Module Expr Str Import alias alias ImportFrom alias Assign NameStore Str Assign NameStore SubscriptLoad Str Slice Num Num Assign NameStore AttributeLoad NameLoad attr Assign NameStore Lambda arguments args NameParam NameParam NameParam defaults SubscriptLoad BoolOpOr BoolOpAnd NameLoad ListLoad NameLoad ListLoad NameLoad Index Num FunctionDef arguments args NameParam NameParam defaults TupleLoad body Expr Str Assign NameStore ListLoad Assign NameStore Call NameLoad Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr Call NameLoad Call NameLoad Lambda arguments args NameParam defaults BoolOpOr NameLoad Str NameLoad Assign NameStore Call NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad If BoolOpAnd NameLoad CompareGt Call NameLoad NameLoad Num body For NameStore NameLoad body Assign NameStore Call NameLoad Lambda arguments args NameParam defaults Call NameLoad NameLoad NameLoad For NameStore Call NameLoad Call NameLoad NameLoad body Assign NameStore SubscriptLoad NameLoad Index NameLoad If CompareLt SubscriptLoad NameLoad Index NameLoad Call NameLoad NameLoad body Assign SubscriptStore NameLoad Index NameLoad Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad If CompareEq Call NameLoad NameLoad Num body Assign NameStore Str orelse If CompareEq Call NameLoad NameLoad Num body Assign NameStore Str orelse Assign NameStore BinOpMod Str BinOpSub Call NameLoad NameLoad Num For NameStore Call NameLoad Call NameLoad NameLoad body Assign NameStore SubscriptLoad NameLoad Index NameLoad Assign NameStore ListLoad For NameStore Call NameLoad Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad SubscriptLoad NameLoad Index NameLoad SubscriptLoad NameLoad Index NameLoad Assign SubscriptStore NameLoad Index NameLoad Call AttributeLoad Str attr NameLoad Assign NameStore Call NameLoad SubscriptLoad NameLoad Index Num Assign SubscriptStore NameLoad Slice Num Num ListLoad BinOpMult Str BinOpDiv NameLoad Call NameLoad Str Expr Call AttributeLoad NameLoad attr BinOpAdd Str NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults TupleLoad body Assign NameStore ListLoad Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad Lambda arguments args NameParam defaults BinOpMod Str Call AttributeLoad NameLoad attr Call NameLoad NameLoad Expr Call NameLoad AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Str If BoolOpAnd NameLoad CompareGt Call NameLoad NameLoad Num body For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr Str Assign NameStore Call NameLoad Lambda arguments args NameParam defaults BinOpMod Str NameLoad NameLoad Expr Call NameLoad AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr Str Return NameLoad decorator_list Assign NameStore Lambda arguments args NameParam defaults Call AttributeLoad Call AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr attr Str NameLoad Num ClassDef bases body Expr Str FunctionDef arguments args NameParam NameParam defaults body Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If CompareEq NameLoad Str body Return AttributeLoad NameLoad attr orelse If CompareEq NameLoad Str body Return AttributeLoad NameLoad attr orelse Return Call NameLoad AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad body If NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad orelse Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body If NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad decorator_list decorator_list ClassDef bases body Expr Str FunctionDef arguments args NameParam NameParam NameParam defaults body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad If AttributeLoad NameLoad attr body Assign AttributeStore NameLoad attr BinOpMod Str TupleLoad NameLoad Call AttributeLoad Str attr AttributeLoad NameLoad attr Call AttributeLoad Str attr BinOpMult TupleLoad Str Call NameLoad AttributeLoad NameLoad attr orelse Assign AttributeStore NameLoad attr BinOpMod Str NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults body Assert BoolOpAnd NameLoad CompareGt Call NameLoad NameLoad Num Str If AttributeLoad NameLoad attr body Assign NameStore AttributeLoad NameLoad attr orelse Assign NameStore BinOpMod AttributeLoad NameLoad attr Call AttributeLoad Str attr BinOpMult TupleLoad Str Call NameLoad SubscriptLoad NameLoad Index Num Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad decorator_list decorator_list FunctionDef arguments args NameParam defaults body Return Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return Call NameLoad keyword NameLoad decorator_list ClassDef bases body FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad Num NameLoad NameLoad body Assign AttributeStore NameLoad attr Num Assign AttributeStore NameLoad attr ListLoad Assign AttributeStore NameLoad attr ListLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad If UnaryOpNot NameLoad body If CompareEq NameLoad NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Index Num Str If UnaryOpNot Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad AttributeLoad NameLoad attr Index Str Str Assign AttributeStore NameLoad attr Call NameLoad NameLoad orelse If Call NameLoad NameLoad NameLoad body Assign AttributeStore NameLoad attr NameLoad orelse Assign AttributeStore NameLoad attr Call NameLoad NameLoad If CompareEq NameLoad NameLoad body Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad Str Str If CompareEq NameLoad Str body ImportFrom alias Assign NameStore NameLoad If UnaryOpNot NameLoad body Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad Str NameLoad Assign TupleStore AttributeStore NameLoad attr NameStore NameStore NameStore TupleLoad SubscriptLoad NameLoad Index Str SubscriptLoad NameLoad Index Str SubscriptLoad NameLoad Index Str SubscriptLoad NameLoad Index Str If Call AttributeLoad NameLoad attr Str body Assign AttributeStore NameLoad attr ListLoad For NameStore Call AttributeLoad SubscriptLoad NameLoad Index Str attr Str body Assign NameStore SubscriptLoad Call AttributeLoad NameLoad attr Str Index Num Assign NameStore Call NameLoad NameLoad Call NameLoad Call NameLoad NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore ListComp NameLoad comprehension NameStore Call AttributeLoad NameLoad attr CompareNotIn NameLoad ListLoad Str Str Str Str Str Str Assign NameStore Dict For NameStore NameLoad body Assign SubscriptStore NameLoad Index NameLoad SubscriptLoad NameLoad Index NameLoad Assign AttributeStore NameLoad attr Call NameLoad AttributeLoad NameLoad attr TupleLoad AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad orelse Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr NameLoad Assign AttributeStore AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr orelse If CompareEq NameLoad Str body For NameStore ListLoad Str Str body TryExcept body Assign NameStore Call NameLoad NameLoad Call NameLoad Call NameLoad Str Break handlers ExceptHandler body Continue orelse Raise Call NameLoad Str Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index TupleLoad Str NameLoad Assign TupleStore AttributeStore NameLoad attr NameStore NameStore TupleLoad SubscriptLoad NameLoad Index Str SubscriptLoad NameLoad Index Str SubscriptLoad NameLoad Index Str Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad NameLoad keyword Num Assign AttributeStore NameLoad attr NameLoad For NameStore Call AttributeLoad AttributeLoad NameLoad attr attr body Expr Call NameLoad NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad NameLoad For NameStore Call NameLoad NameLoad body TryExcept body Assign NameStore Call NameLoad NameLoad NameLoad If Call NameLoad NameLoad NameLoad body Expr Call NameLoad NameLoad NameLoad NameLoad handlers ExceptHandler body Continue Delete NameDel decorator_list FunctionDef arguments args NameParam defaults body Return AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Return AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body If CompareEq Str NameLoad body Return AttributeLoad AttributeLoad NameLoad attr attr Raise Call NameLoad BinOpMod Str NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Expr Call AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body Expr Str Assign TupleStore AttributeStore NameLoad attr AttributeStore NameLoad attr TupleLoad ListLoad ListLoad If NameLoad body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad orelse Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr If CompareEq NameLoad Str body If Call NameLoad NameLoad Str body For NameStore AttributeLoad NameLoad attr body Assign AttributeStore NameLoad attr Call NameLoad AttributeLoad NameLoad attr orelse Assign NameStore Call NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults NameLoad Num body Expr Str If BoolOpAnd NameLoad AttributeLoad NameLoad attr body Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr If Call NameLoad NameLoad Str body Assign NameStore Call AttributeLoad NameLoad attr While NameLoad body AugAssignAdd AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr If Call NameLoad NameLoad Str body Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr If Call NameLoad NameLoad Str body Assign AttributeStore NameLoad attr AttributeLoad NameLoad attr If BoolOpOr UnaryOpNot AttributeLoad NameLoad attr CompareIs NameLoad NameLoad body If UnaryOpNot AttributeLoad AttributeLoad NameLoad attr attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr If BoolOpAnd NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Expr Call AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Return Call AttributeLoad NameLoad attr NameLoad finalbody Expr Call AttributeLoad NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str If BoolOpAnd AttributeLoad NameLoad attr CompareGt AttributeLoad NameLoad attr Num body Assign NameStore AttributeLoad NameLoad attr If NameLoad body Print AttributeLoad NameLoad attr Str For NameStore Call AttributeLoad NameLoad attr NameLoad Call NameLoad Lambda arguments args NameParam defaults SubscriptLoad NameLoad Index Num AttributeLoad NameLoad attr body Print AttributeLoad NameLoad attr NameLoad Print AttributeLoad NameLoad attr Str decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad body Expr Str Assign NameStore Call AttributeLoad NameLoad attr TryFinally body If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad keyword NameLoad orelse If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad keyword NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad keyword NameLoad finalbody Expr Call AttributeLoad NameLoad attr NameLoad keyword Call NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad body Expr Str Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad keyword NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad NameLoad body Expr Str If NameLoad body Assign NameStore ListLoad Assign NameStore ListLoad If CompareEq Call NameLoad NameLoad Call NameLoad NameLoad body If NameLoad body Assign NameStore Call NameLoad NameLoad Assign NameStore Call NameLoad Lambda arguments args NameParam defaults CompareGt Call NameLoad NameLoad Num Call NameLoad Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad orelse Assign NameStore ListLoad NameLoad For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad keyword NameLoad Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad keyword NameLoad Return TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad body Expr Str Assign NameStore Call AttributeLoad NameLoad attr TryFinally body Expr Call AttributeLoad NameLoad attr NameLoad keyword NameLoad keyword NameLoad keyword NameLoad finalbody Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad NameLoad body Expr Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad NameLoad body Expr Str Assign NameStore Call AttributeLoad NameLoad attr If BoolOpAnd NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad orelse If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad orelse If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults NameLoad TupleLoad Str NameLoad NameLoad body Expr Str Assign NameStore Call AttributeLoad NameLoad attr If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad NameLoad NameLoad body Expr Str Assign NameStore Call AttributeLoad NameLoad attr If NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad orelse Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad NameLoad Num Num body Expr Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body Expr Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults Num Num NameLoad body Expr Str Print AttributeLoad NameLoad attr Call NameLoad Call NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults ListLoad ListLoad Num NameLoad body Expr Str If CompareEq Call NameLoad NameLoad Call NameLoad Str body Assign NameStore Call NameLoad NameLoad keyword AttributeLoad NameLoad attr Assign NameStore Call NameLoad NameLoad NameLoad keyword NameLoad keyword NameLoad keyword NameLoad keyword NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults Str ListLoad ListLoad ListLoad Num NameLoad body Expr Str If CompareEq Call NameLoad NameLoad Call NameLoad Str body Assign NameStore Call NameLoad NameLoad keyword AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults Str Num body Expr Str Assign NameStore Call NameLoad NameLoad NameLoad NameLoad NameLoad Expr Call AttributeLoad NameLoad attr NameLoad decorator_list decorator_list ClassDef bases body Expr Str FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam NameParam defaults ListLoad ListLoad Num NameLoad body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Num Assign AttributeStore NameLoad attr ListLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Dict Assign NameStore Call NameLoad Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call NameLoad Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr NameLoad Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr Assign AttributeStore AttributeLoad NameLoad attr attr Num TryFinally body Expr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr If AttributeLoad AttributeLoad NameLoad attr attr body Assign NameStore Dict For NameStore AttributeLoad AttributeLoad NameLoad attr attr body Assign SubscriptStore NameLoad Index Call AttributeLoad SubscriptLoad NameLoad Index Num attr SubscriptLoad NameLoad Index Num Assign NameStore Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr NameLoad NameLoad For NameStore Call NameLoad Call NameLoad Call NameLoad NameLoad NameLoad body Assign SubscriptStore AttributeLoad NameLoad attr Index SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index SubscriptLoad NameLoad Index Num Assign NameStore NameLoad orelse Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad NameLoad finalbody Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad Assign AttributeStore NameLoad attr Call NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return BinOpMod Str TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Return BinOpMod Str TupleLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body If CompareEq NameLoad Str body Return AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults body Assign NameStore Call NameLoad Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr NameLoad If NameLoad body Assign NameStore Call NameLoad Lambda arguments args NameParam NameParam defaults NameLoad CompareNotIn NameLoad NameLoad NameLoad If NameLoad body Assign NameStore Call NameLoad Lambda arguments args NameParam NameParam defaults NameLoad CompareIn NameLoad NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Assign SubscriptStore AttributeLoad NameLoad attr Index NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body If CompareGt Call NameLoad AttributeLoad NameLoad attr Num body Return Call AttributeLoad NameLoad attr Return Num decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr Assign NameStore Call NameLoad AttributeLoad NameLoad attr AugAssignAdd AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr ListLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad If AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam NameParam defaults Str ListLoad body Assign NameStore BinOpMod Str TupleLoad Call AttributeLoad Str attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr NameLoad Assign TupleStore NameStore NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad If NameLoad body Expr Call NameLoad AttributeLoad NameLoad attr NameLoad Return Call AttributeLoad NameLoad attr Return Num decorator_list decorator_list ClassDef bases body Expr Str FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam defaults Str Num body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Dict decorator_list FunctionDef arguments args NameParam NameParam defaults body If UnaryOpNot NameLoad body Return Str Assign NameStore Call NameLoad NameLoad If CompareNotEq Call AttributeLoad NameLoad attr Str Num body Assign NameStore BinOpMod Str NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults Str body Assign TupleStore NameStore NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore Call NameLoad AttributeLoad NameLoad attr NameLoad If AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr BinOpMod Str Call AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad Lambda arguments args NameParam defaults SubscriptLoad NameLoad Index Num NameLoad If NameLoad body For NameStore NameLoad body Expr Call AttributeLoad NameLoad attr BinOpMod Str Call AttributeLoad AttributeLoad NameLoad attr attr Call NameLoad AttributeLoad NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr decorator_list decorator_list ClassDef bases body Expr Str FunctionDef arguments args NameParam NameParam NameParam NameParam NameParam NameParam defaults NameLoad Num Num body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr Assign AttributeStore AttributeLoad NameLoad attr attr Num TryFinally body If NameLoad body Expr Call AttributeLoad NameLoad attr finalbody Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr keyword AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr ListLoad If AttributeLoad AttributeLoad NameLoad attr attr body Assign AttributeStore NameLoad attr Call NameLoad Lambda arguments args NameParam defaults TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num AttributeLoad AttributeLoad NameLoad attr attr If AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Lambda arguments args NameParam NameParam defaults Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr ListLoad If AttributeLoad AttributeLoad NameLoad attr attr body Assign AttributeStore NameLoad attr Call NameLoad Lambda arguments args NameParam defaults TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num AttributeLoad AttributeLoad NameLoad attr attr If AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Lambda arguments args NameParam NameParam defaults Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Assign AttributeStore NameLoad attr ListLoad If AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr NameLoad If AttributeLoad AttributeLoad NameLoad attr attr body Assign AttributeStore NameLoad attr Call NameLoad Lambda arguments args NameParam defaults TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num AttributeLoad AttributeLoad NameLoad attr attr If AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Lambda arguments args NameParam NameParam defaults Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Expr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr ListLoad If AttributeLoad AttributeLoad NameLoad attr attr body Assign AttributeStore NameLoad attr Call NameLoad Lambda arguments args NameParam defaults TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num AttributeLoad AttributeLoad NameLoad attr attr If AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Lambda arguments args NameParam NameParam defaults Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num TryExcept body Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr ListLoad If AttributeLoad AttributeLoad NameLoad attr attr body Assign NameStore Dict Assign NameStore Call NameLoad Lambda arguments args NameParam defaults TupleLoad SubscriptLoad NameLoad Index Num Call AttributeLoad SubscriptLoad NameLoad Index Num attr SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Call NameLoad Lambda arguments args NameParam defaults SubscriptLoad NameLoad Index Num AttributeLoad AttributeLoad NameLoad attr attr FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num If CompareEq NameLoad Num body Assign NameStore Call NameLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Return NameLoad decorator_list Expr Call AttributeLoad NameLoad attr NameLoad For NameStore NameLoad body If UnaryOpNot Call AttributeLoad NameLoad attr SubscriptLoad NameLoad Index Num body Assign SubscriptStore NameLoad Index SubscriptLoad NameLoad Index Num ListLoad Expr Call AttributeLoad SubscriptLoad NameLoad Index SubscriptLoad NameLoad Index Num attr NameLoad Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr If AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr Lambda arguments args NameParam NameParam defaults Call NameLoad SubscriptLoad SubscriptLoad NameLoad Index Num Index Num SubscriptLoad SubscriptLoad NameLoad Index Num Index Num handlers ExceptHandler body Pass decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore ListLoad Expr Call AttributeLoad NameLoad attr Str Expr Call AttributeLoad NameLoad attr BinOpAdd Str AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Str For NameStore AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Expr Call AttributeLoad NameLoad attr Str For NameStore AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num If AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Str For NameStore AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num Expr Call AttributeLoad NameLoad attr Str For NameStore AttributeLoad NameLoad attr body Assign NameStore Call NameLoad SubscriptLoad NameLoad Index Num Str Str Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num SubscriptLoad NameLoad Index Num NameLoad Expr Call AttributeLoad NameLoad attr Str If CompareIs AttributeLoad NameLoad attr NameLoad body Expr Call AttributeLoad NameLoad attr Str orelse For NameStore AttributeLoad NameLoad attr body Assign NameStore Call NameLoad SubscriptLoad SubscriptLoad NameLoad Index Num Index Num Str Str Assign NameStore Call AttributeLoad Str attr Call NameLoad Lambda arguments args NameParam defaults SubscriptLoad NameLoad Index Num NameLoad Expr Call AttributeLoad NameLoad attr BinOpMod Str TupleLoad NameLoad SubscriptLoad SubscriptLoad NameLoad Index Num Index Num NameLoad Return Call AttributeLoad Str attr NameLoad decorator_list decorator_list ClassDef bases body FunctionDef arguments args NameParam NameParam NameParam defaults Str body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Dict Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Str Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Str Assign AttributeStore NameLoad attr NameLoad Expr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore Call NameLoad AttributeLoad NameLoad attr Str Assign NameStore Call AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr Assign NameStore Call NameLoad Lambda arguments args NameParam defaults BoolOpAnd CompareGt Call NameLoad NameLoad Num CompareNotIn SubscriptLoad NameLoad Index Num ListLoad Str Str Call NameLoad Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr NameLoad Assign NameStore NameLoad For NameStore Call NameLoad Call NameLoad NameLoad body Assign NameStore SubscriptLoad NameLoad Index NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad If NameLoad body Assign NameStore Dict If UnaryOpNot Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr Num body Assign SubscriptStore AttributeLoad NameLoad attr Index Call AttributeLoad NameLoad attr Num ListLoad Expr Call AttributeLoad SubscriptLoad AttributeLoad NameLoad attr Index Call AttributeLoad NameLoad attr Num attr NameLoad orelse Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad If NameLoad body Assign SubscriptStore NameLoad Index Call AttributeLoad NameLoad attr Num Call AttributeLoad NameLoad attr Num decorator_list FunctionDef arguments args NameParam TupleStore NameStore NameStore defaults body If CompareEq NameLoad AttributeLoad NameLoad attr body Return SubscriptLoad SubscriptLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad Index Num Index NameLoad Assign NameStore Call NameLoad Lambda arguments args NameParam NameParam NameParam defaults AttributeLoad NameLoad attr NameLoad CompareEq SubscriptLoad NameLoad Index NameLoad NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad If BoolOpOr UnaryOpNot NameLoad CompareGt Call NameLoad NameLoad Num body Raise NameLoad BinOpMod Str TupleLoad NameLoad NameLoad Return SubscriptLoad NameLoad Index Num decorator_list decorator_list FunctionDef arguments args NameParam NameParam defaults body Import alias Assign NameStore ListLoad NameLoad Str Assign NameStore Num While CompareLt NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr Call NameLoad BinOpAdd BinOpMod Call NameLoad BinOpMult Num Call AttributeLoad NameLoad attr Num Call NameLoad Str AugAssignAdd NameStore Num Return Call AttributeLoad Str attr NameLoad decorator_list ClassDef bases body FunctionDef arguments args NameParam NameParam NameParam defaults body Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body If CompareEq Call NameLoad NameLoad Call NameLoad Str body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Return SubscriptLoad AttributeLoad NameLoad attr Index NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body If CompareEq Call NameLoad NameLoad Call NameLoad Str body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad If CompareEq Call NameLoad NameLoad Call NameLoad Str body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Return SubscriptLoad AttributeLoad NameLoad attr Slice NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return Call NameLoad AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Return Call NameLoad AttributeLoad NameLoad attr decorator_list decorator_list ClassDef bases body FunctionDef arguments args NameParam NameParam NameParam defaults ListLoad body Assign AttributeStore NameLoad attr Call NameLoad Lambda arguments args NameParam defaults Call AttributeLoad NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Return Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam defaults body Return Call NameLoad NameLoad SubscriptLoad AttributeLoad NameLoad attr Index NameLoad decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Return Call NameLoad Lambda arguments args NameParam NameParam defaults NameLoad Call NameLoad NameLoad NameLoad SubscriptLoad AttributeLoad NameLoad attr Slice NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return BinOpMod Str TupleLoad AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr Call NameLoad NameLoad decorator_list decorator_list
N/A N/A 
This script provides platform independence by wrapping Python
Database API 2.0 compatible drivers to allow seamless database
usage across implementations.

