[web2py] Re: Apache, Wsgi problem

Thanks, I just investigated this, but it looks like it did not fix the problem. In 8.4.6 Postgres changed the default "wal_sync_method" to "fdatasync," because the old default "open_datasync" failed on ext4. I use ext3 (on ubuntu 9.10), but I tried changing this option in my postgres database

[web2py] Re: Apache, Wsgi problem

I don't know if it is worth mentioning but as a Ubuntu 10.04.1 user, I noticed the 8.4.6 update to PostgreSQL was pushed by Ubuntu near the end of December. http://www.postgresql.org/docs/8.4/static/release-8-4-6.html first item of the release notes mention the database can fail on some file s

[web2py] Re: Apache, Wsgi problem

I'm still having this problem too (previous posts linked below). I would love to find a solution. I'm not sure how to debug. VP: Can you provide instructions for reproducing this bug using ab? I had trouble using ab in the past. I am also on a VPS. Since my last post (linked below), I have tr

Re: [web2py] jquery.tools.min.js

Which version of jquery.tools.min.js did you include, what I mean is what feature set? There is a possible inclusion of a date picker looking at all the options on their web page for downloads as you build your custom version of jquery.tools.min.js. They all produce the same file name as output

[web2py] Re: Help with cron

Ah, it's working! Sorry for false alarm.

[web2py] Re: Help with cron

Fixed this (no .py) but still not working: cron/crontab: #run every 2 minutes */2 * * * * root *cron/release_pending_items I've also tried: cron/crontab: #run every 2 minutes */2 * * * * root *applications/myapp/cron/release_pending_items.py Is there any way to determine if cron is functioning?

[web2py] Re: reference all fields of another table

Never mind the help notice. restructured the models to abundantly use (and possibly overuse) the "audit trail" model. The results are SWEET! any new request form that I would need to add, requires just a small table with its unique Fields. the rest of the data is provided by combining a few of thes

[web2py] Re: Keys and GAE

