[web2py] Re: Set the Atom Editor to auto complete web2py

2017-01-25 Thread Gael Princivalle
Hello Rafael. Did you find a solution? Il giorno giovedì 8 settembre 2016 02:30:49 UTC+2, Rafael Oliveira ha scritto: > > > Good Morning. I wanted to set the Atom Editor to auto complete web2py, > already tried in some tutorials and I can not. I use Windows 10. I managed > to make Python auto

[web2py] id table in web2py contain uuid

2017-01-25 Thread 黄祥
let say i got the csv file from another web app, in that csv file contain a field id that contain uuid e.g. a.csv (got from another web app) Id,Name 58801d5a3f9591dc47fbcc39,a 58801e67fc61af1a706ac9e1,b is it possible to have id table in web2py that contain uuid? how to define table in dal to fa

[web2py] Re: How to architect a public facing data subset

2017-01-25 Thread Dave S
On Wednesday, January 25, 2017 at 4:31:20 PM UTC-8, Leonel Câmara wrote: > > web2py permissions not enough? > > If not, I guess you could make 2 applications which had 2 different > users/roles in the same database, the user on the public facing application > would have all privileges revoked

[web2py] Re: Key Error when try to access records in DB tables

2017-01-25 Thread Leonel Câmara
This is very weird. Can you provide a minimal application that reproduces it? I've had errors like this but they were due to a table with a "format" that was expecting stuff that was not there. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/w

[web2py] Re: How to migrate with MySQL database?

2017-01-25 Thread 黄祥
i think in web2py you can use export import from csv ref: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.go

[web2py] Re: How to architect a public facing data subset

2017-01-25 Thread Leonel Câmara
web2py permissions not enough? If not, I guess you could make 2 applications which had 2 different users/roles in the same database, the user on the public facing application would have all privileges revoked and then you would give it only exactly what you want to be public. See: https://sup

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Leonel Câmara
Yes, I'm sorry Andrea, I don't use the grid much nowadays, that's because you're using request.args(0) and the grid also uses args, when it sees your arg it think it should be a signature and so you get not authorized, so, I think you need to send your "arg" to the grid so it knows it's yours an

[web2py] How to architect a public facing data subset

2017-01-25 Thread Alex Glaros
I have a transaction database with confidential information, which contains some public information that I want exposed to the public. I'd like the public subset isolated from the confidential database so public users pose no performance or security problem to the confidential database Public d

[web2py] Re: How to migrate with MySQL database?

2017-01-25 Thread Jim S
Is this a one-time migration or something you want to do repeatedly? Sounds like you are just moving from one machine to another. If this is the case, then you don't need web2py at all to do it. This could do the trick for you: https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html Is

[web2py] How to migrate with MySQL database?

2017-01-25 Thread Henk huisman
I want to migrate an application to another computer. The app's database is in MySQl. Could anyone explain me step by step how to perform this operation in Web2py? Thank's a lot Henk -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

Re: [web2py] Key Error when try to access records in DB tables

