[web2py] No translation of 'file' in the UploadWidget

2012-08-18 Thread Martin Weissenboeck
Using the UploadWigdet the word 'file' cannot be translated. I think this looks unprofessional. I found (1) Change line 2423, sqlhtml.py to elif field.type == 'upload': if upload and r: r = A(*current.T('file'*), _href='%s/%s' % (uploa

[web2py] Re: Where to host web2py

2012-08-18 Thread Mike Girard
Hi Simon: I know from having reviewed the trail on this issue in this group that other members have been successful in getting web2py working on Webfaction and hostgator. Webfaction in particular seems to get high marks and their service seems to have some VPS-like features, though it is not V

[web2py] Re: global name 'psycopg2_adapt' is not defined

2012-08-18 Thread Mike Girard
In case anyone else encounters problems installing psycopg2 on a Mac. The problem was created by outdated libcrypto and libssl lib files in /usr/lib. Fixed the problem by copying the newer files from PostgreSQL/9.1/lib, deleting aliases pointing at the old files and creating new ones to replac

[web2py] Re: How to use mysql on GAE?

2012-08-18 Thread howesc
db = DAL('google:sql://realm:domain/database') realm, domain, and database are all values from when you setup your google cloud SQL account. see https://developers.google.com/cloud-sql/docs/before_you_begin On Friday, August 17, 2012 4:25:42 PM UTC-7, Pystar wrote: > > > I know that GAE suppor

[web2py] Re: Route to static file fails on App Engine

2012-08-18 Thread howesc
hrm.i've not used the 'r' in my routesi just put the strings in and it seems to do what i want. on GAE you might rather do this in app.yaml as you save yourself loading web2py to serve a static file. cfh On Friday, August 17, 2012 8:14:08 PM UTC-7, spiffytech wrote: > > I'm trying to m

Re: [web2py] Re: Web2py GAE strange error [Errno 13] file not accessible: (jQuery.js)

2012-08-18 Thread howesc
yes i use modules, and current, but in the form of: from gluon import current def module_func(): if current.request.args: do something return that is threadsafe right? in either case, when i had the problems reported in the other thread i was not using current in modules. On Satur

Re: [web2py] Where to host web2py

2012-08-18 Thread Curiouslearn
Bruno, Can you please comment on how your Linode instances compare with pythonanywhere in terms of responsiveness and speed? Are you saying that you would use PAW because of their awesome customer service, prices, ease of hosting, or do you also find the application performance better on PAW? Tha

Re: [web2py] Where to host web2py

2012-08-18 Thread Curiouslearn
Hi Simon, As Bruno has mentioned it is very easy to get your app on Pythonanywhere. They have great customer service and, hence they are a good possible option. The only problem is that currently the hosting on Pythonanywhere is kind of slow. But I suppose that will be fixed once they move to ngin

[web2py] Re: global name 'psycopg2_adapt' is not defined

2012-08-18 Thread Mike Girard
Apparently there is something wrong with my installation of the driver. Going to see if I can sort that before coming back. Consider this closed. On Saturday, August 18, 2012 8:16:36 PM UTC-4, Mike Girard wrote: > > I am attempting to move from SQLLite to Postgres because I was having > table l

[web2py] global name 'psycopg2_adapt' is not defined

2012-08-18 Thread Mike Girard
I am attempting to move from SQLLite to Postgres because I was having table locking issues.. I downloaded and installed Postgres and the Psycopg2-2.4.5. They work. I am able to administer Postgres and the installation of the driver was uneventful. I first encountered the self-drivers error (

Re: [web2py] Where to host web2py

2012-08-18 Thread Bruno Rocha
http://rochacbruno.com.br/web2py-on-pythonanywhere/ --

Re: [web2py] Where to host web2py

2012-08-18 Thread Bruno Rocha
I use Linode (1024 and 2048 instances) powered by NGINX and UWSGI. Also I am now hosting web2pyslices.com sponsored by http://pythonanywhere.com, I have plans to move to Python Anywhere when they release the PRO plan with Postgres. But if did not needed postgres, I would like to use PythonAnywher

[web2py] Where to host web2py

2012-08-18 Thread Simon Carr
After a few weeks of getting to know web2py i have decided that it should become one of the development tools in my tool belt. The only thing that is stopping me moving on however is hosting options. I am going to take a look at app engine as one option but i need to know that i can also deplo

[web2py] Re: Latest trunk and saving source from web browser problem ... 'Last saved on: communication error'

2012-08-18 Thread Massimo Di Pierro
I believe this is now fixed. Please check it. On Saturday, 18 August 2012 14:48:46 UTC-5, Pystar wrote: > > +1. Yes, noticed it too. > > On Saturday, August 18, 2012 11:42:33 AM UTC+1, David Marko wrote: >> >> When editing app source from web interface there is a problem while >> saving ...I'm

Re: [web2py] NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread Marin Pranjić
If you set run parameters to: -a password You will not get gui popup On Aug 18, 2012 9:56 PM, "thinkwell" wrote: I've set web2py.py as debug file, but it's irritating to have the gui pop open all the time. Also, the TK server window refuses to close after I stop debugging, so after a time there'

Re: [web2py] Re: Scheduler: help us test it while learning

2012-08-18 Thread Yarin
OK i didn't understand that retries happened periodically- i indeed thought that it would retry right away, though i agree with you that that should be handled at the function level. But if we're handling failures within the scheduled function, then now im wondering what is the value in having

Re: [web2py] Re: Where should I put functions that are useful/common to muliple applications?

2012-08-18 Thread Anthony
> > Cliff, I will definitely look up on the topic of MySQL injection > attacks. Does using DAL better protect me against such attacks? > The DAL automatically protects against SQL injection. You can do it on your own as well. Note, the DAL is needed for SQLFORMs, Auth, and SQLFORM.grid. The DA

Re: [web2py] Re: Scheduler: help us test it while learning

2012-08-18 Thread Niphlod
Ok, got the example. Let's start saying that your requirements can be fullfilled (simply) decorating your function in a loop and break after the first successful attempt (and repeats=0, retry_failed=-1). Given that, the current behaviour is not properly a limit to what you are trying to achieve,

Re: [web2py] NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread Anthony
You might also try: if 0: from gluon import * That will tell the IDE about all the web2py global objects that get added to the execution environment (they're all exposed in /gluon/__init__.py). Anthony On Saturday, August 18, 2012 3:56:53 PM UTC-4, thinkwell wrote: > > I've set web2py.py as de

Re: [web2py] Re: Web2py GAE strange error [Errno 13] file not accessible: (jQuery.js)

2012-08-18 Thread Massimo Di Pierro
Do you use modules? Do you do anything like from gluon import current request = current.request # very very thread unsafe!!! Massimo On Saturday, 18 August 2012 11:27:31 UTC-5, howesc wrote: > > i agree that it is GAE specific. i've never had a problem elsewhere. > > On 8/17/12 22:19 , Massi

Re: [web2py] Re: Major speed improvement need testers

2012-08-18 Thread Massimo Di Pierro
As Bruno says. Something like this will completely nullify the benefit of lazy tables. Field(..., readable=True) is OK but db.table.field.readable=True is BAD because will force db.table to be instantiated. Massimo On Saturday, 18 August 2012 08:45:45 UTC-5, rochacbruno wrote: > > What about

Re: [web2py] Re: Scheduler: help us test it while learning

2012-08-18 Thread Yarin Kessler
And the reason i think the behavior's inconsistent is because when you complete an attempt on a repeating task it is immediately requeued to fulfill its repeat obligations, and the last go-around is forgotton- so i think failures should be handled the same way. On Sat, Aug 18, 2012 at 4:32 PM, Yar

Re: [web2py] Re: Scheduler: help us test it while learning

2012-08-18 Thread Yarin Kessler
I think retry_failed and repeats are two distinct concepts and shouldn't be mixed. For example, a task set to (repeats=0, retry_failed=0, period=3600) should be able to fail at 2:00pm, but will try again at 3:00pm regardless of what happened at 2:00. Likewise, if it was set to (repeats=0, retry_f

[web2py] Re: DAL field rules and form constraints

2012-08-18 Thread Niphlod
I remember something about adding a unique=True after "the first time" did not actually enforced at the db level the costraint. Can you please test if this happens also if you define a different table and you try to insert there ? I can't reproduce your situation with both trunk and 1.99.7 stabl

Re: [web2py] NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread thinkwell
I've set web2py.py as debug file, but it's irritating to have the gui pop open all the time. Also, the TK server window refuses to close after I stop debugging, so after a time there's this proliferation of server windows. :-| I've just included the lines below in each file, which helps autoc

[web2py] Re: NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread thinkwell
The path to report_email.txt is applications/saplogger/views/report_email.txt and the script I'm running is in applications/saplogger. Why I'm getting the 404 in the shell is baffling. Regarding context & environment, this report will be called from cron, and the email module will be imported i

[web2py] Re: Latest trunk and saving source from web browser problem ... 'Last saved on: communication error'

2012-08-18 Thread Pystar
+1. Yes, noticed it too. On Saturday, August 18, 2012 11:42:33 AM UTC+1, David Marko wrote: > > When editing app source from web interface there is a problem while saving > ...I'm getting 'Last saved on: communication error' and nothing saved ... > tried several times ... > > David > --

[web2py] Re: DAL field rules and form constraints

2012-08-18 Thread Mike Girard
I did do db.commit from the shell. Still no duplicate in the appadmin. On Saturday, August 18, 2012 3:12:39 PM UTC-4, Anthony wrote: > > In the shell, the transaction won't actually be committed until you do > db.commit() (in your app code, you do not have to call db.commit() because > it will

[web2py] Re: Latest trunk and saving source from web browser problem ... 'Last saved on: communication error'

2012-08-18 Thread Niphlod
and the appadmin of the apps do not work either. You are redirect to appadmin/select/db?query= for any table you choose. If you try to insert something, i.e. appadmin/insert/db/scheduler_task you get an error (something about unable to find the _primarykey). This happens for "old" apps and newly

Re: [web2py] NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread Marin Pranjić
You can run web2py in wingide if you set web2py.py as main debug file. On Aug 18, 2012 9:08 PM, "thinkwell" wrote: Hello everyone, I'm working on emailing a message and I'm having some unexpected issues. Here is my code based on the web2py book: from gluon.tools import Mail from report_vars im

Re: [web2py] Re: Where should I put functions that are useful/common to muliple applications?

2012-08-18 Thread Curiouslearn
Thank you, Villas and Cliff. Cliff, I will definitely look up on the topic of MySQL injection attacks. Does using DAL better protect me against such attacks? Thank you. On Fri, Aug 17, 2012 at 5:17 PM, Cliff Kachinske wrote: > curiouslearn > > I agree it's a good idea to learn as much as you ca

[web2py] Re: NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread Anthony
> > When I run the code in WingIDE, I get > NameError: name 'response' is not defined. > In web2py, model, controller, and view code is executed in an environment with some global objects pre-defined, including the request and response objects. As a result, you cannot run the code of a model,

[web2py] Re: NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread Niphlod
do you have a report_mail.txt in views ? On Saturday, August 18, 2012 9:08:12 PM UTC+2, thinkwell wrote: > > Hello everyone, > > I'm working on emailing a message and I'm having some unexpected issues. > Here is my code based on the web2py book: > > from gluon.tools import Mail > from report_vars

[web2py] Re: DAL field rules and form constraints

2012-08-18 Thread Anthony
In the shell, the transaction won't actually be committed until you do db.commit() (in your app code, you do not have to call db.commit() because it will be called automatically at the end of the request). Also, when you use .insert(), the validators don't run -- they only run when using SQLFORM

[web2py] Re: DAL field rules and form constraints

2012-08-18 Thread Mike Girard
Ok, so I brought up a new shell and the duplicate record was gone. So can I confirm that field constraints get enforced with db.insert and therefore, any DAL method I use for inserting records is sound in this respect? I don't want to do a huge data dump and then have to do a lot of post-proces

[web2py] NameError one way. 404 NOT FOUND the other...

2012-08-18 Thread thinkwell
Hello everyone, I'm working on emailing a message and I'm having some unexpected issues. Here is my code based on the web2py book: from gluon.tools import Mail from report_vars import * report_month = '7-2012' mail = Mail() mail.settings.server = 'smtp.gmail.com:587' mail.settings.sender = o

[web2py] Re: Latest trunk and saving source from web browser problem ... 'Last saved on: communication error'

2012-08-18 Thread Niphlod
+1 On Saturday, August 18, 2012 7:26:17 PM UTC+2, David Marko wrote: > > Updated from trunk, but still the same problem ... > > Dne sobota, 18. srpna 2012 15:35:13 UTC+2 Massimo Di Pierro napsal(a): >> >> Please try again. >> >> On Saturday, 18 August 2012 05:42:33 UTC-5, David Marko wrote: >>> >>

[web2py] Re: Scheduler: help us test it while learning

2012-08-18 Thread Niphlod
Can you elaborate further on the inconsistent behaviour ? repeats requeues the task n times (defaults to only completed tasks) and retry_failed make them requeued if execution fails. You have parameters to let the task be like a cron one (repeats=0, retry_failed=-1). You have also all the bits

[web2py] DAL field rules and form constraints

2012-08-18 Thread Mike Girard
In preparation for doing a bulk insert into my app's tables I have been doing some testing from the web2py shell. I issued the following command: >>db.person.insert(name = 'Dustin Hoffman') person.name has a unique=true setting as well as an IS_NOT_IN_DB form constraint. Dustin Hoffman is alre

[web2py] Re: Scheduler: help us test it while learning

2012-08-18 Thread Yarin
I've noticed that repeating tasks that fail during a certain period are no longer repeated and the task is turned to FAILED. I think this is inconsistent behavior. The better approach would be: - Allow a periodic task to fail during a given period - Reset the task to QUEUED, just like when

[web2py] Re: Latest trunk and saving source from web browser problem ... 'Last saved on: communication error'

2012-08-18 Thread David Marko
Updated from trunk, but still the same problem ... Dne sobota, 18. srpna 2012 15:35:13 UTC+2 Massimo Di Pierro napsal(a): > > Please try again. > > On Saturday, 18 August 2012 05:42:33 UTC-5, David Marko wrote: >> >> When editing app source from web interface there is a problem while >> saving ..

[web2py] Re: Congratulations to Bruno and Mariano

2012-08-18 Thread samuel bonilla
def index(): good = ''Congratulations to Bruno Rocha and Mariano Reingart" return dic(good = good) --

Re: [web2py] Re: Web2py GAE strange error [Errno 13] file not accessible: (jQuery.js)

2012-08-18 Thread Christian Foster Howes
i agree that it is GAE specific. i've never had a problem elsewhere. On 8/17/12 22:19 , Massimo Di Pierro wrote: I opened an issue on googlecode. If there is a problem with thread safety it is GAE specific. There is some logic created in the early days to cache things on GAE assuming one proces

[web2py] Re: Date format in CRUD forms

2012-08-18 Thread Simon Carr
I have created a short video on how to change the default Ajax date format in Web2Py. This in turn allows the Calendar widget to return what ever date format you want. http://www.youtube.com/watch?v=nk5YEP5r-UQ Cheers Simon On Tuesday, 9 August 2011 21:07:19 UTC+1, Jim S wrote: > > I'm sure

Re: [web2py] Any ideas about how to develop a gtalk web client into web2py?

2012-08-18 Thread Alec Taylor
https://developers.google.com/talk Python wrapper: https://github.com/Jajcus/pyxmpp2 Tutorial: http://www.linuxforu.com/2012/06/use-xmpp-to-create-your-own-google-talk-client/ On Sat, Aug 18, 2012 at 8:50 PM, david xiao wrote: > Any ideas about how to develop a gtalk web client into web2py? >

Re: [web2py] Re: Major speed improvement need testers

2012-08-18 Thread Bruno Rocha
What about db.table.field.readable = True db.table.field.default = x ? --

Re: [web2py] Re: Major speed improvement need testers

2012-08-18 Thread Massimo Di Pierro
good point but... in my view we could make lazy tables the default except for one caveat: they no loger allow Person = db.define_table('person') syntax. Other than this there is no different i making table lazy or not. It would be very confusing if some tables has the syntax and others did not.

[web2py] Re: Major speed improvement need testers

2012-08-18 Thread Massimo Di Pierro
can you post your model? there may be places (for example references and validators) which force the instantiation of lazy tables. Code needs to be rearrange to take advantage of lazy tables. Here are my benchmarks (admittedly extreme and not typical scenario) but I do expect a speedup: impor

[web2py] Re: Latest trunk and saving source from web browser problem ... 'Last saved on: communication error'

2012-08-18 Thread Massimo Di Pierro
Please try again. On Saturday, 18 August 2012 05:42:33 UTC-5, David Marko wrote: > > When editing app source from web interface there is a problem while saving > ...I'm getting 'Last saved on: communication error' and nothing saved ... > tried several times ... > > David > --

[web2py] Re: Help me to write SQL query in web2py

2012-08-18 Thread Massimo Di Pierro
My bad. It should be t.created_on.max() On Saturday, 18 August 2012 04:26:37 UTC-5, mcamel wrote: > > Hi, > > Massimo, i really like your framework. Thank you very much for your > dedication. > > I'm newbie and don't want to bother but... i think some details are > missing in the manual so that

[web2py] Re: Major speed improvement need testers

2012-08-18 Thread Ron McOuat
I tried to convert but use the _and= portion of requires to help not get duplicate entries in the many to many link tables I use. An example Field('server_id', 'reference servers', requires = IS_IN_DB(db, 'servers.id', '%(hostname)s', _and = IS_NOT_IN_DB(db(db.site_servers.site_id==request.

Re: [web2py] Re: Major speed improvement need testers

2012-08-18 Thread Anthony
> > Are you using auth.signature in any table? > if you have Auth, the auth tables will not be lazy (I think) because it > needs to be defined on auth.define_tables() > Maybe we could add a "lazy_tables" option to auth.define_tables() and move the field attributes inside the Field() calls and

Re: [web2py] Creating None DB forms in the Controller with Formating?

2012-08-18 Thread Simon Carr
Thankyou Bruno. On most frameworks if you have a question there is always a thought in the back of your mind that it might not be possible. But with web2py I never have those thoughts any more. The developers seem to have thought of everything, i simply have to learn it. Simon On 18 Aug 2012 1

Re: [web2py] Re: Major speed improvement need testers

2012-08-18 Thread Bruno Rocha
are you using auth.signature in any table? if you have Auth, the auth tables will not be lazy (I think) because it needs to be defined on auth.define_tables() On Sat, Aug 18, 2012 at 6:58 AM, David Marko wrote: > I have redesigned one of my app by moving requires into Field definition, > and s

Re: [web2py] Creating None DB forms in the Controller with Formating?

2012-08-18 Thread Bruno Rocha
form = SQLFORM.factory(Field("name"), Field("email", requires=IS_EMAIL())) On Sat, Aug 18, 2012 at 7:11 AM, Simon Carr wrote: > Hi, > > I understand how to create forms using SQLFORM and FORM, but the latter > does not provide any table formatting as SQLFORM does. > > How do I create a Form in

[web2py] Any ideas about how to develop a gtalk web client into web2py?

2012-08-18 Thread david xiao
Any ideas about how to develop a gtalk web client into web2py? Hi, I am considering incorporate Gtalk, Webex(similar to previous Meeboo, seems Webex doesn't open its API) web clients into web2py site, while i didn't find any useful information when i searched, any ideas? or any resource/doc

[web2py] Latest trunk and saving source from web browser problem ... 'Last saved on: communication error'

2012-08-18 Thread David Marko
When editing app source from web interface there is a problem while saving ...I'm getting 'Last saved on: communication error' and nothing saved ... tried several times ... David --

[web2py] Creating None DB forms in the Controller with Formating?

2012-08-18 Thread Simon Carr
Hi, I understand how to create forms using SQLFORM and FORM, but the latter does not provide any table formatting as SQLFORM does. How do I create a Form in the Controller which is not connected to a database definition but which is formatted into a table layout? Many thanks Simon --

[web2py] Re: Major speed improvement need testers

2012-08-18 Thread David Marko
I have redesigned one of my app by moving requires into Field definition, and setup the lazy_tables=True ... and benchmarked difference(before and after trunk version) using apache benchmark but cant see any difference for home page which dont require any table ... so I expect speedup here. Bot

[web2py] Re: Help me to write SQL query in web2py

2012-08-18 Thread mcamel
Hi, Massimo, i really like your framework. Thank you very much for your dedication. I'm newbie and don't want to bother but... i think some details are missing in the manual so that we can build this kind of selects by our own, or even understand the query below. Are there references to 'crea

[web2py] Re: Major speed improvement need testers

2012-08-18 Thread lyn2py
Amazing! Thanks Massimo! Was about to port my models over to model-less modules and now this excellent update! Would love to hear the feedback from other users, since I have no idea how to run benchmarking tests. On Saturday, August 18, 2012 11:00:44 AM UTC+8, Massimo Di Pierro wrote: > > The