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 vote185 views1 answer
Class 10: Conditional Statements in Python [IF, ELIF, ELSE]
Python
0 vote148 views1 answer
Move one column value down by one column in pandas
Python
0 vote158 views1 answer
Spyder new instance
Python
0 vote137 views1 answer
Gui radio button python
Python
2 votes152 views2 answers
How to round to the nearest 25 python
Python
0 vote147 views1 answer
Remove toggle/pandaslux
Python
0 vote139 views1 answer
How a 16 mp camera looks like
Python
3 votes152 views1 answer
How to exit command prompt
Python
15 votes142 views3 answers
Get the current year in python
Python
0 vote159 views1 answer
Enumerate to skip items
Python