Quote:I thought conn = would open the database sqlite file if it exist or create the file if it doesn't?I was referring to a table, not a file, my mistake. To create a table if it doesn't exist, use
cur.execute("CREATE TABLE IF NOT EXISTS " etc.
Quote:slight error on database open:I import sqliteX as sqlite. Then, if there is a version change I only have to update the import statement.
open database with:
con = sqlite3.connect(table_name)