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

17 votes107 views2 answers
Return count of unique values pandas
Python
0 vote114 views1 answer
How to make a operating system in python
Python
0 vote112 views2 answers
Rotatelist in python
Python
11 votes111 views6 answers
Python get file size
Python
0 vote106 views1 answer
Matplotlib inside Jupyter | Jupyter generate graphs.
Python
1 vote156 views1 answer
Max pooling tf keras
Python
204 votes169 views6 answers
How to read a file in python
Python
4 votes141 views2 answers
Urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1123)>
Python
3 votes112 views1 answer
Numpy how to calculate variance
Python
0 vote103 views1 answer
Start a webservice quickly using python2.7
Python