SQLite In Python

Setup For Work

---

SQLite3 comes with python by default. So, you don't need to install it explicitly.

Now create a python script and try with the below code.

Connecting Database [db_connect.py]:

import sqlite3

def create_db():

    try:

        connection = sqlite3.connect('test.db')    # if test.db is there then it will connect or it will create a new

        return connection

    except(sqlite3.DatabaseError, sqlite3.ProgrammingError):

        print("DB Connection Error")

connection  = connect_my_db()

Create Table :

import sqlite3

import db_connect

connection  = connect_my_db()

cursor_object = connection.cursor()

query = '''CREATE TABLE DemoTable (username text, mail text, phone text, id integer);'''

try:

    cursor_object.execute(query)

    print("Table created successfully")

except Exception as e:

    print(e)

connection.commit()

connection.close()

Insert Data Into Table :

import sqlite3

import db_connect

connection  = connect_my_db()

cursor_object = connection.cursor()

query = '''INSERT INTO DemoTable 

(username, mail, phone, id) 

VALUES ('kuntal', 'kuntal@mail.com', '7407501378', 1);'''

try:

    cursor_object.execute(query)

    print("Record created successfully")

except Exception as e:

    print(e)

connection.commit()

connection.close()

Fetching Data From Table:

import sqlite3

import db_connect

connection  = connect_my_db()

cursor_object = connection.cursor()

query = '''SELECT * FROM DemoTable'''

try:

    cursor_object.execute(query)

except Exception as e:

    print(e)

else:

    rows = cursor_object.fetchall()

    for i in rows:

        print("Your Deatils : {0} {1}".format(i[1], i[2]))

Screenshot :

Enjoy Database Tutorial 😉

Quiz Level 1

Quiz Level 2

Request Me