[web2py:18482] Re: Full documentation
A lot of free documentation is available, including example code in the posts on this mailing list. The web2py book is very reasonably priced, especially in PDF form. As I understand it, the documentation is in the form of a proper publication because Massimo has developed web2py in the context of his job as a lecturer at DePaul University. As an associate professor, his employers judge his performance mainly on the number of publications he makes. Unfortunately free documentation wouldn't count, hence the deal with Wiley to publish the book. There is an effort to develop a comprehensive web2py wiki that is in its early stages. It's available here https://mdp.cti.depaul.edu/wiki Chris On Mar 23, 3:10 am, Álvaro Justen [Turicas] wrote: > Hello, > firstly, congratulations for the job in web2py, Massimo! > > I downloaded and printed web2py's manual and only when I was reading I > see that it was incomplete. > That is a reason for doesn't exist a free full documentation? > Free documentation is very good, but I want to learn more advanced > features of web2py and have some troubles in buying in international > shops (I'm from Brazil). > > Thanks, > > -- > Álvaro Justen --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18480] Re: How to hide the console window?
I have renamed web2py.py to web2py.pyw and then start web2py using a shortcut with target set to \web2py.pyw -t You need to have .pyw appropriately set up as a file type in windows explorer for this to work I think. I had installed a windows distribution of Python before I had web2py, and I the installation process set this up. The extra 'w' on the Python file extension means 'don't open a console window' Chris On Mar 22, 3:52 pm, Iceberg wrote: > Tried but that does not help. :-P > > We need something similar to the effect of hstart.exe's: > hstart /NOCONSOLE "web2py.exe -i 0.0.0.0 -a -t" > > On Mar22, 11:06pm, mdipierro wrote: > > > > > try > > > web2py -a blah -p 8000 > > > Not sure. > > > On Mar 21, 10:44 pm, Iceberg wrote: > > > > Hi pals, > > > > I am using web2py 's windows distribution. Is there some way to hide > > > the console window (a.k.a. the black dos window) in which web2py is > > > running? I already know about: > > > web2py.exe -a blah -t > > > can start web2py in the systray of Microsoft Windows system, but the > > > console itself is still there and it is somewhat annoying and > > > meaningless to end users. > > > > I heard this can be done if using source code, just rename the main > > > web2py.py to web2py.pyw, on Windows platform. > > > > And this can also be done if using py2exe to build windows > > > distribution package, like > > > this:http://ubuntuforums.org/showthread.php?t=728170 > > > > But I don't know how things go in current web2py world. Can we just > > > have a web2py.exe as current situation, and one more web2pyw.exe that > > > does not have a console window? > > > > Thanks for any hint. > > > > Regards, > > > Iceberg- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18481] jquery jqGrid JSON url problem
Hi, I've been trying to execute a jquery jqGrid url to return JSON data but failed. Only a blank table with exact headings is displayed. I tried changing the url several times but no data is displayed. The following is part of the code. --
[web2py:18483] Re: Qusestion about the book?
> I would stay away from this kind of posting. At worst, you are presuming a > legal position on how to take copyrighted material without consequences. Perhaps Massimo could step in to clarify his position to prevent speculation. So far I've read that he needs to publish for the university, but it is possible to publish and give away simultaneously, as the Django Book shows. Clearly a lot of time was spent on the manual so it is understandable for a person to want to maintain ownership. However Massimo also spent a lot of time on web2py but still gave it away. The wiki right now is still pretty empty and doesn't look like approaching the coverage of the manual for a long time. So, would it be possible to kick start the documentation effort by allowing the copying of text sections from the manual? Baron --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18484] Re: How to hide the console window?
Thanks Chris but that is not the case. I already know the py and pyw difference but that only works when you have python distribution installed on the target PC. What I am talking about is trying to achieve same pyw effect on a PC with no python available but only web2py_win package is installed. Thanks anyway. On Mar23, 5:12pm, cjparsons wrote: > I have renamed web2py.py to web2py.pyw and then start web2py using a > shortcut with target set to > \web2py.pyw -t > You need to have .pyw appropriately set up as a file type in windows > explorer for this to work I think. I had installed a windows > distribution of Python before I had web2py, and I the installation > process set this up. > > The extra 'w' on the Python file extension means 'don't open a console > window' > > Chris > > On Mar 22, 3:52 pm, Iceberg wrote: > > > Tried but that does not help. :-P > > > We need something similar to the effect of hstart.exe's: > > hstart /NOCONSOLE "web2py.exe -i 0.0.0.0 -a -t" > > > On Mar22, 11:06pm, mdipierro wrote: > > > > try > > > > web2py -a blah -p 8000 > > > > Not sure. > > > > On Mar 21, 10:44 pm, Iceberg wrote: > > > > > Hi pals, > > > > > I am using web2py 's windows distribution. Is there some way to hide > > > > the console window (a.k.a. the black dos window) in which web2py is > > > > running? I already know about: > > > > web2py.exe -a blah -t > > > > can start web2py in the systray of Microsoft Windows system, but the > > > > console itself is still there and it is somewhat annoying and > > > > meaningless to end users. > > > > > I heard this can be done if using source code, just rename the main > > > > web2py.py to web2py.pyw, on Windows platform. > > > > > And this can also be done if using py2exe to build windows > > > > distribution package, like > > > > this:http://ubuntuforums.org/showthread.php?t=728170 > > > > > But I don't know how things go in current web2py world. Can we just > > > > have a web2py.exe as current situation, and one more web2pyw.exe that > > > > does not have a console window? > > > > > Thanks for any hint. > > > > > Regards, > > > > Iceberg- Hide quoted text - > > > - Show quoted text - --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18485] Change Control Process for web2py
All: It is very important to have change control process for web2py, this change control process will include : - formal submission of idea or improvement using a form - voting on the idea or improvement with supporting reasonings - incorporating the the idea or improvements into the next release - every release must be deposited in a storage area and kept there for certain time - removing old versions from the official storage will when support for that version is no longer feasible - annoucement is sent to all members when old version is no longer supported - There must be board of directors selected from the exiting members to decide the direction of web2py web2py Documentation : - all releases must have documentations for each new feature and stored in an official site togther with web2py framework - access to web2py should be limited to members only web2py members: - all members must pay a fee to hire students to write documentations, to test integrate applications into web2py framework, and to cover some of Massimo's expenses - the fee will be determined by the board of directors, my suggestion is 20 USD per month - all fee paying members will have all access to documentation and real time anwers for the creator, of course , that is Massimo Any suggestions!! Best Regards: dbb --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18486] problems with a query
hi all, I would like to make a query to fetch records in reverse order. The manual says to use ˜ by I get this error (everything works if a eliminate ˜). On web2py (maybe not after pasting the message in googlegroups) the arrow indicating the problems point to ˜. Am I missing something or is a problem with my Italian settings? thanks, Marco Error ticket for "X" Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c- fb62-423d-81a8-27058eccb348 Error traceback Traceback (most recent call last): File "gluon/restricted.py", line 97, in restricted File "C:/web2py_win159/web2py/applications/crm/controllers/ default.py", line 66 for i,r in enumerate(db().select (db.allineamento_erp.data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)): ^ SyntaxError: invalid syntax In file: C:\web2py_win159\web2py\applications\crm/controllers/ default.py #!/usr/bin/python # -*- coding: utf-8 -*- response.title = "New X" response.application = "X" if auth.user: response.menu=[ ['-Logout-',False,URL(r=request,f='user',args=['logout'])], ['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict (query='db.contatti.id>0'))], ['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict (query='db.operatori.id>0'))], ['Tipi attività',False,URL(r=request,f='select',args= ['db'],vars=dict(query='db.tipiattivita.id>0')) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18487] under load
I have an interesting situation, where while in a Apache/WSGI 1 process environment, running under high load (which makes this a likely race condition/lock issue) web2py just explodes: [Mon Mar 23 14:19:44 2009] [error] Traceback (most recent call last): [Mon Mar 23 14:19:44 2009] [error] File "/var/www/web2py/gluon/ sql.py", line 859, in define_table [Mon Mar 23 14:19:44 2009] [error] query = t._create(migrate=args ['migrate']) [Mon Mar 23 14:19:44 2009] [error] File "/var/www/web2py/gluon/ sql.py", line 1183, in _create [Mon Mar 23 14:19:44 2009] [error] sql_fields_old = cPickle.load (tfile) [Mon Mar 23 14:19:44 2009] [error] EOFError If I moderate myself and lower the load on the particular instance, everything works nice. Anybody encounter anything similar ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18488] Re: Web2py in Debug mode ?
DenesL wrote: > Despite its misleading name Winpdb is a platform independent GPL > [...] > In a hurry? just read: > http://groups.google.com/group/web2py/msg/ee46125b7c93fdd4 > In quickly trying it, it seems to work great! Thanks, -kb --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18489] html META error
META('',_http-equiv='content-type',_content='text/html', _charset='utf-8') or TAG.meta('',_http-equiv='content-type',_content='text/html', _charset='utf-8') or META(_charset='utf-8') returns SyntaxError: tags cannot have components --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18490] Re: Full documentation
Alvaro you should check http://mdp.cti.depaul.edu/AlterEgo There is some documentation there... On Mon, Mar 23, 2009 at 6:33 AM, cjparsons wrote: > > A lot of free documentation is available, including example code in > the posts on this mailing list. > > The web2py book is very reasonably priced, especially in PDF form. As > I understand it, the documentation is in the form of a proper > publication because Massimo has developed web2py in the context of his > job as a lecturer at DePaul University. As an associate professor, his > employers judge his performance mainly on the number of publications > he makes. Unfortunately free documentation wouldn't count, hence the > deal with Wiley to publish the book. > > There is an effort to develop a comprehensive web2py wiki that is in > its early stages. It's available here https://mdp.cti.depaul.edu/wiki > > Chris > On Mar 23, 3:10 am, Álvaro Justen [Turicas] > wrote: > > Hello, > > firstly, congratulations for the job in web2py, Massimo! > > > > I downloaded and printed web2py's manual and only when I was reading I > > see that it was incomplete. > > That is a reason for doesn't exist a free full documentation? > > Free documentation is very good, but I want to learn more advanced > > features of web2py and have some troubles in buying in international > > shops (I'm from Brazil). > > > > Thanks, > > > > -- > > Álvaro Justen > > > -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18491] Re: jquery jqGrid JSON url problem
Hey Ed, We're using jqGrid with XML data. Something thoughts (if you haven't tried them already): 1.) Try your grid with the FireBug plugin for FireFox and look at the response being returned to the grid. I've had web2py tickets thown at that point and the only to see it is via Firebug. Or just check for tickets from the admin app 2.) Did you set the response headers? in my case I had to use...response.headers["Content-Type"]="text/xml" 3.) What does your controller look like? In my controller that serves up the XML I just return a string with the XML data "return xml" instead of "return dict(xml = xml)" Hope that helps. I like jqGrid since it has excellent documentation and hope more of us can make it work with web2py. Mike On Mar 23, 5:27 am, ed wrote: > Hi, > I've been trying to execute a jquery jqGrid url to return JSON data > but failed. Only a blank table with exact headings is displayed. I > tried changing the url several times but no data is displayed. The > following is part of the code. > ------ > > type="text/javascript"> > > >
[web2py:18492] Re: Full documentation
That is why like all other new applications ( framework)let us pay membership fee for web2py to grow and be a household name. The fee will help take some of the trivial work to a payed student and Massimo be available to the difficult task what is ahead. I know Yaro and others, whom I am learning their names as I progress with web2py, are people that help web2py be at this stage; the fee will help them too focus on the demanding task ahead. Best Regards: Debebe Asefa,Ph.D. On Mar 22, 11:10 pm, Álvaro Justen [Turicas] wrote: > Hello, > firstly, congratulations for the job in web2py, Massimo! > > I downloaded and printed web2py's manual and only when I was reading I > see that it was incomplete. > That is a reason for doesn't exist a free full documentation? > Free documentation is very good, but I want to learn more advanced > features of web2py and have some troubles in buying in international > shops (I'm from Brazil). > > Thanks, > > -- > Álvaro Justen --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18493] Re: html META error
Try: META(**{'_http-equiv':'content-type','_content':'text/ html','_charset':'utf-8'}) note: you need the dictionary syntax since _http-equiv is an invalid identifier in Python and can not be used as a keyword argument. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18494] Re: html META error
Thats it - Thank You! On 23 Mar., 18:57, DenesL wrote: > Try: > > META(**{'_http-equiv':'content-type','_content':'text/ > html','_charset':'utf-8'}) > > note: you need the dictionary syntax since _http-equiv is an invalid > identifier in Python and can not be used as a keyword argument. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18495] Re: problems with a query
hi, this looks like a scripting error to me. i'm not a web2py-developer right now, but have some knowledge on python... the linebreak after select makes the mess: for i,r in enumerate(db().select(db.allineamento_erp.data_allineamento, orderby=˜db.allineamento_erp.data_allineamento)): whatever stuff you want to do with i and r the way you wrote it a variable called 'select' on db() is expected not the method db().select() regards iham On Mar 23, 2009, at 3:18 PM, Marco Prosperi wrote: > > hi all, I would like to make a query to fetch records in reverse > order. The manual says to use ˜ by I get this error (everything works > if a eliminate ˜). On web2py (maybe not after pasting the message in > googlegroups) the arrow indicating the problems point to ˜. Am I > missing something or is a problem with my Italian settings? thanks, > Marco > > Error ticket for "X" > Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c- > fb62-423d-81a8-27058eccb348 > > > Error traceback > > > > Traceback (most recent call last): > File "gluon/restricted.py", line 97, in restricted > File "C:/web2py_win159/web2py/applications/crm/controllers/ > default.py", line 66 >for i,r in enumerate(db().select > (db > .allineamento_erp > .data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)): > > ^ > SyntaxError: invalid syntax > > > > In file: C:\web2py_win159\web2py\applications\crm/controllers/ > default.py > > > #!/usr/bin/python > # -*- coding: utf-8 -*- > > response.title = "New X" > response.application = "X" > > > if auth.user: response.menu=[ >['-Logout-',False,URL(r=request,f='user',args=['logout'])], >['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict > (query='db.contatti.id>0'))], >['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict > (query='db.operatori.id>0'))], >['Tipi attività',False,URL(r=request,f='select',args= > ['db'],vars=dict(query='db.tipiattivita.id>0')) > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18496] Re: How to hide the console window?
On Mar 22, 3:44 am, Iceberg wrote: > I am using web2py 's windows distribution. Is there some way to hide > the console window (a.k.a. the black dos window) in which web2py is > running? I run as a service using: http://mdp.cti.depaul.edu/AlterEgo/default/show/77 I get no console window. PS This thread may also be useful: http://groups.google.com/group/web2py/browse_thread/thread/733896d0aec07d3e F --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18497] Re: problems with a query
thanks for the time you spent on my question but I don't have any linebreak in my code after 'select'. It appears in my post after copying the error message from web2py and pasting it to googlegroups. If I cancel the character ˜ everything works fine in my application Marco On 23 Mar, 19:14, Hilbert Markus wrote: > hi, > > this looks like a scripting error to me. > i'm not a web2py-developer right now, but have some knowledge on > python... > > the linebreak after select makes the mess: > for i,r in enumerate(db().select(db.allineamento_erp.data_allineamento, > > orderby=˜db.allineamento_erp.data_allineamento)): > whatever stuff you want to do with i and r > > the way you wrote it a variable called 'select' on db() is expected > not the method db().select() > > regards > iham > > On Mar 23, 2009, at 3:18 PM, Marco Prosperi wrote: > > > > > hi all, I would like to make a query to fetch records in reverse > > order. The manual says to use ˜ by I get this error (everything works > > if a eliminate ˜). On web2py (maybe not after pasting the message in > > googlegroups) the arrow indicating the problems point to ˜. Am I > > missing something or is a problem with my Italian settings? thanks, > > Marco > > > Error ticket for "X" > > Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c- > > fb62-423d-81a8-27058eccb348 > > > Error traceback > > > Traceback (most recent call last): > > File "gluon/restricted.py", line 97, in restricted > > File "C:/web2py_win159/web2py/applications/crm/controllers/ > > default.py", line 66 > > for i,r in enumerate(db().select > > (db > > .allineamento_erp > > .data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)): > > > ^ > > SyntaxError: invalid syntax > > > In file: C:\web2py_win159\web2py\applications\crm/controllers/ > > default.py > > > #!/usr/bin/python > > # -*- coding: utf-8 -*- > > > response.title = "New X" > > response.application = "X" > > > if auth.user: response.menu=[ > > ['-Logout-',False,URL(r=request,f='user',args=['logout'])], > > ['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict > > (query='db.contatti.id>0'))], > > ['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict > > (query='db.operatori.id>0'))], > > ['Tipi attività',False,URL(r=request,f='select',args= > > ['db'],vars=dict(query='db.tipiattivita.id>0')) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18498] Re: problems with a query
Hello Marco - Try this and tell us what you get: $ python web2py.py -S crm -M >>> result=db().select( db.allineamento_erp.data_allineamento, \ orderby=˜db.allineamento_erp.data_allineamento) >>> str(result) On Mon, Mar 23, 2009 at 4:29 PM, Marco Prosperi wrote: > > thanks for the time you spent on my question but I don't have any > linebreak in my code after 'select'. It appears in my post after > copying the error message from web2py and pasting it to googlegroups. > If I cancel the character ˜ everything works fine in my application > > Marco > > > On 23 Mar, 19:14, Hilbert Markus wrote: > > hi, > > > > this looks like a scripting error to me. > > i'm not a web2py-developer right now, but have some knowledge on > > python... > > > > the linebreak after select makes the mess: > > for i,r in enumerate(db().select(db.allineamento_erp.data_allineamento, > > > orderby=˜db.allineamento_erp.data_allineamento)): > > whatever stuff you want to do with i and r > > > > the way you wrote it a variable called 'select' on db() is expected > > not the method db().select() > > > > regards > > iham > > > > On Mar 23, 2009, at 3:18 PM, Marco Prosperi wrote: > > > > > > > > > hi all, I would like to make a query to fetch records in reverse > > > order. The manual says to use ˜ by I get this error (everything works > > > if a eliminate ˜). On web2py (maybe not after pasting the message in > > > googlegroups) the arrow indicating the problems point to ˜. Am I > > > missing something or is a problem with my Italian settings? thanks, > > > Marco > > > > > Error ticket for "X" > > > Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c- > > > fb62-423d-81a8-27058eccb348 > > > > > Error traceback > > > > > Traceback (most recent call last): > > > File "gluon/restricted.py", line 97, in restricted > > > File "C:/web2py_win159/web2py/applications/crm/controllers/ > > > default.py", line 66 > > >for i,r in enumerate(db().select > > > (db > > > .allineamento_erp > > > .data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)): > > > > > ^ > > > SyntaxError: invalid syntax > > > > > In file: C:\web2py_win159\web2py\applications\crm/controllers/ > > > default.py > > > > > #!/usr/bin/python > > > # -*- coding: utf-8 -*- > > > > > response.title = "New X" > > > response.application = "X" > > > > > if auth.user: response.menu=[ > > >['-Logout-',False,URL(r=request,f='user',args=['logout'])], > > >['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict > > > (query='db.contatti.id>0'))], > > >['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict > > > (query='db.operatori.id>0'))], > > >['Tipi attività',False,URL(r=request,f='select',args= > > > ['db'],vars=dict(query='db.tipiattivita.id>0')) > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18499] Re: auth questions
On Mar 23, 3:27 am, ctalley wrote: > There's still one thing I don't get. "Table Name:" in the appadmin > form is a drop down list and the only tables selectable from the list > are auth_user, auth_group, auth_membership, and auth_permission. To > me, this implied that it was only possible to set permissions on those > four tables. auth.add_permission() above indicates that any table can > be named, not just the four in the dropdown list. Should the dropdown > be populated with the names of all my tables? See: http://groups.google.com/group/web2py/browse_thread/thread/7a68e6cde4e0e3d9 F --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18500] Re: Change Control Process for web2py
Hi dbb, You bring up several good ideas... I have some (hopefully useful) comments below: On Mar 23, 9:44 pm, dbb wrote: > All: > > It is very important to have change control process for web2py, this > change control process will include : > - formal submission of idea or improvement using a form > - voting on the idea or improvement with supporting reasonings > - incorporating the the idea or improvements into the next > release > - every release must be deposited in a storage area and kept > there for certain time The svn and bzr take care of this > - removing old versions from the official storage will when > support for that version is > no longer feasible Why? The code is GPL. Let the old code live in SVN > - annoucement is sent to all members when old version is no > longer supported Currently, the website and this forum get the announcements , if we are on this forum, looks good... I have just registered the project on freshmeat (http://freshmeat.net/ projects/web2py) so the announcements should start appearing on FM too... Maybe we should announce on icewalkers too? > - There must be board of directors selected from the exiting > members to decide the > direction of web2py While governance is good, it comes with the risk of bureaucracy and slow decisions and sometimes arguments. > > web2py Documentation : > - all releases must have documentations for each new feature > and stored in an > official site togther with web2py framework There is an official book, several videos, wiki pages etc. The community around web2py is trying to build up an excellent new wiki. This group is very active and usually you can get response in < day. So while more is better wrt docs, the current status is reasonably good > - access to web2py should be limited to members only > web2py members: This goes against the philosophy of OSS.. Sorry, not feasible. > - all members must pay a fee to hire students to write > documentations, to test > integrate applications into web2py framework, and to > cover some of Massimo's > expenses > - the fee will be determined by the board of directors, my > suggestion is 20 USD > per month > - all fee paying members will have all access to > documentation and real time > anwers for the creator, of course , that is Massimo I don't think Massimo will take money to answer to forum posts or provide support. The commercial companies around web2py have to fulfill that role. I guess Massimo is more keen on developing web2py code, building a community and teaching. I'd also think any book revenues are 'side-effects' but not done for the purpose of profit. Moreover, while $20 looks ok to you, many people in developing countries can have 30 meals with $20. To them it may be very expensive. They may have the time to read code and learn hands-on... My $0.02 Regards Anand > Any suggestions!! > > Best Regards: > dbb --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18501] balancing
hi web2py people, I'm still balancing between Django and Web2py, althought I think I start to like web2py more and more because it really eases the process of writing an app. I tried to expose my views in my blog, if any french-spoken is interested: http://www.desfrenes.com/blog/post/quel-framework-web-python-choisir Just to help me clear my mind, what would you, as a web2py user, consider being weaknesses of it ? I understand this is not an easy question for a fan, but at least it could give directions to the project. See you, --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18502] Multi Column Unique Key, how to code best in web2py?
Massimo and web2py.experts, After initial successful tests with web2py we are trying to get the first 'little' enterprise application done with it. And like enterprises do we need to life with extensive use of multi column unique keys. Despite reading through various threads on this we could not get it working already with a 'simple' 2 column unique key. Either we loose the "drop box" option/functionality or we can't use it as one column of a multi column unique key. See the last 3 lines of the following code example. I'm sure someone here can share a working example of how to implement such a basic enterprise requirement in web2py code. Beyond that I would appreciate help on how a good code for a 3 column unique key would be implemented (a good example would be shapename +colorname+month below). Thanks, Hans db=SQLDB('sqlite://test.db') db.define_table('shape', SQLField('name'), migrate='shape.table') db.define_table('color', SQLField('name'), migrate='color.table') db.define_table('shapecolor', SQLField('shapename'), SQLField('colorname'), SQLField('month','date',requires=IS_DATE('%Y-%m')), migrate='shapecolor.table') db.shapecolor.shapename.requires=IS_IN_DB(db,db.shape.name,'%(name) s') # 1st try db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name) s'),IS_NOT_IN_DB(db (db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname') #<<< this breaks db.color.name dropdown # 2nd try db.shapecolor.colorname.requires=[IS_IN_DB(db,db.color.name,'%(name) s'),IS_NOT_IN_DB(db (db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname')] #<<< this breaks db.color.name dropdown as well # 3rd try db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name) s') #<<< dropdown working but no multi column unique key! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18503] Re: How to hide the console window?
On Mar24, 5:20am, Fran wrote: > On Mar 22, 3:44 am, Iceberg wrote: > > > I am using web2py 's windows distribution. Is there some way to hide > > the console window (a.k.a. the black dos window) in which web2py is > > running? > > I run as a service using:http://mdp.cti.depaul.edu/AlterEgo/default/show/77 > > I get no console window. > > PS This thread may also be > useful:http://groups.google.com/group/web2py/browse_thread/thread/733896d0ae... > > F Hi Fran, Actually I had read your first link, and then I was the person who posted your second link. :-) Running web2py as a service is a usual answer for the "no-console" need. But somehow that can only be done when using web2py's source code distribution (and therefore python is a precondition on the target PC, perhaps pywin32 too). I am seeking a way to do the same thing with web2py_win.zip binary distribution, so that eventually any MS Windows user do not need to install anything else, but just use web2py like every other "normal" windows programs. The goal is almost achieved now, with the help of "Hidden Start". I even write a mail to Massimo for suggesting him to try to apply a free permission of using "Hidden Start" in web2py, because of its license policy: http://www.ntwind.com/software/utilities/hstart/distribution.html Regards, Iceberg --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18504] Re: Multi Column Unique Key, how to code best in web2py?
Hello Hans - On Mon, Mar 23, 2009 at 5:23 PM, Hans < johann.scheibelho...@easytouch-edv.com> wrote: > > Massimo and web2py.experts, > > After initial successful tests with web2py we are trying to get the > first 'little' enterprise application done with it. And like > enterprises do we need to life with extensive use of multi column > unique keys. Despite reading through various threads on this we could > not get it working already with a 'simple' 2 column unique key. Either > we loose the "drop box" option/functionality or we can't use it as one > column of a multi column unique key. See the last 3 lines of the > following code example. I'm sure someone here can share a working > example of how to implement such a basic enterprise requirement in > web2py code. > > Beyond that I would appreciate help on how a good code for a 3 column > unique key would be implemented (a good example would be shapename > +colorname+month below). > > Thanks, > Hans > > db=SQLDB('sqlite://test.db') > > db.define_table('shape', > SQLField('name'), > migrate='shape.table') > > db.define_table('color', > SQLField('name'), > migrate='color.table') > > db.define_table('shapecolor', > SQLField('shapename'), > SQLField('colorname'), > SQLField('month','date',requires=IS_DATE('%Y-%m')), > migrate='shapecolor.table') You probably mean to have these be a table holding many-to-many relationships. If so, these should be references (that is, they should implement foreign keys), something like this: db.define_table('shapecolor',# note every web2py table by default creates a unique field, 'id' SQLField('shape_id', db.shape), SQLField('color_id', db.color )) # I leave the date off just because the way you have it is ok... # I only want to show correction where I think there is a problem > > db.shapecolor.shapename.requires=IS_IN_DB(db,db.shape.name,'%(name) > s') > Now, since a reference to another table is a reference to a row id, here is how this should look: db.shapecolor.shape_id.requires=IS_IN_DB(db, db.shape.id, %(name)s ) Here is how this "reads": shape_id must be the same as shape.id, and shape.id must exist (but, from that row, display db.shape.name as a string, instead of shape.id) Try to re-phrase all of the following in a similar way, recognizing that the foreign key is a reference to another table's 'id' field (and so the IS_IN_DB test will also be against the id of that table) --- display the name for selection, as you have. Let us know how it goes. Regards, Yarko > # 1st try > db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name) > s'),IS_NOT_IN_DB(db > (db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname') > #<<< this breaks db.color.name dropdown > # 2nd try > db.shapecolor.colorname.requires=[IS_IN_DB(db,db.color.name,'%(name) > s'),IS_NOT_IN_DB(db > (db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname')] > #<<< this breaks db.color.name dropdown as well > # 3rd try > db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name) > s') #<<< dropdown working but no multi column unique key! > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18505] Auth Wiki example
Hi all, I followed the example posted at the WiKi about auth, I extended Auth class with: db.py -> class MyAuth(Auth): def __init__(self, environment, T, db = None): Auth.__init__(self, environment, db) self.messages.logged_in = T("Logged in") self.messages.email_sent = T("Email sent") self.messages.email_verified = T("Email verified") self.messages.logged_out = T("Logged out") self.messages.registration_successful = T("Registration successful") self.messages.invalid_email = T("Invalid email") self.messages.invalid_login = T("Invalid login") self.messages.verify_email_subject = T("Password verify") self.messages.username_sent = T("Your username was emailed to you") self.messages.new_password_sent = T("A new password was emailed to you") self.messages.password_changed = T("Password changed") self.messages.retrieve_username = str(T("Your username is"))+": % (username)s" self.messages.retrieve_username_subject = T("Username retrieve") self.messages.retrieve_password = str(T("Your password is"))+": % (password)s" self.messages.retrieve_password_subject = T("Password retrieve") self.messages.profile_updated = T("Profile updated") auth = MyAuth(globals(), T, db) Then I enabled user at controllers: def user(): return dict(form=auth()) When I try to call user it returns the following: Error ticket for "welcome" Ticket 127.0.0.1.2009-03-23.23-19-06.ea037521-4005-40f4-ac29- ef8af121182a Error traceback Traceback (most recent call last): File "/Users/Ra/codigo_fuente/web2py/gluon/restricted.py", line 98, in restricted exec ccode in environment File "/Users/Ra/codigo_fuente/web2py/applications/welcome/ controllers/default.py", line 14, in File "/Users/Ra/codigo_fuente/web2py/gluon/globals.py", line 75, in self._caller = lambda f: f() File "/Users/Ra/codigo_fuente/web2py/applications/welcome/ controllers/default.py", line 8, in user def user(): return auth() File "/Users/Ra/codigo_fuente/web2py/gluon/tools.py", line 399, in __call__ return self.login() File "/Users/Ra/codigo_fuente/web2py/gluon/tools.py", line 529, in login if 'username' in user.fields: AttributeError: 'NoneType' object has no attribute 'fields' In file: /Users/Ra/codigo_fuente/web2py/applications/welcome/ controllers/default.py def index(): response.flash = T('Welcome to web2py') return dict(message=T('Hello World')) # # uncomment the following if you have defined "auth" and "crud" in models #def user(): return dict(form=auth()) def user(): return auth() # def data(): return dict(form=crud()) def download(): return response.download(request,db) # # tip: use @auth.requires_login, requires_membership, requires_permission response._vars=response._caller(user) I guess that the problem is at db = None when variables are initialized. So... how I can fix it? Thanks in advance. BTW: My python skills are poor and sorry for my english. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18506] Re: Multi Column Unique Key, how to code best in web2py?
On Mon, Mar 23, 2009 at 9:17 PM, Yarko Tymciurak wrote: > Hello Hans - > *snip* > You probably mean to have these be a table holding many-to-many > relationships. If so, these should be references (that is, they should > implement foreign keys), something like this: > > db.define_table('shapecolor',# note every web2py table by default > creates a unique field, 'id' > SQLField('shape_id', db.shape), > SQLField('color_id', db.color )) > > It may not be clear what these say: shape_id is a foreign key, and it references the table db.shape, that is it holds a reference to db.shape.id Another way to write references (useful when you have forward references, or a self-reference) is: SQLField('shape_id', 'reference shape') A self reference might look like: db.define_table('mine', SQLField('name'), SQLField('related_mine_id', 'reference mine')) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18507] MVC question
All, Just a question on the best practice - in terms of development & continuous maintenance. web2py (like django) allows to define forms in controller itself. And it allows having 'business logic' embedded in views too. To bring out the application quickly, such mixing is fine. But what about long term maintenance and also to call the application truly MVC? What are your thoughts basis of your experience. Thank you for sharing your thoughts on this, Joseph --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---