[web2py] Re: web2py 2.3.2 added "+ -" to some form elements

2012-12-19 Thread howesc
ooops. i added the - and didn't test the "only 1 row case". i'll try and create a patch tomorrow for it. mind opening a ticket in google code? thanks, christian On Tuesday, December 18, 2012 8:17:11 AM UTC-8, Daniele wrote: > > The newest version of web2py has added some + and - clickable li

[web2py] Re: hello3.xml question

2012-12-19 Thread lucas
oh yeah, that worked absolutely great. thank you so much. so cool, data can be stripped and sent so many different ways. so sweet. lucas --

Re: [web2py] Re: web2py interactive shell in windows does not start the browser

2012-12-19 Thread Bruno Rocha
Alternativelly you can use WINGIDE which gives you an "real time" debugger shell http://www.wingware.com/doc/howtos/web2py Woth this IDE you can have a breakpoint and so in a request you can inspect the variables for that request. --

[web2py] Re: web2py interactive shell in windows does not start the browser

2012-12-19 Thread Anthony
A few options: - The admin app includes an interactive debugger -- you can set breakpoints in your code and then step through. - If you start web2py from the shell via python web2py.py, any print statements in your code will print output to that shell. - At any point in your code,

[web2py] Re: The book updates and status

2012-12-19 Thread Andrew W
I'm happy to proof read. Send it through when ready. Andrew W On Thursday, December 20, 2012 2:46:41 PM UTC+13, Anthony wrote: > > On Wednesday, December 19, 2012 5:56:48 PM UTC-5, Massimo Di Pierro wrote: > >> I have been going over that document. The things in gray were not in the >> publish

[web2py] Re: The book updates and status

2012-12-19 Thread Anthony
On Wednesday, December 19, 2012 5:56:48 PM UTC-5, Massimo Di Pierro wrote: > I have been going over that document. The things in gray were not in the > published 4th edition but are in the online version. > Make sure you click the link below -- it's an updated version of the original document.

[web2py] Re: Customizing auth login form but unable to set the form class name

2012-12-19 Thread Anthony
Sorry, I forgot this doesn't work with form.custom.begin, which is an XML object rather than an HTML helper (because it includes only the opening form tag). Instead, you could do this: {{=XML(form.custom.begin.replace('>', ' class="myclass">'))}} but it's probably more straightforward to just m

[web2py] Re: web2py interactive shell in windows does not start the browser

2012-12-19 Thread Bhaskar Ramachandran
Thanks Massimo. Again, i am so new to web development. I learned from your web2py book that your framework goes through a series of actions and i am assuming it creates objects in memory and fills these objects with user data and then processes these objects according to the model, controller

[web2py] Re: Query results from 2 children tables from same parent ordered by date

2012-12-19 Thread Mamisoa Andriantafika
Best results to UNION I could have was using the mutex table trick: http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-join-in-mysql/ with this syntax: exams_mutex = db().select(db.dataset1.ALL, db.dataset2.ALL, left=[db.dataset1.on(db.mutex.i==0),db.dataset2.on(db.mutex.i==1)]) Two pr

[web2py] Re: Customizing auth login form but unable to set the form class name

2012-12-19 Thread Bhaskar Ramachandran
Hi Anthony, I tried that earlier also but that code didn't seem to work. I say so because my html page still has that login form on the left side of the navigation bar and looking at the source code, i see the following: No class is added. If I replace the custom form with a hard coded form

Re: [web2py] how to cleanse field value

2012-12-19 Thread Massimo Di Pierro
Here is a custom validator that replaces '-' with '_' class MyValidator(obejct): def __call__(self,value): return (value.replace('-','_'), None) Field(..., requires=MyValidator()...) On Wednesday, 19 December 2012 16:54:21 UTC-6, wwwgong wrote: > > I thought validator only validates

[web2py] Re: Limits on controller names?

2012-12-19 Thread Wes Hall
Packing and reinstalling the application solved the problem. Any clues as to what might've happened? On Wednesday, December 19, 2012 4:59:52 PM UTC-5, Wes Hall wrote: > > I was successfully working with a controller 'b.py'. > > I am no longer able to use the included editor to edit this controll

[web2py] Re: hello3.xml question

