SQLite test

# -*- coding: utf-8 -*-

import sqlite3 as lite
import sys

cars_names = (
    (1, 'Audi', 52642),
    (2, 'Mercedes', 57127),
    (3, 'Skoda', 9000),
    # (4, 'Volvo', 29000),
    # (5, 'Bentley', 350000),
    # (6, 'Hummer', 41400),
    # (7, 'Volkswagen', 21600)
)

cars_drivers = (
    (1,"Joe Star"),
    (2,"Sue Mc'Wall"),
    (3,"Space Dude"),
)


con = lite.connect('test1.db')

with con:

    cur = con.cursor()

    cur.execute("DROP TABLE IF EXISTS CarsNames")
    cur.execute("DROP TABLE IF EXISTS CarsDrivers")

    cur.execute("CREATE TABLE CarsNames(Id INT, Name TEXT, Price INT)")
    cur.execute("CREATE TABLE CarsDrivers(Id INT, Name TEXT)")

    cur.executemany("INSERT INTO CarsNames VALUES(?, ?, ?)", cars_names)
    cur.executemany("INSERT INTO CarsDrivers VALUES(?, ?)", cars_drivers)

    for row in cur.execute("SELECT * FROM CarsNames WHERE Name = 'Audi'"):
        print(row)