[web2py] Re: A way to disable totally auto migration ?

2011-03-29 Thread cjrh
On Mar 28, 7:12 pm, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I am looking at the source code right now. Currently this does not override the behavior of individual define_table(s). It just provides the default behavior in case a migrate argument is not passed. Since this is

[web2py] Re: A way to disable totally auto migration ?

2011-03-29 Thread cjrh
On Mar 28, 10:03 pm, Anthony abasta...@gmail.com wrote: Of course, we could always offer both options via some additional override argument. Turtles all the way down? :)

[web2py] Re: specifying controller

2011-03-29 Thread James C .
Anthony abastardi@... writes: Hi James,   It sounds like you might be thinking of how a PHP app might work, where your URL points to a particular .php file, and that file is then processed to generate the returned web page. web2py does not work that way. To get a better understanding

Re: [web2py] Re: question from stackoverflow - DB transactions

2011-03-29 Thread David Warnock
D, I often use Firebird and it supports Global Temporary Tables. I wonder whether that is something designed to resolve Adam's requirement. You can keep the temporary data even when the connection is lost. http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-globaltemp I am of

[web2py] Re: clean database

2011-03-29 Thread LightOfMooN
Question is opened. App working, HDD space decreases because of uploads. But some uploads are deleted from database, but files not. How to clean it? On 27 мар, 20:25, LightOfMooN vladsale...@yandex.ru wrote: Is there a way to pack just app code? (without images and other uploads) Or it can be

[web2py] Re: components and sessions