2012-12-19 Thread villas
This may help... In db.py: response.generic_patterns = ['*.xml'] See this: http://web2py.com/books/default/chapter/29/10#Generic-views On Wednesday, December 19, 2012 10:31:58 PM UTC, Derek wrote: > > Yeah, I got the same issue as you. I have a site called 'customers2' and a > controller 'cu

[web2py] Re: Webassets in web2py

2012-12-19 Thread Arnon Marcus
The auto-compile is just calling the JavaScript-based compiler on the code when the file is saved... Doesn't sound like a lot to implement for a plugin... Maybe there are even things one can wire manually in some IDEs, like binding the save short-key to a macro that runs a command line in the b

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2012-12-19 Thread paolo.vall...@gmail.com
Hi I was trying with the script that comes with the stable web2py. with the one on dropbox I problem has gone. Paolo 2012/12/19 Niphlod > > @Simone, an other improvement to the script could be to combine into a >> single server the 80, and 443 to avoid duplicating configuration, as stated >> h

[web2py] Re: web2py 2.3.2 is OUT

2012-12-19 Thread Derek
clicking the 'demo' links, all the demo sites look like crap and have serious issues with navigation. http://web2py.com/demo_app1/default/index clicking on the 'categories' - nothing happens. http://web2py.com/demo_app2/default/index once again, clicking on the 'categories' does nothing, and hov

[web2py] Re: The book updates and status

2012-12-19 Thread Massimo Di Pierro
I have been going over that document. The things in gray were not in the published 4th edition but are in the online version. I also have this file: https://github.com/mdipierro/web2py-book/blob/master/sources/29-web2py-english/README things checked [x] were not in the published 4th edition but

Re: [web2py] how to cleanse field value

2012-12-19 Thread wwwgong
I thought validator only validates, can you show me how to update field with the sanitized value. Thanks, On Wednesday, December 19, 2012 9:57:48 AM UTC-5, viniciusban wrote: > > Try a custom validator to sanitize your description field. > > > On Wed, Dec 19, 2012 at 12:06 PM, wwwgong > > wrote

Re: [web2py] Re: Graph Model (proposal to contribute)

2012-12-19 Thread Massimo Di Pierro
Not yet. It is the queue. On Wednesday, 19 December 2012 09:49:04 UTC-6, Ramos wrote: > > Is this in trunk? > > > > 2012/12/16 Ovidio Marinho > > >> Very Well Jose. >> >> >> >>Ovidio Marinho Falcao Neto >> Web Developer >> ovid...@gmail.com >>

[web2py] Getting Apache 2.4 to work on Suse Linux

2012-12-19 Thread Andrew W
Hi all, Just a note on Apache that may help others: I've battled for days with getting web2py working with apache (2.4) on a Suse linux server. I kept on getting Forbidden errors. I eventually stumbled onto the "Require all granted" statement - once I added this then everything works fine.

[web2py] Re: hello3.xml question

2012-12-19 Thread Derek
Yeah, I got the same issue as you. I have a site called 'customers2' and a controller 'customer' and a function 'index' - when i add a '.xml' onto 'index' i get this: invalid view (customer/index.xml) On Wednesday, December 19, 2012 2:38:36 PM UTC-7, lucas wrote: > > hello one and all, > > i am

Re: [web2py] Re: help please

2012-12-19 Thread Derek
The data is gone. Let this be a reminder to all of you out there, back up your data and back it up often. Also, it's not backed up if you can't restore it, so test out restores as well. On Wednesday, December 19, 2012 9:08:47 AM UTC-7, LightDot wrote: > > First, make a couple of physical copies

[web2py] Re: The book updates and status

2012-12-19 Thread Andrew W
The #1 thing I am waiting on is the addition of auth.wiki. On Thursday, December 20, 2012 9:15:46 AM UTC+13, Anthony wrote: > > This document is a bit old, so some of the items may already have been > added: > https://docs.google.com/document/d/1yQy0F5HcxiecBOBLblrLmAAAsAK6sL37wSL527yssGk/edit >

[web2py] Limits on controller names?

