[web2py:36017] forms

2009-11-26 Thread kurdt

hi,

i am actually a django user, I want to try web2py, but I could like to
know if web2py has FORMS? Forms that can be customize not the one that
inherit from a MODEL. And of the coolest things I like about Django is
there FORMS, very flexible (adding custom function or overriding
function). Does web2py have Forms similar to django?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:36018] Re: bad image and word Validator

2009-11-26 Thread Simo
Thank, this solve a part of a problem, my site is also  for french community
.
 thanks for web2py users , am a java programmer and am very happy to use
web2py

On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  wrote:

>
> As a bad words validator you can try this one:
>
> http://web2py.com/examples/static/badwords.py
>
> Detecting p**n images is complex well beyond me. I do not know if
> there is a web service that provides that as a service.
>
> Massimo
> >
>


-- 
Emmanuel Simo

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



Re: [web2py:36019] forms

2009-11-26 Thread Simo
You cant custum your form. this is one example a use.

  form=FORM(TABLE(TR("categorie:",A(category(1),
_href=URL(r=request,c=request.controller, f='category',
args=request.args))),
TR("sous categorie:",A(category(3),
_href=URL(r=request,c=request.controller, f='subcagegory',
args=request.args))),
TR("region:",SELECT(selectlabels
,_id="province",_name="province",_onChange="document.location='"+URL(r=request,f=request.function,args=request.args)+"?pro='+this.value;")),
TR("ville:", SELECT(selectcities
,_id="city",_name="city",_onChange="ajax('"+URL(r=request,f='ajaxgetzone')+"',['city'],'z');"),DIV(_id="z")),
TR("quartier:
",INPUT(_type="text",_id="zone",_name="zone",requires=IS_BAD()
 if form.accepts(request.vars,session):
 insertlocation
=db.an_location.insert(province=form.vars.province,city=form.vars.city,
zone=form.vars.zone)
 redirect(URL(r=request,f='attachimage',args=args,vars=var ))


On Thu, Nov 26, 2009 at 9:12 AM, kurdt  wrote:

>
> hi,
>
> i am actually a django user, I want to try web2py, but I could like to
> know if web2py has FORMS? Forms that can be customize not the one that
> inherit from a MODEL. And of the coolest things I like about Django is
> there FORMS, very flexible (adding custom function or overriding
> function). Does web2py have Forms similar to django?
> --~--~-~--~~~---~--~~
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web2py@googlegroups.com
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en
> -~--~~~~--~~--~--~---
>
>


-- 
Emmanuel Simo

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36020] Re: Help with frames

2009-11-26 Thread Lydia Manikonda
Something like breaking a particular page in to some frames.

Like in html we normally mention like for example:



A simple frameset document


  
  
  
  
  
  
  This frameset document contains:
  
 Some neat contents
 
 Some other neat
contents
  
  


that might create a frame layout something like this:

 
|  | |
|  | |
| Frame 1 | |
|  | |
|  | |
|--| |
|  |  Frame 3   |
|  | |
|  | |
|  | |
| Frame 2 | |
|  | |
|  | |
|  | |
|  | |
 

On Nov 24, 9:36 pm, mdipierro  wrote:
> Something like this?
>
> http://google.com";>
>
> On Nov 24, 9:50 am, Lydia Manikonda  wrote:
>
>
>
> > I'm very new to web2py. I want to include the HTML frames in my .html
> > file of web2py. Can anyone kindly let me know how to use frameset and
> > frames.
>
> > Thanks in advance.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36021] Re: forms

2009-11-26 Thread mdipierro
Yes. One way to do it is

form=SQLFORM.factory(Field('name'),
 Field('gender',requires=IS_IN_SET(('Male','Female'

(gender field will be render with select dropbox).
You can embed it in template with

{{=form}}

or customized

{{=form.custom.begin}}

{{=form.custom.widget.name}}
{{=form.custom.widget.gender}}

{{=form.custom.submit}}
{{=form.custom.end}}


On Nov 26, 2:12 am, kurdt  wrote:
> hi,
>
> i am actually a django user, I want to try web2py, but I could like to
> know if web2py has FORMS? Forms that can be customize not the one that
> inherit from a MODEL. And of the coolest things I like about Django is
> there FORMS, very flexible (adding custom function or overriding
> function). Does web2py have Forms similar to django?

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36022] Re: Help with frames

2009-11-26 Thread mdipierro
In the templates (which we call views) you can put any HTML you like.
You can put the HTML of your example without any change.

Anyway, as a more general advice, you should use frames if the content
is a complete HTML page. If you are trying to embed the output of a
web2py action there are better ways that result in less communication.
I.e. embed the page via ajax and  or  instead of using
frames.

Massimo

On Nov 26, 2:48 am, Lydia Manikonda  wrote:
> Something like breaking a particular page in to some frames.
>
> Like in html we normally mention like for example:
>
> 
> 
> A simple frameset document
> 
> 
>   
>       
>       
>   
>   
>   
>       This frameset document contains:
>       
>          Some neat contents
>          
>          Some other neat
> contents
>       
>   
> 
> 
> that might create a frame layout something like this:
>
>  
> |              |                             |
> |              |                             |
> | Frame 1 |                             |
> |              |                             |
> |              |                             |
> |--|                             |
> |              |          Frame 3       |
> |              |                             |
> |              |                             |
> |              |                             |
> | Frame 2 |                             |
> |              |                             |
> |              |                             |
> |              |                             |
> |              |                             |
>  
>
> On Nov 24, 9:36 pm, mdipierro  wrote:
>
> > Something like this?
>
> > http://google.com";>
>
> > On Nov 24, 9:50 am, Lydia Manikonda  wrote:
>
> > > I'm very new to web2py. I want to include the HTML frames in my .html
> > > file of web2py. Can anyone kindly let me know how to use frameset and
> > > frames.
>
> > > Thanks in advance.
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36023] Re: bad image and word Validator

2009-11-26 Thread mdipierro
If you can find a list of bad french words (singular and plural), I
cam modify the validator to be extensible.

On Nov 26, 2:30 am, Simo  wrote:
> Thank, this solve a part of a problem, my site is also  for french community
> .
>  thanks for web2py users , am a java programmer and am very happy to use
> web2py
>
> On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  wrote:
>
> > As a bad words validator you can try this one:
>
> >http://web2py.com/examples/static/badwords.py
>
> > Detecting p**n images is complex well beyond me. I do not know if
> > there is a web service that provides that as a service.
>
> > Massimo
>
> --
> Emmanuel Simo

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36024] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Mi experience with spam on blogs and cms engine is that 70% of spam
comments
are in english, 10-15% in chinese, 10% in russian and only the
remaining 5%
is written in my own language. Do you have the same experiences?
One great feature for web2py could be a bayesan antispam filter,
something like
Akismet for example.

On 26 Nov, 10:51, mdipierro  wrote:
> If you can find a list of bad french words (singular and plural), I
> cam modify the validator to be extensible.
>
> On Nov 26, 2:30 am, Simo  wrote:
>
> > Thank, this solve a part of a problem, my site is also  for french community
> > .
> >  thanks for web2py users , am a java programmer and am very happy to use
> > web2py
>
> > On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  wrote:
>
> > > As a bad words validator you can try this one:
>
> > >http://web2py.com/examples/static/badwords.py
>
> > > Detecting p**n images is complex well beyond me. I do not know if
> > > there is a web service that provides that as a service.
>
> > > Massimo
>
> > --
> > Emmanuel Simo

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36025] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Mi experience with spam on blogs and cms engine is that 70% of spam
comments
are in english, 10-15% in chinese, 10% in russian and only the
remaining 5%
is written in my own language. Do you have the same experiences?
One great feature for web2py could be a bayesan antispam filter,
something like
Akismet for example.

On 26 Nov, 10:51, mdipierro  wrote:
> If you can find a list of bad french words (singular and plural), I
> cam modify the validator to be extensible.
>
> On Nov 26, 2:30 am, Simo  wrote:
>
> > Thank, this solve a part of a problem, my site is also  for french community
> > .
> >  thanks for web2py users , am a java programmer and am very happy to use
> > web2py
>
> > On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  wrote:
>
> > > As a bad words validator you can try this one:
>
> > >http://web2py.com/examples/static/badwords.py
>
> > > Detecting p**n images is complex well beyond me. I do not know if
> > > there is a web service that provides that as a service.
>
> > > Massimo
>
> > --
> > Emmanuel Simo

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36026] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Or we could implement akismet for python... :-)
http://www.voidspace.org.uk/python/akismet_python.html