2011-03-29 Thread carlo
Massimo, I omitted a test case because it seems occurring in any of my components and it can easily reproduced. Here using the component example in the Book (modified a bit): model: db.define_table('comment', Field('body','text',label='Your comment'),

[web2py] Web2py uses the wrong database

2011-03-29 Thread Omri
Hello all, I have recently come across a strange problem: I copied my application to a different name, because I wanted to create a branch for beta testing of my application. I emptied the database from all my tests (using Sqliteman - btw - is there a better way to clear the database and reset

Re: [web2py] Re: clean database

2011-03-29 Thread Martín Mulone
Put autodelete=True on the db field definition upload. from the book: autodelete determines if the corresponding uploaded file should be deleted when the record referencing the file is deleted. For upload fields only. 2011/3/29 LightOfMooN vladsale...@yandex.ru Question is opened. App

[web2py] Re: specifying controller

2011-03-29 Thread Anthony
Glad to see you got it working. Note, when calling URL(), passing r=request is completely optional. Also, if you want the time of the request, it is stored in request.now, so you don't have to bother calculating the current time (assuming you don't mind the small amount of elapsed time between

[web2py] Re: A way to disable totally auto migration ?

2011-03-29 Thread Anthony
On Tuesday, March 29, 2011 2:09:09 AM UTC-4, cjrh wrote: On Mar 28, 10:03 pm, Anthony abas...@gmail.com wrote: Of course, we could always offer both options via some additional override argument. Turtles all the way down? Sorry, not sure what you mean.

[web2py] Re: Web2py uses the wrong database

2011-03-29 Thread Omri
I have found my problem - it was some stupid configuration problem. But I will still want to leave the question open - What is the best way to create a new 'clean' copy of the database file, resetting all the auto-increment fields? Thanks, Omri On Tue, Mar 29, 2011 at 11:36, Omri

[web2py] Re: A way to disable totally auto migration ?

2011-03-29 Thread Alexandre Strzelewicz
Perfect, thank you. (I prefer this current behaviour than the overidde) On Mar 28, 3:53 pm, Jose jjac...@gmail.com wrote: On 28 mar, 07:13, Alexandre Strzelewicz strzelewicz.alexan...@gmail.com wrote: I have recurrent problems with auto-migration. Is there a way to totally disable

[web2py] Re: Web2py uses the wrong database

2011-03-29 Thread Anthony
On Tuesday, March 29, 2011 7:29:41 AM UTC-4, Omri wrote: I have found my problem - it was some stupid configuration problem. But I will still want to leave the question open - What is the best way to create a new 'clean' copy of the database file, resetting all the auto-increment fields?

[web2py] Re: Web2py uses the wrong database

2011-03-29 Thread Ross Peoples
Another option for non-SQLite databases is to use truncate() on each table. But you have to truncate() in the right order for tables that reference each other, otherwise the truncate operation will fail.

[web2py] routing and routes.py

2011-03-29 Thread CVstash dot com
OK this one might seem very redundant but it just doesn't work on my behalf. I have an existing controller with an address like this: /resume/default/public/ which shows the public view of the online resume. I wish to make a simpler url for users to spread their resumes to, so I made a table to

[web2py] Layout for ticket?

2011-03-29 Thread sipiatti
Hi, I would like to know how can I provide a layout and/or view for the ticket appearing? Sometimes I made mistakes and errors, but that nearly empty page Internal error Ticket issued: myapp/127.0.0.1.2011-03-29.14-59-40.b807ecd9-3d35-4bed- b0e9-87619cb63c6a is non informative to my users. They

Re: [web2py] Re: Do we have any Turbogears to web2py model migration script?

2011-03-29 Thread Tito Garrido
Yeah? How can I do that? Regards, Tito On Tue, Mar 29, 2011 at 1:52 AM, Vasile Ermicioi elff...@gmail.com wrote: but you can generate models from database -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___

[web2py] Re: clean database

2011-03-29 Thread LightOfMooN
Yes, thanks, it's good. But first question stills opened: Is there a way to pack just app code? (to *.w2p) On 29 мар, 16:03, Martín Mulone mulone.mar...@gmail.com wrote: Put autodelete=True on the db field definition upload. from the book: autodelete determines if the corresponding uploaded

Re: [web2py] routing and routes.py

2011-03-29 Thread Jonathan Lundell
On Mar 29, 2011, at 5:10 AM, CVstash dot com wrote: so I made web2py/routes.py with this code: * routers = dict( BASE = dict(default_application='resume'), ) routes_in = ( ('/view/', '/resume/default/cv/'), (r'/view/any', r'/resume/default/cv/(?Pany.*)'), )

[web2py] Re: Web2py uses the wrong database

2011-03-29 Thread Omri Har-Shemesh
Thanks for your quick reply! Omri

[web2py] sqlform.widget.radio.widget problem getting value

2011-03-29 Thread Jens Örtenholm
Hi, I've been trying to add a radio button set to one of my web forms. I'm generating the form with SQLFORM.factory, because I'm adding a non db field to it. Example model: db.define_table('mytable', Field('name', 'string', requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB(db, ' mytable.name')]),

[web2py] datetime, DAL and JSON serialization

2011-03-29 Thread Omri Har-Shemesh
Hey, I have a problem with datetime json serialization. I am using the DAL with sqlite, and accessing web2py using JSONRPC. Today I started getting an error when trying to pass datetime fields back to the client. I haven't changed anything in the code for the routines, but it seems that the

[web2py] Puzzling registered trademark symbol appearance

2011-03-29 Thread Jim Karsten
I have a variable named 'reg_no' that when used as a link paramater is getting converted into a registered trademark symbol. Here is a simple example that illustrates it. The controller: def page(): link = A('my link', _href=URL(r=request, vars=request.vars)) form =

[web2py] Re: routing and routes.py

2011-03-29 Thread CVstash dot com
Thanks a lot Jonathan for the reply. I did just that but it still doesn't work out the shortcut even with this code: * default_application='resume' routes_in = ( ('/view', '/resume/default/index'), ) * doing http://localhost:8000/ would redirect to the resume app just

Re: [web2py] Puzzling registered trademark symbol appearance

2011-03-29 Thread Jonathan Lundell
On Mar 29, 2011, at 6:53 AM, Jim Karsten wrote: I have a variable named 'reg_no' that when used as a link paramater is getting converted into a registered trademark symbol. Here is a simple example that illustrates it. The controller: def page(): link = A('my link',

Re: [web2py] Re: routing and routes.py

2011-03-29 Thread Jonathan Lundell
On Mar 29, 2011, at 6:58 AM, CVstash dot com wrote: Thanks a lot Jonathan for the reply. I did just that but it still doesn't work out the shortcut even with this code: * default_application='resume' routes_in = ( ('/view', '/resume/default/index'), ) *

[web2py] Re: A way to disable totally auto migration ?

2011-03-29 Thread cjrh
On Mar 29, 1:02 pm, Anthony abasta...@gmail.com wrote: On Tuesday, March 29, 2011 2:09:09 AM UTC-4, cjrh wrote: On Mar 28, 10:03 pm, Anthony abas...@gmail.com wrote: Of course, we could always offer both options via some additional override argument. Turtles all the way down?

Re: [web2py] Re: routing and routes.py

2011-03-29 Thread Jonathan Lundell
On Mar 29, 2011, at 7:06 AM, Jonathan Lundell wrote: On Mar 29, 2011, at 6:58 AM, CVstash dot com wrote: Thanks a lot Jonathan for the reply. I did just that but it still doesn't work out the shortcut even with this code: * default_application='resume' routes_in = (

[web2py] Re: routing and routes.py

2011-03-29 Thread Anthony
On Tuesday, March 29, 2011 9:58:35 AM UTC-4, CVstash dot com wrote: Thanks a lot Jonathan for the reply. I did just that but it still doesn't work out the shortcut even with this code: * default_application='resume' routes_in = ( ('/view', '/resume/default/index'), )

[web2py] Re: A way to disable totally auto migration ?

2011-03-29 Thread Anthony
On Tuesday, March 29, 2011 10:09:58 AM UTC-4, cjrh wrote: On Mar 29, 1:02 pm, Anthony abas...@gmail.com wrote: On Tuesday, March 29, 2011 2:09:09 AM UTC-4, cjrh wrote: On Mar 28, 10:03 pm, Anthony aba...@gmail.com wrote: Of course, we could always offer both options via

[web2py] Re: routing and routes.py

2011-03-29 Thread CVstash dot com
OK I feel so silly, the restart did it ;-) Also this is what I used to handle the parameters: * default_application='resume' routes_in = ( ('/view', '/resume/default/cv'), ('/view/$anything', '/resume/default/cv/$anything'), ) * Thanks for your time Jonathan. Regards,

[web2py] Re: Very Bad Error Experience...

2011-03-29 Thread Massimo Di Pierro
Something went wrong with upgrade. Please upgrade manually (replace all web2py files). On Mar 28, 10:54 pm, Yannick ytchatch...@gmail.com wrote: Hello Mate, On my LIVE production server (Hosting Server), from the admin console I tried to upgrade the web2py server by clicking on the button

[web2py] Re: components and sessions

2011-03-29 Thread Massimo Di Pierro
The problem is that {{session.mysession={}}} {{session.mysession['mylabel']=comment.body}}} should be {{session.mysession={} }} # missing space {{session.mysession['mylabel']=comment.body}} # too many } On Mar 29, 3:11 am, carlo syseng...@gmail.com wrote: Massimo, I omitted a test case

[web2py] Re: routing and routes.py

2011-03-29 Thread CVstash CVstash
Thanks for the reply Anthony. Got it running, and yes restarting fixed it for me. I posted what I used in the thread. Regards, Arbie On Tue, Mar 29, 2011 at 10:31 PM, Anthony abasta...@gmail.com wrote: On Tuesday, March 29, 2011 9:58:35 AM UTC-4, CVstash dot com wrote: Thanks a lot Jonathan

[web2py] MSSQL Connection error on MacOS

2011-03-29 Thread Bruno Rocha
HI, I am trying connection to MSSQL using standalone DAL, but I am getting this error: Traceback (most recent call last): File baixar_arquivos.py, line 10, in module db = DAL('mssql://user1:pass...@servicogente.com.br/coelba') File /Users/rochacbruno/Dropbox/gente/web2py/gluon/dal.py,

[web2py] Re: MSSQL Connection error on MacOS

2011-03-29 Thread Bruno Rocha
It seens someone are having same issue woth Pyodbc and sqlalchemy http://stackoverflow.com/questions/4665078/connect-to-mssql-from-sqlalchemy-by-pyodbc-on-mac-os So it is not web2py DAL issue, it is Pyodbc issue, anyone aware? On Tue, Mar 29, 2011 at 12:28 PM, Bruno Rocha rochacbr...@gmail.com

[web2py] Re: datetime, DAL and JSON serialization

2011-03-29 Thread Massimo Di Pierro
Can you provide a simple example to reproduce the problem? Massimo On Mar 29, 8:48 am, Omri Har-Shemesh omri...@gmail.com wrote: Hey, I have a problem with datetime json serialization. I am using the DAL with sqlite, and accessing web2py using JSONRPC. Today I started getting an error when

[web2py] Re: components and sessions

2011-03-29 Thread carlo
wow! I would never have thought about the missing space while the extra curly brace was a typo in my post, thank you! On 29 Mar, 16:48, Massimo Di Pierro massimo.dipie...@gmail.com wrote: The problem is that {{session.mysession={}}} {{session.mysession['mylabel']=comment.body}}} should be

