[web2py] nssm scheduler seems to be a nobrainer...

2013-04-05 Thread Marian
...but I cannot get it to work. As soon as I start the service via the service console, it terminates without an error code. It tried 32/64 bit version of nssm, w and w/o quotes for the paths. In procexp I see that the python.exe is started but it terminates immediately. pythonw.exe without

[web2py] web2py with ExtJS - advice required on restructing

2013-04-05 Thread at
HI, Started working on a project where the team is already working on using extjs to develop the views. Each view of web2py application is basically an ExtJS application. They've placed extjs library in web2py/applications/app/static /extjs and created an extjs_views folder in

[web2py] jqwidgets and web2py

2013-04-05 Thread puercoespin
Do you know jqwidgets from www.jqwidgets.com? That's a superb jquery based widgets, than i think may be included in web2py. There are a commercial licence, but you can use jQWidgets for free under the Creative Commons Attribution-NonCommercial 3.0

Re: [web2py] jqwidgets and web2py

2013-04-05 Thread António Ramos
and about this one? http://www.jeasyui.com/index.php 2013/4/5 puercoespin jzaragoza.puercoes...@gmail.com Do you know jqwidgets from www.jqwidgets.com? That's a superb jquery based widgets, than i think may be included in web2py. There are a commercial licence, but you can use jQWidgets for

[web2py] Re: nssm scheduler seems to be a nobrainer...

2013-04-05 Thread Marian
I dug around in the event log and found: Started C:\Python27\pythonw.exe D:\web2py\web2py.py -K imagecontest for service web2py_scheduler_imagecontest4 in C:\Python27\. Program C:\Python27\pythonw.exe for service web2py_scheduler_imagecontest4 exited with return code 1. Killing process tree

[web2py] REF: Matplotlib Image

2013-04-05 Thread Teddy Nyambe
I have the following code: fig = plt.figure(1, figsize=(6,6)) ax = fig.add_axes([0.1,0.1,0.8,0.8]) labels = 'Female', 'Male' fracs = [50,50] ax.pie(fracs, labels=labels, autopct='%1.1f%%', shadow=True) image_folder=os.path.join(request.folder, 'static/tmp/') fig.savefig('%stest.png' %

[web2py] Re: options_std.py/options.py breaks as-is on web2py 2.4.5 + a question

2013-04-05 Thread wprins
Can someone confirm whether the issue with options_std.py/options.py is worth filing a bug about? It may be trivial but it seems unnecessarily broken. Walter -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group

[web2py] Re: nssm scheduler seems to be a nobrainer...

2013-04-05 Thread Niphlod
As soon as I get home I'll make screenshot of the configs I hadn't any problems a few months back, but I'll recheck for sure and post here or on web2pyslices.com the steps involved. On Friday, April 5, 2013 11:34:30 AM UTC+2, Marian wrote: I dug around in the event log and found:

[web2py] Re: another scheduler Q

2013-04-05 Thread Niphlod
what db are you using ? On Friday, April 5, 2013 6:24:13 AM UTC+2, Yoel Benitez Fonseca wrote: i have this setup: 2 severs with the same web2py app installed, each of then run a scheluder worker the problem is that only one of then get jobs, and in db.scheluder_worker the one with do

[web2py] 'str' object has no attribute 'year' with 2 or more datetime validators

2013-04-05 Thread Daniel González
Hi everyone, I have noticed that i cannot use 2 or more datetime validators on the same field. I'm building a SCRUM project management app. Making the sprints module I need to validate that a new sprint is inside the project date range, and at the same time, the sprint doesn't overlaps with

[web2py] Re: web2py Talk

2013-04-05 Thread Francisco Costa
also this one: http://www.slideshare.net/blackthorne/web2pyweb-development-like-a-boss On Thursday, April 4, 2013 11:56:20 AM UTC+1, Francisco Costa wrote: Hi, I'm going to give a briefly presentation about web2py this Saturday:

[web2py] Re: nssm scheduler seems to be a nobrainer...

2013-04-05 Thread Marian
That would be awesome. Thanks for the great work! :) On Friday, April 5, 2013 12:46:36 PM UTC+2, Niphlod wrote: As soon as I get home I'll make screenshot of the configs I hadn't any problems a few months back, but I'll recheck for sure and post here or on web2pyslices.com the steps