On 26 Nov, 10:51, mdipierro  wrote:
> If you can find a list of bad french words (singular and plural), I
> cam modify the validator to be extensible.
>
> On Nov 26, 2:30 am, Simo  wrote:
>
> > Thank, this solve a part of a problem, my site is also  for french community
> > .
> >  thanks for web2py users , am a java programmer and am very happy to use
> > web2py
>
> > On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  wrote:
>
> > > As a bad words validator you can try this one:
>
> > >http://web2py.com/examples/static/badwords.py
>
> > > Detecting p**n images is complex well beyond me. I do not know if
> > > there is a web service that provides that as a service.
>
> > > Massimo
>
> > --
> > Emmanuel Simo

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36027] Re: bad image and word Validator

2009-11-26 Thread mdipierro
This is written in python too and the complete source is available:
http://spambayes.sourceforge.net/

Massimo

On Nov 26, 4:24 am, Doxaliber  wrote:
> Or we could implement akismet for python... 
> :-)http://www.voidspace.org.uk/python/akismet_python.html
>
> On 26 Nov, 10:51, mdipierro  wrote:
>
> > If you can find a list of bad french words (singular and plural), I
> > cam modify the validator to be extensible.
>
> > On Nov 26, 2:30 am, Simo  wrote:
>
> > > Thank, this solve a part of a problem, my site is also  for french 
> > > community
> > > .
> > >  thanks for web2py users , am a java programmer and am very happy to use
> > > web2py
>
> > > On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  
> > > wrote:
>
> > > > As a bad words validator you can try this one:
>
> > > >http://web2py.com/examples/static/badwords.py
>
> > > > Detecting p**n images is complex well beyond me. I do not know if
> > > > there is a web service that provides that as a service.
>
> > > > Massimo
>
> > > --
> > > Emmanuel Simo
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36028] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread yamandu
The problem when I update is that was not possible to see the error.
I got ticket screen but the link always led to another ticket screen.
So I think there was a problem under my app too.

On Nov 25, 12:38 pm, mdipierro  wrote:
> I do not understand. where you not getting a ticket? Something wrong
> with the ticket?
>
> On Nov 25, 6:45 am, yamandu  wrote:
>
>
>
> > In fact, it was an almost obvious thing.
> > There was a bracket mistake on my code that I discover reverting to an
> > older version.
> > But the strange thing is that in the older version I could find the
> > error by clicking the ticket link but not in the 1.72.3 version.
> > Maybe this is a bug?
>
> > On 25 nov, 10:03, yamandu  wrote:
>
> > > The update method I used was simply copy merging the files from the
> > > new version with the installation ones.
>
> > > On Nov 25, 9:24 am, yamandu  wrote:
>
> > > > I had previous install through source (because I use GAE in
> > > > production).
> > > > Thought the crash could be because of python 2.6 recent installation
> > > > but I remove it and nothing changed.
>
> > > > After updating nothing works! Only thing I get is an ticket screen!
> > > > An when I click the ticket link it lead me to another ticket screen.
> > > > I think I used a wrong and stupid update method!
> > > > But the same had worked on previous updates.
>
> > > > What would be the proper way to update an existing installation from
> > > > source?
>
> > > > On Nov 24, 4:29 pm, Yarko Tymciurak 
> > > > wrote:
>
> > > > > what is it that I remember about this sort of thing?:   clear sessions
> > > > > files?   sqlite migration issues (table files, but no tables - as 
> > > > > could
> > > > > happen is you install new web2py, but manually move your app)?
>
> > > > > Look at some obvious things, then tell more of what is going on, how 
> > > > > you set
> > > > > this up...
>
> > > > > On Tue, Nov 24, 2009 at 10:32 AM, mdipierro  
> > > > > wrote:
>
> > > > > > Can you tell us more? What does not work?
>
> > > > > > On Nov 24, 7:30 am, yamandu  wrote:
> > > > > > > Before I updated to 1.72.3 it does not run.
> > > > > > > It goes to the ticket page and does not even open the ticket link.
>
> > > > > > > Any issue with this version?

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36029] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Great. An open source solution is always better for me. :-)
We could create a plugin to use this filter for comments and
other user generated contents.

On 26 Nov, 12:09, mdipierro  wrote:
> This is written in python too and the complete source is 
> available:http://spambayes.sourceforge.net/
>
> Massimo
>
> On Nov 26, 4:24 am, Doxaliber  wrote:
>
> > Or we could implement akismet for python... 
> > :-)http://www.voidspace.org.uk/python/akismet_python.html
>
> > On 26 Nov, 10:51, mdipierro  wrote:
>
> > > If you can find a list of bad french words (singular and plural), I
> > > cam modify the validator to be extensible.
>
> > > On Nov 26, 2:30 am, Simo  wrote:
>
> > > > Thank, this solve a part of a problem, my site is also  for french 
> > > > community
> > > > .
> > > >  thanks for web2py users , am a java programmer and am very happy to use
> > > > web2py
>
> > > > On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  
> > > > wrote:
>
> > > > > As a bad words validator you can try this one:
>
> > > > >http://web2py.com/examples/static/badwords.py
>
> > > > > Detecting p**n images is complex well beyond me. I do not know if
> > > > > there is a web service that provides that as a service.
>
> > > > > Massimo
>
> > > > --
> > > > Emmanuel Simo

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36030] Re: possible ? WYSIWYG editor with integrated image upload

2009-11-26 Thread David
Mr Romero's been holding out on the goods it seems.

This something I need as well.  A simple tutorial and app example on
web2py slices would be most excellent.

Thank you for the work Jon!

- David