2017-01-25 Thread Richard Vézina
Hmm... Is "table_name" what you exactly use in your code or does it stand for a table name that you actually keep from us to know (it ok we don't know the name of your entity if you want ot keep it secret)? Because I thinking that you use litterally 'table_name' in your code and that would be amuzi

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Andrea Fae'
Thanks a lot, but nevertheless it's not working. flash tell me I'm not authorized The function modified is this def lista_asset(): if (request.args(0) == 'SC'): query = (db.asset.tipo=='SC') & (db.asset.is_active==True) else: query = (db.asset.is_active==True) db.a

[web2py] Re: User group blocked in China

2017-01-25 Thread Alex Glaros
could we mirror the text somehow from GG to web2py.com? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscrib

[web2py] Re: User group blocked in China

2017-01-25 Thread Dave S
On Wednesday, January 25, 2017 at 10:48:30 AM UTC-8, Dave S wrote: > > > > On Tuesday, January 24, 2017 at 7:19:16 PM UTC-8, Ben Lawrence wrote: >> >> Hi >> I am in China for 3 weeks and suddenly realized this awesome user group >> is now blocked! So up comes the VPN tunnel... But for our Chinese

[web2py] Re: User group blocked in China

2017-01-25 Thread Dave S
On Tuesday, January 24, 2017 at 7:19:16 PM UTC-8, Ben Lawrence wrote: > > Hi > I am in China for 3 weeks and suddenly realized this awesome user group is > now blocked! So up comes the VPN tunnel... But for our Chinese comrades, > would you consider moving the group to web2py.com ? > regards >

Re: [web2py] Re: pass arguments to menu item

2017-01-25 Thread Áureo Dias Neto
Thanks bro, it's really usefull \o 2017-01-25 15:23 GMT-02:00 Leonel Câmara : > The first one: > > *db(*(db.asset.tipo=='SC') & (db.asset.is_active==True)*)* > > Returns a Set (this is not a python set but a pyDAL one) > > The second one: > > (db.asset.tipo=='SC') & (db.asset.is_active==True) > >

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Leonel Câmara
The first one: *db(*(db.asset.tipo=='SC') & (db.asset.is_active==True)*)* Returns a Set (this is not a python set but a pyDAL one) The second one: (db.asset.tipo=='SC') & (db.asset.is_active==True) Actually returns a Query A set is what you get when you call your DAL instance with a query as

Re: [web2py] Re: pass arguments to menu item

2017-01-25 Thread Áureo Dias Neto
Leonel, can explain the difference between two codes? 2017-01-25 15:12 GMT-02:00 Leonel Câmara : > Note that this isn't a query: > > query = db((db.asset.tipo=='SC') & (db.asset.is_active==True)) > > this is a query: > > query = (db.asset.tipo=='SC') & (db.asset.is_active==True) > > -- > Resource

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Leonel Câmara
Note that this isn't a query: query = db((db.asset.tipo=='SC') & (db.asset.is_active==True)) this is a query: query = (db.asset.tipo=='SC') & (db.asset.is_active==True) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Andrea Fae'
Thanks but it's not the question. I wanted to pass some arguments to function like this... ('Scanner operativi', False, URL('default', 'lista_asset', *args='SC*')), but when I use in the function the system told me in session.flash "Not authorized" and doesn't show me what I want...

[web2py] Amazon Glacier

2017-01-25 Thread Alex Glaros
anyone have experience integrating their w2p app with Glacier? https://aws.amazon.com/glacier/ thanks Alex Glaros -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report I

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

2017-01-25 Thread icodk
Thank you both it works On Wednesday, January 25, 2017 at 5:04:42 PM UTC+1, Anthony wrote: > > On Wednesday, January 25, 2017 at 4:40:40 AM UTC-5, mweissen wrote: >> >> Try in the module: >> >> from gluon import current >> T = current.T >> > > Don't do T=current.T at the top level of the module (o

[web2py] Column width and row height in smartgrid

2017-01-25 Thread ArtDijk
LS, I have long text field in one column. Is it possible to set word-wrap in the column ? Additional a variable row height (based on the number of text lines) would be very nice. It can be seen at work here: https://datatables.net/examples/basic_init/zero_configuration.html If you reduce the wi

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

2017-01-25 Thread Anthony
On Wednesday, January 25, 2017 at 4:40:40 AM UTC-5, mweissen wrote: > > Try in the module: > > from gluon import current > T = current.T > Don't do T=current.T at the top level of the module (or as a class property) -- instead, that should go inside a function or method. Anthony -- Resources:

Re: [web2py] data from controller to javascript

2017-01-25 Thread Anthony
On Wednesday, January 25, 2017 at 6:22:22 AM UTC-5, Gaurav Vichare wrote: > > Or you can use ASSIGNJS helper > > {{=ASSIGNJS(js_array = python_list)}} > Yes, good suggestion. As an additional benefit, it uses gluon.serializers.json, which can handle conversion of datetimes, decimals, and various

[web2py] Arabic reports with web2py

2017-01-25 Thread Neveen Adel
Hello, Am trying to generate Arabic reports by web2py and the characters displayed with wrong encoding. I tried the following : 1- generate PDF : def printExam(): reload(sys) sys.setdefaultencoding('utf-8') exam_id = request.args[0] subject = request.args[1] response.

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Leonel Câmara
What do you mean? The menu is usually defined in the menu.py model, which puts the menu in response.menu. You can either change the model file to change the menu depending on "arguments" or you can change response.menu in the controller where you want it changed. -- Resources: - http://web2py

[web2py] pass arguments to menu item

2017-01-25 Thread Andrea Fae'
How to pass arguments to menu item? That can be retrieved by a function? Can I have a simple example? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues

[web2py] Re: Store dates in UTC format across all tables

2017-01-25 Thread Leonel Câmara
this is the simplest way: request.now = request.utcnow Your way should also work if you do it after auth.define_tables() -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Re

Re: [web2py] data from controller to javascript

2017-01-25 Thread Gaurav Vichare
Or you can use ASSIGNJS helper {{=ASSIGNJS(js_array = python_list)}} http://gauravvichare.com/how-to-assign-python-variable-to-javascript-variable-in-web2py/ On Tuesday, January 24, 2017 at 9:22:08 PM UTC+5:30, Anthony wrote: > > On Tuesday, January 24, 2017 at 7:43:24 AM UTC-5, Ramos wrote: >>

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

2017-01-25 Thread Martin Weissenboeck
Try in the module: from gluon import current T = current.T Regards, Martin 2017-01-25 9:51 GMT+01:00 icodk : > I have a controller that imports a module > In the controller I can use T('some text'). However trying to use it in a > function in an imported module gives: global name 'T' is not

[web2py] global name 'T' is not defined

2017-01-25 Thread icodk
I have a controller that imports a module In the controller I can use T('some text'). However trying to use it in a function in an imported module gives: global name 'T' is not defined exception The controller function is called from an ajax request I also tried to from gluon import T and go

[web2py] Re: Scheduler is_ticker and deadlock issues

2017-01-25 Thread Niphlod
you *should* have one different db for each environment. Each scheduler tied to the same db will process incoming tasks, and it doesn't matter what app effectively pushes them. This is good if you want to have a single scheduler (which can be composed by several workers) serving many apps, but *