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 vote216 views1 answer
Remove hh:mm:ss from pandas dataframe column
Python
1 vote172 views1 answer
Simple gui for pygame
Python
0 vote171 views2 answers
Programação orientada a objetos python - Pessoa
Python
1 vote160 views1 answer
How to save inputs python
Python
-1 vote206 views1 answer
Convert .tif images files to .jpeg in python
Python
2 votes197 views1 answer
Pytorch tensor change dimension order
Python
7 votes198 views2 answers
Sort list by attribute python
Python
19 votes151 views1 answer
How to change the scale of a picture in pygame
Python
0 vote175 views3 answers
How to list all the string's characters in python
Python
0 vote150 views1 answer
How to make antivirus software in python
Python