On Nov 25, 11:29 am, "mr.freeze"  wrote:
> Yes, more please!
>
> On Nov 25, 11:03 am, mdipierro  wrote:
>
>
>
> > Hey, what's this awsome CMS? we want to know more.
>
> > On Nov 25, 10:36 am, Jon Romero  wrote:
>
> > > Sorry for the late reply!
> > > I have already integrate CKEditor WITH uploading into web2py (check a
> > > screenshot here:http://emotionull.com/blog_files/ckeditor.png) for a
> > > new CMS my company is building (yeap, in web2py and probably it will
> > > be released as opensource).
> > > You just need to create an action/view to upload the file which
> > > returns the vars CKEditorFuncNum and url:
>
> > > def upload_file():
> > >         url = ""
> > >         form = SQLFORM(db.files, showid=False, fields=['title',
> > > 'uploaded_data'])
> > >         if form.accepts(request.vars, session):
> > >                 response.flash = T('File uploaded successfully!')
> > >                 url = URL(r=request, f="download", args = 
> > > db(db.files.title ==
> > > request.vars.title).select(orderby=~db.files.created_on)
> > > [0].uploaded_data)
>
> > >         return dict(form=form, cknum=request.vars.CKEditorFuncNum, 
> > > url=url)
>
> > > If you have any problems, I could write a tutorial an release a small
> > > app.
>
> > > On Nov 25, 2:33 pm, David  wrote:
>
> > > > Also found this:
>
> > > >http://zerokspot.com/weblog/2009/09/09/custom-filebrowser-callbacks-c...
>
> > > > On Nov 25, 5:53 am, David  wrote:
>
> > > > > I don't know if this helps but I've found this:
>
> > > > >http://docs.cksource.com/CKEditor_3.x/Developers_Guide/File_Browser_(...
>
> > > > > and
>
> > > > >http://docs.cksource.com/CKEditor_3.x/Developers_Guide/File_Browser_(...)
>
> > > > > On Nov 19, 10:23 pm, Thadeus Burgess  wrote:
>
> > > > > > I don't think it needs RPC. Just to return XML data.
>
> > > > > > It shouldn't be hard, we just need to start gathering data that gets
> > > > > > communicated between CKFinder and the server. They don't really 
> > > > > > have any
> > > > > > examples for implementing backend code, since they expect you to 
> > > > > > use their
> > > > > > written code, which is way more complicated than it needs to be.
>
> > > > > > -Thadeus
>
> > > > > > On Thu, Nov 19, 2009 at 10:18 PM, Wes James  
> > > > > > wrote:
>
> > > > > > > web2py has xmlrpc service - would that help any?
>
> > > > > > > -wes
>
> > > > > > > On Thu, Nov 19, 2009 at 9:05 PM, Thadeus Burgess 
> > > > > > > 
> > > > > > > wrote:
> > > > > > > > As far as integratingCKeditor, easy.
>
> > > > > > > > Integrating something like CKFinder however, is a whole nother 
> > > > > > > > story. I
> > > > > > > have
> > > > > > > > been researching, and it seems that the backend code will need 
> > > > > > > > to be
> > > > > > > ported
> > > > > > > > from their examples, to web2py. CKFinder uses mostly XML to 
> > > > > > > > communicate
> > > > > > > for
> > > > > > > > file browsing etc, and with a little bit of firebug magic and 
> > > > > > > > some time,
> > > > > > > I
> > > > > > > > think a workable back end is possible.
>
> > > > > > > > I'm thinking this can be designed as a web2py plug-in.
>
> > > > > > > > -Thadeus
>
> > > > > > > > On Thu, Nov 19, 2009 at 9:48 PM, Darcy Clark  
> > > > > > > > wrote:
>
> > > > > > > >> I'm willing to help on this - however I'm hoping someone with 
> > > > > > > >> a deeper
> > > > > > > >> knowledge of web2py can provide some guidance on where to 
> > > > > > > >> start and
> > > > > > > >> best practice etc...
>
> > > > > > > >> On Nov 20, 12:26 pm, blackthorne  
> > > > > > > >> wrote:
> > > > > > > >> > That was one my first intentions when I got into web2py. 
> > > > > > > >> > Just to say
> > > > > > > >> > I'm willing to work for that. Get a WYSIWYG web based editor 
> > > > > > > >> > like kupu
> > > > > > > >> > or TinyMCE or FCKeditor in web2py for rich content handling. 
> > > > > > > >> > My idea
> > > > > > > >> > for that would be to turn it as a optional setting (namely 
> > > > > > > >> > for the
> > > > > > > >> > views).
> > > > > > > >> > Afaik kupu started outside the Plone project but became 
> > > > > > > >> > "assimilated".
> > > > > > > >> > Seems to me it should be possible to integrate it on any 
> > > > > > > >> > project but
> > > > > > > >> > probably harder than with TinyMCE or FCKeditor/CKeditor.
>
> > > > > > > >> > Anyone feels like putting hands-on this?
>
> > > > > > > >> > On Nov 19, 12:09 am, Darcy Clark  wrote:
>
> > > > > > > >> > > I've come to web2py from a Plone CMS background. Plone 
> > > > > > > >> > > integrated a
> > > > > > > >> > > WYSIWYG editor called kupu which allowed theuploadand 
> > > > > > > >> > > integration
> > > > > > > of
> > > > > > > >> > > images while you were editing rich content (i.e. web 
> > > > > > > >> > > pages

[web2py:36031] Data grids in Web2py

2009-11-26 Thread David
Do we have a data grid widget in web2py?  If not, are there any plans
to include this in the future?

I'm currently building them manually with web2py, which works, but
I've seen dataTables and it looks a lot nicer.  Has anyone used
dataTables?  Do you have any examples that I can reference?

Thanks,
David

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36032] Re: Complex SQL Query - Left Out Join With A Third table...

2009-11-26 Thread Yannick
Thanks Massimo,
I just wonder, I do know that is possible to see the SQL Query by
using _select()... I was wondering if there opposite operation ? Like
if is possible to write the SQL query and see DAL code of web2py ?

Thanks,
Yannick P.

On Nov 25, 9:00 am, mdipierro  wrote:
> Yes.
>
> left=(db.table_B.on(db.table_A.ID = db.table_B.FK)),
>       db.table_C.on(db.table_A.ID = db.table_C.FK)))
>
> On Nov 24, 10:26 pm, Yannick  wrote:
>
> > Hello mate,
> > Let's said for example I have the following:
>
> > rows = db().select(db.table_A.first_name, db.table_B.email,
> > db.table_B.ID,
> >                                                 left=db.table_B.on
> > ( db.table_A.ID = db.table_B.FK) )
>
> > NOW I  want to do  another left OUTER JOIN of the table from 
> > with a third table "table_C" on a condition "db.table_B.ID =
> > db.table_C.ID"
> > How can I do that ?
>
> > Thanks for your help,
>
> > Cheers,
> > Yannick P.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36033] SQL Query with Case Statement...

2009-11-26 Thread Yannick
Hello Mate,

I just double check in the book and the documentation resources
because I was wondering how to actually create a DAL query that
include "Case" statement ?
Like let's say I have an SQL like this :

SELECT salary,
 CASE
 WHEN  salary <= 2000 THEN 'PoorOne'
END AS salary_level
FROM employees
ORDER BY salary ASC


How can I write such a query with "CASE" statement in Web2py ?

Thanks,
Yannick P.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36034] IS_DATE validation not working

2009-11-26 Thread Johann Spies
In my db.py I have this as part of the auth_table:

Field('birthdate', 'date',requires = IS_DATE(format=T('%Y-%m-%d'),
error_message=T('must be -MM-DD!'))),

However, when a non-date is entered, the form accepts it and corrupt
the database resulting in a  ticket.
Why does this validator not work?

Regards
Johann

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




Re: [web2py:36035] Re: Markdown problem

2009-11-26 Thread Johann Spies
2009/11/24 mdipierro :

I am testing with "Post a comment":

> When you do WIKI(,safe_mode='escape') is default. Try with
> safe_mode=None or safe_mode=True.

With "save_mode='escape'" the result is ""

With "save_mode=True" the result is "[HTML_REMOVED]Post a comment[HTML_REMOVED]"

:(

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36036] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread mdipierro
Please try again. When you get the first ticket click on it. If you
get another ticket
/
locate the corresponding ticket file applciations//errors/
and email it to me.

When you upgraded web2py, did you upgraded admin?

web2py.py --upgrade=yes

Massimo

On Nov 26, 5:12 am, yamandu  wrote:
> The problem when I update is that was not possible to see the error.
> I got ticket screen but the link always led to another ticket screen.
> So I think there was a problem under my app too.
>
> On Nov 25, 12:38 pm, mdipierro  wrote:
>
> > I do not understand. where you not getting a ticket? Something wrong
> > with the ticket?
>
> > On Nov 25, 6:45 am, yamandu  wrote:
>
> > > In fact, it was an almost obvious thing.
> > > There was a bracket mistake on my code that I discover reverting to an
> > > older version.
> > > But the strange thing is that in the older version I could find the
> > > error by clicking the ticket link but not in the 1.72.3 version.
> > > Maybe this is a bug?
>
> > > On 25 nov, 10:03, yamandu  wrote:
>
> > > > The update method I used was simply copy merging the files from the
> > > > new version with the installation ones.
>
> > > > On Nov 25, 9:24 am, yamandu  wrote:
>
> > > > > I had previous install through source (because I use GAE in
> > > > > production).
> > > > > Thought the crash could be because of python 2.6 recent installation
> > > > > but I remove it and nothing changed.
>
> > > > > After updating nothing works! Only thing I get is an ticket screen!
> > > > > An when I click the ticket link it lead me to another ticket screen.
> > > > > I think I used a wrong and stupid update method!
> > > > > But the same had worked on previous updates.
>
> > > > > What would be the proper way to update an existing installation from
> > > > > source?
>
> > > > > On Nov 24, 4:29 pm, Yarko Tymciurak 
> > > > > wrote:
>
> > > > > > what is it that I remember about this sort of thing?:   clear 
> > > > > > sessions
> > > > > > files?   sqlite migration issues (table files, but no tables - as 
> > > > > > could
> > > > > > happen is you install new web2py, but manually move your app)?
>
> > > > > > Look at some obvious things, then tell more of what is going on, 
> > > > > > how you set
> > > > > > this up...
>
> > > > > > On Tue, Nov 24, 2009 at 10:32 AM, mdipierro 
> > > > > >  wrote:
>
> > > > > > > Can you tell us more? What does not work?
>
> > > > > > > On Nov 24, 7:30 am, yamandu  wrote:
> > > > > > > > Before I updated to 1.72.3 it does not run.
> > > > > > > > It goes to the ticket page and does not even open the ticket 
> > > > > > > > link.
>
> > > > > > > > Any issue with this version?
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36037] Re: bad image and word Validator

2009-11-26 Thread mdipierro
It would be a nice app.

On Nov 26, 5:24 am, Doxaliber  wrote:
> Great. An open source solution is always better for me. :-)
> We could create a plugin to use this filter for comments and
> other user generated contents.
>
> On 26 Nov, 12:09, mdipierro  wrote:
>
> > This is written in python too and the complete source is 
> > available:http://spambayes.sourceforge.net/
>
> > Massimo
>
> > On Nov 26, 4:24 am, Doxaliber  wrote:
>
> > > Or we could implement akismet for python... 
> > > :-)http://www.voidspace.org.uk/python/akismet_python.html
>
> > > On 26 Nov, 10:51, mdipierro  wrote:
>
> > > > If you can find a list of bad french words (singular and plural), I
> > > > cam modify the validator to be extensible.
>
> > > > On Nov 26, 2:30 am, Simo  wrote:
>
> > > > > Thank, this solve a part of a problem, my site is also  for french 
> > > > > community
> > > > > .
> > > > >  thanks for web2py users , am a java programmer and am very happy to 
> > > > > use
> > > > > web2py
>
> > > > > On Wed, Nov 25, 2009 at 6:01 PM, mdipierro  
> > > > > wrote:
>
> > > > > > As a bad words validator you can try this one:
>
> > > > > >http://web2py.com/examples/static/badwords.py
>
> > > > > > Detecting p**n images is complex well beyond me. I do not know if
> > > > > > there is a web service that provides that as a service.
>
> > > > > > Massimo
>
> > > > > --
> > > > > Emmanuel Simo
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36038] Re: Data grids in Web2py

