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

7 votes174 views5 answers
Remove extension from filename python
Python
0 vote207 views1 answer
Merge two list of dictionaries python with string
Python
0 vote249 views1 answer
Check if a date is reached django
Python Django
1 vote205 views1 answer
2d array pytho
Python
18 votes232 views9 answers
Dictionary in python
Python
1 vote224 views1 answer
Selenium refresh till the element appears python
Python
12 votes200 views5 answers
Conda python update
Python
0 vote181 views1 answer
Django serialize a get object is not iterable
Python
-1 vote248 views1 answer
Regex find all sentences python
Python
20 votes195 views1 answer
Pil get image type
Python