def METHOD_NAME():
    import sqlite3
    conn = sqlite3.connect("sqlite3.db")
    c = conn.cursor()
    c.execute("""CREATE TABLE stocks
                 (date text, trans text, symbol text, qty real, price real)""")
    c.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")
    conn.commit()
    t = ('RHAT',)
    c.execute('SELECT * FROM stocks WHERE symbol=?', t)
    # Larger example that inserts many records at a time
    purchases = [
        ('2006-03-28', 'BUY', 'IBM', 1000, 45.00),
        ('2006-04-05', 'BUY', 'MSFT', 1000, 72.00),
        ('2006-04-06', 'SELL', 'IBM', 500, 53.00),
    ]
    c.executemany('INSERT INTO stocks VALUES (?,?,?,?,?)', purchases)
    conn.commit()
    conn.close()
    conn = sqlite3.connect("sqlite3.db")
    c = conn.cursor()
    c.execute("SELECT * from stocks")
    data = c.fetchall()
    if len(data) != 4:
        raise Exception("Need 4 stocks")
    print(data)
    conn.close()