[web2py] Re: Multiple instances of same application

2010-06-04 Thread Iceberg
Let me clarify and then summarize. First, .hgignore is one thing, "packing" is another. Ok we can leave the .hgignore out of web2py level, let each developer controls it by themselves. But when talking about "packing", I mean the "pack" feature on http://localhost:8000/admin/default/site for each

Re: [web2py] Re: Cherokee-fastcgi server (error log)

2010-06-04 Thread Álvaro Justen
On Fri, Jun 4, 2010 at 20:16, mdipierro wrote: > This happens when users drop connections (like close the broser or tab > duing a slow download). > > There is not much that we can do. The web server logs it. Probably > web2py logs it too. Maybe adding an "except socket.error"? -- Álvaro Justen

[web2py] Re: routes to have userprofile pages

2010-06-04 Thread ChrisM
Adi, thanks very much, works well. I will probably want to remove "profile" from url so user can just have www.myapp.com\username but I will need to think how this can be done:) On Jun 4, 5:16 pm, Adi wrote: > Assuming your application is in init folder - the following might work > > routes_in=(

[web2py] Re: Cherokee-fastcgi server (error log)

2010-06-04 Thread mdipierro
This happens when users drop connections (like close the broser or tab duing a slow download). There is not much that we can do. The web server logs it. Probably web2py logs it too. Massimo On Jun 4, 2:54 pm, Jose wrote: > Hello, > > From the applicative not see any mistake or problem, but I th

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-04 Thread mdipierro
The problem is that the csv export requires the entire data to be stored in ram. You may want to try exporting using the shell and/or exporting a some data at the time. On Jun 4, 2:22 pm, drayco wrote: > Today, when I try to download large csv archives, with admin, apache > crashed > > Well, I ad

[web2py] Re: Rocket for production sites?

2010-06-04 Thread mdipierro
Because I have seen the source code. Even if a problem where to show up (none recently), I trust we'd be able to deal with it fast. On Jun 4, 10:46 am, Anand Vaidya wrote: > Hi Massimo, > > I am confused by what you say here: > > > I trust rocket even more but I do not have data or direct > > exp

[web2py] Cherokee-fastcgi server (error log)

2010-06-04 Thread Jose
Hello, >From the applicative not see any mistake or problem, but I think that is not normal, but in the error log Cherokee appears thousands of times the following error: Unhandled exception in thread started by > Traceback (most recent call last): File "/usr/home/web2py/gluon/contrib/gateways/

[web2py] Re: welcome.w2p

2010-06-04 Thread NetAdmin
Sorry I found it. Time for new eye-glasses. On Jun 4, 2:19 pm, NetAdmin wrote: > I just upgraded to web2p version 1.78.3 and there seems to be no > welcome.w2p scaffold app. > > Is this a problem or do I need to create my own? > > Thanks!

[web2py] Re: Where can I download web2py 1.77.3?

2010-06-04 Thread drayco
Today, when I try to download large csv archives, with admin, apache crashed Well, I added this to httpd.conf WSGIDaemonProcess web2py user=drayco group=drayco \ home=/home/drayco/webapps/seccion36/web2py \ processes=1 maximum-requests=1000 But even with that, apache crashed equal. Any

[web2py] welcome.w2p

2010-06-04 Thread NetAdmin
I just upgraded to web2p version 1.78.3 and there seems to be no welcome.w2p scaffold app. Is this a problem or do I need to create my own? Thanks!

Re: [web2py] Re: Multiple instances of same application

2010-06-04 Thread Thadeus Burgess
I agree with Massimo, the NOT packing facility could be handled by .hgignore. As for configuration, I have used 0_config.py in blogitizor so that I can run two versions, my personal version and the one that is open source, this way my database and email information doesn't get leaked out into the

Re: [web2py] [proposition] Need date calculations in a query

2010-06-04 Thread Thadeus Burgess
http://thadeusb.com/weblog/archive/2010/1/5/query_between_dates/30 http://thadeusb.com/weblog/archive/2010/3/19/increase_productivity_by_using_parameterized_queries_with_web2py/33 If you have any questions please feel free to ask. -- Thadeus On Fri, Jun 4, 2010 at 5:42 AM, Sverre wrote: > I

Re: [web2py] Re: Layout of functions with the MVC environment

2010-06-04 Thread Thadeus Burgess
All functions defined in models are available to controllers and views as anything you put in the models becomes part of the global namespace that the controllers/views are executed in. This leads to potential problems of namespace collision. Make sure you do not overwrite the function elsewhere,

[web2py] Re: Outer join problem

2010-06-04 Thread ceriox
now it work thanks Candid On 4 Giu, 17:55, Candid wrote: > typo: belongs, not belngs > > On Jun 4, 11:49 am, ceriox wrote: > > > it don't work > > AttributeError: 'Field' object has no attribute 'belngs' > > > mdipierro i write you an email with the real full db > > > On 4 Giu, 15:40, mdipierro

Re: [web2py] Re: Layout of functions with the MVC environment

2010-06-04 Thread Doug Warren
On Fri, Jun 4, 2010 at 9:11 AM, Yarko Tymciurak wrote: > > > On Jun 4, 10:58 am, Doug Warren wrote: >> I don't believe I want to local_import my db.py file as it's already >> set up by the environment correct? > > Correct - you do not want / need to import your db.py. > > As long as it is in your

Re: [web2py] Re: Rocket for production sites?

2010-06-04 Thread Jason Brower
Ananad... if you haven't used it how can _you_ trust it. You may want to talk to the people that made Rocket. I use it for our production system. But my setup is very different. It runs a robot. BR, Jason On Fri, 2010-06-04 at 08:46 -0700, Anand Vaidya wrote: > Hi Massimo, > > I am confused

[web2py] Re: routes to have userprofile pages

2010-06-04 Thread Adi
Assuming your application is in init folder - the following might work routes_in=( ('/profile/$args', '/init/default/profile/$args'), ('/profile/$args/(?P.*$)', '/init/default/profile/$args/ \g'), ) routes_out=( ('/init/default/profile/$args', '/profile/$args'), ('/init/default/profile/$a

[web2py] convert field to multiple view values?

2010-06-04 Thread Keith
I'm new to web2py and the I did this previously was with javascript but I was hoping to avoid that this go around. In my database table I have a single field something like this below: db.define_table('foo', Field('height', 'double'), In the controller/view I need to be able to translate that

[web2py] Re: Layout of functions with the MVC environment

2010-06-04 Thread Yarko Tymciurak
On Jun 4, 10:58 am, Doug Warren wrote: > I don't believe I want to local_import my db.py file as it's already > set up by the environment correct? Correct - you do not want / need to import your db.py. As long as it is in your models folder (by default it is), it's already in your request cont

Re: [web2py] Re: Layout of functions with the MVC environment

2010-06-04 Thread Doug Warren
I don't believe I want to local_import my db.py file as it's already set up by the environment correct? What I'm asking for is a way to keep all of the code that relates to the model in one place and to invoke it from controllers. That is if I define 5 tables for the model I'd expect to write hel

[web2py] Re: Layout of functions with the MVC environment

2010-06-04 Thread Yarko Tymciurak
On Jun 4, 10:43 am, Doug Warren wrote: > Traditionally when I've written MVC style applications, the model > would contain not only the data representing the objects but also the > data for manipulating the objects.  I'm not sure how that same > relation applies to web2py. > > If I have a model

[web2py] Re: Outer join problem

2010-06-04 Thread Candid
typo: belongs, not belngs On Jun 4, 11:49 am, ceriox wrote: > it don't work > AttributeError: 'Field' object has no attribute 'belngs' > > mdipierro i write you an email with the real full db > > On 4 Giu, 15:40, mdipierro wrote: > > > > > I think you want this, all Books without a union. > > >

[web2py] Re: Ticket when trying to upload an image

2010-06-04 Thread weheh
auth.user table On Jun 4, 1:43 am, mdipierro wrote: > which table? > > On Jun 1, 1:42 am, weheh wrote: > > > > > I got the following ticket when trying to upload an image via the > > appadmin: > > > Traceback (most recent call last): > >   File "C:\web2py\gluon\restricted.py", line 178, in restr

[web2py] Re: Outer join problem

2010-06-04 Thread ceriox
it don't work AttributeError: 'Field' object has no attribute 'belngs' mdipierro i write you an email with the real full db On 4 Giu, 15:40, mdipierro wrote: > I think you want this, all Books without a union. > > records=db(~db.Book.book_id.belngs(db()._select(db.Union.id))).select(db.Book.ALL)

[web2py] Re: Rocket for production sites?

2010-06-04 Thread Anand Vaidya
Hi Massimo, I am confused by what you say here: > I trust rocket even more but I do not have data or direct > experience of its use in production. How can you trust rocket if you have no direct experience with it? Can you please elaborate what you meant with that line? Regards Anand > > On Ju

[web2py] Re: new stuff in trunk...

2010-06-04 Thread Anand Vaidya
There is a nice article related to this topic on Smashing Magazine: http://www.smashingmagazine.com/2010/06/02/getting-started-with-e-commerce-your-options-when-selling-online/comment-page-1/#comment-462851 Regards Anand On Jun 3, 10:23 pm, Richard wrote: > I would also trust someone known like

[web2py] Layout of functions with the MVC environment

2010-06-04 Thread Doug Warren
Traditionally when I've written MVC style applications, the model would contain not only the data representing the objects but also the data for manipulating the objects. I'm not sure how that same relation applies to web2py. If I have a model that defines 4-5 tables, 2 of them are just foreign k

[web2py] Re: Support for Indian Languages

2010-06-04 Thread Anand Vaidya
Hi Rahul, I had contributed a Hindi translation some time ago, which was like 85-90% complete. It works. I had tested it in two ways: - set T() in web2py so w2py serves only Hindi ;-) - I had downloaded the hindi localized build of firefox to test ( I think I also tested with Arora webkit browse

Re: [web2py] Re: Wouldn't it be cool ...

2010-06-04 Thread Doug Warren
Getting way off topic, but the Sprint 4g Evo comes out today... I've been waiting for this phone since it was announced to jump from an iPhone :) http://sprint.com/evo (Website being hammered by activations probably.) Can act as an 802.11 base station, is the first 4g android phone in the US, an

Re: [web2py] Re: Inserting data with foreign keys not from a form

2010-06-04 Thread Doug Warren
Yes, but the foreign key here is many to one, not one to one. (I guess I should have been more clear: if db(fk_table.id > 0).count() == 0: db.fk_table.insert(name="The Foreign Key") if db(table2.id > 0).count() == 0: fk = db(db.fk_table.name == "The Foreign Key").select()[0] db.tab

[web2py] Re: Inserting data with foreign keys not from a form

2010-06-04 Thread mr.freeze
The insert function will return the id. fk = db.fk_table.insert(name="The Foreign Key") On Jun 4, 9:48 am, Doug Warren wrote: > Hi, > > I defined all my tables in my model file and want to have a few > hundred rows of default foreign keys to maintain 3rd normal form.  So > I have things in my cod

[web2py] Inserting data with foreign keys not from a form

2010-06-04 Thread Doug Warren
Hi, I defined all my tables in my model file and want to have a few hundred rows of default foreign keys to maintain 3rd normal form. So I have things in my code such as: if db(fk_table.id > 0).count() == 0: db.fk_table.insert(name="The Foreign Key") if db(table2.id > 0).count() == 0: f

Re: [web2py] Re: I can not update

2010-06-04 Thread Marcelo Martinez
thanks, solved my problem 2010/6/4 mdipierro > In this > > try: > #1 > except: > # 2 > > if #1 fails because it violates a constraint, than you need to > rollback before you can access the database again. > Try this: > > t

[web2py] Re: Mustache.js and web2py

2010-06-04 Thread PanosJee
I just open an html file and spit the code in web2py views now :P Just for the shake of performance i cache the content so i do not open the file all the time :) On 4 Ιούν, 17:12, Thadeus Burgess wrote: > Unfortunately not at the moment. This is something we have been > discussing for the last we

Re: [web2py] Mustache.js and web2py

2010-06-04 Thread Thadeus Burgess
Unfortunately not at the moment. This is something we have been discussing for the last week however it does not seem web2py templates will ever get this. Just as a note, you would have this problem whether you were using jinja, or django templates as well. -- Thadeus On Fri, Jun 4, 2010 at

[web2py] Re: Outer join problem

2010-06-04 Thread mdipierro
I think you want this, all Books without a union. records=db(~db.Book.book_id.belngs(db()._select(db.Union.id))).select(db.Book.ALL) On Jun 4, 7:17 am, ceriox wrote: > hi all > i have a problem making an outer join > somebody can write me the correct one? > > db.define_table('Union', >     Fie

[web2py] Re: Support for Indian Languages

2010-06-04 Thread mdipierro
if you email me your language files I will include them in web2py. On Jun 4, 5:29 am, Rahul wrote: > Hi Massimo, All, >        Wondering how the internationalization for Indian Languages > works. I am using latest web2py (1.78.3) on Firefox with "Translate" > Plugin installed for translation on W

[web2py] Re: routes to have userprofile pages

2010-06-04 Thread ChrisM
anyone? On Jun 3, 2:29 pm, ChrisM wrote: > Having trouble gettingroutesto work (not used before) for instance > as a test I did: > > inroutes.py: > routes_in = (  ('/profile/*', '/init/default/userprofilepage/*'),) > routes_out = (  ('/init/default/userprofilepage/*', '/profile'),) > > in default

[web2py] Re: Outer join problem

2010-06-04 Thread ceriox
correction: record=db().select(db.Book.ALL, db.Union.ALL, left=db.Book.on(db.Union.book_id<>db.Book.id)) i use 'left=db.Book.on' not 'right=.' On 4 Giu, 14:17, ceriox wrote: > hi all > i have a problem making an outer join > somebody can write me the correct one? > > db.define_table('Union'

[web2py] Outer join problem

2010-06-04 Thread ceriox
hi all i have a problem making an outer join somebody can write me the correct one? db.define_table('Union', Field('user_id', db.User, writable=False, readable=False), Field('book_id', 'integer', db.Book, writable=False, readable=False)) db.define_table('Book', Field('Titolo', 'string'

[web2py] Mustache.js and web2py

2010-06-04 Thread PanosJee
Hello everyone i am trying to use Mustache.js along with web2py Mustache is a cross language rendering mechanism. We use it both server side and client side. What i want to do is to have a hidden div with the mustache template but i have the following problem. Mustache uses {{ }} as web2py does so

[web2py] [proposition] Need date calculations in a query

2010-06-04 Thread Sverre
I need some like query(startdate+timedelta(days) > endtime) In PostgreSQL and other databases that not a problem. The alternative is only filtering on client side.

[web2py] Support for Indian Languages

2010-06-04 Thread Rahul
Hi Massimo, All, Wondering how the internationalization for Indian Languages works. I am using latest web2py (1.78.3) on Firefox with "Translate" Plugin installed for translation on Windows XP (SP2). International languages like Japanese, Chinese, Korean and others work seamlessly and thats

Re: [web2py] Re: checkboxes and radio widget failed with multiple validators

2010-06-04 Thread Mathieu Clabaut
Good point ! My example was not so good. But anyway I have another specific validator to add... -Mathieu On Fri, Jun 4, 2010 at 06:42, Iceberg wrote: > Maybe your patch is ok. But wouldn't it be not necessary to use > requires=[IS_IN_SET(...), IS_NOT_EMPTY()]? Because you must already > mention

[web2py] Re: unique entry or null validation

2010-06-04 Thread dlin
By the way, I found http://127.0.0.1:8000/examples/static/epydoc/index.html also have such document. But, I missed it. I should click on the left upper corner to choose validator at first to narrow the display results. On 6月4日, 下午4時15分, dlin wrote: > Thanks, It works. > > I've searched it onhtt

[web2py] Re: Multiple instances of same application

2010-06-04 Thread Iceberg
Aside from the config issue, a flag when packaging that does not package the database/ folder, would be the long missing piece. And when this flag is available, I think I can have my own databases/ my_config.py to solve the local config problem in my style. :-) So +1 for the "flag when packaging t

[web2py] Re: How to set multiple primary key?

2010-06-04 Thread dlin
I still not understand the answer. How could I build primary key on two fields by default sqlite? Or, is there any better method to build 'unique key' on multiple fields? On 5月20日, 上午12時30分, drayco wrote: > Thank's a lot Nico de Groot. > > It worked for me too even with mysql. > > On 18 mayo, 0

[web2py] Re: unique entry or null validation

2010-06-04 Thread dlin
Thanks, It works. I've searched it on http://web2py.com/book/default/section/7/4 On 6月4日, 下午1時47分, Yarko Tymciurak wrote: > On Jun 3, 11:31 pm, dlin wrote: > > > There is a field which I want user to enter different answer, or just > > keep in empty. > > empty, or unique answer: > > db.table.an

[web2py] call javascript function from within controller

2010-06-04 Thread annet
I have the following code in a view: {{=A(club.companyname,_onmouseover="this.style.cursor='pointer';",\ _onclick="javascript:clublocatordetails('%s')"%URL(r=request,f='details',args=[club.id]))}} The javascript clublocatordetails function (in web2py_ajax.html) re sizes the window. I extende