[web2py] Problem with form.process().accepted ?

2013-04-05 Thread Nguyen Minh Tuan
Hi! I'm newbie with web2py. I do tutorial in FORM chapter Model db.define_table('person', Field('personname', 'string', requires = IS_NOT_EMPTY())) Controller : def index(): form = SQLFORM(db.person) if form.process().accepted:

[web2py] Re: web2py Talk

2013-04-05 Thread Alan Etkin
also this one: http://www.slideshare.net/blackthorne/web2pyweb-development-like-a-boss And Bruno Rocha's work: Slides (Demistificando web2py) http://www.slideshare.net/rochacbruno/desmistificando-web2py-tdc2011 Video (IDE, pra que?) http://vimeo.com/26387038 Perhaps you need to check

[web2py] Re: scheduler init script

2013-04-05 Thread Niphlod
that's the one in the header comments on the scheduler.py itself. Given that upstart is present in your ubuntu version it's definitely the shortest way (and simple, also) to run a service. On Thursday, April 4, 2013 11:57:01 PM UTC+2, Yoel Benitez Fonseca wrote: i have found this script in the

[web2py] Re: nssm scheduler seems to be a nobrainer...

2013-04-05 Thread Marian
Hm maybe I have a hint, I found a failed entry in db.scheduler_run: gluon.shell line 137: sys.exit(1). When I try to restart the service, I don't get new failed tasks, so I cannot say where this specific one came from. On Friday, April 5, 2013 1:36:37 PM UTC+2, Marian wrote: That would be

[web2py] Re: Problem with form.process().accepted ?

2013-04-05 Thread Anthony
redirect('default', 'list') Should be: redirect(URL('default', 'list')) When I submit form with empty value (person name), validation does not work. What do you mean it doesn't work? Do you not see the error message on the form? What do you expect, and what happens instead? It

[web2py] Re: web2py with ExtJS - advice required on restructing

2013-04-05 Thread LightDot
It's hard to answer this without knowing what are the application goals and what are the issues you're facing. So... what exactly is a problem with the current approach? What would you like to achieve by restructuring? Regards, Ales On Friday, April 5, 2013 8:45:28 AM UTC+2, at wrote: HI,

[web2py] Re: how to send bulk emails with web2py

2013-04-05 Thread ctrlSoft
Amazon Simple Email Service (Amazon SES) http://aws.amazon.com/ses/ -- --- 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

[web2py] auth.settings.extra_fields

2013-04-05 Thread Domagoj Kovač
Hi, i have a problem. In my models/db.py file i have this code: auth.settings.extra_fields['auth_user'] = [Field('deleted', 'boolean', default=False), Field('company_id', 'reference companies', requires=IS_IN_DB(db,db.companies.id))] In my

[web2py] Re: auth.settings.extra_fields

2013-04-05 Thread ctrlSoft
models are executed in alphabetical order. db.py and after that companies.py, you make reference to a non define table. you sould define companies table right after auth = Auth(db) and before auth.settings. extra_fields['auth_user'] = auth = Auth(db) # # # #

[web2py] RadioWidget ignoring formstyle?

2013-04-05 Thread Leonel Câmara
Hey, I was hoping someone could help me understand what I'm doing wrong. For some reason, in my SQLFORM.factory created form, even though I had specified formstyle='divs' and everything else was inside divs, my radio buttons were still being rendered inside a table. Which I found odd since

[web2py] Re: auth.settings.extra_fields

2013-04-05 Thread Niphlod
the point is having that db.companies.id evaluated later . you can pass a string to the is_in_db validator, it shouldn't raise the error IS_IN_DB(db, 'companies.id', '%(name)s') *should* work giving you a nice dropdown too. On Friday, April 5, 2013 4:48:33 PM UTC+2, ctrlSoft wrote: models

[web2py] Re: auth.settings.extra_fields

