Module Import alias TryExcept body Expr Call AttributeLoad NameLoad attr Str handlers ExceptHandler type NameLoad body Pass Import alias Assign NameStore Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore Str Expr Call AttributeLoad NameLoad attr BinOpMod Str NameLoad Assign NameStore TupleLoad Str Expr Call AttributeLoad NameLoad attr Str NameLoad Print Call AttributeLoad NameLoad attr Assign NameStore ListLoad TupleLoad Str Str Str Num Num TupleLoad Str Str Str Num Num TupleLoad Str Str Str Num Num Expr Call AttributeLoad NameLoad attr Str NameLoad For NameStore Call AttributeLoad NameLoad attr Str body Print NameLoad
N/A N/A os N/A N/A N/A N/A N/A os unlink example.db N/A N/A N/A Exception N/A N/A N/A sqlite3 N/A conn N/A N/A sqlite3 connect example.db N/A c N/A N/A conn cursor N/A N/A N/A c execute CREATE TABLE stocks
             (date text, trans text, symbol text, qty real, price real) N/A N/A N/A c execute INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14) N/A N/A N/A conn commit N/A N/A N/A conn close N/A conn N/A N/A sqlite3 connect example.db N/A c N/A N/A conn cursor N/A symbol RHAT N/A N/A N/A c execute N/A SELECT * FROM stocks WHERE symbol = '%s' symbol N/A t N/A RHAT N/A N/A N/A c execute SELECT * FROM stocks WHERE symbol=? t N/A N/A N/A c fetchone N/A purchases N/A N/A 2006-03-28 BUY IBM 1000 45.0 N/A 2006-04-05 BUY MSFT 1000 72.0 N/A 2006-04-06 SELL IBM 500 53.0 N/A N/A N/A c executemany INSERT INTO stocks VALUES (?,?,?,?,?) purchases N/A row N/A N/A c execute SELECT * FROM stocks ORDER BY price N/A N/A row