how to insert into sqlite3 using python code example
Example: insert into sqlite python
import sqlite3
def insertVaribleIntoTable(id, name, email, joinDate, salary):
try:
sqliteConnection = sqlite3.connect('SQLite_Python.db')
cursor = sqliteConnection.cursor()
print("Connected to SQLite")
sqlite_insert_with_param = """INSERT INTO SqliteDb_developers
(id, name, email, joining_date, salary)
VALUES (?, ?, ?, ?, ?);"""
data_tuple = (id, name, email, joinDate, salary)
cursor.execute(sqlite_insert_with_param, data_tuple)
sqliteConnection.commit()
print("Python Variables inserted successfully into SqliteDb_developers table")
cursor.close()
except sqlite3.Error as error:
print("Failed to insert Python variable into sqlite table", error)
finally:
if (sqliteConnection):
sqliteConnection.close()
print("The SQLite connection is closed")
insertVaribleIntoTable(2, 'Joe', '[email protected]', '2019-05-19', 9000)
insertVaribleIntoTable(3, 'Ben', '[email protected]', '2019-02-23', 9500)