[web2py] Invalid boundary in multipart form?

2010-05-05 Thread vince
i am trying to implement the html5 multiple file upload with progress http://webreflection.blogspot.com/2009/03/safari-4-multiple-upload-with-progress.html to web2py, it comes with example on php. but i run into some parsing error from python's cgi library. is it possible to turn off auto variable

[web2py] Re: new dal

2010-02-23 Thread vince
seems to be working fine on 1.75.4. so are we getting support of nosql database soon =) On Feb 6, 12:14 am, mdipierro wrote: > I encourage eveybody running from source to try the newdal: > > cd gluon > cp sql.py sql.py.bak > cpdal.py sal.py > > and restart web2py. > Let me know what works or doe

[web2py] any quick workaround for the datetime strftime() methods require year >= 1900

2010-02-25 Thread vince
i run into some rare problem on web2py it's related to python's limitation/bugs Traceback (most recent call last): File "/Library/WebServer/Documents/web2py/gluon/restricted.py", line 173, in restricted exec ccode in environment File "/Library/WebServer/Documents/web2py/applications/cychur

[web2py] Re: any quick workaround for the datetime strftime() methods require year >= 1900

2010-02-25 Thread vince
y',str(d.year)[-2:]) >      if d.year>=0: >          format = format.replace('%Y',str(d.year)) >      else: >          format = format.replace('%Y',str(d.year)+'B.C.') >      d = > datetime.datetime(2000,d.month,d.day,d.hour,d.minute,d.second) &g

[web2py] Re: any quick workaround for the datetime strftime() methods require year >= 1900

2010-02-25 Thread vince
it's just osx and windows problem since i've just google it. it's a known problem on python. ValueError: year=1897 is before 1900; the datetime strftime() methods require year >= 1900 On Feb 26, 1:20 pm, mdipierro wrote: > No it work for every date but just B.C. > >

[web2py] Re: any quick workaround for the datetime strftime() methods require year >= 1900

2010-02-25 Thread vince
ohoh! you are the man... that was quick! yes i tried and it just work! On Feb 26, 1:32 pm, mdipierro wrote: > I tried. It does not work for year<=0 but works otherwise. It is now > in trunk. Nothing for you to do. Just upgrade and retry your code. > Should work. > > On Feb 2

[web2py] database is locked

2010-03-04 Thread vince
i always got the error on 1.75.5. i am upgrading to 1.76.3 and see how it goes. i am using sqlite and it's not for heavy usage, is it suppose to be delay instead of return error when the db file is locked? File "/home/web2py/gluon/sql.py", line 3042, in select rows = response(query) Fil

[web2py] Re: database is locked

2010-03-04 Thread vince
here's some more errorlog just fyi. actually it's easy to reproduce when opening page with lots of image needs to be download via web2py Traceback (most recent call last): File "/home/web2py/gluon/main.py", line 488, in wsgibase session._try_store_in_db(request, response) File "/home/web2

[web2py] Re: database is locked

2010-03-04 Thread vince
files although migrate=False can fix it. On Mar 5, 5:50 am, Thadeus Burgess wrote: > Vince has had this problem in the past, and it was due to the .table > files being locked, he solved it by setting migrate=False. > > Has he forgotten about this? > > I just did a quick search on

[web2py] sqlite timeout setting?

2010-03-17 Thread vince
m with for eg. mysql, but i still want to know is there any way to catch the error if mysql server is down? -vince -- 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 uns

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread vince
have a default timeout of 5 seconds. i think it should be able to catch the error when the database file is locked, for other sql database we should be able to catch the error too when the sql server is down. -vince On Mar 17, 10:39 pm, mdipierro wrote: > What error do you get? What trigge

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread vince
> a concurrency issue. Do you use the thread module explicitly or > multiprocessing or background processes? Can you post a minimalist app > that allows to reproduce the problem? If not can you tells us a little > more about the application? > > On Mar 17, 7:51 pm, vince wrote: > &g

[web2py] Re: sqlite timeout setting?

2010-03-17 Thread vince
thread? > > On Mar 17, 10:15 pm, vince wrote: > > > mutliprocess yes. i am running under mod_wsgi with single thread but > > multi process. > > > i do assume the sqlite driver should try to acquire the database file > > lock for a specific time instead of return

