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

58 votes220 views6 answers
Python class definition
Python
14 votes110 views2 answers
What does related name do in django
Python
0 vote127 views1 answer
Na in python
Python
3 votes153 views5 answers
Pytorch check gpu
Python
5 votes133 views2 answers
Python get everything between two characters
Python
1 vote165 views1 answer
Flask enumerate index
Python Flask
0 vote133 views1 answer
Python ai for stock trading
Python
0 vote131 views1 answer
From sklearn.metrics import confusion_matrix pred = model.predict(X_test) pred = np.argmax(pred,axis = 1) y_true = np.argmax(y_test,axis = 1)
Python
0 vote140 views1 answer
Time in regression expression python
Python
0 vote128 views1 answer
Python print class variables
Python