Breaking News: Grepper is joining You.com. Read the official announcement!

python create sqlite db file

Doubtful Dotterel answered on April 21, 2021 Popularity 9/10 Helpfulness 3/10

answer python create sqlite db file

related create sqlite database python

python create sqlite db file

Comment

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)

Popularity 9/10 Helpfulness 3/10 Language python

Source: www.sqlitetutorial.net

Tags: file python sqlite

Link to this answer
Share Copy Link

Contributed on Jan 09 2022

Doubtful Dotterel

0 Answers Avg Quality 2/10

Closely Related Answers

create sqlite database python

Comment

import sqlite3

conn = sqlite3.connect('TestDB.db')  # You can create a new database by changing the name within the quotes
c = conn.cursor() # The database will be saved in the location where your 'py' file is saved

# Create table - CLIENTS
c.execute('''CREATE TABLE CLIENTS
             ([generated_id] INTEGER PRIMARY KEY,[Client_Name] text, [Country_ID] integer, [Date] date)''')
          
# Create table - COUNTRY
c.execute('''CREATE TABLE COUNTRY
             ([generated_id] INTEGER PRIMARY KEY,[Country_ID] integer, [Country_Name] text)''')
        
# Create table - DAILY_STATUS
c.execute('''CREATE TABLE DAILY_STATUS
             ([Client_Name] text, [Country_Name] text, [Date] date)''')
                 
conn.commit()

# Note that the syntax to create new tables should only be used once in the code (unless you dropped the table/s at the end of the code). 
# The [generated_id] column is used to set an auto-increment ID for each record
# When creating a new table, you can add both the field names as well as the field formats (e.g., Text)

Popularity 10/10 Helpfulness 7/10 Language python

Source: datatofish.com

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Apr 21 2021

Xerothermic Xenomorph

0 Answers Avg Quality 2/10

python create sqlite db file

Contents

More Related Answers

python create sqlite db file

Closely Related Answers

create sqlite database python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.