#!/usr/bin/python

import sqlite3

con = sqlite3.connect('ydb.db')

with con:

cur = con.cursor()

cur.execute("DROP TABLE IF EXISTS cars;")

cur.execute("CREATE TABLE cars(id INT, name TEXT, price INT)")

cur.execute("INSERT INTO cars VALUES(1,'Audi',52642)")

cur.execute("INSERT INTO cars VALUES(2,'Mercedes',57127)")

cur.execute("INSERT INTO cars VALUES(3,'Skoda',9000)")

cur.execute("INSERT INTO cars VALUES(4,'Volvo',29000)")

cur.execute("INSERT INTO cars VALUES(5,'Bentley',350000)")

cur.execute("INSERT INTO cars VALUES(6,'Citroen',21000)")

cur.execute("INSERT INTO cars VALUES(7,'Hummer',41400)")

cur.execute("INSERT INTO cars VALUES(8,'Volkswagen',21600)")