[web2py] Why the response.flash can't be dismissed here?

2017-04-04 Thread Mike Stephenson
I am using this layout from web2py's official site: web2py.plugin.layout_Chasmogamous However I see that the response.flash can't be dismissed. I guess there is a problem with this snippet in its layout.html: {{=response.flash or ''}} How do I make it work like it does in default layout? This sn

[web2py] Re: smartgrid with linked_tables and constraints broke the links

2017-04-04 Thread Rudy
Hi Anthony, Pardon me for asking stupid question, what does SQLFORM.smartgrid(., args=request.args[:1], ...) really do? you mentioned in earlier post that args must be a list, and it preserves the 1st argument of URL for application specific use. Does it tell web2py whatever url it creates,

Re: [web2py] Sites Powered by web2py

2017-04-04 Thread Fabiano Almeida
Hi Alex! Great design ! Congratulations! I see use of subdomain to breeds, how do you do it? thx, Fabiano. 2017-04-02 17:58 GMT-03:00 Alex : > The section for "Sites Powered by web2py" does not look very promising and > also seems outdated. Most pages don't have a screenshot and some of them >

[web2py] Android Logging in by passing arguments in the URL and returning a Token

2017-04-04 Thread Oasis Agano
Greetings I'm trying to build an android app that connects and load data from web2py server/App. I runt into a code on github using this as the route: *final String url = initial + "/default/login.json?userid=" + username + "&password=" + password;* i tried opening it in the url i g

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-04 Thread Jim Steil
I don't believe https is supported for git. Or, at least it wasn't for some time. You can try cloning with ssh, but I seem to recall that failing as well. -Jim On Tue, Apr 4, 2017 at 10:15 AM, 'DenesL' via web2py-users < web2py@googlegroups.com> wrote: > The instruction is to use a git clone c

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-04 Thread 'DenesL' via web2py-users
The instruction is to use a git clone command as follows [usro5gha@SPACES]~% git clone --recursive https://github.com/web2py/web2py.git Cloning into 'web2py'... fatal: Unable to find remote helper for 'https' but it obviuosly fails. I hav

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-04 Thread Jim S
And then if I try to install pysqlite I get: [usrxkcon@SPACES]~/web2py% easy_install pysqlite==2.7.0 Searching for pysqlite==2.7.0 Reading http://pypi.python.org/simple/pysqlite/ Best match

Re: [web2py] JQuery in Web2Py

2017-04-04 Thread Richard Vézina
Hello, You have mistake in you script tag : https://www.w3schools.com/tags/tag_script.asp And not type="text/javascript" src="default/show.html" ... I am not sure why you specify a source as you seem (or should) to include the this little piece of js into the same view file for wh

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-04 Thread Jim Steil
Pretty sure I downloaded the zip file from github and extracted it. Then started with command line options specifying IP of 0.0.0.0 and port. Port can be determined by clicking on the More Info icon on the on your Spaces page. Also, here is the error I'm getting with the Welcome app: [image: In

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-04 Thread 'DenesL' via web2py-users
Could you detail how you install and start web2py on litmis?. On Tuesday, April 4, 2017 at 9:40:38 AM UTC-4, Jim S wrote: > > The error I'm getting on litmis has to do with pysqlite. I was going to > jump on and get you my error message, but seems I can't connect right now. > > -Jim > > On Tue,

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
Thank you, I'll try to migrate to mysql and keep on a server for now -- 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

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Jim Steil
I'm using redis only for session caching. But others would use it for static page caching or caching lists and other heavily used static items. For now I'd start with the basics and just get a different database regardless of which server it runs on. 3000 users is not, but isn't that large. I'm a

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
It's interesting to think about this possibility ... I'm thinking of something around 3 thousand users, but transactions can vary a lot, since I can have 10 or 1000 users online .. I did not measure this detail right .. How to configure Redis server for caching? And if I keep a single server for t

Re: [web2py] Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Kenneth
I changed the {} to [] and it seams to be working now. Interesting. Kenneth Den tisdag 4 april 2017 kl. 16:28:49 UTC+3 skrev Kenneth: > > Hi, > > I found a list of packages that was updated yesterday when I updated the > server and python 2.6 was updated to newest 2.6 version, I'm guessing th

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-04 Thread Jim Steil
The error I'm getting on litmis has to do with pysqlite. I was going to jump on and get you my error message, but seems I can't connect right now. -Jim On Tue, Apr 4, 2017 at 8:30 AM, 'DenesL' via web2py-users < web2py@googlegroups.com> wrote: > I tried running web2py on PUB400 but I get > >

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Jim S
The advantages would be more processing power and separation of duties. In our environment, we have: * database server (MySQL) * Load balancer (haproxy) * Multiple webservers running nginx/uwsgi/web2py * Redis server for caching By separating the database server from the webserver we can then s

[web2py] Re: wfastcgi on IIS ... no more wfastcgi.py script?

