Module Import alias alias alias alias Expr Str Assign NameStore SubscriptLoad Str Slice Num Num ClassDef bases NameLoad body Pass decorator_list ClassDef bases body Expr Str FunctionDef arguments args NameParam NameParam defaults body Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore BinOpMod Str AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr If CompareGt Call NameLoad AttributeLoad AttributeLoad NameLoad attr attr Num body Assign NameStore Str Return NameLoad decorator_list If CompareEq AttributeLoad NameLoad attr Str body FunctionDef arguments args NameParam NameParam defaults body Import alias If CompareEq NameLoad AttributeLoad AttributeLoad NameLoad attr attr body Return Call AttributeLoad NameLoad attr Return NameLoad decorator_list decorator_list ClassDef bases AttributeLoad NameLoad attr body FunctionDef arguments args NameParam NameParam NameParam NameParam defaults NameLoad Str TupleLoad Str Str body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad keyword NameLoad If BoolOpOr CompareIs NameLoad NameLoad CompareEq Call NameLoad NameLoad Call NameLoad Str body Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr NameLoad orelse Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Dict Assign AttributeStore NameLoad attr ListLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr NameLoad Assign AttributeStore NameLoad attr Call NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign TupleStore NameStore NameStore NameStore Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad If BoolOpAnd NameLoad CompareNotEq NameLoad Str body Assign NameStore Call AttributeLoad NameLoad attr Return TupleLoad NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Print AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str TryExcept body Exec Call AttributeLoad NameLoad attr Call NameLoad handlers ExceptHandler body Print SubscriptLoad Call AttributeLoad NameLoad attr Index Num Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign AttributeStore NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad Call AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad AttributeLoad NameLoad attr orelse Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If Call NameLoad Call AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad AttributeLoad NameLoad attr orelse Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Print Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Print Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore Call AttributeLoad NameLoad attr If CompareGt Call NameLoad NameLoad Num body Assign AttributeStore NameLoad attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If UnaryOpNot NameLoad body Assign NameStore AttributeLoad AttributeLoad NameLoad attr attr TryFinally body If NameLoad body Expr Call AttributeLoad NameLoad attr finalbody Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad orelse Assign NameStore Call NameLoad NameLoad Str Assign AttributeStore AttributeLoad NameLoad attr attr NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str TryFinally body If AttributeLoad AttributeLoad NameLoad attr attr body Expr Call AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr finalbody Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str If CompareEq Call NameLoad Call AttributeLoad NameLoad attr Num body Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr If Call NameLoad NameLoad body Print For NameStore SubscriptLoad Call AttributeLoad NameLoad attr NameLoad TupleLoad Str Str Slice Num body Print NameLoad Print Return 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 Str If CompareEq Call NameLoad NameLoad Num body If Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad NameLoad Index Num body Delete SubscriptDel AttributeLoad NameLoad attr Index SubscriptLoad NameLoad Index Num orelse Assign SubscriptStore AttributeLoad NameLoad attr Index SubscriptLoad NameLoad Index Num Call NameLoad SubscriptLoad NameLoad Index Num decorator_list FunctionDef arguments args NameParam NameParam defaults body Assign NameStore Call NameLoad NameLoad TryFinally body Print For NameStore Call AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad NameLoad finalbody Expr Call AttributeLoad NameLoad attr Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body TryExcept body Assign NameStore Call AttributeLoad NameLoad attr If UnaryOpNot NameLoad body Return NameLoad Assign NameStore ListComp Call AttributeLoad NameLoad attr NameLoad comprehension NameStore AttributeLoad NameLoad attr If Call NameLoad Lambda arguments args NameParam NameParam defaults BoolOpOr NameLoad NameLoad NameLoad body Return NameLoad If CompareEq SubscriptLoad NameLoad Index Num Str body Assign NameStore SubscriptLoad NameLoad Slice Num If CompareGtE Call NameLoad NameLoad Call NameLoad AttributeLoad NameLoad attr body If CompareEq SubscriptLoad NameLoad Slice BinOpMult Num Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Expr Call AttributeLoad AttributeLoad NameLoad attr attr SubscriptLoad NameLoad Slice BinOpMult Num Call NameLoad AttributeLoad NameLoad attr If AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad Str attr AttributeLoad NameLoad attr Print NameLoad Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad AttributeLoad NameLoad attr Assign AttributeStore NameLoad attr ListLoad If AttributeLoad AttributeLoad NameLoad attr attr body Print If CompareEq AttributeLoad AttributeLoad NameLoad attr attr Num body Print Str orelse Print BinOpMod Str AttributeLoad AttributeLoad NameLoad attr attr Print Return NameLoad If NameLoad body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad handlers ExceptHandler body Assign AttributeStore NameLoad attr ListLoad Print Print SubscriptLoad Call AttributeLoad NameLoad attr Index Num Print Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Raise Call NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body While Num body TryExcept body Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad NameLoad handlers ExceptHandler type NameLoad name NameStore body Break ExceptHandler type NameLoad name NameStore body Print Print NameLoad Print Assign NameStore NameLoad decorator_list decorator_list If CompareEq NameLoad Str body Import alias TryExcept body Assign TupleStore NameStore NameStore Call AttributeLoad NameLoad attr SubscriptLoad AttributeLoad NameLoad attr Slice Num Str ListLoad handlers ExceptHandler type AttributeLoad NameLoad attr name NameStore body Print Print NameLoad Print BinOpMod Str SubscriptLoad AttributeLoad NameLoad attr Index Num Expr Call AttributeLoad NameLoad attr Num Assign NameStore NameLoad For TupleStore NameStore NameStore NameLoad body If CompareEq NameLoad Str body Assign NameStore NameLoad Assign NameStore BinOpMod Str NameLoad Assign NameStore Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr
N/A N/A dbexts cmd sys os N/A 
Isql works in conjunction with dbexts to provide an interactive environment
for database work.
 N/A __version__ N/A $Revision: 6639 $ N/A 11 -2 IsqlExit N/A Exception N/A N/A N/A Prompt N/A N/A N/A 
    This class fixes a problem with the cmd.Cmd class since it uses an ivar 'prompt'
    as opposed to a method 'prompt()'.  To get around this, this class is plugged in
    as a 'prompt' attribute and when invoked the '__str__' method is called which
    figures out the appropriate prompt to display.  I still think, even though this
    is clever, the attribute version of 'prompt' is poor design.
     __init__ N/A N/A self isql N/A N/A N/A N/A self isql isql N/A __str__ N/A N/A self N/A N/A N/A prompt N/A %s>  N/A N/A N/A self isql db dbname N/A N/A N/A len N/A N/A self isql sqlbuffer 0 N/A N/A prompt ...  N/A prompt N/A N/A N/A N/A os name java N/A __tojava__ N/A N/A self cls N/A N/A N/A java.lang.String N/A N/A cls N/A N/A java lang String N/A N/A N/A N/A self __str__ N/A False N/A N/A IsqlCmd N/A N/A cmd Cmd N/A __init__ N/A N/A self db delimiter comment N/A None ; N/A # -- N/A N/A N/A N/A N/A cmd Cmd __init__ self completekey None N/A N/A N/A db None N/A N/A type db N/A type N/A N/A N/A self db N/A N/A dbexts dbexts db N/A N/A N/A self db db N/A N/A self kw N/A N/A N/A self sqlbuffer N/A N/A N/A self comment comment N/A N/A self delimiter delimiter N/A N/A self prompt N/A Prompt self N/A parseline N/A N/A self line N/A N/A N/A N/A command arg line N/A N/A N/A cmd Cmd parseline self line N/A N/A command N/A command EOF N/A N/A command N/A N/A command lower N/A N/A command arg line N/A do_which N/A N/A self arg N/A N/A N/A 
