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

1 vote339 views1 answer
Python get address of object
Python
0 vote391 views1 answer
Django queryset group by sum
Python Django
1 vote347 views1 answer
Python - count values that contain special characters
Python
0 vote314 views1 answer
Get list of all document in django-elasticsearch-dsl
Python
2 votes330 views2 answers
Python check string for negative number
Python
0 vote377 views1 answer
Pandas: How to Drop Rows that Contain a Specific String
Python
0 vote322 views2 answers
How to store data in python
Python
1 vote337 views1 answer
Numpy subarray python
Python
7 votes354 views6 answers
Python random word
Python
8 votes343 views3 answers
Check pandas version
Python