2009-11-26 Thread mdipierro
Yes

http://web2py-crm.appspot.com/init/default/index

uses datatables. The source is posted on applicances


On Nov 26, 5:45 am, David  wrote:
> Do we have a data grid widget in web2py?  If not, are there any plans
> to include this in the future?
>
> I'm currently building them manually with web2py, which works, but
> I've seen dataTables and it looks a lot nicer.  Has anyone used
> dataTables?  Do you have any examples that I can reference?
>
> Thanks,
> David

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36039] Re: Complex SQL Query - Left Out Join With A Third table...

2009-11-26 Thread mdipierro
Sorry no.

On Nov 26, 6:42 am, Yannick  wrote:
> Thanks Massimo,
> I just wonder, I do know that is possible to see the SQL Query by
> using _select()... I was wondering if there opposite operation ? Like
> if is possible to write the SQL query and see DAL code of web2py ?
>
> Thanks,
> Yannick P.
>
> On Nov 25, 9:00 am, mdipierro  wrote:
>
> > Yes.
>
> > left=(db.table_B.on(db.table_A.ID = db.table_B.FK)),
> >       db.table_C.on(db.table_A.ID = db.table_C.FK)))
>
> > On Nov 24, 10:26 pm, Yannick  wrote:
>
> > > Hello mate,
> > > Let's said for example I have the following:
>
> > > rows = db().select(db.table_A.first_name, db.table_B.email,
> > > db.table_B.ID,
> > >                                                 left=db.table_B.on
> > > ( db.table_A.ID = db.table_B.FK) )
>
> > > NOW I  want to do  another left OUTER JOIN of the table from 
> > > with a third table "table_C" on a condition "db.table_B.ID =
> > > db.table_C.ID"
> > > How can I do that ?
>
> > > Thanks for your help,
>
> > > Cheers,
> > > Yannick P.
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36040] Re: IS_DATE validation not working

2009-11-26 Thread vvk
I faced a similar issue once.

Write "requires" separately as
db.dbname.fieldname.requires = [IS_DATE(error_message = "Must be -
MM-DD")]



On Nov 26, 5:56 pm, Johann Spies  wrote:
> In my db.py I have this as part of the auth_table:
>
> Field('birthdate', 'date',requires = IS_DATE(format=T('%Y-%m-%d'),
> error_message=T('must be -MM-DD!'))),
>
> However, when a non-date is entered, the form accepts it and corrupt
> the database resulting in a  ticket.
> Why does this validator not work?
>
> Regards
> Johann

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36041] Re: SQL Query with Case Statement...

2009-11-26 Thread mdipierro
You cannot but you can try this:

db(db.employees.salary,
"CASE WHEN  salary <= 2000 THEN 'PoorOne' END AS salary_level",
orderby=db.employees.salary)

let us know if it works.

On Nov 26, 6:53 am, Yannick  wrote:
> Hello Mate,
>
> I just double check in the book and the documentation resources
> because I was wondering how to actually create a DAL query that
> include "Case" statement ?
> Like let's say I have an SQL like this :
>
> SELECT salary,
>  CASE
>  WHEN  salary <= 2000 THEN 'PoorOne'
> END AS salary_level
> FROM employees
> ORDER BY salary ASC
>
> How can I write such a query with "CASE" statement in Web2py ?
>
> Thanks,
> Yannick P.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36042] Re: IS_DATE validation not working

2009-11-26 Thread mdipierro
haha. You found a bug. I just fixed it in trunk. For now just use this
workaround


Field('birthdate', 'date',requires = IS_DATE(format=str(T('%Y-%m-
%d')),error_message=str(T('must be
-MM-DD!',

notice the str(T(...)) instead of T(..).

Massimo


On Nov 26, 6:56 am, Johann Spies  wrote:
> In my db.py I have this as part of the auth_table:
>
> Field('birthdate', 'date',requires = IS_DATE(format=T('%Y-%m-%d'),
> error_message=T('must be -MM-DD!'))),
>
> However, when a non-date is entered, the form accepts it and corrupt
> the database resulting in a  ticket.
> Why does this validator not work?
>
> Regards
> Johann

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36043] Re: Markdown problem

2009-11-26 Thread mdipierro
I took a second look.

>>> WIKI('this is a test').xml()
'this is a test\n'
>>> WIKI('this is a test',safe_mode=True).xml()
'this [HTML_REMOVED]is[HTML_REMOVED] a test\n'
>>> WIKI('this is a test',safe_mode=False).xml()
'this is a test\n'
>>> WIKI('this is a test',safe_mode=False).xml()
'this is a test\n'


It seems safe_mode=False is the way to go but it does do any
sanitization either.
This is a problem with the markdown2 library we use.

For now you can do:

XML(WIKI('this is a test',safe_mode=False),sanitize=True)

until I finish rewriting markdown.


On Nov 26, 7:13 am, Johann Spies  wrote:
> 2009/11/24 mdipierro :
>
> I am testing with "Post a comment":
>
> > When you do WIKI(,safe_mode='escape') is default. Try with
> > safe_mode=None or safe_mode=True.
>
> With "save_mode='escape'" the result is ""
>
> With "save_mode=True" the result is "[HTML_REMOVED]Post a 
> comment[HTML_REMOVED]"
>
> :(

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36044] web2py 1.73.1 is OUT for testing

2009-11-26 Thread mdipierro
http://web2py.com/examples/static/1.73.1/web2py_src.zip
http://web2py.com/examples/static/1.73.1/web2py_osx.zip
http://web2py.com/examples/static/1.73.1/web2py_win.zip

Please let me know if you check it out and everything is ok


Fixed problem with storage and comparison of Row objects
Fixed problem with mail on GAE
Fixed problem with T in IS_DATE(TIME) error_message and format
Rows[i].delete_record()
Even better support for legacy databases
Experimantal support for non UTF8 encoding in DB
Better IPV4 (thanks Thandeus)
T.current_languages default to 'en' and new T.set_current_languages
(...) (thanks Yarko)
INPUT(...,hideerror=False) used to fix rare chechbox widget problem
Admin allows change of admin password
New gluon/contrib/populate.py
Size of input/textarea set by CSS no more by jQuery  (thanks Iceberg)
Customizable CSV  (thanks Thandeus)
More bug fixed (thanks Thandeus)
Better regex for template fixed Jython problem (thank Jonathan)

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36045] how i got web2py woking with mod_proxy on ubuntu

2009-11-26 Thread selecta
i have a apache server running which i wanted to show my web2py apps
that are running on the provided server under port 8000
so that i can call
http://localhost/myapp/ <- thats the apache server
instead of
http://127.0.0.1:8000/myapp/ <- thats the web2py server

what i had to do was to install mod proxy
sudo aptitude install libapache2-mod-proxy-html

add to /etc/apache2/httpd.conf
ProxyRequests off
ProxyPass /myapp/ http://127.0.0.1:8000/myapp/
ProxyHTMLURLMap http://127.0.0.1:8000/myapp/ /myapp


ProxyPassReverse /
ProxyHTMLURLMap  /  /myapp/


change in /etc/apache2/mods-enabled/proxy.conf
Deny from all
to
Allow from all

and execute the following commands
ln -s /etc/apache2/mods-available/proxy_http.load /etc/apache2/mods-
enabled/proxy_http.load
sudo a2enmod proxy
sudo /etc/init.d/apache2 restart

yes i did not excatly know what I did in every step and there may be
room for improvements but it works :)

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36046] Export/Import problem

2009-11-26 Thread vvk

I've created database and wrote controllers without using UUID's.
While exporting and importing databases, I'm facing these problems

i)  record id's are getting changed while importing and my search
functions are no longer working because I've reference of id's of
other tables, which are changing

example:
db1(product)
db2(db1.id,person)

I've read in Manual that UUID's should be used to reference rather
than Id's. So should I change all my search functions also to search
by uuid and not by id?

ii) How to modify entire existing database to have UUID's apart from
changing model ? I don't want to recreate entire database.



--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36047] Re: Export/Import problem

2009-11-26 Thread mdipierro
You do not need uuid unless you want to import records that you
already have and want to replace them.

If you use

id_map={}
db.table1.import_from_csv_file(ifile1, id_map=id_map)
db.table2.import_from_csv_file(ifile2, id_map=id_map)

the id_map={} makes sure all references between table1 and table2 are
preserved. References to records that are not imported may still be
broken.

Massimo


