For your convenience, I have posted the entire IRC log of the plugin discussion.
Later I will be posting a PDF containing the summary of what was
discussed, and what has been decided as the current "official" plugin
spec.
http://static.thadeusb.com:50002/web2py_plugin_irc_log.txt
-Thadeus
--
Y
ah I didn't know about this new feature - thanks.
However my tables rely on auth, which relies on being passed globals()
containing request, response, and session. Will I need to fake them?
On Mar 10, 11:01 am, Russell wrote:
> You might need to import the DAL?
>
> Fromhttp://groups.google.com
You raise a good point. If the calculations are done database side
then I suppose it is worth the difficulty in syntax.
I just wish the syntax was more natural.
-Thadeus
On Tue, Mar 9, 2010 at 9:54 PM, mdipierro wrote:
> I disagree. In the case you are proposing, the computation would be
>
I disagree. In the case you are proposing, the computation would be
done web2py site since you are fetching all rows.
In the current implementation you can do
s=(db.some_table.amount.sum()
+db.some_table.amount.min())*(db.some_table.amount.max()+3)
row = db(...).select(s).first()
answer = row[s]
Ah, this makes more sense now.
On Mar 9, 9:03 pm, mdipierro wrote:
> s=db.some_table.amount.sum()
> row = db(...).select(s).first()
> answer = row[s]
>
> On Mar 9, 8:23 pm, Thadeus Burgess wrote:
>
> > Is it just me or is this archaic?
>
> > -Thadeus
>
> > On Tue, Mar 9, 2010 at 6:48 PM, Russell
Still doesn't seem natural.
db(...).select().sum(db.table.field) seems much more natural.
rows = db(db.table.id > 0).select(orderby=~db.table.datetimestamp)
total_hours = rows.sum(db.table.hours_worked)
avg_hours = rows.avg(db.table.hours_worked)
Would the actual implementation of this be d
s=db.some_table.amount.sum()
row = db(...).select(s).first()
answer = row[s]
On Mar 9, 8:23 pm, Thadeus Burgess wrote:
> Is it just me or is this archaic?
>
> -Thadeus
>
> On Tue, Mar 9, 2010 at 6:48 PM, Russell wrote:
> > The number is stored in a dictionary called '_extra'. The top part of
>
Yes - plugins, plugins, plugins!!! I'm anxious to start converting all
of my modules to plugins once the spec is somewhat backwards
compatible.
On Mar 9, 8:18 pm, mdipierro wrote:
> We have a meeting on IRC tonight at 10om central time, right?
--
You received this message because you are subscr
It's not just you.
On Mar 9, 8:23 pm, Thadeus Burgess wrote:
> Is it just me or is this archaic?
>
> -Thadeus
>
> On Tue, Mar 9, 2010 at 6:48 PM, Russell wrote:
> > The number is stored in a dictionary called '_extra'. The top part of
> > what you are getting is the dictionary key. Do somethin
Is it just me or is this archaic?
-Thadeus
On Tue, Mar 9, 2010 at 6:48 PM, Russell wrote:
> The number is stored in a dictionary called '_extra'. The top part of
> what you are getting is the dictionary key. Do something like this to
> get just the number...
>
> row = db(...).select(db.som
We have a meeting on IRC tonight at 10om central time, right?
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googleg
Yes I am including the connection string
if request.env.web2py_runtime_gae:
db = DAL('gae')
session.connect(request, response, db=db)
else:
db = DAL('sqlite://storage.sqlite')
because it is working locally with the dev appengine server.
I did notice that it is not creating a session e
Thank you
On Mar 9, 6:39 pm, Igor Gassko wrote:
> Done :-)
>
> http://www.web2pyslices.com/main/slices/take_slice/72
>
> On Mar 10, 1:08 am, Kuba Kucharski wrote:
>
> > could you, please, make a slice with both web2py and flex code?
> > @http://www.web2pyslices.com/
> > it would be useful since
The number is stored in a dictionary called '_extra'. The top part of
what you are getting is the dictionary key. Do something like this to
get just the number...
row = db(...).select(db.some_table.amount.sum())[0]
answer = row.'_extra['SUM(some_table.amount) ']
See pg 169 of the book.
On Mar
rows=db(...).select(db.some_table.amount.sum())
print rows.first()[db.some_table.amount.sum()]
On Mar 9, 6:23 pm, minh wrote:
> I couldn't find much documentation on sum() and I'm not sure how to
> use it.
>
> If I have something like
>
> define_table('some_table',
> Field('amount', 'integer')
Done :-)
http://www.web2pyslices.com/main/slices/take_slice/72
On Mar 10, 1:08 am, Kuba Kucharski wrote:
> could you, please, make a slice with both web2py and flex code?
> @http://www.web2pyslices.com/
> it would be useful since there is a few flex specialists to answer
> these questions here
I couldn't find much documentation on sum() and I'm not sure how to
use it.
If I have something like
define_table('some_table',
Field('amount', 'integer')
...
I try db(...).select(db.some_table.amount.sum())
When I print it out, I get something like:
SUM(some_table.amount)
300
How do I g
You might need to import the DAL?
>From
>http://groups.google.com/group/web2py/browse_thread/thread/159b44bfbb634df2/83751f3fd6e51578
from gluon.sql import DAL, Field
db=DAL('sqlite://storage',folder='/path/to/databases/folder/')
db.define_table()
etc. etc.
On Mar 10, 12:43 pm,
I need to interact with the database from a module and I can't pass db
as an argument. (This is so I can use deferred on GAE:
http://groups.google.com/group/web2py/browse_thread/thread/d9092604580963f8)
Can this be done?
Richard
--
You received this message because you are subscribed to the Goo
Never mind got it.
On Mar 9, 3:33 pm, mikech wrote:
> I'm attempting to log-in to this. It's telling me that my login in is
> invalid. I just registered today, and haven't received an email
> confirming the login info.
>
> Mike
>
> On Mar 9, 7:04 am, dbb wrote:
>
>
>
> > To Web2pyers:
>
> > Ma
I'm attempting to log-in to this. It's telling me that my login in is
invalid. I just registered today, and haven't received an email
confirming the login info.
Mike
On Mar 9, 7:04 am, dbb wrote:
> To Web2pyers:
>
> Massimo has posted a new speedier web2pyHL7, the goal is to certify
> the EHR
could you, please, make a slice with both web2py and flex code? @
http://www.web2pyslices.com/
it would be useful since there is a few flex specialists to answer
these questions here
--
Kuba Kucharski
--
You received this message because you are subscribed to the Google Groups
"web2py-users" g
Case solved.
I used invalid URL, that why request handler didn't recognize the
service call.
Following is the code that works:
rpc.py:
---
from gluon.tools import Service
service = Service(globals())
def call():
session.forget()
return service()
@service.amfrpc3("mydomai
Tried that, the situation remains the same: ticket (and HTTP 500 in
log) when accessing from the browser, no ticket (and HTTP 200 in log)
when calling from Flex.
But now I'm quite sure that the problem is either with my Flex code
(or services-config.xml) or with pyamf. I just wonder if web2py allow
I've debugged Flex for a while and found out that
"Service.ResourceNotFound" comes over from the server.
Since I don't have a clue how to debug web2py, I just dig in pyamf
sources untill I found out that Service.ResourceNotFound is a string
message of UnknownServiceError which is raised in
\pyamf\r
One more test. delete all tickets (errors/*) and see if a new tickets
is generated by the flash request. It may contain some useful info.
massimo
On Mar 9, 3:39 pm, Igor Gassko wrote:
> I embedded it right into the library.zip of web2py by openning .egg
> package and using its pyamf folder. I'm
I embedded it right into the library.zip of web2py by openning .egg
package and using its pyamf folder. I'm quite sure that pyamf is being
imported, because before I did this trick I was getting "no module
named pyamf" error. I also tried using the source version (by
appending it directly to app.pa
I assume you have
db=DLA('gae')
session.connect(request,response,db)
somewhere.
Can you check on GAE console if any session record has been created?
Massimo
On Mar 9, 2:10 pm, stephen wrote:
> Hello,
>
> I am having a problem running my web2py app on GAE. The login form
> seems to not be sett
not sure but:
1) let's concentrate on the first method since that is the new way of
handling this
2) you appear to be using the windows binary distribution of web2py.
that does not come with pyamf and would not see it even if installed.
Could that be the problem? Could you try using the source vers
mdipierro wrote:
If you use archive you should not never delete records. You should
only have an "active" field and filter out the inavtice ones.
Yes, I realise that :)
Further experimentation (while waiting for Gmane to post the message)
after I implemented the small patch revealed that the d
Hello,
I am having a problem running my web2py app on GAE. The login form
seems to not be setting the session for the client. It is working when
i run it locally with the web2py server, and the appengine local dev
server, but not when I run it on GAE.
When running it on GAE in my response var i g
Thats exactly the type of solution I was looking for.
No integration nightmare.
Thanks for the tip :).
On Mar 9, 9:06 am, Timothy Farrell wrote:
> It's never that easy. Magnitus, you can use LightTPD on Windows. I'm
> not sure if it will satisfy the 64-bit requirement though. I've gotten
> w
Hello!
I'm trying to deploy basic connectivity between Flex AS3 application
and web2py server-side. In order to achieve this noble cause I studied
the official tutorial (http://www.web2py.com/AlterEgo/default/show/22)
and the official documentation (http://web2py.com/book/default/section/
9/2).
So
If you use archive you should not never delete records. You should
only have an "active" field and filter out the inavtice ones.
On Mar 8, 11:33 pm, Rowdy wrote:
> Greetings,
>
> I have been playing a little with crud.archive, as advertised by Massimo
> in a post on 13-Feb-2010. It's fantastic :
Kinda like django's stacktraces ?
I have been an advocate for this for a while, yet since I have been
using WingIDE debugger I havn't really needed this.
-Thadeus
On Tue, Mar 9, 2010 at 11:10 AM, Jon Romero wrote:
> I don't think this is a problem.
>
> If I wanted to check the data of db, I
So an option to DAL.__init__(auto_cache=False, clear_cache_on_update=False) ?
auto_cache does an infinity cache time, where if there is any updates
done to the db all cached selects are cleared and alternatively an
option to only clear cached selects that have to do with the table
that is sele
Greetings,
I have been playing a little with crud.archive, as advertised by Massimo
in a post on 13-Feb-2010. It's fantastic :-)
... except when deleting data.
When I try to delete, I get this:
Traceback (most recent call last):
File "/home/rowdy/web2py/gluon/restricted.py", line 173, in re
I don't think this is a problem.
If I wanted to check the data of db, I would use a sqlite viewer (or a
mysql viewer). 99% of cases I just want to
check a variable, sessions or vars/args. I don't want to have a full
blown terminal to experiment.
Just a screen where I can poke around, see what is t
You can already do
cache.ram.clear(db._uri + '/SELECT')
and it will clear all cached select statements. You have to specify
db._uri because you may have multiple db cached.
Massimo
On Mar 9, 10:37 am, Thadeus Burgess wrote:
> What if the cache system includes a "category" or "type" field. All
Problem is that database is closed when the page returns (and rolled
back) so any attempt to use db will result in "database closed". This
is the hard part.
On Mar 9, 10:33 am, Jon Romero wrote:
> On Mar 9, 6:28 pm, mdipierro wrote:
>
> > Let me think about this.
> > We could:
> > 1) save the re
I was reading this and I read:
"web2py does not work well on multiple application environment so you
have to use it as the only WSGI application of the uWSGI server. "
I am not sure I understand the comment.
I think this originates from a misunderstanding and, in fact, the
problem is in the scri
On Mar 9, 6:28 pm, mdipierro wrote:
> Let me think about this.
> We could:
> 1) save the response._environment in ram
> 2) if logged in user is admin allow the user to open a web2py shell in
> the above environment.
Yes!
> the main problem is what do we do with database transactions? when do
>
What if the cache system includes a "category" or "type" field. All
cached SQL could be of type "SQL", and then say responses can be
cached as "RESP". This way if you refresh the cache instead of
clearing the entire thing, we can specify
cache.ram.clear(type="SQL") and it will only clear the sql t
NO.
Your application only becomes GPL if you INCLUDE(ie: distribute) the
DAL with your program, not if it only "USES" the DAL, and the client
has to install web2py themselves.
-Thadeus
On Tue, Mar 9, 2010 at 7:52 AM, Timothy Farrell wrote:
> Also remember that web2py is GPL. So your applic
Let me think about this.
We could:
1) save the response._environment in ram
2) if logged in user is admin allow the user to open a web2py shell in
the above environment.
the main problem is what do we do with database transactions? when do
we close them?
Massimo
On Mar 9, 10:17 am, Jon Romero wr
I've seen that Pylons has an AWESOME debugger.
Every time an error occurs, you have an AJAX console where you can
inspect elements!
This is waaay more useful than tickets (at least on development)
where you click a ticket, go to the new page, read the error, do a
print in your code so you can
You can do that if after insert/update/delete you do
db(...).select(cache=(cache.disk,0))
Massimo
On Mar 9, 9:06 am, Praneeth wrote:
> Would it be better to have a non time based caching? Say refresh cache
> on DB update?
> Time based caching requires guessing the cache time - which in my
> opi
Hello,
just started with web2py and looking for some advice how to use Gdata
apis with web2py.
How to include the gdata apis and what would be the best place to
initialize them as needed.
Thanks
Siegfried
--
You received this message because you are subscribed to the Google Groups
"web2py-user
no problem seeing it here.
Thanks,
Richard Shebora
On Tue, Mar 9, 2010 at 9:57 AM, Thadeus Burgess wrote:
> Has been working for me.
>
> -Thadeus
>
>
>
>
>
> On Tue, Mar 9, 2010 at 3:47 AM, Jason Brower wrote:
>> Works for me (:
>> On Tue, 2010-03-09 at 00:18 -0800, Sky wrote:
>>> as I see web2
nice
On Mar 9, 4:57 am, selecta wrote:
> Hi there,
> I had the idea of creating a table wizard but after creating part of
> it I realized that I will not need it after all. It is unfinished and
> does not actually do much beyond showing the source code and the table
> form. Lots of things to not
Has been working for me.
-Thadeus
On Tue, Mar 9, 2010 at 3:47 AM, Jason Brower wrote:
> Works for me (:
> On Tue, 2010-03-09 at 00:18 -0800, Sky wrote:
>> as I see web2py.com is down since 2 days ago.
>> is there any body to inform the site administrator ???
>>
>
>
> --
> You received this m
You are running from source and did not install Mark Mahmmond win32
extensions.
On Mar 9, 1:08 am, Debebe Asefa wrote:
> Why the following error messages:
>
> Microsoft Windows [Version 6.0.6002]
> Copyright (c) 2006 Microsoft Corporation. All rights reserved.
> C:\Users\User>cd ..
> C:\Users>cd
response.headers['web2py-component-command']
='web2py_ajax_page("GET","%s","","table_code");web2py_ajax_page("GET","%s","","table_details");'
%
(URL(r=request,f='table_code',args=[table_id]),URL(r=request,f='table',args=[table_id]))
On Mar 9, 4:24 am, selecta wrote:
> in my controller I got
>
> r
It's never that easy. Magnitus, you can use LightTPD on Windows. I'm
not sure if it will satisfy the 64-bit requirement though. I've gotten
web2py working through FastCGI on LightTPD on windows. Because web2py
runs as a separate process, it can be 64-bit while Lighttpd runs
32-bit. Since L
It is there already.
values=db(...).select(cache=(cache.disk,3600))
3600 is the time.
On Mar 9, 5:23 am, Praneeth wrote:
> Hello all,
>
> I was wondering if DAL level caching could be added. I am aware of
> cache.ram and cache.disk, but these require the usage of a decorator
> over the function
I did, but apparently "soft" restart doesn't work. When I closed the
process, everything started working.
Thanks!
On Mar 9, 2:30 am, "mr.freeze" wrote:
> Your route works for me. Did you restart the server?
>
> On Mar 8, 3:14 pm, iggass wrote:
>
>
>
> > Hello,
>
> > I'm running web2py (v1.76.1 o
They did work after I had restarted the server, no problem with that.
I wonder if there is any clean way to expose static resources which
don't belong to any particular application? Some sort of "root" static
folder...
On Mar 9, 1:53 am, stephen wrote:
> Hello iggass,
>
> The snippets of code you
On Mar 8, 10:31 pm, mdipierro wrote:
> Why do we need a grid system again? Why does this belong to web2py? I
> am not convinced.
I didn't know that you previously had a grid and I agree that divs are
not so easy and tables are more predictable and reliable. However,
tables will seldom be chosen
Yes, the application is based on HL7 ( health level 7 ) protocol which
is embrassed by HHS. The application can be created as follows:
- how to create the binary codes
Download web2py binary
Unzip it (do not run it)
Under applications create a folder "init"
Copy the web2pyhl7 app under "init" so
Also remember that web2py is GPL. So your application becomes GPL (if
it wasn't already) by importing the DAL.
-tim
On 3/5/2010 1:34 PM, compassiontara wrote:
On Mar 5, 6:17 am, mdipierro wrote:
On Mar 5, 1:33 am, compassiontara wrote:
I'll probably get flamed for talking about
I thought I did fix that and I added you to the whitelist. I will take
a second look.
Massimo
On Mar 9, 9:10 am, "mr.freeze" wrote:
> Massimo, my IP is still blocked too. You should have it in email with
> the iptables command to whitelist it :)
>
> On Mar 9, 9:07 am, mdipierro wrote:
>
> > It
I guess I could use gql directly to access the database, but I would
prefer to have a single syntax for accessing the database.
(controller of model -> controller or model)
On Mar 9, 10:25 pm, Richard wrote:
> Actually it seems only module functions can be deferred. If I try
> deferring a contr
Yes, there are access limitaions due to HIPAA and other rules and
regulations, a patient record can be accessed only for meaningful use,
i.e., to treat the patient and the record is confidential.
On Mar 8, 10:28 am, Wes James wrote:
> on another thread it looks like you need to register as a doct
Massimo, my IP is still blocked too. You should have it in email with
the iptables command to whitelist it :)
On Mar 9, 9:07 am, mdipierro wrote:
> It not down but I may be blocking your IP.
> I have a script that blocks lot of IP if it thinks there is a denial
> of service attack of a directory
Hi there,
I had the idea of creating a table wizard but after creating part of
it I realized that I will not need it after all. It is unfinished and
does not actually do much beyond showing the source code and the table
form. Lots of things to not work e.g. validators
Maybe it is helpful for peopl
Hello all,
I was wondering if DAL level caching could be added. I am aware of
cache.ram and cache.disk, but these require the usage of a decorator
over the functions. I feel that a cache option to cache at the DAL level
that could be enabled by flipping an option in db.py of an application
would b
Actually it seems only module functions can be deferred. If I try
deferring a controller of model function then I get this error:
PicklingError: Can't pickle : it's not
found as __main__.test
However I need my deferred function to interact with the database. Any
ideas??
On Mar 8, 3:44 pm, Richa
Massimo :
Can you create along side the web2py code , the binary for download by
users, with its own version number.
or in a separate web site www.web2pyhl7.com, do we need to register
the URL or get it from google.
On Mar 9, 10:00 am, mdipierro wrote:
> You are running from source and did not
It not down but I may be blocking your IP.
I have a script that blocks lot of IP if it thinks there is a denial
of service attack of a directory traversal attack.
What is your ip?
Massimo
On Mar 9, 2:18 am, Sky wrote:
> as I see web2py.com is down since 2 days ago.
> is there any body to inform
Would it be better to have a non time based caching? Say refresh cache
on DB update?
Time based caching requires guessing the cache time - which in my
opinion seems like a bad thing to do.
Thoughts?
--
Praneeth
On 03/09/2010 08:33 PM, mdipierro wrote:
> It is there already.
>
> values=db(...).se
No but you can make a dummy app with only static files.
On Mar 9, 6:49 am, iggass wrote:
> They did work after I had restarted the server, no problem with that.
> I wonder if there is any clean way to expose static resources which
> don't belong to any particular application? Some sort of "root"
To Web2pyers:
Massimo has posted a new speedier web2pyHL7, the goal is to certify
the EHR ( EMR) as show by the demo, you can help in many ways, such
as, :
- read the specification for certification at
http://xw2k.nist.gov/healthcare/use_testing/under_development.html
and test the software sugges
in my controller I got
response.headers['web2py-component-command'] =
'web2py_ajax_page("GET","%s","","table_code")' %
URL(r=request,f='table_code',args=[table_id])
But now I want to update two components. The following does not work
response.headers['web2py-component-command'] =
'web2py_ajax_pa
Works for me (:
On Tue, 2010-03-09 at 00:18 -0800, Sky wrote:
> as I see web2py.com is down since 2 days ago.
> is there any body to inform the site administrator ???
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, se
Also is working for me...
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit t
I see web2py.com responding nicely... maybe something is blocking it
for you?
have a try at http://68.169.39.35/
Or try nslookup on web2py.com to see if your DNS server returns
something valid.
On Mar 9, 2:18 am, Sky wrote:
> as I see web2py.com is down since 2 days ago.
> is there any body t
as I see web2py.com is down since 2 days ago.
is there any body to inform the site administrator ???
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, se
77 matches
Mail list logo
