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

5 votes222 views2 answers
Use selenium without opening browser
Python
11 votes191 views2 answers
Change pandas column value based on condition
Python
0 vote686 views1 answer
RuntimeError: Error in qhull Delaunay triangulation calculation: singular input data (exitcode=2); use python verbose option (-v) to see original qhull error.
Python
219 votes596 views6 answers
Random number python
Python
1 vote181 views1 answer
Unique words from pandas
Python
1 vote184 views1 answer
Python squared math function
Python
0 vote177 views1 answer
Django admin required decorator
Python
0 vote183 views1 answer
Required depend filed odoo
Python
1 vote173 views2 answers
Selenium set chrome executable path
Python
18 votes350 views3 answers
Export flask app
Python Flask