[web2py] Re: Exposing validators as JSON?

2013-01-20 Thread Bill Thayer
On Sunday, January 20, 2013 11:52:59 PM UTC-6, Bill Thayer wrote: > > Borrowing code from SQLFORM.dictform I think I'm close to rendering nested > dicts dumped from json: > > The browser is simply writing a bunch of the > received an error saying: > Generator expression must be parenthesized

[web2py] Re: Exposing validators as JSON?

2013-01-20 Thread Bill Thayer
Borrowing code from SQLFORM.dictform I think I'm close to rendering nested dicts dumped from json: The browser is simply writing a bunch of the

[web2py] How to update web app on server without change the data already in database

2013-01-20 Thread animnook
I have a web app on server and I use web2py web interface to update the project file. But the users wants to add data in db while I am still working on other part of the app. as right now I just copy and paste everything in controller file local to server. and upload whatever new pages I create.

[web2py] Re: smartgrid - display linked_tables link as a dropdown button instead

2013-01-20 Thread Simon Ashley
My original post hasn't turned up yet, so this may be a duplicate. There was an earlier request (last year) by Massimo, with code written by Martin Mulone to address the dropdown button issue. It may have slipped through the system and never implemented. https://groups.google.com/forum/#!search

[web2py] Re: json validation

2013-01-20 Thread Bill Thayer
Thank you, My revised function looks like this: def json_parameters(param_names): """takes an array of parameter names which are attributes to a design cell then looks up the default value and unit in the attributes table and returns an array of json dictionary objects to be inserted

[web2py] Re: Bug: Query with Expression that contains comma and space within

2013-01-20 Thread Ignacio Ocampo
Massimo, I see the problem, in my dal.py in _select function: def _select(self, query, fields, attributes): tables = self.tables for key in set(attributes.keys())-SELECT_ARGS: raise SyntaxError, 'invalid select attribute: %s' % key args_get = attributes.get

Re: [web2py] Re: PowerFormWizard 0.1.4 - Bug Fixes and auto_validation (+ a new plugin for grids)

2013-01-20 Thread Bruno Rocha
Ok, problem fixed Updated here: https://bitbucket.org/rochacbruno/powerformwizard/downloads Live example here: http://www.web2pyslices.com/formwizard --

[web2py] Re: Exposing validators as JSON?

2013-01-20 Thread Bill Thayer
Hi Alan, Thank you for your work on the json data type. (Sorry for getting your name wrong in my other post). These discussions are great for thinking through my problem. Yes I would need to post json data into the database and also search the data, display and edit it also. My app is just one

[web2py] Re: problems with wiki create

2013-01-20 Thread Alan Etkin
> > Hi all, I've just updated web2py to trunk and it seems that wiki _create >> is broken. I got this ticket: >> > I'll open an issue (I found a possible patch) --

[web2py] Re: problems with wiki create

2013-01-20 Thread Alan Etkin
> > Hi all, I've just updated web2py to trunk and it seems that wiki _create > is broken. I got this ticket: > This is a new bug related to wiki template validation after re-enabling templates (I think the problem is with the IS_IN_DB validator arguments in the Wiki class) Does it fail withou

Re: [web2py] Re: PowerFormWizard 0.1.4 - Bug Fixes and auto_validation (+ a new plugin for grids)

2013-01-20 Thread António Ramos
I´m testing the web2py.app.PFWExample.w2p at https://bitbucket.org/rochacbruno/powerformwizard/downloads and got this error Traceback (most recent call last): File "C:\web2pyGit\web2py\gluon\restricted.py

[web2py] problems with wiki create

2013-01-20 Thread Paolo valleri
Hi all, I've just updated web2py to trunk and it seems that wiki _create is broken. I got this ticket: Traceback (most recent call last): File "/home/paolo/Dropbox/git/web2py/gluon/restricted.py", line 212, in restricted exec ccode in environment File "/home/paolo/Dropbox/git/web2py/app

[web2py] Re: 'DAL' object has no attribute 'auth_wiki' - trunk version

2013-01-20 Thread Bill Thayer
Yes. working now. Thanks. On Friday, January 18, 2013 9:28:27 AM UTC-6, Alan Etkin wrote: > > Working on trying out the json support but db won't get past this error. > > > Fixed in trunk. Please check it works for you (it did for me) > --

Re: [web2py] Re: auth.wiki doesn't find pages without tags

2013-01-20 Thread Massimo Di Pierro
This opens a can of worms. We cannot efficiently check if the user has access before selecting the page. So the solution as a compromise. We allow searching for all page but content is only shown if user is allowed. massimo On Sunday, 20 January 2013 14:45:18 UTC-6, Alan Etkin wrote: > > > Sho

[web2py] Re: Bug: Query with Expression that contains comma and space within

2013-01-20 Thread Massimo Di Pierro
I cannot reproduce. Can you post the model? On Sunday, 20 January 2013 14:43:58 UTC-6, Ignacio Ocampo wrote: > > When I use custom expression, that contains comma within, it fails if I > use an space after comma. > > *Example 1* > --- WORKS --- > query = ac(tickets.id>0).select(tickets.name, tick

[web2py] Re: Bug: Query with Expression that contains comma and space within

2013-01-20 Thread Massimo Di Pierro
On Sunday, 20 January 2013 14:43:58 UTC-6, Ignacio Ocampo wrote: > > When I use custom expression, that contains comma within, it fails if I > use an space after comma. > > *Example 1* > --- WORKS --- > query = ac(tickets.id>0).select(tickets.name, tickets.created_on, > "DATEDIFF(tickets.create

Re: [web2py] Re: auth.wiki doesn't find pages without tags

2013-01-20 Thread Alan Etkin
> Should all pages be searchable? If a user cannot read a wiki page, he shouldn't get the slug in results either, I suppose --

[web2py] Bug: Query with Expression that contains space within

2013-01-20 Thread Ignacio Ocampo
When I use custom expression, that contains comma within, it fails if I use an space after comma. *Example 1* --- WORKS --- query = ac(tickets.id>0).select(tickets.name, tickets.created_on, "DATEDIFF(tickets.created_*on,N*OW())") colnames=['tickets.name', 'tickets.created_on', 'DATEDIFF(tickets.

Re: [web2py] Re: auth.wiki doesn't find pages without tags

2013-01-20 Thread Massimo Di Pierro
You can find them using the manage pages option. That allows the editors and authors to search by title or content. The problem is about the public search pages. Should all pages be searchable? Without fill text search we can use belong but it may be slow. On Sunday, 20 January 2013 12:58:28 UT

[web2py] Re: LinuxJournal web development poll

2013-01-20 Thread Massimo Di Pierro
I guess none of us are... or they are not. On Sunday, 20 January 2013 12:45:19 UTC-6, rif wrote: > > Thanks Ron, the main point I was trying to make is that it seems that I am > not main stream :) > > duminică, 20 ianuarie 2013, 19:42:56 UTC+2, Ron McOuat a scris: >> >> You can write in your pref

[web2py] Re: Query, COUNT and SUM with custom Expression

2013-01-20 Thread Ignacio Ocampo
Thank you Massimo! Regards. On Sunday, January 20, 2013 2:22:34 PM UTC-6, Massimo Di Pierro wrote: > > Doh! Fixed in trunk. Thanks for reporting this was a serious issue. > > On Sunday, 20 January 2013 12:27:41 UTC-6, Ignacio Ocampo wrote: >> >> I'm working with a custom Query, I need use SUM and

[web2py] Re: Query, COUNT and SUM with custom Expression

2013-01-20 Thread Massimo Di Pierro
Doh! Fixed in trunk. Thanks for reporting this was a serious issue. On Sunday, 20 January 2013 12:27:41 UTC-6, Ignacio Ocampo wrote: > > I'm working with a custom Query, I need use SUM and COUNT together, when I > use: > > select(db.field.count(), db.field.sum()) works OK > > But when I use: > >

[web2py] Re: BEAUTIFY broken in trunk

2013-01-20 Thread Massimo Di Pierro
think this is now fixed in trunk. I accidentally committed an experiment in html.py. On Saturday, 19 January 2013 16:55:50 UTC-6, DenesL wrote: > > > That confirms my original suspicion, rev.4631, up to Massimo now. > > > On Saturday, January 19, 2013 4:50:40 PM UTC-5, Alan Etkin wrote: >> >> >

Re: [web2py] Re: auth.wiki doesn't find pages without tags

2013-01-20 Thread Vinicius Assef
On Fri, Jan 18, 2013 at 5:42 PM, Massimo Di Pierro wrote: > The issue to be considered is that this will not work on Google App Engine > and it may considerable slow down searches for many wiki pages. Massimo, I think there's another issue, because Auth.wiki() allows me to save a page without any

[web2py] Re: Exposing validators as JSON?

2013-01-20 Thread Alan Etkin
> > would a 'json:reference mytable' field type similar to 'list:reference > mytable' or perhaps a format=lambda row: row.json() be possible? > What would be the enhancement required specifically? Do you need to PUT/POST json data into a DAL database with a service? If you need to return the

[web2py] Re: LinuxJournal web development poll

2013-01-20 Thread rif
Thanks Ron, the main point I was trying to make is that it seems that I am not main stream :) duminică, 20 ianuarie 2013, 19:42:56 UTC+2, Ron McOuat a scris: > > You can write in your preference under Other, a text box opens when it is > selected. > > On Sunday, 20 January 2013 01:38:31 UTC-8, r

[web2py] Query, COUNT and SUM with custom Expression

2013-01-20 Thread Ignacio Ocampo
I'm working with a custom Query, I need use SUM and COUNT together, when I use: select(db.field.count(), db.field.sum()) works OK But when I use: select('COUNT(*)', 'SUM(DATEDIFF(table.field,NOW()))') raise an error I see that I can't combine more that 1 custom expressions. Any idea? --

[web2py] Re: LinuxJournal web development poll

2013-01-20 Thread Ron McOuat
You can write in your preference under Other, a text box opens when it is selected. On Sunday, 20 January 2013 01:38:31 UTC-8, rif wrote: > > http://m.linuxjournal.com/content/web-development-poll > > Most of my prefernces were not listed... > --

[web2py] Re: Probably the best Slice ever published! Save the Earth from a total data mess with MongoDBAdapter

2013-01-20 Thread Alan Etkin
> > This Slice is excellence, not only for the purpose but specially because > the way it was written! > Time for "Hacking Movu.ca before you can say lumberjack" (or whatever) web2pyslices article perhaps? --

[web2py] Re: smartgrid - display linked_tables link as a dropdown button instead

2013-01-20 Thread Niphlod
i know that this can't be a full solution (and I haven't seen a screenshot of those grids) but at least having buttons on the left side should work better. did you try with button_placement = 'left' ? also, for bootstrap customization, can't it be achieved using the ui dict ? PS: if you can

[web2py] Re: LinuxJournal web development poll

2013-01-20 Thread rif
Corrected link http://goo.gl/gOIJP --

[web2py] Re: json validation

2013-01-20 Thread Alan Etkin
> > CONTROLLER FUNCTION: (the myobj value is copied from my cell's edit page > after being inserted into my Oracle DB. > The json field type does not validate insert/update for values stored programatically, validation is performed when you send values with the json widget. However, you could

[web2py] LinuxJournal web development poll

2013-01-20 Thread rif
http://m.linuxjournal.com/content/web-development-poll Most of my prefernces were not listed... --