def pyclearsilver.odb.Table.__init__ | ( | self, | |
database, | |||
table_name, | |||
rowClass = None , |
|||
check = 0 , |
|||
create = 0 , |
|||
rowListClass = None , |
|||
replication = None |
|||
) |
def pyclearsilver.odb.Table.__buildWhereClause | ( | self, | |
col_match_spec, | |||
other_clauses = None |
|||
) | [private] |
def pyclearsilver.odb.Table.__checkColumnLock | ( | self | ) | [private] |
def pyclearsilver.odb.Table.__fetchRows | ( | self, | |
col_match_spec, | |||
cursor = None , |
|||
where = None , |
|||
order_by = None , |
|||
limit_to = None , |
|||
skip_to = None , |
|||
join = None , |
|||
join2 = None , |
|||
column_list = None , |
|||
raw_rows = False |
|||
) | [private] |
def pyclearsilver.odb.Table.__lockColumnsAndInit | ( | self | ) | [private] |
def pyclearsilver.odb.Table._colTypeToSQLType | ( | self, | |
colname, | |||
coltype, | |||
options, | |||
singlePrimaryKey = 0 |
|||
) | [private] |
def pyclearsilver.odb.Table._createTableSQL | ( | self | ) | [private] |
def pyclearsilver.odb.Table._defineRelations | ( | self | ) | [private] |
def pyclearsilver.odb.Table._defineRows | ( | self | ) | [private] |
Reimplemented in pyclearsilver.odb.Replication_DeletedTable, pyclearsilver.odb.Replication_LogTable, pyclearsilver.odb.Replication_KeyValueTable, pyclearsilver.odb._ReflectTable, pyclearsilver.test_odb.TestTable, pyclearsilver.test_odb.AgentsTable, pyclearsilver.trans.db_trans.TransMapTable, pyclearsilver.trans.db_trans.TransLocTable, and pyclearsilver.trans.db_trans.TransStringTable.
def pyclearsilver.odb.Table._fixColMatchSpec | ( | self, | |
col_match_spec, | |||
should_match_unique_row = 0 |
|||
) | [private] |
_checkColMatchSpec(col_match_spec,should_match_unique_row = 0)
raise an error if the col_match_spec contains invalid columns, or (in the case of should_match_unique_row) if it does not fully specify a unique row.
NOTE: we don't currently support where clauses with value column fields!
def pyclearsilver.odb.Table.addIndex | ( | self, | |
columns, | |||
indexName = None , |
|||
unique = 0 |
|||
) |
def pyclearsilver.odb.Table.alterTableToMatch | ( | self, | |
cursor = None |
|||
) |
def pyclearsilver.odb.Table.checkTable | ( | self, | |
warnflag = 1 |
|||
) |
def pyclearsilver.odb.Table.columnType | ( | self, | |
col_name | |||
) |
def pyclearsilver.odb.Table.convertDataForColumn | ( | self, | |
data, | |||
col_name | |||
) |
def pyclearsilver.odb.Table.createIndex | ( | self, | |
columns, | |||
indexName = None , |
|||
unique = 0 , |
|||
cursor = None |
|||
) |
def pyclearsilver.odb.Table.createTable | ( | self, | |
cursor = None |
|||
) |
Reimplemented in pyclearsilver.odb.Replication_KeyValueTable.
def pyclearsilver.odb.Table.d_addColumn | ( | self, | |
col_name, | |||
ctype, | |||
size = None , |
|||
primarykey = 0 , |
|||
notnull = 0 , |
|||
indexed = 0 , |
|||
default = None , |
|||
unique = 0 , |
|||
autoincrement = 0 , |
|||
autoguid = 0 , |
|||
safeupdate = 0 , |
|||
enum_values = None , |
|||
no_export = 0 , |
|||
relations = None , |
|||
foreign_key = None , |
|||
compress_ok = 0 , |
|||
int_date = 0 |
|||
) |
def pyclearsilver.odb.Table.d_addDeleteTrigger | ( | self, | |
triggerName, | |||
tsql | |||
) |
def pyclearsilver.odb.Table.d_addInsertTrigger | ( | self, | |
triggerName, | |||
tsql | |||
) |
def pyclearsilver.odb.Table.d_addUpdateColumnsTrigger | ( | self, | |
triggerName, | |||
columns, | |||
tsql | |||
) |
def pyclearsilver.odb.Table.d_addUpdateTrigger | ( | self, | |
triggerName, | |||
tsql | |||
) |
def pyclearsilver.odb.Table.d_addValueColumn | ( | self | ) |
def pyclearsilver.odb.Table.d_addVColumn | ( | self, | |
col_name, | |||
type, | |||
size = None , |
|||
default = None |
|||
) |
def pyclearsilver.odb.Table.d_belongsTo | ( | self, | |
col_name, | |||
tblNameStr = None , |
|||
foreign_key = None , |
|||
order = None |
|||
) |
def pyclearsilver.odb.Table.d_fullTextSearch | ( | self | ) |
def pyclearsilver.odb.Table.d_hasMany | ( | self, | |
tblname, | |||
col_name, | |||
foreign_key = None , |
|||
order = None |
|||
) |
def pyclearsilver.odb.Table.d_hasOne | ( | self, | |
col_name, | |||
tblname, | |||
foreign_key = None , |
|||
order = None |
|||
) |
def pyclearsilver.odb.Table.databaseSizeForData_ColumnName_ | ( | self, | |
data, | |||
col_name | |||
) |
def pyclearsilver.odb.Table.deleteAllRows | ( | self, | |
cursor = None |
|||
) |
def pyclearsilver.odb.Table.dropTable | ( | self, | |
cursor = None |
|||
) |
def pyclearsilver.odb.Table.getAppColumnList | ( | self | ) |
def pyclearsilver.odb.Table.getColumnDef | ( | self, | |
column_name | |||
) |
def pyclearsilver.odb.Table.getColumnList | ( | self | ) |
def pyclearsilver.odb.Table.getColumnOption | ( | self, | |
columnName, | |||
optionName | |||
) |
def pyclearsilver.odb.Table.getDB | ( | self | ) |
def pyclearsilver.odb.Table.getIndices | ( | self | ) |
def pyclearsilver.odb.Table.getPrimaryKeyList | ( | self | ) |
def pyclearsilver.odb.Table.getRelations | ( | self | ) |
def pyclearsilver.odb.Table.getReplication | ( | self | ) |
def pyclearsilver.odb.Table.getTableColumnsFromDB | ( | self | ) |
def pyclearsilver.odb.Table.getTableName | ( | self | ) |
def pyclearsilver.odb.Table.hasColumn | ( | self, | |
column_name | |||
) |
def pyclearsilver.odb.Table.hasColumn | ( | self, | |
name | |||
) |
def pyclearsilver.odb.Table.hasReplication | ( | self | ) |
def pyclearsilver.odb.Table.hasValueColumn | ( | self | ) |
def pyclearsilver.odb.Table.hasVColumn | ( | self, | |
name | |||
) |
def pyclearsilver.odb.Table.renameTable | ( | self, | |
newTableName, | |||
cursor = None |
|||
) |
def pyclearsilver.odb.Table.setTableName | ( | self, | |
tablename | |||
) |
def pyclearsilver.odb.Table.subclassinit | ( | self | ) |
pyclearsilver::odb.Table::__col_def_hash [private] |
pyclearsilver::odb.Table::__column_list [private] |
pyclearsilver::odb.Table::__db [private] |
pyclearsilver::odb.Table::__indices [private] |
pyclearsilver::odb.Table::__replication [private] |
pyclearsilver::odb.Table::__table_name [private] |
pyclearsilver::odb.Table::__vcolumn_list [private] |
pyclearsilver::odb.Table::_triggers [private] |