[web2py] Re: MSSQL Connection error on MacOS

2011-03-29 Thread annet
Hi Bruno, I had the same problem using MySQLdb, I solved it by setting up a my.cnf file in /etc the following way: Log in to OS X using an administrator-level account, open Terminal; cd /usr/local/mysql/support-files/ sudo cp my-huge.cnf /etc/my.cnf and enter your admin password when prompted.

[web2py] Re: Restriction Fields

2011-03-29 Thread luifran
I have not explained very well, I will not prevent the value of a and b are equal, I want to avoid the insertion of identical records, for example: Record 1 - a: 4 b: 5 Record 2 - a: 4 b: 5 This is what I want to avoid Sorry for my words, I'm Spanish, not fluent in English. On 28 mar, 20:40,

[web2py] Re: Restriction Fields

2011-03-29 Thread pbreit
I suspect you will need to use onvalidation in your controller and then query the db for both fields matching.

[web2py] OpenID on GAE

2011-03-29 Thread Will Stevens
I am trying to get both the basic auth and open id working together on GAE. I have managed to get it working on the web2py.py server, but I still have some minor issues with GAE. It has taken me about 2 days to get to this point, and I am SOO close to having a perfectly working setup. My

[web2py] Re: Restriction Fields

2011-03-29 Thread luifran
as I can do that? to insert into the table I use crud.create On Mar 29, 10:21 am, pbreit pbreitenb...@gmail.com wrote: I suspect you will need to use onvalidation in your controller and then query the db for both fields matching.

