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 vote164 views1 answer
Dataframe, groupby, select one
Python
0 vote178 views1 answer
Matplotlib matrix plot
Python
6 votes168 views3 answers
Pandas drop empty columns
Python
2 votes173 views2 answers
Format binary string python
Python
0 vote170 views2 answers
Merge two sorted lists into one sorted list
Python
8 votes167 views4 answers
Remove nans from array
Python
0 vote167 views1 answer
Python structure like c
Python
11 votes160 views3 answers
Kivy python
Python
9 votes163 views2 answers
TypeError: method() takes 1 positional argument but 2 were given
Python
0 vote170 views1 answer
Matplotlib savefig legend cut off
Python