In order to use the C version, you need mxODBC and mxDateTime.
In order to use the Java version, you need zxJDBC.

>>> import dbexts
>>> d = dbexts.dbexts() # use the default db
>>> d.isql('select count(*) count from player')

count
-------
13569.0

1 row affected

>>> r = d.raw('select count(*) count from player')
>>> r
([('count', 3, 17, None, 15, 0, 1)], [(13569.0,)])
>>>

The configuration file follows the following format in a file name dbexts.ini:

[default]
name=mysql

[jdbc]
name=mysql
url=jdbc:mysql://localhost/ziclix
user=
pwd=
driver=org.gjt.mm.mysql.Driver
datahandler=com.ziclix.python.sql.handler.MySQLDataHandler

[jdbc]
name=pg
url=jdbc:postgresql://localhost:5432/ziclix
user=bzimmer
pwd=
driver=org.postgresql.Driver
datahandler=com.ziclix.python.sql.handler.PostgresqlDataHandler
 N/A os re types StringType N/A __author__ brian zimmer (bzimmer@ziclix.com) N/A __version__ N/A $Revision: 4185 $ N/A 11 -2 N/A __OS__ N/A os name N/A choose N/A N/A N/A bool a b N/A N/A N/A N/A bool N/A a N/A b N/A 0 console N/A N/A rows headers N/A N/A N/A N/A Format the results into a list       of strings (one for each row):

        <header>
        <headersep>
        <row1>
        <row2>
        ...

        headers may be given as list of strings.

        Columns are separated by colsep; the header is separated from
        the result set by a line of headersep characters.

        The function calls stringify to format the value data into a string.
        It defaults to calling str() and striping leading and trailing whitespace.

        - copied and modified from mxODBC
         N/A output N/A N/A headers N/A map N/A N/A N/A header N/A N/A N/A header upper N/A list N/A map N/A N/A N/A x N/A N/A x headers N/A collen N/A map len headers N/A N/A N/A output append headers N/A N/A rows N/A N/A len rows 0 N/A N/A row rows N/A N/A row N/A map N/A N/A N/A x N/A N/A str x row N/A i N/A range N/A len row N/A N/A entry N/A row N/A i N/A N/A N/A collen N/A i N/A len entry N/A N/A N/A collen N/A i N/A len entry N/A N/A N/A output append row N/A N/A N/A len output 1 N/A N/A affected 0 rows affected N/A N/A N/A N/A len output 2 N/A N/A affected 1 row affected N/A N/A affected N/A %d rows affected N/A N/A len output 1 N/A i N/A range N/A len output N/A N/A row N/A output N/A i N/A l N/A N/A j N/A range N/A len row N/A N/A N/A N/A l append N/A %-*s N/A N/A collen N/A j N/A row N/A j N/A N/A output N/A i N/A N/A  |  join l N/A totallen N/A len N/A output N/A 0 N/A N/A output N/A 1 1 N/A N/A - N/A totallen N/A len - N/A N/A N/A output append N/A affected N/A output N/A html N/A N/A rows headers N/A N/A N/A N/A output N/A N/A N/A N/A output append <table class="results"> N/A N/A N/A output append <tr class="headers"> N/A headers N/A map N/A N/A N/A x N/A N/A <td class="header">%s</td> N/A N/A x upper N/A list headers N/A N/A map N/A output append headers N/A N/A N/A output append </tr> N/A N/A rows N/A N/A len rows 0 N/A N/A row rows N/A N/A N/A N/A output append <tr class="row"> N/A row N/A map N/A N/A N/A x N/A N/A <td class="value">%s</td> x row N/A N/A map N/A output append row N/A N/A N/A output append </tr> N/A N/A N/A output append </table> N/A output N/A N/A comments N/A N/A N/A x N/A N/A N/A N/A N/A re compile {.*?} N/A re S sub x 0 mxODBCProxy N/A N/A N/A Wraps mxODBC to provide proxy support for zxJDBC's additional parameters. __init__ N/A N/A self c N/A N/A N/A N/A self c c N/A __getattr__ N/A N/A self name N/A N/A N/A N/A name execute N/A N/A N/A self execute N/A N/A N/A name gettypeinfo N/A N/A N/A self gettypeinfo N/A N/A N/A getattr N/A self c name N/A execute N/A N/A self sql params bindings maxrows N/A None None None N/A N/A params N/A N/A N/A N/A N/A self c execute sql params N/A N/A N/A N/A N/A self c execute sql N/A gettypeinfo N/A N/A self typeid N/A None N/A N/A typeid N/A N/A N/A N/A N/A self c gettypeinfo typeid N/A N/A executor N/A N/A N/A Handles the insertion of values given dynamic data. __init__ N/A N/A self table cols N/A N/A N/A N/A self cols cols N/A N/A self table table N/A N/A self cols N/A N/A N/A self sql N/A insert into %s (%s) values (%s) N/A table N/A N/A , join N/A self cols N/A N/A , join N/A N/A ? N/A len N/A self cols N/A N/A N/A self sql N/A insert into %s values (%%s) table N/A execute N/A N/A self db rows bindings N/A N/A N/A N/A rows N/A N/A len rows 0 must have at least one row N/A N/A self cols N/A N/A sql N/A self sql N/A N/A sql N/A N/A self sql N/A N/A , join N/A N/A ? N/A len N/A rows N/A 0 N/A N/A N/A db raw sql rows bindings N/A N/A connect N/A N/A dbname N/A N/A N/A N/A dbexts dbname N/A lookup N/A N/A dbname N/A N/A N/A N/A dbexts jndiname dbname N/A dbexts N/A N/A __init__ N/A N/A self dbname cfg formatter autocommit jndiname out N/A None None console 0 None None N/A N/A N/A self verbose 1 N/A N/A self results N/A N/A N/A self headers N/A N/A N/A self autocommit autocommit N/A N/A self formatter formatter N/A N/A self out out N/A N/A self lastrowid None N/A N/A self updatecount None N/A N/A jndiname N/A N/A N/A cfg None N/A N/A fn N/A N/A N/A os path join N/A N/A N/A N/A os path split __file__ N/A 0 dbexts.ini N/A N/A N/A N/A N/A os path exists fn N/A N/A fn N/A N/A N/A os path join N/A N/A os environ N/A HOME .dbexts N/A N/A self dbs N/A IniParser fn N/A N/A N/A isinstance cfg IniParser N/A N/A N/A self dbs cfg N/A N/A N/A self dbs N/A IniParser cfg N/A N/A dbname None N/A N/A dbname N/A N/A self dbs N/A N/A default name N/A N/A __OS__ java N/A com.ziclix.python.sql zxJDBC N/A database zxJDBC N/A N/A jndiname N/A N/A t N/A N/A self dbs N/A N/A jdbc dbname N/A N/A N/A self dburl dbuser dbpwd jdbcdriver N/A N/A t N/A url N/A t N/A user N/A t N/A pwd N/A t N/A driver N/A N/A N/A t has_key datahandler N/A N/A N/A self datahandler N/A N/A dh N/A N/A N/A t N/A datahandler split , N/A N/A classname N/A N/A N/A dh split . N/A -1 N/A datahandlerclass N/A __import__ dh N/A globals N/A locals classname N/A N/A N/A N/A self datahandler append datahandlerclass N/A keys N/A x N/A x N/A N/A t keys N/A x N/A url user pwd driver datahandler name N/A props N/A N/A a keys N/A N/A N/A props N/A a N/A t N/A a N/A N/A self db N/A apply N/A database connect N/A N/A self dburl dbuser dbpwd jdbcdriver props N/A N/A N/A self db N/A N/A database lookup jndiname N/A N/A N/A self db autocommit N/A self autocommit N/A N/A N/A __OS__ nt N/A N/A modname N/A mx.ODBC.Windows ODBC.Windows N/A N/A N/A N/A database N/A __import__ modname N/A globals N/A locals Windows N/A N/A N/A N/A N/A N/A N/A N/A ImportError unable to find appropriate mxODBC module N/A t N/A N/A self dbs N/A N/A odbc dbname N/A N/A N/A self dburl dbuser dbpwd N/A N/A t N/A url N/A t N/A user N/A t N/A pwd N/A N/A self db N/A N/A database Connect N/A self dburl dbuser dbpwd clear_auto_commit 1 N/A N/A self dbname dbname N/A a N/A N/A N/A database sqltype keys N/A N/A N/A setattr self N/A N/A database sqltype N/A a a N/A a N/A dir database N/A N/A N/A N/A p N/A getattr database a N/A N/A issubclass p Exception N/A N/A N/A setattr self a p N/A N/A N/A N/A N/A database N/A __str__ N/A N/A self N/A N/A N/A N/A self dburl N/A __repr__ N/A N/A self N/A N/A N/A N/A self dburl N/A __getattr__ N/A N/A self name N/A N/A N/A N/A cfg name N/A N/A N/A N/A self dbs cfg N/A N/A AttributeError N/A 'dbexts' object has no attribute '%s' name N/A close N/A N/A self N/A N/A N/A  close the connection to the database  N/A N/A N/A N/A self db close N/A begin N/A N/A self style N/A None N/A N/A  reset ivars and return a new cursor, possibly binding an auxiliary datahandler  N/A N/A N/A self headers N/A self results N/A N/A N/A N/A style N/A N/A c N/A N/A N/A self db cursor style N/A N/A c N/A N/A N/A self db cursor N/A N/A __OS__ java N/A N/A N/A hasattr self datahandler N/A N/A dh N/A self datahandler N/A N/A N/A c datahandler N/A dh N/A c datahandler N/A N/A c N/A mxODBCProxy c N/A c N/A commit N/A N/A self cursor close N/A None 1 N/A N/A  commit the cursor and create the result set  N/A N/A cursor N/A cursor description N/A N/A N/A self headers N/A cursor description N/A N/A self results N/A N/A cursor fetchall N/A N/A hasattr cursor nextset N/A N/A s N/A N/A cursor nextset N/A s N/A N/A N/A self results N/A N/A cursor fetchall N/A s N/A N/A cursor nextset N/A N/A hasattr cursor lastrowid N/A N/A N/A self lastrowid N/A cursor lastrowid N/A N/A hasattr cursor updatecount N/A N/A N/A self updatecount N/A cursor updatecount N/A N/A N/A N/A self autocommit N/A cursor None N/A N/A N/A N/A N/A self db autocommit N/A N/A N/A N/A N/A self db commit N/A N/A cursor close N/A N/A N/A N/A cursor close N/A rollback N/A N/A self N/A N/A N/A  rollback the cursor  N/A N/A N/A N/A self db rollback N/A prepare N/A N/A self sql N/A N/A N/A  prepare the sql statement  N/A cur N/A N/A self begin N/A N/A N/A N/A N/A cur prepare sql N/A N/A N/A N/A self commit cur N/A display N/A N/A self N/A N/A N/A  using the formatter, display the results  N/A N/A N/A self formatter N/A N/A self verbose 0 N/A N/A res N/A self results N/A res N/A N/A N/A self out N/A a N/A N/A self formatter res N/A map N/A N/A N/A x N/A N/A x N/A 0 N/A self headers N/A N/A N/A self out a N/A N/A self out N/A __execute__ N/A N/A self sql params bindings maxrows N/A None None None N/A N/A  the primary execution method  N/A cur N/A N/A self begin N/A N/A N/A bindings N/A N/A N/A N/A cur execute sql params bindings maxrows maxrows N/A N/A params N/A N/A N/A N/A cur execute sql params maxrows maxrows N/A N/A N/A N/A cur execute sql maxrows maxrows N/A N/A N/A N/A self commit cur close N/A isinstance sql StringType N/A isql N/A N/A self sql params bindings maxrows N/A None None None N/A N/A  execute and display the sql  N/A N/A N/A self raw sql params bindings maxrows maxrows N/A N/A N/A self display N/A raw N/A N/A self sql params bindings delim comments maxrows N/A None None None comments None N/A N/A  execute the sql and return a tuple of (headers, results)  N/A delim N/A N/A headers N/A N/A results N/A N/A N/A N/A type sql N/A type StringType N/A N/A comments N/A N/A sql N/A comments sql N/A statements N/A filter N/A N/A N/A x N/A N/A N/A len x 0 N/A map N/A N/A N/A statement N/A N/A N/A statement strip N/A N/A sql split delim N/A N/A statements N/A sql N/A a statements N/A N/A N/A N/A self __execute__ a params bindings maxrows maxrows N/A N/A N/A headers append N/A self headers N/A N/A N/A results append N/A self results N/A N/A self headers headers N/A N/A self results results N/A N/A N/A N/A self __execute__ sql params bindings maxrows maxrows N/A N/A N/A self headers N/A self results N/A callproc N/A N/A self procname params bindings maxrows N/A None None None N/A N/A  execute a stored procedure  N/A cur N/A N/A self begin N/A N/A N/A N/A N/A cur callproc procname params params bindings bindings maxrows maxrows N/A N/A N/A N/A self commit cur N/A N/A N/A self display N/A pk N/A N/A self table owner schema N/A None None N/A N/A  display the table's primary keys  N/A cur N/A N/A self begin N/A N/A N/A cur primarykeys schema owner table N/A N/A N/A self commit cur N/A N/A N/A self display N/A fk N/A N/A self primary_table foreign_table owner schema N/A None None None None N/A N/A  display the table's foreign keys  N/A cur N/A N/A self begin N/A N/A primary_table foreign_table N/A N/A N/A N/A cur foreignkeys schema owner primary_table schema owner foreign_table N/A N/A primary_table N/A N/A N/A N/A cur foreignkeys schema owner primary_table schema owner None N/A N/A foreign_table N/A N/A N/A N/A cur foreignkeys schema owner None schema owner foreign_table N/A N/A N/A self commit cur N/A N/A N/A self display N/A table N/A N/A self table types owner schema N/A None N/A TABLE None None N/A N/A If no table argument, displays a list of all tables.  If a table argument,
                displays the columns of the given table. N/A cur N/A N/A self begin N/A table N/A N/A N/A N/A cur columns schema owner table None N/A N/A N/A N/A cur tables schema owner None types N/A N/A N/A self commit cur N/A N/A N/A self display N/A proc N/A N/A self proc owner schema N/A None None None N/A N/A If no proc argument, displays a list of all procedures.  If a proc argument,
                displays the parameters of the given procedure. N/A cur N/A N/A self begin N/A proc N/A N/A N/A N/A cur procedurecolumns schema owner proc None N/A N/A N/A N/A cur procedures schema owner None N/A N/A N/A self commit cur N/A N/A N/A self display N/A stat N/A N/A self table qualifier owner unique accuracy N/A None None 0 0 N/A N/A  display the table's indicies  N/A cur N/A N/A self begin N/A N/A N/A cur statistics qualifier owner table unique accuracy N/A N/A N/A self commit cur N/A N/A N/A self display N/A typeinfo N/A N/A self sqltype N/A None N/A N/A  display the types available for the database  N/A cur N/A N/A self begin N/A N/A N/A cur gettypeinfo sqltype N/A N/A N/A self commit cur N/A N/A N/A self display N/A tabletypeinfo N/A N/A self N/A N/A N/A  display the table types available for the database  N/A cur N/A N/A self begin N/A N/A N/A cur gettabletypeinfo N/A N/A N/A self commit cur N/A N/A N/A self display N/A schema N/A N/A self table full sort owner N/A 0 1 None N/A N/A Displays a Schema object for the table.  If full is true, then generates
                references to the table in addition to the standard fields.  If sort is true,
                sort all the items in the schema, else leave them in db dependent order. N/A N/A self out N/A str N/A Schema self table owner full sort N/A bulkcopy N/A N/A self dst table include exclude autobatch executor N/A N/A N/A 0 executor N/A N/A Returns a Bulkcopy object using the given table. N/A N/A N/A type dst N/A type N/A N/A dst N/A dbexts dst cfg N/A self dbs N/A bcp N/A Bulkcopy dst table include include exclude exclude autobatch autobatch executor executor N/A bcp N/A bcp N/A N/A self src table where params include exclude autobatch executor N/A (1=1) N/A N/A N/A 0 executor N/A N/A Bulkcopy of rows from a src database to the current database for a given table and where clause. N/A N/A N/A type src N/A type N/A N/A src N/A dbexts src cfg N/A self dbs N/A bcp N/A N/A self bulkcopy self table include exclude autobatch executor N/A num N/A N/A bcp transfer src where params N/A num N/A unload N/A N/A self filename sql delimiter includeheaders N/A , 1 N/A N/A  Unloads the delimited results of the query to the file specified, optionally including headers.  N/A u N/A Unload self filename delimiter includeheaders N/A N/A N/A u unload sql N/A N/A Bulkcopy N/A N/A N/A The idea for a bcp class came from http://object-craft.com.au/projects/sybase __init__ N/A N/A self dst table include exclude autobatch executor N/A N/A N/A 0 executor N/A N/A N/A self dst dst N/A N/A self table table N/A N/A self total 0 N/A N/A self rows N/A N/A N/A self autobatch autobatch N/A N/A self bindings N/A N/A include N/A map N/A N/A N/A x N/A N/A N/A x lower include N/A exclude N/A map N/A N/A N/A x N/A N/A N/A x lower exclude N/A _verbose N/A N/A self dst verbose N/A N/A N/A self dst verbose 0 N/A N/A N/A N/A N/A N/A self dst table N/A self table N/A N/A N/A self dst results N/A N/A colmap N/A N/A a N/A N/A self dst results N/A N/A N/A colmap N/A N/A N/A N/A a N/A 3 lower N/A a N/A 4 N/A cols N/A N/A self __filter__ N/A N/A colmap keys include exclude N/A a N/A zip N/A range N/A len cols cols N/A N/A N/A N/A self bindings N/A N/A a N/A 0 N/A colmap N/A N/A a N/A 1 N/A colmap None N/A N/A cols N/A N/A self __filter__ include include exclude N/A N/A N/A N/A self dst verbose _verbose N/A N/A self executor N/A executor table cols N/A __str__ N/A N/A self N/A N/A N/A N/A [%s].[%s] N/A N/A self dst N/A self table N/A __repr__ N/A N/A self N/A N/A N/A N/A [%s].[%s] N/A N/A self dst N/A self table N/A __getattr__ N/A N/A self name N/A N/A N/A N/A name columns N/A N/A N/A N/A self executor cols N/A __filter__ N/A N/A self values include exclude N/A N/A N/A cols N/A map N/A N/A N/A col N/A N/A N/A col lower values N/A exclude N/A N/A cols N/A filter N/A N/A N/A x ex N/A exclude N/A x ex cols N/A include N/A N/A cols N/A filter N/A N/A N/A x inc N/A include N/A x inc cols N/A cols N/A format N/A N/A self column type N/A N/A N/A N/A N/A self bindings N/A column type N/A done N/A N/A self N/A N/A N/A N/A N/A len N/A self rows 0 N/A N/A N/A N/A self batch N/A 0 N/A batch N/A N/A self N/A N/A N/A N/A N/A N/A self executor execute N/A self dst N/A self rows N/A self bindings N/A cnt N/A len N/A self rows N/A N/A self total cnt N/A N/A self rows N/A N/A cnt N/A rowxfer N/A N/A self line N/A N/A N/A N/A N/A N/A self rows append line N/A N/A self autobatch N/A N/A N/A N/A self batch N/A transfer N/A N/A self src where params N/A (1=1) N/A N/A N/A sql N/A select %s from %s where %s N/A N/A N/A ,  join N/A self columns N/A self table where N/A N/A h d N/A N/A src raw sql params N/A d N/A N/A N/A map N/A self rowxfer d N/A N/A N/A self done N/A 0 N/A N/A Unload N/A N/A N/A Unloads a sql statement to a file with optional formatting of each value. __init__ N/A N/A self db filename delimiter includeheaders N/A , 1 N/A N/A N/A self db db N/A N/A self filename filename N/A N/A self delimiter delimiter N/A N/A self includeheaders includeheaders N/A N/A self formatters N/A N/A format N/A N/A self o N/A N/A N/A N/A o N/A N/A N/A o N/A str o N/A N/A N/A N/A o find , -1 N/A N/A o N/A ""%s"" o N/A o N/A unload N/A N/A self sql mode N/A w N/A N/A N/A headers results N/A N/A N/A self db raw sql N/A w N/A open N/A self filename mode N/A N/A self includeheaders N/A N/A N/A N/A w write N/A %s
 N/A N/A N/A self delimiter join N/A map N/A N/A N/A x N/A N/A x N/A 0 headers N/A results N/A N/A a results N/A N/A N/A N/A w write N/A %s
 N/A N/A N/A self delimiter join N/A map N/A self format a N/A N/A N/A w flush N/A N/A N/A w close N/A N/A Schema N/A N/A N/A Produces a Schema object which represents the database schema for a table __init__ N/A N/A self db table owner full sort N/A None 0 1 N/A N/A N/A self db db N/A N/A self table table N/A N/A self owner owner N/A N/A self full full N/A N/A self sort sort N/A _verbose N/A N/A self db verbose N/A N/A N/A self db verbose 0 N/A N/A N/A table N/A N/A N/A N/A self computeschema N/A N/A N/A N/A self db verbose _verbose N/A computeschema N/A N/A self N/A N/A N/A N/A N/A N/A self db table N/A self table owner N/A self owner N/A N/A self columns N/A N/A N/A N/A self db results N/A N/A N/A self columns N/A map N/A N/A N/A x N/A N/A N/A x N/A 3 N/A x N/A 5 N/A x N/A 6 N/A x N/A 10 N/A N/A self db results N/A N/A self sort N/A N/A N/A N/A N/A self columns sort N/A N/A N/A x y N/A N/A cmp N/A x N/A 0 N/A y N/A 0 N/A N/A N/A N/A self db fk None N/A self table N/A N/A self imported N/A N/A N/A N/A self db results N/A N/A N/A self imported N/A map N/A N/A N/A x N/A N/A N/A x N/A 2 N/A x N/A 3 N/A x N/A 7 N/A x N/A 11 N/A x N/A 12 N/A N/A self db results N/A N/A self sort N/A N/A N/A N/A N/A self imported sort N/A N/A N/A x y N/A N/A cmp N/A x N/A 2 N/A y N/A 2 N/A N/A self exported N/A N/A N/A self full N/A N/A N/A N/A N/A self db fk N/A self table None N/A N/A N/A self db results N/A N/A N/A self exported N/A map N/A N/A N/A x N/A N/A N/A x N/A 3 N/A x N/A 6 N/A x N/A 7 N/A x N/A 11 N/A x N/A 12 N/A N/A self db results N/A N/A self sort N/A N/A N/A N/A N/A self exported sort N/A N/A N/A x y N/A N/A cmp N/A x N/A 1 N/A y N/A 1 N/A N/A N/A N/A self db pk N/A self table N/A N/A self primarykeys N/A N/A N/A N/A self db results N/A N/A N/A self primarykeys N/A map N/A N/A N/A x N/A N/A N/A x N/A 3 N/A x N/A 4 N/A x N/A 5 N/A N/A self db results N/A N/A self sort N/A N/A N/A N/A N/A self primarykeys sort N/A N/A N/A x y N/A N/A cmp N/A x N/A 1 N/A y N/A 1 N/A N/A N/A N/A self indices None N/A N/A N/A N/A self db stat N/A self table N/A N/A self indices N/A N/A N/A N/A self db results N/A N/A idxdict N/A N/A idx N/A map N/A N/A N/A x N/A N/A N/A x N/A 3 N/A N/A N/A x N/A 5 strip N/A x N/A 6 N/A x N/A 7 N/A x N/A 8 N/A filter N/A N/A N/A x N/A N/A x N/A 5 N/A N/A self db results cckmp N/A N/A x y N/A N/A N/A c N/A cmp N/A x N/A 1 N/A y N/A 1 N/A N/A c 0 N/A N/A c N/A cmp N/A x N/A 3 N/A y N/A 3 N/A c N/A N/A N/A N/A idx sort cckmp N/A a idx N/A N/A N/A N/A N/A idxdict has_key N/A a N/A 1 N/A N/A N/A idxdict N/A N/A a N/A 1 N/A N/A N/A N/A N/A idxdict N/A N/A a N/A 1 append a N/A N/A self indices N/A N/A idxdict values N/A N/A self sort N/A N/A N/A N/A N/A self indices sort N/A N/A N/A x y N/A N/A cmp N/A N/A x N/A 0 N/A 1 N/A N/A y N/A 0 N/A 1 N/A N/A N/A N/A N/A __str__ N/A N/A self N/A N/A N/A d N/A N/A N/A N/A d append Table N/A N/A N/A d append N/A N/A self table N/A N/A N/A d append 