[web2py] Re: Puzzling registered trademark symbol appearance

2011-03-29 Thread Anthony
When web2py writes A('my link', _href=URL(r=request, vars=request.vars)) to HTML, it results in: a href=/page?input_one=aaareg_no=bbbmy link/a The problem is, the *browser* converts the reg in the href to the registered trademark symbol, so when you click the link, the requested URL sent to

[web2py] Text in admin not bold

2011-03-29 Thread Mr. Electronic
Hi Minor bug in the web2py admin: The text: There are no controllers Is not in bold text like: There are no models !-- CONTROLLERS -- ... p/strongThere are no controllers/strong/p ... Br. Rune Christensen (alias Mr. Electronic)

Re: [web2py] Re: Puzzling registered trademark symbol appearance

2011-03-29 Thread Jonathan Lundell
On Mar 29, 2011, at 10:34 AM, Anthony wrote: When web2py writes A('my link', _href=URL(r=request, vars=request.vars)) to HTML, it results in: a href=/page?input_one=aaareg_no=bbbmy link/a The problem is, the browser converts the reg in the href to the registered trademark symbol, so

Re: [web2py] Re: Do we have any Turbogears to web2py model migration script?

2011-03-29 Thread Anthony
In /web2py/scripts there are scripts for MySQL and Postgres (the latter says it might work with other databases too): http://code.google.com/p/web2py/source/browse/scripts/extract_mysql_models.py http://code.google.com/p/web2py/source/browse/scripts/extract_pgsql_models.py Anthony On

[web2py] web2py is too slow to respond to pages

