SyntaxFix

[sqlite] Create table in SQLite only if it doesn't exist already

Am going to try and add value to this very good question and to build on @BrittonKerin's question in one of the comments under @David Wolever's fantastic answer. Wanted to share here because I had the same challenge as @BrittonKerin and I got something working (i.e. just want to run a piece of code only IF the table doesn't exist). 

        # for completeness lets do the routine thing of connections and cursors
        conn = sqlite3.connect(db_file, timeout=1000) 

        cursor = conn.cursor() 

        # get the count of tables with the name  
        tablename = 'KABOOM' 
        cursor.execute("SELECT count(name) FROM sqlite_master WHERE type='table' AND name=? ", (tablename, ))

        print(cursor.fetchone()) # this SHOULD BE in a tuple containing count(name) integer.

        # check if the db has existing table named KABOOM
        # if the count is 1, then table exists 
        if cursor.fetchone()[0] ==1 : 
            print('Table exists. I can do my custom stuff here now.... ')
            pass
        else: 
           # then table doesn't exist. 
           custRET = myCustFunc(foo,bar) # replace this with your custom logic

Examples related to sqlite

• getting " (1) no such column: _id10 " error • Laravel: PDOException: could not find driver • auto create database in Entity Framework Core • How to open .SQLite files • Accessing an SQLite Database in Swift • When does SQLiteOpenHelper onCreate() / onUpgrade() run? • Attempt to write a readonly database - Django w/ SELinux error • Android sqlite how to check if a record exists • How can I add the sqlite3 module to Python? • "Insert if not exists" statement in SQLite

Examples related to create-table

• Field 'id' doesn't have a default value? • MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB • Create hive table using "as select" or "like" and also specify delimiter • #1064 -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version • C# - Create SQL Server table programmatically • How do I create a table based on another table • Creating new table with SELECT INTO in SQL • create table in postgreSQL • PostgreSQL Error: Relation already exists • Mysql: Setup the format of DATETIME to 'DD-MM-YYYY HH:MM:SS' when creating a table

Examples related to database-table

• Count the Number of Tables in a SQL Server Database • SQL count rows in a table • Mysql: Select rows from a table that are not in another • Import CSV to mysql table • MySQL > Table doesn't exist. But it does (or it should) • Create table in SQLite only if it doesn't exist already • Copy a table from one database to another in Postgres • Truncating all tables in a Postgres database • Maximum number of records in a MySQL database table • Why use multiple columns as primary keys (composite primary key)