[web2py] mysql db connections

2013-05-26 Thread Saba
Hi, I have a question please regarding db connections and connection pooling in web2py. In models/db.py, I have a connect string like this: db=DAL('mysql...',pool_size=5) does model files get executed for every request? If so, then does it create the above db connection for every

[web2py] After update web2py version, invalid login.

2013-05-26 Thread toni campins
Hi, Why after update web2py i have to edit all passwords for invalid login? Thanks -- --- 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

Re: [web2py] After update web2py version, invalid login.

2013-05-26 Thread Marin Pranjić
From which version did you update? Marin On Sun, May 26, 2013 at 10:02 AM, toni campins toniul...@gmail.com wrote: Hi, Why after update web2py i have to edit all passwords for invalid login? Thanks -- --- You received this message because you are subscribed to the Google Groups

Re: [web2py] After update web2py version, invalid login.

2013-05-26 Thread toni campins
From 2.4.6 to 2.4.7 I think the problem is only in postresql database,in sqlite i have no problem. El domingo, 26 de mayo de 2013 10:23:26 UTC+2, Marin Pranjić escribió: From which version did you update? Marin On Sun, May 26, 2013 at 10:02 AM, toni campins

[web2py] Re: mysql db connections

2013-05-26 Thread Niphlod
nope. DAL retains a connection pool, opening at most pool_size connections. For threaded webservers, this means that every connection instantiate a new connection until pool_size is reached. Connections are then recycled (as opposed to trashed) for every new incoming request. For multiprocess

[web2py] Re: web2py 2.4.7 is Out

2013-05-26 Thread Niphlod
in hg to delete a bookmark hg tag --remove bookmark name in git instead its git tag -d bookmark name git push origin :refs/tags/bookmark name PS: github doesn't hold the new tag name yet. To propagate tags you have to issue git push origin --tags On Saturday, May 25, 2013 10:59:36 PM

Re: [web2py] Re: Testing your app using py.test

2013-05-26 Thread Arnon Marcus
Only for announcements that include links to the real announcement. Let's see: 2.4.7 is out: http://web2py.com/init/default/changelog (54 characters) 2.4.7 is out: pypy support, thanks Niphlod more bug fixes (57 characters) Obviously, for more verbose change-logs, a link can be

Re: [web2py] Re: Testing your app using py.test

2013-05-26 Thread Arnon Marcus
Thanks for explaining, Massimo. However, it seems that our common interest for a road-map, may not fit the way you operate - as you said, if developers don't need a feature, it will not be written. This nulls the possibility of web2py developers answering the needs of web2py users. I agree

Re: [web2py] Re: database shootout

2013-05-26 Thread Alexei Vinidiktov
I use Firebird with web2py but I often have problems migrating db schemas because of incorrect sql migration scripts that web2py issues. On Sat, Mar 9, 2013 at 1:04 AM, pjag pjagiel...@gmail.com wrote: web2py works nicely with Firebird DB. Highly recommended. On Thursday, March 7, 2013

[web2py] Re: web2py 2.4.7 is Out

2013-05-26 Thread LightDot
This should fix it nicely. Btw, I see jQuery 1.10.0 has been included in the trunk. This would probably be a good moment to also upgrade Bootstrap to 2.3.2. Should be a drop-in replacement for 2.2.2. Regards, Ales On Sunday, May 26, 2013 10:58:08 AM UTC+2, Niphlod wrote: in hg to delete a

Re: [web2py] Re: Testing your app using py.test

2013-05-26 Thread Anthony
Arnon, once again, we agree. It is true that *some* announcements are under 140 characters and that *all* announcements could be made by including a link to a longer announcement. But then you need a separate place for the linked longer announcements (such as Google Groups). Note, this very

Re: [web2py] Re: Testing your app using py.test

2013-05-26 Thread Anthony
However, it seems that our common interest for a road-map, may not fit the way you operate - as you said, if developers don't need a feature, it will not be written. This nulls the possibility of web2py developers answering the needs of web2py users. Arnon, I think you are somewhat

