[web2py] ordering the table reverse

The docs mention it , but looks like there is some typo.. it is said that a tilde has to be used but the example does not show it:- This is what is in the docs:- >>> for row in db().select(db.person.ALL, orderby=db.person.name): print row.name But this would not reverse the table . Can so

Re: [web2py] Re: Routes.py on GAE

Hi I guess this bug has not been fixed yet? I am getting the following error: unable to import Rocket Your routes.py has a syntax error Please fix it before you restart web2py Traceback (most recent call last): File "/base/data/home/apps/reviewround/1.344628390884008259/gluon/rewrite.py", line

Re: [web2py] xmlrpc does not work on GAE (while it works fine on dev local gae server) ??

Found the problem! my url was simply wrong. :( In the call bellow: RPCServer = ServerProxy('http://myapp.appspot.com/welcome/default/ index/call/xmlrpc ') the "welcome" should be "myapp" (and no "index" is needed). So the proper url is

[web2py] xmlrpc does not work on GAE (while it works fine on dev local gae server) ??

Hi I have a function exposed as a xmlrpc service. It works perfectly in the dev gae local server but once I deployed my application to the live servers I get the following error when I try to call it: RPCServer.AddProducts("apps",data) Traceback (most recent call last): File "C:\chilkat\crawl.

[web2py] Re: COM thread problem: CoInitialize wasn't called

On Sep 6, 9:58 pm, weheh wrote: > I'm getting the following error message from the code that used to > work a few weeks ago and haven't changed: > >   File "C:\Program Files\Python25\Lib\site-packages\win32com\client > \dynamic.py", line 84, in _GetGoodDispatch >     IDispatch = pythoncom.CoCrea

[web2py] COM thread problem ???

I'm getting the following error message from the code that used to work a few weeks ago and haven't changed: File "C:\Program Files\Python25\Lib\site-packages\win32com\client \dynamic.py", line 84, in _GetGoodDispatch IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.

[web2py] Re: pyStack - Stack Overflow "clone" update

Indeed, and happy to do it. On Sep 6, 6:20 pm, mdipierro wrote: > Will you make it open source? > > On Sep 6, 7:58 pm, Julio Schwarzbeck wrote: > > > Interesting Question :) - Well, since I am using both MySQL and > > Postgres, I have implemented Full-text searching for both paradigms, > > this

[web2py] Re: pyStack - Stack Overflow "clone" update

Will you make it open source? On Sep 6, 7:58 pm, Julio Schwarzbeck wrote: > Interesting Question :) - Well, since I am using both MySQL and > Postgres, I have implemented Full-text searching for both paradigms, > this is really more in the database side and it really relies on the > indexing of t

[web2py] Re: pyStack - Stack Overflow "clone" update

Interesting Question :) - Well, since I am using both MySQL and Postgres, I have implemented Full-text searching for both paradigms, this is really more in the database side and it really relies on the indexing of the available data. This can indeed be an issue with non- RDBS and the fact that my e

[web2py] Re: Crash in the appadmin db page when trying to view one of my tables

It is not that stupid. In fact it happens to me every day and am thinking if there is a better way to deal with this exception. On Sep 6, 6:55 pm, Miguel Goncalves wrote: > Thanks for your comment ! that made me look into the fields that are > references and quickly found what was wrong. > > In m

[web2py] Re: Is code interpreted at every call in Web2Py ?

no problem. free publicity. ;-) On Sep 6, 7:02 pm, Stanley peter wrote: > Thanks massimo, > Sorry for duplicate on SO. > > On Sep 6, 9:11 pm, mdipierro wrote: > > > In the admin interface you can click "compile" and web2py will run > > from the "pyc". > > > On Sep 6, 8:03 am, Stanley peter wrot

[web2py] Re: I found a bug... [solved]

Sorry for the false alarm. I fixed it in trunk. It was easier then I though but the problem was in sqlhtml not in tools. On Sep 6, 6:37 pm, mdipierro wrote: > ... I cannot fix it until tomorrow. Let's see if you can fix it first! > > 1) create a custom auth_user table with a Field('image','upload