[web2py] upgraded to 1.83.2 with db table file appears corrupted

2010-09-01 Thread vince
upgraded to 1.83.2, the application itself run fine just with this error keeps appearing in error log. is there any way to regenerate the db table file? Traceback (most recent call last): File "gluon/restricted.py", line 186, in restricted exec ccode in environment File "/home/web2py/appl

[web2py] upgraded to 1.83.2 with db table file appears corrupted

2010-09-01 Thread vince
upgraded to 1.83.2, the application itself run fine just with this error appearing in error log sometimes. is there any way to regenerate the db table file? Traceback (most recent call last): File "gluon/restricted.py", line 186, in restricted exec ccode in environment File "/home/web2py/

[web2py] Re: upgraded to 1.83.2 with db table file appears corrupted

2010-09-01 Thread vince
since it's the auth's table i do not know how to do fake_migrate. however it seems to be file locking seems. after auth.define_tables(migrate=False), the error seems to be gone. On Sep 2, 1:55 am, mdipierro wrote: > yes. db.define_table(...,fake_migrate=True) > > On Sep

[web2py] Re: upgraded to 1.83.2 with db table file appears corrupted

2010-09-02 Thread vince
his happen in the first place? > > > > Thanks! > > > Jeff > > > > On Sep 1, 10:55 am, mdipierro wrote: > > > > > yes. db.define_table(...,fake_migrate=True) > > > > > On Sep 1, 12:11 pm, vince wrote: > > > > >

[web2py] problem of is_in_db multiple on 1.83.2

2010-09-07 Thread vince
after upgraded to 1.83.2, sqlform of is_in_db multiple no longer highlight the previous selected items from db.

[web2py] problem of is_in_db multiple on 1.83.2

2010-09-07 Thread vince
after upgraded to 1.83.2, sqlform of is_in_db multiple no longer highlight the previous selected items from db.

[web2py] Re: problem of is_in_db multiple on 1.83.2

2010-09-07 Thread vince
ello Massimo, > > > This problem looks the same as mine!! > > > Richard > > > 2010/9/7 vince > > > > after upgraded to 1.83.2,  sqlform of is_in_db multiple no longer > > > highlight the previous selected items from db.

[web2py] dal form of SQL SELECT IN?

2010-09-07 Thread vince
been searching on the document, i can only find the reverse form of SQL SELECT IN, contains. do dal have SELECT IN?

[web2py] strange problem on auth.requires_login with 1.85.3

