[web2py] Re: web2py & jenkins

2018-09-02 Thread 黄祥
think you can use git, subversion, etc for version control system (git most used by people) for jenkins extensions or plugins perhaps you can get more detail info from their site or forum as you can see from example of my previous post is just simply - copy the web2py app from my repository fold

[web2py] Re: Help with CAS logout

2018-09-02 Thread fiubarc
Hello! Thank you for your answer, now I understand. I want, for example, that like google, when I log in to an application I do not need to start it in the rest, and when I close it, I can not enter the rest of the applications until I start it again. Then in web2py I should share the sessi

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-02 Thread Lisandro
Thanks for that fast response. If the cause of the problem is passing "contenido.id" as int, then the error is even more weird, because my app uses URL like that in several situations, for example: URL('contenido', 'editar', args=contenido.id) URL('categoria', 'editar', args=categoria.id) URL('d

[web2py] Re: global name 'Recaptcha' is not defined error when my app is run in web2py 2.17.1 (latest)

2018-09-02 Thread Rahul
Oops accidentaly posted it earlier - All, I wanted to know is with earlier version of web2py the same code does not give an error. But it gives me a message as I attached in my earlier mail. But now when I deployed my web2py application on production with latest version, I am being given a tic

[web2py] Re: global name 'Recaptcha' is not defined error when my app is run in web2py 2.17.1 (latest)

2018-09-02 Thread Rahul
Hi Anthony, Yes - It is defined in db.py file as from gluon.tools import Recaptcha and is utilized in my controller as - publickey = "key" privatekey = "key" crud.settings.create_captcha= Recaptcha(request, publickey, privatekey) crud.settings.create_captcha.label = 'Recap

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-02 Thread fiubarc
Hello, I think it's more a matter of python language, contenido.id is long type then self.args[0] in 'any string' raise an exception because, as the message says : 'in ' requires string as left operand, not long You can do args=['%s' % contenido.id, or args=[str(contenido.id), Don

[web2py] Re: web2py & jenkins

2018-09-02 Thread Vowner
Hello, Thanks for your reply. Actually I am in a initial stage to implement Jenkins for the python webdelopers to automate their process. We are planning for setup a version control system and Jenkins as ci. But I am confused here about that up to what extension, Jenkins can help them to revie

[web2py] Can't understand this error in gluon/rewrite.py

2018-09-02 Thread Lisandro
I have the same app installed several times within a web2py instance (running version 2.16.1-stable+timestamp.2017.11.14.05.54.25). In some of them, this sentence: URL(c='default', f=f, args=[contenido.id, contenido.slug], extension='', scheme=True, host=current.CONFIG.dominio) ... throws this

Re: [web2py] pydal metadata in db

2018-09-02 Thread Carlos Cesar Caballero Díaz
I like it. Greetings. El 02/09/18 a las 14:08, Massimo Di Pierro escribió: We you may know web2py has the ability to store table metadata in DB: from gluon.dal import InDBMigrator db = DAL(myconf.get('db.uri'), adapter_args=dict(migrator=InDBMigrator)) This is better for scalability as there

[web2py] Re: global name 'Recaptcha' is not defined error when my app is run in web2py 2.17.1 (latest)

2018-09-02 Thread Anthony
Recaptcha must be imported somewhere for you to use it. Do you have an import somewhere in your code? We need more details. Anthony On Friday, August 31, 2018 at 8:48:49 AM UTC-4, Rahul wrote: > > Hi All, > There seems to be an issue with latest version of web2py 2.17.1. I am > getting an e

[web2py] Re: pydal metadata in db

2018-09-02 Thread Anthony
On Sunday, September 2, 2018 at 2:08:50 PM UTC-4, Massimo Di Pierro wrote: > > We you may know web2py has the ability to store table metadata in DB: > > from gluon.dal import InDBMigrator > db = DAL(myconf.get('db.uri'), adapter_args=dict(migrator=InDBMigrator)) > > This is better for scalability a

[web2py] Re: Form submit takes too long

2018-09-02 Thread Anthony
> > - my first attempt will be to try to add indexes in the post and answers > Table on the field author. > - secondly i will try to change this row > >> row = db(db.post.author== auth.user.id).select(db.post.id, db.post. >> message, orderby=~db.post.id, limitby=(0,1)).first() > > to this >> >> r

[web2py] Re: Vue + web2py + Vuetify

2018-09-02 Thread 黄祥
perhaps you can give some example about that (git link or *.w2p), follow the link provided, just found an emptiness best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/

[web2py] Re: manage web2py app

2018-09-02 Thread 黄祥
already replied on another thread of this forum about web2py & jenkins which part that you confused, perhaps we can give any hints? best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.googl

[web2py] Re: web2py & jenkins

2018-09-02 Thread 黄祥
yes, you can *e.g.* *note : change path with your own path* *~/.jenkins/jobs/web2py/config.xml* false app /Users/sugizo/git/web2py/ ALL false false ALL

[web2py] Re: Problem with wsgihandler.py Apache/Python3

2018-09-02 Thread 黄祥
there are a lot of suggestion in this forum to not use apache to serve web2py, perhaps you can try another web server, e.g. nginx, gunicorn wsgihandler.py had tested and running fine with gunicorn best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Web2py Python3 ready

2018-09-02 Thread 黄祥
> > i try web2py on python3 but round about every 2 hours i get some > ticket from the standard library describing some python syntax errors who > doesn't make me more productive. I already create some issues with py3 on > Github. > pls post the error traceback that you got best regards, st

[web2py] Re: port 800 busy

2018-09-02 Thread 黄祥
you can check it with another tools, e.g. ps and stop it with e.g. kill or killall another way around you can start with another port (change with free port in your machine) e.g. python web2py.py -p best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Doc

[web2py] Re: Python 3.7 Compiled Apps

2018-09-02 Thread 黄祥
is there any error traceback? pls post it here too, so we know what happen best regards, stifan -- 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 recei

[web2py] Python 3.7 Compiled Apps

2018-09-02 Thread Donald McClymont
Has anyone successfully ran a compiled app under python 3.7? As far as I can see this doesn’t work - compilation is fine but running for example the welcome app complains about some Marshal error. It’s not obvious that much has changed between 3.6 which works fine and 3.7 as regards compilatio

[web2py] Re: port 800 busy

2018-09-02 Thread FRANK OJAMBO
How can I tell there is another process running and how can I stop it. -- 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

[web2py] Web2py website list

2018-09-02 Thread Gualter Portella
Hi everyone, I would like to thank this great community for supporting the amazing Web2py framework! About a year ago I was barely able to write a few lines of python code and now I have finished my webapp dedicated to financial information from Brazilian financial system! If you think the app d

[web2py] Re: Web2py Python3 ready

2018-09-02 Thread Massimo Di Pierro
"End-Of-Life of py2 version in 2020" it is not going to happen. Large banks use python 2. Anyway, this is not a web2py problem. It is a python problem. People do not want to port code (apps) that have written long ago. The developers may have left. On Sunday, 2 September 2018 11:03:30 UTC-7, j

[web2py] Re: how to set "arraysize" value for the DAL Oracle cursor ?

2018-09-02 Thread Massimo Di Pierro
You can with db = DAL('oracle:...) db.connection.cursor.arraysize =10 But I suspect the problem is another. The problem is that web2py turns the response into objects and that takes a lot of time. If you do not want that there is a way to prevent it. On Sunday, 2 September 2018 11:03:30 UT

[web2py] Re: parse_as_rest still experimental

2018-09-02 Thread Massimo Di Pierro
Just a decision that it is good enough as is and we want to support it On Sunday, 2 September 2018 11:03:30 UTC-7, justice Nanhou wrote: > > Hi everyone, > > does somebody already use "parse_as_rest" in Production ? > > it is like 2 years know i learn Web2py and this function is still > experimen

[web2py] Re: Smartgrid links with many-to-many join tables

2018-09-02 Thread Massimo Di Pierro
How about this? def grid(): form = SQLFORM.grid(db.thing_a, links=[lambda row: A('b things', _href=URL('grid_b',args=row.id))]) return locals() def grid_b(): a_id = request.args(0) query = (db.thing_b.id==db.join_table.b_id) & (db.join_table.a_id==a_id) filelds = columns = [

[web2py] Re: After 20 GB of data insertion replication is broken in BDR set up

2018-09-02 Thread Massimo Di Pierro
How is this related to web2py? On Sunday, 2 September 2018 11:03:30 UTC-7, Soumitra Bhandary wrote: > > Hi, > > I have performed below steps and after that , it seems that BDR > replication is broken . No DML statement is getting replicated and DDL > statements getting hanged . Any suggestion t

[web2py] Re: port 800 busy

2018-09-02 Thread Massimo Di Pierro
You may have started web2py twice or have another process using that port. On Sunday, 2 September 2018 11:03:29 UTC-7, FRANK OJAMBO wrote: > > hello why do i get this error each time i try to run on my webserver > > frankizzo@web7:~/www/web2py$ python web2py.py > web2py Web Framework > Created by

Re: [web2py] Re: Form submit takes too long

2018-09-02 Thread Maurice Waka
Hey @Lovdie. Can we have a look at this later? On Sun, 2 Sep 2018, 21:13 Lovedie JC wrote: > Am using sqlite.storage > > On Sun, 2 Sep 2018, 21:03 justice Nanhou wrote: > >> Hallo Maurice, >> >> it is know issue for all application and all framworks. >> which database are you using ? >> - my fi

Re: [web2py] Re: Form submit takes too long

2018-09-02 Thread Lovedie JC
Am using sqlite.storage On Sun, 2 Sep 2018, 21:03 justice Nanhou wrote: > Hallo Maurice, > > it is know issue for all application and all framworks. > which database are you using ? > - my first attempt will be to try to add indexes in the post and answers > Table on the field author. > - second

Re: [web2py] Re: Form submit takes too long

2018-09-02 Thread Lovedie JC
Yes. Been away. But I am looking into this. I'll let you know the results. Regards On Sun, 2 Sep 2018, 21:03 justice Nanhou wrote: > Hallo Maurice, > > it is know issue for all application and all framworks. > which database are you using ? > - my first attempt will be to try to add indexes in t

[web2py] pydal metadata in db

2018-09-02 Thread Massimo Di Pierro
We you may know web2py has the ability to store table metadata in DB: from gluon.dal import InDBMigrator db = DAL(myconf.get('db.uri'), adapter_args=dict(migrator=InDBMigrator)) This is better for scalability as there is no filsystem IO. How do people feel with the following: - make the above th

[web2py] i had 4 uwsgi worker defined in nginx and pool_size=10 how many db connection will be created.

2018-09-02 Thread Naveen Kumar
my web2py instance running with nginx + uwsgi + mysql and environment is linux(redhat). recently i am facing an issue as below: resources are temporary unavailable and giving me an response 502 i had 4 uwsgi worker defined in nginx , how many db connection will be created if i didn't define a

[web2py] port 800 busy

2018-09-02 Thread FRANK OJAMBO
hello why do i get this error each time i try to run on my webserver frankizzo@web7:~/www/web2py$ python web2py.py web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2018 Version 2.17.1-stable+timestamp.2018.08.06.01.02.56 Database drivers available: sqlite3, imaplib, pyodbc, pymysq

[web2py] Web2py Python3 ready

2018-09-02 Thread justice Nanhou
Hallo everyone, it is like 3 years now that i learn web2py. and today i will like to start a new project with the framework. for the requirement i have to use python 3 and postgresql. Web2py is the best candidate for this Job but i am not sure if it is already python 3 ready. *does anyone alre

[web2py] Smartgrid links with many-to-many join tables

2018-09-02 Thread miiheikk
Hi, the amount of googling I've fruitlessly put into this problem might indicate that it's either a really remote corner case or something so obvious that I'm the only one missing it. The problem: I've multiple many-to-many relations in my app, and I'm building a simple management interface fo

[web2py] how can i change DAL/Oracle cursor arraysize?

2018-09-02 Thread Thomas Klopf
Hi everyone, Not sure if my last post made it through or not... Please does anyone know a good way to set the 'arraysize' value on the cx_Oracle cursor through web2py? I'm having performance issues with web2py connecting to a remote Oracle DB. I manually connected with cx_Oracle and setti

[web2py] Problem with wsgihandler.py Apache/Python3

2018-09-02 Thread motionbutterfly
Hello, I was wondering if anyone here could help me. I've been migrating a web2py application from Python2.7 to Python3.4, this application was already being hosted in a webserver with Apache2.4 following the steps in the Deployment Recipes chapter of the web2py book. I reconfigured apache to r

Re: [web2py] global name 'Recaptcha' is not defined error when my app is run in web2py 2.17.1 (latest)

2018-09-02 Thread Isaac Nyarkotey
Hi to everyone! I just learnt how to use web2py and I want someone to give me a project to to see whether I can do something on it. On Aug 31, 2018 12:48 PM, "Rahul" wrote: > Hi All, > There seems to be an issue with latest version of web2py 2.17.1. I am > getting an exception like below for

[web2py] Re: Form submit takes too long

2018-09-02 Thread justice Nanhou
Hallo Maurice, it is know issue for all application and all framworks. which database are you using ? - my first attempt will be to try to add indexes in the post and answers Table on the field author. - secondly i will try to change this row > row = db(db.post.author== auth.user.id).select(db.

[web2py] Re: manage web2py app

2018-09-02 Thread Vowner
Hello Stiffan You could do this in betterway as you explained here. We are also planning to bring devops knind of toolchain with web2y tool for our development work. We are also planning to bring jenkins with web2py, but confused about the plan actually. Could you please help us by a suggest

[web2py] Re: web2py & jenkins

2018-09-02 Thread Vowner
I am also having the same doubt. How to make jenkins to automate the testing and deployment of web2py tool. On Thursday, October 17, 2013 at 9:46:40 PM UTC+5:30, Mirko wrote: > > Hi there, > > does anybody here know how to set up jenkins to run "python web2py.py > --run_system_tests" ? > > It wo

[web2py] After 20 GB of data insertion replication is broken in BDR set up

2018-09-02 Thread Soumitra Bhandary
Hi, I have performed below steps and after that , it seems that BDR replication is broken . No DML statement is getting replicated and DDL statements getting hanged . Any suggestion to this please . 1. Executed in Postgres NODE 1 : Below statements : Insert into test_bdr_16 values(gene

[web2py] web2py sqlite3 FOREIGN KEY constraint failed

2018-09-02 Thread Melody Daniel
Hi, I have been fighting this error for a longtime, I can't seem to find out where this error is coming from. MY MODEL db.define_table('discussion',Field('title','string',requires = (IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'discussion.title'))), Field('post','text',requires = IS_NOT_EMPTY()), auth.sign

[web2py] parse_as_rest still experimental

2018-09-02 Thread justice Nanhou
Hi everyone, does somebody already use "parse_as_rest" in Production ? it is like 2 years know i learn Web2py and this function is still experimental. What is actually needed to make it production ready thank in advance Justice -- Resources: - http://web2py.com - http://web2py.com/book (Doc

[web2py] how to set "arraysize" value for the DAL Oracle cursor ?

2018-09-02 Thread Thomas Klopf
Hi everyone! Please I'd appreciate some tips on a problem I'm having.. I have a remote Oracle DB I'm connecting to with web2py, and performance is very slow retrieving large select queries/result sets. I tried manually connecting with the cx_Oracle package, and found a huge performance increa

[web2py] Re: Anyone using Pony ORM with web2py?

2018-09-02 Thread Massimo Di Pierro
It can be used but the forms rely heavily on pydal and that is not a simple fix. Would rquire total rewrite. If you have forfeit pydal and forms, you may as well go barebone and user bottle.py + Pony. On Friday, 3 August 2018 08:58:08 UTC-7, Jim S wrote: > > I've been playing around with Pony OR

[web2py] Re: Help with CAS logout

2018-09-02 Thread Massimo Di Pierro
I think this is a feature, not a bug, as each app has the its own session. But I see why you would want a different behavior. Problem is, as implemented, provider has no info about consumer apps. On Wednesday, 1 August 2018 13:00:05 UTC-7, fiubarc wrote: > > Hello, I am wanting to implement CAS,

[web2py] Re: MySql encryption using DAL

2018-09-02 Thread Massimo Di Pierro
For postgresql it has been there for long time: postgres://{username}:{password}@{domain}:5432/{dbname}?sslmode=require For MySQL it can also be done with current PyDAL. My understanding is that MySQL requires certificates so you 1) you need to install certificates 2) on server side in my

[web2py] Re: HELP: Communication error

2018-09-02 Thread Massimo Di Pierro
It is probably a permission issue and the web server do not have write permission in your app folder. On Friday, 31 August 2018 12:41:05 UTC-7, Carlos Zenteno wrote: > > When editing app source from web interface there is a problem while saving > ...I'm getting 'Last saved on: communication erro

Re: [web2py] Re: Why not to mention support to Python3 on the official sites main page?

2018-09-02 Thread Massimo Di Pierro
Thanks! merged. On Sunday, 19 August 2018 13:17:44 UTC-7, Nico Zanferrari wrote: > > Hi all, > > I've made a PR to update the Download page ( > https://github.com/web2py/web2py/pull/1976). Also, another PR to update > the first chapters of the book ( > https://github.com/web2py/web2py-book/pu

[web2py] AttributeError: 'DAL' object has no attribute 'definitions'

2018-09-02 Thread Maurice Waka
rows = db(db.definitions.definitions).select() File "/usr/local/lib/python2.7/dist-packages/pydal/base.py", line 669, in __getattr__ return BasicStorage.__getattribute__(self, key) AttributeError: 'DAL' object has no attribute 'definitions' I am getting the above error with my code. I am usi

[web2py] Re: Can start cron in 2.17.1

2018-09-02 Thread Massimo Di Pierro
+1 On Wednesday, 15 August 2018 15:09:57 UTC-7, Dave S wrote: > > > > On Tuesday, August 14, 2018 at 3:29:53 PM UTC-7, Omicron VT wrote: >> >> Trying to start the cron with -Y option gives me an error: >> >> " TypeError: argument of type 'NoneType' is not iterable " >> >> Any ideas. Thanks >> > >

[web2py] Re: groupby count/sum on grid

2018-09-02 Thread Massimo Di Pierro
It would be convoluted. It is easier the way you are doing it. On Tuesday, 14 August 2018 02:38:19 UTC-7, JSalvat wrote: > > Hi, How can this be done using SQLFORM.grid ? > > def groupgrid(): > cant = db.emitida.id.count() > suma = db.emitida.total.sum() > rows = > db(db.emitida.n

[web2py] Re: name 'unicode' is not defined in 2.17.1

2018-09-02 Thread Massimo Di Pierro
Fixed it now in trunk. thanks for reporting this. On Monday, 13 August 2018 11:08:59 UTC-7, sandeep patel wrote: > > Hello, > > This was working with 2.16 and python3 but in 2.17.1 I get an error. > > name 'unicode' is not definedVersion > web2py™ Version 2.17.1-stable+timestamp.2018.08.06.01.02