Primary Keys N/A a N/A self primarykeys N/A N/A N/A N/A d append N/A   %s {%s} N/A N/A a N/A 0 N/A a N/A 2 N/A N/A N/A d append 
Imported (Foreign) Keys N/A a N/A self imported N/A N/A N/A N/A d append N/A   %s (%s.%s) {%s} N/A N/A a N/A 2 N/A a N/A 0 N/A a N/A 1 N/A a N/A 3 N/A N/A self full N/A N/A N/A N/A d append 
Exported (Referenced) Keys N/A a N/A self exported N/A N/A N/A N/A d append N/A   %s (%s.%s) {%s} N/A N/A a N/A 0 N/A a N/A 1 N/A a N/A 2 N/A a N/A 3 N/A N/A N/A d append 
Columns N/A a N/A self columns N/A N/A nullable N/A choose N/A a N/A 3 nullable non-nullable N/A N/A N/A d append N/A   %-20s %s(%s), %s N/A N/A a N/A 0 N/A a N/A 1 N/A a N/A 2 nullable N/A N/A N/A d append 
Indices N/A N/A N/A self indices None N/A N/A N/A N/A d append  (failed) N/A N/A a N/A self indices N/A N/A unique N/A choose N/A N/A a N/A 0 N/A 0 non-unique unique N/A cname N/A N/A ,  join N/A map N/A N/A N/A x N/A N/A x N/A 4 a N/A N/A N/A d append N/A   %s index {%s} on (%s) N/A unique N/A N/A a N/A 0 N/A 1 cname N/A N/A N/A join d N/A N/A IniParser N/A N/A __init__ N/A N/A self cfg key N/A name N/A N/A N/A self key key N/A N/A self records N/A N/A N/A self ctypeRE N/A N/A re compile \[(jdbc|odbc|default)\] N/A N/A self entryRE N/A N/A re compile ([a-zA-Z]+)[ 	]*=[ 	]*(.*) N/A N/A self cfg cfg N/A N/A N/A self parse N/A parse N/A N/A self N/A N/A N/A fp N/A open N/A self cfg r N/A data N/A N/A fp readlines N/A N/A N/A fp close N/A lines N/A filter N/A N/A N/A x N/A N/A N/A N/A len x 0 N/A N/A x N/A 0 N/A # ; N/A map N/A N/A N/A x N/A N/A N/A x strip data N/A current None N/A i N/A range N/A len lines N/A N/A line N/A lines N/A i N/A g N/A N/A N/A self ctypeRE match line N/A g N/A N/A current N/A N/A N/A N/A N/A N/A self records has_key N/A N/A g group 1 N/A N/A N/A N/A self records N/A N/A N/A g group 1 N/A N/A N/A N/A N/A N/A self records N/A N/A N/A g group 1 append current N/A N/A g N/A N/A N/A self entryRE match line N/A g N/A N/A N/A current N/A N/A N/A g group 1 N/A N/A g group 2 N/A __getitem__ N/A N/A self N/A ctype skey N/A N/A N/A N/A skey N/A self key N/A N/A N/A N/A N/A N/A self records N/A ctype N/A 0 N/A skey N/A t N/A filter N/A N/A N/A x p s N/A N/A self key skey N/A N/A x N/A p s N/A N/A self records N/A ctype N/A N/A N/A t N/A N/A len t 1 N/A N/A KeyError N/A invalid key ('%s', '%s') N/A ctype skey N/A N/A t N/A 0 N/A N/A random_table_name N/A N/A prefix num_chars N/A N/A N/A random N/A d N/A prefix _ N/A i 0 N/A N/A i num_chars N/A N/A N/A N/A d append N/A chr N/A N/A N/A int N/A 100 N/A N/A random random 26 N/A ord A N/A i 1 N/A N/A N/A join d N/A ResultSetRow N/A N/A __init__ N/A N/A self rs row N/A N/A N/A N/A self row row N/A N/A self rs rs N/A __getitem__ N/A N/A self i N/A N/A N/A N/A N/A type i N/A type N/A N/A i N/A N/A N/A self rs index i N/A N/A N/A self row N/A i N/A __getslice__ N/A N/A self i j N/A N/A N/A N/A N/A type i N/A type N/A N/A i N/A N/A N/A self rs index i N/A N/A N/A type j N/A type N/A N/A j N/A N/A N/A self rs index j N/A N/A N/A self row N/A i j N/A __len__ N/A N/A self N/A N/A N/A N/A len N/A self row N/A __repr__ N/A N/A self N/A N/A N/A N/A str N/A self row N/A N/A ResultSet N/A N/A __init__ N/A N/A self headers results N/A N/A N/A N/A N/A self headers N/A map N/A N/A N/A x N/A N/A N/A x upper headers N/A N/A self results results N/A index N/A N/A self i N/A N/A N/A N/A N/A N/A self headers index N/A N/A i upper N/A __getitem__ N/A N/A self i N/A N/A N/A N/A ResultSetRow self N/A N/A self results N/A i N/A __getslice__ N/A N/A self i j N/A N/A N/A N/A map N/A N/A N/A x rs N/A self N/A ResultSetRow rs x N/A N/A self results N/A i j N/A __repr__ N/A N/A self N/A N/A N/A N/A <%s instance {cols [%d], rows [%d]} at %s> N/A N/A self __class__ N/A len N/A self headers N/A len N/A self results N/A id self N/A N/A