2010-09-21 Thread vince
upgraded to 1.85.3, was using 1.83 or something like that (can't remember) only one of our server experience the problem with auth.requires_login sometimes return false and send user back to login page. for the problem server, it only occur with https, http connect is fine. this problem is very

[web2py] Re: strange problem on auth.requires_login with 1.85.3

2010-09-22 Thread vince
o not believe this is an upgrade issue anyhow. > > On Sep 22, 12:22 am, vince wrote: > > > > > upgraded to 1.85.3, was using 1.83 or something like that (can't > > remember) > > > only one of our server experience the problem with auth.requires_login >

[web2py] upgrade web2py now in admin page can't upgrade to 1.86.3

2010-10-09 Thread vince
upgrade web2py now in admin page can only upgrade to 1.86.2, can't upgrade to 1.86.3.

[web2py:34674] Re: problem with 1.71.2

2009-11-05 Thread vince
oh yes it's working without cache. vince On Nov 6, 2:19 am, mdipierro wrote: > There is good code here. Can you help me debug this? > can you try remove cache=(...) in validators? > Feel free to email me personally and we'll post the fix when done. > > Massimo >

[web2py:34677] Re: problem with 1.71.2

2009-11-05 Thread vince
thanks for your quick fix! vince On Nov 6, 2:42 am, mdipierro wrote: > I found the problem. > > There is, there always was, a bug in cache.ram. It was caching the > original object, not a copy, so if the object gets modified the one in > cache changes too. > > This b

[web2py:34678] Re: Join web2py wave

2009-11-05 Thread vince
yes pls On Nov 5, 8:22 pm, Markus Gritsch wrote: > Hi, > > it would be nice if you (or someone else) could send me an invitation, > too. > > Thanks, Markus --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-use

[web2py:34676] Re: js minification

2009-11-05 Thread vince
i do think it's a good idea if web2py will also do jsmin during compile. vince On Nov 5, 10:59 pm, vihang wrote: > If not part of web2py, then It would be a superb plugin. Maybe it > could be looked at as a candidate for 'must have' plugins. I was > looking for one mys

[web2py:36060] Re: expire login when browser closes

2009-11-26 Thread vince
it will expire when browser close on firefox/safari. however, if you just close the tab the session won't expire. is there any workaround for this problem? -vince On Nov 20, 3:14 am, mdipierro wrote: > This expiration is handled at the web2py level. Thesessioncookie > used

[web2py:36080] gae and nosql

2009-11-27 Thread vince
i've notice the new DAL do support a form of LIKE on GAE. anyone tried it and how's the performance? it seems to only support "startwith", what about "contain"? is there any experimental nosql database i can play with now besides GAE? -vince -- You receive

[web2py:36171] request.args and error handling

2009-11-29 Thread vince
i've been doing lots of error handling with request.args. is that possible to have request.args[index] to return None instead of "index out of range" exception? -vince -- You received this message because you are subscribed to the Google Groups "web2py-users" gro

[web2py:36980] Re: request.args and error handling

2009-12-10 Thread vince
oh thanks a lot. On Nov 30, 12:34 am, mdipierro wrote: > request.args(index) > > On Nov 29, 10:05 am, vince wrote: > > > i've been doing lots of error handling with request.args. is that > > possible to have request.args[index] to return None instead of "

[web2py:37483] calling dal from python and transaction

2009-12-17 Thread vince
from gluon.sql import * db=DAL('sqlite://test.db') db.define_table('test', db.Field('subject'), db.Field('num','integer',default=0), ) db.test.insert(subject="sub",num="1") db.test.insert(subject="sub",num="2") db.test.insert(subject="sub",num="3") if run this python script, all the

[web2py:37584] blob and binary

2009-12-20 Thread vince
i need to read and write blob from sqlite in order to work with others program. i can manually encode the blob with base64 if i read it but is there anyway for dal to write blob in binary format? -vinc -- You received this message because you are subscribed to the Google Groups "web2py-users"

[web2py] EOFError?

2010-01-22 Thread vince
i just look into the error log for some clean up and found several ticket with the following errors. i am using 1.74.6, any ideas? Traceback (most recent call last): File "/Library/WebServer/Documents/web2py/gluon/restricted.py", line 173, in restricted exec ccode in environment File "/Li

[web2py] Re: EOFError?

2010-01-24 Thread vince
actually the application is running fine, the weird thing is there are few error log of this EOFError. i can't figure out when did it occur, i'll keep you update if i can sort it out. -vince On Jan 23, 6:36 am, mdipierro wrote: > Are you using the web2py binary or source? > Did

[web2py] Re: EOFError?

2010-01-24 Thread vince
On Jan 22, 2:13 pm, Thadeus Burgess wrote: > > > > looks like a corrupted .table file > > > -Thadeus > > > > On Fri, Jan 22, 2010 at 1:18 PM, vince wrote: > > > > i just look into the error log for some clean up and found several > > > > ticket wit

[web2py] Re: EOFError?

2010-01-24 Thread vince
issue > 3) there are some .table files in you databases folder that were > created by a different python dictribution > > On Jan 24, 10:16 am, vince wrote: > > > i am running from source on linux and mac. > > > On Jan 23, 6:36 am, mdipierro wrote: > > > > A

[web2py] Re: EOFError?

2010-01-24 Thread vince
)" for all tables. > > In any case. Make a backup of the .tables before you delete them. In > theory, if you lose them it is always possible to rebuild them (they > are just picked files. > Massimo > > On Jan 24, 10:54 am, vince wrote: > > > i just double check

[web2py] Re: EOFError?

2010-01-24 Thread vince
i can't sort out how to reproduce it anyway, it's not happening everytime i add a field. i'll see if the clean up of .table works On Jan 25, 2:58 am, vince wrote: > i just did some test and the error seems to appear  when i modify the > table definition, eg add a new fi