[web2py] Re: Is code interpreted at every call in Web2Py ?

Thanks massimo, Sorry for duplicate on SO. On Sep 6, 9:11 pm, mdipierro wrote: > In the admin interface you can click "compile" and web2py will run > from the "pyc". > > On Sep 6, 8:03 am, Stanley peter wrote: > > > > > If so, is it possible to make web2py run directly from bytecode > > skipping

Re: [web2py] Re: Crash in the appadmin db page when trying to view one of my tables

Thanks for your comment ! that made me look into the fields that are references and quickly found what was wrong. In my insert, I harcoded the categoryID to 63which does not exist anymore in my category table. Stupid mistake. Sorry. Thanks again; -Miguel

[web2py] Re: Crash in the appadmin db page when trying to view one of my tables

somewhere you have a recursive select like row.fieldrefencingtable.fieldofreferencestable but the value of row.fieldrefencingtable points to a record that does not exist. On Sep 6, 6:38 pm, Miguel wrote: > Hi > > On web2py, version 1.83.2 (2010-08-15 08:16:30) , I have the following > table: >

[web2py] Re: pyStack - Stack Overflow "clone" update

really nice. Can you tell us how you implement search? On Sep 6, 5:40 pm, Julio Schwarzbeck wrote: > Pleased to inform the community that I finally had some time to > heavily work on one of my web2py pets, pyStack is coming along quite > nicely and it is being developed as we speak, pyStack is a

[web2py] Crash in the appadmin db page when trying to view one of my tables

