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 vote116 views1 answer
Python discord if == emoji not working
Python
9 votes121 views6 answers
Elif python
Python
1 vote140 views1 answer
Python convert html to text
Python
0 vote134 views1 answer
Import models
Python
3 votes105 views1 answer
Python numpy group by count
Python
3 votes104 views1 answer
Python automation ideas
Python
0 vote107 views1 answer
Draw a bow tie in python
Python
15 votes119 views2 answers
Loop throughthe key and the values of a dict in python
Python
1 vote116 views1 answer
Segregate list in even and odd numbers python
Python
0 vote114 views1 answer
How to crash a pc using python
Python