[web2py] Re: EOFError?

2010-01-24 Thread vince
oh that's why. thank for the info. On Jan 25, 3:24 am, mdipierro wrote: > You can have a problem with sqlite if you remove a field and you add > it again with the same name. > > This is because sqlite does not support ALTER TABLE ... DROP. > > Massimo > > On

[web2py] Re: Mac Apache

2010-01-24 Thread vince
just compile your own version of mod_wsgi On Jan 24, 2:42 am, pistacchio wrote: > Has anyone succesfully run web2py under Mac OSX apache? Any guide? > Thanks. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to

[web2py] Re: EOFError?

2010-01-24 Thread vince
BLE ... DROP. > > Massimo > > On Jan 24, 1:21 pm, vince wrote: > > > > > i can't sort out how to reproduce it anyway, it's not happening > > everytime i add a field. i'll see if the clean up of .table works > > > On Jan 25, 2:58 am, vince wrot

[web2py] Re: EOFError?

2010-01-25 Thread vince
x this for sure. i suggest error ticket should record the url as well as cookie data too for debug purpose. -vince On Jan 25, 3:24 am, mdipierro wrote: > You can have a problem with sqlite if you remove a field and you add > it again with the same name. > > This is because sqlite

[web2py:12660] Re: ... and you can run *some* SQLALchemy models in web2py

2008-11-29 Thread vince
i am a sqlalchemy user and i think most of us are using object mapping instead. i've been using pylons but really tried of the lack of document, and i really enjoy the all in one package advantage in web2py. will web2py give us an option to use sqlalchemy instead of web2py's DAL soon? -vinc On

[web2py:12661] Re: ... and you can run *some* SQLALchemy models in web2py

2008-11-29 Thread vince
i am a SQLAlchemy user and i think most of us are using its object- relational mapping instead. i've been using pylons but tried of its lack of document and really enjoy the idea of "all in one package" in web2py. will web2py give us an option to use SQLAlchemy instead of its own DAL? -vinc On 1

[web2py:13567] Re: t3 on launchpad, t2 will die

2008-12-15 Thread vince
eb2py. vince On Dec 15, 2:01 pm, mdipierro wrote: > This is what I meant. t2 is contained and will be contained in t3. > > On Dec 14, 4:11 pm, ceej wrote: > > > I like the idea of t3 but I also really like the idea of t2, I feel t2 > > should be separate from t3 and the

[web2py:13597] possible bug in T.current_languages

2008-12-15 Thread vince
T.current_languages['en'] doesn't work as expected however, when i edit gluon/languages.py and change self.current_languages = ['en'] it works. my current workaround is to put a en.py file inside language directory with just "()" -vince --~--~-~--~---

[web2py:13599] Re: possible bug in T.current_languages

2008-12-15 Thread vince
yes as described in the manual i declare T.current_language=['en'] in models. but it didn't work, but editing the self.current_language=['en'] directly inside gluon works. or i have to declare it elsewhere? i expect it should be fine to declare inside models or contr

[web2py:13602] Re: possible bug in T.current_languages

2008-12-15 Thread vince
de but i have no clue too.. T.force('en') works fine but what i want is to set the default language and T.current_languages doesn't work for some result. -vince On Dec 16, 1:35 pm, mdipierro wrote: > odd. can you try > > T.append('en') > > Massimo > > On

[web2py:13606] Re: possible bug in T.current_languages

2008-12-15 Thread vince
oh i actually figured it out, it has to be T.current_language=['en'] T.force(request.env.http_accept_language) it works. -vince On 12月16日, 下午2时00分, mdipierro wrote: > Can I see your app? You can email it to me privately. > > Massimo > > On Dec 15, 11:45 pm, vince

[web2py:13608] Re: possible bug in T.current_languages

2008-12-15 Thread vince
i propose this patch to make it cleaner to set current languages. -vince gluon/languages.py 57a58,61 > self.http_accept_language = request.env.http_accept_language > def set_current_languages(self,languages): > self.current_languages=languages > self.for

