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 vote180 views1 answer
Remove alphabetic characters python
Python
1 vote174 views1 answer
Python how to create attribute of class while iterating a list
Python
0 vote204 views1 answer
Python subprocess stdout to dev null
Python
213 votes304 views6 answers
Python iterate through dictionary
Python
0 vote180 views1 answer
Xlabel font type matplotlib
Python
0 vote173 views1 answer
Spevify datatype of column
Python
0 vote195 views1 answer
PermissionError: [Errno 13] Permission denied on flask
Python Flask
11 votes178 views6 answers
For enumerate python
Python
0 vote189 views10 answers
EMAIL_BACKEND = 'django.core.mail.backends.console.EmailBackend'
Python Django
0 vote173 views1 answer
Symbol to make things not equeal to something in python
Python