Re: [sqlalchemy] Attaching a second database to a connection

2020-07-07 Thread Mike Bayer
On Tue, Jul 7, 2020, at 8:11 AM, Richard Damon wrote: > Ok, I guess I knew you could execute explicit SQL but wasn't thinking > about it or coming across it in my searches. In my case I wouldn't want > to automatically connect, as it will be done at a specific time for a > specific operation, so

Re: [sqlalchemy] Attaching a second database to a connection

2020-07-07 Thread Richard Damon
Ok, I guess I knew you could execute explicit SQL but wasn't thinking about it or coming across it in my searches. In my case I wouldn't want to automatically connect, as it will be done at a specific time for a specific operation, so I could do the ATTACH specifically. Will I need to explicitly r

Re: [sqlalchemy] Attaching a second database to a connection

2020-07-06 Thread Mike Bayer
On Mon, Jul 6, 2020, at 11:19 PM, Richard Damon wrote: > SQLite allows a program to attach multiple databases to a single > connection, and you are able to reference tables in these additional > databases with things like schema.table as the name of a table. > > Is there a way to do this in SQLA

[sqlalchemy] Attaching a second database to a connection

2020-07-06 Thread Richard Damon
SQLite allows a program to attach multiple databases to a single connection, and you are able to reference tables in these additional databases with things like schema.table as the name of a table. Is there a way to do this in SQLAlchemy? I am working on an application that will want to import da