[web2py:13669] Re: possible bug in T.current_languages

2008-12-16 Thread vince
will that introduce performance impact since it should have hundreds T () call for each page? i understand it's better to keep the api compatible. or maybe it's good time to change the api when no one notice this problem yet? -vince On Dec 16, 4:21 pm, mdipierro wrote: > correcti

[web2py:13715] is that possible to requires IS_DATE or None/Empty?

2008-12-16 Thread vince
is that possible to define a SQLField as date so it is either empty or a valid IS_DATE format? -vince --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group,

[web2py:13717] Re: is that possible to requires IS_DATE or None/Empty?

2008-12-17 Thread vince
oh thanks a lots. i didn't notice there is a IS_NULL_OR -vince On Dec 17, 4:10 pm, mdipierro wrote: > requires=IS_NULL_OR(IS_DATE('%Y-%m-%d',error_message='must be empty or > iso date')) > > On Dec 17, 1:56 am, vince wrote: > > > is that possibl

[web2py:13782] mod_wsgi deployment question

2008-12-17 Thread vince
i have set the Alias the WSGIScriptAlias will be ignore. anyone have the solution to have all the static page skip mod_wsgi? thanks in advance vince here's my config ServerName 10.10.10.2 ### alias the location of applications (for static files) #Alias / /home/web2

[web2py:13790] Re: mod_wsgi deployment question

2008-12-18 Thread vince
thanks your config works fine. but those files under static still serving by web2py. -vince On Dec 18, 3:48 pm, Johanm wrote: > I got some help with this a week or so ago. I found the manual to be > more confusing than > helpful.http://groups.google.com/group/web2py/browse_thre

[web2py:13957] Re: To know IP Address of client

2008-12-20 Thread vince
request.client On Dec 21, 7:52 am, "Phyo Arkar" wrote: > AHH no no this . it is just server ip:port .. how can i find browser > client's IP ? > > On Sat, Dec 20, 2008 at 11:49 PM, Phyo Arkar wrote: > > > Got it , it is > > > request.env.http_host > > > Where can i find all the properties of Requ

[web2py:13958] Re: Performance tips

2008-12-20 Thread vince
shouldn't have any problem at all even if you just using reverse proxy via apache. maybe you can try mod_wsgi. -vince On Dec 21, 5:47 am, voltron wrote: > I am having serious performance problems with an appliance. I have 2 > instances of web2py being served by reverse proxy via

[web2py:13965] Re: Performance tips

2008-12-21 Thread vince
and i think that can be fix easy by caching the sqlform result and replace it. oh yeah one question. web2py's DAL is non-lazy query right? -vince > @vince > do you have any data we can use to compare web2py to other frameworks? > > Massimo > --~--~-~--~~

[web2py:13980] Re: Performance tips

2008-12-21 Thread vince
ons'): opts=[] for k,v in field.requires.options(): opts.append(OPTION(v,_value=k)) can you show me some lights where is the actual select query. in some cases if i have many field that is joining the same table it will have over a second delay on just the SQLFORM function. -vin

[web2py:13984] Re: Performance tips

2008-12-21 Thread vince
oh thx i got it. can i propose a quick patch to add an optional argument to SQLFORM for passing the cache option to IS_IN_DB.options? -vince On Dec 22, 2:11 am, mdipierro wrote: > good point. the select is in gluon/validators.py right now there is no > option cache it. > > Massim

[web2py:13987] Re: Performance tips

2008-12-21 Thread vince
wrote: > try the latest trunk IS_IN_DB(...cache=(cache.ram,3600)) > > On Dec 21, 12:39 pm, vince wrote: > > > oh thx i got it. > > > can i propose a quick patch to add an optional argument to SQLFORM for > > passing the cache option to IS_IN_DB.options? > &

[web2py:13988] Re: Performance tips

2008-12-21 Thread vince
also is it possible to enable logging for all SQL query execution? On Dec 22, 6:30 am, mdipierro wrote: > try the latest trunk IS_IN_DB(...cache=(cache.ram,3600)) > > On Dec 21, 12:39 pm, vince wrote: > > > oh thx i got it. > > > can i propose a quick patch to

[web2py:13990] simple benchmark

