[web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread Lewis
Thanks. The versions I got were in the apt-get repositories for that version of Ubuntu. I hadn't realized Cherokee had been abandoned. I am not in love with anything. I can go back to Apache. It is certainly well-documented and well-supported. Is Nginx the cat's meow? My site is not at

Re: [web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread Vasile Ermicioi
I hadn't realized Cherokee had been abandoned. I am not in love with anything. I can go back to Apache. It is certainly well-documented and well-supported. Is Nginx the cat's meow? My site is not at all performance bound. I was just looking for an easier option. uwsgi has a built-in

Re: [web2py] [noob]html not properly rendered, class=ten columns has no effect on where the elements are positioned.

2012-05-16 Thread Keith Edmunds
On Tue, 15 May 2012 14:28:04 -0700 (PDT), shortempe...@gmail.com said: all I get is a page with elements placed on default location I would start by looking in the browser at the page source, and see what is wrong, and I'd check that the CSS file is being loaded. Once you know how the HTML

Re: [web2py] [noob]html not properly rendered, class=ten columns has no effect on where the elements are positioned.

2012-05-16 Thread Johann Spies
On 15 May 2012 23:28, Vinit Mahedia shortempe...@gmail.com wrote: Below is my html file, although I specify where do I want to put each element, all I get is a page with elements placed on default location (left most side of the page). I am following this

[web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread Gour
On Tue, 15 May 2012 23:13:33 -0700 (PDT) Lewis lewis_le...@hotmail.com wrote: I hadn't realized Cherokee had been abandoned. Who told you that? The main developer is busy with a new job and slowly working on a new version which should support SPDY protocol. Sincerely, Gour -- Never was

Re: [web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread Roberto De Ioris
Thanks. The versions I got were in the apt-get repositories for that version of Ubuntu. I hadn't realized Cherokee had been abandoned. not abandoned, it is on hold (or slowed down in development) -- Roberto De Ioris http://unbit.it

Re: [web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread Roberto De Ioris
I hadn't realized Cherokee had been abandoned. I am not in love with anything. I can go back to Apache. It is certainly well-documented and well-supported. Is Nginx the cat's meow? My site is not at all performance bound. I was just looking for an easier option. uwsgi has a

Re: [web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread Vasile Ermicioi
Maybe it is time to add https support... that would be great... )) and I know you are not interested in, but I would like also a windows version

[web2py] Custom form with default values...

2012-05-16 Thread Jason Brower
Many values I don't need to show in the view so I have done this: def join(): ''' NOTES:Covers the event bio and any payments if needed. ''' event_details = db.event[request.args(0)] if not event_details: redirect(URL('default', 'index')) attender_count =

[web2py] Two LEFT JOINs and left=

2012-05-16 Thread Annet
How would I code this query in web2py using left= SELECT organization.name, hub.name FROM node LEFT JOIN organization ON node.id = organization.nodeID LEFT JOIN hub ON node.id = hub.nodeID; Kind regards, Annet

[web2py] https for login

2012-05-16 Thread Lewis
I have been trying to add force https for login with apache directives to no avail. Ideally, I would have a redirect, rather than simply access denied (not fair to expect a user to know to try https and type it in manually like we all do for admin and appadmin). I guess I don't get regexp or

[web2py] Re: Two LEFT JOINs and left=

2012-05-16 Thread Annet
I tried: row=db().select(db.Organization.name,db.Hub.name,\ left=[db.Node.on(db.Node.id==db.Organization.nodeID),db.Node.on(db.Node.id==db.Hub.nodeID)]).first() but that results in: class 'psycopg2.ProgrammingError' invalid reference to FROM-clause entry for table organization LINE 1: ...OM

[web2py] Re: Questions about background process using homemade task queue

2012-05-16 Thread Niphlod
you can do what you want, celery is a task queue handler on steroids. with that you can pass messages, assign more workers if your message queue is lagging behind (i.e. 2 workers if the queue contains 100 updates, 8 workers if queue contains 1000) and so on. For basic task you can roll your

Re: [web2py] Custom form with default values...

2012-05-16 Thread Johann Spies
On 16 May 2012 09:43, Jason Brower encomp...@gmail.com wrote: If I print the form with {{=bio_form}} it works just fine, but I see all the extra data fields. Is there a way to fix this? Yes. 'bio_form' contains the whole form with all the fields including hidden ones.. In your view you

Re: [web2py] Re: Two LEFT JOINs and left=

2012-05-16 Thread Johann Spies
On 16 May 2012 10:51, Annet anneve...@googlemail.com wrote: I tried: row=db().select(db.Organization.name,db.Hub.name,\ left=[db.Node.on(db.Node.id==db.Organization.nodeID),db.Node.on(db.Node.id ==db.Hub.nodeID)]).first() but that results in: class 'psycopg2.ProgrammingError' invalid

Re: [web2py] Re: Two LEFT JOINs and left=

2012-05-16 Thread Marin Pranjić
Can you post entire query generated using _select method? On Wed, May 16, 2012 at 10:51 AM, Annet anneve...@googlemail.com wrote: I tried: row=db().select(db.Organization.name,db.Hub.name,\ left=[db.Node.on(db.Node.id==db.Organization.nodeID),db.Node.on(db.Node.id ==db.Hub.nodeID)]).first()

[web2py] How can you configure memcache and built-in cache to be present at the same time

2012-05-16 Thread Robert Clark
Is there a way to configure both MemcacheClient and the built-in cache at the same time? We would like to use built-in cache to hold singleton or short-life python objects across requests (being a process-only cache it suits well) and Memcache for everything else (sessions and

[web2py] Re: Schemas, search parth, auth_user and table definitions in modules

2012-05-16 Thread Johann Spies
The following code seems to have solved my problem (I replaced the class with a function to which db is passed by the controller): def docs(db): T = current.T auth = current.session.auth if auth: auth_user = self.auth.user.id else: auth_user = None request =

[web2py] External lib import issue ( opencv )

2012-05-16 Thread web2py_tn
Hey guys- I installed opencv and it works great integrated with python when I run it from the command line. Actually even web2py runs fine with opencv with the line of code import cv when I run it from the terminal. My problem is with Aptana ( pydev ). When I run the project in pydev, import cv

Re: [web2py] Re: Two LEFT JOINs and left=

2012-05-16 Thread Marin Pranjić
Also, can you try: row=db().select(db.Organization.name http://db.organization.name/, db.Hub.name http://db.hub.name/,\ left=[db.Organization.on(db.Node.id http://db.node.id/== db.Organization.nodeID),db.Hub.on(db.Node.id http://db.node.id/==db.Hub. nodeID)]).first() Marin On Wed, May 16, 2012

[web2py] Re: [noob]html not properly rendered, class=ten columns has no effect on where the elements are positioned.

2012-05-16 Thread Anthony
My reply on Stack Overflow: http://stackoverflow.com/a/10609558/440323. Let me know if you have questions. Anthony On Tuesday, May 15, 2012 5:28:04 PM UTC-4, Vinit Mahedia wrote: Below is my html file, although I specify where do I want to put each element, all I get is a page with elements

[web2py] Re: Custom form with default values...

2012-05-16 Thread Anthony
You could set the readable and writable attributes of the fields you want to hide to False. Another option is to use SQLFORM instead of Crud and pass the fields argument with a list of fields to include. In this case, SQLFORM is probably just as easy to use as Crud. bio_form =

[web2py] Re: How can you configure memcache and built-in cache to be present at the same time

2012-05-16 Thread Anthony
Can't you just use cache.memcache for memcache and cache.ram/cache.disk as usual? The example in the book re-assigns cache.ram and cache.disk to point to cache.memcache, but I don't think that is required. Try just leaving that line out. Anthony On Wednesday, May 16, 2012 5:40:50 AM UTC-4,

[web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread John-Kim Murphy
These are the best guides for installing Web2Py + Cherokee: - http://stackoverflow.com/questions/4332514/set-up-cherokee-web2py-on-ubuntu-10-04-lucid/4528543#4528543 - Based on my personal experience from installing Web2Py on Cherokee about a year ago -

[web2py] Re: quotes invoices app

2012-05-16 Thread Alan Etkin
Check out this projects: *GestionLibre* http://code.google.com/p/gestionlibre/ *FacturaLibre*http://code.google.com/p/pyafipws/source/checkout?repo=gui2py-app The first is an open source ERP software with a web2py app for the web interface. A Basic CRM and invoice generation system is available

[web2py] Re: SNI or dedicated IP.

2012-05-16 Thread Ross Peoples
I'd never heard of SNI before, but looking at the Wikipedia page for it: http://en.wikipedia.org/wiki/Server_Name_Indication This will NOT work. The main reason being that Python 2 (which web2py runs on) does not support SNI. Python 3.2 does, however. So until there is a web3py, SNI will not

[web2py] Re: quotes invoices app

2012-05-16 Thread Alan Etkin
The second link is wrong. FacturaLibre is at http://code.google.com/p/pyafipws/source/checkout?repo=web2py-app El miércoles, 16 de mayo de 2012 09:32:06 UTC-3, Alan Etkin escribió: Check out this projects: *GestionLibre* http://code.google.com/p/gestionlibre/

[web2py] Re: https for login

2012-05-16 Thread Ross Peoples
You could force a redirect within web2py. I do this with most of my applications: In a model: if request.controller == 'default' and request.function == 'user': request.requires_https() This will force all user operations (login, profile, reset_password, etc) to use HTTPS. The advantage to

[web2py] Re: https for login

2012-05-16 Thread Ross Peoples
By the way, in case you are wondering, I stopped using Apache once I tried Nginx. Configuration is much easier (in my humble opinion) and it's way faster. So I've been using Nginx for all of my stuff for over 6 months now and haven't looked back. However, I still try to write my applications to

[web2py] How to use web2py DAL with sybase?

2012-05-16 Thread dlypka
I see this posting which has some sybase adapter code: https://groups.google.com/forum/?fromgroups#!searchin/web2py/sybase/web2py/LXdEdc1th3M/8ZIOxE8tJQgJ Is there anything else? I have a need to use web2y + sybase at work. Thanks.

Re: [web2py] Re: Error facebook login

2012-05-16 Thread www.diazluis.com
greetings. I repeat this properly configured facebook I have no write permission on / etc / hosts I have write permission only for: / apache2 / htdocs / web2py not my domain provider allows me to create PTR type DNS not as you would with CNAME thanks for your time and help .. I'm still here

[web2py] Re: https for login

2012-05-16 Thread Anthony
request.requires_https() Yet another secret feature. :-)

[web2py] update not updating

2012-05-16 Thread lucas
hello one and all, trying to update, but not updating. here is my code: db.lecture_items.fileetag.writable = True upload = db(db.lecture_items.id==uidi).select().first() upload.update(fileetag='%s' % request.vars.etag) db.commit() i even threw in the commit and i have verified

[web2py] Re: https for login

2012-05-16 Thread Ross Peoples
I only know about it because I submitted it :) We really need to open the book up for editing so that we can add these kinds of things. On Wednesday, May 16, 2012 9:22:28 AM UTC-4, Anthony wrote: request.requires_https() Yet another secret feature. :-)

[web2py] Re: https for login

2012-05-16 Thread Anthony
On Wednesday, May 16, 2012 9:52:34 AM UTC-4, Ross Peoples wrote: I only know about it because I submitted it :) We really need to open the book up for editing so that we can add these kinds of things. +1

[web2py] Re: https for login

2012-05-16 Thread Anthony
I'm tempted to say we should just go back to the old book app for the time being so we can do editing as well as have working reference links, an index, and a working TOC for the Deployment chapter (all of which are broken in the current book app). Anthony On Wednesday, May 16, 2012 10:01:14

Re: [web2py] update not updating

2012-05-16 Thread Richard Vézina
I think that this is wrong : upload = db(db.lecture_items.id==uidi). select().first() try not use upload var at first, do this instead : db(db.lecture_items.id==uidi).update(fileetag='%s' % request.vars.etag) If still not working, you should investigate if uidi is really the id of the record

[web2py] Re: update not updating

2012-05-16 Thread Anthony
db.lecture_items.fileetag.writable = True upload = db(db.lecture_items.id==uidi).select().first() upload.update(fileetag='%s' % request.vars.etag) db.commit() First, the writable attribute only determines whether the field will be displayed and editable in SQLFORMs -- you

[web2py] Re: RFC: web2py-based workflow engine

2012-05-16 Thread Cliff
I have collected my thoughts into a specification, available at this linkhttps://docs.google.com/document/d/1yeVV9Pf--BIE0GvkhVcPkF81vjxkzKcFtpcUlj7xZeQ/edit?pli=1 . Comments invited and welcome. Thank you. On Tuesday, May 1, 2012 12:00:42 PM UTC-4, Ross Peoples wrote: In reference to:

[web2py] Re: quotes invoices app

2012-05-16 Thread Gour
On Wed, 16 May 2012 05:32:06 -0700 (PDT) Alan Etkin spame...@gmail.com wrote: Check out this projects: *GestionLibre* http://code.google.com/p/gestionlibre/ *FacturaLibre*http://code.google.com/p/pyafipws/source/checkout?repo=gui2py-app Thank you...Let me check it out... Sincerely, Gour

[web2py] modules

2012-05-16 Thread Aurigadl
I always work with modules. In the latest versions of web2py not work. doing the following to import: from applications.examples.modules import test Restricting the application name.The modules are placed in the / app / modules/. As this problem solved.

Re: [web2py] modules

2012-05-16 Thread Bruno Rocha
For that to work you need a bare __init__.py file in all directories and subdirectories. /applications/__init__.py, /applications/yourapp/__init__.py, .../modules/__init__.py On Wed, May 16, 2012 at 12:13 PM, Aurigadl aurig...@gmail.com wrote: I always work with modules. In the latest versions

[web2py] Re: External lib import issue ( opencv )

2012-05-16 Thread Wikus van de Merwe
Where is the opencv installed in your system? When you check python interpreters in PyDev options is that path on the list? If you still struggling with it, a workaround could be to add the installation folder to the system path by hand: import sys sys.path.append(opencv)

[web2py] Re: RFC: web2py-based workflow engine

2012-05-16 Thread Ross Peoples
Cliff, Thanks for putting this into a spec. My current code follows most of what is in there. I still haven't finished writing (or testing it), but I do have some thoughts on implementation for one or two of the items listed at the end: I imagine a workflow_monitor table that has the fields:

[web2py] Re: Why the web2py shell returns different results?

2012-05-16 Thread sesenmaister
1.-both editor and shell use different type of encofing: sure 2.-both editor and shell throw the same answer: yes import sys sys.stdin.encoding ‘cp850' 3.-both editor and shell throw the same answer: yes import sys sys.getdefaultencoding() 'ascii' 4.-due to my lack of knowledge, I must be

Re: [web2py] Re: Book Update - Chapter 9 - Pyjamas and jsonrpc

2012-05-16 Thread Massimo Di Pierro
I promise. Tonight. On Tuesday, 15 May 2012 09:19:41 UTC-5, Anthony wrote: On Tuesday, May 15, 2012 10:12:32 AM UTC-4, Massimo Di Pierro wrote: Agreed. nudgeNevertheless, we need the book to be editable again so we can fix all the other errors that have been reported and start

[web2py] Re: modules

2012-05-16 Thread Anthony
Are you importing from within the examples application? In that case you can just do: import test Anthony On Wednesday, May 16, 2012 11:13:16 AM UTC-4, Aurigadl wrote: I always work with modules. In the latest versions of web2py not work. doing the following to import: from

[web2py] Re: AttributeError: 'thread._local' object has no attribute 'request'

2012-05-16 Thread Massimo Di Pierro
what python version and os version do you have? On Tuesday, 15 May 2012 22:20:00 UTC-5, JungHyun Kim wrote: Hi. I got a error AttributeError: 'thread._local' object has no attribute 'request' when trying to run web2py with wsgi. The application was welcome which is sample application of

Re: [web2py] Re: Two LEFT JOINs and left=

2012-05-16 Thread Annet
Johann and Marin, Thanks for your replies. Also, can you try: row=db().select(db.Organization.name http://db.organization.name/, db.Hub.name http://db.hub.name/,\ left=[db.Organization.on(db.Node.id http://db.node.id/== db.Organization.nodeID),db.Hub.on(db.Node.id

[web2py] Re: GAE datastore: how to unindex a field?

2012-05-16 Thread Wikus van de Merwe
This is really a GAE question, not related to web2py. By default the indexes are set automatically when you run your app in dev environment depending on what queries you use. But you can do it manually to by editing the index.yaml (above the #AUTOGENERATED line). On the next deploy the indexes

[web2py] Re: modules

2012-05-16 Thread Aurigadl
if you have: /applications/examples/modules/prueba.py $python web2py.py -S examples import prueba this does not work But if you used: from applications.examples.modules import prueba this work very well. way?? I have all whit the __init__py for import modules. El miércoles, 16 de mayo de

[web2py] Re: How to use web2py DAL with sybase?

2012-05-16 Thread Massimo Di Pierro
web2py includes an adapter but nobody has tested it. If you can help us test it we can help you debug any problem that may arise. Compatibility with sybase and other SQL DB engines is a priority. On Wednesday, 16 May 2012 07:47:59 UTC-5, dlypka wrote: I see this posting which has some

[web2py] Re: modules

2012-05-16 Thread Massimo Di Pierro
Please open a ticket in googlecode and give more details about your web2py version, python version and os version. On Wednesday, 16 May 2012 10:40:54 UTC-5, Aurigadl wrote: if you have: /applications/examples/modules/prueba.py $python web2py.py -S examples import prueba this does not

[web2py] Re: How to use web2py DAL with sybase? Please point me to the sybase adapter

2012-05-16 Thread dlypka
I do not see any reference to sybase in 1.99.7 dal.py. Please point me to the sybase adapter. There are 2 of us developers here at work who can test it for you on a large corporate sybase database. Thanks. On Wednesday, May 16, 2012 10:42:05 AM UTC-5, Massimo Di Pierro wrote: web2py

[web2py] Re: SNI or dedicated IP.

2012-05-16 Thread Annet
Hi Ross, Thanks for the reply. I'll stick to the dedicated IP address solution. Kind regards, Annet

[web2py] require login on submit

2012-05-16 Thread Marco Prosperi
hi all, what could be a clean way to require login (if not already logged in) when a user clicks on the submit button of a form? thanks in advance for advice Marco

[web2py] Re: modules

2012-05-16 Thread Aurigadl
I did Thank you for entering Issue 800http://code.google.com/p/web2py/issues/detail?id=800 El miércoles, 16 de mayo de 2012 10:43:36 UTC-5, Massimo Di Pierro escribió: Please open a ticket in googlecode and give more details about your web2py version, python version and os version. On

[web2py] change the size of a text field in a form

2012-05-16 Thread Marco Prosperi
hello, how can I change the default size of a 'text' field in a form? (at first appearance, not dragging the corner) thanks Marco

Re: [web2py] Re: GAE datastore: how to unindex a field?

2012-05-16 Thread Christian Foster Howes
actually the question at hand here i think is whether or not web2py can support indexed=False in the property constructor when defining GAE models: https://developers.google.com/appengine/docs/python/datastore/propertyclass class Property(verbose_name=None, name=None, default=None,

[web2py] Re: SNI or dedicated IP.

2012-05-16 Thread Anthony
I'd never heard of SNI before, but looking at the Wikipedia page for it: http://en.wikipedia.org/wiki/Server_Name_Indication This will NOT work. The main reason being that Python 2 (which web2py runs on) does not support SNI. Python 3.2 does, however. So until there is a web3py, SNI

[web2py] Re: change the size of a text field in a form

2012-05-16 Thread Anthony
You can do it via CSS: textarea {width: 400px;} Anthony On Wednesday, May 16, 2012 11:59:14 AM UTC-4, Marco Prosperi wrote: hello, how can I change the default size of a 'text' field in a form? (at first appearance, not dragging the corner) thanks Marco

[web2py] Re: https for login

2012-05-16 Thread Lewis
Well, thats easy! Does anyone do it with RedirectMatch? Should I really switch to nginx? Thanks, (I hate config.)

[web2py] Re: require login on submit

2012-05-16 Thread Anthony
What user workflow are you trying to achieve? Is it possible to simply not present the form unless the user is logged in (i.e., require login to get to the page with the form)? Otherwise, I suppose you could handle it via Javascript and Ajax -- when submit is clicked, check for login, and if

[web2py] Re: AttributeError: 'thread._local' object has no attribute 'request'

2012-05-16 Thread JungHyun Kim
The server is Redhat Openshift (cloud PAAS). It uses Python 2.6 on RHEL 6. 2012년 5월 17일 목요일 오전 12시 34분 54초 UTC+9, Massimo Di Pierro 님의 말: what python version and os version do you have? On Tuesday, 15 May 2012 22:20:00 UTC-5, JungHyun Kim wrote: Hi. I got a error AttributeError:

[web2py] Re: Is there anyone who running web2py application on Redhat openshift?

2012-05-16 Thread JungHyun Kim
Thank you Andrew! I connected mysql successfully (I guess, cause the error message disappeared). But I still have some problems. ( https://groups.google.com/forum/#!topic/web2py/wMDDCsisic4) If I can see your project settings, it will be really helpful! 2012년 5월 16일 수요일 오전 3시 15분 28초

[web2py] Re: SNI or dedicated IP.

2012-05-16 Thread Ross Peoples
I wouldn't know the first thing about setting up SNI, so I would tell WebFaction that if they will do it for me and it works, then sure, I'll use SNI, otherwise stick with what you know. On Wednesday, May 16, 2012 12:14:42 PM UTC-4, Anthony wrote: I'd never heard of SNI before, but looking at

[web2py] Re: RFC: web2py-based workflow engine

2012-05-16 Thread Cliff
Ross, I like the workflow monitor table, though I think it should be tied to the template rather than individual workflows. Since each stage knows the id of its parent workflow and the workflow knows the id of its template, it would be a simple matter to get the monitors and ping them when

Re: [web2py] Re: External lib import issue ( opencv )

2012-05-16 Thread Bassem Bouguerra
Thanks Willis Do I add that into the web2py.py ? On Wed, May 16, 2012 at 8:17 AM, Wikus van de Merwe dupakrop...@googlemail.com wrote: Where is the opencv installed in your system? When you check python interpreters in PyDev options is that path on the list? If you still struggling with

[web2py] Re: SNI or dedicated IP.

2012-05-16 Thread Anthony
On Wednesday, May 16, 2012 1:08:20 PM UTC-4, Ross Peoples wrote: I wouldn't know the first thing about setting up SNI, so I would tell WebFaction that if they will do it for me and it works, then sure, I'll use SNI, otherwise stick with what you know. I think in this case, what you know

[web2py] Re: Automatically reload custom modules?

2012-05-16 Thread howesc
i'm on a mac using GAE, but i have a script that calls dev_appserver (rather than using their gui launcher). and my keystrokes memorized to alt+tab to terminal, ctrl+c, up arrow, enter, alt+tab to FFperhaps not quite as efficient as auto-reload of modules but it keeps me happy enough. cfh

Re: [web2py] Re: External lib import issue ( opencv )

2012-05-16 Thread Bassem Bouguerra
Also, I installed opencv using homebew and I can find OpenCV folder in /usr/local/share/ where there is OpenCVConfig-version.cmake haarcascades OpenCVConfig.cmake lbpcascades doc That means OpenCV's installation path is /usr/local/share/, right? On Wed, May 16, 2012 at 10:33 AM, Bassem Bouguerra

Re: [web2py] Re: External lib import issue ( opencv )

2012-05-16 Thread Bassem Bouguerra
Actually I think the installation path is /usr/local/lib/ But where do I have to manually set it, in web2py? On Wed, May 16, 2012 at 10:42 AM, Bassem Bouguerra bougue...@gmail.comwrote: Also, I installed opencv using homebew and I can find OpenCV folder in /usr/local/share/ where there is

[web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread pbreit
As has been suggested, you might reconsider Apache or Nginx (my preference). I haven't tried this in awhile but this worked at one point: https://bitbucket.org/pbreit/web2py-automation/src/bc2ac095b592/setup-ubuntu-cherokee.sh Also, for Nginx:

[web2py] Re: RFC: web2py-based workflow engine

2012-05-16 Thread Ross Peoples
The data model I already have does things a bit differently, but I think it accomplishes the same thing. I am in the process of writing all of the support methods. This is my current data model: # workflow table db.define_table('workflow', Field('name', length=50), Field('is_template',

[web2py] Filling the page as data is being processed

2012-05-16 Thread Fabiano Faver
I have a page that have a slow query using group by but it are slowing down the query so I thought to load each item separately and showing them as they are done. Web2py have any tool that can help me with this or I need to use another approach?

Re: [web2py] Filling the page as data is being processed

2012-05-16 Thread Richard Vézina
Show code, very difficult to follow you... Richard On Wed, May 16, 2012 at 2:44 PM, Fabiano Faver far...@gmail.com wrote: I have a page that have a slow query using group by but it are slowing down the query so I thought to load each item separately and showing them as they are done. Web2py

Re: [web2py] Filling the page as data is being processed

2012-05-16 Thread Fabiano Faver
I'm trying to display a table with the name of some companies with the background color of each TD or DIV dependent of the last day the printers company were checked this it what I have now: def exibicao_empresas(): #get companies empr = db(auth.accessible_query('read', db.empresa,

Re: [web2py] Filling the page as data is being processed

2012-05-16 Thread Fabiano Faver
But because of the group by clause it are too slow and I curious to know if I can query each company separately do what i must with the data and show the result on page as soon as they are ready 2012/5/16 Fabiano Faver far...@gmail.com I'm trying to display a table with the name of some

[web2py] Problem with storage object

2012-05-16 Thread Rod Watkins
I have created a Storage object in a model to expose some settings gathered from the database. But I am facing a problem. When I access the object from a view, it works correctly, e.g., {{=gsettings.setting_name}} produces the correct text in my html. But if I try to access that value in my

Re: [web2py] Problem with storage object

2012-05-16 Thread Bruno Rocha
do you have a function named gsettings in controller? -- Bruno Rocha [http://rochacbruno.com.br]

Re: [web2py] Filling the page as data is being processed

2012-05-16 Thread Richard Vézina
Would you show your models... You make complexe queries, maybe your models are not pretty well design for the purpose. Richard On Wed, May 16, 2012 at 3:22 PM, Fabiano Faver far...@gmail.com wrote: But because of the group by clause it are too slow and I curious to know if I can query each

[web2py] cannot find the adapter for sybase which Massimo is referring to

2012-05-16 Thread dlypka
Please advise where it is. I do not see 'sybase' in dal.py. Is is somewhere else? Thanks.

Re: [web2py] Filling the page as data is being processed

2012-05-16 Thread Fabiano Faver
For this purpose they are not...I may include a field on printers table that inform the date I searching for. If what I want to do in this page is still not clear I can try to explain more. basically its a grid that each TD have a bg-color dependant on it last date EmpresaTb =

Re: [web2py] Filling the page as data is being processed

2012-05-16 Thread Richard Vézina
If you don't need this page to be update more then once a day or once a hour what you can do is this : You make sub-function that you gonna cache def __sub_func_NAME(): complex query return var def display_func(): var = cache.ram('var', lambda:

Re: [web2py] Problem with storage object

2012-05-16 Thread Rod Watkins
No, no such function. On Wednesday, 16 May 2012 12:46:26 UTC-7, rochacbruno wrote: do you have a function named gsettings in controller? -- Bruno Rocha [http://rochacbruno.com.br]

Re: [web2py] Re: Error facebook login

2012-05-16 Thread Michele Comitini
The /etc/hosts i am talking about is the one on the client I.e. the computer running the browser not the one running web2py. If you want a public domain name you can one at afraid.org. No PTR just A is needed. mic Il giorno 16/mag/2012 15:16, www.diazluis.com diazluis2...@gmail.com ha scritto:

Re: [web2py] Problem with storage object

2012-05-16 Thread Rod Watkins
Ahh, found it. I did have a function named gsettings. It was in a different model file and I had forgotten to delete it. Thanks for the suggestion. That was two hours wasted. :) Rod On Wednesday, 16 May 2012 12:46:26 UTC-7, rochacbruno wrote: do you have a function named gsettings in

Re: [web2py] Configuring web2py with nginx - domain error (gaierror: [Errno -2] Name or service not known)

2012-05-16 Thread Chris
I wrote a patch to fix the problem on my server, which is basically just commenting out that line (main.py:390ish): local_hosts = [http_host,'::1','127.0.0.1',':::127.0.0.1'] if not global_settings.web2py_runtime_gae: local_hosts +=

[web2py] Re: How to use web2py DAL with sybase? Please point me to the sybase adapter

2012-05-16 Thread Massimo Di Pierro
Will send it tonight. Basically Sybase is almost the same as MSSQL. Do you a preference for one of the pyhton drivers for sybase? On Wednesday, 16 May 2012 10:51:39 UTC-5, dlypka wrote: I do not see any reference to sybase in 1.99.7 dal.py. Please point me to the sybase adapter. There are

[web2py] Re: web2py uWSGI cherokee -- I give up

2012-05-16 Thread Lewis
Thanks. I am going with nginx. Already had apache up and running for many months. The slices are way out of date (and the site has bad visuals, is hard to navigate and search despite being a volunteer effort by a community member). The cookbook is better but contains obvious errors (symbolic

[web2py] Re: AttributeError: 'thread._local' object has no attribute 'request'

2012-05-16 Thread Massimo Di Pierro
Any chance you can try 2.5 or 2.7? On Wednesday, 16 May 2012 11:28:32 UTC-5, JungHyun Kim wrote: The server is Redhat Openshift (cloud PAAS). It uses Python 2.6 on RHEL 6. 2012년 5월 17일 목요일 오전 12시 34분 54초 UTC+9, Massimo Di Pierro 님의 말: what python version and os version do you have? On

[web2py] Re: How to use web2py DAL with sybase? Please point me to the sybase adapter

2012-05-16 Thread dlypka
No preference on which python driver for sybase. So whatever you select is fine with us. Thanks. - Dave Lypka. On Wednesday, May 16, 2012 4:10:28 PM UTC-5, Massimo Di Pierro wrote: Will send it tonight. Basically Sybase is almost the same as MSSQL. Do you a preference for one of the pyhton

[web2py] Re: How to use web2py DAL with sybase? Please point me to the sybase adapter

2012-05-16 Thread Massimo Di Pierro
I just committed a SybaseAdapter using this driver: http://python-sybase.sourceforge.net/ It extends the MSSQLAdapter but uses the other driver and Sybase types. It needs testing. You can use it with DAL('sybase://dsnstring') or DAL('sybase://username:password@hostname:port/dbname') It uses

Re: [web2py] Re: External lib import issue ( opencv )

2012-05-16 Thread Massimo Di Pierro
Can you try set PYTHONPATH? http://www.stereoplex.com/blog/understanding-imports-and-pythonpath On Wednesday, 16 May 2012 12:46:34 UTC-5, web2py_tn wrote: Actually I think the installation path is /usr/local/lib/ But where do I have to manually set it, in web2py? On Wed, May 16, 2012

[web2py] KeyError: 'float' when selecting records

2012-05-16 Thread wuelfhis asuaje
It only happens in version 1.99.7 in 1.99.1 works perfect Only happens when the table or (i don't know if model) has a float or decimal field That's what i ran: In [66]: rows = db().select(db.fc_pago.ALL) --- KeyError

[web2py] Re: KeyError: 'float' when selecting records

2012-05-16 Thread Massimo Di Pierro
Hello wuelfhis, Do you have 1.99.7 stable? I believe this has been fixed in trunk and in the nightly build. Can you try it? Massimo On Wednesday, May 16, 2012 4:42:55 PM UTC-5, wuelfhis asuaje wrote: It only happens in version 1.99.7 in 1.99.1 works perfect Only happens when the table or

[web2py] Re: KeyError: 'float' when selecting records

2012-05-16 Thread wuelfhis asuaje
Ok let me try !

[web2py] Re: KeyError: 'float' when selecting records

2012-05-16 Thread wuelfhis asuaje
Ok Massimo y tested with nightly build 1.99.7 and it's working know. Now,, what should i do? work with this version, wait to be corrected in stable, or what? Thanks

[web2py] Re: KeyError: 'float' when selecting records

2012-05-16 Thread wuelfhis asuaje
Ok Massimo y tested with nightly build 1.99.7 and it's working now. Now,, what should i do? work with this version, wait to be corrected in stable, or what? Thanks

[web2py] Updated slice: nginx and SCGI | Recipe | Web2py Slices - Recipes, Tutorials, Code, Questions

2012-05-16 Thread Michele Comitini
Changes: - keep-alive support from nginx. - secure https channel detection. - process management tip. http://www.web2pyslices.com/slice/show/1466/nginx-and-scgi tnx -- mic

  1   2   >