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 vote156 views1 answer
\n vs \r python
Python
0 vote121 views1 answer
How to extract keys from dictreader python
Python
9 votes159 views3 answers
SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead
Python
0 vote173 views1 answer
Are angles of a parallelogram equal?
Python
4 votes184 views3 answers
ArrayField in Django
Python Django
0 vote172 views1 answer
Python load file with multiple jsons
Python
1 vote177 views1 answer
Pandas drop column by index range
Python
1 vote160 views1 answer
Sns title
Python
0 vote171 views1 answer
Python code to replace first value of txt file
Python
6 votes164 views2 answers
Python re search print
Python