2008-12-21 Thread vince
i've done a simple benchmark between pylons and web2py both testing page have one single query one inherit template pylons: use the quickwiki demo, sqlite sqlalchemy mako web2py: made a similiar wiki using sqlite web2py: This is ApacheBench, Version 2.3 <$Revision: 655654 $> Copyright 1996

[web2py:13991] Re: simple benchmark

2008-12-21 Thread vince
another one with totally identical setup web2py: model: --- db=SQLDB('sqlite://storage.db') db.define_table('page', SQLField('title'), SQLField('body','text')) --- controller --- def index(): mypages=db().select (db.page.id,db.page.title,orderby=db.page.title) return d

[web2py:13992] Re: simple benchmark

2008-12-21 Thread vince
another one with totally identical setup web2py: model: --- db=SQLDB('sqlite://storage.db') db.define_table('page', SQLField('title'), SQLField('body','text')) --- controller --- def index(): mypages=db().select (db.page.id,db.page.title,orderby=db.page.title) return d

[web2py:13999] Re: Performance tips

2008-12-22 Thread vince
db._lastsql only record the last sql query right? is that any easy way to log all the sql query it's executing to a file like sql.log does for table update? i think it's really useful for preference fine tune. -vince On Dec 22, 4:26 pm, mdipierro wrote: > Will think about i

[web2py:14001] Re: simple benchmark