2012-12-19 Thread Wes Hall
I was successfully working with a controller 'b.py'. I am no longer able to use the included editor to edit this controller. Attempting to access the controller results in a never-ending attempt to load. Suspecting the file contents, I renamed the controller and .bak to c.py and c.py.bak (the

Re: [web2py] Re: impersonate and 2.3.2

2012-12-19 Thread Martin Weissenboeck
it's ok now - thank you! 2012/12/19 Massimo Di Pierro > Fixed in trunk. Please check it. > > > On Wednesday, 19 December 2012 09:52:52 UTC-6, mweissen wrote: >> >> @auth.requires_login() >> @auth.requires_permission('**impersonate','auth_user') >> def imitieren_id(): >> auth.impersonate(requ

[web2py] hello3.xml question

2012-12-19 Thread lucas
hello one and all, i am trying to understand the hello3 function under simple_examples and i don't understand adding .xml to the url directs web2py to convert it into an xml doc instead of the default html file when the .xml is not included in the url. i tried adding .xml to a few of my html r

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2012-12-19 Thread Richard Vézina
Agree... Richard On Wed, Dec 19, 2012 at 2:59 PM, Niphlod wrote: > ry the script found at the dropbox link. If the same error happens I th --

[web2py] Re: The book updates and status

2012-12-19 Thread Anthony
This document is a bit old, so some of the items may already have been added: https://docs.google.com/document/d/1yQy0F5HcxiecBOBLblrLmAAAsAK6sL37wSL527yssGk/edit Anthony On Wednesday, December 19, 2012 12:11:55 PM UTC-5, Massimo Di Pierro wrote: > > It would help me if people could add to this

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2012-12-19 Thread Niphlod
> @Simone, an other improvement to the script could be to combine into a > single server the 80, and 443 to avoid duplicating configuration, as stated > here : > > http://nginx.org/en/docs/http/configuring_https_servers.html#single_http_https_server > I don't had test this. > > Also, here the c

Re: [web2py] Re: REF: SQLFORM.grid column width and content length

2012-12-19 Thread Teddy Nyambe
Very! thanx buddy! On Dec 19, 2012 9:48 PM, "Niphlod" wrote: > db.define_table('testtable' > Field('averylongtext', length=256) > ) > > grid = SQLFROM.grid(db.testtable, maxtextlenghts={ > 'testtable.averylongtextfield' : 256}) > > > > Clearer ? > > On Wednesday, December 19, 2012 7:04:29 PM

[web2py] Re: Webassets in web2py

2012-12-19 Thread Niphlod
so develop web2py in VS and not in the integrated admin interface :P I was referring to the fact that there is no python compiler for typescript (other IDE "advertised" have only the syntax highlight feature, not the auto-compile feature) On Wednesday, December 19, 2012 5:40:31 PM UTC+1, Arnon

Re: [web2py] Re: REF: SQLFORM.grid column width and content length

2012-12-19 Thread Niphlod
db.define_table('testtable' Field('averylongtext', length=256) ) grid = SQLFROM.grid(db.testtable, maxtextlenghts={ 'testtable.averylongtextfield' : 256}) Clearer ? On Wednesday, December 19, 2012 7:04:29 PM UTC+1, software.ted wrote: > > Can you show an example on how that dictionary is p

[web2py] Re: Scheduler tasks stuck in ASSIGNED state

2012-12-19 Thread Niphlod
yep, I started with "sorry" because I can't reproduce with the newer one and the older one. But let me (us) know as soon as logs are filled. On Wednesday, December 19, 2012 7:52:44 PM UTC+1, JimK wrote: > > I'll give it a try with debug mode later this afternoon and send along the > logs. > > I'

[web2py] Re: Scheduler tasks stuck in ASSIGNED state

2012-12-19 Thread JimK
I'll give it a try with debug mode later this afternoon and send along the logs. I'm certain that there's a real bug here and not user error as I tested it quite thoroughly from a blackbox perspective (I didn't know how to turn on logging, doh!). Again, with all other criteria being equal, swi

[web2py] Re: web2py book now free in PDF

2012-12-19 Thread Lewis
Nice! --

[web2py] Re: The book updates and status

2012-12-19 Thread Massimo Di Pierro
One more thing is important. Please check the page: http://web2py.com/examples/default/who.html If you have contributed and your name is not there or you are there but your work is not properly represented please email me. DO NOT BE SHY. I need the names in the book acknowledgement page. Massi

[web2py] Re: edit a record does not show uploaded files