Re: [web2py] After update web2py version, invalid login.

2013-05-26 Thread Massimo Di Pierro
Do you get invalid invalid login for every account or only one? What id you revert only dal.py? Can you login? Massimo On Sunday, 26 May 2013 03:28:35 UTC-5, toni campins wrote: From 2.4.6 to 2.4.7 I think the problem is only in postresql database,in sqlite i have no problem. El

[web2py] Re: mysql db connections

2013-05-26 Thread Massimo Di Pierro
On Sunday, 26 May 2013 01:34:40 UTC-5, Saba wrote: Hi, I have a question please regarding db connections and connection pooling in web2py. In models/db.py, I have a connect string like this: db=DAL('mysql...',pool_size=5) does model files get executed for every request?

Re: [web2py] Re: database shootout

2013-05-26 Thread Massimo Di Pierro
Can you tell us more. I believe firebird does not support multiple alter tables in transaction and that is cause of some problems. Make sure you always mgrate one table at the time. On Sunday, 26 May 2013 06:24:49 UTC-5, Alexei Vinidiktov wrote: I use Firebird with web2py but I often have

[web2py] TypeError

2013-05-26 Thread webpypy
Hi, the statement form = SQLFORM(db.table) is giving the error unbound method formatter() must be called with IS_NOT_EMPTY instance as first argument (got str instance instead) Please, explain. regards, Ashraf -- --- You received this message because you are subscribed to the Google

[web2py] Re: TypeError

2013-05-26 Thread Anthony
Can you show the db.table definition? On Sunday, May 26, 2013 10:14:18 AM UTC-4, webpypy wrote: Hi, the statement form = SQLFORM(db.table) is giving the error unbound method formatter() must be called with IS_NOT_EMPTY instance as first argument (got str instance instead) Please,

[web2py] Re: TypeError

