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

2 votes181 views1 answer
Matplotlib insert text
Python
0 vote254 views1 answer
How to list gym envirolments
Python
2 votes226 views2 answers
Import other python files
Python
16 votes210 views3 answers
How to find total no of nan values in pandas
Python
2 votes213 views1 answer
Python unchain list
Python
-1 vote207 views1 answer
Example exponential distribution python
Python
4 votes191 views1 answer
Python dictionary add key-value pair
Python
0 vote211 views1 answer
Head first python by paul barry pdf
Python
0 vote250 views1 answer
Windows 10 reset django migrations
Python
2 votes203 views2 answers
Pandas update with condition
Python