Hi On web2py, version 1.83.2 (2010-08-15 08:16:30) , I have the following table: db.define_table("products", Field("categoryID", db.productCategory, writable=False, readable=False, requires=IS_IN_DB(db, "productCategory.id", "productCategory.name") ), # reference field Field("RRRating", '

[web2py] I found a bug...

... I cannot fix it until tomorrow. Let's see if you can fix it first! 1) create a custom auth_user table with a Field('image','upload') 2) register login and upload and image in profile 3) print the content of auth.user.image 4) edit profile again and submit without changing any fields 5) print t

[web2py] tip of the day: color personalizations

If you have the default layout and want to allows users (auth_users) to personalize their colors here is how: in model before aith.define_tables() insert COLOR_SCHEMES={ 'black':('black','white','#999',URL('static','images/ background.png')), 'red':('white','#333','#f00',URL('static','ima

[web2py] Re: pyStack - Stack Overflow "clone" update

It is Open Source indeed, you'll be able to change it to suit your needs, 95% of the information in it is localized (i.e. {{=XML(T('Message in English'))}} ) so all you'll need to do is create a custom dictionary for it. I don't see why it wouldn't work on the GAE, I personally do not have too muc

[web2py] Re: pyStack - Stack Overflow "clone" update

Looking good! On Sep 6, 5:40 pm, Julio Schwarzbeck wrote: > Pleased to inform the community that I finally had some time to > heavily work on one of my web2py pets, pyStack is coming along quite > nicely and it is being developed as we speak, pyStack is a SO > "inspired" system developed in the b

Re: [web2py] pyStack - Stack Overflow "clone" update

Works on GAE? thats open source? I wish to provide something like that for Brazilian/portuguese community in web2pybrasil.com.br 2010/9/6 Julio Schwarzbeck > Pleased to inform the community that I finally had some time to > heavily work on one of my web2py pets, pyStack is coming along quite >

[web2py] pyStack - Stack Overflow "clone" update

Pleased to inform the community that I finally had some time to heavily work on one of my web2py pets, pyStack is coming along quite nicely and it is being developed as we speak, pyStack is a SO "inspired" system developed in the best web framework available for Python nowadays :) pyStack aims to

[web2py] Re: After Ruby on Rails: DOS on Dope

April Fools? What a geek sutff! It made me remember this http://www.cmstxt.com/how A CMS with only 6kb made of txt files. Quite geek but quite interesting. It´s simplicity makes me think of using it integrated with another tool. But I don´t know what. On Sep 6, 1:20 pm, weheh wrote: > LOL, ouch

[web2py] db issue when accessing db from more than one place

Hey, have following issue. model: db.define_table('syslogs', Field('datetime', 'datetime', label='date&time'), Field('incident', 'string', label='incident')) controller: from applications.myapp.modules.LOG import log @auth.requires_login() def index(): log("log controler", "test message

[web2py] Re: web2py lightning talk on Qcon

Well, since both you you and Massimo pointed me to the plugin_wiki video, which I watched this morning (i was absolutely amazed by the plug-in and its obvious potential), I would vote that you spend some time on that and its unique qualities :) On Sep 6, 12:21 pm, Bruno Rocha wrote: > I'll give a

[web2py] Re: web2py lightning talk on Qcon

15 slides in 5 minutes is too much. Typical budget is 1 slide per minute. Can web2py be boiled down to a 5 slide presentation? Challenging ... On Sep 6, 12:21 pm, Bruno Rocha wrote: > I'll give a lightning talk about web2py on QCon 2010 > (http://www.qconsp.com/-http://www.infoq.com/br) > > will

Re: [web2py] Re: Web2py on google app engine (show INVALID REQUEST)

You can just go to app.yaml and under the skip files section, delete this line :- (applications/(admin|examples)/.*)| or comment it out. If you are trying out the Google SDK on localhost , you will be able to see admin section and examples section , which you were not able to see till now and after

[web2py] Re: Web2py Full Text Search Options

You can also do: def keywords(record): return list(set(x.lower() for re.compile('\w +').findall(record.content or ''))) db.define_table('posts', Field('id', 'id'), Field('content', 'text'), Field('keywords', 'list:string',compute=keywords

[web2py] web2py lightning talk on Qcon

I'll give a lightning talk about web2py on QCon 2010 ( http://www.qconsp.com/ - http://www.infoq.com/br ) will be 15 slides in 5 minutes, any idea or suggestion are welcome.

[web2py] Re: After Ruby on Rails: DOS on Dope

LOL, ouch! It hurts to even think about it.

Re: [web2py] What is polymodel?

On Sep 6, 2010, at 9:10 AM, Jose wrote: > > What is polymodel? http://code.google.com/appengine/articles/polymodel.html > Do you use? > How is it used?

[web2py] Re: What is polymodel?

http://code.google.com/appengine/docs/python/datastore/polymodelclass.html http://groups.google.com/group/web2py/browse_thread/thread/3ac3543cbf48c07e# On Sep 6, 11:10 am, Jose wrote: > in the log (of mercury) see: > > changeset:   844:c32ab678e14a > user:        mdipie...@massimo-di-pierros-macb

[web2py] What is polymodel?

in the log (of mercury) see: changeset: 844:c32ab678e14a user:mdipie...@massimo-di-pierros-macbook.local date:Sat Sep 04 09:31:17 2010 -0500 summary: polymodel support What is polymodel? Do you use? How is it used? Regards Jose

[web2py] Re: User comments in doc

Yes. On Sep 6, 11:49 am, mdipierro wrote: > you mean inhttp://web2py.com/book? > > On Sep 6, 10:26 am, weheh wrote: > > > Could you change the comment input line so that it's a textarea > > instead of an input field?

[web2py] Re: How to import ...

web2py Version 1.83.2 (2010-08-15 08:16:30) I think it's the binary version. How can I tell? On Sep 6, 11:48 am, mdipierro wrote: > which web2py version? source or binary? > > On Sep 6, 10:28 am, weheh wrote: > > > I already tried that and got the same ticket: NameError: global name > > 're' is

[web2py] uploadfolder needs to be added to the book general index

I added some doc on uploadfolder to the DAL section (hope it's OK). But needs a link to the general index for completeness sake. I can't edit that page, so am making a note of it here.

[web2py] Re: list:int problems when import/export (esp GAE)

Thanks, I'll probably test it only tomorrow, I just realised, that my list:int is (should be) list:reference Will w2p handle references when importing as well? -- anyway, I will test :) On Sep 6, 5:03 pm, mdipierro wrote: > I think I have fixed this in trunk, please give it a try. This is not >

[web2py] Re: User comments in doc

you mean in http://web2py.com/book? On Sep 6, 10:26 am, weheh wrote: > Could you change the comment input line so that it's a textarea > instead of an input field?

[web2py] Re: How to import ...

which web2py version? source or binary? On Sep 6, 10:28 am, weheh wrote: > I already tried that and got the same ticket: NameError: global name > 're' is not defined > > I also put import re in the controller that imports the serializer. No > joy. > > On Sep 6, 11:20 am, mdipierro wrote: > > > T

[web2py] Re: TAGs [Closed > see new thread]

Problem encountered. Thread continues here: http://groups.google.com/group/web2py/browse_thread/thread/f4127cbb452f488b?hl=en# On Sep 5, 10:16 pm, weheh wrote: > I'm in the process of copying markdown_serializer to modules and > modifying it to treat tags differently. I don't anticipate running >

[web2py] Re: TAGs [Closed > see new thread]

Ran into a problem, so this thread is continued here: http://groups.google.com/group/web2py/browse_thread/thread/f4127cbb452f488b?hl=en# On Sep 5, 10:16 pm, weheh wrote: > I'm in the process of copying markdown_serializer to modules and > modifying it to treat tags differently. I don't anticipate

Re: [web2py] Re: Web2py on google app engine (show INVALID REQUEST)

Ok, thanks so much Massimo. On Mon, Sep 6, 2010 at 12:24 PM, mdipierro wrote: > By default admin/examples and welcome are not deployed on gae to save > space. You can change this by editing app.yaml > > On Sep 6, 9:49 am, leo kirotawa wrote: > > Thanks Massimo, > > But, Why the app example oes

[web2py] Re: How to import ...

I already tried that and got the same ticket: NameError: global name 're' is not defined I also put import re in the controller that imports the serializer. No joy. On Sep 6, 11:20 am, mdipierro wrote: > This is a python thing. Not sure why it works the way it does. Put > import re outside the f

[web2py] User comments in doc

Could you change the comment input line so that it's a textarea instead of an input field?

[web2py] Re: Web2py on google app engine (show INVALID REQUEST)

By default admin/examples and welcome are not deployed on gae to save space. You can change this by editing app.yaml On Sep 6, 9:49 am, leo kirotawa wrote: > Thanks Massimo, > But, Why the app  example oes not work either? It'll be  for the same > reason? > > > > On Mon, Sep 6, 2010 at 10:14 AM,

[web2py] Re: How to import ...

This is a python thing. Not sure why it works the way it does. Put import re outside the function and it will work. On Sep 6, 10:17 am, weheh wrote: > I've written my own serializer, which I've stored locally under > modules. > > I've imported the serializer in my controller with the statement >

[web2py] How to import ...

I've written my own serializer, which I've stored locally under modules. I've imported the serializer in my controller with the statement module=local_import('serializer') # note: the v3 doc does not include quotes around the name of the module So far, so good. However, the serializer uses reg

Re: [web2py] Re: weird behavior using LOAD

disregard previous post.. I got this controller to work perfectly when it is invoked by its url for a single item (one item per page) def comment(): print 'in comment controller with item_id = ', request.args(0) item_id=request.args(0) db.itemcomments.item_ref.default=item_id

Re: [web2py] Re: Web2py on google app engine (show INVALID REQUEST)

Thanks Massimo, But, Why the app example oes not work either? It'll be for the same reason? On Mon, Sep 6, 2010 at 10:14 AM, mdipierro wrote: > I am not sure anybody is maintaining that wiki any longer. Here is the > most updated information about running on GAE > > http://web2py.com/book/de

[web2py] Re: Deploying web2py on linux (Redhat or others) on cpanel or other ways

I think cpanel is still tied to Python 2.4 so this may be more useful: http://groups.google.com/group/web2py/browse_frm/thread/2b7800cfa079ad5f/3c36aab506dae496?#3c36aab506dae496 On Sep 6, 9:39 am, "mr.freeze" wrote: > This may help:http://www.web2pyslices.com/main/slices/take_slice/76 > > On Se

[web2py] Re: Deploying web2py on linux (Redhat or others) on cpanel or other ways

This may help: http://www.web2pyslices.com/main/slices/take_slice/76 On Sep 6, 7:31 am, Rahul wrote: > Thanks All, this is all fine. I've read the book but I am not a pro on > deployment so I cant say what impact it would have on existing servers > that are being served by the web service provid

[web2py] Re: list:int problems when import/export (esp GAE)

I think I have fixed this in trunk, please give it a try. This is not backward compatible because export/import of list: types was not previously supported. On Sep 6, 4:38 am, Jurgis Pralgauskis wrote: > hello, > > I am strugling with list:integer export/import > > after export->reimport I get >

[web2py] web2py freelance job with Sahana Eden

Job Description To implement Sahana Eden Authorization functionality according to the specs athttp://eden.sahanafoundation.org/wiki/TaiwanAuthorisation Sahana Eden uses S3 framework buil

Re: [web2py] Re: weird behavior using LOAD

I tried it both ways, but neither worked. Here is the current controller. Am I naming and referencing the formname correctly? def comment(): print 'in comment controller with item_id = ', request.args(0) item_id=request.args(0) db.itemcomments.item_ref.default=item_id db.itemcom

[web2py] Re: Web2py Full Text Search Options

On Sep 6, 9:34 am, Anthony wrote: > Massimo recently posted this link for GAE full text > search:http://www.billkatz.com/2009/6/Simple-Full-Text-Search-for-App-Engine Actually, I _saw_ it recently -- it was posted 10 months ago.

[web2py] Re: Web2py Full Text Search Options

Massimo recently posted this link for GAE full text search: http://www.billkatz.com/2009/6/Simple-Full-Text-Search-for-App-Engine On Sep 6, 6:55 am, "Martin.Mulone" wrote: > DONT PAY ATTENTION TO THE EARLY POST WAS MISTAKEN SUBMMITED > > This is not a proper full text but i want to make a better

[web2py] After Ruby on Rails: Dos on Dopes

http://www.secretgeek.net/dod_intro.asp

[web2py] Re: Web2py on google app engine (show INVALID REQUEST)

I am not sure anybody is maintaining that wiki any longer. Here is the most updated information about running on GAE http://web2py.com/book/default/chapter/11#Google-App-Engine there are other good tutorials online. admin - by default - is not deployed on GAE because it does not work (since GAE

[web2py] Re: Is code interpreted at every call in Web2Py ?

In the admin interface you can click "compile" and web2py will run from the "pyc". On Sep 6, 8:03 am, Stanley peter wrote: > If so, is it possible to make web2py run directly from bytecode > skipping interpreting stage (Caching) (except for the first request) ? > Thanks in advance.

[web2py] Is code interpreted at every call in Web2Py ?

If so, is it possible to make web2py run directly from bytecode skipping interpreting stage (Caching) (except for the first request) ? Thanks in advance.

[web2py] Web2py on google app engine (show INVALID REQUEST)

Hi, I was testing web2py on google app engine, follow the first steps in this site [1], but I did not sucess. My web2py, same in localhost show the message: Invalid Request when I try the link admin and that other: web2py/applications/welcome/controllers/default.py. Somebody have any ideia how

[web2py] Re: weird behavior using LOAD

replace: if form.accepts(request.vars, session): with if form.accepts(request.vars): or if form.accepts(request.vars, session, formname='xxx%s' % item_id): else all forms have the same name and the mechanism to prevent CSRF gets confused on which form is which. On Sep 6, 7:20 am, "david.wa

[web2py] Re: list:int problems when import/export (esp GAE)

This is a bug. Please open a ticket in google code and I will try fix it today. Massimo On Sep 6, 4:38 am, Jurgis Pralgauskis wrote: > hello, > > I am strugling with list:integer export/import > > after export->reimport I get > web2py list:int ValueError: > invalid literal for int() with base

[web2py] Re: Deploying web2py on linux (Redhat or others) on cpanel or other ways

Thanks All, this is all fine. I've read the book but I am not a pro on deployment so I cant say what impact it would have on existing servers that are being served by the web service provider -if any. Although, I'll try it out with him again. Questions of Deployment using CPANEL - 1- Anyone can he

[web2py] weird behavior using LOAD

I am using the LOAD command to invoke a custom comment module in a view like this: {{=LOAD('comments','comment',args=(r.id), ajax=True)}}{{pass}} The LOAD statement is called for each row displayed on the view . Note there are multiple rows. The controller is very straight forward and looks lik

[web2py] weird behavior using LOAD

I am using the LOAD command to invoke a custom comment module in a view like this: {{=LOAD('comments','comment',args=(r.id), ajax=True)}}{{pass}} The LOAD statement is called for each row displayed on the view . Note there are multiple rows. The controller is very straight forward and looks lik

Re: [web2py] Re: Scaffolding app with Twitter OAuth1.0a auth

Better than with easy_install :) Almost, wsgihandler.py is reading site-packages folder. I created site-packages folder, put httplib2 and oauth2 there, restart apache2 and now it's working. Thanks Michelle! On Mon, Sep 6, 2010 at 1:09 PM, Michele Comitini wrote: > you can try installing under

[web2py] Re: Install pyodbc in standalone web2py

That's great news. Thank you. I don't suppose there is a workaround that works now? Jon On 3 Sep, 17:40, mdipierro wrote: > We are considering making pyodbc part of the standard distribution. It > is going to take a little way since the process of building binary > distribution and is a little

Re: [web2py] Re: Scaffolding app with Twitter OAuth1.0a auth

you can try installing under site-packages in the root dir of web2py. I do that for running the app on GAE and it works :-) mic 2010/9/6 Albert Abril : > Hi Michelle. > Yes, As you said, I defined it in the db.py. > Now, I'm having an error importing oauth2. > I installed python-oauth2 in webfac

[web2py] Re: Web2py Full Text Search Options

DONT PAY ATTENTION TO THE EARLY POST WAS MISTAKEN SUBMMITED This is not a proper full text but i want to make a better search cause in gae don't have like operator, so i use new introduce list:string that is supported in both gae and sqlite. So in the search I use contains in that field, but at th

Re: [web2py] Re: Scaffolding app with Twitter OAuth1.0a auth

Hi Michelle. Yes, As you said, I defined it in the db.py. Now, I'm having an error importing oauth2. I installed python-oauth2 in webfaction with 'easy_install'. But it seems like it can't import. I'll check the env. On Mon, Sep 6, 2010 at 12:47 PM, Michele Comitini < michele.comit...@gmail.com>

Re: [web2py] Re: Scaffolding app with Twitter OAuth1.0a auth

Hi Yannik, sorry for late answering... just go on http://developer.twitter.com and register an application. After that you get the CLIENT_ID and CLIENT_SECRET, TOKEN_URL and ACCESS_TOKEN_URL from twitter. define those variables in a file called twitter_oauth_data.py in modules dir under your appl

[web2py] Re: Web2py Full Text Search Options

This is not a proper full text but i want to make a better search cause in gae don't have like operator, so i use new introduce list:string that is supported in both gae and sqlite. So in the search I use contains in that field, but at the moment there are a bug in web2py http://code.google.com/p/w

Re: [web2py] Scaffolding app with Twitter OAuth1.0a auth

Hi Albert, does it work now? sorry for my late answer... yes create a file or define those variables in your db.py 2010/9/3 Albert Abril > Ok, I guess it's a file created by me defining twitter config: CLIENT_ID > CLIENT_SECRET > AUTH_URL > TOKEN_URL > ACCESS_TOKEN_URL > On Fri, Sep 3, 2

[web2py] list:int problems when import/export (esp GAE)

hello, I am strugling with list:integer export/import after export->reimport I get web2py list:int ValueError: invalid literal for int() with base 10: '[1, 13, 14]' I use it in my computed field, which returns a list I tried "|%s|" % '|'.join( map(str, the_list) ) but it exports stuff neverthel

Re: [web2py] Re: Permissions on records

On 29 August 2010 07:05, mdipierro wrote: > almost: > > def give_create_permission(form,table): >        group_id = auth.id_group('user_%s' % auth.user.id) >        auth.add_permission(group_id, 'read', table) > > and > > auth.settings.register_onaccept = (lambda form, > table=table:give_create_pe