2013-05-26 Thread webpypy
Here it is db.define_table( 'location', Field('name' , requires = IS_NOT_EMPTY), Field('category_id', 'reference category', requires = IS_NOT_EMPTY), Field('company_id', 'reference company', requires = IS_NOT_EMPTY,label = 'Owner id '), Field('user_id',

[web2py] Re: TypeError

2013-05-26 Thread webpypy
when I added the fields, as in form = SQLFORM(db.location, fields=['name']) if form.process().accepted: it worked, but stopped at the next statement, giving the error 'IS_NOT_EMPTY' object is not iterable -- --- You received this message because you are subscribed to the Google

[web2py] Re: TypeError

2013-05-26 Thread webpypy
On Sunday, May 26, 2013 5:14:18 PM UTC+3, webpypy wrote: Hi, the statement form = SQLFORM(db.table) is giving the error unbound method formatter() must be called with IS_NOT_EMPTY instance as first argument (got str instance instead) Please, explain. regards, Ashraf -- ---

[web2py] Re: Session variables disappearing

2013-05-26 Thread Rob Mayhue
You say your app users were logged in but after a given time the _load_settings function stopped working (stopped storing data)? The _load_settings() function is only called once, right after the user logs in using auth.settings.login_onaccept.append(). The idea was to store certain

[web2py] Re: web2py 2.4.7 is Out

2013-05-26 Thread Mika Sjöman
I agree I think it confuses people allot who are starting with web2py since many try to use online themes, but they break because web2py uses an old version of bootstrap. Cheers On Sunday, May 26, 2013 7:33:59 PM UTC+8, LightDot wrote: This should fix it nicely. Btw, I see jQuery 1.10.0

[web2py] Dropboxing movies into Web2py Server?

2013-05-26 Thread Mika Sjöman
Hi We are trying to set up our production flow so that the guys making small instructional movies will automatically upload them to our server with dropbox. My question is how I can get those movies into a database automatically with the filename as the description into a Field('Description')

[web2py] Re: Dropboxing movies into Web2py Server?

2013-05-26 Thread Mika Sjöman
forgot to add that our server is a ubuntu server... Cheers On Monday, May 27, 2013 1:52:59 AM UTC+8, Mika Sjöman wrote: Hi We are trying to set up our production flow so that the guys making small instructional movies will automatically upload them to our server with dropbox. My question

[web2py] Re: TypeError

2013-05-26 Thread webpypy
when I changed the table definition to db.define_table( 'location', Field('name' ), Field('category_id', 'reference category'), Field('company_id', 'reference company' ,label = 'Owner id '), Field('user_id', 'reference auth_user',writable = False , readable

Re: [web2py] After update web2py version, invalid login.

2013-05-26 Thread toni campins
I get invalid login for every acount. -- --- 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+unsubscr...@googlegroups.com. For more options, visit

Re: [web2py] Re: web2py 2.4.7 is Out

2013-05-26 Thread Marin Pranjić
looks like bootstrap 2.3.2 fixed few issues but introduced more On Sun, May 26, 2013 at 7:42 PM, Mika Sjöman mikasjo...@gmail.com wrote: I agree I think it confuses people allot who are starting with web2py since many try to use online themes, but they break because web2py uses an old

[web2py] Re: IDE edit function doesn't work on ipad ?

2013-05-26 Thread Maxxy
Me too. web2py editor doesnt wotk on my ipad and neither on iPhone. web2py it's almost perfect but I do need to edit my file on the go. Is there any workaround or any roadmap to address this problem? Maxx -- --- You received this message because you are subscribed to the Google Groups

[web2py] Admin is Temporarily down for maintenance on PythonAnywhere

2013-05-26 Thread Phil
I shutdown my admin process in the web2py web app on my PythonAnywhere account. So now it saysTemporarily down for maintenance when I try to go to it. I know I can destroy the site and rebuild it to fix this. But is there a way to restart admin otherwise? -- --- You received this message

[web2py] Re: Dropboxing movies into Web2py Server?

2013-05-26 Thread Alan Etkin
We are trying to set up our production flow so that the guys making small instructional movies will automatically upload them to our server with dropbox. My question is how I can get those movies into a database automatically with the filename as the description into a

Re: [web2py] Re: Testing your app using py.test

2013-05-26 Thread Arnon Marcus
I think that we fail to communicate because we have different un-spoken assumptions. Let's take the following sentence as an example for what I mean by that: less expert users should work on the easy tasks (that they can do), even if it takes them a bit longer, leaving the more expert users to

[web2py] Re: Dropboxing movies into Web2py Server?

2013-05-26 Thread Niphlod
if I understood correctly what you need is just something that updates a table whenever a new file pops up into your dropbox folder (that receives yet the files). Just schedule something that lists all contents of a directory and update your table accordingly, let's say every minute. Scheduler

[web2py] Re: mysql db connections

2013-05-26 Thread Saba
Thanks for the reply. I really appreciate. I'm developing an app using web2py to pull up records from mysql db and present it to the user using custom views. It looks like sometimes it takes 1sec to display the records to the user (i'm the only user now) but other times it takes around

[web2py] help with functions index

2013-05-26 Thread André Kablu
Hi all, I have been adventuring myself with web2py for some months now, just to learn it, and I am enjoying very much. web2py is an awesome MVC. However it is my first time with python (yes I am only using python now b/c of web2py :D ), and I am missing so much some kind of functions index for

[web2py] Error on start: 'Auth' object has no attribute 'wikimenu'

2013-05-26 Thread jfinke
I just downloaded the mac version of web2py. When I start the server with a password, I immediately get an error ticket. Error ticket for welcomeTicket ID 127.0.0.1.2013-05-26.17-23-02.b3d13a3c-4b2c-445a-a4cf-2722911fae41 type 'exceptions.AttributeError' 'Auth' object has no attribute

Re: [web2py] Re: No module named PIL

2013-05-26 Thread smoggy
In my code i use: import Image On Saturday, May 25, 2013 10:11:38 PM UTC+1, Massimo Di Pierro wrote: web2py source yes. PIL you do not install from source on windows because it includes binary modules that must be compiler. You must get the binary module. On Saturday, 25 May

Re: [web2py] Re: Memory leak, SQLite, Windows (7, 2008)

2013-05-26 Thread Simon Ashley
Thanks, that's good to know ... -- --- 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+unsubscr...@googlegroups.com. For more options, visit

Re: [web2py] Re: Testing your app using py.test

2013-05-26 Thread Anthony
Arnon, it is more than a little frustrating having a discussion with you, as it appears you don't really pay much attention to what others are saying. If you go back, you will see I have already addressed your argument. You are correct that we make different assumptions, but the differences

[web2py] Re: help with functions index

2013-05-26 Thread Anthony
globals()http://docs.python.org/2/library/functions.html?highlight=globals#globalsis a Python built-in function that returns a dictionary of objects in the current global environment. You can use it to check whether a particular object name exists in the current environment to avoid generating

[web2py] Re: Admin is Temporarily down for maintenance on PythonAnywhere

2013-05-26 Thread Massimo Di Pierro
What did you do? check is there is an applications/admin/DISABLED file. If there is, remove it. On Sunday, 26 May 2013 12:54:59 UTC-5, Phil wrote: I shutdown my admin process in the web2py web app on my PythonAnywhere account. So now it saysTemporarily down for maintenance when I try to go

Re: [web2py] After update web2py version, invalid login.

2013-05-26 Thread Massimo Di Pierro
What id you revert only dal.py? Can you login? On Sunday, 26 May 2013 13:24:58 UTC-5, toni campins wrote: I get invalid login for every acount. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop

[web2py] Login with ID rather than email?

2013-05-26 Thread Alec Taylor
Is it possible to login to web2py by ID rather than by email? Thanks for all information, Alec Taylor -- --- 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

Re: [web2py] Login with ID rather than email?

2013-05-26 Thread Marco Mansilla
El Mon, 27 May 2013 13:00:11 +1000 Alec Taylor alec.tayl...@gmail.com escribió: Is it possible to login to web2py by ID rather than by email? Thanks for all information, Alec Taylor if you mean something like username yes... and there are some ways to hardcode the behaviour for this

Re: [web2py] Login with ID rather than email?

2013-05-26 Thread Massimo Di Pierro
auth.define_tables(username=True) On Sunday, 26 May 2013 22:41:09 UTC-5, marco mansilla wrote: El Mon, 27 May 2013 13:00:11 +1000 Alec Taylor alec.t...@gmail.com javascript: escribió: Is it possible to login to web2py by ID rather than by email? Thanks for all information,

[web2py] Re: After update web2py version, invalid login.

2013-05-26 Thread Massimo Di Pierro
This is a serious issue. Anybody else having this problem can help us reproduce it? Massimo On Sunday, 26 May 2013 03:02:02 UTC-5, toni campins wrote: Hi, Why after update web2py i have to edit all passwords for invalid login? Thanks -- --- You received this message because you are

[web2py] Re: jquery mobile: popup calendar does not always appear

2013-05-26 Thread Rowdy
On 24/04/2013 10:02 AM, Rowdy wrote: Greetings, I am developing a desktop/mobile application using web2py 2.4.6 (currently hosted on CentOS 6.4 with Python 2.6.6, web2py running from source). If I have an SQLFORM containing a date field, when I tap on the field on a mobile device the popup

[web2py] Re: After update web2py version, invalid login.

2013-05-26 Thread toni campins
With another machine,and update from 2.4.6 to 2.4.7 no problem in postgresql database in localhost. If I can reproduce the error again I'll alert. Thanks On Monday, May 27, 2013 7:15:53 AM UTC+2, Massimo Di Pierro wrote: This is a serious issue. Anybody else having this problem can help us