On Nov 26, 9:11 am, vvk  wrote:
> I've created database and wrote controllers without using UUID's.
> While exporting and importing databases, I'm facing these problems
>
> i)  record id's are getting changed while importing and my search
> functions are no longer working because I've reference of id's of
> other tables, which are changing
>
> example:
> db1(product)
> db2(db1.id,person)
>
> I've read in Manual that UUID's should be used to reference rather
> than Id's. So should I change all my search functions also to search
> by uuid and not by id?
>
> ii) How to modify entire existing database to have UUID's apart from
> changing model ? I don't want to recreate entire database.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




Re: [web2py:36048] Re: Don't you love it when editors mess up?

2009-11-26 Thread Thadeus Burgess
Actually, it should be self.settings.table_even.

However somehow export_to_csv got stuck in there, and is in SVN trunk.

I think at some point Massimo had export_to_csv in his copy/paste and
somehow his IDE decided to paste it right there and he did not realize.
Eclipse has done that to me many a time.

-Thadeus




On Thu, Nov 26, 2009 at 1:07 AM, Vasile Ermicioi  wrote:

>
> should be self.export_to_csv.settings.table_even
>
>
> Is it because of the built in web2py editor?
>
>
> On Thu, Nov 26, 2009 at 6:03 AM, mr.freeze  wrote:
>
>>
>> What kind of patch are you making??? Sexports and csv elves??? Haha.
>>
>> On Nov 25, 9:52 pm, Thadeus Burgess  wrote:
>> > Traceback (most recent call last):
>> >
>> >   File "/home/Applications/web2py/gluon/tools.py", line 834, in
>> define_tables
>> >
>> > table = sexport_to_csvelf.settings.table_event
>> > NameError: global name 'sexport_to_csvelf' is not defined
>> >
>> > -Thadeus
>>
>>
>
> --~--~-~--~~~---~--~~
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To post to this group, send email to web2py@googlegroups.com
> To unsubscribe from this group, send email to
> web2py+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/web2py?hl=en
> -~--~~~~--~~--~--~---
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36049] Routes

2009-11-26 Thread kbochert
As a new user to web2py, I am trying to get routes.py to work.
Nothing I put into web2py/routes.py has any effect.

example:
  routes_in=(
('^127\.0\.0\.1:.*',
'/examples/default/index'),
  )

Moreover , clear errors in the routes.py have no effect.
i.e.
x = 6/0; @!

Am I overlooking something that I need to do to turn on the rewrite??

Karl

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36050] url rewriting bug in rewrite.py still not fixed

2009-11-26 Thread Wikus van de Merwe
Sorry for advertising the bug here, but as I've noticed that the list
gets 10 times more attention than the issue tracker. Some time ago
I've filled a bug against rewrite.py and its routing rules processing:
http://code.google.com/p/web2py/issues/detail?id=58

It was marked as fixed in trunk but in fact it was not. Normally I
would reopen the bug, but I guess some extra privileges are needed for
that. I have attached a patch before but it was not used, so this time
I've attached a minimal test case showing the incorrect behaviour so
the fix can be easily tested. It would be great if you could take a
second look at it.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36051] Re: Routes

2009-11-26 Thread Yarko Tymciurak
routes.py is read when web2py starts - be sure to re-start whatever
server you are using (or restart web2py, if you are using the builting
server).

On Nov 26, 11:21 am, kbochert  wrote:
> As a new user to web2py, I am trying to get routes.py to work.
> Nothing I put into web2py/routes.py has any effect.
>
> example:
>   routes_in=(
>     ('^127\.0\.0\.1:.*',
>         '/examples/default/index'),
>   )
>
> Moreover , clear errors in the routes.py have no effect.
> i.e.
> x = 6/0; @!
>
> Am I overlooking something that I need to do to turn on the rewrite??
>
> Karl

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36052] Re: Routes

2009-11-26 Thread Wikus van de Merwe
Well, first, you don't need a comma after bracket, when there is only
one rule there.
Second, routes are only processed once when the server is first time
started. Are you restarting your app server each time you change it?

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36053] Re: Export/Import problem

2009-11-26 Thread vvk
I tried these:

Exported into csv file from appadmin interface three tables:
auth_user, allot, product
with allot(auth_user_id, product_id) having id's of user and product

Then tried to import as:

@auth.requires_login()
def backup():
id_map = {}
db.auth_user.import_from_csv_file(open('db_auth_user.csv'), id_map =
id_map)
db.allot.import_from_csv_file(open('db_allot.csv'), id_map = id_map)
db.product.import_from_csv_file(open('db_product.csv'), id_map =
id_map)
redirect(URL(r=request,f='index'))
return dict(form='')

On importing, allot table isn't getting updated id's of auth_user &
allot.

Varun


On Nov 26, 9:34 pm, mdipierro  wrote:
> You do not need uuid unless you want to import records that you
> already have and want to replace them.
>
> If you use
>
> id_map={}
> db.table1.import_from_csv_file(ifile1, id_map=id_map)
> db.table2.import_from_csv_file(ifile2, id_map=id_map)
>
> the id_map={} makes sure all references between table1 and table2 are
> preserved. References to records that are not imported may still be
> broken.
>
> Massimo
>
> On Nov 26, 9:11 am, vvk  wrote:
>
>
>
> > I've created database and wrote controllers without using UUID's.
> > While exporting and importing databases, I'm facing these problems
>
> > i)  record id's are getting changed while importing and my search
> > functions are no longer working because I've reference of id's of
> > other tables, which are changing
>
> > example:
> > db1(product)
> > db2(db1.id,person)
>
> > I've read in Manual that UUID's should be used to reference rather
> > than Id's. So should I change all my search functions also to search
> > by uuid and not by id?
>
> > ii) How to modify entire existing database to have UUID's apart from
> > changing model ? I don't want to recreate entire database.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36054] Re: Export/Import problem

2009-11-26 Thread vvk
I tried:

Exported to csv file from appadmin interface, tables auth_user,
product, allot with allot table having id references of auth_user and
product
allot(auth_user.id,product.id)

Imported as:

@auth.requires_login()
def backup():
id_map = {}
db.auth_user.import_from_csv_file(open('db_auth_user.csv'), id_map =
id_map)
db.allot.import_from_csv_file(open('db_allot.csv'), id_map = id_map)
db.product.import_from_csv_file(open('db_product.csv'), id_map =
id_map)
redirect(URL(r=request,f='index'))
return dict(form='')

After importing, allot table doesn't have updated id's of auth_user
and product.



Varun

On Nov 26, 9:34 pm, mdipierro  wrote:
> You do not need uuid unless you want to import records that you
> already have and want to replace them.
>
> If you use
>
> id_map={}
> db.table1.import_from_csv_file(ifile1, id_map=id_map)
> db.table2.import_from_csv_file(ifile2, id_map=id_map)
>
> the id_map={} makes sure all references between table1 and table2 are
> preserved. References to records that are not imported may still be
> broken.
>
> Massimo
>
> On Nov 26, 9:11 am, vvk  wrote:
>
>
>
> > I've created database and wrote controllers without using UUID's.
> > While exporting and importing databases, I'm facing these problems
>
> > i)  record id's are getting changed while importing and my search
> > functions are no longer working because I've reference of id's of
> > other tables, which are changing
>
> > example:
> > db1(product)
> > db2(db1.id,person)
>
> > I've read in Manual that UUID's should be used to reference rather
> > than Id's. So should I change all my search functions also to search
> > by uuid and not by id?
>
> > ii) How to modify entire existing database to have UUID's apart from
> > changing model ? I don't want to recreate entire database.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36055] Re: how i got web2py woking with mod_proxy on ubuntu

2009-11-26 Thread mdipierro
Thank you for the suggestion.

On Nov 26, 8:35 am, selecta  wrote:
> i have a apache server running which i wanted to show my web2py apps
> that are running on the provided server under port 8000
> so that i can callhttp://localhost/myapp/<- thats the apache server
> instead ofhttp://127.0.0.1:8000/myapp/<- thats the web2py server
>
> what i had to do was to install mod proxy
> sudo aptitude install libapache2-mod-proxy-html
>
> add to /etc/apache2/httpd.conf
> ProxyRequests off
> ProxyPass /myapp/http://127.0.0.1:8000/myapp/
> ProxyHTMLURLMaphttp://127.0.0.1:8000/myapp//myapp
>
> 
>         ProxyPassReverse /
>         ProxyHTMLURLMap  /      /myapp/
> 
>
> change in /etc/apache2/mods-enabled/proxy.conf
> Deny from all
> to
> Allow from all
>
> and execute the following commands
> ln -s /etc/apache2/mods-available/proxy_http.load /etc/apache2/mods-
> enabled/proxy_http.load
> sudo a2enmod proxy
> sudo /etc/init.d/apache2 restart
>
> yes i did not excatly know what I did in every step and there may be
> room for improvements but it works :)

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36056] Re: url rewriting bug in rewrite.py still not fixed

