[web2py] Re: web2py and gae : Delete everything in the datastore

2011-01-28 Thread howesc
if i remember correctly the bulk delete was google's christmas present to us - in the decemeber release, so it's a new feature, but quite handy!

[web2py] Re: Is there an alternative to Django's Pinax in the world of Web2py?

2011-01-28 Thread Massimo Di Pierro
The pinax web site says: ...including apps for: account management [x] openid [x] e-mail verification [?] password management [x] profiles [x] notifications [z] activity streams [z] private betas / waiting lists [?] badges [?] tagging [t] wikis [t] forums [f] blogs [t] task tracking [?] friend an

Re: [web2py] query in DAL

2011-01-28 Thread beto (R3)
Hey Vasile: Thanks for your answer.. yes.. that I know and that's actually what I'm doing.. but I'd like to use the benefits of doing it with DAL. (cache the queries, security validation for parameters, etc). regards. On Fri, Jan 28, 2011 at 7:18 PM, Vasile Ermicioi wrote: > you always can exec

[web2py] Re: 2 quickies about cache

2011-01-28 Thread Massimo Di Pierro
web2py uses the query "db.log.id==X" as the key for the cache (where X will be replaced by the actual value). The problem is that if you have a lot of records this may cause a memory leak since, in theory, you may be caching every individual record. On Jan 28, 3:52 pm, Magnitus wrote: > I'm tryin

[web2py] Re: empty list:reference seems like a bug

2011-01-28 Thread Massimo Di Pierro
Can you please try trunk? On Jan 28, 3:47 pm, LightOfMooN wrote: > Running 1.91.6 too. > > db.define_table('tag', >     Field('name', 'string'), format='%(name)s') > > db.define_table('rolic', >     Field('name', 'string'), >     Field('tags', 'list:reference tag', required=True), >     ) > > Add

[web2py] Re: Learning materials for newbie

2011-01-28 Thread noob.py
Thanks for quick answer. But let's assume that I know Python, web2py, HTML, CSS, JavaScript (I suppose I must learn'em all, right?). Do I have to learn something more? Or such knowledge is sufficient for web apps developement?

[web2py] Re: Learning materials for newbie

2011-01-28 Thread noob.py
THANKS GUYS!

Re: [web2py] Re: LIKE case sensitivity: Postgres differs to MySQL => DAL not portable

2011-01-28 Thread Thadeus Burgess
IMHO This breaks backwards compatibility... -- Thadeus On Sat, Jan 29, 2011 at 6:31 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > I treat this as a bug fix. > > On Jan 28, 12:52 pm, Anthony wrote: > > On Friday, January 28, 2011 12:58:30 PM UTC-5, Massimo Di Pierro wrote: > >

[web2py] Re: Learning materials for newbie

2011-01-28 Thread Anthony
On Friday, January 28, 2011 5:41:11 PM UTC-5, noob.py wrote: > > Thanks for quick answer. > But let's assume that I know Python, web2py, HTML, CSS, JavaScript (I > suppose I must learn'em all, right?). Do I have to learn something > more? Or such knowledge is sufficient for web apps developemen

Re: [web2py] query in DAL

2011-01-28 Thread Vasile Ermicioi
perhaps db((db.logs.date.year()==2010) & (db.stock.item == db.logs.item)).select(db.logs.date,db.logs.item.count(), groupby=db.logs.date)

[web2py] Re: Learning materials for newbie

2011-01-28 Thread mikech
I've also found it pretty useful recently to run the web2py app from source in a good ide, in my case WingIDE which I have a 10 day trial on, and step thru the program using the debugger.

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL => DAL not portable

2011-01-28 Thread Bernd Rothert
On 28 Jan., 16:46, Thadeus Burgess wrote: > Case sensitive search is one of the benefits of using postgres instead of > mysql! > As Fran wrote case insensitive LIKE is just a default for MySQL and sqlite. MySQL supports case sensitive search: # SELECT * FROM person WHERE name LIKE BINARY '%Pi%';

[web2py] Re: Fwd: web2py basic auth

2011-01-28 Thread Niphlod
call_or_redirect() is the real "addition" here you can use both a URL or a function to manage on_failed_authentication and on_failed_authorization ... take a look in gluon/utils.py On Jan 28, 1:48 am, miguel wrote: > I suppose this is mentioned in the Change Log by: > "on_failed_authorizatio

Re: [web2py] query in DAL

2011-01-28 Thread beto (R3)
Hey: Nope.. that won't work.. that puts everything in a single query.. The reason I'm doing SELECT ... FROM ( SELECT.. GROUP BY ..) is to get rid of multiple items in the same day. That's why I group by date, items and then group by date. If I could do a count(distinct(items)) I could do that in

[web2py] Testing model validation

2011-01-28 Thread blackthorne
I'm looking for a hook in web2py that allows me to check if a model is valid. It doesn't have to work 100%, but "best-offer", kind of what we have on the web editor right after saving the model file. Is this possible to do for a given file? Thank you, Best regards

[web2py] Re: Important Pycon 2011

