[web2py] Re: Handling OPTIONS request in a web2py RESTful API

2019-11-27 Thread mcamel
I think you have to add code to handle OPTIONS the same way is described in the manual for GET, POST, PUT, DELETE. In my case it worked just adding this: def OPTIONS(*args, **vars): return dict() El viernes, 10 de mayo de 2013, 13:47:05 (UTC+2), Daniel Gonzalez escribió: > >

[web2py] Re: Problem passing a json object to controller

2019-11-27 Thread Patito Feo
Paco, thanks for your help! Y Olé El miércoles, 20 de noviembre de 2019, 18:32:47 (UTC-5), Paco Bernal escribió: > > H again :) > > I think the problem is this > > Instead of > > request.vars.items[json1] >> > > use this > > request.vars['items[json1]'] >> > > because the var is 'items[jso

Re: [web2py] No Column error

2019-11-27 Thread Maurice Waka
I got this error after installing psycopg2 Traceback (most recent call last): File "/home/mauricewaka/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File "/home/mauricewaka/web2py/applications/myappname/controllers/default.py", line 219, in File "/home/m

[web2py] Re: Error opening upload files after upgrading to python 3

2019-11-27 Thread Áureo Dias Neto
I updated the ubuntu packages and everything worked as normal. I didn't know there was a relationship between pydal outside the web2py environment. thanks Em quarta-feira, 27 de novembro de 2019 12:03:39 UTC-3, Áureo Dias Neto escreveu: > > I upgraded from python 2 to 3.6.8 and can no longer

[web2py] Off topic : visual diagrams anyone ???

2019-11-27 Thread António Ramos
Hard to find a tool like this for my web2py app https://mermaidjs.github.io/#/ -- 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 mess

[web2py] ValueError: invalid literal for int() with base 10 for 'id' Field

2019-11-27 Thread Jitun John
Hi, Here is my code. *postgres_db = DAL("postgres://postgres@localhost:5432/" + get_postgres_db_filename(), auto_import=True, pool_size=10, migrate_enabled=False, fake_migrate_all=True)* "get_postgres_db_filename()" will get you "CaptureOutput-2019-11-15_03-25-19-MN" I have defined the t

[web2py] web2py for (R)OLAP (pivoting)?

2019-11-27 Thread Jurgis Pralgauskis
Hi, OLAP Cube model is based on dimensions (what to group by) and metrics (what to aggregate). Dimensions are mostly categorical data -- so can be nearly any fields (mostly FK). Metrics would be aggregations of number fields. -- But [how] could they be described (incorporated into data mode

[web2py] Re: Anyone have a sample haproxy.cfg file for haproxy v 1.8

2019-11-27 Thread Jim S
Here is what I have currently: global log /dev/loglocal0 log /dev/loglocal1 notice chroot /var/lib/haproxy stats socket /run/haproxy/admin.sock mode 660 level admin expose-fd listeners stats timeout 30s user haproxy group haproxy daemon # Default SSL m

[web2py] Re: Anyone have a sample haproxy.cfg file for haproxy v 1.8

2019-11-27 Thread Krishna Bavandlapally
Thank you Jim S for your great help. I am also waiting for the Redis fix. Kindly let me know better alternative for cache. Thank you in advance. On Thursday, 28 November 2019 04:46:59 UTC+5:30, Jim S wrote: > > Here is what I have currently: > > global > log /dev/loglocal0 > log /

Re: [web2py] Re: Anyone have a sample haproxy.cfg file for haproxy v 1.8

2019-11-27 Thread Jim Steil
I'm still using redis for caching, but not for sessions. Per the web2py book, I'm storing sessions in the database now. The redis_session module is where the problem is. Jim On Wed, Nov 27, 2019, 10:31 PM Krishna Bavandlapally < b.krishna2...@gmail.com> wrote: > Thank you Jim S for your great

[web2py] web2py for (R)OLAP (pivoting)?

2019-11-27 Thread Val K
Hi !, you can pass sql expressions to select() : .select(db.tbl.field, 'SUM(sometbl.somefield) OVER(PARTITION BY sometbl.anotherfield) AS mysum )') -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.co