import sqlite3
con = sqlite3.connect(":memory:")
c = con.cursor()
c.execute("create table jjo_errors (id integer primary key, name varchar(100))")
c.execute("create table tasks (id integer primary key, name varchar(100))")
c.execute("""create table connections_to_jjos (
connections_id integer,
jjo_error_id integer,
binder_task_id integer)""")
c.execute("insert into jjo_errors values (1, 'known'), (2, '--Unknown--')")
c.execute("insert into tasks values (3, 'DCDD'), (4, 'ANDD')")
q = """
INSERT INTO connections_to_jjos(
connections_id,
jjo_error_id,
binder_task_id
)
VALUES
(
55,
(select id from jjo_errors where name = "--Unknown--"),
(select id from tasks where name = "DCDD")
)
,
(
55,
(select id from jjo_errors where name = "--Unknown--"),
(select id from tasks where name = "ANDD")
)
"""
c.execute(q)
c.execute('select * from connections_to_jjos')
print(c.fetchall())
c.execute("insert into jjo_errors values (5, 'known'), (6, '--Unknown--')")
c.execute("insert into tasks values (7, 'something'), (8, 'ANDD')")
c.execute(q)
c.execute('select * from connections_to_jjos')
print(c.fetchall())
"""
everyting ok using:
Python 2.7.4 - sqlite3.sqlite_version '3.7.15.2'
Python 3.3.1 - sqlite3.version '2.6.0'
"""