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

4 votes170 views2 answers
Python press any key to continue
Python
0 vote144 views1 answer
Plague meaning
Python
0 vote198 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python Django
17 votes146 views6 answers
Prime number in python
Python
4 votes143 views1 answer
What should you call a decimal value in python
Python
9 votes132 views6 answers
Add list python
Python
2 votes131 views1 answer
Fstring number format python
Python
0 vote131 views1 answer
Timedelta
Python
0 vote148 views1 answer
Racine carré python
Python
0 vote157 views2 answers
Wav file to array python
Python