2009-11-26 Thread mdipierro
oops. sorry about that. I did not get the email notification from
google code.
I will take a look later today or tomorrow.

Massimo

On Nov 26, 11:55 am, Wikus van de Merwe 
wrote:
> Sorry for advertising the bug here, but as I've noticed that the list
> gets 10 times more attention than the issue tracker. Some time ago
> I've filled a bug against rewrite.py and its routing rules 
> processing:http://code.google.com/p/web2py/issues/detail?id=58
>
> It was marked as fixed in trunk but in fact it was not. Normally I
> would reopen the bug, but I guess some extra privileges are needed for
> that. I have attached a patch before but it was not used, so this time
> I've attached a minimal test case showing the incorrect behaviour so
> the fix can be easily tested. It would be great if you could take a
> second look at it.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36057] Re: Routes

2009-11-26 Thread mdipierro
technically you can reload routes without restarting. From the admin
web based shell

from gluon.rewrite improt *
load()

On Nov 26, 12:02 pm, Yarko Tymciurak 
wrote:
> routes.py is read when web2py starts - be sure to re-start whatever
> server you are using (or restart web2py, if you are using the builting
> server).
>
> On Nov 26, 11:21 am, kbochert  wrote:
>
> > As a new user to web2py, I am trying to get routes.py to work.
> > Nothing I put into web2py/routes.py has any effect.
>
> > example:
> >   routes_in=(
> >     ('^127\.0\.0\.1:.*',
> >         '/examples/default/index'),
> >   )
>
> > Moreover , clear errors in the routes.py have no effect.
> > i.e.
> > x = 6/0; @!
>
> > Am I overlooking something that I need to do to turn on the rewrite??
>
> > Karl
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36058] Re: Export/Import problem

2009-11-26 Thread mdipierro
Not sure I understand. Do you get broken references?

Are you exporting the entire db? and you importing over the existing
db or a clean db?

Have you tried exporting and importing the entire db?

db.export_to_csv_file(...)
db.import_from_csv_file(...)

On Nov 26, 12:16 pm, vvk  wrote:
> I tried:
>
> Exported to csv file from appadmin interface, tables auth_user,
> product, allot with allot table having id references of auth_user and
> product
> allot(auth_user.id,product.id)
>
> Imported as:
>
> @auth.requires_login()
> def backup():
>         id_map = {}
>         db.auth_user.import_from_csv_file(open('db_auth_user.csv'), id_map =
> id_map)
>         db.allot.import_from_csv_file(open('db_allot.csv'), id_map = id_map)
>         db.product.import_from_csv_file(open('db_product.csv'), id_map =
> id_map)
>         redirect(URL(r=request,f='index'))
>         return dict(form='')
>
> After importing, allot table doesn't have updated id's of auth_user
> and product.
>
> 
> Varun
>
> On Nov 26, 9:34 pm, mdipierro  wrote:
>
> > You do not need uuid unless you want to import records that you
> > already have and want to replace them.
>
> > If you use
>
> > id_map={}
> > db.table1.import_from_csv_file(ifile1, id_map=id_map)
> > db.table2.import_from_csv_file(ifile2, id_map=id_map)
>
> > the id_map={} makes sure all references between table1 and table2 are
> > preserved. References to records that are not imported may still be
> > broken.
>
> > Massimo
>
> > On Nov 26, 9:11 am, vvk  wrote:
>
> > > I've created database and wrote controllers without using UUID's.
> > > While exporting and importing databases, I'm facing these problems
>
> > > i)  record id's are getting changed while importing and my search
> > > functions are no longer working because I've reference of id's of
> > > other tables, which are changing
>
> > > example:
> > > db1(product)
> > > db2(db1.id,person)
>
> > > I've read in Manual that UUID's should be used to reference rather
> > > than Id's. So should I change all my search functions also to search
> > > by uuid and not by id?
>
> > > ii) How to modify entire existing database to have UUID's apart from
> > > changing model ? I don't want to recreate entire database.
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36059] Re: url rewriting bug in rewrite.py still not fixed

2009-11-26 Thread mdipierro
I do not understand. Could you provide an example of path that is
wrongly mapped. You say patch that "do not start with / are wrongly
rewritten". Technically paths that do not start with / are not allowed
so I am not sure how do you expect the rewrite to behave.

On Nov 26, 11:55 am, Wikus van de Merwe 
wrote:
> Sorry for advertising the bug here, but as I've noticed that the list
> gets 10 times more attention than the issue tracker. Some time ago
> I've filled a bug against rewrite.py and its routing rules 
> processing:http://code.google.com/p/web2py/issues/detail?id=58
>
> It was marked as fixed in trunk but in fact it was not. Normally I
> would reopen the bug, but I guess some extra privileges are needed for
> that. I have attached a patch before but it was not used, so this time
> I've attached a minimal test case showing the incorrect behaviour so
> the fix can be easily tested. It would be great if you could take a
> second look at it.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36060] Re: expire login when browser closes

2009-11-26 Thread vince
it will expire when browser close on firefox/safari. however, if you
just close the tab the session won't expire. is there any workaround
for this problem?

-vince

On Nov 20, 3:14 am, mdipierro  wrote:
> This expiration is handled at the web2py level. Thesessioncookie
> used to maintain thesessionshould expire at the browser level when
> youclosethe browser because it does have an expiration time. Since
> that is browser dependent I do not know if it always works.
>
> On Nov 19, 11:43 am, Wes James  wrote:
>
> > I see in tools.py
>
> > self.settings.expiration = 3600  # seconds
>
> > Is this used when auth_user is logged in?
>
> > How can this be reset when a browser has closed?
>
> > I notice that when Iclosethe broswer, then come back to the page, it is
> > still logged in.
>
> > thx,
>
> > -wes

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36061] Re: Routes

2009-11-26 Thread kbochert


On Nov 26, 10:36 am, mdipierro  wrote:
> technically you can reload routes without restarting. From the admin
> web based shell
>
> from gluon.rewrite improt *
> load()
>
> On Nov 26, 12:02 pm, Yarko Tymciurak 
> wrote:
>
> > routes.py is read when web2py starts - be sure to re-start whatever
> > server you are using (or restart web2py, if you are using the builting
> > server).
>

A line in routes.py like
   x = 6/0
does indeed produce a divide by zero error when web2py starts.


The routes:
routes_in=(
  ('^127\.0\.0\.1:.*',
  '/examples/default/index'),
)
has no effect, even after a startup of web2py

Using the web based shell
 >>>from gluon.rewrite import *
produces "error : undefined"

I'm using version 1.72.3

Karl

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36062] multiple validations problem

2009-11-26 Thread __Kyo__
Hi, i use this code in my application, it works very good when i
insert a new record, but i have a little problem when i want to update
a registry. For example:

I have un my table inventory: product, country, quantity

If i insert pencil, canada, 40 it inserts fine

then if i want to insert again pencil, canada, 50 it doesnt insert
beacuse i already have pencils in canada. This is working fine.

My problem is here, in the update. For example

I want to update my number of pencils in Canada, beacause i buy
another 50 pencils. I put update
pencil, canada, 90

But it says it already have pencils in canada, its like i am inserting
a new registry and not doing an update. How can i solve this?

This is my validator, is in the model:

class IS_NOT_IN_DB_DDOWN_UIM(IS_IN_DB):
def __init__(self,*a,**b):
IS_IN_DB.__init__(self,*a,**b)
def __call__(self,value):
e=IS_IN_DB.__call__(self,value)
if e[1]:return e e=IS_NOT_IN_DB(db
(db.Inventory.idProduct==request.vars.idProduct),'Inventory.idCountry',error_message=self.error_message)
(value)
return e

db.Inventory.idCountry.requires=IS_NOT_IN_DB_DDOWN_UIM
(db,'Country.id','%(nCountry)s',error_message="The product is already
in this country.")

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36063] Re: Data grids in Web2py

2009-11-26 Thread David
Just got a chance to look through the source...

It's a whole lot cleaner than the mess I cobbled together to get it to
work.

Thank you for this Massimo :0)





On Nov 26, 7:23 am, mdipierro  wrote:
> Yes
>
> http://web2py-crm.appspot.com/init/default/index
>
> uses datatables. The source is posted on applicances
>
> On Nov 26, 5:45 am, David  wrote:
>
>
>
> > Do we have a data grid widget in web2py?  If not, are there any plans
> > to include this in the future?
>
> > I'm currently building them manually with web2py, which works, but
> > I've seen dataTables and it looks a lot nicer.  Has anyone used
> > dataTables?  Do you have any examples that I can reference?
>
> > Thanks,
> > David

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36064] accessing web...@googlegroups please help

