from sqlite3 import connect
from contextlib import contextmanager
cur.execute('create table points(x int, y int)')
cur.execute('drop table points')
with connect('test.db') as conn:
cur.execute('insert into points (x, y) values(1, 1)')
cur.execute('insert into points (x, y) values(1, 2)')
cur.execute('insert into points (x, y) values(2, 1)')
cur.execute('insert into points (x, y) values(2, 2)')
for row in cur.execute("select x, y from points"):