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

0 vote176 views1 answer
How to install flask module in vscode
Python Flask
0 vote119 views1 answer
Turn of warning iin python
Python
2 votes137 views2 answers
Sqlalchemy python install
Python
0 vote137 views1 answer
Python sleeping with a varible
Python
0 vote133 views1 answer
Plague meaning
Python
7 votes122 views6 answers
How to create a function in python
Python
0 vote141 views1 answer
How to save model to a file python
Python
0 vote175 views1 answer
How to write to a netcdf file using xarray
Python
0 vote126 views1 answer
Save jupyter notebook session
Python
10 votes125 views4 answers
Python bold text
Python