2009-11-26 Thread Eduardo Biano
Hi,
I've been trying for the past weeks to access web2py@googlegroups.com but 
failed to connect when I clicked Groups at Google.com. The error displayed is 
Network Timeout. I googled but didn't find any solution. Tried searching email 
address of Google groups to address this concern but never found any. Please 
help. Thanks in advance.
Cheers,
Ed

--- On Thu, 11/26/09, web2py@googlegroups.com  wrote:

From: web2py@googlegroups.com 
Subject: [web2py:0] Abridged summary of web2py@googlegroups.com - 43 Messages  
in 17 Topics
To: "Abridged Recipients" 
Date: Thursday, November 26, 2009, 8:46 PM

 
  Today's Topic Summary
Group: http://groups.google.com/group/web2py/topics

Routes [5 Updates]
expire login when browser closes [1 Update]
url rewriting bug in rewrite.py still not fixed [3 Updates]
Export/Import problem [5 Updates]
how i got web2py woking with mod_proxy on ubuntu [2 Updates]
[web2py:36016] Re: Don't you love it when editors mess up? [1 Update]
web2py 1.73.1 is OUT for testing [1 Update]
[web2py:35928] Re: Markdown problem [2 Updates]
IS_DATE validation not working [3 Updates]
SQL Query with Case Statement... [2 Updates]
Complex SQL Query - Left Out Join With A Third table... [2 Updates]
Data grids in Web2py [2 Updates]
bad image and word Validator [7 Updates]
Crashing on Updating to 1.72.3 [2 Updates]
possible ? WYSIWYG editor with integrated image upload [1 Update]
Help with frames [2 Updates]
[web2py:36017] forms [2 Updates]





  
  
   Topic: Routes

  
  
kbochert  Nov 26 09:21AM -0800

   

  As a new user to web2py, I am trying to get routes.py to work.

Nothing I put into web2py/routes.py has any effect.

 

example:

  routes_in=(

('^127\.0\.0\.1:.*',
  more...


  
  
  
Yarko Tymciurak  Nov 26 10:02AM -0800

   

  routes.py is read when web2py starts - be sure to re-start whatever

server you are using (or restart web2py, if you are using the builting

server).

 


  more...


  
  
  
Wikus van de Merwe  Nov 26 10:02AM -0800

   

  Well, first, you don't need a comma after bracket, when there is only

one rule there.

Second, routes are only processed once when the server is first time

started. Are you restarting your app
  more...


  
  
  
mdipierro  Nov 26 10:36AM -0800

   

  technically you can reload routes without restarting. From the admin

web based shell

 

from gluon.rewrite improt *

load()

 

On Nov 26, 12:02 pm, Yarko Tymciurak 
  more...


  
  
  
kbochert  Nov 26 11:05AM -0800

   

  > > server).

>

 

A line in routes.py like

   x = 6/0

does indeed produce a divide by zero error when web2py starts.

 

 

The routes:

routes_in=(

  ('^127\.0\.0\.1:.*',
  more...


  
  

  
  
   Topic: expire login when browser closes

  
  
vince  Nov 26 10:54AM -0800

   

  it will expire when browser close on firefox/safari. however, if you

just close the tab the session won't expire. is there any workaround

for this problem?

 

-vince

 


  more...


  
  

  
  
   Topic: url rewriting bug in rewrite.py still not fixed

  
  
Wikus van de Merwe  Nov 26 09:55AM -0800

   

  Sorry for advertising the bug here, but as I've noticed that the list

gets 10 times more attention than the issue tracker. Some time ago

I've filled a bug against rewrite.py and its routing rules
  more...


  
  
  
mdipierro  Nov 26 10:34AM -0800

   

  oops. sorry about that. I did not get the email notification from

google code.

I will take a look later today or tomorrow.

 

Massimo

 

On Nov 26, 11:55 am, Wikus van de Merwe
  more...


  
  
  
mdipierro  Nov 26 10:47AM -0800

   

  I do not understand. Could you provide an example of path that is

wrongly mapped. You say patch that "do not start with / are wrongly

rewritten". Technically paths that do not start with / are not
  more...


  
  

  
  
   Topic: Export/Import problem

  
  
vvk  Nov 26 07:11AM -0800

   

  I've created database and wrote controllers without using UUID's.

While exporting and importing databases, I'm facing these problems

 

i)  record id's are getting changed while importing and my
  more...


  
  
  
mdipierro  Nov 26 08:34AM -0800

   

  You do not need uuid unless you want to import records that you

already have and want to replace them.

 

If you use

 

id_map={}

db.table1.import_from_csv_file(ifile1, id_map=id_map)
  more...


  
  
  
vvk  Nov 26 10:11AM -0800

   

  I tried these:

 

Exported into csv file from appadmin interface three tables:

auth_user, allot, product

with allot(auth_user_id, product_id) having id's of user and product

 

Then tried to import
  more...


  
  
  
vvk  Nov 26 10:16AM -0800

   

  I tried:

 

Exported to csv file from appadmin interface, tables auth_user,

product, allot with allot tab

[web2py:36065] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread yamandu
Massimo,

strange, but I can´t reproduce the problem.
I tried to do the same mistake but I got a normal ticket behavior.
But I don´t remember exactly how was the mistake with the brackets,
only that it was on menu.py in menu definition.
Could it be just a big syntax problem caused by bracket mismatch?

On 26 nov, 11:21, mdipierro  wrote:
> Please try again. When you get the first ticket click on it. If you
> get another ticket
> /
> locate the corresponding ticket file applciations//errors/
> and email it to me.
>
> When you upgraded web2py, did you upgraded admin?
>
> web2py.py --upgrade=yes
>
> Massimo
>
> On Nov 26, 5:12 am, yamandu  wrote:
>
>
>
> > The problem when I update is that was not possible to see the error.
> > I got ticket screen but the link always led to another ticket screen.
> > So I think there was a problem under my app too.
>
> > On Nov 25, 12:38 pm, mdipierro  wrote:
>
> > > I do not understand. where you not getting a ticket? Something wrong
> > > with the ticket?
>
> > > On Nov 25, 6:45 am, yamandu  wrote:
>
> > > > In fact, it was an almost obvious thing.
> > > > There was a bracket mistake on my code that I discover reverting to an
> > > > older version.
> > > > But the strange thing is that in the older version I could find the
> > > > error by clicking the ticket link but not in the 1.72.3 version.
> > > > Maybe this is a bug?
>
> > > > On 25 nov, 10:03, yamandu  wrote:
>
> > > > > The update method I used was simply copy merging the files from the
> > > > > new version with the installation ones.
>
> > > > > On Nov 25, 9:24 am, yamandu  wrote:
>
> > > > > > I had previous install through source (because I use GAE in
> > > > > > production).
> > > > > > Thought the crash could be because of python 2.6 recent installation
> > > > > > but I remove it and nothing changed.
>
> > > > > > After updating nothing works! Only thing I get is an ticket screen!
> > > > > > An when I click the ticket link it lead me to another ticket screen.
> > > > > > I think I used a wrong and stupid update method!
> > > > > > But the same had worked on previous updates.
>
> > > > > > What would be the proper way to update an existing installation from
> > > > > > source?
>
> > > > > > On Nov 24, 4:29 pm, Yarko Tymciurak 
> > > > > > wrote:
>
> > > > > > > what is it that I remember about this sort of thing?:   clear 
> > > > > > > sessions
> > > > > > > files?   sqlite migration issues (table files, but no tables - as 
> > > > > > > could
> > > > > > > happen is you install new web2py, but manually move your app)?
>
> > > > > > > Look at some obvious things, then tell more of what is going on, 
> > > > > > > how you set
> > > > > > > this up...
>
> > > > > > > On Tue, Nov 24, 2009 at 10:32 AM, mdipierro 
> > > > > > >  wrote:
>
> > > > > > > > Can you tell us more? What does not work?
>
> > > > > > > > On Nov 24, 7:30 am, yamandu  wrote:
> > > > > > > > > Before I updated to 1.72.3 it does not run.
> > > > > > > > > It goes to the ticket page and does not even open the ticket 
> > > > > > > > > link.
>
> > > > > > > > > Any issue with this version?

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36066] Re: Export/Import problem

2009-11-26 Thread vvk
No Broken references
I deleted all my DB and created a new one with only One auth_user, One
product in Product Table and only One entry in Allot Table.

Not Exporting entire DB
I'm not exporting entire DB, I'm exporting only three tables
auth_user, product, allot and then I'm deleting only those three
tables from **appadmin interface**.

Importing:
 id_map = {}
db.auth_user.import_from_csv_file(open('db_auth_user.csv'),
id_map = id_map)
db.allot.import_from_csv_file(open('db_allot.csv'), id_map =
id_map)
db.product.import_from_csv_file(open('db_product.csv'), id_map
= id_map)


Tried These methods Also:

Export using:
   db.export_to_csv_file(open('backupfile.csv','wb'))
   Then delete all tables, make user to logout because while importing
similar records are showing up twice.

Import using:
   id_map = {}
   db(db.auth_user.id > 0).delete()
   db.import_from_csv_file(open('backupfile.csv','rb'))

In this process also, I'm not getting updated id's in allot table ...
allot (product.id, auth_user.id)

---
Varun


On Nov 26, 11:39 pm, mdipierro  wrote:
> Not sure I understand. Do you get broken references?
>
> Are you exporting the entire db? and you importing over the existing
> db or a clean db?
>
> Have you tried exporting and importing the entire db?
>
> db.export_to_csv_file(...)
> db.import_from_csv_file(...)
>
> On Nov 26, 12:16 pm, vvk  wrote:
>
>
>
> > I tried:
>
> > Exported to csv file from appadmin interface, tables auth_user,
> > product, allot with allot table having id references of auth_user and
> > product
> > allot(auth_user.id,product.id)
>
> > Imported as:
>
> > @auth.requires_login()
> > def backup():
> >         id_map = {}
> >         db.auth_user.import_from_csv_file(open('db_auth_user.csv'), id_map =
> > id_map)
> >         db.allot.import_from_csv_file(open('db_allot.csv'), id_map = id_map)
> >         db.product.import_from_csv_file(open('db_product.csv'), id_map =
> > id_map)
> >         redirect(URL(r=request,f='index'))
> >         return dict(form='')
>
> > After importing, allot table doesn't have updated id's of auth_user
> > and product.
>
> > 
> > Varun
>
> > On Nov 26, 9:34 pm, mdipierro  wrote:
>
> > > You do not need uuid unless you want to import records that you
> > > already have and want to replace them.
>
> > > If you use
>
> > > id_map={}
> > > db.table1.import_from_csv_file(ifile1, id_map=id_map)
> > > db.table2.import_from_csv_file(ifile2, id_map=id_map)
>
> > > the id_map={} makes sure all references between table1 and table2 are
> > > preserved. References to records that are not imported may still be
> > > broken.
>
> > > Massimo
>
> > > On Nov 26, 9:11 am, vvk  wrote:
>
> > > > I've created database and wrote controllers without using UUID's.
> > > > While exporting and importing databases, I'm facing these problems
>
> > > > i)  record id's are getting changed while importing and my search
> > > > functions are no longer working because I've reference of id's of
> > > > other tables, which are changing
>
> > > > example:
> > > > db1(product)
> > > > db2(db1.id,person)
>
> > > > I've read in Manual that UUID's should be used to reference rather
> > > > than Id's. So should I change all my search functions also to search
> > > > by uuid and not by id?
>
> > > > ii) How to modify entire existing database to have UUID's apart from
> > > > changing model ? I don't want to recreate entire database.

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36067] Re: multiple validations problem

