[web2py] Re: new plugin - web2py Form Wizard - PowerFormWizard
In the validation example, I entered a single character in the Bio and was allowed to proceed to the next field despite the db.person.bio.requires = IS_LENGTH(minsize=5, maxsize=200). You made a note about Client side validation is not supposed to validate everything!, is this included in that exception? A few suggestions: * How about using description or details instead of the legend keyword at it seems to be more appropriate for said function. • As default behavior, instead of the default X errorImage beside the step title, how about using an exclamation point icon to indicate that this step needs attention and then in the specific field with an error use the X icon instead. The other day you answered my query re modal windows with a reference to easyframework.com + web2py. I pray that you have plans of adding that feature to your PowerFormWizard Plugin (or perhaps turning this into a PowerForms plugin to truly enable feature-full forms in Web2py? Cheers and many thanks for your many contributions to the web2py community. /r Nik On Jun 29, 10:33 pm, Bruno Rocha rochacbr...@gmail.com wrote: Hi, I just created a new plugin for stepped form wizards. I made it last night, so it is not tested very well, I would like your help to test it. web2py PowerFormWizard Plugin - based on Jquery Stepy - Steps - Customizable titles - Server side validation - Client side validation (with jquery validate) - Custom css - JS Callbaks - Error images Take a look:http://labs.blouweb.com/powerformwizard This plugin is the second plugin of blouweb PowerPlugins, I am now starting the third one which I hope to have the first version soon. http://labs.blouweb.com Suggestions, testers, issues, contributions etc on bitbucket:https://bitbucket.org/rochacbruno/powerformwizard Hope it helps someone! Thanks. -- Bruno Rocha [ About me:http://zerp.ly/rochacbruno] [ Aprenda Python:http://CursoDePython.com.br] [ O seu aliado nos cuidados com os animais:http://AnimalSystem.com.br] [ Consultoria em desenvolvimento web:http://www.blouweb.com]
[web2py] Re: new plugin - web2py Form Wizard - PowerFormWizard
very cool!!! :) On Jun 30, 2:41 am, niknok nikolai...@gmail.com wrote: In the validation example, I entered a single character in the Bio and was allowed to proceed to the next field despite the db.person.bio.requires = IS_LENGTH(minsize=5, maxsize=200). You made a note about Client side validation is not supposed to validate everything!, is this included in that exception? A few suggestions: * How about using description or details instead of the legend keyword at it seems to be more appropriate for said function. • As default behavior, instead of the default X errorImage beside the step title, how about using an exclamation point icon to indicate that this step needs attention and then in the specific field with an error use the X icon instead. The other day you answered my query re modal windows with a reference to easyframework.com + web2py. I pray that you have plans of adding that feature to your PowerFormWizard Plugin (or perhaps turning this into a PowerForms plugin to truly enable feature-full forms in Web2py? Cheers and many thanks for your many contributions to the web2py community. /r Nik On Jun 29, 10:33 pm, Bruno Rocha rochacbr...@gmail.com wrote: Hi, I just created a new plugin for stepped form wizards. I made it last night, so it is not tested very well, I would like your help to test it. web2py PowerFormWizard Plugin - based on Jquery Stepy - Steps - Customizable titles - Server side validation - Client side validation (with jquery validate) - Custom css - JS Callbaks - Error images Take a look:http://labs.blouweb.com/powerformwizard This plugin is the second plugin of blouweb PowerPlugins, I am now starting the third one which I hope to have the first version soon. http://labs.blouweb.com Suggestions, testers, issues, contributions etc on bitbucket:https://bitbucket.org/rochacbruno/powerformwizard Hope it helps someone! Thanks. -- Bruno Rocha [ About me:http://zerp.ly/rochacbruno] [ Aprenda Python:http://CursoDePython.com.br] [ O seu aliado nos cuidados com os animais:http://AnimalSystem.com.br] [ Consultoria em desenvolvimento web:http://www.blouweb.com]
Re: [web2py] Invalid view in 1.97.1
On 06/29/2011 10:51 PM, pbreit wrote: Or this if you can get by with them only being available on localhost: # by default give a view/generic.extension to all actions from localhost # none otherwise. a pattern can be 'controller/function.extension' response.generic_patterns = ['*'] if request.is_local else [] I see. This is a nice solution. Thanks. I'm curious to know what is the security risk being avoided here. I vaguely remember it being discussed here -- time to search the archives I guess. -- Gary Herron, PhD. Department of Computer Science DigiPen Institute of Technology (425) 895-4418
[web2py] Re: new plugin - web2py Form Wizard - PowerFormWizard
Clarification regarding the bio field with requires. It does let me proceed to the next step, but will not be allowed to submit the data after validation unless i meet the requires statement. A bit confusing since some fields will allow me to move to next step. One more thing, is there going to be an equivalent for SQLFORM.factory? On Jun 30, 2:41 pm, niknok nikolai...@gmail.com wrote: In the validation example, I entered a single character in the Bio and was allowed to proceed to the next field despite the db.person.bio.requires = IS_LENGTH(minsize=5, maxsize=200). You made a note about Client side validation is not supposed to validate everything!, is this included in that exception? A few suggestions: * How about using description or details instead of the legend keyword at it seems to be more appropriate for said function. • As default behavior, instead of the default X errorImage beside the step title, how about using an exclamation point icon to indicate that this step needs attention and then in the specific field with an error use the X icon instead. The other day you answered my query re modal windows with a reference to easyframework.com + web2py. I pray that you have plans of adding that feature to your PowerFormWizard Plugin (or perhaps turning this into a PowerForms plugin to truly enable feature-full forms in Web2py? Cheers and many thanks for your many contributions to the web2py community. /r Nik On Jun 29, 10:33 pm, Bruno Rocha rochacbr...@gmail.com wrote: Hi, I just created a new plugin for stepped form wizards. I made it last night, so it is not tested very well, I would like your help to test it. web2py PowerFormWizard Plugin - based on Jquery Stepy - Steps - Customizable titles - Server side validation - Client side validation (with jquery validate) - Custom css - JS Callbaks - Error images Take a look:http://labs.blouweb.com/powerformwizard This plugin is the second plugin of blouweb PowerPlugins, I am now starting the third one which I hope to have the first version soon. http://labs.blouweb.com Suggestions, testers, issues, contributions etc on bitbucket:https://bitbucket.org/rochacbruno/powerformwizard Hope it helps someone! Thanks. -- Bruno Rocha [ About me:http://zerp.ly/rochacbruno] [ Aprenda Python:http://CursoDePython.com.br] [ O seu aliado nos cuidados com os animais:http://AnimalSystem.com.br] [ Consultoria em desenvolvimento web:http://www.blouweb.com]
[web2py] plugins and languages
Hello All! See I right that the plugin system can't handle language files for the plugins or I miss something? It could be good to be able to have the language files for plugins...
Re: [web2py] plugins and languages
On 30/06/2011 10:07, szimszon wrote: Hello All! See I right that the plugin system can't handle language files for the plugins or I miss something? It could be good to be able to have the language files for plugins... have you seen http://www.web2py.com/book/default/chapter/13?search=plugin#Plugins have you tried to create under languages file called: plugin_myplugin_en-en.py or something similar? I've never tried but it seems possible. My 2¢ Manuele
[web2py] web2py license
here is an interesting article about source code licenses http://gskinner.com/blog/archives/2008/07/source_code_lic_1.html the author in summary says I would strongly encourage developers to release shared code under the MIT license. and I would also encourage developers to petition the owners of their favourite shared libraries to change their licensing to MIT, if they haven’t already. so my question: why not releasing under MIT license or under dual license (as jquery) ?
Re: [web2py] Using request.env.http_referrer to link to previous page
On Thu, Jun 30, 2011 at 2:55 AM, Jonathan Lundell jlund...@pobox.com wrote:
On Jun 29, 2011, at 1:18 PM, Richard Arts wrote:
Can somebody point out to me how to use the request.env.http_referrer
to link to the previous page?
So far I have tried the following in the template file:
{{=A('Back', _href=URL(request.env.http_referrer))}}
but it links to the current page.
Trying to supply the http_referrer through a dict does not work either.
I'm certain I must be overlooking something...
Using 1.97.1.
It's not your problem, but it's 'http_referer'; it got misspelled somewhere
back in the mists of Internet time.
It's an absolute URL, so URL() won't do anything useful with it. You'll need
something more like _href=request.env.http_referer.
Alternatively, you can parse it and pull out the bits that you need to pass
to URL() (assuming that the referring page is in your app).
Generally speaking, I think you're better off tracking the referral chain
internally, rather than relying on http_referer.
Thank you Jonathan. I will try this out tonight, and take your point
about avoiding the referer into consideration.
Regards,
Richard
Re: [web2py] plugins and languages
Did not work. And admin did not recognize it too...
[web2py] web2py license
While I think frameworks are best under BSD/MIT, this article seems mostly about flash and is not very compelling. As well as old.
Re: [web2py] Invalid view in 1.97.1
If you pass, for example, an auth_user record to a view, you can view all the fields of that record by changing the extension. If you're passin locals() you can view even more. This is because the generics are designed to display everything that they can. Helpful during development but not appropriate for production.
[web2py] Multiple Languages for application
Does web2py support Multiple Languages. So lets say I create a system that is all in English, How would i translate it into french Italian Spanish.
Re: [web2py] Multiple Languages for application
Yes, if you read the book, you've seen about i18n here: http://www.web2py.com/book/default/chapter/04#T-and-Internationalization 2011/6/30 stargate kyoukh...@gmail.com Does web2py support Multiple Languages. So lets say I create a system that is all in English, How would i translate it into french Italian Spanish.
Re: [web2py] SECOND TRY TO GET IT ON THE LIST how redirect without propagate the .load extension?
Still nop!
I also try to put it in the if table == like this :
if table == 'ref_fnaregistry':
#redirect(URL(request.application,c='default',f='index.html'))
form.update(_class='no_trap',
_action=URL('default','creation.html'),args=1)
return dict(form=form)
#URL(request.application,c='default', f='creation.html',args=1)
I don't think changing the action for 'create_fvte.html' is logic... I mean
my create_fvte is a component function and it serves to load all the 2
components ref_fnaregistry and ref_vregistry...
Maybe I should drop this function and create 2 functions one for each
component or form...
Anyway using your line of code directly give a empty page theres is no shell
for the component I mean no Tabs plugin and no code at all in the
create_fvte.hml view...
Richard
On Wed, Jun 29, 2011 at 11:38 PM, Anthony abasta...@gmail.com wrote:
OK, I forgot the underscore before 'action' (I also forgot to include
request.args in the form action URL) -- I think this should do it:
form.update(_class='no_trap',
_action=URL('default','create_fvte.html',args=request.args))
Note, adding the .html extension to create_fvte above ensures that when the
form is submitted back to this function, the extension will be .html, which
is the extension that will be passed to the redirects.
Also, you should remove the following from create_fvte:
else:
response.flash = T('please fill out the form')
The problem with that is that when you redirect to the /creation URL, it
reloads your components, and the response.flash from the components
overrides the session.flash that was passed to the /creation page. Instead,
put the following in the creation() function:
if not request.args:
response.flash = T('please fill out the form')
That will flash 'please fill out the form' when the /creation page is
loaded without any arguments, but not otherwise.
With those small changes, I believe it all works as you want now.
Anthony
On Wednesday, June 29, 2011 9:57:09 PM UTC-4, Richard wrote:
It clear validator if they trigger and don't know why the redirection
don't works neither...
Maybe pbreit is right and I should just forget about redirection... It's
probably what I will do for now, cause I can't spend any longer on this
picky stuff for now. It's part of the 20% percent stuff...
Thanks anyway, I really appreciate your help.
;-)
Richard
On Wed, Jun 29, 2011 at 6:54 PM, Anthony abas...@gmail.com wrote:
Sorry, the **dict() isn't really needed -- you can just do:
form.element('form').update(**_**class='no_trap',
action=URL('default','create_**f**vte'))
Actually, in the URL() call above, you might be better off doing
'create_fvte.html' to ensure it doesn't use the .load extension, which would
then propagate to the redirect (unless you explicitly specify .hmtl in the
redirect).
Anthony
On Wednesday, June 29, 2011 6:02:42 PM UTC-4, Anthony wrote:
Try this:
form = crud.create(db[table])
form.element('form').update(**dict(_class='no_trap',
action=URL('default','create_**f**vte')))
The _class='no_trap' should turn off the trapping of the form, and the
action=URL('default','create_**f**vte') should ensure that the
untrapped form gets submitted back to the create_fvte function rather than
the parent page (i.e., the index function). Because the form will not be
submitted via ajax, the redirect should work as usual and reload the entire
page.
Anthony
Re: [web2py] Re: new plugin - web2py Form Wizard - PowerFormWizard
Even without client side validation, the server side will perform at the end of submission. The client-side validation, for now, just check if a field is required, i did not implemented yet the other kind of client validation. I guess you can use factory in the normal way, PowerFormWizard.factory, as PowerFormWizard is a subclass of SQLFORM. - But I did not tested yet. I just found some issues, I will wait for people to raise more issues and I will update. Thank you all for testing.. On Thu, Jun 30, 2011 at 4:49 AM, niknok nikolai...@gmail.com wrote: Clarification regarding the bio field with requires. It does let me proceed to the next step, but will not be allowed to submit the data after validation unless i meet the requires statement. A bit confusing since some fields will allow me to move to next step. One more thing, is there going to be an equivalent for SQLFORM.factory? On Jun 30, 2:41 pm, niknok nikolai...@gmail.com wrote: In the validation example, I entered a single character in the Bio and was allowed to proceed to the next field despite the db.person.bio.requires = IS_LENGTH(minsize=5, maxsize=200). You made a note about Client side validation is not supposed to validate everything!, is this included in that exception? A few suggestions: * How about using description or details instead of the legend keyword at it seems to be more appropriate for said function. • As default behavior, instead of the default X errorImage beside the step title, how about using an exclamation point icon to indicate that this step needs attention and then in the specific field with an error use the X icon instead. The other day you answered my query re modal windows with a reference to easyframework.com + web2py. I pray that you have plans of adding that feature to your PowerFormWizard Plugin (or perhaps turning this into a PowerForms plugin to truly enable feature-full forms in Web2py? Cheers and many thanks for your many contributions to the web2py community. /r Nik On Jun 29, 10:33 pm, Bruno Rocha rochacbr...@gmail.com wrote: Hi, I just created a new plugin for stepped form wizards. I made it last night, so it is not tested very well, I would like your help to test it. web2py PowerFormWizard Plugin - based on Jquery Stepy - Steps - Customizable titles - Server side validation - Client side validation (with jquery validate) - Custom css - JS Callbaks - Error images Take a look:http://labs.blouweb.com/powerformwizard This plugin is the second plugin of blouweb PowerPlugins, I am now starting the third one which I hope to have the first version soon. http://labs.blouweb.com Suggestions, testers, issues, contributions etc on bitbucket: https://bitbucket.org/rochacbruno/powerformwizard Hope it helps someone! Thanks. -- Bruno Rocha [ About me:http://zerp.ly/rochacbruno] [ Aprenda Python:http://CursoDePython.com.br] [ O seu aliado nos cuidados com os animais:http://AnimalSystem.com.br] [ Consultoria em desenvolvimento web:http://www.blouweb.com] -- -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] [ Aprenda a programar: http://CursoDePython.com.br ] [ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ] [ Consultoria em desenvolvimento web: http://www.blouweb.com ]
[web2py] Re: I created a little app to be able to share some files over the net without authentication
Minor update: 110630 display the number of the uploadable and the uploaded files on upload group list 110628 the upload and downloaed links of the upload groups has now a title='...' with the best before date And *Like* button on https://trac.oregpreshaz.eu/linux/wiki/ul Could we have a download count on *appliances* page?
[web2py] Re: Localising decimal values in form fields
Thanks for this hint, but that doesn't seem to work. If I apply this to the field in either model or controller, i get following error: File gluon/sqlhtml.py, line 782, in __init__ File gluon/dal.py, line 5247, in formatter File gluon/validators.py, line 807, in formatter TypeError: expected a character buffer object If I use fixed value (eg .. requires=IS_DECIMAL_IN_RANGE(dot=,) ...) the conversion seems to work. On 29 Jun., 17:46, Massimo Di Pierro massimo.dipie...@gmail.com wrote: IS_DECIMAL_IN_RANGE and IS_FLOAT take a an attribute called dot=. which you can internationalize IS_DECIMAL_IN_RANGE(dot=T(.)) On Jun 29, 5:39 am, tomtom5 tomt...@chello.at wrote: I'm currently diving into web2py and got a problem localising input/ output ofDecimal/Doubleformfields according to the users (browsers) locale. I understand the mechanism of internationalising messages with T(..), but that doesn't seem to help me further. What I need is, that for example a german user may input adecimalvalue as 123.456,78 while an american user will use 123 456.78 as input/output format. I found methods to define thedecimalseparator char in the constructor of the IS_DECIMAL_IN_RANGE validator, but this is very rudimentary and will not be user-locale aware. Is there a way to solve the problem out of the box or should I create new validators or widgets for such a task? Thanks for advise
Re: [web2py] Re: I created a little app to be able to share some files over the net without authentication
On Thu, Jun 30, 2011 at 9:50 AM, szimszon szims...@gmail.com wrote: Could we have a download count on *appliances* page? Not yet, I am working on web2yslices2.0, which will probably work as an appliance directory, this will be included... Now, I host my projects in bitbucket, and I link ethe download to there, because of the counter https://bitbucket.org/rochacbruno/powerformwizard/downloads -- -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] [ Aprenda a programar: http://CursoDePython.com.br ] [ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ] [ Consultoria em desenvolvimento web: http://www.blouweb.com ]
[web2py] Re: Disabling Input Validation/Output Incoding
I did something similar to demonstrate common vulnerabilities, such as SQL injection and changing hidden values in forms before submission. It was really tough to make this app with web2py, as I had to skirt around most of the framework to make it happen. This is a GOOD THING though. I learned a lot about the extent that web2py goes to in order to keep apps secure. You have to wrap everything in XML(), like Anthony mentions, you also have to use db.executesql() and define and handle your own forms manually, without using FORM or SQLFORM.
[web2py] Re: how to pass flag to database backend
I added an unindexed string type like this: from google.appengine.ext import db as gae db._adapter.types['noindex'] = (lambda: gae.StringProperty(multiline=True, indexed=False)) Is there a better way?
Re: [web2py] SECOND TRY TO GET IT ON THE LIST how redirect without propagate the .load extension?
No, the code should look like this:
def create_fvte():
table = request.args(0)
crud.settings.formstyle='divs'
form = crud.create(db[table])
form.update(_class='no_trap',
_action=URL('default','create_fvte.html',args=request.args))
if form.accepts(request.vars, session):
session.flash = T('form accepted')
if table == 'ref_fnaregistry':
redirect(URL(request.application,c='default',f='index'))
elif table == 'ref_vregistry':
redirect(URL(request.application,c='default',
f='creation',args=2))
elif table == 'ref_tregistry':
redirect(URL(request.application,c='default',
f='creation',args=3))
elif form.errors:
response.flash = T('form has errors')
return dict(form=form)
The above works fine for me, but there's still one problem -- if the form
has errors, it isn't able to re-display the form with error messages
(because it submits to create_fvte, which loads at the top level instead of
within the creation page). We might be able to handle that by putting things
in the session, but that's starting to get a bit too complicated. So
instead, let's try redirecting from the client side via javascript. Try
this:
def create_fvte():
table = request.args(0)
crud.settings.formstyle='divs'
form = crud.create(db[table])
if form.accepts(request.vars, session):
if table == 'ref_fnaregistry':
next = URL('default', 'index', extension=False, host=True)
elif table == 'ref_vregistry':
next = URL('default', 'creation', args=2, extension=False,
host=True)
elif table == 'ref_tregistry':
next = URL('default', 'creation', args=3, extension=False,
host=True)
session.flash = T('form accepted')
response.js = 'window.location.replace(%s)' % next
elif form.errors:
response.flash = T('form has errors')
return dict(form=form)
Instead of redirecting on the server side, the above sends a javascript
command back to the client that redirects to the appropriate URL. In this
case, because the redirect happens on the client side after the returned
page loads, you will briefly see the original page with a blank form before
the redirect happens.
Anthony
On Thursday, June 30, 2011 8:32:01 AM UTC-4, Richard wrote:
Still nop!
I also try to put it in the if table == like this :
if table == 'ref_fnaregistry':
#redirect(URL(request.application,c='default',f='index.html'))
form.update(_class='no_trap',
_action=URL('default','creation.html'),args=1)
return dict(form=form)
#URL(request.application,c='default', f='creation.html',args=1)
I don't think changing the action for 'create_fvte.html' is logic... I mean
my create_fvte is a component function and it serves to load all the 2
components ref_fnaregistry and ref_vregistry...
Maybe I should drop this function and create 2 functions one for each
component or form...
Anyway using your line of code directly give a empty page theres is no
shell for the component I mean no Tabs plugin and no code at all in the
create_fvte.hml view...
Richard
On Wed, Jun 29, 2011 at 11:38 PM, Anthony abas...@gmail.com wrote:
OK, I forgot the underscore before 'action' (I also forgot to include
request.args in the form action URL) -- I think this should do it:
form.update(_class='no_trap',
_action=URL('default','create_fvte.html',args=request.args))
Note, adding the .html extension to create_fvte above ensures that when
the form is submitted back to this function, the extension will be .html,
which is the extension that will be passed to the redirects.
Also, you should remove the following from create_fvte:
else:
response.flash = T('please fill out the form')
The problem with that is that when you redirect to the /creation URL, it
reloads your components, and the response.flash from the components
overrides the session.flash that was passed to the /creation page. Instead,
put the following in the creation() function:
if not request.args:
response.flash = T('please fill out the form')
That will flash 'please fill out the form' when the /creation page is
loaded without any arguments, but not otherwise.
With those small changes, I believe it all works as you want now.
Anthony
On Wednesday, June 29, 2011 9:57:09 PM UTC-4, Richard wrote:
It clear validator if they trigger and don't know why the redirection
don't works neither...
Maybe pbreit is right and I should just forget about redirection... It's
probably what I will do for now, cause I can't spend any longer on this
picky stuff for now. It's part of the 20% percent stuff...
Thanks anyway, I really appreciate your help.
;-)
Richard
On Wed, Jun 29, 2011 at 6:54 PM, Anthony aba...@gmail.com wrote:
Sorry, the **dict() isn't really needed -- you can just do:
Re: [web2py] SECOND TRY TO GET IT ON THE LIST how redirect without propagate the .load extension?
Now it works!!!
I had try what you explained... I didn't just not explain everything
completly maybe...
There is only an artefact. The next solution that you propose breaks the
normal workflow of navigation... The user can't go back with the nav
backward arrow... Maybe we could use javascript:void(history.go(-1))
somewhere ;-)
Thank you Anthony for your help...
Richard
On Thu, Jun 30, 2011 at 10:26 AM, Anthony abasta...@gmail.com wrote:
No, the code should look like this:
def create_fvte():
table = request.args(0)
crud.settings.formstyle='divs'
form = crud.create(db[table])
form.update(_class='no_trap',
_action=URL('default','create_fvte.html',args=request.args))
if form.accepts(request.vars, session):
session.flash = T('form accepted')
if table == 'ref_fnaregistry':
redirect(URL(request.application,c='default',f='index'))
elif table == 'ref_vregistry':
redirect(URL(request.application,c='default',
f='creation',args=2))
elif table == 'ref_tregistry':
redirect(URL(request.application,c='default',
f='creation',args=3))
elif form.errors:
response.flash = T('form has errors')
return dict(form=form)
The above works fine for me, but there's still one problem -- if the form
has errors, it isn't able to re-display the form with error messages
(because it submits to create_fvte, which loads at the top level instead of
within the creation page). We might be able to handle that by putting things
in the session, but that's starting to get a bit too complicated. So
instead, let's try redirecting from the client side via javascript. Try
this:
def create_fvte():
table = request.args(0)
crud.settings.formstyle='divs'
form = crud.create(db[table])
if form.accepts(request.vars, session):
if table == 'ref_fnaregistry':
next = URL('default', 'index', extension=False, host=True)
elif table == 'ref_vregistry':
next = URL('default', 'creation', args=2, extension=False,
host=True)
elif table == 'ref_tregistry':
next = URL('default', 'creation', args=3, extension=False,
host=True)
session.flash = T('form accepted')
response.js = 'window.location.replace(%s)' % next
elif form.errors:
response.flash = T('form has errors')
return dict(form=form)
Instead of redirecting on the server side, the above sends a javascript
command back to the client that redirects to the appropriate URL. In this
case, because the redirect happens on the client side after the returned
page loads, you will briefly see the original page with a blank form before
the redirect happens.
Anthony
On Thursday, June 30, 2011 8:32:01 AM UTC-4, Richard wrote:
Still nop!
I also try to put it in the if table == like this :
if table == 'ref_fnaregistry':
#redirect(URL(request.**application,c='default',f='**
index.html'))
form.update(_class='no_trap', _action=URL('default','**
creation.html'),args=1)
return dict(form=form)
#URL(request.application,c='**default',
f='creation.html',args=1)
I don't think changing the action for 'create_fvte.html' is logic... I
mean my create_fvte is a component function and it serves to load all the 2
components ref_fnaregistry and ref_vregistry...
Maybe I should drop this function and create 2 functions one for each
component or form...
Anyway using your line of code directly give a empty page theres is no
shell for the component I mean no Tabs plugin and no code at all in the
create_fvte.hml view...
Richard
On Wed, Jun 29, 2011 at 11:38 PM, Anthony abas...@gmail.com wrote:
OK, I forgot the underscore before 'action' (I also forgot to include
request.args in the form action URL) -- I think this should do it:
form.update(_class='no_trap', _action=URL('default','create_**
fvte.html',args=request.args))
Note, adding the .html extension to create_fvte above ensures that when
the form is submitted back to this function, the extension will be .html,
which is the extension that will be passed to the redirects.
Also, you should remove the following from create_fvte:
else:
response.flash = T('please fill out the form')
The problem with that is that when you redirect to the /creation URL, it
reloads your components, and the response.flash from the components
overrides the session.flash that was passed to the /creation page. Instead,
put the following in the creation() function:
if not request.args:
response.flash = T('please fill out the form')
That will flash 'please fill out the form' when the /creation page is
loaded without any arguments, but not otherwise.
With those small changes, I believe it all works as you want now.
Anthony
On Wednesday, June 29, 2011 9:57:09 PM UTC-4, Richard wrote:
It clear validator if they trigger and don't know why
[web2py] Re: web2py license
We had a long discussion about this several months ago, and as a result, the license was changed from GPL (with commercial exception) to LGPL. I think the idea was that LGPL should allow usage of the framework along with apps and libraries of any license type while prohibiting any closed source/commercial forks of web2py (which MIT would allow). Anthony On Thursday, June 30, 2011 5:52:12 AM UTC-4, elffikk wrote: here is an interesting article about source code licenses http://gskinner.com/blog/archives/2008/07/source_code_lic_1.html the author in summary says I would strongly encourage developers to release shared code under the MIT license. and I would also encourage developers to petition the owners of their favourite shared libraries to change their licensing to MIT, if they haven’t already. so my question: why not releasing under MIT license or under dual license (as jquery) ?
Re: [web2py] SECOND TRY TO GET IT ON THE LIST how redirect without propagate the .load extension?
You're welcome.
Yeah, you might have to play around with the JS a bit, but hopefully this
points you in the right direction.
The problem with the server side redirect is that the jQuery ajax function
receives the redirect response and then makes the redirect request via ajax
again, and then it receives the new response and uses it to fill the
component div. So, it's not really a server-side issue with web2py. There
may be a way to tell jQuery not to respond to redirects via ajax -- I'll
look into that.
Anthony
On Thursday, June 30, 2011 10:55:22 AM UTC-4, Richard wrote:
Now it works!!!
I had try what you explained... I didn't just not explain everything
completly maybe...
There is only an artefact. The next solution that you propose breaks the
normal workflow of navigation... The user can't go back with the nav
backward arrow... Maybe we could use javascript:void(history.go(-1))
somewhere ;-)
Thank you Anthony for your help...
Richard
On Thu, Jun 30, 2011 at 10:26 AM, Anthony abas...@gmail.com wrote:
No, the code should look like this:
def create_fvte():
table = request.args(0)
crud.settings.formstyle='divs'
form = crud.create(db[table])
form.update(_class='no_trap',
_action=URL('default','create_fvte.html',args=request.args))
if form.accepts(request.vars, session):
session.flash = T('form accepted')
if table == 'ref_fnaregistry':
redirect(URL(request.application,c='default',f='index'))
elif table == 'ref_vregistry':
redirect(URL(request.application,c='default',
f='creation',args=2))
elif table == 'ref_tregistry':
redirect(URL(request.application,c='default',
f='creation',args=3))
elif form.errors:
response.flash = T('form has errors')
return dict(form=form)
The above works fine for me, but there's still one problem -- if the form
has errors, it isn't able to re-display the form with error messages
(because it submits to create_fvte, which loads at the top level instead of
within the creation page). We might be able to handle that by putting things
in the session, but that's starting to get a bit too complicated. So
instead, let's try redirecting from the client side via javascript. Try
this:
def create_fvte():
table = request.args(0)
crud.settings.formstyle='divs'
form = crud.create(db[table])
if form.accepts(request.vars, session):
if table == 'ref_fnaregistry':
next = URL('default', 'index', extension=False, host=True)
elif table == 'ref_vregistry':
next = URL('default', 'creation', args=2, extension=False,
host=True)
elif table == 'ref_tregistry':
next = URL('default', 'creation', args=3, extension=False,
host=True)
session.flash = T('form accepted')
response.js = 'window.location.replace(%s)' % next
elif form.errors:
response.flash = T('form has errors')
return dict(form=form)
Instead of redirecting on the server side, the above sends a javascript
command back to the client that redirects to the appropriate URL. In this
case, because the redirect happens on the client side after the returned
page loads, you will briefly see the original page with a blank form before
the redirect happens.
Anthony
On Thursday, June 30, 2011 8:32:01 AM UTC-4, Richard wrote:
Still nop!
I also try to put it in the if table == like this :
if table == 'ref_fnaregistry':
#redirect(URL(request.**application,c='default',f='**
index.html'))
form.update(_class='no_trap', _action=URL('default','**
creation.html'),args=1)
return dict(form=form)
#URL(request.application,c='**default',
f='creation.html',args=1)
I don't think changing the action for 'create_fvte.html' is logic... I
mean my create_fvte is a component function and it serves to load all the 2
components ref_fnaregistry and ref_vregistry...
Maybe I should drop this function and create 2 functions one for each
component or form...
Anyway using your line of code directly give a empty page theres is no
shell for the component I mean no Tabs plugin and no code at all in the
create_fvte.hml view...
Richard
On Wed, Jun 29, 2011 at 11:38 PM, Anthony aba...@gmail.com wrote:
OK, I forgot the underscore before 'action' (I also forgot to include
request.args in the form action URL) -- I think this should do it:
form.update(_class='no_trap', _action=URL('default','create_**
fvte.html',args=request.args))
Note, adding the .html extension to create_fvte above ensures that when
the form is submitted back to this function, the extension will be .html,
which is the extension that will be passed to the redirects.
Also, you should remove the following from create_fvte:
else:
response.flash = T('please fill out the form')
[web2py] Re: Disabling Input Validation/Output Incoding
Thank you both for the help and advice, things are working perfectly now. On Jun 30, 9:25 am, Ross Peoples ross.peop...@gmail.com wrote: I did something similar to demonstrate common vulnerabilities, such as SQL injection and changing hidden values in forms before submission. It was really tough to make this app with web2py, as I had to skirt around most of the framework to make it happen. This is a GOOD THING though. I learned a lot about the extent that web2py goes to in order to keep apps secure. You have to wrap everything in XML(), like Anthony mentions, you also have to use db.executesql() and define and handle your own forms manually, without using FORM or SQLFORM.
[web2py] response.js=web2py_component('action','target') : no refresh
Hello,
I am having hard time to refresh component I don't know if it is my
response.js or my setup or 1.97.1 issue :
response.js=web2py_component(URL(c='ref',f='creation'),'two')
CONTROLLER
def creation():
if not request.args:
response.flash = T('please fill out the form')
a = None
return dict(a=a)
def create_fvte():
table = request.args(0)
crud.settings.formstyle='divs'
form = crud.create(db[table])
if form.accepts(request.vars, session):
session.flash = T('form accepted')
response.js=web2py_component(URL(c='ref',
f='create_fvte.load',args='ref_vregistry'),'two')
elif form.errors:
response.flash = T('form has errors')
return dict(form=form)
VIEWS :
CREATION =
{{extend 'layout_form.html'}}
style type=text/css title=currentStyle
@import
{{=URL('static','plugin_added/jquery-ui-1.8.14.custom/development-bundle/themes/base/jquery.ui.all.css')}};
/style
div class=demo
br/
br/
br/
div id=tabs
ul
lia href=#tabs-1{{=T('folder').capitalize()}}/a/li
lia href=#tabs-2{{=T('volume').capitalize()}}/a/li
lia href=#tabs-3{{=T('tome').capitalize()}}/a/li
lia href=#tabs-4{{=T('report').capitalize()}}/a/li
/ul
div id=tabs-1
br/
{{=LOAD(c='ref', f='create_fvte', args='ref_fnaregistry',
extension='load', ajax=True, target='one')}}
/div!-- tabs-1 --
div id=tabs-2
br/
{{=LOAD(c='ref', f='create_fvte', args='ref_vregistry',
extension='load', ajax=True, target='two')}}
/div!-- tabs-2 --
div id=tabs-3
br/
{{=LOAD(c='ref', f='create_fvte', args='ref_tregistry',
extension='load', ajax=True, target='three')}}
/div!-- tabs-3 --
div id=tabs-4
br/
{{=LOAD(c='ref', f='create_fvte', args='ref_eregistry',
extension='load', ajax=True, target='four')}}
/div!-- tabs-4 --
/div!-- tabs --
/div!-- End demo --
script type=text/javascript charset=utf-8
src={{=URL('static','plugin_added/jquery-ui-1.8.14.custom/development-bundle/ui/minified/jquery.ui.core.min.js')}}
/script
script type=text/javascript charset=utf-8
src={{=URL('static','plugin_added/jquery-ui-1.8.14.custom/development-bundle/ui/minified/jquery.ui.widget.min.js')}}
/script
script type=text/javascript charset=utf-8
src={{=URL('static','plugin_added/jquery-ui-1.8.14.custom/development-bundle/ui/minified/jquery.ui.tabs.min.js')}}
/script
script
$(function() {
var $tabs = $( #tabs ).tabs();
$tabs.tabs('select', {{=request.args(0)}});
return false;
});
/script
CREATE_FVTE = EMPTY
Re: [web2py] Re: web2py license
I think frameworks are best under BSD/MIT so you agree :) the fact that it is written by a flash developer a few years ago doesn't mean that this is not relevant information prohibiting any closed source/commercial forks of web2py DAL and template system can be used standalone what if I want to use them with bottle (MIT) or flask(BSD) and make a hybrid framework and distribute them (in commercial projects too)? for some of my projects there is no reason to use a full stack framework - just 3 files: bottle, dal, and template or for some desktop (offline) applications I need 4: rocket+bottle+dal+template
Re: [web2py] Re: web2py license
On Thu, Jun 30, 2011 at 1:52 PM, Vasile Ermicioi elff...@gmail.com wrote: DAL and template system can be used standalone what if I want to use them with bottle (MIT) or flask(BSD) and make a hybrid framework and distribute them (in commercial projects too)? I guess you can create a comercial product, but not a comercial framework. -- -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] [ Aprenda a programar: http://CursoDePython.com.br ] [ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ] [ Consultoria em desenvolvimento web: http://www.blouweb.com ]
Re: [web2py] Re: web2py license
I guess you can create a comercial product, but not a comercial framework. what about an opensource framework :) e.g. ( bottle+dal+template+rocket) ? anyway, I think another license change (to MIT) will be welcome
Re: [web2py] Re: web2py license
On Thu, Jun 30, 2011 at 2:05 PM, Vasile Ermicioi elff...@gmail.com wrote: what about an opensource framework :) e.g. ( bottle+dal+template+rocket) ? Martin Mulone started a project for that https://bitbucket.org/mulonemartin/web2tools/overview -- -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] [ Aprenda a programar: http://CursoDePython.com.br ] [ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ] [ Consultoria em desenvolvimento web: http://www.blouweb.com ]
Re: [web2py] response.js=web2py_component('action','target') : no refresh
On Thursday, June 30, 2011 12:39:53 PM UTC-4, Richard wrote:
Hello,
I am having hard time to refresh component I don't know if it is my
response.js or my setup or 1.97.1 issue :
response.js=web2py_component(URL(c='ref',f='creation'),'two')
You can't put a call to the URL() function inside a string -- it's a web2py
Python function that has to be run on the server side -- as is, you're
sending it as javascript code. You might also need to put it in quotes.
Maybe something like this:
response.js=web2py_component('%s','two') % URL('ref','creation')
Anthony
Re: [web2py] Re: web2py license
great, as always, I thought and it is already done :) so forks are allowed, or... ?
Re: [web2py] Re: web2py license
On Thursday, June 30, 2011 1:05:47 PM UTC-4, elffikk wrote: I guess you can create a comercial product, but not a comercial framework. what about an opensource framework :) e.g. ( bottle+dal+template+rocket) ? I think you can do that, but I don't think you could make the entire framework MIT because that would violate the DAL's LGPL license (i.e., the DAL would have to stay LGPL). Anthony
Re: [web2py] Re: web2py license
On Thursday, June 30, 2011 12:52:06 PM UTC-4, elffikk wrote: I think frameworks are best under BSD/MIT so you agree :) the fact that it is written by a flash developer a few years ago doesn't mean that this is not relevant information prohibiting any closed source/commercial forks of web2py DAL and template system can be used standalone what if I want to use them with bottle (MIT) or flask(BSD) and make a hybrid framework and distribute them (in commercial projects too)? I think it depends exactly what you want to do. The DAL part of your project would have to stay open source, but I think you can use it as a library/module within a closed source project. You just can't make changes to it, and then close source the changed version. Anthony
Re: [web2py] response.js=web2py_component('action','target') : no refresh
Ok, it works now but I get None in place of the reloaded component... I
thought it could be the Tabs plugin so I remove the initiation script but
still get None...
Any idea?
On Thu, Jun 30, 2011 at 1:13 PM, Anthony abasta...@gmail.com wrote:
On Thursday, June 30, 2011 12:39:53 PM UTC-4, Richard wrote:
Hello,
I am having hard time to refresh component I don't know if it is my
response.js or my setup or 1.97.1 issue :
response.js=web2py_component(**URL(c='ref',f='creation'),'**two')
You can't put a call to the URL() function inside a string -- it's a web2py
Python function that has to be run on the server side -- as is, you're
sending it as javascript code. You might also need to put it in quotes.
Maybe something like this:
response.js=web2py_component('%s'**,'**two') % URL('ref','creation')
Anthony
[web2py] Re: Documenting a file with sphinx, that has local_import in it
I'm having the same issue. Where do I have to include all this? Is
there some other workaround for this? It would be great if we could
use Sphinx for documenting out Web2Py apps.
Thanks for any help.
On May 28, 5:18 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
controllers and models in web2py are written in python but are not
python modules. They use objects
(request,response,...,local_import,...) that are not imported.
Sphinx does not understand this.
I am sure there is a way around (for example add to your models and
controllers:
if 1:
from gluon import *
request,response,session,cache,T = \
current.request,current.response,
current.session,current.cache,current.T
from gluon.compileapp import local_import_aux as local_import
) but I cannot say for sure without details about what you are trying
to do.
On May 28, 3:47 am, Vasil Petkov petko...@dir.bg wrote:
Hello!
I use web2py 1.94 on Ubuntu with Python 2.7 and Sphinx 1.0.7. For the
documentation purposes, i have created a 'doc'-directory inside my
web2py-application. My web2py project has the following structure:
web2py
|_ server
| |_ applications
| |_ init
| | |_ controllers
| | |_ myapp.py
... ...
| |_ modules
| |_ xml2obj.py
...
|_ doc
When i try to generate documentation for the myapp.py-file with
sphinx, i get the following warning:
Traceback (most recent call
last):
File /usr/local/lib/python2.7/dist-packages/Sphinx-1.0.7-py2.7.egg/
sphinx/ext/autodoc.py, line 329, in import_object
__import__(self.modname)
File /home/vpetkov/Documents/web2py/server/applications/init/
controllers/myapp.py, line 16, in module
xml2obj = local_import('xml2obj', reload=False)
NameError: name 'local_import' is not defined
/home/vpetkov/Documents/web2py/server/doc/myapp.rst:7: (WARNING/2)
autodoc can't import/find module 'myapp', it reported error: name
'local_import' is not defined, please check your spelling and
sys.path
Additionally. in conf.py Sphinx file, i added
sys.path.append(os.path.abspath('../applications/init/modules/'))
Re: [web2py] response.js=web2py_component('action','target') : no refresh
Like this it pass, but it takes time and it load the entire site before
finally return the updated component...
response.js=web2py_component(URL(c='ref',f='creation#tabs-2'),'two')
Richard
On Thu, Jun 30, 2011 at 1:25 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
Ok, it works now but I get None in place of the reloaded component... I
thought it could be the Tabs plugin so I remove the initiation script but
still get None...
Any idea?
On Thu, Jun 30, 2011 at 1:13 PM, Anthony abasta...@gmail.com wrote:
On Thursday, June 30, 2011 12:39:53 PM UTC-4, Richard wrote:
Hello,
I am having hard time to refresh component I don't know if it is my
response.js or my setup or 1.97.1 issue :
response.js=web2py_component(**URL(c='ref',f='creation'),'**two')
You can't put a call to the URL() function inside a string -- it's a
web2py Python function that has to be run on the server side -- as is,
you're sending it as javascript code. You might also need to put it in
quotes. Maybe something like this:
response.js=web2py_component('%s'**,'**two') % URL('ref','creation')
Anthony
Re: [web2py] response.js=web2py_component('action','target') : no refresh
Not sure. Isn't that the wrong URL for your component? Shouldn't it be
f='create_ftve', plus args=[tablename]?
On Thursday, June 30, 2011 1:25:13 PM UTC-4, Richard wrote:
Ok, it works now but I get None in place of the reloaded component... I
thought it could be the Tabs plugin so I remove the initiation script but
still get None...
Any idea?
On Thu, Jun 30, 2011 at 1:13 PM, Anthony abas...@gmail.com wrote:
On Thursday, June 30, 2011 12:39:53 PM UTC-4, Richard wrote:
Hello,
I am having hard time to refresh component I don't know if it is my
response.js or my setup or 1.97.1 issue :
response.js=web2py_component(**URL(c='ref',f='creation'),'**two')
You can't put a call to the URL() function inside a string -- it's a
web2py Python function that has to be run on the server side -- as is,
you're sending it as javascript code. You might also need to put it in
quotes. Maybe something like this:
response.js=web2py_component('%s'**,'**two') % URL('ref','creation')
Anthony
Re: [web2py] response.js=web2py_component('action','target') : no refresh
Kind of the exact same problem we already solve...
The propagation has pretty problematic behavior in this peculiar case
Richard
On Thu, Jun 30, 2011 at 1:32 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
Like this it pass, but it takes time and it load the entire site before
finally return the updated component...
response.js=web2py_component(URL(c='ref',f='creation#tabs-2'),'two')
Richard
On Thu, Jun 30, 2011 at 1:25 PM, Richard Vézina
ml.richard.vez...@gmail.com wrote:
Ok, it works now but I get None in place of the reloaded component... I
thought it could be the Tabs plugin so I remove the initiation script but
still get None...
Any idea?
On Thu, Jun 30, 2011 at 1:13 PM, Anthony abasta...@gmail.com wrote:
On Thursday, June 30, 2011 12:39:53 PM UTC-4, Richard wrote:
Hello,
I am having hard time to refresh component I don't know if it is my
response.js or my setup or 1.97.1 issue :
response.js=web2py_component(**URL(c='ref',f='creation'),'**two')
You can't put a call to the URL() function inside a string -- it's a
web2py Python function that has to be run on the server side -- as is,
you're sending it as javascript code. You might also need to put it in
quotes. Maybe something like this:
response.js=web2py_component('%s'**,'**two') % URL('ref','creation')
Anthony
Re: [web2py] response.js=web2py_component('action','target') : no refresh
Ok, my mistake... I had try with create_fvte before but with the URL in the
js call so I thought it were not working with it.
Richard
On Thu, Jun 30, 2011 at 1:34 PM, Anthony abasta...@gmail.com wrote:
Not sure. Isn't that the wrong URL for your component? Shouldn't it be
f='create_ftve', plus args=[tablename]?
On Thursday, June 30, 2011 1:25:13 PM UTC-4, Richard wrote:
Ok, it works now but I get None in place of the reloaded component... I
thought it could be the Tabs plugin so I remove the initiation script but
still get None...
Any idea?
On Thu, Jun 30, 2011 at 1:13 PM, Anthony abas...@gmail.com wrote:
On Thursday, June 30, 2011 12:39:53 PM UTC-4, Richard wrote:
Hello,
I am having hard time to refresh component I don't know if it is my
response.js or my setup or 1.97.1 issue :
response.js=web2py_component(URL(c='ref',f='creation'),'**two**')
You can't put a call to the URL() function inside a string -- it's a
web2py Python function that has to be run on the server side -- as is,
you're sending it as javascript code. You might also need to put it in
quotes. Maybe something like this:
response.js=web2py_component(**'%s'**,'**two') % URL('ref','creation')
Anthony
Re: [web2py] Re: Documenting a file with sphinx, that has local_import in it
Interresting too in the fix to use Sphynx to document app...
Richard
On Thu, Jun 30, 2011 at 1:29 PM, Dan rea...@imojo.de wrote:
I'm having the same issue. Where do I have to include all this? Is
there some other workaround for this? It would be great if we could
use Sphinx for documenting out Web2Py apps.
Thanks for any help.
On May 28, 5:18 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
controllers and models in web2py are written in python but are not
python modules. They use objects
(request,response,...,local_import,...) that are not imported.
Sphinx does not understand this.
I am sure there is a way around (for example add to your models and
controllers:
if 1:
from gluon import *
request,response,session,cache,T = \
current.request,current.response,
current.session,current.cache,current.T
from gluon.compileapp import local_import_aux as local_import
) but I cannot say for sure without details about what you are trying
to do.
On May 28, 3:47 am, Vasil Petkov petko...@dir.bg wrote:
Hello!
I use web2py 1.94 on Ubuntu with Python 2.7 and Sphinx 1.0.7. For the
documentation purposes, i have created a 'doc'-directory inside my
web2py-application. My web2py project has the following structure:
web2py
|_ server
| |_ applications
||_ init
|| |_ controllers
|| |_ myapp.py
... ...
||_ modules
| |_ xml2obj.py
...
|_ doc
When i try to generate documentation for the myapp.py-file with
sphinx, i get the following warning:
Traceback (most recent call
last):
File /usr/local/lib/python2.7/dist-packages/Sphinx-1.0.7-py2.7.egg/
sphinx/ext/autodoc.py, line 329, in import_object
__import__(self.modname)
File /home/vpetkov/Documents/web2py/server/applications/init/
controllers/myapp.py, line 16, in module
xml2obj = local_import('xml2obj', reload=False)
NameError: name 'local_import' is not defined
/home/vpetkov/Documents/web2py/server/doc/myapp.rst:7: (WARNING/2)
autodoc can't import/find module 'myapp', it reported error: name
'local_import' is not defined, please check your spelling and
sys.path
Additionally. in conf.py Sphinx file, i added
sys.path.append(os.path.abspath('../applications/init/modules/'))
Re: [web2py] Re: web2py license
Martin did something great, but I would include template too, because I prefer web2py's template system
[web2py] Problem with 1.97.1??
Hi
I have an app I've been working on and upgraded my system to 1.97.1
today. Since then I'm getting the following with an AJAX call for json
data:
Traceback(most recent call last):
Filegluon/restricted.py,line192,inrestricted
FileC:/dev/web2py/applications/InfoCenter/controllers/administration.py
http://127.0.0.1:8000/admin/default/edit/InfoCenter/controllers/administration.py,line862,inmodule
Filegluon/globals.py,line137,inlambda
FileC:/dev/web2py/applications/InfoCenter/controllers/administration.py
http://127.0.0.1:8000/admin/default/edit/InfoCenter/controllers/administration.py,line17,incall
Filegluon/tools.py,line3918,in__call__
Filegluon/tools.py,line3734,inserve_json
Filegluon/tools.py,line3404,inuniversal_caller
TypeError:object of type'NoneType'has no len()
My call from my template looks like this:
jQuery(document).ready(function(){
jQuery(#list).jqGrid({
url:'/InfoCenter/administration/call/json/userList',
datatype: 'json',
postData:{'searchText':$(#searchText).val()},
colModel :[ {
name:'id',
index:'id',
label:'ID',
hidden:true,
},
{
name:'lastFirst',
index:'lastFirst',
width:'50%',
label:'Name',
},
{
name:'email',
index:'email',
width:'50%',
label:'Email',
},
],
pager: '#pager',
rowNum:20,
sortname: lastFirst,
sortorder: 'asc',
width: 875,
height: 100%,
ondblClickRow: function(){
var row_id = $(#list).getGridParam('selrow');
window.location.href = /InfoCenter/administration/user/ + row_id;
return true;
},
caption:'',
});
jQuery(#list).navGrid(#pager,
{edit:false,add:false,del:true,search:false},
{},
{},
{msg:Delete selected row(s),
bSubmit:Delete,
bCancel:Cancel,
url:/InfoCenter/administration/userDelete,
reloadAfterSubmit:true}
);
});
This works in the 1.96.x branches by not 1.97.1. And, it never gets to
the method in the controller. Line in administration.py is the last
line of the call() method:
and line 862 doesn't exist in the controller, it ends at 861:
Any thoughts? I'm stumped (but also pretty new to web2py).
-Jim
inline: dgagieea.pnginline: ghbgbjgj.png
[web2py] Re: Error on LOAD() in trunk
Any ideas on this one? Has anyone else had problems with LOAD(ajax=False) in trunk? I tried switching it to deepcopy and got same error. I also tried putting it in a try/except but could not find anything. Could my request have something funky in it?
Re: [web2py] Re: Error on LOAD() in trunk
You answer your own post... So many may consider you find your own answer... Maybe start a other thread could help. Richard On Thu, Jun 30, 2011 at 3:10 PM, pbreit pbreitenb...@gmail.com wrote: Any ideas on this one? Has anyone else had problems with LOAD(ajax=False) in trunk? I tried switching it to deepcopy and got same error. I also tried putting it in a try/except but could not find anything. Could my request have something funky in it?
Re: [web2py] Re: [OFF] Protect the web2py app of DDoS atack in GAE
Thanks! I take a look, then return here =) # --- # Bruno Barbosa # Web Developer - Linux user and Free Software Enthusiast # http://algoritmizando.com # http://twitter.com/bruninbsb # --- 2011/6/30 pbreit pbreitenb...@gmail.com Check out CloudFlare which caches all your static files, prevents threats and more. All for free with a simple setup. Info on GAE: http://blog.cloudflare.com/zone-apex-naked-domain-root-domain-cname-supp
[web2py] requires and T()
Hi,
I want to use a SQLFORM with a checkbox. I have tried
... Field('my_question',
requires=[IS_IN_SET([T('Yes'),T('No')]),],
widget=SQLFORM.widgets.checkboxes.widget,
default=T('No'),
),...
I got a nice form with the German translations 'Ja' and 'Nein'.
But now I did not get the English version.
A SELECT like
... SELECT(
OPTION(T('Yes'), _value='Y'),
OPTION(T('No'), _value='N'),
) ...
works depending on the T-language, but I don't know how to put a _values
into the SQLFORM.
Any hints?
Regards, Martin
[web2py] id not starting with 1?
Hi, is it possible to create a new table with an id-field not starting with 1. I think it would be better to have numbers of equal length. And - if it's possible - does it reduce efficiency? Regards., Martin
Re: [web2py] requires and T()
IS_IN_SET( [ ('Y',T('Yes')), ('N',T('No')) ] )
Is in set, can receive a list of tuples, where first element is value,
second is text.
On Thu, Jun 30, 2011 at 4:31 PM, Martin Weissenboeck mweis...@gmail.comwrote:
Hi,
I want to use a SQLFORM with a checkbox. I have tried
... Field('my_question',
requires=[IS_IN_SET([T('Yes'),T('No')]),],
widget=SQLFORM.widgets.checkboxes.widget,
default=T('No'),
),...
I got a nice form with the German translations 'Ja' and 'Nein'.
But now I did not get the English version.
A SELECT like
... SELECT(
OPTION(T('Yes'), _value='Y'),
OPTION(T('No'), _value='N'),
) ...
works depending on the T-language, but I don't know how to put a _values
into the SQLFORM.
Any hints?
Regards, Martin
--
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]
Re: [web2py] id not starting with 1?
I think it will depend of your database backend and how you setup your sequence generating... Web2py by default will create a basic sequence then you should go in your database management software (ex.: pgAdmin for postgres) to setup the proper caracteristic of your sequence... Your may override the name of you sequence with sequence_name='YOURSEQUENCENAME' in your model... Richard On Thu, Jun 30, 2011 at 3:34 PM, Martin Weissenboeck mweis...@gmail.comwrote: Hi, is it possible to create a new table with an id-field not starting with 1. I think it would be better to have numbers of equal length. And - if it's possible - does it reduce efficiency? Regards., Martin
Re: [web2py] requires and T()
Great, thank you - it solves the _value-problem.
But the other problem is not solved: I get only the translated version
(German), not dependig on the selected language.
I have tried it with T.force('fr-fr') [there is no French translation]. I
have expected 'Yes' and 'No', but I got again 'Ja' and 'Nein'.
And: how to set the default value?
2011/6/30 Bruno Rocha rochacbr...@gmail.com
IS_IN_SET( [ ('Y',T('Yes')), ('N',T('No')) ] )
Is in set, can receive a list of tuples, where first element is value,
second is text.
On Thu, Jun 30, 2011 at 4:31 PM, Martin Weissenboeck
mweis...@gmail.comwrote:
Hi,
I want to use a SQLFORM with a checkbox. I have tried
... Field('my_question',
requires=[IS_IN_SET([T('Yes'),T('No')]),],
widget=SQLFORM.widgets.checkboxes.widget,
default=T('No'),
),...
I got a nice form with the German translations 'Ja' and 'Nein'.
But now I did not get the English version.
A SELECT like
... SELECT(
OPTION(T('Yes'), _value='Y'),
OPTION(T('No'), _value='N'),
) ...
works depending on the T-language, but I don't know how to put a _values
into the SQLFORM.
Any hints?
Regards, Martin
--
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]
[web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
Hello, Is it possible to declare UNIQUE constraint over many fields and how... Does using IS_NOT_IN_DB() on the differents fields will work? ...num_part1.requires=IS_NOT_IN_DB(db((db.ref_fnaregistry.num_part1==request.vars.num_part1) (db.ref_fnaregistry.num_part2==request.vars.num_part2) (db.ref_fnaregistry.num_part3==request.vars.num_part3) (db.ref_fnaregistry.title==request.vars.title)),db.ref_fnaregistry.num_part1) etc. But I think i need to concatenate... If there is no way I think I know how I will do it. Richard
Re: [web2py] requires and T()
http://web2py.com/book/default/chapter/04?search=default+language#T-and-Internationalization
Look at default language in this page...
Also default depend of you browser setting...
Richard
On Thu, Jun 30, 2011 at 3:55 PM, Martin Weissenboeck mweis...@gmail.comwrote:
Great, thank you - it solves the _value-problem.
But the other problem is not solved: I get only the translated version
(German), not dependig on the selected language.
I have tried it with T.force('fr-fr') [there is no French translation]. I
have expected 'Yes' and 'No', but I got again 'Ja' and 'Nein'.
And: how to set the default value?
2011/6/30 Bruno Rocha rochacbr...@gmail.com
IS_IN_SET( [ ('Y',T('Yes')), ('N',T('No')) ] )
Is in set, can receive a list of tuples, where first element is value,
second is text.
On Thu, Jun 30, 2011 at 4:31 PM, Martin Weissenboeck
mweis...@gmail.comwrote:
Hi,
I want to use a SQLFORM with a checkbox. I have tried
... Field('my_question',
requires=[IS_IN_SET([T('Yes'),T('No')]),],
widget=SQLFORM.widgets.checkboxes.widget,
default=T('No'),
),...
I got a nice form with the German translations 'Ja' and 'Nein'.
But now I did not get the English version.
A SELECT like
... SELECT(
OPTION(T('Yes'), _value='Y'),
OPTION(T('No'), _value='N'),
) ...
works depending on the T-language, but I don't know how to put a
_values into the SQLFORM.
Any hints?
Regards, Martin
--
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]
Re: [web2py] requires and T()
I just tested it and works perfectly.
Are you sure do you have the string translated in language file?
My test:
T.force('pt-br')
print T.accepted_language # printed ok pt-br in terminal
myset = [ ('Y', T('Yes')), ('N', T('No')) ]
db.define_table('question',
Field('my_question',
requires = [IS_IN_SET(myset)],
widget = SQLFORM.widgets.checkboxes.widget,
default = T('No'),
)
)
I got Sim , Não in portuguese.
But I needed to update my language files.
On Thu, Jun 30, 2011 at 4:55 PM, Martin Weissenboeck mweis...@gmail.comwrote:
Great, thank you - it solves the _value-problem.
But the other problem is not solved: I get only the translated version
(German), not dependig on the selected language.
I have tried it with T.force('fr-fr') [there is no French translation]. I
have expected 'Yes' and 'No', but I got again 'Ja' and 'Nein'.
And: how to set the default value?
2011/6/30 Bruno Rocha rochacbr...@gmail.com
IS_IN_SET( [ ('Y',T('Yes')), ('N',T('No')) ] )
Is in set, can receive a list of tuples, where first element is value,
second is text.
On Thu, Jun 30, 2011 at 4:31 PM, Martin Weissenboeck
mweis...@gmail.comwrote:
Hi,
I want to use a SQLFORM with a checkbox. I have tried
... Field('my_question',
requires=[IS_IN_SET([T('Yes'),T('No')]),],
widget=SQLFORM.widgets.checkboxes.widget,
default=T('No'),
),...
I got a nice form with the German translations 'Ja' and 'Nein'.
But now I did not get the English version.
A SELECT like
... SELECT(
OPTION(T('Yes'), _value='Y'),
OPTION(T('No'), _value='N'),
) ...
works depending on the T-language, but I don't know how to put a
_values into the SQLFORM.
Any hints?
Regards, Martin
--
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]
--
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]
Re: [web2py] Re: reponse.js Update 2 Targets.
Reminder :
When 2 components have to be refresh with on this schema :
web2py_component('%s',target) % URL()
response.js=web2py_component('%s','two'); %
URL('ref','create_fvte',args='ref_vregistry')
response.js+=web2py_component('%s','three'); %
URL('ref','create_fvte',args='ref_tregistry')
Richard
On Wed, May 25, 2011 at 8:20 AM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
No your syntax is correct. Can you email me a minimalist app so I can
try it quickly?
On May 24, 11:05 pm, David J. da...@styleflare.com wrote:
I am using Trunk;
Is my syntax correct?
should it be a ',' instead of a ';'
response.js =
'web2py_component(url,target),web2py_component(other_url,other_target);'
On 5/24/11 11:40 PM, Massimo Di Pierro wrote:
There is no reason why it should not work. Are you using trunk? There
was in bug in stable about response.js.
On May 24, 8:25 pm, David J.da...@styleflare.com wrote:
I was wondering how I can update 2 targets with reponse.js?
I tried this
response.js =
'web2py_component(url,target);web2py_component(other_url,other_target);'
Seems only the first updated.
Any ideas?
Re: [web2py] slices and generic.load
Thanks for pointing this out Anthony - I'll try to find time to update my slice demo app soon. ~Brian
Re: [web2py] requires and T()
Yes, I have tried it too and the translation works very fine. But my problem
is: how to get the original strings 'Yes' and 'No'
I have forced a language with no translation (in my example
T.force('fr-fr')) and I thought, this would give the original strings. But I
got again the German strings. T.accepted-language is really 'fr-fr'.
2011/6/30 Bruno Rocha rochacbr...@gmail.com
I just tested it and works perfectly.
Are you sure do you have the string translated in language file?
My test:
T.force('pt-br')
print T.accepted_language # printed ok pt-br in terminal
myset = [ ('Y', T('Yes')), ('N', T('No')) ]
db.define_table('question',
Field('my_question',
requires = [IS_IN_SET(myset)],
widget = SQLFORM.widgets.checkboxes.widget,
default = T('No'),
)
)
I got Sim , Não in portuguese.
But I needed to update my language files.
On Thu, Jun 30, 2011 at 4:55 PM, Martin Weissenboeck
mweis...@gmail.comwrote:
Great, thank you - it solves the _value-problem.
But the other problem is not solved: I get only the translated version
(German), not dependig on the selected language.
I have tried it with T.force('fr-fr') [there is no French translation]. I
have expected 'Yes' and 'No', but I got again 'Ja' and 'Nein'.
And: how to set the default value?
2011/6/30 Bruno Rocha rochacbr...@gmail.com
IS_IN_SET( [ ('Y',T('Yes')), ('N',T('No')) ] )
Is in set, can receive a list of tuples, where first element is value,
second is text.
On Thu, Jun 30, 2011 at 4:31 PM, Martin Weissenboeck mweis...@gmail.com
wrote:
Hi,
I want to use a SQLFORM with a checkbox. I have tried
... Field('my_question',
requires=[IS_IN_SET([T('Yes'),T('No')]),],
widget=SQLFORM.widgets.checkboxes.widget,
default=T('No'),
),...
I got a nice form with the German translations 'Ja' and 'Nein'.
But now I did not get the English version.
A SELECT like
... SELECT(
OPTION(T('Yes'), _value='Y'),
OPTION(T('No'), _value='N'),
) ...
works depending on the T-language, but I don't know how to put a
_values into the SQLFORM.
Any hints?
Regards, Martin
--
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]
--
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em desenvolvimento web: http://www.blouweb.com ]
Re: [web2py] id not starting with 1?
Thank you for your answer. I am using the built-in database, sqlite3. Where can I find the sequence? 2011/6/30 Richard Vézina ml.richard.vez...@gmail.com I think it will depend of your database backend and how you setup your sequence generating... Web2py by default will create a basic sequence then you should go in your database management software (ex.: pgAdmin for postgres) to setup the proper caracteristic of your sequence... Your may override the name of you sequence with sequence_name='YOURSEQUENCENAME' in your model... Richard On Thu, Jun 30, 2011 at 3:34 PM, Martin Weissenboeck mweis...@gmail.comwrote: Hi, is it possible to create a new table with an id-field not starting with 1. I think it would be better to have numbers of equal length. And - if it's possible - does it reduce efficiency? Regards., Martin
[web2py] Re: id not starting with 1?
Well, length of an integer field is always the same... but I understand what you want to mean, because I am on the same situation I guess you are looking for an ID to identify records, but It's not convenient that the ID indicates the order of creation In my case, is the affiliate ID, and I've been asked generating an 3 or 4 digits number automatically, also I need multiple database syncronization, so I am thinking on creating an auxiliar table with indexes Anyone has a simpler solution? On Jun 30, 9:34 pm, Martin Weissenboeck mweis...@gmail.com wrote: Hi, is it possible to create a new table with an id-field not starting with 1. I think it would be better to have numbers of equal length. And - if it's possible - does it reduce efficiency? Regards., Martin
[web2py] Re: Image upload filenames too long
pbreit wrote: The filename that Web2py is giving my uploaded images is too long. Is it possible to make it shorter? For example (i need them to be under 150 chars): item.image.8651e61b27b66998.6974656d2e696d6167652e396363373962663466616535313834392e3533353434313566333233323331333432653461353034375f646973706c61792e6a706567.jpeg Greetings, I encountered something similar a while ago, and Massimo was good enough to implement a small change. In dal.py there is a line that truncates long filenames: class Field(Expression): snip def store(...): snip newfilename = newfilename[:200] + '.' + extension I suspect you would be able to replace 200 with 150 (or slightly less if your 150 characters needs to include the dot and extension). Rowdy
[web2py] Re: Image upload filenames too long
Yeah, I did find your original thread after some searching. And wondered if it might be worth either shortening outright or making it configurable. I've implemented 50 chars which seems like plenty to me.
Re: [web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
UNIQUE applies at the database level. IS_NOT_IN_DB applies during form validation. I'm not sure that's going to work. Maybe a custom validator? http://web2py.com/book/default/chapter/07#Custom-Validators
Re: [web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
IS_NOT_IN_DB does take a DAL Set object as the first argument, so you can limit the records checked to a particular set within the table (see http://web2py.com/book/default/chapter/07#Database-Validators). However, I'm not quite sure what you're trying to do here. On Thursday, June 30, 2011 4:27:56 PM UTC-4, Richard wrote: Hello, Is it possible to declare UNIQUE constraint over many fields and how... Does using IS_NOT_IN_DB() on the differents fields will work? ...num_part1.requires=IS_NOT_IN_DB(db((db.ref_fnaregistry.num_part1==request.vars.num_part1) (db.ref_fnaregistry.num_part2==request.vars.num_part2) (db.ref_fnaregistry.num_part3==request.vars.num_part3) (db.ref_fnaregistry.title==request.vars.title)),db.ref_fnaregistry.num_part1) etc. But I think i need to concatenate... If there is no way I think I know how I will do it. Richard
[web2py] Unable to edit records in appadmin due to fk constraint
I'm still having trouble editing records in appadmin due to a foreign key constraint. Even though I'm logged in as auth_user.id=5, it's trying to set modified_by=0. This was in trying to update a custom auth_user table which has an auth.signature. Traceback (most recent call last): File /opt/web2py/gluon/restricted.py, line 192, in restricted exec ccode in environment File /opt/web2py/applications/init/controllers/appadmin.py, line 410, in module File /opt/web2py/gluon/globals.py, line 137, in lambda self._caller = lambda f: f() File /opt/web2py/applications/init/controllers/appadmin.py, line 277, in update if form.accepts(request.vars, session): File /opt/web2py/gluon/sqlhtml.py, line 1203, in accepts self.table._db(self.table._id == self.record.id).update(**fields) File /opt/web2py/gluon/dal.py, line 5407, in update return self.db._adapter.update(tablename,self.query,fields) File /opt/web2py/gluon/dal.py, line 1002, in update self.execute(sql) File /opt/web2py/gluon/dal.py, line 1251, in execute return self.log_execute(*a, **b) File /opt/web2py/gluon/dal.py, line 1246, in log_execute ret = self.cursor.execute(*a,**b) IntegrityError: insert or update on table auth_user violates foreign key constraint auth_user_modified_by_fkey DETAIL: Key (modified_by)=(0) is not present in table auth_user.
[web2py] Dropdown field not being accepted
Hi
I'm looking at doing a neural net 20 questions type program at some
stage, but still having difficulty with the basics.
Currently if I do a dropdown field, it won't let me enter the data
unless the question on the NEXT screen is the same as this one.
I know it's something to do with the fact that I'm deliberately
relooping through the same page with different data, but it shouldn't
reloop BEFORE it's verified and entered the data, should it?
After all, it has to use X just to do the dropdown, and the x hasn't
changed before you enter the data.
def l():
from random import randint
row = 1
f1=db().select(db.questions.ALL,orderby=db.questions.id)
f2=db().select(db.answers.ALL,orderby=db.answers.id)
f3=db().select(db.big.ALL,orderby=db.big.id)
f4=db(db.big.id == row).select() #This is last row, the stuff
currently being entered
#QUESTION_AND_ANSWER
x=randint(1,3)
question_asking = db(db.questions.q_number == x).select()[0].q_para01
your_answer = SQLFORM.factory(Field('reply',requires =
IS_IN_DB(db(db.answers.q_number == x),answers.id,'%
(a_options)s')))
#fill in correct row
if your_answer.accepts(request.vars,session):
put_in_big = db(db.answers.number == your_answer.vars.reply).select()
[0].a_options
if x == 1:
db(db.big.number == row).update(col01=put_in_big)
if x == 2:
db(db.big.number == row).update(col02=put_in_big)
if x == 3:
db(db.big.number == row).update(col03=put_in_big)
redirect(URL('l'))
return
dict(f1=f1,f2=f2,f3=f3,f4=f4,x=x,question_asking=question_asking,your_answer=your_answer,row=row)
(These been imported)
TABLE questions
questions.id,questions.q_number,questions.q_para01
1,1,'Q1 Where are you?'
2,2,'Q2 Are you a tiger?'
3,3,'Q3 Are you a shark?'
TABLE answers
answers.id,answers.q_number,answers.a_options,answers.a_value
1,1,'Land',1
2,1,'Sea',1
3,2,'Yes',1
4,2,'No',2
5,3,'Yes',1
6,3,'No',2
I would really appreciate figuring this out - I've been stuck for a
couple of weeks on this.
[web2py] Hiding submit button on Crud forms
Hello! I've been away for a while but am diving back into web2py for a new project. I want to host my Crud forms in jqueryui dialogs so I need to hide the submit button. I know I can do it using form.element(input,_type=submit)[_style] = display:none; trickery but I want to avoid extra processing like this. With SQLFORM you can pass buttons=[] but not so much with Crud. Am I just missing it?
Re: [web2py] slices and generic.load
Both slice bitbucket repo should be fixed to work with web2py 1.97.1 now - Thanks Richard for pointing this out and Anthony for helping to explain the problem. Let me know if there are more issues. ~Brian
Re: [web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
On Thu, Jun 30, 2011 at 4:15 PM, Anthony abasta...@gmail.com wrote: IS_NOT_IN_DB does take a DAL Set object as the first argument, so you can limit the records checked to a particular set within the table (see http://web2py.com/book/default/chapter/07#Database-Validators). However, I'm not quite sure what you're trying to do here. I think what he wants is the equivalent of Django's unique together, which I'm also trying to figure out. IS_NOT_IN_DB seems to accomplish it, but is that going to create a unique index on the combined fields? Otherwise, it will be expensive to do inserts. Nick
Re: [web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
On Thursday, June 30, 2011 9:43:39 PM UTC-4, Nick Arnett wrote: On Thu, Jun 30, 2011 at 4:15 PM, Anthony abas...@gmail.com wrote: IS_NOT_IN_DB does take a DAL Set object as the first argument, so you can limit the records checked to a particular set within the table (see http://web2py.com/book/default/chapter/07#Database-Validators). However, I'm not quite sure what you're trying to do here. I think what he wants is the equivalent of Django's unique together, which I'm also trying to figure out. IS_NOT_IN_DB seems to accomplish it, but is that going to create a unique index on the combined fields? Otherwise, it will be expensive to do inserts. I don't think web2py automatically creates any indexes -- see http://web2py.com/book/default/chapter/06#Indexes.
Re: [web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
On Thu, Jun 30, 2011 at 6:43 PM, Nick Arnett nick.arn...@gmail.com wrote:
On Thu, Jun 30, 2011 at 4:15 PM, Anthony abasta...@gmail.com wrote:
IS_NOT_IN_DB does take a DAL Set object as the first argument, so you can
limit the records checked to a particular set within the table (see
http://web2py.com/book/default/chapter/07#Database-Validators). However,
I'm not quite sure what you're trying to do here.
I think what he wants is the equivalent of Django's unique together,
which I'm also trying to figure out. IS_NOT_IN_DB seems to accomplish it,
but is that going to create a unique index on the combined fields?
Otherwise, it will be expensive to do inserts.
Actually, I don't see how NOT_IN_DB can accomplish this, since it is
associated with a single field. Do I have to create an extra concatenated
field and make it unique? Seems silly, given that's what a database unique
index is.
In other words, for table foo, if I want fields A, B and C to be unique
together, do I have to do this?
db.define_table('foo', Field('A'), Field('B'), Field('C'),
Field('ABC_unique', unique=True))
And remember to concat A, B, and C into that last field every time I do an
insert?
I'm missing something here, since this is so simple elsewhere.
Nick
Re: [web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
On Thu, Jun 30, 2011 at 7:00 PM, Anthony abasta...@gmail.com wrote: I don't think web2py automatically creates any indexes -- see http://web2py.com/book/default/chapter/06#Indexes. It has to! Can't have primary keys without them. But I see what you mean, looking at the docs. I guess I will just use that approach to create a multi-column unique index but at this point I was really hoping to avoid raw SQL. Nick
[web2py] Re: slices and generic.load
about the slices... some of us are writing a book on recipes and I we are using some ideas from the slices. I am finding a lot of good ideas but some of the slices are old and can be improved a lot using new syntax. I cannot share the text of the book for copyright issue but I will share the code examples when done so the slices can be improved and new code checked for errors. Massimo
Re: [web2py] SQL UNIQUE IN WEB2PY : CONSTRAINT unique_test UNIQUE (num_part1, num_part2, num_part3, title)
Custom Validator still seems like the best option: http://web2py.com/book/default/chapter/07#Custom-Validators Although I think unique_together is implemented via db constraints. That seems like a very remote scenario so probably not outlandish that it takes a little code. Postgres, at least, automatically creates the index for primary keys. Otherwise, Web2py does not create any indexes. Validators, by the way, are enforced at the form level and have no direct effect on the db.
[web2py] Re: slices and generic.load
Does that mean anything that goes in the book cannot be posted and modified elsewhere? I'd much rather see a more permissive resource. The copyright and licensing issues in this community are unfortunate to say the least.
[web2py] Re: Dropdown field not being accepted
Everything above the if form.accepts() is run each time the submit button is pressed. I can't think of the best way to implement this off-hand. It does seem like you could do it all in one controller. There's a pretty old survey app which might give you some ideas: http://www.web2py.com/appliances/default/show/66
[web2py] Re: Unable to edit records in appadmin due to fk constraint
Does anyone here edit records in /appadmin on a postgres db? It should work, right?
Re: [web2py] Re: slices and generic.load
On Thu, Jun 30, 2011 at 11:46 PM, pbreit pbreitenb...@gmail.com wrote: Does that mean anything that goes in the book cannot be posted and modified elsewhere? I'd much rather see a more permissive resource. The copyright and licensing issues in this community are unfortunate to say the least. Massimo is not referring the web2py official book , he is talking about another book. -- -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] [ Aprenda a programar: http://CursoDePython.com.br ] [ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ] [ Consultoria em desenvolvimento web: http://www.blouweb.com ]
[web2py] looks familiar, could be useful
https://github.com/MisterRager/DOMination
Re: [web2py] Re: slices and generic.load
Yes, I was concerned with the other book. But it'd also be nice if the Book content could be used in different ways, too.
Re: [web2py] Problem with 1.97.1??
Yor're facing to a reported bug. In the bug report you can find a workaround
to continue working: http://code.google.com/p/web2py/issues/detail?id=319
2011/6/30 Jim Steil j...@qlf.com
Hi
I have an app I've been working on and upgraded my system to 1.97.1 today.
Since then I'm getting the following with an AJAX call for json data:
Traceback (most recent call last):
File gluon/restricted.py, line 192, in restricted
File C:/dev/web2py/applications/InfoCenter/controllers/administration.py
http://127.0.0.1:8000/admin/default/edit/InfoCenter/controllers/administration.py,
line 862, in module
File gluon/globals.py, line 137, in lambda
File C:/dev/web2py/applications/InfoCenter/controllers/administration.py
http://127.0.0.1:8000/admin/default/edit/InfoCenter/controllers/administration.py,
line 17, in call
File gluon/tools.py, line 3918, in __call__
File gluon/tools.py, line 3734, in serve_json
File gluon/tools.py, line 3404, in universal_caller
TypeError: object of type 'NoneType' has no len()
My call from my template looks like this:
jQuery(document).ready(function(){
jQuery(#list).jqGrid({
url:'/InfoCenter/administration/call/json/userList',
datatype: 'json',
postData:{'searchText':$(#searchText).val()},
colModel :[ {
name:'id',
index:'id',
label:'ID',
hidden:true,
},
{
name:'lastFirst',
index:'lastFirst',
width:'50%',
label:'Name',
},
{
name:'email',
index:'email',
width:'50%',
label:'Email',
},
],
pager: '#pager',
rowNum:20,
sortname: lastFirst,
sortorder: 'asc',
width: 875,
height: 100%,
ondblClickRow: function(){
var row_id = $(#list).getGridParam('selrow');
window.location.href = /InfoCenter/administration/user/ + row_id;
return true;
},
caption:'',
});
jQuery(#list).navGrid(#pager,
{edit:false,add:false,del:true,search:false},
{},
{},
{msg:Delete selected row(s),
bSubmit:Delete,
bCancel:Cancel,
url:/InfoCenter/administration/userDelete,
reloadAfterSubmit:true}
);
});
This works in the 1.96.x branches by not 1.97.1. And, it never gets to the
method in the controller. Line in administration.py is the last line of the
call() method:
and line 862 doesn't exist in the controller, it ends at 861:
Any thoughts? I'm stumped (but also pretty new to web2py).
-Jim
ghbgbjgj.pngdgagieea.png