2011-01-28 Thread Anthony
Massimo offered to reimburse $70 of the registration fee to the first 5 people to sign up. I'm not sure if I'm in the first 5 (registered on Jan. 16), but if I am, I offer my $70 reimbursement to whoever signs up next. : ) I hope they don't cancel it -- I'm looking forward to meeting some other

Re: [web2py] Re: Adding fields to the default register form;

2011-01-28 Thread Anthony
On Thursday, January 27, 2011 12:53:34 PM UTC-5, rochacbruno wrote: > > *Manipulation of the SQLFORM object* > {{=form.elements()[0].insert(0,LABEL('test:',INPUT(_type='text')))}} > or in a more comprehensive way > {{=form.elements('form tr td')[0].insert(0,INPUT())}} > Altering forms via ser

[web2py] Re: T-Shirts web2py

2011-01-28 Thread Robert
On 2011-01-27 17:03:21 -0500, mikech said: +1 Zazzle is another alternative.  I don't know if you've ordered t-shirts from Cafe Express, but I did some time ago, and they seemed very lightweight.  Don't know if Zazzle is any better.   Here is a comparison:  http://www.squidoo.com/cafepress_al

Re: [web2py] Re: Adding fields to the default register form;

2011-01-28 Thread Bruno Rocha
2011/1/28 Anthony > On Thursday, January 27, 2011 12:53:34 PM UTC-5, rochacbruno wrote: > >> *Manipulation of the SQLFORM object* >> {{=form.elements()[0].insert(0,LABEL('test:',INPUT(_type='text')))}} >> or in a more comprehensive way >> {{=form.elements('form tr td')[0].insert(0,INPUT())}} >

Re: [web2py] Re: Adding fields to the default register form;

2011-01-28 Thread Anthony
On Friday, January 28, 2011 9:15:20 PM UTC-5, rochacbruno wrote: > > 2011/1/28 Anthony > >> Altering forms via server-side DOM manipulations should be documented in >> the book. It seems to come up a lot, but I don't think it's all that obvious >> or explicit in the book. The Views chapter (ch.

Re: [web2py] Re: web2pyslices migration

2011-01-28 Thread Bruno Rocha
I created a twitter account for @web2pyslices For now, it will only automatic tweet about reamdom slices, comments and updates on the site, also it will tweet some random tips taken from here, google search and from the official book. Follow us http://twitter.com/web2pyslices (a better logo and a

[web2py] Re: LIKE case sensitivity: Postgres differs to MySQL => DAL not portable

2011-01-28 Thread KMax
On 29 янв, 05:39, Bernd Rothert wrote: > On 28 Jan., 16:46, Thadeus Burgess wrote: > > > Case sensitive search is one of the benefits of using postgres instead of > > mysql! > > As Fran wrote case insensitive LIKE is just a default for MySQL and > sqlite. MySQL supports case sensitive search: Thi

[web2py] Re: Is there an alternative to Django's Pinax in the world of Web2py?

2011-01-28 Thread William
if somebody can use web2py to build a facebook like or groupon like site, that would beat django or pinax :) i want to see web2py go to mainstream, it is so young! -Bill

[web2py] Re: Is there an alternative to Django's Pinax in the world of Web2py? Options

2011-01-28 Thread Anthony
Where is it?

[web2py] Re: django admin like app/plugin in web2py

2011-01-28 Thread mart
Hey this is nice! Makes it easy to create a group of admins! :) Also, you can always make appAdmin open & available for your app to all users (its trivial to do really), although i don't see any benefit. hum come to think of it, its probably a bug. I like Bruno's script better than handing the

[web2py] Re: PDF Reports with Pisa

2011-01-28 Thread mart
Oh, I'm sure the problem is on my side (I have tones of crap in my web2py server). I'm sure if I clean up, things would run much smoother... Actually, I think I will. Lemme install a fresh server with basic app, and I'll try it. I'll let you know what I find. For now, I can just say that I was una

[web2py] Re: T-Shirts web2py

2011-01-28 Thread mart
just a thought... wouldn't an app, 'powered by web2py', where we go to buy stuff (like t-shirts) take the cause further? and if making money is the plan, should we not expand the product line to include other frameworks; shows confidence, we can make more money for web2py AND, we can use proven mar

[web2py] Re: 2 quickies about cache

2011-01-28 Thread Magnitus
> web2py uses the query "db.log.id==X" as the key for the cache (where X > will be replaced by the actual value). Clever. Very simple, yet powerful. Thanks for the clarification. > The problem is that if you have a lot of records this may cause a > memory leak since, in theory, you may be cachin

Re: [web2py] query in DAL

2011-01-28 Thread Vasile Ermicioi
_sql1 = db(db.logs.date.year()==2010)._select(db.logs.date, db.logs.item, groupby=db.logs.item) rows = db(db.logs.item.belongs(_sql1) & (db.stock.item == db.logs.item)).select(db.logs.date,db.logs.item.count(), groupby=db.logs.date) notice _select for the first query

<    1   2