Prints the current db connection parameters.
 N/A N/A self db N/A False N/A do_EOF N/A N/A self arg N/A N/A N/A False N/A do_p N/A N/A self arg N/A N/A N/A 
Execute a python expression.
 N/A N/A N/A N/A N/A arg strip N/A globals N/A N/A N/A N/A N/A N/A N/A sys exc_info N/A 1 N/A False N/A do_column N/A N/A self arg N/A N/A N/A 
Instructions for column display.
 N/A False N/A do_use N/A N/A self arg N/A N/A N/A 
Use a new database connection.
 N/A N/A self db N/A N/A N/A self db __class__ N/A N/A arg strip N/A False N/A do_table N/A N/A self arg N/A N/A N/A 
Prints table meta-data.  If no table name, prints all tables.
 N/A N/A len N/A N/A arg strip N/A N/A N/A N/A N/A self db table arg N/A self kw N/A N/A N/A N/A N/A self db table None N/A self kw N/A False N/A do_proc N/A N/A self arg N/A N/A N/A 
Prints store procedure meta-data.
 N/A N/A len N/A N/A arg strip N/A N/A N/A N/A N/A self db proc arg N/A self kw N/A N/A N/A N/A N/A self db proc None N/A self kw N/A False N/A do_schema N/A N/A self arg N/A N/A N/A 