2009-11-26 Thread mdipierro
Look into gluon.validators.IS_NOT_IN_DB

specifically:

def set_self_id(self, id):
self.record_id = id

By settings the id of the current record you can prevent the check on
update.

Massimo

On Nov 26, 4:32 pm, __Kyo__  wrote:
> Hi, i use this code in my application, it works very good when i
> insert a new record, but i have a little problem when i want to update
> a registry. For example:
>
> I have un my table inventory: product, country, quantity
>
> If i insert pencil, canada, 40 it inserts fine
>
> then if i want to insert again pencil, canada, 50 it doesnt insert
> beacuse i already have pencils in canada. This is working fine.
>
> My problem is here, in the update. For example
>
> I want to update my number of pencils in Canada, beacause i buy
> another 50 pencils. I put update
> pencil, canada, 90
>
> But it says it already have pencils in canada, its like i am inserting
> a new registry and not doing an update. How can i solve this?
>
> This is my validator, is in the model:
>
> class IS_NOT_IN_DB_DDOWN_UIM(IS_IN_DB):
>     def __init__(self,*a,**b):
>         IS_IN_DB.__init__(self,*a,**b)
>     def __call__(self,value):
>         e=IS_IN_DB.__call__(self,value)
>         if e[1]:return e             e=IS_NOT_IN_DB(db
> (db.Inventory.idProduct==request.vars.idProduct),'Inventory.idCountry',error_message=self.error_message)
> (value)
>         return e
>
> db.Inventory.idCountry.requires=IS_NOT_IN_DB_DDOWN_UIM
> (db,'Country.id','%(nCountry)s',error_message="The product is already
> in this country.")

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36068] Re: accessing web...@googlegroups please help

2009-11-26 Thread mdipierro
I do not know what to do about this. If anybody has a good idea please
let me know.

On Nov 26, 7:51 pm, Eduardo Biano  wrote:
> Hi,
> I've been trying for the past weeks to access web2py@googlegroups.com but 
> failed to connect when I clicked Groups at Google.com. The error displayed is 
> Network Timeout. I googled but didn't find any solution. Tried searching 
> email address of Google groups to address this concern but never found any. 
> Please help. Thanks in advance.
> Cheers,
> Ed
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




[web2py:36069] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread mdipierro
I do not know. Usually a recirsive ticket is caused by a problem in
admin or a wrong filesystem permissions.

On Nov 26, 8:58 pm, yamandu  wrote:
> Massimo,
>
> strange, but I can´t reproduce the problem.
> I tried to do the same mistake but I got a normal ticket behavior.
> But I don´t remember exactly how was the mistake with the brackets,
> only that it was on menu.py in menu definition.
> Could it be just a big syntax problem caused by bracket mismatch?
>
> On 26 nov, 11:21, mdipierro  wrote:
>
> > Please try again. When you get the first ticket click on it. If you
> > get another ticket
> > /
> > locate the corresponding ticket file applciations//errors/
> > and email it to me.
>
> > When you upgraded web2py, did you upgraded admin?
>
> > web2py.py --upgrade=yes
>
> > Massimo
>
> > On Nov 26, 5:12 am, yamandu  wrote:
>
> > > The problem when I update is that was not possible to see the error.
> > > I got ticket screen but the link always led to another ticket screen.
> > > So I think there was a problem under my app too.
>
> > > On Nov 25, 12:38 pm, mdipierro  wrote:
>
> > > > I do not understand. where you not getting a ticket? Something wrong
> > > > with the ticket?
>
> > > > On Nov 25, 6:45 am, yamandu  wrote:
>
> > > > > In fact, it was an almost obvious thing.
> > > > > There was a bracket mistake on my code that I discover reverting to an
> > > > > older version.
> > > > > But the strange thing is that in the older version I could find the
> > > > > error by clicking the ticket link but not in the 1.72.3 version.
> > > > > Maybe this is a bug?
>
> > > > > On 25 nov, 10:03, yamandu  wrote:
>
> > > > > > The update method I used was simply copy merging the files from the
> > > > > > new version with the installation ones.
>
> > > > > > On Nov 25, 9:24 am, yamandu  wrote:
>
> > > > > > > I had previous install through source (because I use GAE in
> > > > > > > production).
> > > > > > > Thought the crash could be because of python 2.6 recent 
> > > > > > > installation
> > > > > > > but I remove it and nothing changed.
>
> > > > > > > After updating nothing works! Only thing I get is an ticket 
> > > > > > > screen!
> > > > > > > An when I click the ticket link it lead me to another ticket 
> > > > > > > screen.
> > > > > > > I think I used a wrong and stupid update method!
> > > > > > > But the same had worked on previous updates.
>
> > > > > > > What would be the proper way to update an existing installation 
> > > > > > > from
> > > > > > > source?
>
> > > > > > > On Nov 24, 4:29 pm, Yarko Tymciurak 
> > > > > > > wrote:
>
> > > > > > > > what is it that I remember about this sort of thing?:   clear 
> > > > > > > > sessions
> > > > > > > > files?   sqlite migration issues (table files, but no tables - 
> > > > > > > > as could
> > > > > > > > happen is you install new web2py, but manually move your app)?
>
> > > > > > > > Look at some obvious things, then tell more of what is going 
> > > > > > > > on, how you set
> > > > > > > > this up...
>
> > > > > > > > On Tue, Nov 24, 2009 at 10:32 AM, mdipierro 
> > > > > > > >  wrote:
>
> > > > > > > > > Can you tell us more? What does not work?
>
> > > > > > > > > On Nov 24, 7:30 am, yamandu  wrote:
> > > > > > > > > > Before I updated to 1.72.3 it does not run.
> > > > > > > > > > It goes to the ticket page and does not even open the 
> > > > > > > > > > ticket link.
>
> > > > > > > > > > Any issue with this version?
>
>

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.