2008-12-22 Thread vince
oh actually pylons one was compiled as when it's running under mod_wsgi u need to touch the wsgihandler or it will use pyc directly. i don't think packing pylons project into compiled egg will increase performance. compiled version, stock centos5.2 x86_64, python2.5.2 and mod_wsgi 2.3 (self comp

[web2py:14002] Re: simple benchmark

2008-12-22 Thread vince
oh actually pylons one was compiled as when it's running under mod_wsgi u need to touch the wsgihandler or it will use pyc directly. i don't think packing pylons project into compiled egg will increase performance. compiled version, stock centos5.2 x86_64, python2.5.2 and mod_wsgi 2.3 (self compi

[web2py:14004] Re: simple benchmark

2008-12-22 Thread vince
ab -c 5 -n 500 web2py Server Software:Apache/2.2.3 Server Hostname:10.8.8.18 Server Port:80 Document Path: /welcometest/wiki Document Length:895 bytes Concurrency Level: 5 Time taken for tests: 22.284 seconds Complete requests: 500 Faile

[web2py:14005] Re: simple benchmark

2008-12-22 Thread vince
ab -c 10 -n 500 web2py Server Software:Apache/2.2.3 Server Hostname:10.8.8.18 Server Port:80 Document Path: /welcometest/wiki Document Length:895 bytes Concurrency Level: 10 Time taken for tests: 22.178 seconds Complete requests: 500 Fai

[web2py:14009] Re: simple benchmark

2008-12-22 Thread vince
sure will do. -vince On Dec 22, 5:50 pm, mdipierro wrote: > Bottom line: we are +50% faster (22-23 rq/sec vs 15-18)! > > Thank you vince. > > Would you add an entry in thehttp://mdp.cti.depaul.edu/web2py_wiki > summarzing your results and posting sample code? > > Massim

[web2py:14008] Re: Performance tips

2008-12-22 Thread vince
ime.time() >       f() >       t0=time.time()-t0 >       gluon.portalocker,unlock(myfile) >       myfile.wriite('%s: %s\n' % (t0,db._lastsql) > db._execute=lambda *a,**b: timer(db,lambda:db._execute(*a,**b)) > > On Dec 22, 2:54 am, vince wrote: > > > db._lastsq

[web2py:14032] Re: Performance tips

2008-12-22 Thread vince
lambda *a,**b: timer(db,lambda:db._execute(*a,**b)) and the output locking pre f() locking -vince On Dec 22, 6:20 pm, mdipierro wrote: > grr > > db['_execute']=lambda *a,**b: timer(db,lambda:db._execute(*a,**b)) > > On Dec 22, 4:17 am, vince wrote: > >

[web2py:14034] Re: simple benchmark

2008-12-22 Thread vince
mod_wsgi on apache doing quite well. i'll sure take a look it. -vince On Dec 22, 6:26 pm, mmstud wrote: > Have you ever considered using libevent based server (FAPWS2)? I > realized the excellence of libevent (what comes to performance and > concurrency) year or so ago and t

[web2py:14035] Re: Performance revisited

2008-12-22 Thread vince
you'll have to provide more details if u need help from us. 1500 users a day can do well even without any caching you'll have to figure out where is the bottleneck first. use a simple import time t0 = time.clock() some code t0 = time.clock-t0 print t0 can help you debug your problem On Dec 22

[web2py:14042] Re: Performance tips

2008-12-22 Thread vince
b,lambda:f (*a,**b)) TypeError: 'str' object is not callable On Dec 23, 2:39 am, mdipierro wrote: > try this > > db['_execute']=lambda f=db._execute,*a,**b: timer(db,lambda:f(*a,**b)) > > On Dec 22, 9:50 am, vince wrote: > > > it freezed and i

[web2py:14067] Re: Performance tips

2008-12-23 Thread vince
church/models/db.py", line 255, in db['_execute']=lambda f=db._execute,*a,**b: timer(db,lambda:f (*a,**b)) TypeError: 'str' object is not callable -vince On Dec 23, 9:41 pm, mdipierro wrote: > in latest trunk, _lastsql on GAE is a string but only says &quo

[web2py:14238] sqlrow to json again

2008-12-29 Thread vince
http://groups.google.com/group/web2py/browse_thread/thread/8e3e33879974663f/64f76c562366aec4?lnk=gst&q=json#64f76c562366aec4 will it be added or we'll have to wait? i think it's hard to avoid all dependency contrib / thirdparty package. as long as it's include i think th

[web2py:14239] Re: reportlab in web2py?

2008-12-29 Thread vince
i think pdf generation is necessary but the size may affect those user who do not need it. any convenient way to include reportlab to web2py right now? (at least compatible on win32/osx and linux) -vince On Dec 27, 12:20 am, mdipierro wrote: > There is a problem with makingreportla

[web2py:14240] Re: open source organization again

2008-12-29 Thread vince
i think that's really necessary for web2py. without anyone providing business support, cooperate won't trust web2py! vince On Dec 28, 3:18 am, mdipierro wrote: > Some of you may remember previous threads on creating an organization > to support web2py adoption and provide bus

[web2py:14273] bug on devel trunk revision 320

2008-12-29 Thread vince
Traceback (most recent call last): File "gluon/restricted.py", line 62, in restricted exec ccode in environment File "/home/web2py/applications/cychurch/controllers/appadmin.py", line 209, in File "gluon/globals.py", line 55, in self._caller=lambda f: f() File "/home/web2py/appli

[web2py:14281] Re: bug on devel trunk revision 320

2008-12-29 Thread vince
) db.members.name.requires=IS_IN_DB(db,'name_list.name') On Dec 30, 4:24 am, vince wrote: > Traceback (most recent call last): >   File "gluon/restricted.py", line 62, in restricted >     exec ccode in environment >   File "/home/web2py/applications/cychurc

[web2py:14284] Re: bug on devel trunk revision 320

2008-12-29 Thread vince
> > this says the foreign key (a 'name_list.id')  must be in the table name_list > in a string field, 'name'. > > This is why you get an error - you are checking a foreign key (an integer) > against a string. > > oh so the case is IS_IN_D

[web2py:14286] Re: bug on devel trunk revision 320

2008-12-29 Thread vince
thanks. it's my mistake that IS_IN_DB should not work this way. since i need the field holding the name instead of the id, i'll sort out other solution for it. -vince On Dec 30, 6:14 am, "Yarko Tymciurak" wrote: > If what you want is a form which will list the names

[web2py:14288] sqlform formname question

2008-12-29 Thread vince
,formname="form2") form2=SQLFORM(db.products,thisrecord,_formname="form2") form2.element(_formname="form2") form2.element(formname="form2") doesn't work too. anyone have the way to set formname to SQLFORM? thanks in advance -vince --~--~-~--~~--

[web2py:14293] Re: Many-to-Many widgets