2017-04-04 Thread Johann du Preez
This helped me a lot. Thanks. Do you know if the 'scriptProcessor' can be set relatively? On Monday, December 14, 2015 at 6:45:21 AM UTC+2, Tim Richardson wrote: > > > > On Monday, 14 December 2015 13:36:05 UTC+11, Tim Richardson wrote: >> >> wfastcgi is now a module on PyPi >> >> after installin

[web2py] JQuery in Web2Py

2017-04-04 Thread Nicholas Nicolaou
I currently have a page in Web2Py that displays an image. I want this image to fade in when the page has loaded, but I am not how to implement this JQuery to my web2py page in order to do so. Here is the view page (show.html) that contains the image (Product_Image): {{extend 'layout.html'}}

[web2py] WEB2PY CAS with basic auth

2017-04-04 Thread Muhammad Bilal
Hi Massimo I am developing a project where I have two web2py applications App A is provider and App B is consumer. So I have setup CAS in consumer and it is working fine for normal browser stuff. But when I am trying to use basic auth with restful api then I always get Not Authorized. If I re

[web2py] Re: How to make smartgrid redirect to edit after creating new record?

2017-04-04 Thread Shashank Upadhyay
thanks Adi it was really helpful On Friday, December 23, 2011 at 11:14:17 PM UTC+5:30, Adi wrote: > > this works: > > grid=SQLFORM.smartgrid(db.purchase_order, details=False, > links_in_grid=True, > maxtextlengths={'purchase_order.po_number':15,}, >

[web2py] Re: how to get user name before login is completed

2017-04-04 Thread felipe . marcos
thanks for help. Em sexta-feira, 15 de julho de 2011 05:25:47 UTC-3, J Zaragoza escreveu: > > In a view: > > {{if auth.user_id:}} > {{=H4(T('Welcome ') + db.auth_user[auth.user_id].first_name)}} > {{pass} > > > > On 14 jul, 14:42, Anthony wrote: > > On Thursday, July 14, 2011 1:03:24 AM

Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-04 Thread 'DenesL' via web2py-users
I tried running web2py on PUB400 but I get File "/QOpenSys/QIBM/ProdData/OPS/Python2.7/lib/python2.7/threading.py", line 736, in start _start_new_thread(self.__bootstrap, ()) thread.error: can't start new thread Does web2py work on litmis?. Denes On Wednesday, March 29, 2017 at 2:40:07

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
Are the advantages of using mysql on another server? Or does this solution vary from my hardware? 2017-04-04 10:22 GMT-03:00 Jim S : > Take a look here http://web2py.com/books/default/chapter/29/06/the- > database-abstraction-layer#Connection-strings--the-uri-parameter- > > Then, for MySQL, chang

Re: [web2py] Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Kenneth
Hi, I found a list of packages that was updated yesterday when I updated the server and python 2.6 was updated to newest 2.6 version, I'm guessing this is the reason why I'm getting the errors right now. But I don't understand why I'm getting errors. Kenneth Den tisdag 4 april 2017 kl. 16:

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
i will try this, thanks man 2017-04-04 10:15 GMT-03:00 黄祥 : > perhaps you can use export import csv for that > 1. export the sqlite data into *.csv > 2. change the database connection from sqlite into mysql or postgresql > (appconfig.ini of db.py) > 3. ensure the migrate is True > 4. hit appadmin

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Jim S
Take a look here http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings--the-uri-parameter- Then, for MySQL, change the localhost in the connectstring to the name of your database server. You also have to make sure that MySQL is set to allow remote con

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread 黄祥
perhaps you can use export import csv for that 1. export the sqlite data into *.csv 2. change the database connection from sqlite into mysql or postgresql (appconfig.ini of db.py) 3. ensure the migrate is True 4. hit appadmin once to create table 5. after that import *.csv ref: http://web2py.com

Re: [web2py] Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Áureo Dias Neto
you do not need multiple = True? to use checkboxes 2017-04-04 10:07 GMT-03:00 Kenneth : > Hi, > > everything was wortking yesterday, so IS_IN_SET should be OK. > > Full traceback is (or do you need anymore of it): > > Traceback (most recent call last): > File "/data/web2py/gluon/restricted.py",

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
How to migrate data from sqlite to mysql or postgre? I tried to migrate the data to mysql using the workbench, but it did not work .. And, how would this question the database on another server? How does the connection work? -- Resources: - http://web2py.com - http://web2py.com/book (Documentati

Re: [web2py] Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Kenneth
Hi, everything was wortking yesterday, so IS_IN_SET should be OK. Full traceback is (or do you need anymore of it): Traceback (most recent call last): File "/data/web2py/gluon/restricted.py", line 226, in restricted ccode = compile2(code, layer) File "/data/web2py/gluon/restricted.py", l

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Jim S
Then, in my opinion the first thing to do would be to move to MySQL or Postgresql and I'd put the database on a different server. For me, I'd go with MySQL but others here on the list may argue that postgres is the better option. I don't feel that fetching the 'full' html is the issue. It ha

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
Right, i'm using sqlite actualy 2017-04-04 9:51 GMT-03:00 Jim S : > I personally am a MySQL guy, but for high volume databases I think some > may say postgres would be a better option. > > Regarding middleware, I was referring to uwsgi. > > So, which database are you currently using? > > -Jim > >

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Jim S
I personally am a MySQL guy, but for high volume databases I think some may say postgres would be a better option. Regarding middleware, I was referring to uwsgi. So, which database are you currently using? -Jim On Tuesday, April 4, 2017 at 7:40:33 AM UTC-5, Áureo Dias Neto wrote: > > I use n

Re: [web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
I use nginx with uwsgi as a server in the centos .. the database, I was wondering if you have experiences on performance between sqlite and mysql or postgresql? -middleware in case, would it be in REST applications? thanks 2017-04-04 9:33 GMT-03:00 Jim S : > It might help if you described your

[web2py] Re: Questions about production environment / large applications

2017-04-04 Thread Jim S
It might help if you described your production environment a bit. What servers/middleware? What database? -Jim On Tuesday, April 4, 2017 at 7:10:53 AM UTC-5, Áureo Dias Neto wrote: > > Friends, assuming a hypothetical application .. > > If I have a large multiuser and monolithic application .

[web2py] Re: smartgrid with linked_tables and constraints broke the links

2017-04-04 Thread Anthony
> > here is the minimal app, and I did reproduce the problem and narrowed > where it broke. > In view_invoices() action, it checks if customer id args is provided, if > so it will take it in for invoice_query = db.invoice.customer==customer_id, > if not invoice_query = db.invoice.customer != N

[web2py] Questions about production environment / large applications

2017-04-04 Thread Áureo Dias Neto
Friends, assuming a hypothetical application .. If I have a large multiuser and monolithic application .. with the growing of it (more clients, more concurrent accesses) .. I have some doubts .. For example search and report screens: 1) If I ask to fetch records and fill a table with 200 record

Re: [web2py] Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Anthony
On Tuesday, April 4, 2017 at 7:05:25 AM UTC-4, Áureo Dias Neto wrote: > > the correct is: > > requires=IS_IN_SET(['Only one option '])) > > IS_IN_SET should be able to take a Python set object rather than a list, so {} vs. [] shouldn't be the issue. Anthony -- Resources: - http://web2py.com - h

[web2py] Re: Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Anthony
Can you show the full traceback? On Tuesday, April 4, 2017 at 4:16:31 AM UTC-4, Kenneth wrote: > > Hi, > > yesterday I did a yum update on my CentOS server and today I'm getting > errors on rows using IS_IN_SET? > > I'm using Python 2.6 for web2py and that one was not updated. I know a lot > was

[web2py] Re: how to get ALL db._timings -- override TIMINGSSIZE without touching base.py

2017-04-04 Thread Anthony
Yeah, just monkey patch TIMINGSSIZE in adapters/base.py. Anthony On Tuesday, April 4, 2017 at 7:24:58 AM UTC-4, Jurgis Pralgauskis wrote: > > Hi, > > in some older web2py ( Version > 2.10.4-stable+timestamp.2015.04.26.15.11.54 ) > and I want to get all the SQL's of the request.. > > I see, tha

[web2py] how to get ALL db._timings -- override TIMINGSSIZE without touching base.py

2017-04-04 Thread Jurgis Pralgauskis
Hi, in some older web2py ( Version 2.10.4-stable+timestamp.2015.04.26.15.11.54 ) and I want to get all the SQL's of the request.. I see, that they are stored in db._timings but truncated to 100 in adapters/base.py TIMINGSSIZE = 100 def log_execute(self, *a, **b): *...* ret = s

Re: [web2py] Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Áureo Dias Neto
the correct is: requires=IS_IN_SET(['Only one option '])) 2017-04-04 5:16 GMT-03:00 Kenneth : > Hi, > > yesterday I did a yum update on my CentOS server and today I'm getting > errors on rows using IS_IN_SET? > > I'm using Python 2.6 for web2py and that one was not updated. I know a lot > was u

[web2py] Re: smartgrid with linked_tables and constraints broke the links

2017-04-04 Thread Rudy
Hi Anthony, here is the minimal app, and I did reproduce the problem and narrowed where it broke. In view_invoices() action, it checks if customer id args is provided, if so it will take it in for invoice_query = db.invoice.customer==customer_id, if not invoice_query = db.invoice.customer != N

[web2py] Upgraded OS, now IS_IN_SET now working

2017-04-04 Thread Kenneth
Hi, yesterday I did a yum update on my CentOS server and today I'm getting errors on rows using IS_IN_SET? I'm using Python 2.6 for web2py and that one was not updated. I know a lot was updated but not exactly what, didn't pay much attention to it. If I comment out rows having IS_IN_SET the ap