[web2py] Re: AJAX in Web2py -> Synchronous

Ohhh, OK, Anthony. Yes, my version is the same. And yes I'm reffering to . I deleted them, because I thought it was for commenting out (nearly everything was greyed out). >From your link: "Old browsers will treat your JS code as one long HTML comment. On the other hand, new JavaScript-aware brows

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

On 7 дек 2010, 00:31, Fran wrote: > - minimally it should be in a FAQ (ideally in the next Book) & ideally > we could have a case_sensitive=True option for the DAL like() > operator...to ensure that both pgsql & mysql/sqlite existing apps > didn't break, it could default differently depending on

[web2py] Speeding up IS_IN_DB

I have a lot of foreign keys in a database of which some tables have more than 30 records. What is happening is that if a link to add a record is selected it takes a long time before the form appears because all the cross referencess in the IS_IN_DB-dropdowns have to be assembled. How do I s

Re: [web2py] Speeding up IS_IN_DB

Hi ! You can be more specific? have any suggestions to improve this? -- Lucas D'Avila http://flavors.me/lucasdavila Em 28/01/2011 09:19, "Johann Spies" escreveu:

[web2py] Re: WSGI apache -- WSGIScriptAlias as /python and not just plain /

I'm guessing that nothing has changed here since I see the self-same problem now. I'm packaging Sahana (& hence Web2Py) to run on OSGeo Live (http://live.osgeo.org) We cannot have a dedicated vhost in this environment so I need to be able to run off a subdirectory. Since WSGI seems impossible

Re: [web2py] Speeding up IS_IN_DB

On 28 January 2011 13:30, Lucas D'Avila wrote: > Hi ! > > You can be more specific? have any suggestions to improve this? > OK. For the following model, calling DAL.create it takes 65 seconds to open the form using web2py's own webserver and 35 seconds when using Apache + WSGI. Both too long:

Re: [web2py] Speeding up IS_IN_DB

ops! sorry my last comment is for another post :( , please ignore what I said ... -- Lucas D'Avila http://flavors.me/lucasdavila Em 28/01/2011 09:54, "Johann Spies" escreveu:

Re: [web2py] Re: PDF Reports with Pisa

Can you be more specific? have any suggestions to improve this? -- Lucas D'Avila http://flavors.me/lucasdavila Em 28/01/2011 05:46, "mart" escreveu: > Just letting you now... I looking to see it in action (the custom > _code part looks really interesting), but am stumped as it tries to do > the

Re: [web2py] Speeding up IS_IN_DB

I think you need manually create index(es) in the database. 2011/1/28 Johann Spies > I have a lot of foreign keys in a database of which some tables have more > than 30 records. What is happening is that if a link to add a record > is selected it takes a long time before the form appears

Re: [web2py] Re: PDF Reports with Pisa

what about reportlab? 2011/1/28 Lucas D'Avila > Can you be more specific? have any suggestions to improve this? > > -- > > Lucas D'Avila > http://flavors.me/lucasdavila > Em 28/01/2011 05:46, "mart" escreveu: > > > Just letting you now... I looking to see it in action (the custom > > _code part

[web2py] How to do a count distinct with DAL?

How to do a count distinct with DAL? like: db().count(db.item.of_variant, distinct=True)

Re: [web2py] Speeding up IS_IN_DB

On 28 January 2011 14:09, Alexandre Andrade wrote: > I think you need manually create index(es) in the database. > I did create indexes although I do not think it should be necessary for id-fields in the light of the following quote from Postgresql documentation: "PostgreSQL automatically create

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

Yes, it is an amazing time saver. On Jan 27, 11:56 pm, William wrote: > Just vote it! > why nobody care this? They claim django admin is the kill feature of django.

[web2py] web2py on free hosting with no shell or httpd.conf access

Hi, I got interested in web2py after seeing the no install/ configuration comment on the web2py homepage. Is it possible to copy the web2py folder to a free hosting account and somehow get up and running? The account I currently have has python (but only able to execute python files with .cgi exten

[web2py] table referencing?

Bear with me my language is not english, so ill try to be plain and straight i have a table that references another 2 tables. when im generating the form works nicely as i want, but when i retrieve the list with a db select all i dont get the referenced names of the tables...i get only the id's...

[web2py] Re: Change in URL args handling

I had another problem with url argument handling that came in was "/app/controller/function/arg1\r". The default regex matching ( regex_args.match(request.raw_args( )) for the arguments would return false and then the application would respond with an "invalid request" error. It is not obvious f

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

I use something like this: @auth.requires_membership('admin') def index(): args = request.args title = 'Administration' if not args: link = UL(*[LI(A(tab,_href=URL(args=tab))) for tab in db.tables]) return dict(items=link,title=title) if not args(1): i =

[web2py] Re: Speeding up IS_IN_DB

According to your model you have two references: 1) joernaal.id (with autocomplete) 2) article.ouid (without) How many records do you have in joernaal and in article tables?. On Jan 28, 6:54 am, Johann Spies wrote: > On 28 January 2011 13:30, Lucas D'Avila wrote: > > > Hi ! > > > You can be m

[web2py] Re: What is web2py best practice basis for modular site development?

I am developing a website with many features required my client, using web2py. So, I'd also like to see the best practice for modular site development. In my development, I made two applications for a website, one is for front, and the other is for admin site. And I think it worked well, though ob

[web2py] Re: The web of connected p2p web2py apps ? (or a new kind of social network)

I believe the new DAL has support for CouchDB but I have not tested it. There was some work done on MongoDB on the old DAL but I have to redo it for the new one. On Jan 26, 6:18 pm, Offray Vladimir Luna Cárdenas wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi all, > > I'm lookin

[web2py] Re: What is web2py best practice basis for modular site development?

I am developing a website with many features required my client, using web2py. So, I'd also like to see the best practice for modular site development. In my development, I made two applications for a website, one is for front, and the other is for admin site. And I think it worked well, though ob

[web2py] Re: web2py on free hosting with no shell or httpd.conf access

In general if you have wsgi, you need just to set wsgihandler.py (without extension in some implementations) as your startup script, supposed you have Python 2.5 or 2.6 of course. But you should look into your hosting instructions about configuring a wsgi application in their environment. On 28 Ge

[web2py] Re: Change in URL args handling

On Jan 27, 5:58 pm, Jonathan Lundell wrote: > On Jan 27, 2011, at 12:48 PM, DenesL wrote: > > Still, it bothers me that arg1 == arg1/ != arg1//; (optional) trailing slash> seems like an odd rule. > > Notice also that '/'.join(['arg1', '']) is 'arg1/', not 'arg1//'. True. Moreover URL('f',args=

[web2py] Re: table referencing?

The generic formula for a 3 way join is: db.define_table('a',db.Field('name')) db.define_table('b',db.Field('name')) db.define_table('t',db.Field('name'),db.Field('aid',db.a),db.Field('bid',db.b)) rows=db().select(db.t.name,db.a.name,db.b.name, left=[db.a.on(db.a.id==db.t.aid),db.b.on(db.b.id==

[web2py] Re: Callable as Field.default

The fact is, you can do both. If you want the values to be evaluated on insert, just do Field(...,default=lambda: f()) instead of Field(...,default=f()) If you want lazy evaluation you have to be explicit. On Jan 27, 4:51 pm, Vinicius Assef wrote: > On Thu, Jan 27, 2011 at 3:54 PM, Bernd Roth

[web2py] Re: Can any help me with new dal in trunk?

this should now be fixed in trunk On Jan 8, 2:58 pm, Thadeus Burgess wrote: >  All I know is that tables are issued as lowercase, but you can still access > your table as an uppercase attribute. > > There is an inconsistency in the DAL somewhere because of this... Somewhere > it is forgetting to

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

I agree the behavior should be uniform. The easiest way is to make the LIKE always case insensitive. I am patching trunk to use ILIKE with postgresql. On Jan 28, 3:01 am, KMax wrote: > On 7 дек 2010, 00:31, Fran wrote: > > > - minimally it should be in a FAQ (ideally in the next Book) & ideally

[web2py] Re: How to do a count distinct with DAL?

The SQL command would be SELECT COUNT(DISTINCT item.of_variant) FROM item; but I believe that is not something you can build in the DAL currently. In addition that SQL command might not be supported by all the backend DBs. It seems to work in SQLite and MS-SQL though. So you have two options: 1)

[web2py] Re: How to do a count distinct with DAL?

This is not supported because I am not sure all supported RDBS support count(distinct ...). As a way around it you can do len(db().select(db.item.of_variant,distinct=True)) Massimo On Jan 28, 6:32 am, vortex wrote: > How to do a count distinct with DAL? > > like: > > db().count(db.item.of_vari

[web2py] Re: Speeding up IS_IN_DB

This: requires = IS_IN_DB(db, db.joernaal.id, '%(titel)s') indicates you want to a select/options dropbox and it takes time to populate it. Use instead: requires = [IS_IN_DB(db, db.joernaal.id,'%(titel)s')] so no dropbox and use autocomplete. On Jan 28, 5:54 am, Johann Spies wrote: > On 28

[web2py] Re: The web of connected p2p web2py apps ? (or a new kind of social network)

yes. it does. not only tested for string types. Should work for integer and double but probably does not work for date/datetime//time/ boolean types. It would not take much to fix it. On Jan 28, 7:53 am, DenesL wrote: > I believe the new DAL has support for CouchDB but I have not tested > it. >

[web2py] Re: How to do a count distinct with DAL?

Thank you very much! On Jan 28, 2:43 pm, Massimo Di Pierro wrote: > This is not supported because I am not sure all supported RDBS support > count(distinct ...). > > As a way around it you can do > > len(db().select(db.item.of_variant,distinct=True)) > > Massimo > > On Jan 28, 6:32 am, vortex wr

[web2py] Best way to implement network database system with web2py

Hi, I would like to implement a system of several databases on for each store and then have the master database stored at a sever for all company. Each store can read/write data to the local database and then synchronize the databases. Or should I enforce read/write only on master server database

[web2py] empty list:reference seems like a bug

It's a problem, that if i have empty list:reference, the standard database administration don't work because of wrong query: Traceback (most recent call last): File "/home/www-data/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/www-data/web2py/ap

Re: [web2py] Re: Callable as Field.default

Massimo, good news to me. It shoud be in the book! On Fri, Jan 28, 2011 at 12:32 PM, Massimo Di Pierro wrote: > The fact is, you can do both. If you want the values to be evaluated > on insert, just do > > Field(...,default=lambda: f()) > > instead of > > Field(...,default=f()) > > If you want

[web2py] create table as select.

Is it possible to join to tables and create a new table based on this join using only DAL? CREATE TABLE newtable AS SELECT ta.key, ta.col1, tb.col2 FROM ta JOIN tb.col1 on (ta.key=tb.key)

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

I disagree! Your playing with things that shouldn't be played with. Not to mention that now you have just broken some of my apps that perform case-sensitive queries in postgres this is just plain wrong in so many ways. Add a new identifier to DAL... give me db(db.table.name.like('%printer%')

Re: [web2py] Re: How to do a count distinct with DAL?

Can we not add per-dialect identifiers to DAL... I can see adding this just for postgres & ms sql. -- Thadeus On Fri, Jan 28, 2011 at 8:43 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This is not supported because I am not sure all supported RDBS support > count(distinct ...).

Re: [web2py] Re: Change in URL args handling

On Jan 28, 2011, at 6:05 AM, DenesL wrote: > > On Jan 27, 5:58 pm, Jonathan Lundell wrote: >> On Jan 27, 2011, at 12:48 PM, DenesL wrote: >> >> Still, it bothers me that arg1 == arg1/ != arg1//; > (optional) trailing slash> seems like an odd rule. >> >> Notice also that '/'.join(['arg1', '']) i

Re: [web2py] Re: Speeding up IS_IN_DB

On 28 January 2011 16:45, Massimo Di Pierro wrote: > This: > > requires = IS_IN_DB(db, db.joernaal.id, '%(titel)s') > > indicates you want to a select/options dropbox and it takes time to > populate it. > > Use instead: > > requires = [IS_IN_DB(db, db.joernaal.id,'%(titel)s')] > > so no dropbox an

Re: [web2py] Re: Change in URL args handling

On Jan 28, 2011, at 4:40 AM, marius.v.niekerk wrote: > > I had another problem with url argument handling that came in was > > "/app/controller/function/arg1\r". > > The default regex matching ( regex_args.match(request.raw_args( )) for > the arguments would return false and then the application

Re: [web2py] Re: Speeding up IS_IN_DB

On 28 January 2011 15:48, DenesL wrote: > > According to your model you have two references: > 1) joernaal.id (with autocomplete) > 2) article.ouid (without) > There are also two other fields with list_references. There are about 137000 records in article and 8200 in joernaal. Regards Johann -

[web2py] Re: Change in URL args handling

Hi Jonathan Stripping out trailing slashes seems like it delivers cleaner, shorter args. If no one has asked for trailing slashes, why introduce a feature which has to be protected forever as backward-compatible? After all, if these extra args exist, we're going to have to iterate through them

[web2py] Re: How to do a count distinct with DAL?

> It seems to work in SQLite and MS-SQL though. Firebird seems OK too.

Re: [web2py] Re: Change in URL args handling

On Jan 28, 2011, at 8:30 AM, villas wrote: > > Stripping out trailing slashes seems like it delivers cleaner, shorter > args. If no one has asked for trailing slashes, why introduce a > feature which has to be protected forever as backward-compatible? > > After all, if these extra args exist,

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

I agree with Thadeus here that "like" should be what it means in each case. Changing the default meaning of "like" in each RDBMS will cause confusion. "ilike" can be a web2py thing, but "like" should be specific to each RDMS. On Jan 28, 9:46 am, Thadeus Burgess wrote: > I disagree! Your playi

[web2py] Re: Change in URL args handling

On Jan 28, 10:59 am, Jonathan Lundell wrote: > > It's no so obviously a bug. Agreed. > URL('f',args=['arg1','arg2']) is /app/ctl/f/arg1/arg2 or > /app/ctl/f/'arg1'/'arg2' (quotes added for clarity) > > so suppose arg2 is ''; the consistent transformation is: > > URL('f',args=['arg1','']) -> /

[web2py] Re: GAE belongs (how to map long list)

I did it myself. Thanks

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

What if like() had something like a 'case' argument, with three possible values: sensitive, insensitive, and rdbms_default (defaulting to rdbms_default)? We obviously need to maintain backward compatibility, but like() is a web2py operator, not a specific RDBMS operator, so it would be nice if

Re: [web2py] Re: Change in URL args handling

On Jan 28, 2011, at 9:21 AM, DenesL wrote: > > > > On Jan 28, 10:59 am, Jonathan Lundell wrote: >> >> It's not so obviously a bug. > > Agreed. > >> URL('f',args=['arg1','arg2']) is /app/ctl/f/arg1/arg2 or >> /app/ctl/f/'arg1'/'arg2' (quotes added for clarity) >> >> so suppose arg2 is ''; t

[web2py] Re: Speeding up IS_IN_DB

Something else is wrong. If you have requires=[...] it should not query the db for the possible references and it should not make the dropdown. Can we see the entire model? Massimo On Jan 28, 10:01 am, Johann Spies wrote: > On 28 January 2011 16:45, Massimo Di Pierro wrote: > > > This: > > > re

[web2py] Re: How to do a count distinct with DAL?

OK. 3 is enough. Please add a google code issue and I will add it asap. Meanwhile if you want to try build a patch, it would be a new exercise in understainding the new dal. search for "def count" in the file. On Jan 28, 10:41 am, villas wrote: > > It seems to work in SQLite and MS-SQL though. >

[web2py] Re: GAE belongs (how to map long list)

It is supported by DAL. It maps into OR on GAE. Is it not? On Jan 27, 3:29 pm, "Arun K.Rajeevan" wrote: > Hi, > > I know belongs is not supported on GAE > > Fromhttp://www.web2py.com/AlterEgo/default/show/248 > > *it's clear that we have to convert

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

We need two steps: 1) make it behave the same (which means case insensitive, ilike on postgresql, now in trunk) 2) yes we can add a case_sensitive arg that defaults to True (not done yet but I would take a patch). On Jan 28, 11:37 am, Anthony wrote: > What if like() had something like a 'case' a

[web2py] Re: Speeding up IS_IN_DB

list:reference fields get an IS_IN_DB validator if no explicit requires is defined. Note: the assigned requires is not a list. On Jan 28, 12:54 pm, Massimo Di Pierro wrote: > Something else is wrong. If you have requires=[...] it should not > query the db for the possible references and it shou

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

I suppose 'ilike' in PostgreSQL is similar to 'containing' in Firebird (except you don't use wildcards in FB). On Jan 28, 5:58 pm, Massimo Di Pierro wrote: > We need two steps: > > 1) make it behave the same (which means case insensitive, ilike on > postgresql, now in trunk) > 2) yes we can add

[web2py] Re: create table as select.

It can be done, but why do you want to do it?. On Jan 28, 10:42 am, vortex wrote: > Is it possible to join to tables and create a new table based on this > join using only DAL? > > CREATE TABLE newtable AS SELECT  ta.key, ta.col1, tb.col2  FROM ta > JOIN tb.col1 on (ta.key=tb.key)

[web2py] Bugfix for full CRUD internal read links

The book's example for "full CRUD" def data(): return (form=crud()) doesn't set the proper links from .../data/select/ to .../data/read// they instead go to .../read// This patch fixes the issue: --- a/gluon/tools.pyFri Jan 28 09:54:47 2011 -0600 +++ b/gluon/tools.pyFri Jan 2

Re: [web2py] Re: Change in URL args handling

> Kenneth: how did you happen to notice this? How did the extra trailing slash get there in the first place? I was testing an application and was using http://domain/controller/applications/2 when I decided to start from the begining with http://domain/controller/applications but I only remove

[web2py] Re: Change in URL args handling

> The downside is that we lose the capability to have trailing args that are > empty strings. Hi Jonathan, My point is that it's only a *downside* for those that want 'trailing args that are empty strings'. Who is it that wants them?? If we explicitly want to indicate empty args we can insert som

Re: [web2py] Re: Change in URL args handling

"If no one has asked for trailing slashes, why introduce a feature which has to be protected forever as backward-compatible?" Except that stripping out the trailing slash is itself a non-backwards compatible change. It may be OK, but let's be clear. I don't think the browser adds the trailing

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

On Friday, January 28, 2011 12:58:30 PM UTC-5, Massimo Di Pierro wrote: > > We need two steps: > > 1) make it behave the same (which means case insensitive, ilike on > postgresql, now in trunk) Doesn't this change break backward compatibility, or are you treating this as a bug fix? > 2)

Re: [web2py] Re: Change in URL args handling

On Jan 28, 2011, at 10:40 AM, villas wrote: > >> The downside is that we lose the capability to have trailing args that are >> empty strings. > > Hi Jonathan, > My point is that it's only a *downside* for those that want 'trailing > args that are empty strings'. > Who is it that wants them?? We

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

I have a table with empty list:reference fields and db admin does not have a problem with it. Running 1.91.6 . On Jan 28, 10:12 am, LightOfMooN wrote: > It's a problem, that if i have empty list:reference, the standard > database administration don't work because of wrong query: > > Traceback (

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

Hi, I'm running web2py 1.91.6 on google app engine. I'd like to delete everything in the datastore and start over. If you have a quick solution for this, stop reading now and just tell me the "web2py" way. :) There is a StackOverflow thread that I found: http://stackoverflow.com/questions/10625

Re: [web2py] Re: TypeError: is not JSON serializable

Hi massimo, do you know something more about this? 2011/1/26 web2py noob : > Hi Massimo, > > I send you my code attached to this email. > Very thank you for your time. > > On 26 ene, 16:40, Massimo Di Pierro wrote: >> Can you please email me your app? >> >> On Jan 26, 10:05 am, web2py noob wrote

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

Run your web2py app with a command from your GAE library and the flag - c. i.e: dev_appserver.py -c C:\web2py On Jan 28, 9:31 pm, Nathan VanHoudnos wrote: > Hi, > > I'm running web2py 1.91.6 on google app engine. I'd like to delete > everything in the datastore and start over. > > If you have a q

[web2py] query in DAL

Hey guys: Is there a way to do this query in DAL? SELECT date, count(foo.items) FROM ( SELECT logs.date, logs.items FROM logs WHERE extract(year from logs.date) = 2010) GROUP BY date, items ) AS foo, stock WHERE stock.items = foo.items GROUP by date Any he

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

Thanks for the reply. To clarify, I want to wipe everything in the production datastore on Google's servers. If it were only as easy as clearing the development datastore! Cheers, Nathan On Fri, Jan 28, 2011 at 3:10 PM, devGS wrote: > Run your web2py app with a command from your GAE library a

[web2py] Disabling the error page in production.

How do I disable the error page in production? I would ideally like to replace it with a Nicer page same for 404 errors; I searched the book for error page; but I must have missed the part where it says disabling. Thanks.

[web2py] Pydra: new Python hosting option

Still testing but looks interesting: http://www.pydra.com/

[web2py] Re: Pydra: new Python hosting option

There's also http://www.ep.io/, also still in beta. On Friday, January 28, 2011 4:03:13 PM UTC-5, pbreit wrote: > Still testing but looks interesting: > http://www.pydra.com/ >

[web2py] Re: Use the source, Luca

Interesting related discussion: https://groups.google.com/forum/?fromgroups#!topic/comp.lang.python/Dq11ce39xtc

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

Hi all, I am gonna design and develop a social app via Web2py. Before I am getting my hands dirty, I wonder is there an alternative to Django's Pinax in the world of Web2py?

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

PInax looks really cool and helpful. I'm not aware of anything besides plugins and appliances.

Re: [web2py] Disabling the error page in production.

http://web2py.com/book/default/chapter/04#Routes-on-Error 2011/1/28 David J. > How do I disable the error page in production? > > I would ideally like to replace it with a Nicer page same for 404 errors; > > I searched the book for error page; but I must have missed the part where > it says dis

[web2py] Important Pycon 2011

The web2py Python tutorial has 8 registered participants. That is not god enough. There is still a possibility it may be cancelled. I am told web2py is easy and perhaps people do not need a tutorial but I promise I will do my best to cover things you probably do not know and make it worthwhile. S

[web2py] Re: Important Pycon 2011

Sorry I can't go to Pycon 2011. But I would be appreciated if you can post an article about the experience on your blog. Thanks, Bill

[web2py] Re: The web of connected p2p web2py apps ? (or a new kind of social network)

I don't know why people are constantly talking about the NOSQL hype. why bother them? Sqlite is included in web2py. I would rather to see a user admin which is better than django's. -Bill

[web2py] Re: Important Pycon 2011

Hi, same goes for the developers at my company - we will not be able to attend Pycon 2011. Would definitely appreciate an article on your experiences though. On Jan 28, 4:28 pm, William wrote: > Sorry I can't go to Pycon 2011. But I would be appreciated if you can post > an article about the expe

[web2py] Learning materials for newbie

Hello, I'm totally new to programming, but very motivated to learn it. I'm especially interested in creating web application (that's why I post here). So, can anyone tell me what do I have to learn (except Python and web2py of course) and point me some good learning materials and resources (books,

Re: [web2py] Learning materials for newbie

Web2py book : http://www.web2py.com/book Richard On Fri, Jan 28, 2011 at 4:38 PM, noob.py wrote: > Hello, > I'm totally new to programming, but very motivated to learn it. I'm > especially interested in creating web application (that's why I post > here). So, can anyone tell me what do I have t

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

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 1 rolic with empty tags, and "database administration -> db.rolic" goes to error: Pro

[web2py] 2 quickies about cache

I'm trying to determine whether the built-in web2py cache will fulfill my needs or not and thus need a clarification on the following... Based on this completely artificial example to illustrate my questions: someModule.py: def ICacheLogs(cache, X): return db(db.log.id==X).select(db.log.ALL,

[web2py] Re: Can any help me with new dal in trunk?

Hi, I updated my trunk version However, The same issue is still This is the new traceback Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/iscada/models/cfedb.py", l

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

On Jan 28, 4: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 1 rolic with empty tags,

[web2py] Re: Can any help me with new dal in trunk?

Are you sure it worked before? As far as I know mysql is not supported for legacy DBs using primarykey. On Jan 28, 5:04 pm, drayco wrote: > Hi, I updated my trunk version > > However, The same issue is still > > This is the new traceback > > Traceback (most recent call last): >   File "/home/dr

Re: [web2py] query in DAL

you always can execute sql sql_str = 'SELECT * FROM ...' rows = db.executesql(sql_str) but your results will not be objects, but an array of arrays or an array of dicts if you do sql_str = '''SELECT date, count(foo.items) as total ... ' rows = db.executesql(sql_str, as_dict = True) for row in

Re: [web2py] Re: The web of connected p2p web2py apps ? (or a new kind of social network)

Please, Sqlite is not NOSQL, but a small, portable rdbms 2011/1/28 William > I don't know why people are constantly talking about the NOSQL hype. > why bother them? > Sqlite is included in web2py. > > I would rather to see a user admin which is better than django's. > > -Bill > -- Atenci

[web2py] Re: Disabling the error page in production.

You can use routes.py in the root of your web2py tree to reroute 404 and/or 400 errors to a more friendly page, see http://web2py.com/book/default/chapter/04#Routes-on-Error Nico On 28 jan, 21:00, "David J." wrote: > How do I disable the error page in production? > > I would ideally like to repl

Re: [web2py] Learning materials for newbie

> > Web2py book : http://www.web2py.com/book + http://w3schools.com/

[web2py] Re: GAE belongs (how to map long list)

I use belong on GAE quite frequently these days. Arun - you found an outdated post. :( christian

[web2py] Re: Learning materials for newbie

On Friday, January 28, 2011 4:38:39 PM UTC-5, noob.py wrote: > > Hello, > I'm totally new to programming, but very motivated to learn it. I'm > especially interested in creating web application (that's why I post > here). So, can anyone tell me what do I have to learn (except Python > and web2

[web2py] Re: Speeding up IS_IN_DB

Are you suggesting we change the way the default is assigned? If so.. let's duscuss this inw eb2py-developers because it is a complex matter. Massimo On Jan 28, 12:16 pm, DenesL wrote: > list:reference fields get an IS_IN_DB validator if no explicit > requires is defined. > Note: the assigned re

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

Did you try to do it through the dashboard? At Data, Datastore Admin you have the option to select all of the entities and delete them. On Jan 28, 10:56 pm, Nathan VanHoudnos wrote: > Thanks for the reply. > > To clarify, I want to wipe everything in the production datastore on > Google's servers

Re: [web2py] Speeding up IS_IN_DB

in places where i wanted to keep the dropdown, but not the overhead of creating a huge list, i filtered the list. I was lucky enough that not all of the options were valid in all tables, and so i modified my IS_IN_DB() calls to return a much smaller filtered set of data. not sure if this will

[web2py] Re: Bugfix for full CRUD internal read links

oops. Thanks On Jan 28, 12:33 pm, Bernd Rothert wrote: > The book's example for "full CRUD" > > def data(): return (form=crud()) > > doesn't set the proper links from > > .../data/select/         to > .../data/read// > > they instead go to > .../read// > > This patch fixes the issue: > > --- a/gl

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

ILIKE is not the same as containing. It is a case insensitive LIKE On Jan 28, 12:23 pm, villas wrote: > I suppose 'ilike' in PostgreSQL is similar to 'containing' in Firebird > (except you don't use wildcards in FB). > > On Jan 28, 5:58 pm, Massimo Di Pierro > wrote: > > > > > > > > > We need tw

Re: [web2py] Learning materials for newbie

Hi, To learn Python I found these very helpful (no particular order): - Hetland's stuff is concise and clear which is not always the case :-) - http://hetland.org/writing/instant-hacking.html - http://hetland.org/writing/instant-python.html - Alan Gaud's on-line is also very cle

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

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: > > > We need two steps: > > > 1) make it behave the same (which means case insensitive, ilike on > > postgresql, now in trunk) > > Doesn't this change break ba

  1   2   >