Prints schema information.
 N/A N/A N/A N/A N/A self db schema arg N/A N/A False N/A do_delimiter N/A N/A self arg N/A N/A N/A 
Change the delimiter.
 N/A delimiter N/A N/A arg strip N/A N/A N/A len delimiter 0 N/A N/A N/A self delimiter delimiter N/A do_o N/A N/A self arg N/A N/A N/A 
Set the output.
 N/A N/A arg N/A N/A fp N/A N/A self db out N/A N/A N/A fp N/A N/A N/A N/A fp close N/A N/A N/A N/A self db out None N/A N/A fp N/A open arg w N/A N/A N/A self db out fp N/A do_q N/A N/A self arg N/A N/A N/A 
Quit.
 N/A N/A N/A N/A N/A self db out N/A N/A N/A N/A N/A N/A self db out close N/A N/A True N/A do_set N/A N/A self arg N/A N/A N/A 
Set a parameter. Some examples:
 set owner = 'informix'
 set types = ['VIEW', 'TABLE']
The right hand side is evaluated using `eval()`
 N/A N/A N/A len N/A N/A arg strip 0 N/A N/A items N/A N/A N/A self kw items N/A N/A len items N/A N/A N/A a N/A N/A N/A dbexts console items N/A key value N/A -1 N/A N/A a N/A N/A False N/A d 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 x N/A N/A N/A x strip N/A N/A arg split = N/A N/A N/A len d 1 N/A N/A N/A N/A N/A self kw has_key N/A d N/A 0 N/A N/A N/A N/A self kw N/A N/A d N/A 0 N/A N/A N/A N/A self kw N/A N/A d N/A 0 N/A eval N/A d N/A 1 N/A do_i N/A N/A self arg N/A N/A N/A fp N/A open arg N/A N/A N/A N/A line N/A N/A fp readlines N/A N/A line N/A N/A self precmd line N/A stop N/A N/A self onecmd line N/A stop N/A N/A self postcmd stop line N/A N/A N/A N/A fp close N/A False N/A default N/A N/A self arg N/A N/A N/A N/A N/A token N/A N/A arg strip N/A N/A token N/A N/A False N/A comment N/A N/A N/A token startswith x N/A x N/A self comment N/A N/A reduce N/A N/A N/A x y N/A N/A x y comment N/A N/A False N/A N/A N/A token N/A 0 \ N/A N/A token N/A token N/A 1 N/A N/A N/A len token N/A len N/A self delimiter N/A N/A N/A N/A token N/A N/A -1 N/A len N/A self delimiter N/A self delimiter N/A N/A N/A N/A N/A self sqlbuffer append N/A token N/A N/A -1 N/A len N/A self delimiter N/A N/A self sqlbuffer N/A N/A q N/A N/A join N/A self sqlbuffer N/A q N/A N/A N/A N/A self db isql q N/A self kw N/A N/A self sqlbuffer N/A N/A N/A N/A self db updatecount N/A N/A N/A N/A N/A N/A self db updatecount 1 N/A N/A 1 row affected N/A N/A N/A %d rows affected N/A N/A self db updatecount N/A N/A False N/A token N/A N/A N/A N/A N/A self sqlbuffer append token N/A N/A N/A N/A N/A self sqlbuffer N/A N/A N/A N/A N/A N/A sys exc_info N/A 1 N/A N/A False N/A emptyline N/A N/A self N/A N/A N/A False N/A postloop N/A N/A self N/A N/A N/A N/A IsqlExit N/A cmdloop N/A N/A self intro N/A None N/A N/A 1 N/A N/A N/A N/A N/A N/A N/A cmd Cmd cmdloop self intro N/A N/A N/A IsqlExit N/A e N/A N/A N/A N/A Exception N/A e N/A N/A N/A e N/A N/A intro None N/A N/A N/A N/A __name__ __main__ N/A N/A getopt N/A N/A N/A N/A opts args N/A N/A getopt getopt N/A N/A sys argv N/A 1 b: N/A N/A N/A N/A N/A getopt error N/A msg N/A N/A N/A msg N/A N/A Try `%s --help` for more information. N/A N/A sys argv N/A 0 N/A N/A N/A sys exit 0 N/A dbname None N/A N/A opt arg opts N/A N/A N/A opt -b N/A N/A dbname arg N/A intro N/A 
isql - interactive sql (%s)
 __version__ N/A isql N/A IsqlCmd dbname N/A N/A N/A isql cmdloop