>>> import sqlite3
>>> c = sqlite3.connect(r'c:\test.sqlite')
>>> cur = c.cursor()
>>> cur.execute('create table test1(id number auto increment primary key, f1 text, f2 text, f3 text)')
<sqlite3.Cursor object at 0x006961A0>
>>> cur.execute('create table test2(id number, f1 text, f2 text, f3 text)')
<sqlite3.Cursor object at 0x006961A0>
>>> query_a = "INSERT INTO test1 (f1, f2, f3) VALUES (?, ?, ?)"
>>> a = [('1', '2', '3')]
>>> cur.executemany(query_a,a)
<sqlite3.Cursor object at 0x006961A0>
>>> cur.execute('select last_insert_rowid()')
<sqlite3.Cursor object at 0x006961A0>
>>> cur.fetchone()
(1,)try:
for i in text:
cur.execute(sql, [(i),])
result = cur.fetchone()
if result is not None:
print('Найдено')
else:
print('Не найдено')
except TypeError as err:
print('Ошибка:', err)
else:
print('Готово')