2011-03-29 Thread Teddy Limousin
hi guys, I have made a small project in web2py and when trying to use it from the internet it takes too long to respond when loading any page. Is there a configuration that I should know about that makes it faster. Is web2py compilying the pages for every record or something like that (though I

[web2py] very slow response (over a minute)

2011-03-29 Thread Alex Darlington
Hi, I am using web2py for google app engine and doing development on windows 7 and XP machines. I recently changed some code to start using the blob store (in case this is relevant?) and now have a pretty unusable development environment. The first time I visit a page it takes over a minute to

[web2py] Re: very slow response (over a minute)

2011-03-29 Thread Massimo Di Pierro
This may be dues to excessive use of recursize queries or too much data being extracted from db at once. It is hard to say without looking at the code. On Mar 29, 12:03 pm, Alex Darlington alexdarling...@gmail.com wrote: Hi, I am using web2py for google app engine and doing development on

Re: [web2py] Re: Puzzling registered trademark symbol appearance

2011-03-29 Thread Jonathan Lundell
On Mar 29, 2011, at 11:04 AM, Jonathan Lundell wrote: On Mar 29, 2011, at 10:34 AM, Anthony wrote: When web2py writes A('my link', _href=URL(r=request, vars=request.vars)) to HTML, it results in: a href=/page?input_one=aaareg_no=bbbmy link/a The problem is, the browser converts the reg

[web2py] Re: OpenID on GAE

2011-03-29 Thread Will Stevens
I have continued debugging, so I figured I would add some more details. In the controller here... if 'janrain_nonce' in request.vars: auth.settings.login_form = openid_login_form return dict(form=auth() I printed out the value of 'request.vars' in a debugger. = request.vars Storage

[web2py] Re: OpenID on GAE

2011-03-29 Thread Will Stevens
in the initial post, i change my app name to init and controller to default cause that is what you would be expecting. it is actually cloudops and dashboard, but i have everything configured for that to work... i did not change the urls in the latest printout, so i wanted to make a note of that.

[web2py] ISNULL for sorting NULLs to bottom

2011-03-29 Thread Jim Karsten
I would like to sort records on a field such that NULL values get sorted to the end. In MySQL the suggested solution is to use ISNULL. For example SELECT name FROM person ORDER BY ISNULL(name), name; I tried other approaches such as sorting the rows returned from a select but they were not

[web2py] Bug with error ticket viewing and line numbers

2011-03-29 Thread Chris
In the error ticket page, my source code is double spaced but the line numbers aren't. Is that because of *nix line endings or something?

[web2py] Re: very slow response (over a minute)

2011-03-29 Thread Chris
Have you tried running it with the profiler and viewing a log for one page request? http://groups.google.com/group/web2py/browse_thread/thread/8e38fc1c177d5640 On Mar 29, 1:03 pm, Alex Darlington alexdarling...@gmail.com wrote: Hi, I am using web2py for google app engine and doing development

[web2py] Re: OpenID on GAE

2011-03-29 Thread Will Stevens
I have continued testing and I have further confirmed that the only time I am having the redirect issue of: [DB] profiles.google.com/williamstevens authenticated Status: 303 SEE OTHER Set-Cookie: session_id_cloudops=292:7dfe3917-16a3...etc...a0077e6f94f6; Path=/ Content-Type: text/html;

[web2py] time datatype widget is broken?

2011-03-29 Thread danto
I remember that the Time datatype widget in DAL can deploy a kind of dropdown menu showing the hours, but not anymore. This is how it should be or is something wrong? I'm using 1.94.5

[web2py] Re: Bug with error ticket viewing and line numbers

2011-03-29 Thread Massimo Di Pierro
Do you use windows? On Mar 29, 2:42 pm, Chris partyonais...@gmail.com wrote: In the error ticket page, my source code is double spaced but the line numbers aren't. Is that because of *nix line endings or something?

Re: [web2py] Re: Puzzling registered trademark symbol appearance

2011-03-29 Thread pbreit
Wow, I'm really surprised the browsers seem to mis-interpret that since it's missing the trailing semi-colon. It appears the underscore is significant (regno is OK).

Re: [web2py] Re: Puzzling registered trademark symbol appearance

2011-03-29 Thread Anthony
On Tuesday, March 29, 2011 6:47:23 PM UTC-4, pbreit wrote: Wow, I'm really surprised the browsers seem to mis-interpret that since it's missing the trailing semi-colon. It appears the underscore is significant (regno is OK). Yes, that's surprising. It appears to be intrpreted as an HTML

[web2py] Re: web2py is too slow to respond to pages

2011-03-29 Thread Plumo
I find that web hosting effects speed more that framework. What web hosting are you using?

[web2py] Re: SQLFORM.factory - RuntimeError: you must specify a Field(...,uploadfolder=...)

2011-03-29 Thread Russell
I've just been struck by the same issue when upgrading to Version 1.94.6 (2011-03-27 18:20:38). To be clear, this used to work, but does NOT work anymore: form=SQLFORM.factory(Field('document', 'upload')) This works on the current version: form=SQLFORM.factory(Field('document', 'upload',

[web2py] Re: datetime, DAL and JSON serialization

2011-03-29 Thread nick name
This thread might be relevant: https://groups.google.com/d/topic/web2py/1N0TwMOgp3o/discussion - have you started using detect_types? (if not, you should!) This thread might also be relevant: https://groups.google.com/d/topic/web2py/RuBOLSyDc40/discussion - as_list and as_dict (if you use

[web2py] Re: A way to disable totally auto migration ?

2011-03-29 Thread Anthony
I took a shot at explaining the current behavior at the end of the Migrations section in the book: http://web2py.com/book/default/chapter/06#Migrations Feel free to suggest changes. Anthony On Monday, March 28, 2011 1:12:09 PM UTC-4, Massimo Di Pierro wrote: I am looking at the source

Re: [web2py] Re: very slow response (over a minute)

2011-03-29 Thread Jason (spot) Brower
Do you have an internet connection when you are working locally? If not it may be pausing because it is looking some file that is not accessable and needs to time out. Is you app somewhere that we could test it? On 29 Mar 2011 22:45, Chris partyonais...@gmail.com wrote: Have you tried running it

[web2py] PluginMModal in plugin_wiki page

2011-03-29 Thread kawate
Hell: Please advise me to show PluginMModal window in plugin_wiki page. Best Regards:

[web2py] Another web2py job

2011-03-29 Thread Anthony
http://www.elance.com/j/web2py-webapp-pdf-handling-python-django-devs-welcome/23618115/