[web2py] We really should have something similar to DjDT in Web2py
Boy, I kinda like that thing. http://robhudson.github.com/django-debug-toolbar/ BR, Jason Brower
[web2py] Re: Proposals for New Tagline
Some time ago I built a web application in which we left room for users to enter a tagline, since most users struggled to come up with a tagline, we provided them with the following description: A tagline is a slogan in which you state what your company/product/ service does or is and in what in differs from your competitors company/product/service. To me web2py is a 'web framework' and compared to its competitors I think it is very 'straightforward'. Kind regards, Annet.
[web2py] Re: web2py 1.94.1 is OUT
Debian packages for 1.94.4 are already available where usual: http://people.debian.org/~jredrejo/web2py/lenny/ (for python2.5) or http://people.debian.org/~jredrejo/web2py/squeeze/ (for python >> 2.5) Regards.
Re: [web2py] Re: nginx with bultin uwsgi module
On Thu, Mar 17, 2011 at 7:49 PM, pbreit wrote: > I just copied my parameters_8000.py to parameters_443.py > > I think it needs to be 443 since that's the https port. > > So: > > web2py$ cp parameters_8000.py parameters_443.py > That did it. I now have access to the administrative interface. With the fcgi method I could do upgrades throught the interface without problems; with uwsgi I attempted upgrade and got an error message [ error 13 ] which unfortunately I was not able to copy as it appeared in a flash bar on top then disappeared and was not registered on a ticket. However, when I restarted web2py the upgrade had gone through, so I'll be checking the next upgrade with care to see what happens. Just swapping a couple of config files and restarting nginx now gives me the possibility of swapping from fcgi to uwsgi or viceversa. Thanks to everybody!
[web2py] Re: web2py 1.94.1 is OUT
I have had trouble with 1.94.4 as follows: - Start the develop server of the web2py - Browse the admin application site - Log-in the site - Click to a link of my application site (which uses a database session) - browse the admin application site again - Then, cannot log-in the site because somehow the session for the admin site become empty, and never can log-in until restart the develop server. Please help. On 3月18日, 午後5:36, José L. wrote: > Debian packages for 1.94.4 are already available where > usual:http://people.debian.org/~jredrejo/web2py/lenny/(for python2.5) > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(for python >> 2.5) > > Regards.
[web2py] Re: web2py 1.94.1 is OUT
I have had trouble with 1.94.4 as follows: - Start the develop server of the web2py - Browse the admin application site - Log-in the site - Click a link to my application site (which uses a database session) - browse the admin application site again - Then, cannot log-in the site because somehow the session for the admin site become empty, and never can log-in until restart the develop server. Please help. On 3月18日, 午後5:36, José L. wrote: > Debian packages for 1.94.4 are already available where > usual:http://people.debian.org/~jredrejo/web2py/lenny/(for python2.5) > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(for python >> 2.5) > > Regards.
[web2py] rounded cache for web2py
has anyone expanded caching of web2py and contribs/gae_memcache.py..? for example: 1. I'd like to be able to call a wrapper that calls Web2py/clear() or GAE/delete() 2. Cover the exceptions that GAE memcache can throw (e.g., during read- only maintenance sessions) 3. I'm happy to skip the use of cache with select() calls unless someone has cleverly added cache support for update_record() and insert() too or... for those that have skipped the web2py implementation have you found it better to write directly to the GAE memcache api?
[web2py] Re: get vars from view to my def
Massimo, thanks for your correction, but I need code like that:
**
* def work(i): *
*row=db(db.autos.id==i).select() *
*return dict(row=row)*
**
In this case "i" is a variable from the view "default/new.html". The
link is: "http://.../default/work?=3";. Figure 3 is an example.
In this code I want to use "i" as argument for "work()" but the result
is "invalid function(default/work)".
I hope my descriptions are clear for you :)
How can I set the value of variable from the current view to my def in
controller?
Thank you in advance...
_
On 18 мар, 00:03, Massimo Di Pierro
wrote:
> My code in controller:
> ***
>
> * def work():
> * row=db(db.autos.id==20).select() < can be done with DAL
> * return dict(row=row)
> ***
>
> My code in the view (new.html):
> ***
>
> * {{for r in rows:}} <-- rows not records
> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
> * {{pass}} <--- missing
> ***
>
>
> Anyway, your select returns at most one record.
>
> On Mar 17, 3:55 pm, cyber wrote:
>
>
>
>
>
>
>
> > Hi there!
>
> > I need a hint of how to get variable value from view to my function in
> > controller.
>
> > My code in controller:
> > ***
> >
> > * def work():
> > * row=db.executesql('SELECT * FROM autos WHERE autos.id=20')
> > * return dict(row=row)
> > ***
> >
>
> > My code in the view (new.html):
> > ***
> >
> > * {{for r in records:}}
> > * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
> > ***
> >
>
> > As you see I can select one row from db by id but I want work function
> > to get current id instead "autos.id=20"
> > I have no ideas of how to use variable from view in my controllers
> > def.
>
> > So, any proposals!?! Please...
Re: [web2py] Re: get vars from view to my def
http://.../default/work?number=3
In controller
i = request.vars.number
> row=db(db.autos.id==i).select()
Em 18/03/2011, às 08:16, cyber escreveu:
> Massimo, thanks for your correction, but I need code like that:
>
> **
> * def work(i): *
> *row=db(db.autos.id==i).select() *
> *return dict(row=row)*
> **
>
> In this case "i" is a variable from the view "default/new.html". The
> link is: "http://.../default/work?=3";. Figure 3 is an example.
> In this code I want to use "i" as argument for "work()" but the result
> is "invalid function(default/work)".
>
> I hope my descriptions are clear for you :)
> How can I set the value of variable from the current view to my def in
> controller?
> Thank you in advance...
> _
>
>
> On 18 мар, 00:03, Massimo Di Pierro
> wrote:
>> My code in controller:
>> ***
>>
>> * def work():
>> *row=db(db.autos.id==20).select() < can be done with DAL
>> *return dict(row=row)
>> ***
>>
>> My code in the view (new.html):
>> ***
>>
>> * {{for r in rows:}} <-- rows not records
>> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
>> * {{pass}} <--- missing
>> ***
>>
>>
>> Anyway, your select returns at most one record.
>>
>> On Mar 17, 3:55 pm, cyber wrote:
>>
>>
>>
>>
>>
>>
>>
>>> Hi there!
>>
>>> I need a hint of how to get variable value from view to my function in
>>> controller.
>>
>>> My code in controller:
>>> ***
>>>
>>> * def work():
>>> *row=db.executesql('SELECT * FROM autos WHERE autos.id=20')
>>> *return dict(row=row)
>>> ***
>>>
>>
>>> My code in the view (new.html):
>>> ***
>>>
>>> * {{for r in records:}}
>>> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
>>> ***
>>>
>>
>>> As you see I can select one row from db by id but I want work function
>>> to get current id instead "autos.id=20"
>>> I have no ideas of how to use variable from view in my controllers
>>> def.
>>
>>> So, any proposals!?! Please...
[web2py] Re: get vars from view to my def
WOW!
It works! It's so simple - I can't believe.
Thank you.
**
On 18 мар, 14:34, rochacbruno wrote:
> http://.../default/work?number=3
>
> In controller
>
> i = request.vars.number
>
> > row=db(db.autos.id==i).select()
>
> Em 18/03/2011, às 08:16, cyber escreveu:
>
>
>
>
>
>
>
> > Massimo, thanks for your correction, but I need code like that:
>
> > **
> > * def work(i): *
> > * row=db(db.autos.id==i).select() *
> > * return dict(row=row) *
> > **
>
> > In this case "i" is a variable from the view "default/new.html". The
> > link is: "http://.../default/work?=3";. Figure 3 is an example.
> > In this code I want to use "i" as argument for "work()" but the result
> > is "invalid function(default/work)".
>
> > I hope my descriptions are clear for you :)
> > How can I set the value of variable from the current view to my def in
> > controller?
> > Thank you in advance...
> > _
>
> > On 18 мар, 00:03, Massimo Di Pierro
> > wrote:
> >> My code in controller:
> >> ***
> >>
> >> * def work():
> >> * row=db(db.autos.id==20).select() < can be done with DAL
> >> * return dict(row=row)
> >> ***
> >>
> >> My code in the view (new.html):
> >> ***
> >>
> >> * {{for r in rows:}} <-- rows not records
> >> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
> >> * {{pass}} <--- missing
> >> ***
> >>
>
> >> Anyway, your select returns at most one record.
>
> >> On Mar 17, 3:55 pm, cyber wrote:
>
> >>> Hi there!
>
> >>> I need a hint of how to get variable value from view to my function in
> >>> controller.
>
> >>> My code in controller:
> >>> ***
> >>>
> >>> * def work():
> >>> * row=db.executesql('SELECT * FROM autos WHERE autos.id=20')
> >>> * return dict(row=row)
> >>> ***
> >>>
>
> >>> My code in the view (new.html):
> >>> ***
> >>>
> >>> * {{for r in records:}}
> >>> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
> >>> ***
> >>>
>
> >>> As you see I can select one row from db by id but I want work function
> >>> to get current id instead "autos.id=20"
> >>> I have no ideas of how to use variable from view in my controllers
> >>> def.
>
> >>> So, any proposals!?! Please...
[web2py] Re: get vars from view to my def
On Mar 17, 4:55 pm, cyber wrote:
> Hi there!
>
> I need a hint of how to get variable value from view to my function in
> controller.
>
> My code in controller:
> ***
> * def work():
> * row=db.executesql('SELECT * FROM autos WHERE autos.id=20')
> * return dict(row=row)
> ***
>
> My code in the view (new.html):
> ***
> * {{for r in records:}}
> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
If you build the URL with vars it will look like this:
(assuming r.id == 3)
http://.../default/work?i=3
and the value of i will be available to your controller in
request.vars.i # same key as in the vars dict inside URL()
Now, if you use URL(..., args=[r.id] )
it will create a link like this:
http=//.../default/work?3
and the value is available in
request.args[0]
> ***
>
> As you see I can select one row from db by id but I want work function
> to get current id instead "autos.id=20"
> I have no ideas of how to use variable from view in my controllers
> def.
>
> So, any proposals!?! Please...
[web2py] Re: web2py 1.94.1 is OUT
Are other people having the same problem? Are you sure it is with 1.94.4. Can you try delete all sessions files? On Mar 18, 5:59 am, kenji4569 wrote: > I have had trouble with 1.94.4 as follows: > - Start the develop server of the web2py > - Browse the admin application site > - Log-in the site > - Click a link to my application site (which uses a database > session) > - browse the admin application site again > - Then, cannot log-in the site because somehow the session for the > admin site become empty, and never can log-in until restart the > develop server. > Please help. > > On 3月18日, 午後5:36, José L. wrote: > > > > > > > > > Debian packages for 1.94.4 are already available where > > usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython >> 2.5) > > > Regards.
[web2py] Re: get vars from view to my def
Instead of
row=db(db.autos.id==i).select().first()
you can also do
row=db.autos(i)
On Mar 18, 6:34 am, rochacbruno wrote:
> http://.../default/work?number=3
>
> In controller
>
> i = request.vars.number
>
> > row=db(db.autos.id==i).select()
>
> Em 18/03/2011, às 08:16, cyber escreveu:
>
>
>
>
>
>
>
> > Massimo, thanks for your correction, but I need code like that:
>
> > **
> > * def work(i): *
> > * row=db(db.autos.id==i).select() *
> > * return dict(row=row) *
> > **
>
> > In this case "i" is a variable from the view "default/new.html". The
> > link is: "http://.../default/work?=3";. Figure 3 is an example.
> > In this code I want to use "i" as argument for "work()" but the result
> > is "invalid function(default/work)".
>
> > I hope my descriptions are clear for you :)
> > How can I set the value of variable from the current view to my def in
> > controller?
> > Thank you in advance...
> > _
>
> > On 18 мар, 00:03, Massimo Di Pierro
> > wrote:
> >> My code in controller:
> >> ***
> >>
> >> * def work():
> >> * row=db(db.autos.id==20).select() < can be done with DAL
> >> * return dict(row=row)
> >> ***
> >>
> >> My code in the view (new.html):
> >> ***
> >>
> >> * {{for r in rows:}} <-- rows not records
> >> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
> >> * {{pass}} <--- missing
> >> ***
> >>
>
> >> Anyway, your select returns at most one record.
>
> >> On Mar 17, 3:55 pm, cyber wrote:
>
> >>> Hi there!
>
> >>> I need a hint of how to get variable value from view to my function in
> >>> controller.
>
> >>> My code in controller:
> >>> ***
> >>>
> >>> * def work():
> >>> * row=db.executesql('SELECT * FROM autos WHERE autos.id=20')
> >>> * return dict(row=row)
> >>> ***
> >>>
>
> >>> My code in the view (new.html):
> >>> ***
> >>>
> >>> * {{for r in records:}}
> >>> * {{=A(r.id,_href=URL('work', vars={'i':r.id}))}}
> >>> ***
> >>>
>
> >>> As you see I can select one row from db by id but I want work function
> >>> to get current id instead "autos.id=20"
> >>> I have no ideas of how to use variable from view in my controllers
> >>> def.
>
> >>> So, any proposals!?! Please...
[web2py] Re: web2py anti-propaganda video
show-off! ;) On Mar 18, 8:32 am, Massimo Di Pierro wrote: > http://vimeo.com/21185623
[web2py] sub url
Hi Massimo,
I did once more try to setup web2py using mod_wsgi in something
different than /, in my case /ruamel
To be sure I temporarily deactivated the WSGIScriptAlias for /
Although the welcome page on http://localhost/ruamel tells me it works
it doesn't look like that since the page has no CSS.
Looking in the apache log I saw that web2py still is trying to get the
stylesheets and other stuff from / and not /ruamel
so I googled and searched through the newsgroup once more only to
your exchange with Graham Dumpleton on
sub url usage and that I had to setup a path in router.py.
I appreciate your concern with backwards compatibility but this is
something that has come up under various names in the past.
The router change works for the welcome app, but errors are not
covered by that. for that you need to adapt the error_message_ticket
in routes.py as well.
It should not take knowledge of the term sub url to find out about
this, for me that meant several hours searching and trying. I would
assume that if the welcome app cannot find its stylesheets it should
give a useful message. This could easily be achieved in a backwards
compatible way by the following change:
diff -r 1e70764ec03a applications/welcome/views/default/index.html
--- a/applications/welcome/views/default/index.html Fri Mar 18
09:18:59 2011 +0100
+++ b/applications/welcome/views/default/index.html Fri Mar 18
14:38:17 2011 +0100
@@ -9,6 +9,25 @@
Readme
{{=T('You are successfully running web2py')}}
+
+
+
+Style sheets were not found.
+
+{{if request.env.get('script_name'):}}
+
+You probably want to add something like:
+
+ routes_out=(('(?P.*)','/{{=request.env.script_name}}
\g'),)
+ error_message_ticket = 'Internal errorTicket
issued: %(ticket)s'
+
+to the file in {{=request.env.web2py_path}}/routes.py and check
+http://groups.google.com/group/web2py";>http://
groups.google.com/group/web2py for 'sub url'
+{{pass}}
+
+
+
+
{{=T('This is a copy of the scaffolding application')}}
{{=T('You can modify this application and adapt it to your
needs')}}
I am not sure there are more issues. Is this the proper direction to
proceed?
Regards
Anthon
PS I like backwards compatibility. I went from an application on some
December 2009 version to version 1.89 in November without any major
problems.
[web2py] Re: web2py anti-propaganda video
It wasn't me. My robot made it. I just posted it. On Mar 18, 8:26 am, DenesL wrote: > show-off! ;) > > On Mar 18, 8:32 am, Massimo Di Pierro > wrote: > > > > > > > > >http://vimeo.com/21185623
Re: [web2py] web2py anti-propaganda video
*WOW*! This is the best answer to all criticism against web2py *Talk is cheap, Show the code!* I created a custom shorten link, because I am sure this link will be very used to answer threads : http://bit.ly/web2pykickass On Fri, Mar 18, 2011 at 9:32 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > http://vimeo.com/21185623
[web2py] Re: web2py 1.94.1 is OUT
I have had apps "freeze" last night where I needed to kill the tab and open fresh. First time it happens. Don't know if related, but maybe not a coincidence... I'm on macosX Thanks, Mart :) On Mar 18, 8:23 am, Massimo Di Pierro wrote: > Are other people having the same problem? Are you sure it is with > 1.94.4. Can you try delete all sessions files? > > On Mar 18, 5:59 am, kenji4569 wrote: > > > > > I have had trouble with 1.94.4 as follows: > > - Start the develop server of the web2py > > - Browse the admin application site > > - Log-in the site > > - Click a link to my application site (which uses a database > > session) > > - browse the admin application site again > > - Then, cannot log-in the site because somehow the session for the > > admin site become empty, and never can log-in until restart the > > develop server. > > Please help. > > > On 3月18日, 午後5:36, José L. wrote: > > > > Debian packages for 1.94.4 are already available where > > > usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > > > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> 2.5) > > > > Regards.
[web2py] Re: web2py anti-propaganda video
Very nice. I'm sure the claim that the web2py template engine is "the best" will not generate any controversy. ;) Anthony On Friday, March 18, 2011 8:32:19 AM UTC-4, Massimo Di Pierro wrote: > http://vimeo.com/21185623
[web2py] Re: We really should have something similar to DjDT in Web2py
That would be pretty cool. You sometimes have to jump through a few hoops to see all the variables and SQL code.
[web2py] Re: web2py anti-propaganda video
reddit thread: http://www.reddit.com/r/Python/comments/g6e5s/on_web2py_with_tornado_cherrypy_paste_mako/ On Mar 18, 4:52 pm, Anthony wrote: > Very nice. > > I'm sure the claim that the web2py template engine is "the best" will not > generate any controversy. ;) > > Anthony > > On Friday, March 18, 2011 8:32:19 AM UTC-4, Massimo Di Pierro wrote: > >http://vimeo.com/21185623 > >
[web2py] Re: web2py 1.94.1 is OUT
I had the browser freeze... not web2py. I thought the problem was with google chrome beta on MacOSX. What browser are you using? On Mar 18, 9:31 am, mart wrote: > I have had apps "freeze" last night where I needed to kill the tab and > open fresh. First time it happens. Don't know if related, but maybe > not a coincidence... I'm on macosX > > Thanks, > Mart :) > > On Mar 18, 8:23 am, Massimo Di Pierro > wrote: > > > > > > > > > Are other people having the same problem? Are you sure it is with > > 1.94.4. Can you try delete all sessions files? > > > On Mar 18, 5:59 am, kenji4569 wrote: > > > > I have had trouble with 1.94.4 as follows: > > > - Start the develop server of the web2py > > > - Browse the admin application site > > > - Log-in the site > > > - Click a link to my application site (which uses a database > > > session) > > > - browse the admin application site again > > > - Then, cannot log-in the site because somehow the session for the > > > admin site become empty, and never can log-in until restart the > > > develop server. > > > Please help. > > > > On 3月18日, 午後5:36, José L. wrote: > > > > > Debian packages for 1.94.4 are already available where > > > > usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > > > > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> 2.5) > > > > > Regards.
[web2py] Re: web2py anti-propaganda video
The demonstrated modularity is impressive. I also looked at the recent
reddit link. I must say the DAL is amazing. I've done Perl
professionally for 12 years with a focus on database processing and I
wish I had had DAL at my disposal.
I would like to discuss one thing said in this video - "the web2py
template language is the best"
It certainly is the most convenient and intuitive approach to
templating. However, I've always been a fan of push-style templating
( http://www.perlmonks.org/?node_id=674225#python ) and insuring that
the processor was separate from the processed. Hence, I tend to
generate HTML in a DOM like fashion. In my one Python job, I used
meld3 from Python for that purpose. I dont think the HTML created with
web2py's template system is well-formed is it?
{{ for row: in rows }} < breaks well-formedness?
...
One other thing, I notice web2py ships with jQuery, which is massively
popular and succinct. However, I find jquery a bit lacking in UI and
am probably going to use Dojo for what I'm working on at the moment. I
searched these archives and there appears to be no issue with hooking
in dojo.
On Mar 18, 8:32 am, Massimo Di Pierro
wrote:
> http://vimeo.com/21185623
[web2py] Re: web2py anti-propaganda video
On Mar 18, 8:54 am, Terrence Brannon wrote:
> The demonstrated modularity is impressive. I also looked at the recent
> reddit link. I must say the DAL is amazing. I've done Perl
> professionally for 12 years with a focus on database processing and I
> wish I had had DAL at my disposal.
>
> I would like to discuss one thing said in this video - "the web2py
> template language is the best"
>
> It certainly is the most convenient and intuitive approach to
> templating. However, I've always been a fan of push-style templating
> (http://www.perlmonks.org/?node_id=674225#python) and insuring that
> the processor was separate from the processed. Hence, I tend to
> generate HTML in a DOM like fashion. In my one Python job, I used
> meld3 from Python for that purpose. I dont think the HTML created with
> web2py's template system is well-formed is it?
>
>
> {{ for row: in rows }} < breaks well-formedness?
>
> ...
>
Not sure I understand. Are you referring to the extra new line?
>
> One other thing, I notice web2py ships with jQuery, which is massively
> popular and succinct. However, I find jquery a bit lacking in UI and
> am probably going to use Dojo for what I'm working on at the moment. I
> searched these archives and there appears to be no issue with hooking
> in dojo.
>
> On Mar 18, 8:32 am, Massimo Di Pierro
> wrote:
>
>
>
>
>
>
>
> >http://vimeo.com/21185623
[web2py] Re: web2py 1.94.1 is OUT
I just upgraded from 1.91.6 to 1.94.4 through the admin interface. The problem is still reproducible when deleting all session files. But, the problem does not occur when I comment out a "session.connect" method in my application, indicating that the database session is somewhat related. I use CentOS 5.4 with Python 2.6. On 3月18日, 午後9:23, Massimo Di Pierro wrote: > Are other people having the same problem? Are you sure it is with > 1.94.4. Can you try delete all sessions files? > > On Mar 18, 5:59 am, kenji4569 wrote: > > > > > > > > > I have had trouble with 1.94.4 as follows: > > - Start the develop server of the web2py > > - Browse the admin application site > > - Log-in the site > > - Click a link to my application site (which uses a database > > session) > > - browse the admin application site again > > - Then, cannot log-in the site because somehow the session for the > > admin site become empty, and never can log-in until restart the > > develop server. > > Please help. > > > On 3月18日, 午後5:36, José L. wrote: > > > > Debian packages for 1.94.4 are already available where > > > usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > > > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> 2.5) > > > > Regards.
[web2py] Re: web2py 1.94.1 is OUT
Can you show the complete session.connect(...) statement? On Mar 18, 10:53 am, kenji4569 wrote: > I just upgraded from 1.91.6 to 1.94.4 through the admin interface. The > problem is still reproducible when deleting all session files. But, > the problem does not occur when I comment out a "session.connect" > method in my application, indicating that the database session is > somewhat related. I use CentOS 5.4 with Python 2.6. > > On 3月18日, 午後9:23, Massimo Di Pierro > wrote: > > > > > > > > > Are other people having the same problem? Are you sure it is with > > 1.94.4. Can you try delete all sessions files? > > > On Mar 18, 5:59 am, kenji4569 wrote: > > > > I have had trouble with 1.94.4 as follows: > > > - Start the develop server of the web2py > > > - Browse the admin application site > > > - Log-in the site > > > - Click a link to my application site (which uses a database > > > session) > > > - browse the admin application site again > > > - Then, cannot log-in the site because somehow the session for the > > > admin site become empty, and never can log-in until restart the > > > develop server. > > > Please help. > > > > On 3月18日, 午後5:36, José L. wrote: > > > > > Debian packages for 1.94.4 are already available where > > > > usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > > > > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> 2.5) > > > > > Regards.
[web2py] Re: web2py 1.94.1 is OUT
session.connect(request, response, masterapp=masterapp, db=db) where masterapp is my application name, and use the method in a module file. On 3月19日, 午前12:57, Massimo Di Pierro wrote: > Can you show the complete session.connect(...) statement? > > On Mar 18, 10:53 am, kenji4569 wrote: > > > > > > > > > I just upgraded from 1.91.6 to 1.94.4 through the admin interface. The > > problem is still reproducible when deleting all session files. But, > > the problem does not occur when I comment out a "session.connect" > > method in my application, indicating that the database session is > > somewhat related. I use CentOS 5.4 with Python 2.6. > > > On 3月18日, 午後9:23, Massimo Di Pierro > > wrote: > > > > Are other people having the same problem? Are you sure it is with > > > 1.94.4. Can you try delete all sessions files? > > > > On Mar 18, 5:59 am, kenji4569 wrote: > > > > > I have had trouble with 1.94.4 as follows: > > > > - Start the develop server of the web2py > > > > - Browse the admin application site > > > > - Log-in the site > > > > - Click a link to my application site (which uses a database > > > > session) > > > > - browse the admin application site again > > > > - Then, cannot log-in the site because somehow the session for the > > > > admin site become empty, and never can log-in until restart the > > > > develop server. > > > > Please help. > > > > > On 3月18日, 午後5:36, José L. wrote: > > > > > > Debian packages for 1.94.4 are already available where > > > > > usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > > > > > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> 2.5) > > > > > > Regards.
[web2py] Re: web2py 1.94.1 is OUT
I think this is a bug introduced in 1.94.* I will fix it later tonight. On Mar 18, 11:01 am, kenji4569 wrote: > session.connect(request, response, masterapp=masterapp, db=db) > where masterapp is my application name, and use the method in a module > file. > > On 3月19日, 午前12:57, Massimo Di Pierro > wrote: > > > > > > > > > Can you show the complete session.connect(...) statement? > > > On Mar 18, 10:53 am, kenji4569 wrote: > > > > I just upgraded from 1.91.6 to 1.94.4 through the admin interface. The > > > problem is still reproducible when deleting all session files. But, > > > the problem does not occur when I comment out a "session.connect" > > > method in my application, indicating that the database session is > > > somewhat related. I use CentOS 5.4 with Python 2.6. > > > > On 3月18日, 午後9:23, Massimo Di Pierro > > > wrote: > > > > > Are other people having the same problem? Are you sure it is with > > > > 1.94.4. Can you try delete all sessions files? > > > > > On Mar 18, 5:59 am, kenji4569 wrote: > > > > > > I have had trouble with 1.94.4 as follows: > > > > > - Start the develop server of the web2py > > > > > - Browse the admin application site > > > > > - Log-in the site > > > > > - Click a link to my application site (which uses a database > > > > > session) > > > > > - browse the admin application site again > > > > > - Then, cannot log-in the site because somehow the session for the > > > > > admin site become empty, and never can log-in until restart the > > > > > develop server. > > > > > Please help. > > > > > > On 3月18日, 午後5:36, José L. wrote: > > > > > > > Debian packages for 1.94.4 are already available where > > > > > > usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > > > > > > orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> > > > > > > 2.5) > > > > > > > Regards.
Re: [web2py] Re: web2py 1.94.1 is OUT
On Mar 18, 2011, at 9:01 AM, kenji4569 wrote: > > session.connect(request, response, masterapp=masterapp, db=db) > where masterapp is my application name, and use the method in a module > file. If it's in a module (vs model) file, where are you invoking it from? > > On 3月19日, 午前12:57, Massimo Di Pierro > wrote: >> Can you show the complete session.connect(...) statement? >> >> On Mar 18, 10:53 am, kenji4569 wrote: >> >> >> >> >> >> >> >>> I just upgraded from 1.91.6 to 1.94.4 through the admin interface. The >>> problem is still reproducible when deleting all session files. But, >>> the problem does not occur when I comment out a "session.connect" >>> method in my application, indicating that the database session is >>> somewhat related. I use CentOS 5.4 with Python 2.6. >> >>> On 3月18日, 午後9:23, Massimo Di Pierro >>> wrote: >> Are other people having the same problem? Are you sure it is with 1.94.4. Can you try delete all sessions files? >> On Mar 18, 5:59 am, kenji4569 wrote: >> > I have had trouble with 1.94.4 as follows: > - Start the develop server of the web2py > - Browse the admin application site > - Log-in the site > - Click a link to my application site (which uses a database > session) > - browse the admin application site again > - Then, cannot log-in the site because somehow the session for the > admin site become empty, and never can log-in until restart the > develop server. > Please help. >> > On 3月18日, 午後5:36, José L. wrote: >> >> Debian packages for 1.94.4 are already available where >> usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) >> orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> 2.5) >> >> Regards.
[web2py] Re: web2py 1.94.1 is OUT
> If it's in a module (vs model) file, where are you invoking it from? I define it in a helper function of a module file, and invoke the function in a model file. On 3月19日, 午前1:13, Jonathan Lundell wrote: > On Mar 18, 2011, at 9:01 AM, kenji4569 wrote: > > > > > session.connect(request, response, masterapp=masterapp, db=db) > > where masterapp is my application name, and use the method in a module > > file. > > If it's in a module (vs model) file, where are you invoking it from? > > > > > > > > > > > On 3月19日, 午前12:57, Massimo Di Pierro > > wrote: > >> Can you show the complete session.connect(...) statement? > > >> On Mar 18, 10:53 am, kenji4569 wrote: > > >>> I just upgraded from 1.91.6 to 1.94.4 through the admin interface. The > >>> problem is still reproducible when deleting all session files. But, > >>> the problem does not occur when I comment out a "session.connect" > >>> method in my application, indicating that the database session is > >>> somewhat related. I use CentOS 5.4 with Python 2.6. > > >>> On 3月18日, 午後9:23, Massimo Di Pierro > >>> wrote: > > Are other people having the same problem? Are you sure it is with > 1.94.4. Can you try delete all sessions files? > > On Mar 18, 5:59 am, kenji4569 wrote: > > > I have had trouble with 1.94.4 as follows: > > - Start the develop server of the web2py > > - Browse the admin application site > > - Log-in the site > > - Click a link to my application site (which uses a database > > session) > > - browse the admin application site again > > - Then, cannot log-in the site because somehow the session for the > > admin site become empty, and never can log-in until restart the > > develop server. > > Please help. > > > On 3月18日, 午後5:36, José L. wrote: > > >> Debian packages for 1.94.4 are already available where > >> usual:http://people.debian.org/~jredrejo/web2py/lenny/(forpython2.5) > >> orhttp://people.debian.org/~jredrejo/web2py/squeeze/(forpython>> 2.5) > > >> Regards.
[web2py] auth.has_membership: how to specify user and role?
Given a user ID with ID of 1 and a group with ID of 1 and role = "Super Admin" and an entry in auth_membership to tie the two together so that user 1 is a member of group 1 I can do: auth.has_membership(1,1) True but if I do: auth.has_membership(1, role="Super admin") False (I'm running latest trunk) Am I being stupid here? I'm following the syntax as described in the book: """ auth.has_membership(group_id, user_id, role) checks whether user_id has membership of the group group_id or the group with the specified role. Only group_id or role should be passed to the function, not both. If the user_id is not specified, then web2py assumes the current logged-in user. """
[web2py] Re: web2py anti-propaganda video
Another very useful video - thanks for putting these out! Clever use of decorators for template support. While we're on the topic of using web2py features outside of web2py: I have a package with library code, command line scripts, etc. -- let's call it "mypackage" Let's say I also have a web2py app "myapp". (the creative juices are really flowing this morning!) I want to be able to use the same DAL definition from: - myapp web2py controllers - mypackage command line scripts - mypackage library functions that may be called by either web2py or the command line scripts Are there any generally accepted "best" methods for organizing something like this? I can think of the following general approaches: 1. - Define my DAL in myapp's models/db.py, as usual - Within mypackage code, do "from web2py.applications.myapp.models.db import db". This has the following issues: (a.) I need to lug around my website code on machines where I want mypackage, even if I don't want to run the website (b.) If models/db.py is imported from outside web2py (e.g. a command line script), the contents only get evaluated once per execution. So I would only ever have a reference to one DB connection, which I think will cause problems if it is used from multiple threads. (Is this still correct?) (c.) Minor: I need to add "from gluon.dal import DAL, Field" to the top of db.py in models. Otherwise, imports from outside web2py will fail since db.py isn't being evaluated in web2py's context of preloaded gluon imports. I don't think this causes any problems, does it? It's just redundant when run within web2py? 2. A variant of #1: myapp/models/db.py: def get_db(): db = DAL(...) # Put this in a function, so it can be evaluated multiple times at runtime db.define_table(...) return db myapp/models/db_load.py: # Gets loaded by web2py after db.py? db = get_db() # We don't want this in db.py, or we'll have an extra connection hanging around in mypackage code mypackage/my-script.py: from web2py.applications.myapp.models.db import get_db def threadedRoutine(): db = get_db() do_stuff_within_thread(db) I think this takes care of problem 1.b above. 3. Define my DAL in mypackage, and import from there in the web2py models. For example: mypackage/db.py: db = DAL(...) db.define_table(...) myapp/models/db.py: from mypackage.db import db # warning - db only built once per server lifetime? This has the following problems; - If I make changes to the DAL definition under mypackage/db.py, I think I'll need to restart the web2py server -- these changes won't be picked up automatically since they are in an outside module, right? - If the module is only evaluated once per execution, as with #1.b. you again have the problem of only one DAL instance, and this will cause problems when multiple connections/threads are involved. But this time the problem extends to web2py, not just mypackage! Am I correct in saying this, or does DAL have any magic that allow multiple threads to work via a single DAL reference? But at least I don't need to carry my website code everywhere! 4.Like #3, define the DAL in mypackage and import into web2py models. But construct and return the database within a get_db() function, as with #2. Call get_db() from myapp/models/db.py to load a new DAL on each pageview, and from any mypackage thread that needs to use the db. I think this is pretty good, except that you still need to restart web2py when making changes to the DAL. Maybe if models/db.py looked something like: import mypackage.db # contents are normally evaluated once per execution reload(mypackage.db) # force mypackage.db to be re-read each time models/db.py is run db = mypackage.db.get_db() it would work, but I haven't tested it yet. If anybody out there has successfully organized a setup like this or could offer any suggestions, I'd greatly appreciate it! Thanks, Kevin
Re: [web2py] Re: We really should have something similar to DjDT in Web2py
Yup. Found out about it at my new job where I am programming in Django. BR, Jason Brower On 03/18/2011 05:01 PM, Ross Peoples wrote: That would be pretty cool. You sometimes have to jump through a few hoops to see all the variables and SQL code.
Re: [web2py] Re: web2py anti-propaganda video
On Fri, Mar 18, 2011 at 11:32 AM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
>
>
> On Mar 18, 8:54 am, Terrence Brannon wrote:
> > I dont think the HTML created with
> > web2py's template system is well-formed is it?
> >
> >
> > {{ for row: in rows }} < breaks well-formedness?
> >
> > ...
> >
>
> Not sure I understand. Are you referring to the extra new line?
>
No, I was guessing it is not allowed for plain-text to be between
and in well-formed HTML, but I could be wrong ( and probably should've
used HTML tidy to figure it out :)
[web2py] Re: auth.has_membership: how to specify user and role?
"Super Admin" != "Super admin" On Mar 18, 11:51 am, Tom Atkins wrote: > Given a user ID with ID of 1 > and a group with ID of 1 and role = "Super Admin" > and an entry in auth_membership to tie the two together so that user 1 is a > member of group 1 I can do: > > auth.has_membership(1,1) > > True > > but if I do: > > auth.has_membership(1, role="Super admin") > > False > > (I'm running latest trunk) > Am I being stupid here? I'm following the syntax as described in the book: > > """ > auth.has_membership(group_id, user_id, role) > > checks whether user_id has membership of the group group_id or the group > with the specified role. Only group_id or role should be passed to the > function, not both. If the user_id is not specified, then web2py assumes the > current logged-in user. > """
Re: [web2py] Re: auth.has_membership: how to specify user and role?
Thanks - that was only a typo in the example though... I just worked out my stupid error, I needed to use: auth.has_membership(user_id=1, role="Super admin") maybe too many pints on St. Patrick's day yesterday ;-) On 18 March 2011 18:17, Massimo Di Pierro wrote: > "Super Admin" != "Super admin" > > On Mar 18, 11:51 am, Tom Atkins wrote: > > Given a user ID with ID of 1 > > and a group with ID of 1 and role = "Super Admin" > > and an entry in auth_membership to tie the two together so that user 1 is > a > > member of group 1 I can do: > > > > auth.has_membership(1,1) > > > > True > > > > but if I do: > > > > auth.has_membership(1, role="Super admin") > > > > False > > > > (I'm running latest trunk) > > Am I being stupid here? I'm following the syntax as described in the > book: > > > > """ > > auth.has_membership(group_id, user_id, role) > > > > checks whether user_id has membership of the group group_id or the group > > with the specified role. Only group_id or role should be passed to the > > function, not both. If the user_id is not specified, then web2py assumes > the > > current logged-in user. > > """ >
[web2py] Re: web2py anti-propaganda video
amazed! I am still new to web2py with a cakephp background and I am very sorry to did not come across to web2py sooner. Just for curiousity: What program/environment you use to create these videos? On márc. 18, 13:32, Massimo Di Pierro wrote: > http://vimeo.com/21185623
Re: [web2py] Re: web2py anti-propaganda video
On Friday, March 18, 2011 11:47:50 AM UTC-4, metaperl wrote:
>
>
>
> On Fri, Mar 18, 2011 at 11:32 AM, Massimo Di Pierro > wrote:
>
>>
>>
>> On Mar 18, 8:54 am, Terrence Brannon wrote:
>> > I dont think the HTML created with
>> > web2py's template system is well-formed is it?
>> >
>> >
>> > {{ for row: in rows }} < breaks well-formedness?
>> >
>> > ...
>> >
>>
>> Not sure I understand. Are you referring to the extra new line?
>>
>
> No, I was guessing it is not allowed for plain-text to be between
> and in well-formed HTML, but I could be wrong ( and probably should've
> used HTML tidy to figure it out :)
>
The template code to which you are pointing does not actually generate any
HTML at the point of the {{ for row in rows:}} Python code (i.e., between
the table and tr tags). That is simply a Python statement that begins a for
loop, which loops over the subsequent lines (i.e., the lines from to
) -- the loop creates a table row for each row in rows (there should be
a {{pass}} statement at the end to indicate the scope of the loop). The
template system is not inserting text in every place where you see {{ }}. It
only inserts something if preceded by an '=', such as
{{=var_from_controller}}, or when response.write is called explicitly. Does
that make sense? Read ch. 5 for more details:
http://web2py.com/book/default/chapter/05
Anthony
[web2py] Best way to return all users who have a specific role?
OK my brain is still failing me today:
What's the best way to return the details of all users who have a specific
role?
I have something like:
for row in db(db.auth_user).select():
if auth.has_membership(user_id=row.id, role=('Super admin')):
# do something
but can't help feeling there's a better way!
[web2py] Re: Best way to return all users who have a specific role?
I would think a join could get you there in one query. Something like: users = db((db.auth_user.id==db.auth_membership.user_id) & (db.auth_membership.group_id==db.auth_group.id) & (db.auth_group.role=='Super admin')).select() for user in user: #do something The query is messier but I worry that your query is hitting the DB on each iteration through the loop (anyone know?). Also note that you have to reference the result set differently because of the joins. It would help to take a look at "users" in the raw (ie, return dict(users=users) and just take a look at the data). It's going to be something like: user.auth_user.first_name, etc. I realize that joins force the more complicated representation but am wondering if there are any solutions? For example, could it be made so that if we code "select(db.auth_user)" that it only return the auth_user table elements?
[web2py] Re: Best way to return all users who have a specific role?
That should be: for user in users: #2nd plural
Re: [web2py] Re: web2py applications and version control systems
Christian, Thanks yes, as a GAE user you *need* to have app.yaml, index.yaml, and queue.yaml > in your source control (right now they get overwritten on upgrade so you > want them backed up). most people also need to have routes.py in their > source control. > Ok. It seems that I need to have the web2py directory as my version control root rather than web2py/applications/myapp > when i want to test out new things from trunk, i have an hg repository of > trunk and i just symlink the application that i want to test into that > directory. usually works without too much fuss. > And because I am using GAE I'll need to symlink the yaml files as well. Thanks Dave -- Dave Warnock: http://42.blogs.warnock.me.uk Cycling Blog: http://42bikes.warnock.me.uk
Re: [web2py] Re: web2py applications and version control systems
Hi, I hg clone web2py and then set up a second repository for my app. So I can > update web2py and my app independently. I am using git, but no problem. Which directory do you have as the root for the app repository? web2py or web2py/applications/myapp Thanks Dave -- Dave Warnock: http://42.blogs.warnock.me.uk Cycling Blog: http://42bikes.warnock.me.uk
Re: [web2py] Re: web2py applications and version control systems
On Mar 18, 2011, at 12:31 PM, David Warnock wrote: > Christian, > > Thanks > > yes, as a GAE user you *need* to have app.yaml, index.yaml, and queue.yaml in > your source control (right now they get overwritten on upgrade so you want > them backed up). most people also need to have routes.py in their source > control. > > Ok. It seems that I need to have the web2py directory as my version control > root rather than web2py/applications/myapp > > when i want to test out new things from trunk, i have an hg repository of > trunk and i just symlink the application that i want to test into that > directory. usually works without too much fuss. > > And because I am using GAE I'll need to symlink the yaml files as well. > I keep my app.yaml, routes.py, etc in my applications private/ directory for version-control purposes, and either copy or link them to the web2py root for deployment.
Re: [web2py] Re: Best way to return all users who have a specific role?
Thank you - yes the double hit on the database was what made it seem inelegant to me. Your joined query works fine and I can work with the return data. Any further improvements gratefully received! Hoping Massimo has an undocumented super 1 liner! ;-)
Re: [web2py] Re: web2py applications and version control systems
For web2py, web2py is root. For my app, myapp is root. Pulling from web2py repository will leave my app alone.
Re: [web2py] Re: web2py applications and version control systems
I do this as well. I have all my misc files in private and then in my setup and deploy Fabric scripts to "rm /var/web2py/routes.py; cp routes.py var/web2py/routes.py" Linking actually sounds like a better way to go?
[web2py] Re: Best way to return all users who have a specific role?
If you have given explicit permission to the group:
group_id=auth.add_group('Super Admin')
auth.add_permission(group_id, 'read', db.mytable)
then you can do:
for row in db(auth.accessible_query('read',
db.mytable)).select(db.mytable.ALL): print row
in the case being discussed mytable is auth_user
On Mar 18, 2:38 pm, Tom Atkins wrote:
> Thank you - yes the double hit on the database was what made it seem
> inelegant to me.
>
> Your joined query works fine and I can work with the return data. Any
> further improvements gratefully received! Hoping Massimo has an undocumented
> super 1 liner! ;-)
[web2py] Re: Oracle DB - Select into an existing table DAL problem.
Thanks, This is unfortunately quite heavy to redefine the tables with define_table, but it works. I did not yet tried for the tables without primary key. Regards, On Mar 9, 6:42 am, cjrh wrote: > On Mar 8, 9:26 pm, Pivert wrote: > > > - My first problem was a major typo in the documentation. For oracle > > connector, the username and password are not separated by : but by /, > > to the oracle connection string is : > > oracle://username/password@DBNameInTnsnamesFile' > > Fixed, thank you.
[web2py] 1.94.5 is OUT
I apologize, the 1.94.1-4 has had problems with sessions because of recent major refactoring. The latest reported here: http://groups.google.com/group/web2py/msg/59f3716c4dcbdf47 Jonathan figured out the problem and submitted a patch. It passes my tests. Please check it and hopefully the issue is resolved. If you still have problems with sessions, let us know asap. Massimo
[web2py] Making another app building wizard.
I wonder how useful it would be to have a wizard to help pull all the common bulding blocks without the predone welcome application. That is, it contains the html but with no body content and the files and feature installed and ready to use. This provides us with the ability for more variety in our features like what js libraries to use what templating tool and other things the welcome app cant do. This to me is a better start for more advanced users. Any ideas on this? Best regards, JB
[web2py] could step 3 in the application wizard benefit from the phpMyAdmin UI
In [step 3 of the application wizard](http://imgur.com/Xrk2U) one is supposed to enter the fields for a table. It uses a tremendous of text to describe field entry - with no link to the corresponding part of the book. Wouldnt a series of checkboxes for things like null, primary key, be nice? And how about a pulldown for the various datatypes? The way that phpMyAdmin allows one to define fields when building a table is more graphical. You can try out the phpMyAdmin way here: http://demo.phpmyadmin.net And btw, what is the difference between notnull and notempty? I suppose an empty string in a column is not null, but is empty, but I'm guessing.
[web2py] SyntaxError: not enough information to build the url
The archives have 3 instances of this problem, but their solutions do not apply to me. Here is a link to the ticket for the failed application creation: http://static.livingcosmos.org/tmp/127.0.0.1.2011-03-18.17-17-30.156fa84f-4485-4a40-937d-6bb44d73d60f.html All I tried to do was create a single table with 3 string files NOT NULL. I did not mess with any other defaults. The only unusual thing about the whole procedure was when I accidentally hit "+" and added a blank table after my table and hit submit. At that point, web2py went back to the table creation screen and only made one table.
Re: [web2py] 1.94.5 is OUT
I think the windows version is still 1.94.4, not 1.94.5 2011/3/18 Massimo Di Pierro > I apologize, the 1.94.1-4 has had problems with sessions because of > recent major refactoring. The latest reported here: > > http://groups.google.com/group/web2py/msg/59f3716c4dcbdf47 > > Jonathan figured out the problem and submitted a patch. It passes my > tests. > Please check it and hopefully the issue is resolved. > If you still have problems with sessions, let us know asap. > > Massimo Martin
[web2py] adding auth later?
For the moment, I want to build a non-auth application. How hard is it to add user authentication later?
[web2py] Re: adding auth later?
Dare I say it's not too difficult?
[web2py] Re: Best way to return all users who have a specific role?
The book says 'db(accessible_query(...)...' -- should it say 'db(auth.
accessible_query(...)...'?
http://web2py.com/book/default/chapter/08?search=accessible_query
On Friday, March 18, 2011 4:08:18 PM UTC-4, Massimo Di Pierro wrote:
> If you have given explicit permission to the group:
>
> group_id=auth.add_group('Super Admin')
> auth.add_permission(group_id, 'read', db.mytable)
>
> then you can do:
>
> for row in db(auth.accessible_query('read',
> db.mytable)).select(db.mytable.ALL): print row
>
> in the case being discussed mytable is auth_user
>
> On Mar 18, 2:38 pm, Tom Atkins wrote:
> > Thank you - yes the double hit on the database was what made it seem
> > inelegant to me.
> >
> > Your joined query works fine and I can work with the return data. Any
> > further improvements gratefully received! Hoping Massimo has an
> undocumented
> > super 1 liner! ;-)
[web2py] why is my database zero-length after commiting a record
web2py shell transcript of session resulting in no records in sqlite
storage.db file after doing an insert with no error:
[thequietcenter@ubuntu ~/prg/yinyogaworks] ../web2py/web2py.py --
shell=tmp
web2py Enterprise Web Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.94.4 (2011-03-18 02:53:34)
Database drivers available: SQLite3, pymysql, CouchDB
WARNING:web2py:import IPython error; use default python shell
Python 2.6.5 (r265:79063, Apr 16 2010, 13:09:56)
[GCC 4.4.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> db = DAL('sqlite://storage.db')
>>> db.define_table('asanas', Field('name'), Field('img_url'),
>>> Field('page_url'))
,
'virtualfields': [], '_sequence_name': 'asanas_sequence', 'name':
, '_referenced_by': [], 'fields':
['id', 'name', 'img_url', 'page_url'], '_db': ,
'check_reserved': None, '_uri': 'sqlite://storage.db', 'tables':
['asanas'], 'asanas': , '_migrate': True, '_pool_size': 0}
>, '_dbt': 'applications/tmp/databases/
fb87181b96a99be45f5a23f4277867ce_asanas.table', '_trigger_name':
'asanas_sequence', '_loggername': 'applications/tmp/databases/
sql.log', '_tablename': 'asanas', '_format': None, '_id':
, 'img_url': , 'id': ,
'page_url': }>
>>> db.asanas.insert(name='placeholder', img_url='http://place',
>>> page_url='http://holder')
1
>>> db.commit()
>>>
[thequietcenter@ubuntu ~/prg/yinyogaworks] ls -l
total 12
drwxr-xr-x 2 thequietcenter thequietcenter 4096 2011-03-18 12:10 dojo
-rw-r--r-- 1 thequietcenter thequietcenter 1037 2011-03-18 19:07 grab-
asanas.py
-rw-r--r-- 1 thequietcenter thequietcenter 333 2011-03-18 08:40 grab-
asanas.py~
-rw-r--r-- 1 thequietcenter thequietcenter0 2011-03-18 19:07
storage.db
[thequietcenter@ubuntu ~/prg/yinyogaworks]
[web2py] Re: 1.94.5 is OUT
if I use the upgrade that comes with admin (and I tried twice), I still get Version 1.94.4 (2011-03-18 02:53:34. If I use mine, I can get: Select option: 1) check for updates on web2py.com 2) check for updates and install latest available release 3) upgrade from a local copy 4) revert to a previous version 5) diff current web2py against latest available version at web2py.com 6) diff current web2py against a local codebase 7) install latest available version from web2py.com 8) Quit * upgrade are from source only. 1 extracting version information from http://www.web2py.com/examples/static/web2py_src.zip... latest available web2py server version from the web is 1.94.5 Thanks, Mart :)s On Mar 18, 5:31 pm, Martin Weissenboeck wrote: > I think the windows version is still 1.94.4, not 1.94.5 > > 2011/3/18 Massimo Di Pierro > > > I apologize, the 1.94.1-4 has had problems with sessions because of > > recent major refactoring. The latest reported here: > > >http://groups.google.com/group/web2py/msg/59f3716c4dcbdf47 > > > Jonathan figured out the problem and submitted a patch. It passes my > > tests. > > Please check it and hopefully the issue is resolved. > > If you still have problems with sessions, let us know asap. > > > Massimo > > Martin
[web2py] Re: index.yaml not automatically generated in GAE SDK
Richard, if your query only orders or filters on a single property no index is required (GAE actually does build an index, but those are auto-generated and do not need to be specified in your index.yaml). some queries that need indexes (assume for a moment that the proper tables are defined): db((db.building.type='house') & (db.building.built > '2010-01-27')).select() db(db.building.type='house').select(orderby=~db.building.built) glad you are enjoying web2py! christian
[web2py] Re: auth.has_membership: how to specify user and role?
>> maybe too many pints on St. Patrick's day yesterday ;-) Tom, you're right -- I've felt terrible today, and I'm blaming the Irish! :-) Great fun though...!
[web2py] Re: book "bugs"
villas: tonight I went through the edits you made, and just about everything looks like it was correctly added to the book, including these two IS_DATE corrections. Thanks for your work on this! Kevin
[web2py] Re: adding auth later?
Basically you would need to add this to model from gluon.tools import Auth auth=Auth(globals(),db) auth.define_tables() and this to controller def user(): return dict(form=auth()) then decorate the actions as usual @auth.requires_login() You may want to customize some settings auth.settings.blablabla = 'blablabla' On Mar 18, 4:53 pm, pbreit wrote: > Dare I say it's not too difficult?
[web2py] Re: 1.94.5 is OUT
can you please try again? On Mar 18, 6:49 pm, mart wrote: > if I use the upgrade that comes with admin (and I tried twice), I > still get > Version 1.94.4 (2011-03-18 02:53:34. > > If I use mine, I can get: > > Select option: > 1) check for updates on web2py.com > 2) check for updates and install latest available release > 3) upgrade from a local copy > 4) revert to a previous version > 5) diff current web2py against latest available version at > web2py.com > 6) diff current web2py against a local codebase > 7) install latest available version from web2py.com > 8) Quit > > * upgrade are from source only. > > 1 > > extracting version information > fromhttp://www.web2py.com/examples/static/web2py_src.zip... > latest available web2py server version from the web is 1.94.5 > > Thanks, > Mart :)s > > On Mar 18, 5:31 pm, Martin Weissenboeck wrote: > > > > > > > > > I think the windows version is still 1.94.4, not 1.94.5 > > > 2011/3/18 Massimo Di Pierro > > > > I apologize, the 1.94.1-4 has had problems with sessions because of > > > recent major refactoring. The latest reported here: > > > >http://groups.google.com/group/web2py/msg/59f3716c4dcbdf47 > > > > Jonathan figured out the problem and submitted a patch. It passes my > > > tests. > > > Please check it and hopefully the issue is resolved. > > > If you still have problems with sessions, let us know asap. > > > > Massimo > > > Martin
[web2py] web2py.com is down right now
Re: [web2py] web2py.com is down right now
works for me :) On Sat, Mar 19, 2011 at 5:07 AM, Anthony wrote: >
Re: [web2py] web2py.com is down right now
http://www.downforeveryoneorjustme.com/web2py.com Em 19/03/2011, às 01:54, Marin Pranjic escreveu: > works for me :) > > On Sat, Mar 19, 2011 at 5:07 AM, Anthony wrote: >
Re: [web2py] Re: Proposals for New Tagline
I notice that "enterprise" still appears in http://twitpic.com/4awuyv Will it be removed? I am removing it from portuguese translation.
[web2py] Re: 1.94.5 is OUT
The problem is now resolved. Thank you for your quick response. Kenji On 3月19日, 午前5:28, Massimo Di Pierro wrote: > I apologize, the 1.94.1-4 has had problems with sessions because of > recent major refactoring. The latest reported here: > > http://groups.google.com/group/web2py/msg/59f3716c4dcbdf47 > > Jonathan figured out the problem and submitted a patch. It passes my > tests. > Please check it and hopefully the issue is resolved. > If you still have problems with sessions, let us know asap. > > Massimo
