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 vote281 views1 answer
Debug console shows blank
Python
0 vote298 views1 answer
Switch case dictionary python
Python
0 vote288 views1 answer
Python beacon
Python
0 vote334 views1 answer
How to import flask restful using pip
Python Flask
1 vote296 views1 answer
Python named group regex example
Python
0 vote297 views1 answer
Long type python
Python
4 votes357 views4 answers
Get file parent directory python
Python
0 vote282 views1 answer
Code coverage pytest as html
Python
-1 vote311 views2 answers
Install unity on pop os
Python
0 vote272 views1 answer
Tensorflow not installing error
Python