[web2py] Upgrading web2py 1.99.7 to 2.3.2 on ubuntu

2013-02-07 Thread at
Hi, Currenty we are usnig web2py (1.99.7) + apache + ssl + mod_wsgi + postgresql on ubuntu on production and development servers. Before we upgrade to latest stable version i.e. 2.3.2 on production, we want to run both old and latest versions side-by-side on development servers. What should be

[web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-02-07 Thread dederocks
Hello, I have setup nginx uwsgi on lubuntu with the script and it works great (best server ever!), except for a part of my application that requires multi threads. I have changed the /etc/uwsgi/web2py.xml to enable threads, tried to set each worker with 2 threads, set the thread memory stack

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-02-07 Thread Roberto De Ioris
Hello, I have setup nginx uwsgi on lubuntu with the script and it works great (best server ever!), except for a part of my application that requires multi threads. I have changed the /etc/uwsgi/web2py.xml to enable threads, tried to set each worker with 2 threads, set the thread memory

[web2py] Re: Real Python for Web Development, featuring web2py

2013-02-07 Thread Michael Herman
Hi All - So I posted an update to the KickStarter earlier. I 100% agree about the blog/wiki-type examples - it's done too much. I am going to open up a survey next week to see what people would like to see developed. In the meantime, email or message me with your ideas about what you'd like

[web2py] Re: How to dont show seconds in a time field

2013-02-07 Thread DenesL
On Thursday, February 7, 2013 2:53:50 AM UTC-5, Gerd wrote: Am Donnerstag, 7. Februar 2013 00:20:02 UTC+1 schrieb DenesL: On Wednesday, February 6, 2013 8:24:01 AM UTC-5, Gerd wrote: Hi Annet and DenesL! @DenesL: Yes, did restart it, nothings changed True. Note that the input will

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-02-07 Thread dederocks
AWSOME! Thank you so much for the fix and explanation! Best regards, Andre Le jeudi 7 février 2013 10:11:19 UTC+1, Roberto De Ioris a écrit : Hello, I have setup nginx uwsgi on lubuntu with the script and it works great (best server ever!), except for a part of my application that

[web2py] Re: Background M2M communication

2013-02-07 Thread Massimo Di Pierro
Good point. yes you should close it but how and why depends on your protocol and how you use the function. On Wednesday, 6 February 2013 20:19:31 UTC-6, Bernard wrote: Thanks, it works. Do I have to worry about s.close()? On Wednesday, February 6, 2013 6:12:06 PM UTC-8, Massimo Di Pierro

[web2py] Re: How to dont show seconds in a time field

2013-02-07 Thread Gerd
Am Donnerstag, 7. Februar 2013 10:56:31 UTC+1 schrieb DenesL: On Thursday, February 7, 2013 2:53:50 AM UTC-5, Gerd wrote: Am Donnerstag, 7. Februar 2013 00:20:02 UTC+1 schrieb DenesL: On Wednesday, February 6, 2013 8:24:01 AM UTC-5, Gerd wrote: Hi Annet and DenesL! @DenesL: Yes,

[web2py] Custom form won't submit.

2013-02-07 Thread Andrew Buchan
Hello, I'm using a form.custom, but clicking on submit doesn't trigger validation or submission. The page just refreshes. The code below always results in 'dont know' at the response.flash... Controller: ... fields = [..] request_details_form = SQLFORM(db.capacity_request,

Re: [web2py] Re: Autoincrement field

2013-02-07 Thread Alec Taylor
Optionally you can define a field of `type='id'` and web2py will use this field as auto-increment id field. This is not recommended except when accessing legacy database tables. With some limitation, you can also use different primary keys and this is discussed in the section on Legacy databases

[web2py] Re: 2.2.1 auth.wiki() automatically adds users to wiki_editor group. Bug or feature?

2013-02-07 Thread Michael Beller
I noticed in the documentation that there should also be an 'everybody' group (which I did not have). I thought that maybe if that group did not exist users are added to 'wiki_editor' by default but adding 'everybody' group did not fix the problem. Anybody else having this issue? On Tuesday,

[web2py] Re: Auth with Wordpress

2013-02-07 Thread Michael Haas
Hello Kenneth, But how do I handle that WP takes care of authentication and somehow gives the customer rights to view the manual. I had a similar problem. I added an XMLRPC method to my wordpress instance to check if a given username/password combination is valid and added an auth

[web2py] One database field, two form fields? From seconds to min:sec

2013-02-07 Thread Michael Haas
Hello all, I'm writing a web app where people can log their exercise sessions. Basically, sessions are timed, and the faster the better. To this end, I store seconds in my model: Field('f_record_taken', type='date',notnull=True,default=datetime.date. today(), label=T('Record

[web2py] adding elements to auth.register()

2013-02-07 Thread Fabiano Faver
I would like to implement the example of http://web2py.com/books/default/chapter/29/07#Adding-extra-form-elements-to-SQLFORM inside auth.register form. Then try to validate if its checked. auth.settings.register_onvalidation = checkaceito And I set that users need approval to login:

Re: [web2py] Upgrading web2py 1.99.7 to 2.3.2 on ubuntu

2013-02-07 Thread Richard Vézina
Do you have a limitation, why would you put 2 version of web2py on the same machine... I would create an other VM with the new stuff! You could use the same database if you want pointing the postgres of the old version of web2py... Richard On Thu, Feb 7, 2013 at 4:06 AM, at matifa...@gmail.com

[web2py] Re: Image store with open does not work on GAE

2013-02-07 Thread Sebastian Cambeo
unfortunately not: TRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. Traceback (most recent call last): File *\restricted.py, line 212, in restricted exec ccode in environment File */applications/welcome/models/db.py http://localhost/admin/default/edit/welcome/models/db.py, line 90,

[web2py] Bug in database administration

2013-02-07 Thread Calycé
Hi all, I have an error in the database administration when using the following code in db.py: db.define_table('cgc_service_categories', Field('category', 'string', required=True), Field('description', 'text', required=True), Field('image', 'upload', required=True),

[web2py] Re: How to dont show seconds in a time field

2013-02-07 Thread Annet
Hi Denes, I'd like to use your solution to replace the 2009 one I am using right now. However, put these lines of code in db.py script=SCRIPT('jQuery(document).ready(function(){jQuery(input.mytime).timeEntry({showSeconds:false});});') timewidget=lambda field,value:

[web2py] web2pyhl7 demo not available at web2py.com

2013-02-07 Thread Alan Etkin
There are some links with introduction to web2py with the following demo link: http://web2py.com/HLv3 but the server returns invalid request Maybe the server could redirect to the project page if the demo is no longer available. -- --- You received this message because you are subscribed

[web2py] Re: Custom form won't submit.

2013-02-07 Thread Massimo Di Pierro
{{request_details_form.custom.end}} should be {{=request_details_form.custom.end}} On Thursday, 7 February 2013 05:58:45 UTC-6, Andrew Buchan wrote: Hello, I'm using a form.custom, but clicking on submit doesn't trigger validation or submission. The page just refreshes. The code below

[web2py] Re: 2.2.1 auth.wiki() automatically adds users to wiki_editor group. Bug or feature?

2013-02-07 Thread Massimo Di Pierro
The documentation needs to be fixed. There are two different everybody. In Wiki if you set manage_permissions=True you can use a group everybody to set permissions on wiki pages. This group is not really created but just a dummy. It tells the wiki the page can be accessed by everybody. In Auth

[web2py] Re: Bug in database administration

2013-02-07 Thread Massimo Di Pierro
This is not a bug but a limitation in syntax: You cannot do: db.define_table('cgc_schedule', ... format='%(training.short_title)s (%(training_date)s)') because only fields of the table itself can be used in the representation of a record. In order to retrieve training.short_title for a

[web2py] Re: web2pyhl7 demo not available at web2py.com

2013-02-07 Thread Massimo Di Pierro
I have taken down some legacy apps since we are moving the server to python anywhere. On that server I do not have too much flexibility to configure the web server. May be easier to fix the source of links. On Thursday, 7 February 2013 09:44:49 UTC-6, Alan Etkin wrote: There are some links

[web2py] Re: Bug in database administration

2013-02-07 Thread Calycé
I found a solution/workaround. For the records, I changed the format for the table cgc_schedule. Old one: format='%(training.short_title)s (%(training_date)s)' New one: format=lambda row: row.training.short_title + ' (' + row.training_date. strftime('%d-%m-%Y') + ')' With that new format, it

[web2py] Re: Bug in database administration

2013-02-07 Thread Calycé
oops, looks like you were faster than me ;-) Anyway thanks for your help. On Thursday, February 7, 2013 5:39:24 PM UTC+1, Massimo Di Pierro wrote: This is not a bug but a limitation in syntax: You cannot do: db.define_table('cgc_schedule', ... format='%(training.short_title)s

[web2py] Re: Image store with open does not work on GAE

2013-02-07 Thread Alan Etkin
Field('image', 'upload'), Why two upload fields? Shouldn't the first table have a blob type field? -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to

[web2py] Inconsistent smartgrid behavior for reference field links

2013-02-07 Thread Michael Beller
smartgrid creates links for reference fields if linked_tables is not specified but does not if linked_tables is specified. I have a test model with Owner and Dog and a test function for manage_owners with a smartgrid: form = SQLFORM.smartgrid(db.t_owner), linked_tables=['t_dog']) If you

[web2py] Re: web2pyhl7 demo not available at web2py.com

2013-02-07 Thread Alan Etkin
I have taken down some legacy apps since we are moving the server to python anywhere. ... (visited) places where to change the reference: Project page: http://code.google.com/p/web2pyhl7/ Python users (Argentina) http://python.org.ar/pyar/PreguntasFrecuentes Wikipedia (es)

[web2py] Re: 2.2.1 auth.wiki() automatically adds users to wiki_editor group. Bug or feature?

2013-02-07 Thread Michael Beller
Thank you for the clarification but I don't think that addresses the problem that every new user is added to wiki_editor group. I saw earlier in this thread there was a fix but I'm still experiencing that problem. Is there something else I should check? On Thursday, February 7, 2013 11:32:30

[web2py] Re: How to dont show seconds in a time field

2013-02-07 Thread DenesL
On Thursday, February 7, 2013 10:36:01 AM UTC-5, Annet wrote: Hi Denes, I'd like to use your solution to replace the 2009 one I am using right now. However, put these lines of code in db.py

Re: [web2py] Re: Auth with Wordpress

2013-02-07 Thread Kenneth Lundström
Hi Michael, Am I understanding you solution completly wrong but isn't it so that web2py asks WP if a username and password compination is OK. In my case customer first logs into a WP site, he gets a list of manuals he has paid for. When selecting a manual he wants to read he is sent to a

[web2py] Re: web2pyhl7 demo not available at web2py.com

2013-02-07 Thread Alan Etkin
Python users (Argentina) http://python.org.ar/pyar/PreguntasFrecuentes Done. For now, changed to ar.pycon.org/2012 (is a link to an example of application made with web2py) Wikipedia (es) http://es.wikipedia.org/wiki/Web2py Changed to project page -- --- You received this message

[web2py] Re: How to dont show seconds in a time field

2013-02-07 Thread Annet
Hi Denes, I no longer get the error message when a user enters for example 09: so only the hours not the minutes. How would I have to adjust your code to validate the time? It should not be possible to enter just 09: , jQuery.timeEntry will not allow that to happen. It only allows

[web2py] .delete()

2013-02-07 Thread Annet
If db(db.eventList.nodeID==id) is empty will db(db.eventList.nodeID==id).delete() result in an error? Best regards, Annet -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it,

Re: [web2py] Upgrading web2py 1.99.7 to 2.3.2 on ubuntu

2013-02-07 Thread at
Thanks for your reply. Actually we want to keep apache+ssl+mod_wsgi+postgres installations as they are. Keeping them unchanged what should be the right approach to run same applications side-by-side on both old and new versions of web2py? Our servers are in amazon cloud. Thanks Regards On

[web2py] Re: .delete()

2013-02-07 Thread Anthony
It should just return 0 (indicating that 0 records were deleted). Anthony On Thursday, February 7, 2013 1:38:34 PM UTC-5, Annet wrote: If db(db.eventList.nodeID==id) is empty will db(db.eventList.nodeID==id).delete() result in an error? Best regards, Annet -- --- You received this

[web2py] Re: Image store with open does not work on GAE

2013-02-07 Thread Massimo Di Pierro
Clearly something is not working as intended. There are two cases here: 1) the blob is saved in the same table as the unload field: db.define_table('table1', Field('image', 'upload'), ) In this case the blob field is created automatically. 2) the blob is created in a separate table:

[web2py] Re: 2.2.1 auth.wiki() automatically adds users to wiki_editor group. Bug or feature?

2013-02-07 Thread Massimo Di Pierro
Not every user is added to wiki_editor. Only if the user is logged into admin. You are probably testing this by logging out from the app and creating multiple accounts. You need to do this while not logged into admin. I agree that this behavior is annoying when testing but if a user a a system

[web2py] Re: How to dont show seconds in a time field

2013-02-07 Thread DenesL
Hi Annet, to make the widget safer we could do: timewidget=lambda field,value: TAG[''](SQLFORM.widgets.time.widget(field, value.strftime('%H:%M') if hasattr(value,'strftime') else '', _class='mytime'),script) but I still don't understand how you can submit a value of 09: that input is just

Re: [web2py] Re: how to support video in an app

2013-02-07 Thread Tito Garrido
How to set the width and height of the embed video using expand_one? On Sat, Feb 2, 2013 at 12:00 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Sorry my bad: {{=XML(expand_one('http://www.**youtube.com/watch?v=**

Re: [web2py] Upgrading web2py 1.99.7 to 2.3.2 on ubuntu

2013-02-07 Thread Niphlod
ideally you should have 2 locations (your choice for them to be domain-related or folder related , i.e. domain.com/domain2.com vs domain.com/first/ domain.com/second) and have separate wsgiscriptaliase directives, one pointing to old and the other pointing to new web2py folders. On Thursday,

[web2py] Re: How to handle one-to-many relationship with sqlform and checkboxes?

2013-02-07 Thread bracquet
I am getting an error when using list:reference and the checkbox widget: db.define_table('person', Field('name', requires=IS_NOT_EMPTY()), Field('dogs', 'list:reference dog')) db.define_table('dog', Field('name', requires=IS_NOT_EMPTY())) db.person.dogs.widget =

Re: [web2py] Re: Auth with Wordpress

2013-02-07 Thread Michael Haas
Am Donnerstag, 7. Februar 2013 19:13:41 UTC+1 schrieb Kenneth: Am I understanding you solution completly wrong but isn't it so that web2py asks WP if a username and password compination is OK. In my case customer first logs into a WP site, he gets a list of manuals he has paid for.

[web2py] Re: How to handle one-to-many relationship with sqlform and checkboxes?

2013-02-07 Thread bracquet
Nevermind, I just figured it out. I had to define the dog table prior to the person table. Although I thought this wouldn't be a problem according to the web2py book. However, the form now displays this weird disable input box along with the list of dog checkboxes: input class=hidden

[web2py] Problem with difficult query

2013-02-07 Thread Jake Lowen
Thanks for a great framework. I'm loving web2py, but I just encountered a difficult query One query generates a list of people. Each of those persons has 0 to many reports filed about them. I wanted to see only the newest report on each person AND I want to see Null or None if no reports have

[web2py] Re: Example JSON Code

2013-02-07 Thread pal4rp
Here's the top of the html file, the Javascript function and the Python file. Started using the *jsonp-2.4.0.min.js* script because it appears to handle errors better. I've just jumped into Web2py so I don't know if I'm building the URL properly. This returns: *errMsg =Uncaught Error.*

[web2py] Re: Problem with difficult query

2013-02-07 Thread Jake Lowen
If it helps, here is how I can get the desired result in raw SQL: SELECT * FROM benchmark_targets t2 LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC)t1 ON t2.KPID = t1.KPID; Now how to do it in DAL? -- --- You received this message because you are subscribed to

[web2py] Re: Problem with difficult query

2013-02-07 Thread Jake Lowen
Forgot the WHERE in my SQL statement. Should be: SELECT * FROM benchmark_targets t2 LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC)t1 ON t2.KPID = t1.KPID WHERE t2.benchmark = 10; -- --- You received this message because you are subscribed to the Google Groups

[web2py] Re: Problem with difficult query

2013-02-07 Thread Jake Lowen
I'm only talking to myself here, but the notes are helpful... This is how I get the desired result in web2py using the executesql command: foo = db.executesql('SELECT * FROM benchmark_targets AS t2 LEFT JOIN (SELECT * from lobby_report GROUP BY KPID ORDER BY datetime DESC) AS t1 ON t2.KPID =

Re: [web2py] Re: Auth with Wordpress

2013-02-07 Thread Derek
I guess you could have wordpress set a cookie of some sort if they have access, and then use that cookie in web2py to control access. On Thursday, February 7, 2013 11:13:41 AM UTC-7, Kenneth wrote: Hi Michael, Am I understanding you solution completly wrong but isn't it so that web2py

[web2py] Re: Example JSON Code

2013-02-07 Thread howesc
get_days is not a valid url. /get_days might be depending on your routing. for the purposes of getting things working you should put in the fully qualified URL like http://test.exmaple.com/app/json_test/get_days cfh On Thursday, February 7, 2013 2:12:34 PM UTC-8, pal...@gmail.com wrote:

[web2py] Integrating iPhone device tokens into web2py auth

2013-02-07 Thread chris_g
I'm looking into supporting Apple push notifications in an iPhone app that connects to a web2py server. In order to know which devices to push details to, web2py's auth module would presumably need to maintain Device Tokens. I'm curious if anyone has implemented a solution that takes care of

[web2py] Re: Problem with difficult query

2013-02-07 Thread Jake Lowen
Solved: It was a dumb mistake.. I was trying to group by a field in the left join table.. so of course it was eliminating all records not found in the second table. I switched the group by to a first table field and all is well. Final working query was: foo =

[web2py] Minimum period in web2py Scheduler

2013-02-07 Thread Bernard
I am using the web2py scheduler to run a task periodically, with a single worker thread. The task is configured to run an infinite number of times. If I set the task period to 1 second, I can verify that the task is being run in the scheduler_run table, but the run_time indicates it is running

[web2py] Re: Scheduler Quick question

2013-02-07 Thread Tim Richardson
Well there are definitely some experts here, but this is what I understand: 1) the scheduler should run as a completely detached process. 2) Windows, OS X linux have ways of doing this via task schedulers or startup scripts (often the task scheduler has an option that means run at startup).

[web2py] negative ID values in the ID field break use of format in SQLFORM.grid

2013-02-07 Thread Tim Richardson
Using 2.3.2 with MSQL, I have a table T1 where the primary key is ID (migrate=false) Most values have ID 0 but I have two special cases where the ID is 0 T1 uses format to make a friend display of the primary key. Then this table is referred to in another table T2 using reference. When I

[web2py] field defined as requires IS_IN_SET defaults to blank on sqlform.grid edit

2013-02-07 Thread Tim Richardson
I have a field defined as Field('item_type','string',requires=IS_IN_SET(['Procedure','Consultation'])) db1.define_table('com_tier1',Field('item_nbr','string'),Field('doctorID','reference doctor'), Field('cmsn_pct','decimal(18,4)',requires = IS_DECIMAL_IN_RANGE(-1,1)), Field('cmsn_set',

[web2py] Re: field defined as requires IS_IN_SET defaults to blank on sqlform.grid edit

2013-02-07 Thread Tim Richardson
And an espresso later ... the reason is that my table was defined as char(50) not varchar(50), so the values where gettings spaces at the end, and were therefore failing the validation when trying to display the row. -- --- You received this message because you are subscribed to the Google