Kenneth Shuai wrote:
> 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)

Okay, let's try:

  >>> conn = sqlite3.connect(db_dest)
  Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
  NameError: name 'db_dest' is not defined
  >>> conn = sqlite3.connect("db_dest.db")
  >>> 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)
  Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
  NameError: name 'Conn' is not defined
  >>> conn.execute(sql)
  Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
  sqlite3.OperationalError: no such column: db_source.db
  >>> 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)
  Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
  sqlite3.Warning: You can only execute one statement at a time.
  >>> sql2 = """
  ... drop table if exists tbs1  # it is used to check if tbs1 already in 
db_dest.
  ... """
  >>> conn.execute(sql2)
  Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
  sqlite3.OperationalError: unrecognized token: "#"
  >>> sql2 = """
  ... drop table if exists tbs1  -- it is used to check if tbs1 already in 
db_dest.
  ... """
  >>> conn.execute(sql2)
  >>>

> Above will delete tbs1 from db_source.db

Yes.

> it might be a bug cause wrong deletion of tbs1 from db_source

Why do you think is is wrong?

<http://www.sqlite.org/lang_attach.html> says:
| Tables in an attached database can be referred to using the syntax
| schema-name.table-name. If the name of the table is unique across all
| attached databases and the main and temp databases, then the schema-
| name prefix is not required.


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

Reply via email to