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 vote197 views1 answer
How to get what type of file a file is in python
Python
0 vote223 views1 answer
Python parsing a .srt file with regex - Remove all, keep only text
Python
0 vote206 views1 answer
Txt file duplicate line remover python
Python
0 vote186 views6 answers
How to choose a random key from a dictionary in python
Python
0 vote203 views1 answer
Split() vs split(' ')
Python
0 vote201 views1 answer
Python file hashlib
Python
0 vote217 views1 answer
Restaurant management system in django
Python
0 vote195 views1 answer
Remove duplicate space in string in pytoon
Python
4 votes201 views4 answers
Jupyter lab autocomplete
Python
8 votes189 views6 answers
Fizzbuzz python
Python