Re: [web2py] Multiple connections/ databases with same app

2016-03-13 Thread Shane Raney
I did notice, if I pull the DB generation from a .py file in modules and move it into the the db.py file, I see it inside the web management gui. On Sun, Mar 13, 2016 at 9:33 AM, Shane Raney wrote: > Opps, that was a typo on my behalf while reproducing the code on my iPad. > Good catch though.

Re: [web2py] Multiple connections/ databases with same app

2016-03-13 Thread Shane Raney
Opps, that was a typo on my behalf while reproducing the code on my iPad. Good catch though. On Sun, Mar 13, 2016 at 9:31 AM, Paolo Caruccio wrote: > and by replacing "poolsize" to "pool_size"? > > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#DAL-signature

Re: [web2py] Multiple connections/ databases with same app

2016-03-13 Thread Paolo Caruccio
and by replacing "poolsize" to "pool_size"? http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#DAL-signature Il giorno domenica 13 marzo 2016 17:12:17 UTC+1, Shayn Raney ha scritto: > > Even If I rename the db's to just 'Cats' I see the same issue. > > > On Mar 13

Re: [web2py] Multiple connections/ databases with same app

2016-03-13 Thread Shane Raney
Even If I rename the db's to just 'Cats' I see the same issue. > On Mar 13, 2016, at 4:08 AM, Paolo Caruccio > wrote: > > Try to replace dash ("-") with uderscore ("_") in the variable names i.e. > db_cats > > > Il giorno sabato 12 marzo 2016 15:10:33 UTC+1, Shayn Raney ha scritto: >> >>

Re: [web2py] Multiple connections/ databases with same app

2016-03-13 Thread Paolo Caruccio
Try to replace dash ("-") with uderscore ("_") in the variable names i.e. db_cats Il giorno sabato 12 marzo 2016 15:10:33 UTC+1, Shayn Raney ha scritto: > > I would like to implement something like this to use two sqlite3 > databases. I've tried to create the following within a new model via t

Re: [web2py] Multiple connections/ databases with same app

2016-03-12 Thread Shayn Raney
I would like to implement something like for a project that uses two sqlite3 databases? I've tried to create the following within a new model via the web admin gui and did not see the new tables under the 'Available Databases and Tables' appadmin page. Does the 'Available Databases and Tables'

Re: [web2py] Multiple connections/ databases with same app

2013-01-02 Thread Simon Ashley
Sorry Alec, I saw that just as posted it and tried to delete it. It came through again afterwards. This wasn't the issue, just an example returning the same error. Solved it ... was in the query=db() statements, which should have been changed to query=db1() etc. Thanks for your reply.

Re: [web2py] Multiple connections/ databases with same app

2013-01-02 Thread Alec Taylor
On Wed, Jan 2, 2013 at 10:53 PM, Simon Ashley wrote: > Ok then, should this work? > (Version 2.3.2 (2012-12-17 15:03:30) stable, source, nightly build, from > 12/31) > > *Connection* > db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) > db1 = DAL('mysql://root:www@localhost:3

Re: [web2py] Multiple connections/ databases with same app

2013-01-02 Thread Simon Ashley
Ok then, should this work? (Version 2.3.2 (2012-12-17 15:03:30) stable, source, nightly build, from 12/31) *Connection* db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) db1 = DAL('mysql://root:www@localhost:3306/xxx', migrate=True, fake_migrate= False, check_reserved=['commo

Re: [web2py] Multiple connections/ databases with same app

2013-01-02 Thread Alec Taylor
Yep, that's possible. Feature trivial to utilise in web2py; difficult or unimplemented with other frameworks. On Wed, Jan 2, 2013 at 8:56 PM, Simon Ashley wrote: > Quick question - is this do able i.e. some tables - e.g. db = > DAL('sqlite://storage.sqlite), other tables - db1 = DAL('mysql

[web2py] Multiple connections/ databases with same app

2013-01-02 Thread Simon Ashley
Quick question - is this do able i.e. some tables - e.g. db = DAL('sqlite://storage.sqlite), other tables - db1 = DAL('mysql://root: ) etc, within the same application/controller/function? If so, will write up an issue we're having. TIA --