establish connection using SQLite in Python

Dipa,

Good evening. Below is the sample code from my Repository.

URL: https://github.com/vishipayyallore/LearningPython_2019/tree/master/Intermediate/Day7/1sqlitedemo

Code:

import sqlite3
connection = sqlite3.connect('./data/employees.db')
"""
create_table = 'CREATE TABLE employees (ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL);'
connection.execute(create_table, )
"""
insert_data = 'INSERT INTO employees values (101, \'Rajesh\'); '
connection.execute(insert_data);
insert_data = 'INSERT INTO employees values (102, \'Manish\'); '
connection.execute(insert_data);
select_data = 'SELECT * FROM employees;'
datasets = connection.execute(select_data);
for id, name in datasets:
print(id, name)
connection.commit()
connection.close()
print("Contenst saved to database successfully");

2 Replies

Know the answer? Post it — somebody with the same question will find it here.