From: Andrey

main.py

import sqlite3
connect = sqlite3.connect("some")
cursor = connect.cursor()
query = "create table example (id integer, name text);"
cursor.execute(query)
Out[10]: <sqlite3.Cursor at 0x7f62b5bb57a0>
cursor.fetchall()
Out[11]: []
query = """insert into example values (1 , "Vasya");"""
cursor.execute(query)
Out[13]: <sqlite3.Cursor at 0x7f62b5bb57a0>
cursor.fetchall()
Out[14]: []
query = "select * from example;"
cursor.fetchall()
Out[16]: []
cursor.execute(query)
Out[17]: <sqlite3.Cursor at 0x7f62b5bb57a0>
cursor.fetchall()
Out[18]: [(1, 'Vasya')]
query = """update example set name="petya" where id =1;"""
cursor.execute(query)
Out[20]: <sqlite3.Cursor at 0x7f62b5bb57a0>
cursor.fetchall()
Out[21]: []
query = "select * from example;"
cursor.execute(query)
Out[23]: <sqlite3.Cursor at 0x7f62b5bb57a0>
cursor.fetchall()
Out[24]: [(1, 'petya')]