2008-12-29 Thread vince
http://groups.google.com/group/web2py/browse_thread/thread/29655ebffb97d7ac/c8dcc5e5ed3c7ea5 this is a simple one. maybe you can base on this widget and workout something. -vince On Dec 30, 4:39 am, Fran wrote: > I agree with this thread that a good method for handling the 80% case >

[web2py:14294] how to do dal not like?

2008-12-29 Thread vince
anyway to do sql not like? db(!(db.members.name.like('%a%'))).select() or something like that? anyone like the syntax to do not? -vince --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web F

[web2py:14297] Re: how to do dal not like?

2008-12-30 Thread vince
oh thanks alot. i was searching for this NOT operator on the manual for long! -vince On Dec 30, 3:56 pm, "Yarko Tymciurak" wrote: > On Tue, Dec 30, 2008 at 1:34 AM, vince wrote: > > > anyway to do sql not like? > > db(!(db.members.name.like('%a%'))).se

[web2py:14308] Re: Many-to-Many widgets

2008-12-30 Thread vince
at's no good for you if you're looking for hundreds of entries -vinc On Dec 30, 7:43 pm, Fran wrote: > On Dec 30, 5:59 am, vince wrote: > > >http://groups.google.com/group/web2py/browse_thread/thread/29655ebffb... > > this is a simple one. maybe you can base on this

[web2py:14455] sqlform error message positioning problem

2009-01-03 Thread vince
when sqlform validate with error it will generate the error message like this too long! i think it should be too long! so we can position it as well as the table.field__label and table.field -vince --~--~-~--~~~---~--~~ You received this message because you

[web2py:14508] question about win32 build

2009-01-04 Thread vince
i only work on linux and trying to figure out the win32 build of web2py recently i tried to put the reportlab's dll files inside the library.zip and the web2py directory but it didn't work. is the dll files suppose to put inside sys.path? thanks in adva

[web2py:14509] Re: sqlform error message positioning problem

2009-01-04 Thread vince
wow that was fast! thanks for the awesome web2py -vince On Jan 4, 9:18 pm, mdipierro wrote: > In trunk now: > > >>> a=FORM(INPUT(_name='test',requires=IS_NOT_EMPTY())) > >>> a.accepts(request.vars,formname=None) > False > >>>

[web2py:14552] locking issue

2009-01-04 Thread vince
i just notice single thread, not even with db access, will lock the whole application. i can only access to other application on the same server. is that suppose to be single thread only for each applcation? -vince --~--~-~--~~~---~--~~ You received this

[web2py:14560] Re: locking issue

2009-01-05 Thread vince
/admin/ or any others application works fine i even try with a new empty welcome applcation where the model/db.py is empty -vince On Jan 5, 9:02 am, mdipierro wrote: > sorry, I do not understand the context of the question. > > which operation locks the entire applications? > > M

[web2py:14561] Re: question about win32 build

2009-01-05 Thread vince
oh thanks i didn't know reportlab is pure python(i guess except the image thing) as it's website come with compiled dll for windows. stupid me spend hours on copying the dll around haha. -vince On Jan 4, 10:06 pm, mdipierro wrote: > Just put the reportlab source in the main

[web2py:14567] Re: locking issue

2009-01-05 Thread vince
oh thanks for the info no session still lock the whole application session.forget() sql session works fine session.connect(request,response,db=db) i think it should make the session default to sql then if file session have locking issue. -vince On Jan 5, 9:04 pm, mdipierro wrote: > Beca

[web2py:14569] Re: locking issue

2009-01-05 Thread vince
oh that's a different case, sorry for my misunderstanding. -vince On Jan 5, 10:12 pm, mdipierro wrote: > It does not lock the whole application. It simply serializes all > requests sharing the same session. > If two different users (or same use using different sessions) connect

[web2py:14562] Re: sqlform error message positioning problem

2009-01-05 Thread vince
wow nice formula! no wonder web2py works great On Jan 4, 10:07 pm, mdipierro wrote: > some changes take one line and they are fast (t~exp(1)). Some changing > take 10 lines they can be slow (t~exp(10)). > > Massimo > > On Jan 4, 7:52 am, vince wrote: > > > wow th

  1   2   >