2012-12-19 Thread António Ramos
read the source luke!!! in sqlform, add upload=URL('download') Thanks António 2012/12/19 António Ramos > hello this is my controller > > def edittrab(): > record = db.trabalhador(request.args(0)) or redirect(URL('index')) > form = SQLFORM(db.trabalhador, record) > if form.accepts(r

Re: [web2py] Re: bootstrap themes generator

2012-12-19 Thread António Ramos
i downloaded web2py from trunk and copied my code to a new app 2012/12/18 Vinicius Assef > What was the problem? How did you solve it? > > > > On Tue, Dec 18, 2012 at 3:19 PM, António Ramos > wrote: > > Done.thank you. > > > > 2012/12/18 Vinicius Assef > >> > >> Well, if you started your app

Re: [web2py] Re: Graph Model (proposal to contribute)

2012-12-19 Thread António Ramos
Is this in trunk? 2012/12/16 Ovidio Marinho > Very Well Jose. > > > >Ovidio Marinho Falcao Neto > Web Developer > ovidio...@gmail.com > ovidiomari...@itjp.net.br > ITJP - itjp.net.br >83 8826 9088 - Oi >

[web2py] edit a record does not show uploaded files

2012-12-19 Thread António Ramos
hello this is my controller def edittrab(): record = db.trabalhador(request.args(0)) or redirect(URL('index')) form = SQLFORM(db.trabalhador, record) if form.accepts(request.vars, session): response.flash = 'registo actualizado com sucesso' redirect(URL()) elif form

[web2py] Re: Login manually

2012-12-19 Thread Wonton
Yes, of course. This is my ticket: Error ticket for "dianaappv1" Ticket ID 127.0.0.1.2012-12-19.18-24-12.5d2b292c-7e9a-4281-a9f7-bb9aa17bbd0c unsupported hash type |pbkdf2(1000,20,sha512) Versión web2py™ (2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable') Python Python 2.7.1: /u

Re: [web2py] Re: REF: SQLFORM.grid column width and content length

2012-12-19 Thread Teddy Nyambe
Can you show an example on how that dictionary is passed to the grid? On Dec 19, 2012 3:18 PM, "Niphlod" wrote: > By default, maxtextlength is 20. maxtextlength=150 will truncate all > columns only if they are longer than 150 chars. > > maxtextlength*s* instead allows to pass a dictionary of > {'

[web2py] Re: impersonate and 2.3.2

2012-12-19 Thread Massimo Di Pierro
Fixed in trunk. Please check it. On Wednesday, 19 December 2012 09:52:52 UTC-6, mweissen wrote: > > @auth.requires_login() > @auth.requires_permission('impersonate','auth_user') > def imitieren_id(): > auth.impersonate(request.args[0]) > redirect(URL('index')) > > This is the function

Re: [web2py] Re: No module named plural_rules, end emtpy db in DAL connection

2012-12-19 Thread Massimo Di Pierro
The warning comes from the internationalization. By importing from gluon it expects that you are in the web2py folder and it will try preload pluralization rules. Try instead: from gluon.dal import DAL, Field On Wednesday, 19 December 2012 09:27:51 UTC-6, Kostas M wrote: > > Thank you both, fo

[web2py] Re: change id?

2012-12-19 Thread Massimo Di Pierro
Even if possible this may break web2py. On Wednesday, 19 December 2012 06:00:35 UTC-6, Aurelijus Useckas wrote: > > is it possible to change row id or null it so it starts sequential counting > starting from 0? > > thank you > --

[web2py] Re: The book updates and status

2012-12-19 Thread Massimo Di Pierro
It would help me if people could add to this thread some comments about: - what needs clarification? - what is poorly undocumented? - what do you expect in the 5th edition? Please when making comments refers to the online english version. Massimo On Wednesday, 19 December 2012 03:11:37 UTC-6, And

[web2py] Re: Customizing auth login form but unable to set the form class name

2012-12-19 Thread Anthony
form['_class'] = 'myclass' or form.update(_class='myclass') A form is an HTML helper object, just like any other HTML helper, so the usual rules apply: http://web2py.com/books/default/chapter/29/05#HTML-helpers Anthony On Tuesday, December 18, 2012 11:33:32 PM UTC-5, Bhaskar Ramachandran wro

[web2py] Re: Login manually

2012-12-19 Thread Massimo Di Pierro
Can you please show me the complete traceback? I cannot reproduce this and I this error is not generated from a web2py function. On Tuesday, 18 December 2012 11:11:51 UTC-6, Massimo Di Pierro wrote: > > Can I see you models? Are you changing the validator for > db.auth_user.password? > Your erro

[web2py] Re: Webassets in web2py

2012-12-19 Thread Arnon Marcus
Hmmm, not exactly. You CAN use node for/with it, but there are also IDE plugins. I'm using Visual Studio 2012 (trial) and it compiles-on-save automatically, with a side-by-side updating javascript target file view. that is being generated as I save. All the material needed to make such a plugin

Re: [web2py] Re: Edit or delete not committing in sqlform.grid for custom query

2012-12-19 Thread Mandar Vaze / मंदार वझे
I know it is a tough one, but can you guess what "could" be the problem ? As I mentioned, "explicitly" adding db.commit() helps "resolve" the problem (Whether in gluon/sqlhtml.py or separately in my custom ondelete) Does that give you any hints ? I debugged but (obviously) couldn't find the culpri

[web2py] Re: default/user/profile onaccept ?

2012-12-19 Thread Annet
Massimo, Thanks for your reply, problem solved. Kind regards, Annet --

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2012-12-19 Thread Richard Vézina
@Paolo, I don't see dist-upgrade anymore you should have a wrong version look at the drop box of Simone Niphold : https://www.dropbox.com/s/n7chteos9sh6p2h/setup-web2py-nginx-uwsgi-ubuntu.sh @Arnon, I don't know bitnami I heard about, but didn't have a look, but I guest it will not works because u

Re: [web2py] Re: help please

2012-12-19 Thread LightDot
First, make a couple of physical copies of the database and do not write into it anymore. Then, working on a copy, you could try restoring / extracting the data by using forensic tools, etc. I'm not aware of a straightforward sqlite restore tool, but there might be one or two out there... I'm s

Re: [web2py] Re: help please

2012-12-19 Thread Paolo Caruccio
Mine is a very stupid question but sometime... Is there an "active" field in your db tables? Il giorno mercoledì 19 dicembre 2012 16:54:50 UTC+1, Aurelijus Useckas ha scritto: > > Yeah I know.. I have an old backup only :( me bad > > > On Wed, Dec 19, 2012 at 5:51 PM, Mark >wrote: > >> Do you h

Re: [web2py] Re: help please

2012-12-19 Thread Aurelijus
Yeah I know.. I have an old backup only :( me bad On Wed, Dec 19, 2012 at 5:51 PM, Mark wrote: > Do you have any kind of backup files for the database? Or, do your > server/computer backup daily or weekly? If there are any backup files, you > can restore the deleted data easily. > > Mark > > >

[web2py] impersonate and 2.3.2

2012-12-19 Thread Martin Weissenboeck
@auth.requires_login() @auth.requires_permission('impersonate','auth_user') def imitieren_id(): auth.impersonate(request.args[0]) redirect(URL('index')) This is the function "imitieren_id" for impersonate. I think (but I am not sure) yesterday there has been no problem, but today (after up

[web2py] Re: help please

2012-12-19 Thread Mark
Do you have any kind of backup files for the database? Or, do your server/computer backup daily or weekly? If there are any backup files, you can restore the deleted data easily. Mark On Wednesday, December 19, 2012 8:21:27 AM UTC-5, Aurelijus Useckas wrote: > > I've deleted user information f

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2012-12-19 Thread Paolo
Hi all, I've just tried to run the script on a VM (ubuntu 12.04.1). The compilation of uwsgi failed: *** uWSGI linking *** gcc -pthread -o /usr/local/bin/uwsgi core/utils.o core/protocol.o core/socket.o core/logging.o core/master.o core/master_utils.o core/emperor.o core/notify.o core/mule.o

Re: [web2py] Re: No module named plural_rules, end emtpy db in DAL connection

2012-12-19 Thread Kostas M
Thank you both, for the heads up! As Niphlod have said at: https://groups.google.com/forum/#!searchin/web2py/auto_import=True/web2py/bwCYiQcE59I/D1IkGFC55eEJ * Remember that DAL does NOT introspect databases.* Any hints on the Warning? --

Re: [web2py] Re: help please

2012-12-19 Thread Aurelijus
I've tried Sqlite database browser. Same results.. but still it's strange, records are really there On Wed, Dec 19, 2012 at 5:22 PM, Niphlod wrote: > did you try with some app that has sqlite support such as sqliteman or the > sqlite3 command line ? I hardly doubt that if sqlite3 commandline ca

Re: [web2py] Re: help please

2012-12-19 Thread Niphlod
did you try with some app that has sqlite support such as sqliteman or the sqlite3 command line ? I hardly doubt that if sqlite3 commandline can't fetch your records, what you're seeing with VIM is your actual records Il giorno mercoledì 19 dicembre 2012 16:12:31 UTC+1, Aurelijus Useckas ha

Re: [web2py] Re: help please

2012-12-19 Thread Aurelijus
Thanks Niphlod for supporting me on this one. The problem is that appadmin doesn't see any records but if I'm accessing the same storage.sqlite db with VIM or even word processor, I can still see all the data in there, it's just that something doesn't allow appadmin or sqlite viewer to see it.. I

[web2py] Re: Webassets in web2py

2012-12-19 Thread Niphlod
anoher node.js dependancy ^_^ Il giorno mercoledì 19 dicembre 2012 15:53:45 UTC+1, Arnon Marcus ha scritto: > > I'm starting to fall in love with TypeScript... > > http://www.youtube.com/watch?v=3dqZW_DqHIQ > > On Tuesday, December 18, 2012 1:21:33 AM UTC+2, Arnon Marcus wrote: >> >> That sounds

[web2py] Re: help please

2012-12-19 Thread Niphlod
do you see them in appadmin ? if yes, then it's a no-issue: the data is there but I'm not sure what are you pointing to saying "*all my data (from other table views) disapears*" . If it's not there in appadmin but you see the records on sqlite with some other tool, than you're app is using a di

[web2py] Re: Edit or delete not committing in sqlform.grid for custom query

2012-12-19 Thread Niphlod
> > > Can't. Anyway, I'm pasting some relevant code below. BTW, if it matters, I > started the development with 2.0.x and upgrade just the web2py code to > current stable release i.e. After I upgrade web2py I do not go by to my > application and make any changes (like web2py.css or any other)

Re: [web2py] Re: No module named plural_rules, end emtpy db in DAL connection

2012-12-19 Thread Vinicius Assef
In other words (concerning missing tables), you must have define_table() calls or auto_import=True in your DAL instantiation. Otherwise, your db object won't recognize your tables. On Wed, Dec 19, 2012 at 12:43 PM, Niphlod wrote: > if you don't define table and you don't have auto_import=True,

Re: [web2py] how to cleanse field value

2012-12-19 Thread Vinicius Assef
Try a custom validator to sanitize your description field. On Wed, Dec 19, 2012 at 12:06 PM, wwwgong wrote: > Hi, > I like to store youtube videos into a table: > > db.define_table('youtube', > Field('code'), > Field('description') > ) > > def youtube_repr(code,width=400,height=250):

[web2py] Re: Webassets in web2py

2012-12-19 Thread Arnon Marcus
I'm starting to fall in love with TypeScript... http://www.youtube.com/watch?v=3dqZW_DqHIQ On Tuesday, December 18, 2012 1:21:33 AM UTC+2, Arnon Marcus wrote: > > That sounds very cool, thanks for the detailed answered, this makes my > head a little calmer now... > > BTW, I actually DID mean cof

[web2py] Re: No module named plural_rules, end emtpy db in DAL connection

2012-12-19 Thread Niphlod
if you don't define table and you don't have auto_import=True, why are you expecting db.tables to show something ? Il giorno mercoledì 19 dicembre 2012 15:11:51 UTC+1, Kostas M ha scritto: > > Trying to use DAL in my functional_tests.py (sitting in the application > directory), I get the followi

[web2py] No module named plural_rules, end emtpy db in DAL connection

2012-12-19 Thread Kostas M
Trying to use DAL in my functional_tests.py (sitting in the application directory), I get the following warning: In [1]: from gluon import DAL WARNING:root:Unable to import plural rules: No module named plural_rules Furthermore, the db seems to be empty, although it has proper tables, as seen b

[web2py] Re: Edit or delete not committing in sqlform.grid for custom query

2012-12-19 Thread Mandar Vaze
On Wednesday, December 19, 2012 3:24:31 PM UTC+5:30, Niphlod wrote: > > I can't reproduce the issue. I know it is a bit tough one. Even I too wasn't able to pinpoint the exact problem. I debugged till the dal.py as well. Not sure when does the db.commit() get called. > Can you post a pack

[web2py] how to cleanse field value

2012-12-19 Thread wwwgong
Hi, I like to store youtube videos into a table: db.define_table('youtube', Field('code'), Field('description') ) def youtube_repr(code,width=400,height=250): return XML(""" http://www.youtube.com/v/%(code)s&hl=en_US&fs=1&"> http:/

[web2py] Re: help please

2012-12-19 Thread Aurelijus Useckas
but I can see the records inside the storage.sqlite file, so they must be accessible somehow On Wednesday, December 19, 2012 3:51:37 PM UTC+2, Niphlod wrote: > > I said *messed up* just to use part of your sentence. > With referenced table, if you used the default ondelete attribute of the > fie

[web2py] Re: help please

2012-12-19 Thread Niphlod
I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every "child" record gets deleted as soon as the "parent" is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqli

[web2py] Re: help please

2012-12-19 Thread Aurelijus Useckas
is there any way to extract data from sqlite? The file is still full of data... I don't understand, if you delete somthing that is linked, everything messes up? On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: > > definitely messed up. no way they will "return back". That's why

[web2py] Re: help please

2012-12-19 Thread Niphlod
definitely messed up. no way they will "return back". That's why referenced tables are for. Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha scritto: > > i'm on SQLite > > On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: >> >> I've deleted user

[web2py] Re: help please

2012-12-19 Thread Aurelijus Useckas
i'm on SQLite On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas wrote: > > I've deleted user information from auth_users and suddenly all my data > (from other table views) disapears.. Yes, other tables are linked to this > one. Specifically for info on updates and simillar...

[web2py] help please

2012-12-19 Thread Aurelijus Useckas
I've deleted user information from auth_users and suddenly all my data (from other table views) disapears.. Yes, other tables are linked to this one. Specifically for info on updates and simillar... If I restore the same data in auth_users other table still doesn't show anything... I event rese

[web2py] Re: REF: SQLFORM.grid column width and content length

2012-12-19 Thread Niphlod
By default, maxtextlength is 20. maxtextlength=150 will truncate all columns only if they are longer than 150 chars. maxtextlength*s* instead allows to pass a dictionary of {'tablename.field' : length} to set this limit for every column. Il giorno mercoledì 19 dicembre 2012 13:24:04 UTC+1, sof

Re: [web2py] change id?

2012-12-19 Thread Aurelijus Useckas
I''m using an SQlite btw. autoincrement resets with this command: print db.executesql('UPDATE SQLITE_SEQUENCE SET seq = 0 WHERE name = \'auth_user\'') On Wednesday, December 19, 2012 2:20:49 PM UTC+2, viniciusban wrote: > > I think it depends on you RDBMS. > > > On Wed, Dec 19, 2012 at 10:00 A

Re: [web2py] Re: Aren't we not able to translate SQLFORM.grid buttons?

2012-12-19 Thread Tito Garrido
Thanks! On Tue, Dec 18, 2012 at 11:28 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Yes, that was missing. I now added it. > > > On Tuesday, 18 December 2012 16:23:02 UTC-6, Tito Garrido wrote: >> >> Hi Folks! >> >> I am trying to find the 'Add' string on the translation file but

[web2py] Re: how to hide a field until another field is chosen using SQLFORM.smartgrid

2012-12-19 Thread Jose
El martes, 11 de diciembre de 2012 21:50:07 UTC-3, JimK escribió: > > I have a table defined with many columns but some are only relevant if a > previous one is chosen. How would I hide a field like this > with SQLFORM.smartgrid? > > model: > db.define_table('t_schedule_frat_query', > Field('f

[web2py] REF: SQLFORM.grid column width and content length

2012-12-19 Thread Teddy Nyambe
Hi, I have noticed SQLFORM.grid column content is not wraping if its long instead the content is cut and three dots (...) are appended to the content. How do i allow more text to be displayed or adjust the width of the grid? Teddy L. --

Re: [web2py] change id?

2012-12-19 Thread Vinicius Assef
I think it depends on you RDBMS. On Wed, Dec 19, 2012 at 10:00 AM, Aurelijus Useckas wrote: > is it possible to change row id or null it so it starts sequential counting > starting from 0? > > thank you > > -- > > > --

[web2py] change id?

2012-12-19 Thread Aurelijus Useckas
is it possible to change row id or null it so it starts sequential counting starting from 0? thank you --

[web2py] Re: Edit or delete not committing in sqlform.grid for custom query

2012-12-19 Thread Niphlod
I can't reproduce the issue. Can you post a packed application showing the problem ? Both edit and deleteare working fine for me, either with a custom query or a table name. On Wednesday, December 19, 2012 10:40:58 AM UTC+1, Mandar Vaze wrote: > > Problem still persists in 2.3.2 > > On Tuesday,

[web2py] Re: Multiple or in where clause using dal

2012-12-19 Thread Rocco
Thank you! Il giorno mercoledì 19 dicembre 2012 10:41:33 UTC+1, Niphlod ha scritto: > > db(db.table.id.belongs(myset)).select() > > >> --

[web2py] Re: Multiple or in where clause using dal

2012-12-19 Thread Niphlod
db(db.table.id.belongs(myset)).select() Il giorno mercoledì 19 dicembre 2012 10:07:33 UTC+1, Rocco ha scritto: > > Dear all, > > I need to extract multiple records from a table, the number of selected > records is variable (from 1 to hundreds). > > The user form returns a list of selected ids, f.

[web2py] Re: Edit or delete not committing in sqlform.grid for custom query

2012-12-19 Thread Mandar Vaze
Problem still persists in 2.3.2 On Tuesday, October 9, 2012 6:05:08 AM UTC+5:30, Derek wrote: > > did you open an issue? > http://code.google.com/p/web2py/issues/list > Done. http://code.google.com/p/web2py/issues/detail?id=1234 -Mandar --

[web2py] Re: Scheduler tasks stuck in ASSIGNED state

2012-12-19 Thread Niphlod
sorry, just tried, can't reproduce the issue. Can you post the logs of the schedulers ? Maybe start them adding *-D 0* to activate the DEBUG level What normally goes on is: - you start "dir", it's the first one so it becomes the "TICKER", but it doesn't see any "metrics" worker so it doesn't assi

Re: [web2py] Re: tuple to gluon.dal.Rows conversion

2012-12-19 Thread Muhammad Atif Ayaz
Thanks a lot for a very useful tip Regards On Tue, Dec 18, 2012 at 9:18 PM, Anthony wrote: > t will automatically convert the res --

[web2py] Re: The book updates and status

2012-12-19 Thread Andrew W
Just checking in on how the 5th edition is going ? Thanks On Thursday, November 29, 2012 11:58:29 PM UTC+13, Kostas M wrote: > > I have bought the (printed) web2py book (editions 3rd and 4th) from Lulu, > and my note is that the black & white printouts are much less attractive > from > the web c

[web2py] Multiple or in where clause using dal

2012-12-19 Thread Rocco
Dear all, I need to extract multiple records from a table, the number of selected records is variable (from 1 to hundreds). The user form returns a list of selected ids, f.e.: myset=[1,15,22,44,56] In the raw sql way, I used a for loop to generate the where clause of the sql statement, to get

Re: [web2py] Re: RFC: web2py-based workflow engine

2012-12-19 Thread Andrew W
Does anyone know if there has been any progress on this ? Hello Ross ? On Tuesday, September 25, 2012 1:52:46 AM UTC+12, Ramos wrote: > > Same question here > Ross, > How's the workflow engine going ? > > Cheers > António > > 2012/7/6 Andrew > > >> Hi Ross, >> How's the workflow engine going ?

[web2py] Re: Script for nginx/uWSGI/web2py install on Webfaction

2012-12-19 Thread Neil
Yup, it works, but I think I left out a key step. In more detail: - In the webfaction control panel, set up two different applications. one is a "custom" type, and one is a "static" type. - Put a link from the static folder under the web2py application to the static application's home folder - I