[web2py] making a secure db connection on top of already existing SSL for the site

2019-06-15 Thread Vlad
Here is a quote from the web2py docs: "Making a secure connection Sometimes it is necessary (and advised) to connect to your database using secure connection, especially if your database is not on the same server as your application. In this case you need to pass additional parameters to the

[web2py] switching to postgres [RuntimeError: No driver of supported ones ('psycopg2',) is available]

2019-06-15 Thread Vlad
I am getting the following error: RuntimeError: No driver of supported ones ('psycopg2',) is available I used "pip3 install psycopg2" and pip now reports that psycopg2 is installed. What am I still missing? What's the best (quickest, easiest, and hassle-free) way to use postgres from web2py?

[web2py] Re: Web3py

2019-06-15 Thread 黄祥
still have an error, a bit different told about __iter__ and __len__ $ pip3 install -U -r requirements.txt Successfully built yatl Installing collected packages: yatl Found existing installation: yatl 1.0.6 Uninstalling yatl-1.0.6: Successfully uninstalled yatl-1.0.6 Successfully

[web2py] Re: pyDAL "adapter" for Pandas syntax (phylosophical)

2019-06-15 Thread Massimo Di Pierro
+1 On Monday, 3 June 2019 09:51:56 UTC-7, Leonel Câmara wrote: > > Sorry to dig this thread up, but I had to take a look at this recently. > > I think the most efficient way is to use pydal to make the sql query and > then have pandas do it. As an example say you want a dataframe which has

Re: [web2py] Generating graph with chartjs

2019-06-15 Thread Massimo Di Pierro
mind highcharts is not free On Tuesday, 11 June 2019 09:33:37 UTC-7, Lovedie JC wrote: > > I'm following this discussion. Does the chart have a print to image(jpg, > png, svg) or pdf? > Hicharts does a nice job. > Regards > > On Tue, 11 Jun 2019, 19:25 Dave S wrote: > >> >> >> On Sunday, June

[web2py] Re: Web3py

2019-06-15 Thread Massimo Di Pierro
was a yatl bug in len(XML('')) now fixed in yatl On Saturday, 15 June 2019 00:56:45 UTC-7, 黄祥 wrote: > > *work in web2py* > def json_row_as_list(): > if not request.env.request_method == 'GET': raise HTTP(403) > import json > table_name = request.args(0) > id = request.args(1) >

Re: [web2py] Web2py Windows edition with 3.x Interpreter

2019-06-15 Thread Dave S
On Friday, June 14, 2019 at 9:00:05 AM UTC-7, rāma wrote: > > Hi Dave, > > Nico is right here. I used pip to pre-package modules for easier > distribution. Not really a DLL but works. The only downside is that > distributing the app can be really large. > > Thanks, guys! Dave S /dps > On

[web2py] Re: Upgrading from 2.08 to 2.18.5

2019-06-15 Thread Jim Gregory
On Friday, June 14, 2019 at 2:57:38 PM UTC-5, Jim Gregory wrote: > > > On the old version of my blog, I would get relative URLs > '/blog/', but now I'm getting '/blog/default/'. > SImilar behavior is occurring in the top-level navigation. Has routing > behavior changed? > > I had forgotten

[web2py] Re: Web3py

2019-06-15 Thread 黄祥
*work in web2py* def json_row_as_list(): if not request.env.request_method == 'GET': raise HTTP(403) import json table_name = request.args(0) id = request.args(1) if id.isdigit() and int(id) > 0: query = (db[table_name]['id'] == id) else: query =

[web2py] Re: Web3py

2019-06-15 Thread Massimo Di Pierro
db.tablename.fieldname.readable = False # SAFE def test(): db.tablename.fieldname.readable = False # NOT SAFE *models.py* def on_define_tablename(table): table.fieldname.readable = False # SAFE db.define_table('tablename', Field('fieldname'), on_define = on_define_tablename)

[web2py] Re: Web3py

2019-06-15 Thread Massimo Di Pierro
Does not exist because it is always lazy by default. On Friday, 14 June 2019 21:53:54 UTC-7, 黄祥 wrote: > > *url* = >> http://localhost:8000/_dashboard/dbadmin?app=test=db=address >> *result* = { "__class__": "lazyT", "kwargs": {}, "text": "Field 0", >> "translator": { "__class__": "method" } }