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

4 votes249 views1 answer
Matplotlib plot dashed
Python
3 votes284 views3 answers
Python post request
Python
30 votes253 views4 answers
UnicodeDecodeError: 'utf-8' codec can't decode byte invalid start byte
Python
0 vote254 views2 answers
Python list to string with spaces
Python
0 vote251 views1 answer
Tiktok python bot
Python
1 vote262 views2 answers
Selenium set chrome executable path
Python
0 vote302 views1 answer
Torch.cuda.randn
Python
0 vote275 views1 answer
ModuleNotFoundError: No module named 'html5lib'
Python
3 votes284 views3 answers
Matplotlib transparency
Python
0 vote258 views1 answer
Series distict
Python