Thanks it is nice post.
I also refer very useful and helpful article about SQLite - ATTACH DATABASE
Please visit this helpful article.
http://www.mindstick.com/blog/10947/SQLite%20ATTACH%20DATABASE#.VffLzhFViko
http://www.tutorialspoint.com/sqlite/sqlite_attach_database.htm
--
You received this
I tried the following:
import sqlalchemy as SA
md_dbA=SA.BoundMetaData('dbA')
tbl_dbAtbl=SA.Table('dbAtbl',md_dbA,autoload=True)
SA.text(ATTACH DATABASE 'C:Temp\dbB.db' as dbB_db)
tbl_dbBtbl=SA.Table('dbB_db.dbBtbl',md_dbA,schema='dbB_db',autoload=True)
===
The code fails on the line
I tried the following:
import sqlalchemy as SA
md_dbA=SA.BoundMetaData('dbA')
tbl_dbAtbl=SA.Table('dbAtbl',md_dbA,autoload=True)
SA.text(ATTACH DATABASE 'C:Temp\dbB.db' as dbB_db)
tbl_dbBtbl=SA.Table('dbB_db.dbBtbl',md_dbA,schema='dbB_db',autoload=True)
===
The code fails on the line
attach database ...wow i never knew it had that ! if its a matter of
issuing the string attach database, just use literal text() or
engine.execute().
attach databasevery handy !
On Mar 9, 9:43 am, Karlo Lozovina [EMAIL PROTECTED] wrote:
Greetings everyone,
does SQLAlchemy somehow
On Mar 9, 4:33 pm, Michael Bayer [EMAIL PROTECTED] wrote:
attach database ...wow i never knew it had that ! if its a matter of
issuing the string attach database, just use literal text() or
engine.execute().
Me neither ;), until the other day I started looking for an efficient
way to dump
OK, just read over ATTACH, you issue the ATTACH DATABASE command
textually. from that point on, the tables in that database are
accessible using a schemaname syntax (i.e. schemaname.tablename).
if you really want to just copy tables wholesale, yeah youd have to
issue INSERT ... SELECT