def main():
model = BaseModel()
print('select----start')
res = model.select('SELECT * FROM weather;')
print(res)
model.execute(
'INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (\'a\', 1, 1, 3.5, \'1961-06-16\');'
)
model.execute(
'INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (\'b\', 2, 2, 3.5, \'1961-06-16\');'
)
model.execute('UPDATE weather SET temp_lo=20 WHERE temp_hi=2;')
model.execute('DELETE FROM weather WHERE temp_lo=20;')
print('select----end')
res = model.select('SELECT * FROM weather;')
print(res)
model.close()
