Contents
Columns
module: pyrseas.dbobject.column
The column module defines two classes, Column derived from DbSchemaObject and ColumnDict, derived from DbObjectDict.
Column
Column is derived from ~pyrseas.dbobject.DbSchemaObject and represents a column of a table, or an attribute of a composite type. Its keylist attributes are the schema name and the table name.
A Column has the following attributes: name, type, not_null, default and collation. The number attribute is also present but is not made visible externally.
autoclass: Column
automethod: Column.to_map
automethod: Column.add
automethod: Column.add_privs
automethod: Column.diff_privileges
automethod: Column.comment
automethod: Column.drop
automethod: Column.rename
automethod: Column.alter
Column Dictionary
Class ColumnDict is a dictionary derived from ~pyrseas.dbobject.DbObjectDict and represents the collection of columns in a database, across multiple tables. It is indexed by the schema name and table name, and each value is a list of Column objects.
autoclass: ColumnDict
automethod: ColumnDict.from_map