Python SQlite - insertion with tuples and List

python_sqlite_and_tuples

import sqlite3

con = sqlite3.connect('mydb.sqlite')
con.execute("CREATE TABLE  IF NOT EXISTS users(id INTEGER ,name TEXT, ecode TEXT);")

con.execute("CREATE TABLE  IF NOT EXISTS employees(id INTEGER PRIMARY KEY,ename TEXT, eid INTEGER);")

empnames = [
    ('jhon', 1),
    ('martin', 2),
    ('dev', 3)
]
companies = [
    ('Foo', 12),
    ('Bar', 7),
    ('Moo', 99),
]
comp='SAMSUNG'
comp_id=7006
# argument must be touple
# if one parameter place additional coma
con.execute("INSERT INTO users (id) VALUES (?)", (comp_id,))
con.execute("INSERT INTO users (name,id) VALUES (?,?)", (comp,comp_id))
con.executemany("INSERT or ignore INTO employees (ename,id) VALUES (?,?)", empnames)

con.commit()

# I think this will help you