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 vote127 views1 answer
Regular Expression to Stop at First Match
Python
2 votes139 views2 answers
Merge two df
Python
1 vote118 views1 answer
Python close all plot figures
Python
0 vote119 views1 answer
How to capitalize words in python
Python
0 vote128 views1 answer
Python3 change file permissions
Python
18 votes119 views2 answers
Absolute value python
Python
1 vote139 views1 answer
Scatter plot of a dataframe in python
Python
9 votes182 views2 answers
Post request with proxy python
Python
1 vote124 views1 answer
Evaluate how much a python program memory
Python
-2 votes124 views1 answer
En_core_web_sm
Python