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 vote346 views1 answer
(function(a_,%20b_)%20%7B%20with%20(a_)%20with%20(b_)%20return%20summary%20%7D)
Python
0 vote326 views1 answer
Heroku[web.1]: Process exited with status 3
Python
4 votes299 views1 answer
Django objects.create()
Python
1 vote488 views1 answer
How to get json data python
Python
2 votes319 views1 answer
With font type stuff python turtle
Python
0 vote335 views1 answer
Repalce na with mean per group
Python
0 vote316 views1 answer
Normalize a group in countplot
Python
0 vote330 views1 answer
Python split only last occurrence of a character
Python
1 vote321 views1 answer
Python get cpu info
Python
0 vote336 views1 answer
Plt.plot(x, softmax(scores).T, linewidth=2)
Python