Sorry that should have been: a = db(db.A.id == ['A:1', 'B:2', 'C:3', ''D:4') Matt On Jan 11, 4:39 pm, Matt wrote: > Thanks Christian, > > Your suggestion looks good. > > Could potentially specify the "tablename" like: > > db(db.address.id == ['user:21', 'address:96']) > > NB: this would need t

[web2py] Re: Keys and GAE

Thanks Christian, Your suggestion looks good. Could potentially specify the "tablename" like: db(db.address.id == ['user:21', 'address:96']) NB: this would need to support full recurvsive key generation so that you could specify: Assuming: C.parent = D.id = 4

[web2py] Re: wrong documentation on ajax api sample?

Yes, you can't upgrade... and the documentation is broken as per the first post. On Jan 10, 9:07 pm, Massimo Di Pierro wrote: > No because the ajax part (web2py_ajax.html) stays with the app.It is > not affected by upgrades unless you want to. > > On Jan 10, 5:17 pm, DenesL wrote: > > > Does t

Re: [web2py] Re: Keys and GAE

Matt, so now i understand completely. thanks for the clarification. this may be crazy talk, so hopefully those closer to the DAL will weigh in here, but take a look at line select_raw of dal.py (i don't have a line number since i have all modified versions, it's around 2670): el

[web2py] Help with cron

I can't seem to get my cron working. Any tips? Running 1.91.6 locally on a Mac. cron/crontab: #run every 2 minutes */2 * * * * root *cron/release_pending_items.py controllers/cron.py: def release_pending_items(): items = db(db.item.status=='pending').select() for item in items: i

[web2py] Re: Keys and GAE

Hi Christian, Thanks for your response. In order to save my entities (as part of an entity group) I've had to set the parent of the 'address' to be the 'user'. That way I can use a transaction to persist these multiple entities in one go. I.e. assuming: db.define_table('user',

[web2py] Re: SQLFORM and read-only references

Is this in appadmin or your own forms? On Jan 10, 5:44 pm, howesc wrote: > It seems that in the latest version of web2py (1.91.6 and today's trunk) > that if you have a table (say auth_user), with a format string, and then you > refer to it in another table as read-only like: >   Field('updated_b

[web2py] Re: flush in web2py?

Too complex and not worth it. I would just use ajax. On Jan 10, 5:25 pm, Alexandre Andrade wrote: > I can't imagine how to do this: > > "You would have to break a view into > pieces, have an iterator process the pieces separately, return the > iterator." > > Maybe using ajax I can achive this? Fl

[web2py] Re: wrong documentation on ajax api sample?

No because the ajax part (web2py_ajax.html) stays with the app.It is not affected by upgrades unless you want to. On Jan 10, 5:17 pm, DenesL wrote: > Does this cause any backward compatibility issues?. > > On Jan 7, 10:25 am, DenesL wrote: > > > > > > > > > Hmmm... somewhere after 1.56.2 the aja

Re: [web2py] Email gateway

Thank You Bruno and Alexandre for your answers. I think I have now downloaded the attachment but not written it anywhere yet. Would it be possible to use the uploads function i web2py to save the file in uploads and update a table with info about the new file? Kenneth You should look to t

Re: [web2py] Re: Inserting additional fields in crud

Thanks. That thread did it. orm=SQLFORM .factory(db.client,Field('extra_field'))

[web2py] Re: Keys and GAE

I must admit i'm not following your example. why do you need to query by GAE __key__ rather than by ID? (i have not used ancestors in GAE so maybe that is why i'm mis-understanding). but your reference to my previous exchange made me look at this in the new DAL - and the !=, <, >, <=, and >=

[web2py] SQLFORM and read-only references

It seems that in the latest version of web2py (1.91.6 and today's trunk) that if you have a table (say auth_user), with a format string, and then you refer to it in another table as read-only like: Field('updated_by', 'reference '+auth.settings.table_user_name, default=auth.user_id,upda

Re: [web2py] Re: flush in web2py?

I can't imagine how to do this: "You would have to break a view into pieces, have an iterator process the pieces separately, return the iterator." Maybe using ajax I can achive this? Flush the content to a div? someone can post a example? 2011/1/10 Massimo Di Pierro > Not possible in web2py

[web2py] Re: wrong documentation on ajax api sample?

Does this cause any backward compatibility issues?. On Jan 7, 10:25 am, DenesL wrote: > Hmmm... somewhere after 1.56.2 the ajax function was changed. > It now uses serialize (which encodes a set of form elements as a > string for submission) instead of the original getElementById.

Re: [web2py] jquery.tools.min.js

Yes, I tried to load it as number 1 first, but I´ll try again some other places. Thank you for your answer. Kenneth Sometimes it is just the order of loading: did you try to change the order i.e. the "3" to something else? hope it works! mic 2011/1/10 Kenneth Lundström: A while ago I got

Re: [web2py] jquery.tools.min.js

Sometimes it is just the order of loading: did you try to change the order i.e. the "3" to something else? hope it works! mic 2011/1/10 Kenneth Lundström : > A while ago I got an app from Bruno with an example app showing how to open > a modal window. > > It works great in the example but when I

Re: [web2py] Problems with ssh tunnel to run cherokee-admin and configure web2py

Hi, El 10/01/11 14:38, pbreit escribió: > I'm not sure why '-N' would be necessary. I don't seem to need it on > RackSpace Cloud Ubuntu 10.04. > > The '-b' flag defeats the purpose. '-b' enables you to connect to Cherokee > admin over any port (ie, http://173.230.137.80/admin). Omitting '-b' is

[web2py] Re: [Tips] Change style of sqlform

This is great. Thanks. If you have time, maybe you could add it as a slice: http://web2pyslices.com

Re: [web2py] Gzip compression of javascript to speed up website

If you use apache proxy rewrite in front of your web2py you can compress everything even html. I do not know if it is possible with apache+fcgi or apache+wsgi, does anyone? mic 2011/1/10 pbreit : > Also, for Jquery: > http://code.google.com/apis/libraries/devguide.html#jquery >

Re: [web2py] Re: Problems trying to use jqgrid from plugin_wiki

Hello Massimo it is related to this thread I think : http://groups.google.com/group/web2py/browse_thread/thread/561ee826ac9c1ff2?pli=1 So you will close more then one issue ;-) Richard On Mon, Jan 10, 2011 at 4:13

Re: [web2py] Gzip compression of javascript to speed up website

Also, for Jquery: http://code.google.com/apis/libraries/devguide.html#jquery

[web2py] Keys and GAE

Hi there, How can I construct a GAE query using the DAL which allows me to specify the __key__? I can see several references to this in the dal.py file. Also in the following post: http://groups.google.com/group/web2py/browse_thread/thread/2ed53b5dc9069bef/785854e3ff3aa40b?lnk=gst&q=ANCESTOR#785

[web2py] Re: [w2py-dev] Re: ajax upload for components

I made a slice: http://web2pyslices.com/main/slices/take_slice/114 mic 2011/1/10 K.R.Arun : > Can you show me an example with file upload using jQuery form plugin? > Michele Comitini wrote: >> sorry i have to repeat myself, use the following, it is working and it >> is simple: >> http://jquery.

[web2py] Re: flush in web2py?

Not possible in web2py without major refactoring. That is because the view is a program that needs to run in order to produce an output. One way to do would be to have an action return an iterator. Each term in the iterator is flushed. You would have to break a view into pieces, have an iterator p

Re: [web2py] Gzip compression of javascript to speed up website

Not gzip, but works well -> http://pypi.python.org/pypi/WebDepCompress/0.2 2011/1/10 DJ > Hi there, > > I was using Chrome's audit tool to see how I can increase my application > speed. One of recommendations Chrome suggests is that I gzip javascript > files (jquery, others) to decrease loading

[web2py] Re: Is it a bug in "with_alias"?

Actually I am not sure why the SQL is wrong. The SQL looks correct although with_alias for a field is undocumented, except for tables, and I am not sure how well it works. On Jan 10, 3:42 pm, LightOfMooN wrote: > rolics = db(db.rolic.id>0).select(db.rolic.id.with_alias('myid')) > > Traceback (mos

Re: [web2py] Re: Problems trying to use jqgrid from plugin_wiki

> > Ok, thanks very much! That was the problem, I had to login :) > > I've heard of PowerTable, and even I visited the webpage, saw the > demos. PowerTable is really cool, but (I'm quoting the author in this) > it's not appropriate for tables with lot of records, because it uses > "datatable", and

[web2py] Gzip compression of javascript to speed up website

Hi there, I was using Chrome's audit tool to see how I can increase my application speed. One of recommendations Chrome suggests is that I gzip javascript files (jquery, others) to decrease loading time. Can the web2py server be set to serve zipped content based on the incoming browser? Also,

[web2py] flush in web2py?

In php, you can flush the data with the flush() function. It allows to send the data to the browser without wait for the rest of code. It's useful when you are doing a intensive computing task or a long time task and need send a answer to the user whie he waits. My question is: There is a way

[web2py] Re: Problems trying to use jqgrid from plugin_wiki

Ok, thanks very much! That was the problem, I had to login :) I've heard of PowerTable, and even I visited the webpage, saw the demos. PowerTable is really cool, but (I'm quoting the author in this) it's not appropriate for tables with lot of records, because it uses "datatable", and datatable isn

Re: [web2py] Email gateway

You can start from http://docs.python.org/library/poplib.html http://docs.python.org/library/imaplib.html http://docs.python.org/library/email.parser.html Atenciosamente Alexandre Andrade Hipercenter.com Classificados Gratuitos e Inteligentes 2011/1/10 Kenneth Lundström > A gateway that

[web2py] jquery.tools.min.js

A while ago I got an app from Bruno with an example app showing how to open a modal window. It works great in the example but when I copied it to my own app I couldn´t get it working. After some debugging I found out that I need to include the jquery.tools.min.js file. The only way I could g

[web2py] Re: Is it a bug in "with_alias"?

oops, sorry, failed with spaces "^" is under "AS", not under "FROM"

Re: [web2py] Email gateway

You should look to the built in modules: from poplib import * or from imaplib import * I used poplib to get raw text messages, but I never get attached files, but I guess it can do it. 2011/1/10 Kenneth Lundström > A gateway that works the other way. Instead of sending emails from web2py >

[web2py] Is it a bug in "with_alias"?

rolics = db(db.rolic.id>0).select(db.rolic.id.with_alias('myid')) Traceback (most recent call last): File "/home/www-data/web2py/gluon/contrib/shell.py", line 225, in run exec compiled in statement_module.__dict__ File "", line 1, in File "/home/www-data/web2py/gluon/dal.py", line 4507,

Re: [web2py] Re: The first code example of the CRUD Methods section of the online web2py book

Please forgot my last message. 2011/1/10 Alexandre Andrade > > The problem is supposed to be in this line: > > persons = crud.select(db.person, fields=['name'], > > headers={'person.name': 'Name'}) > > There is a typo, the last line shoul be: > > headers={{'person.name': 'Name'}) > > > > 2011/

[web2py] Email gateway

A gateway that works the other way. Instead of sending emails from web2py I´d like to receive emails. I´m working on a app where you upload PDF:s containing receipts. Those PDF:s are usually scanned in a photocopier that emails the PDF to your email. Then you have to login in to my app and upl

Re: [web2py] Re: The first code example of the CRUD Methods section of the online web2py book

> The problem is supposed to be in this line: > persons = crud.select(db.person, fields=['name'], > headers={'person.name': 'Name'}) There is a typo, the last line shoul be: headers={{'person.name': 'Name'}) 2011/1/10 Massimo Di Pierro > Nothing. Can we see more of the code? > > On Jan 10, 1

[web2py] Re: The first code example of the CRUD Methods section of the online web2py book

Nothing. Can we see more of the code? On Jan 10, 1:47 pm, AW wrote: > I tried to run the .../default/people request after I put a simple > view in place: > > {{extend 'layout.html'}} > > {{=form}} > > And I just got this error message: > " > Error snapshot > Detailed traceback description > Excep

[web2py] Re: Problems trying to use jqgrid from plugin_wiki

It took me a while to debug this. The problem is that the ajax service that fills the table requires login. You probably have not created an account or have not logged in. The page that displays the jqgrid does not require login so it shows, but the service responds with a login page instead of sen

[web2py] Re: The first code example of the CRUD Methods section of the online web2py book

I tried to run the .../default/people request after I put a simple view in place: {{extend 'layout.html'}} {{=form}} And I just got this error message: " Error snapshot Detailed traceback description Exception: ('person') " The problem is supposed to be in this line: persons = crud.select(db.p

[web2py] [Offtopic] Generate a mockup from existing web page

Interesting blog entry on the Foreui mockup tool blog about a service that is free for now which generated either Balsamiq or Foreui meta file from an existing web page. The author tried it on the front page of Linkedin with some success. I tried it on the front page of Dzone with quite a bit

Re: [web2py] Problems trying to use jqgrid from plugin_wiki

Why not try powerTable? On Mon, Jan 10, 2011 at 3:00 PM, Lisandro wrote: > I downloaded web2py (1.91.6) and executed the development server. > I edited the "welcome" app: > > First, I installed the plugin "plugin_wiki" in the "welcome" app. > > Second, I edited the db.py, adding the following lin

[web2py] Problems trying to use jqgrid from plugin_wiki

I downloaded web2py (1.91.6) and executed the development server. I edited the "welcome" app: First, I installed the plugin "plugin_wiki" in the "welcome" app. Second, I edited the db.py, adding the following line (every other thing stays as default): -

Re: [web2py] Re: BETA: new URL routing facility

On Jan 10, 2011, at 11:31 AM, pbreit wrote: > As usual, there's more to it than I first imagined! > > To overcome the issue of routes being overwritten with an update, could there > be a routes_default.py that ships with Web2py and can be overridden by > routes.py in the same directory? Not supe

Re: [web2py] Problems with ssh tunnel to run cherokee-admin and configure web2py

I'm not sure why '-N' would be necessary. I don't seem to need it on RackSpace Cloud Ubuntu 10.04. The '-b' flag defeats the purpose. '-b' enables you to connect to Cherokee admin over any port (ie, http://173.230.137.80/admin). Omitting '-b' is what requires tunneling through localhost which i

Re: [web2py] Re: BETA: new URL routing facility

As usual, there's more to it than I first imagined! To overcome the issue of routes being overwritten with an update, could there be a routes_default.py that ships with Web2py and can be overridden by routes.py in the same directory? Not super important. I envision something like (pseudocode):

Re: [web2py] Problems with ssh tunnel to run cherokee-admin and configure web2py

Hi again, El 10/01/11 13:13, Offray Vladimir Luna Cárdenas escribió: > Hi all, > > > I have being testing cherokee + uWSGI for serving web2py. Locally they > work fine, so I decided to put it under my virtual host (a linode VPS). > I was following the intructions on [1] and so I imagine that I n

Re: [web2py] Problems with ssh tunnel to run cherokee-admin and configure web2py

Slice is ok and your problem is not web2py related. Try restarting ssh demon (i googled, not sure if it'll work). On Mon, Jan 10, 2011 at 7:13 PM, Offray Vladimir Luna Cárdenas < off...@riseup.net> wrote: > Hi all, > > > I have being testing cherokee + uWSGI for serving web2py. Locally they > wor

Re: [web2py] Re: BETA: new URL routing facility

On Jan 10, 2011, at 9:33 AM, Wikus van de Merwe wrote: > I'm not using these routes. These were just made up examples to challenge the > proposed new routes. Now I understand that new routes are not intend to be > replacement for the old one, but rather a simplified alternative to handle > the m

[web2py] Re: BETA: new URL routing facility

What do you mean by "I never liked the fact that application specific routes are global"? You can have per/app routing files. Jonathan implemented this and it has been available for a while, although not documented in the printed book. Massimo On Jan 10, 11:33 am, Wikus van de Merwe wrote: > I'm

[web2py] Problems with ssh tunnel to run cherokee-admin and configure web2py

Hi all, I have being testing cherokee + uWSGI for serving web2py. Locally they work fine, so I decided to put it under my virtual host (a linode VPS). I was following the intructions on [1] and so I imagine that I need to do: ssh -L 9090:localhost:9090 r...@173.230.137.80 and: ssh -L 9090:127.

[web2py] [Tips] Change style of sqlform

http://martin.tecnodoc.com.ar/myblog/2011/01/10/hacking-web2py-sqlform-part-1

[web2py] Re: SOAP service - repeating elements/sets of elements

Opened two defects, one for web2py, one for pysimplesoap. Attached patch files to both: http://code.google.com/p/web2py/issues/detail?id=153 http://code.google.com/p/pysimplesoap/issues/detail?id=21 The patch files fix the problem nicely, I've been using this code since previous to my last email,

Re: [web2py] Re: BETA: new URL routing facility

I'm not using these routes. These were just made up examples to challenge the proposed new routes. Now I understand that new routes are not intend to be replacement for the old one, but rather a simplified alternative to handle the most common needs. However, it looks still quite complicated fo

[web2py] Re: Tip of the day

Yes, I saw the slice and was all sounds great, I just dont have the big picture on how they stay linked (at least i don't see it)..other thing that may do the trick is a variation on the "audit slice"... looking into that one Do we know if this 'Tip of the day' works well with the audit (saw t

[web2py] Re: Combining left outer join how to?

Hi DenesL, thank you very much for your feedback. I gave it a go, but I'm still getting doubled records. User John appears twice even if in the auth_user table he is alone. Uolter On Jan 6, 3:30 pm, DenesL wrote: > Just make a list of theleftjoins: > > users=db().select(db.auth_user.ALL, > d

[web2py] Re: computed fields and SQLFORM

yes it kinda would. i would love to be able to see the values of the fields and have them update via javascript as the fields they depend on are modified, but that is beyond the functionality of SQLFORM. But i do want to see the current values when i am editing the form given the potentia

Re: [web2py] Re: customize json output

I would rely on repr too much, Wikus is correct, and all escape sequences are safe? http://json.org/ simplejson slow vs repr? on GAE it should be even slower... 2011/1/10 Wikus van de Merwe : > Unfortunately there is a subtle difference between the output of repr/str > and JSON. Python by defa

Re: [web2py] Re: BETA: new URL routing facility

On Jan 9, 2011, at 11:41 PM, pbreit wrote: > I'm a bit confused as well. Perhaps some more example would help. What's your current routes.py? A general question for the list: how many of you are using domain routing? That is, where you route a particular incoming domain to a particular route? An

[web2py] reference all fields of another table

Hi, I could be looking in the wring place, but i don't see an example on referencing ALL the fields of another table without having to name them - I would like the combination of tables to be more dynamic, so that "sub-tables (forms) could be created on the fly depending on user input... somethin

[web2py] Re: customize json output

Unfortunately there is a subtle difference between the output of repr/str and JSON. Python by default uses single quotes while JSON needs the double ones. If there are no strings in the dict though, str/repr would work all fine.

[web2py] Re: Key error with new DAL and _extra

Thanks for reporting this. The proper new way is: m = db.foo.bar.max() for row in db(...).select(m): print row[m] The old way and still backward compatible is: m = db.foo.bar.max() for row in db(...).select(m): print row._extra[m] A hack that worked with the old way but broke with the

[web2py] Re: Finding out if login has failed

You can set your message with auth.messages.invalid_login = "" On Jan 10, 6:58 am, Ruiwen Chua wrote: > Hi, > > Currently, I'm using the default auth() (eg. return dict(form=auth()) > method for generating the form for my user login view. > > I'd like to know if there's any way by which I ca

[web2py] Key error with new DAL and _extra

Hi! Just updated a project from 1.89.5 to 1.91.6. Got a key error. row._extra['MAX(foo.bar)'] had a problem with the key. The query has a "db.foo.bar.max()," in the select(). (Funny: Can't find anything about _extra and max() again in the book now?) Changed the key to 'max(foo.bar)' and now eve

[web2py] Finding out if login has failed

Hi, Currently, I'm using the default auth() (eg. return dict(form=auth()) method for generating the form for my user login view. I'd like to know if there's any way by which I can tell if a login has failed from within the controller action? I've just asked on the IRC channel, and the answer I go

[web2py] Re: Tip of the day

This one was there at web2pyslice's But It doesn't worked for me when I had a field of type file in one of the forms. Yes, it worked fine on rocket server comes with web2py. But I had to make that work on GAE (but it doesn't worked) I had a long thread here. And waiting Massimo to figure out wha

[web2py] Re: on a possible web2py memory leak

Yes. For the record, having this class: class A: def __init__(self): self.x=x def __del__(self): pass and doing this in an action a=A() would cause the same leak on ANY web framework running on CPython (not on Jython). Using __del__ in python is dangerous. On Jan 10, 3:15 am, Michele

Re: [web2py] Re: ADVOCACY: "every single other Python program ever written uses imports"?

>From my perspective, web2py style is very much influenced by its functional approach and the usage of functors. This gives a great amount of tools to new comers, but can be problmematic with experienced programmers that have been working with a COO (class object oriented: read java) language. I

[web2py] Re: "undefined record" error in appadmin on GAE

I believe we added some checks in 1.91.5 that fix this problem. Not completely but may work in your case. Give that a try first and your case is not covered we'll improve it. On Jan 10, 1:39 am, johntynan wrote: > I am running a web2py application on GAE.  I would like to export > different table

[web2py] Re: Tip of the day

Hi, Just tried this and does the trick! :) I''m just a little unclear on how these two (or more?) tables are linked once submitted? Example: request forms. There can be many types of requests and let's say that they all have a set fields that all request forms have (like: name, email, priority, cr

Re: [web2py] Re: on a possible web2py memory leak

good article, esp. the "The trouble with Finalizers" part 2011/1/10 ron_m : > In the sample code if one comments out the __del__ method in the class the > leak does not occur. That is not to say it can't happen I suppose in a more > complicated code example but I believe the __del__ is a required

Re: [web2py] Re: Inserting additional fields in crud

Is this what your looking for: http://groups.google.com/group/web2py/browse_thread/thread/a0566bf740023b1/41eadc3ba1b53176?lnk=gst&q=form+append#41eadc3ba1b53176 Kenneth I've tried using SQLFORM and adding additional fields by simply adding html inputs. The fields are not accessible via form.v

[web2py] Re: Inserting additional fields in crud

Did you check out SQLFORM.factory? http://web2py.com/book/default/chapter/07#SQLFORM.factory I'd highly recommend using Web2py's built-in user functions, at least initially. It includes all the basic user functions. Then you can focus on your application and come back to user auth later if you r