Module Expr Str ImportFrom alias alias ImportFrom alias alias alias ClassDef bases NameLoad body Expr Str Assign NameStore ListLoad Str Str Str Str Assign NameStore Str Assign NameStore NameLoad FunctionDef arguments args NameParam defaults body Expr Str Return BinOpMod Str TupleLoad Call AttributeLoad AttributeLoad NameLoad attr attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Return BoolOpOr BoolOpAnd CompareEq AttributeLoad NameLoad attr Str AttributeLoad NameLoad attr BinOpMod Str TupleLoad Call NameLoad AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Return BinOpMod Str TupleLoad Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore ListLoad If CompareNotEq AttributeLoad NameLoad attr Str body Expr Call AttributeLoad NameLoad attr BinOpMod Str AttributeLoad NameLoad attr If CompareNotEq AttributeLoad NameLoad attr Str body Expr Call AttributeLoad NameLoad attr BinOpMod Str AttributeLoad NameLoad attr If Call NameLoad NameLoad Str body Expr Call AttributeLoad NameLoad attr BinOpMod Str AttributeLoad NameLoad attr If Call NameLoad NameLoad Str body Expr Call AttributeLoad NameLoad attr BinOpMod Str AttributeLoad NameLoad attr If Call NameLoad NameLoad Str body Expr Call AttributeLoad NameLoad attr BinOpMod Str AttributeLoad NameLoad attr If Call NameLoad NameLoad Str body Expr Call AttributeLoad NameLoad attr BinOpMod Str AttributeLoad NameLoad attr If BoolOpAnd Call NameLoad NameLoad Str AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Str If BoolOpAnd Call NameLoad NameLoad Str AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Str Return ListLoad BinOpMod Str TupleLoad Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr IfExp NameLoad Str Str Call AttributeLoad Str attr NameLoad decorator_list NameLoad NameLoad decorator_list ClassDef bases NameLoad body Expr Str Assign NameStore NameLoad Assign NameStore Str FunctionDef arguments args NameParam defaults body Expr Str For NameStore Call AttributeLoad NameLoad attr body Assign TupleStore NameStore NameStore NameStore NameStore Call AttributeLoad NameLoad attr If CompareEq NameLoad Str body Assign NameStore AttributeStore NameLoad attr Str If CompareEq NameLoad Str body Assign NameStore AttributeStore NameLoad attr Str If CompareEq AttributeLoad NameLoad attr Str body Delete AttributeDel NameLoad attr If CompareEq AttributeLoad NameLoad attr Str body Delete AttributeDel NameLoad attr If CompareEq AttributeLoad NameLoad attr Str body Delete AttributeDel NameLoad attr If CompareEq AttributeLoad NameLoad attr Str body Delete AttributeDel NameLoad attr Assign SubscriptStore NameLoad Index TupleLoad NameLoad NameLoad NameLoad NameLoad Call NameLoad AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam NameParam NameParam defaults body Expr Str For NameStore NameLoad body Assign TupleStore NameStore NameStore NameStore Call AttributeLoad NameLoad attr Str If BoolOpOr CompareNotEq NameLoad Str CompareNotEq NameLoad Str body Raise Call NameLoad BinOpMod Str NameLoad Assign NameStore Call AttributeLoad NameLoad attr Str If BoolOpOr CompareEq NameLoad Num CompareNotEq SubscriptLoad NameLoad Slice Num Str body Raise Call NameLoad BinOpMod Str NameLoad Assign TupleStore NameStore NameStore Call AttributeLoad SubscriptLoad NameLoad Slice BinOpAdd NameLoad Num Num attr Str Assign NameStore Call AttributeLoad NameLoad attr Assign NameStore SubscriptLoad NameLoad Index NameLoad Assign NameStore SubscriptLoad NameLoad Slice NameLoad Assign SubscriptStore NameLoad Index TupleLoad AttributeLoad NameLoad attr NameLoad NameLoad NameLoad NameStore Call NameLoad keyword AttributeLoad NameLoad attr keyword NameLoad keyword NameLoad keyword NameLoad If UnaryOpNot NameLoad body Raise Call NameLoad BinOpMod Str NameLoad For TupleStore NameStore NameStore Call NameLoad Call AttributeLoad NameLoad attr body Expr Call NameLoad NameLoad NameLoad NameLoad If CompareIn Str NameLoad body Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str If CompareIn Str NameLoad body Assign AttributeStore NameLoad attr SubscriptLoad NameLoad Index Str decorator_list FunctionDef arguments args NameParam NameParam defaults body Expr Str Assign NameStore ListLoad For TupleStore NameStore NameStore NameStore NameStore NameLoad body Assign NameStore SubscriptLoad NameLoad Index TupleLoad NameLoad NameLoad NameLoad NameLoad If CompareNotIn TupleLoad NameLoad NameLoad NameLoad NameLoad NameLoad body If UnaryOpNot Call NameLoad NameLoad Str body Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr orelse Expr Call AttributeLoad NameLoad attr Call AttributeLoad SubscriptLoad NameLoad Index TupleLoad NameLoad NameLoad NameLoad NameLoad attr NameLoad orelse Expr Call AttributeLoad NameLoad attr Call AttributeLoad SubscriptLoad NameLoad Index TupleLoad NameLoad NameLoad NameLoad NameLoad attr NameLoad For TupleStore NameStore NameStore NameStore NameStore NameLoad body Assign NameStore SubscriptLoad NameLoad Index TupleLoad NameLoad NameLoad NameLoad NameLoad If CompareNotIn TupleLoad NameLoad NameLoad NameLoad NameLoad NameLoad body Assign AttributeStore NameLoad attr NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore ListLoad For TupleStore NameStore NameStore NameStore NameStore NameLoad body Assign NameStore SubscriptLoad NameLoad Index TupleLoad NameLoad NameLoad NameLoad NameLoad If Call NameLoad NameLoad Str body Expr Call AttributeLoad NameLoad attr Call AttributeLoad NameLoad attr Return NameLoad decorator_list decorator_list
N/A N/A 
    pyrseas.dbobject.operator
    ~~~~~~~~~~~~~~~~~~~~~~~~~

    This module defines two classes: Operator derived from
    DbSchemaObject and OperatorDict derived from DbObjectDict.
 pyrseas.dbobject DbObjectDict DbSchemaObject pyrseas.dbobject quote_id commentable ownable Operator N/A DbSchemaObject N/A N/A An operator N/A keylist N/A schema name leftarg rightarg N/A objtype OPERATOR N/A single_extern_file True extern_key N/A N/A self N/A N/A N/A Return the key to be used in external maps for this operator

        :return: string
         N/A N/A %s %s(%s, %s) N/A N/A N/A N/A self objtype lower N/A self name N/A self leftarg N/A self rightarg N/A qualname N/A N/A self N/A N/A N/A Return the schema-qualified name of the operator

        :return: string

        No qualification is used if the schema is 'public'.
         N/A N/A N/A N/A N/A self schema public N/A self name N/A %s.%s N/A N/A quote_id N/A self schema N/A self name N/A identifier N/A N/A self N/A N/A N/A Return a full identifier for an operator object

        :return: string
         N/A N/A %s(%s, %s) N/A N/A N/A self qualname N/A self leftarg N/A self rightarg N/A create N/A N/A self N/A N/A N/A Return SQL statements to CREATE or REPLACE the operator

        :return: SQL statements
         N/A opt_clauses N/A N/A N/A N/A self leftarg NONE N/A N/A N/A N/A opt_clauses append N/A LEFTARG = %s N/A self leftarg N/A N/A N/A self rightarg NONE N/A N/A N/A N/A opt_clauses append N/A RIGHTARG = %s N/A self rightarg N/A N/A hasattr self commutator N/A N/A N/A N/A opt_clauses append N/A COMMUTATOR = OPERATOR(%s) N/A self commutator N/A N/A hasattr self negator N/A N/A N/A N/A opt_clauses append N/A NEGATOR = OPERATOR(%s) N/A self negator N/A N/A hasattr self restrict N/A N/A N/A N/A opt_clauses append N/A RESTRICT = %s N/A self restrict N/A N/A hasattr self join N/A N/A N/A N/A opt_clauses append N/A JOIN = %s N/A self join N/A N/A N/A hasattr self hashes N/A self hashes N/A N/A N/A N/A opt_clauses append HASHES N/A N/A N/A hasattr self merges N/A self merges N/A N/A N/A N/A opt_clauses append MERGES N/A N/A N/A CREATE OPERATOR %s (
    PROCEDURE = %s%s%s) N/A N/A N/A self qualname N/A self procedure N/A opt_clauses ,
     N/A N/A ,
     join opt_clauses N/A commentable ownable N/A OperatorDict N/A DbObjectDict N/A N/A The collection of operators in a database N/A cls Operator N/A query SELECT nspname AS schema, oprname AS name, rolname AS owner,
                  oprleft::regtype AS leftarg, oprright::regtype AS rightarg,
                  oprcode AS procedure, oprcom::regoper AS commutator,
                  oprnegate::regoper AS negator, oprrest AS restrict,
                  oprjoin AS join, oprcanhash AS hashes,
                  oprcanmerge AS merges,
                  obj_description(o.oid, 'pg_operator') AS description
           FROM pg_operator o
                JOIN pg_roles r ON (r.oid = oprowner)
                JOIN pg_namespace n ON (oprnamespace = n.oid)
           WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
             AND o.oid NOT IN (
                 SELECT objid FROM pg_depend WHERE deptype = 'e'
                              AND classid = 'pg_operator'::regclass)
           ORDER BY nspname, oprname _from_catalog N/A N/A self N/A N/A N/A Initialize the dictionary of operators by querying the catalogs N/A oper N/A N/A self fetch N/A N/A N/A sch opr lft rgt N/A N/A oper key N/A N/A lft - N/A N/A lft N/A oper leftarg NONE N/A N/A rgt - N/A N/A rgt N/A oper rightarg NONE N/A N/A N/A oper commutator 0 N/A N/A N/A oper commutator N/A N/A N/A oper negator 0 N/A N/A N/A oper negator N/A N/A N/A oper restrict - N/A N/A N/A oper restrict N/A N/A N/A oper join - N/A N/A N/A oper join N/A N/A self N/A N/A sch opr lft rgt N/A Operator N/A oper __dict__ N/A from_map N/A N/A self schema inopers N/A N/A N/A Initalize the dictionary of operators by converting the input map

        :param schema: schema owning the operators
        :param inopers: YAML map defining the operators
         N/A key inopers N/A N/A N/A objtype spc opr N/A N/A key partition N/A N/A N/A spc N/A objtype operator N/A N/A N/A KeyError N/A Unrecognized object type: %s key N/A paren N/A N/A opr find ( N/A N/A N/A paren -1 N/A N/A opr N/A -1 ) N/A N/A N/A KeyError N/A Invalid operator signature: %s opr N/A N/A leftarg rightarg N/A N/A N/A opr N/A N/A paren 1 -1 split , N/A rightarg N/A N/A rightarg lstrip N/A inoper N/A inopers N/A key N/A opr N/A opr N/A paren N/A N/A self N/A N/A N/A schema name opr leftarg rightarg oper N/A Operator schema N/A schema name name opr leftarg leftarg rightarg rightarg N/A N/A inoper N/A N/A N/A ValueError N/A Operator '%s' has no specification opr N/A N/A attr val N/A list N/A N/A inoper items N/A N/A N/A setattr oper attr val N/A N/A oldname inoper N/A N/A N/A oper oldname N/A inoper N/A oldname N/A N/A description inoper N/A N/A N/A oper description N/A inoper N/A description N/A diff_map N/A N/A self inopers N/A N/A N/A Generate SQL to transform existing operators

        :param inopers: a YAML map defining the new operators
        :return: list of SQL statements

        Compares the existing operator definitions, as fetched from
        the catalogs, to the input map and generates SQL statements to
        transform the operators accordingly.
         N/A stmts N/A N/A N/A sch opr lft rgt inopers N/A N/A inoper N/A inopers N/A N/A sch opr lft rgt N/A N/A N/A sch opr lft rgt self N/A N/A N/A N/A hasattr inoper oldname N/A N/A N/A N/A stmts append N/A N/A inoper create N/A N/A N/A N/A stmts append N/A N/A N/A self N/A N/A sch opr lft rgt rename inoper N/A N/A N/A N/A stmts append N/A N/A N/A self N/A N/A sch opr lft rgt diff_map inoper N/A N/A sch opr lft rgt self N/A N/A oper N/A self N/A N/A sch opr lft rgt N/A N/A N/A sch opr lft rgt inopers N/A N/A N/A oper dropped False N/A stmts N/A _drop N/A N/A self N/A N/A N/A Actually drop the operators

        :return: SQL statements
         N/A stmts N/A N/A N/A sch opr lft rgt self N/A N/A oper N/A self N/A N/A sch opr lft rgt N/A N/A hasattr oper dropped N/A N/A N/A N/A stmts append N/A N/A oper drop N/A stmts N/A N/A