Python create sqlite db file

import sqlite3
from sqlite3 import Error


def create_connection(db_file):
    """ create a database connection to a SQLite database """
    conn = None
    try:
        conn = sqlite3.connect(db_file)
        print(sqlite3.version)
    except Error as e:
        print(e)
    finally:
        if conn:
            conn.close()


if __name__ == '__main__':
    create_connection(r"C:\sqlite\db\pythonsqlite.db")
Code language: Python (python)

Source: sqlitetutorial.net

Similar codes

14 votes126 views2 answers
Tkinter clear canvas
Python
0 vote201 views3 answers
Python with quick sort
Python
0 vote203 views2 answers
Deleting files which start with a name
Python
1 vote126 views1 answer
Python ignore return value
Python
0 vote182 views1 answer
Discord py replace characters from string
Python
0 vote288 views1 answer
Inpuit inf terfminal ppython
Python
0 vote182 views2 answers
Message: 'geckodriver' executable needs to be in PATH.
Python
0 vote172 views1 answer
Pandas dataframe from array of dict
Python
0 vote169 views1 answer
Doc2text python example
Python
28 votes137 views2 answers
Np zeroes
Python