db_source.db with tbs1, tbs2
db_dest.db with tbd1, tbd2

conn = sqlite3.connect(db_dest)

sql = """
attach db_source.db as db_source;
drop table if exists tbs1  # it is used to check if tbs1 already in db_dest.
"""
Conn.execute(sql)
Above will delete tbs1 from db_source.db
it might be a bug cause wrong deletion of tbs1 from db_source

I also tried other cases,
conn = sqlite3.connect(db_dest)
Sql = """
Attach db_source.db as db_source;
Select * from tbs1;
"""
Conn.execute(sql)
Above code works, it might also be a bug, it should be "select * from 
db_source.tbs1",
"select * from tbs1" should point to "db_dest.tbs1" instead of db_source.tbs1"


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to