2013-04-05 Thread Domagoj Kovač
Thanks guys, right now my db.py looks like this: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() db.define_table('companies', Field('name', 'string',

[web2py] Re: auth.settings.extra_fields

2013-04-05 Thread Niphlod
Nope. when auth definition is encountered, if you want to use db.companies.id written as it is, db.define_table('companies') should have been executead already. You need to change your IS_IN_DB call to (db, 'companies.id', '%(name)s') ... notice the ticks around companies.id, it's a string

[web2py] Re: RadioWidget ignoring formstyle?

2013-04-05 Thread Niphlod
Hum. from the book ...http://web2py.com/books/default/chapter/29/07#Widgets Sometimes widgets take additional arguments and one needs to specify their values. In this case one can use lambda db.mytable.myfield.widget = lambda field,value:

[web2py] .select(db.table.ALL)

2013-04-05 Thread Annet
I have a question about db.table.ALL In case of: db(db.table1.id1).select(db.table1.ALL) this: db(db.table1.id1).select() gives the same result. In case of: db((db.table1.id1)(db.table1.refID==db.table2.id)).select(db.table1.ALL,db.table2.ALL) this:

[web2py] pre populated SQLFORM.FACTORY does not submit because of upload field

2013-04-05 Thread António Ramos
hello, i´m using a sqlform.factory to edit a record. The form is prepopulated using this code row=db((db.trabalhador.id==request.args(0))).select().first() if row: for field in row: if field in db.trabalhador.fields: print setting

[web2py] Re: .select(db.table.ALL)

2013-04-05 Thread Niphlod
recap: - db.table1.ALL is just a shortcut to db.table1.field1, db.table1.field2, db.table1.field3, etc etc etc - select() without arguments selects all fields for all tables involved. - if you pass something explicit to select() , you get just what you asked for tl;dr : exactly what you

[web2py] Re: auth.settings.extra_fields

2013-04-05 Thread Domagoj Kovač
Thanks man! On Friday, April 5, 2013 5:30:38 PM UTC+2, Niphlod wrote: Nope. when auth definition is encountered, if you want to use db.companies.idwritten as it is, db.define_table('companies') should have been executead already. You need to change your IS_IN_DB call to (db,

[web2py] Re: .select(db.table.ALL)

2013-04-05 Thread Annet
Hi, Thanks for your answer, I just wasn't sure I could leave out the .ALL, now I know for sure ... 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, send an email to

[web2py] Re: .select(db.table.ALL)

2013-04-05 Thread Anthony
Note, .ALL is also useful when you don't want to specify any query: db().select(db.mytable.ALL) That will give you all the records and all the fields in db.mytable. If you do specify a query, then calling .select() with no fields is equivalent to using .ALL. Anthony On Friday, April 5, 2013

[web2py] Re: auth.settings.extra_fields

2013-04-05 Thread Anthony
Note, simply doing (db, 'companies.id', ...) may not completely resolve the problem. Even doing that, the db.companies table is only getting defined conditionally when the companies controller is called, but the db.auth_user table is defined on every request, and it could be used by other

[web2py] Re: Just knew about Server-Sent Events and want to share it with you

2013-04-05 Thread Paolo Caruccio
Well, I just tested version 2.4.5 Stable ts 2013.04.04.21.10.38 and all worked for me. What issue have you encountered? Anyway, the code was and is experimental (for example it doesn't work on IE). If do you want something more tested please try comet messaging included in web2py as Derek

[web2py] Re: any good open courses with web2py?

2013-04-05 Thread jjg0
Hi Massimo, This class looks really interesting. Do you have any more information on what types of projects you typically have students complete, what skill level you are expecting students to reach after completing the course, maybe a syllabus? For example do you try to gear your course

[web2py] Article: Frameworks Round 2

2013-04-05 Thread David Marko
http://www.techempower.com/blog/2013/04/05/frameworks-round-2/ -- --- 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

Re: [web2py] Re: another scheduler Q

2013-04-05 Thread Yoel Benítez Fonseca
El 5.4.2013 6:47 am, Niphlod escribió: what db are you using ? postgres, is the same database shared between servers On Friday, April 5, 2013 6:24:13 AM UTC+2, Yoel Benitez Fonseca wrote: i have this setup: 2 severs with the same web2py app installed, each of then run a scheluder worker

Re: [web2py] Re: another scheduler Q

2013-04-05 Thread Niphlod
this is the second time the issue is posted and yet I can't find a way to reproduce it It's true that I'm running two scheduler processes on the same machine vs one scheduler on on machine and the other on another separate one, but as far as the assign algorithm is concerned, as long as

[web2py] Web2py CAS auth.username does not exist. Multiple application with one CAS provider.

2013-04-05 Thread joe smith
I am trying to create a single web2py server with multiple applications that each use a single CAS provider to handle user authentication. I keep running into a wall when it comes to getting the applications to work with the CAS. In particular I get an error from the consumer app that

[web2py] Web2py CAS auth.username does not exist. Multiple applications, one CAS provider.

2013-04-05 Thread joe smith
I am writing a number of Web2py applications. The base CAS application is an administration system to keep track of users, organizations, groups, etc. That part is working fine, but now I want to add additional applications that use this administration system as a CAS provider. I have been

Re: [web2py] Re: another scheduler Q

2013-04-05 Thread Yoel Benítez Fonseca
El 5.4.2013 2:57 pm, Niphlod escribió: this is the second time the issue is posted and yet I can't find a way to reproduce it It's true that I'm running two scheduler processes on the same machine vs one scheduler on on machine and the other on another separate one, but as far as the

[web2py] Re: Article: Frameworks Round 2

2013-04-05 Thread Derek
I've said in the past that they were unfair to Ruby because they were using their ruby server in dev mode which recompiles code on every access. This time, I looked more closely at their 'Flask' setup. They are running Flask via gunicorn, so you'd think all is good. However, they aren't

[web2py] Re: Article: Frameworks Round 2

2013-04-05 Thread Derek
I'd also add that it's debatable whether using gunicorn's 'jsonify' is any better than json.dumps(). They had to add a shim in to make jsonify work. jsonify adds the correct header for json, whereas json.dumps doesn't. I'd expect the database performance to take a hit in this setup because of

[web2py] Re: nssm scheduler seems to be a nobrainer...

2013-04-05 Thread Niphlod
that should be it http://www.web2pyslices.com/slice/show/1614/nssm-webserver-and-scheduler-as-services-in-windows-oses On Friday, April 5, 2013 2:35:15 PM UTC+2, Marian wrote: Hm maybe I have a hint, I found a failed entry in db.scheduler_run: gluon.shell line 137: sys.exit(1). When I try

Re: [web2py] Re: another scheduler Q

2013-04-05 Thread Niphlod
I get that if you manually force them to pick tasks from different groups they are processed, but different schedulers with the same group name should receive the same amount of tasks anyway. On Friday, April 5, 2013 9:17:23 PM UTC+2, Yoel Benitez Fonseca wrote: El 5.4.2013 2:57 pm, Niphlod

[web2py] Re: any good open courses with web2py?

2013-04-05 Thread Derek
Post your code on github, link to it here, we could provide you a with a code review if that's what you're after. On Thursday, April 4, 2013 6:37:15 AM UTC-7, jjg0 wrote: Are there any good self paced learning courses on webdev with web2py? So far I am enjoying learning how to make

[web2py] Re: web2py with ExtJS - advice required on restructing

2013-04-05 Thread Derek
I'd suggest all the 'views' be placed in static. Your ExtJS should handle all the data. Add json services and let the ExtJS consume them. Note that you won't get form helpers or the security that web2py provides, but you get the authentication, DAL, automatic jsonifying and caching. On

Re: [web2py] Re: another scheduler Q

2013-04-05 Thread Niphlod
more on the matter this is the result of 600 queued tasks all in the main group, with two different schedulers started with -K appname, with postgresql select assigned_worker_name, status, count(*) as howmany from scheduler_task group by assigned_worker_name, status

[web2py] Re: another oracle question :(

2013-04-05 Thread Martin Barnard
Sorry for the delay. My DAL code would ideally be something like this: mems=[135123123,135123154,150012323] rows=odb(odb.player_master.link_id.belongs(mems)).select() This works, but I know if I scale up to a large list, as I eventually must, it will bring complaints lockout from our oracle

[web2py] Re: any good open courses with web2py?

2013-04-05 Thread Michael Herman
will this be an online class per chance for extended/adult students? On Thursday, April 4, 2013 4:14:01 PM UTC-7, Luca wrote: I am considering teaching one such class in connection with UCSC in the Fall of this year. Luca On Thursday, April 4, 2013 6:37:15 AM UTC-7, jjg0 wrote: Are

[web2py] Re: How to check if plain text password matches with encrypted password in auth_user.password?

2013-04-05 Thread Orrù
suppose password='12345' and db.auth_user.first_name=='Lucas' so i find user by first_name, row_user=db(db.auth_user.first_name=='Lucas').select().first() and row_user.password='pbkdf2(1000,20,sha512)$97448b22487eca1d$dae65c0429430b7ae7bb311fed8e844b6a37ff30'

[web2py] Windows Service fails with 2 ports on rocket server

2013-04-05 Thread Adham Hassan
I've found an issue where the Windows Service isn't working the same as the command line. I have an options file like this: import socket import os interfaces = [('0.0.0.0',80),('0.0.0.0',443,'server.key','server.crt')] password = 'testing123' pid_filename = 'httpserver.pid' log_filename =

[web2py] web2py shell vs terminal shell

2013-04-05 Thread Michael Herman
i remember reading somewhere that it's better to use the built-in shell in web2py, but i can't find the article/post. anyone know (1) if it is better, and, (2) if so, why? -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe

[web2py] grid with left join example causes err keyword can't be an expression

2013-04-05 Thread Jurgis Pralgauskis
http://web2py.com/books/default/chapter/34/07#SQLFORM.grid-and-SQLFORM.smartgrid-(experimental) I tried examples , and one of them gives err: With SQLFORM.grid you can list all parents: SQLFORM.grid(db.parent) all children: SQLFORM.grid(db.child) and all parents and children in one table:

[web2py] Re: another oracle question :(

2013-04-05 Thread Niphlod
I really don't understand. The query shipped to your oracle instance will be exactly the same using DAL as the one using bind variables. The DAL just does binding for you (in the 90% of the cases, better) If you want to retrieve from a table all records in one query, and you have a large list

[web2py] Re: grid with left join example causes err keyword can't be an expression

2013-04-05 Thread Niphlod
I'd say it's an error on the docs *SQLFORM.grid(db.parent,left=db.child.on(db.child.parent=db.parent.id)) * should be *SQLFORM.grid(db.parent,left=db.child.on(db.child.parent==db.parent.id http://db.parent.id)) * i.e. the condition must have two equal signs instead of one. -- ---

[web2py] internship on web2py

2013-04-05 Thread Massimo Di Pierro
Anybody looking for an internship using web2py in the Philadelphia area? -- --- 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] Re: Windows Service fails with 2 ports on rocket server

2013-04-05 Thread Niphlod
I's say using nssm.exe will spare you some headaches. It seems that there are a few errors in winservice.py You can try to patch it. self.server = main.HttpServer( ip=options.ip, port=options.port, password=options.password,

[web2py] Re: .sum() and .count() in grid?

2013-04-05 Thread Jurgis Pralgauskis
You'll better code a view and access it as a fake table. are there examplses of this? Is it possible to show virtual fields in grid (in appadmin they don't show up)? -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe

[web2py] Re: list:string type field is empty value on edit page

2013-04-05 Thread Massimo Di Pierro
No it is not. Something in the code must be resetting it. On Thursday, 4 April 2013 22:13:25 UTC-5, 黄祥 wrote: hi, is it normal for list:string type field is empty when on editing page? e.g. db.define_table('contact', *Field('salutation'),* Field('first_name'),

[web2py] Re: weired behaviour of matplotlib in web2py

2013-04-05 Thread Massimo Di Pierro
I have been using matplotlib and never seen this. What version of web2py/python/matplotlib? On Friday, 5 April 2013 05:06:23 UTC-5, software.ted wrote: I have this code: import matplotlib matplotlib.use('Agg') import matplotlib.pyplot as plt ## Graphs fig = plt.figure(1, figsize=(6,6))

[web2py] Re: options_std.py/options.py breaks as-is on web2py 2.4.5 + a question

2013-04-05 Thread Massimo Di Pierro
Please do. Looks like a bug. On Friday, 5 April 2013 05:37:17 UTC-5, wprins wrote: Can someone confirm whether the issue with options_std.py/options.py is worth filing a bug about? It may be trivial but it seems unnecessarily broken. Edit: Never mind I see someone previously suggested I

[web2py] Re: 'str' object has no attribute 'year' with 2 or more datetime validators

2013-04-05 Thread Massimo Di Pierro
I am very much interested in your project. Can you send some screenshots? Anyway, the problem is that you are probably piping your validator to the normal one. Can I see your validator and how it is applied? On Friday, 5 April 2013 06:23:39 UTC-5, demetrio wrote: Hi everyone, I have

[web2py] Re: pre populated SQLFORM.FACTORY does not submit because of upload field

2013-04-05 Thread Massimo Di Pierro
Can you post a simpler example (including mode) to reproduce the problem? Looks like the field in the table has a validator which requires an upload. On Friday, 5 April 2013 11:06:52 UTC-5, Ramos wrote: hello, i´m using a sqlform.factory to edit a record. The form is prepopulated using this

[web2py] Re: Web2py CAS auth.username does not exist. Multiple applications, one CAS provider.

2013-04-05 Thread Massimo Di Pierro
If you use CAS you must change: auth = Auth(db) into auth = Auth(db, username=True) CAS requires a username. On Friday, 5 April 2013 11:26:50 UTC-5, joe smith wrote: I am writing a number of Web2py applications. The base CAS application is an administration system to keep track of users,

[web2py] Re: Web2py CAS auth.username does not exist. Multiple application with one CAS provider.

2013-04-05 Thread Massimo Di Pierro
Answered in other thread. On Friday, 5 April 2013 13:19:46 UTC-5, joe smith wrote: I am trying to create a single web2py server with multiple applications that each use a single CAS provider to handle user authentication. I keep running into a wall when it comes to getting the applications

[web2py] Re: web2py shell vs terminal shell

2013-04-05 Thread Massimo Di Pierro
It is not better. The web2py shell is the normal Python shell or the IPython shell if available. The difference is that the code in the web2py shell has already imported for you web2py environment (and optionally the models) so it it like coding in a web2py controller: python print db.tables

[web2py] Re: Windows Service fails with 2 ports on rocket server

2013-04-05 Thread Massimo Di Pierro
Where is this? On Friday, 5 April 2013 16:20:02 UTC-5, Niphlod wrote: I's say using nssm.exe will spare you some headaches. It seems that there are a few errors in winservice.py You can try to patch it. self.server = main.HttpServer( ip=options.ip,

[web2py] Re: web2py shell vs terminal shell

2013-04-05 Thread Anthony
By built-in shell, do you mean the one in the admin app? I think there are sometimes problems with that (particularly with database operations), so I tend to use the web2py shell in the terminal, which you can start as follows from the web2py directory: python web2py.py -S yourapp/[optional

Re: [web2py] Re: web2py shell vs terminal shell

2013-04-05 Thread Michael Herman
yes. so when working with DAL directly from the shell it's better to work from the web2py shell in the terminal rather than the admin app shell? any idea why? On Fri, Apr 5, 2013 at 2:43 PM, Anthony abasta...@gmail.com wrote: By built-in shell, do you mean the one in the admin app? I think

[web2py] Re: Multi-tenany and url routing

2013-04-05 Thread Domagoj Kovač
Does anyone have any advice? On Thursday, April 4, 2013 2:29:55 PM UTC+2, Domagoj Kovač wrote: Hi Guys, i am new to web2py. I have a problem and i am not sure how to approach it. I am working on a multitenant application. I have two tables: Tenants - id - name - url_sufix

[web2py] Re: Windows Service fails with 2 ports on rocket server

2013-04-05 Thread Niphlod
gluon/winservice.py However, there's a problem. when you pass --interfaces to rocket, it overrides whatever ip,port you pass (reading the docs) normally gluon.widget just discards -i and -p in favour of --interfaces options_std.py reports interfaces AND ip AND port ... it should be cleared

Re: [web2py] Re: another scheduler Q

2013-04-05 Thread Yoel Benítez Fonseca
El vie, 05-04-2013 a las 13:17 -0700, Niphlod escribió: more on the matter this is the result of 600 queued tasks all in the main group, with two different schedulers started with -K appname, with postgresql select assigned_worker_name, status, count(*) as howmany from scheduler_task

Re: [web2py] Re: another oracle question :(

2013-04-05 Thread Martin Barnard
Thanks for the info, Niphlod. I will look into the efficiency of the IN clause for my needs, as it appears to offer a solution which may mollify the IT DBA, and his demands for bind vars (they are concerned that a looped select will bring the db to it's knees). Martin Barnard. On 6 April

[web2py] Re: .sum() and .count() in grid?

2013-04-05 Thread Niphlod
often referred as materialized views for the ones who can spare me a lecture about what are exactly those :P, let's say you have an iper-complicated query that reconstructs to a table that you want to show in a grid just for searching purposes (other purposes not listed, sorry, they make

Re: [web2py] Re: another oracle question :(

2013-04-05 Thread Niphlod
On Friday, April 5, 2013 11:58:37 PM UTC+2, Martin Barnard wrote: Thanks for the info, Niphlod. I will look into the efficiency of the IN clause for my needs, as it appears to offer a solution which may mollify the IT DBA, and his demands for bind vars (they are concerned that a

Re: [web2py] Re: web2py shell vs terminal shell

2013-04-05 Thread Anthony
Well, give the admin shell a try and see if it works. I just had some problems in the past with db operations not committing (at least on Windows) -- not sure why. I think the terminal shell is easier to use anyway (don't have to type print before every command, recall previous command, etc.).

[web2py] Re: Web2py CAS auth.username does not exist. Multiple applications, one CAS provider.

2013-04-05 Thread joe smith
Ok thank you for your help. Does that mean I have to allow usernames for login for CAS to work? All of our users now use email addresses. I can get around the issue by manually creating a auth_user.username column in Postgres, but a cleaner fix would be as Anthony posted somewhere else:

[web2py] Help on fake_migration

2013-04-05 Thread Tito Garrido
Hi Folks! I am trying to migrate my web2py application from one server to another. I have pack my application and restored the MYSQL database but when I tried to run it there I got: InternalError: (1050, uTable 'auth_user' already exists)https://74.207.229.72/admin/default/errors/novelas# I have

[web2py] Re: Help on fake_migration

2013-04-05 Thread Niphlod
pass the same migrate argument of you DAL call to auth.define_tables() too (e.g., auth.define_tables(fake_migrate=True)) On Saturday, April 6, 2013 1:24:33 AM UTC+2, Tito Garrido wrote: Hi Folks! I am trying to migrate my web2py application from one server to another. I have pack my

[web2py] Re: web2py Talk

2013-04-05 Thread Francisco Costa
http://franciscocosta.com/web2py.html On Thursday, April 4, 2013 11:56:20 AM UTC+1, Francisco Costa wrote: Hi, I'm going to give a briefly presentation about web2py this Saturday: https://tymr.com/event/encontro-python-pt-6-abril-2013-porto/515c6f2a03d36d409716741e Are there any great

[web2py] class 'sqlite3.OperationalError' database is locked

2013-04-05 Thread BlueShadow
Hi, i got a couple of errors today which tell me the database is locked. I know I'm using sqlite. which is less than ideal. I got about 30 users a day which should be perfectly fine with SQLite. Especially since I added this part of code: if not request.env.web2py_runtime_gae: ## if NOT

[web2py] How to benchmark my web2py website? I have got scary results :-/

2013-04-05 Thread Tito Garrido
Hi Folks! I am trying to use ab to benchmark my website that is hosted on linode (512MB RAM) using nginx + mysql + web2py, installed via the install script provided in the book. Should I point ab to my index? I have been running some tests and the results are scary... Server Software:

Re: [web2py] Re: REF: Displaying a Virtual Field in SQLFORM.grid throws an exception....

2013-04-05 Thread Richard Vézina
I fall on this exact problem, I don't see anything about taht in the change log of 2.4.4. Is this will be fix soon? I mean SQLFORM.grid support for virtual field THanks Richard On Tue, Dec 18, 2012 at 10:32 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Right now grid does not work

[web2py] Re: list:string type field is empty value on edit page

2013-04-05 Thread 黄祥
is it related to the other field constructor, like required, label, etc? and for controller i'm using grid. *default.py* @auth.requires_login() def contact(): grid=SQLFORM.grid(db.contact, user_signature=False) return locals() *db_wizard.py* # create table : contact

[web2py] contribute in indonesian language translate

2013-04-05 Thread 黄祥
hi, is it possible for me to contribute in indonesian language translate? i'm trying to create new file in languages name : id.py in my application after that i've define : *gluon/contrib/plural_rules/id.py* #!/usr/bin/env python # -*- coding: utf8 -*- # Plural-Forms for id (Indonesian)

[web2py] Re: Help on fake_migration

2013-04-05 Thread tomt
I migrate applications fairly often, and using fake_migrate_all works best for me: db = DAL(...,fake_migrate_all=True) On Friday, April 5, 2013 5:24:33 PM UTC-6, Tito Garrido wrote: Hi Folks! I am trying to migrate my web2py application from one server to another. I have pack my

Re: [web2py] How to benchmark my web2py website? I have got scary results :-/

2013-04-05 Thread Richard Vézina
You can look at db.stat and start your app with profiler. Look in the generic.thml view for db.stat you have to the little piece of code in your view to access it. You can serach de groop for the profiler or check the book section how to start the shell I think there is explanation there...

[web2py] setting sqltable row a class for some row without looping over the html table

2013-04-05 Thread Richard
Hello, I am searching way to set class to some row in the html table depend on particular field value of table row for changing background color of the row... Until now I was looping over html table for that but I start to see the limit of this approach as the number of records grow... I try

[web2py] Re: New Plugin: timezone helper

2013-04-05 Thread samuel bonilla
sí, web2pyslices es una buena opción, es posible hacer una automatización en el código fuente https://github.com/rochacbruno/Movuca El martes, 2 de abril de 2013 16:54:10 UTC-5, Niphlod escribió: Here https://github.com/niphlod/w2p_timezone_plugin As always, you're welcome to submit patches,

Re: [web2py] Re: another oracle question :(

2013-04-05 Thread Martin Barnard
Thanks again for the help - it's invaluable to the oracle noob! :D I'm actually building an analysis system so that my boss can view some statistical subset of the information based on a few months or weeks. One part of the data is stored in *our* MySQL database (which our department control),

[web2py] Is there a way to cache images from download function?

2013-04-05 Thread Tito Garrido
Hi! I was running page speed on my website and all image files from the database (upload folder) are not cached... Is there a way to enable cache for them? Thanks! Tito -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___ -- --- You received

Re: [web2py] Re: web2py shell vs terminal shell

2013-04-05 Thread Massimo Di Pierro
The admin shell has problems maintaining state. I do not consider it reliable. The terminal shell is rock solid. It is a normal pyhton shell. On Friday, 5 April 2013 16:48:50 UTC-5, Michael Herman wrote: yes. so when working with DAL directly from the shell it's better to work from the

[web2py] Re: web2py with ExtJS - advice required on restructing

2013-04-05 Thread at
One of the problems is that the extjs implementation has made the application slow. Because each page is itself an extjs application, it reloads extjs libs on accessing a view. So wanted to at least avoid reloading of js libs on each page access request. Regards On Friday, 5 April 2013