how do i insert data into a table using python sqlite

insert records into sqlite table python

import sqlite3

def insertMultipleRecords(recordList):
    try:
        sqliteConnection = sqlite3.connect('SQLite_Python.db')
        cursor = sqliteConnection.cursor()
        print("Connected to SQLite")

        sqlite_insert_query = """INSERT INTO SqliteDb_developers
                          (id, name, email, joining_date, salary) 
                          VALUES (?, ?, ?, ?, ?);"""

        cursor.executemany(sqlite_insert_query, recordList)
        sqliteConnection.commit()
        print("Total", cursor.rowcount, "Records inserted successfully into SqliteDb_developers table")
        sqliteConnection.commit()
        cursor.close()

    except sqlite3.Error as error:
        print("Failed to insert multiple records into sqlite table", error)
    finally:
        if (sqliteConnection):
            sqliteConnection.close()
            print("The SQLite connection is closed")

recordsToInsert = [(4, 'Jos', '[email protected]', '2019-01-14', 9500),
                   (5, 'Chris', '[email protected]', '2019-05-15',7600),
                   (6, 'Jonny', '[email protected]', '2019-03-27', 8400)]

insertMultipleRecords(recordsToInsert)

Posted by: Guest on July-14-2020

Source

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)

Code answers related to "how do i insert data into a table using python sqlite"

Browse Popular Code Answers by Language

Answers for "how do i insert data into a table using python sqlite"

Code answers related to "how do i insert data into a table using python sqlite"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us