Classes | |
| class | _ODB_BigString |
| class | _ODB_Blob |
| class | _ODB_CreatedStamp |
| class | _ODB_CreatedStampMS |
| class | _ODB_DateTime |
| class | _ODB_Enumeration |
| class | _ODB_FixedString |
| class | _ODB_GUID |
| class | _ODB_IncInteger |
| class | _ODB_Integer |
| class | _ODB_ModifiedStamp |
| class | _ODB_Object |
| class | _ODB_Real |
| class | _ODB_TimeStamp |
| class | _ODB_VarString |
| class | _ReflectTable |
| class | Connection |
| class | Cursor |
| class | Database |
| class | eDuplicateKey |
| class | eInternalError |
| class | eInvalidData |
| class | eInvalidJoinSpec |
| class | eInvalidMatchSpec |
| class | eNoMatchingRows |
| class | eNonUniqueMatchSpec |
| class | eNoSuchColumn |
| class | eUnsavedObjectLost |
| class | odb_Exception |
| class | ODB_FixedPoint |
| class | Replication_DeletedTable |
| class | Replication_KeyValueTable |
| class | Replication_LogRow |
| class | Replication_LogTable |
| class | ReplicationLog |
| class | Row |
| class | Table |
| Table. More... | |
Functions | |
| def | __del__ |
| def | __deleteRow |
| def | __delitem__ |
| def | __getattr__ |
| def | __getitem__ |
| def | __insertRow |
| def | __len__ |
| def | __packVColumn |
| #warn(self) val2 = self.getDB().decode(val) warn("val2", repr(val2)) self.__vcoldata = marshal.loads(val2) | |
| def | __repr__ |
| def | __setattr__ |
| def | __setitem__ |
| def | __updateRowList |
| def | _getRaw |
| def | beginTransaction |
| def | changedList |
| changedList() | |
| def | checkRowActive |
| def | commitTransaction |
| def | copyFrom |
| def | createIndices |
| self.alterTableToMatch(tbl) | |
| def | createTables |
| schema creation code | |
| def | createTrigger |
| def | createTriggers |
| def | databaseSizeForColumn |
| def | delete |
| def | deleteRow |
| deleteRow(col_match_spec) | |
| def | discard |
| def | dropIndices |
| def | dropTrigger |
| def | fetchAllRows |
| fetchAllRows() | |
| def | fetchRow |
| fetchRow(col_match_spec) | |
| def | fetchRowCount |
| def | fetchRows |
| fetchRows(col_match_spec) | |
| def | fetchRowUsingPrimaryKey |
| def | fillDefaults |
| def | get |
| def | has_key |
| def | inc |
| def | items |
| def | keys |
| def | listFields |
| def | listFieldsDict |
| def | listIndices |
| def | listTables |
| def | listTriggers |
| def | lookup |
| def | lookupCreate |
| def | lookupRows |
| def | newRow |
| def | parseFieldType |
| def | r_deleteRow |
| r_deleteRow(a_row_obj,cursor = None) | |
| def | r_insertRow |
| InsertRow(a_row_obj,cursor = None) | |
| def | r_updateRow |
| r_updateRow(a_row_obj,cursor = None) | |
| def | reflect |
| parse the schema of an existing db and build table objects to reflect the schema. | |
| def | repl_parsePrimaryKey |
| def | rollbackTransaction |
| def | save |
| def | synchronizeSchema |
| def | values |
Variables | |
| __colchanged_dict | |
| __coldata | |
| __vcolchanged | |
| __vcoldata | |
| _inside_getattr | |
| _rowInactive | |
| _should_insert | |
| _should_replace | |
| tuple | all_rows = cursor.fetchall() |
| list | aval = a_row[col_num] |
| int | col_num = 0 |
| tuple | cursor = self.defaultCursor() |
| for name, tbl in self._tables.items(): tbl.db = None | |
| dictionary | data_dict = {} |
| bug out is the user justs want the raw rows | |
| int | DEBUG = 0 |
| kInteger = "kInteger" # - kFixedString = "kFixedString" # size kVarString = "kVarString" # maxsize kBigString = "kBigString" # - kIncInteger = "kIncInteger" # - kDateTime = "kDateTime" kTimeStamp = "kTimeStamp" kReal = "kReal" | |
| tuple | kBigString = _ODB_BigString() |
| tuple | kBlob = _ODB_Blob() |
| tuple | kCreatedStamp = _ODB_CreatedStamp() |
| tuple | kCreatedStampMS = _ODB_CreatedStampMS() |
| tuple | kDateTime = _ODB_DateTime() |
| tuple | kEnumeration = _ODB_Enumeration() |
| tuple | kFixedPoint = ODB_FixedPoint() |
| tuple | kFixedString = _ODB_FixedString() |
| tuple | kGUID = _ODB_GUID() |
| tuple | kIncInteger = _ODB_IncInteger() |
| tuple | kInteger = _ODB_Integer() |
| tuple | kModifiedStamp = _ODB_ModifiedStamp() |
| tuple | kReal = _ODB_Real() |
| tuple | kTimeStamp = _ODB_TimeStamp() |
| tuple | kVarString = _ODB_VarString() |
| list | name = parts[1] |
| tuple | newrowobj = self.__defaultRowClass(self,data_dict,joined_cols = joined_cols) |
| tuple | parts = string.split(fullname, ".", 1) |
| tuple | return_rows = self.__defaultRowListClass() |
| string | sql = " LIMIT %s OFFSET %s " |
| log("limit,skip = %s,%s" % (limit_to,skip_to)) | |
| list | table = parts[0] |
| def pyclearsilver.odb.__del__ | ( | ) |
| def pyclearsilver.odb.__deleteRow | ( | self, | |
| a_row, | |||
cursor = None |
|||
| ) | [private] |
| def pyclearsilver.odb.__delitem__ | ( | self, | |
| key, | |||
| data | |||
| ) |
| def pyclearsilver.odb.__getattr__ | ( | ) |
| def pyclearsilver::odb::__getitem__ | ( | self, | |
| tblname | |||
| ) |
| def pyclearsilver.odb.__insertRow | ( | self, | |
| a_row_obj, | |||
cursor = None, |
|||
replace = 0 |
|||
| ) | [private] |
| def pyclearsilver.odb.__len__ | ( | self | ) |
| def pyclearsilver.odb.__packVColumn | ( | self | ) | [private] |
| def pyclearsilver.odb.__repr__ | ( | self | ) |
| def pyclearsilver.odb.__setattr__ | ( | self, | |
| key, | |||
| val | |||
| ) |
| def pyclearsilver.odb.__setitem__ | ( | self, | |
| key, | |||
| data | |||
| ) |
| def pyclearsilver.odb.__updateRowList | ( | self, | |
| a_row_list, | |||
cursor = None |
|||
| ) | [private] |
| def pyclearsilver.odb._getRaw | ( | self, | |
| key, | |||
convert = 1 |
|||
| ) | [private] |
| def pyclearsilver.odb.beginTransaction | ( | self, | |
cursor = None |
|||
| ) |
| def pyclearsilver.odb.changedList | ( | self | ) |
returns a list of tuples for the columns which have changed
changedList() -> [ ('name', 'fred'), ('age', 20) ]
| def pyclearsilver.odb.checkRowActive | ( | self | ) |
| def pyclearsilver.odb.commitTransaction | ( | self, | |
cursor = None |
|||
| ) |
| def pyclearsilver.odb.copyFrom | ( | self, | |
| source | |||
| ) |
| def pyclearsilver.odb.createIndices | ( | self | ) |
| def pyclearsilver.odb.createTables | ( | self | ) |
| def pyclearsilver.odb.createTrigger | ( | self, | |
| triggerName, | |||
| sql, | |||
cursor = None |
|||
| ) |
| def pyclearsilver.odb.createTriggers | ( | self | ) |
| def pyclearsilver.odb.databaseSizeForColumn | ( | self, | |
| key | |||
| ) |
| def pyclearsilver.odb.delete | ( | self, | |
cursor = None |
|||
| ) |
| def pyclearsilver.odb.deleteRow | ( | self, | |
| col_match_spec, | |||
where = None |
|||
| ) |
| def pyclearsilver.odb.discard | ( | self | ) |
| def pyclearsilver.odb.dropIndices | ( | self | ) |
| def pyclearsilver.odb.dropTrigger | ( | self, | |
| triggerName, | |||
cursor = None |
|||
| ) |
| def pyclearsilver.odb.fetchAllRows | ( | self, | |
join2 = None |
|||
| ) |
Ex: a_row_list = tbl.fetchRows( ("order_id", 1) ) a_row_list = tbl.fetchRows( [ ("order_id", 1), ("enterTime", now) ] )
| def pyclearsilver.odb.fetchRow | ( | self, | |
| col_match_spec, | |||
cursor = None, |
|||
join2 = None |
|||
| ) |
| def pyclearsilver.odb.fetchRowCount | ( | self, | |
col_match_spec = None, |
|||
cursor = None, |
|||
where = None |
|||
| ) |
| def pyclearsilver.odb.fetchRows | ( | self, | |
col_match_spec = None, |
|||
cursor = None, |
|||
where = None, |
|||
order_by = None, |
|||
limit_to = None, |
|||
skip_to = None, |
|||
join = None, |
|||
join2 = None, |
|||
column_list = None, |
|||
raw_rows = False |
|||
| ) |
| def pyclearsilver.odb.fetchRowUsingPrimaryKey | ( | self, | |
| args | |||
| ) |
| def pyclearsilver.odb.fillDefaults | ( | self | ) |
| def pyclearsilver.odb.get | ( | self, | |
| key, | |||
default = None |
|||
| ) |
| def pyclearsilver.odb.has_key | ( | self, | |
| key | |||
| ) |
| def pyclearsilver.odb.inc | ( | self, | |
| key, | |||
count = 1 |
|||
| ) |
| def pyclearsilver.odb.items | ( | self | ) |
| def pyclearsilver.odb.keys | ( | self | ) |
| def pyclearsilver.odb.listFields | ( | self, | |
| table_name, | |||
cursor = None |
|||
| ) |
| def pyclearsilver.odb.listFieldsDict | ( | self, | |
| table_name, | |||
cursor = None |
|||
| ) |
| def pyclearsilver.odb.listIndices | ( | self, | |
| tableName, | |||
cursor = None |
|||
| ) |
| def pyclearsilver.odb.listTables | ( | self, | |
cursor = None |
|||
| ) |
| def pyclearsilver.odb.listTriggers | ( | self, | |
cursor = None |
|||
| ) |
| def pyclearsilver.odb.lookup | ( | self, | |
join2 = None, |
|||
| kws | |||
| ) |
| def pyclearsilver.odb.lookupCreate | ( | self, | |
| kws | |||
| ) |
| def pyclearsilver.odb.lookupRows | ( | self, | |
join2 = None, |
|||
| kws | |||
| ) |
| def pyclearsilver.odb.newRow | ( | self, | |
replace = 0, |
|||
save = 0, |
|||
| kws | |||
| ) |
| def pyclearsilver.odb.parseFieldType | ( | dataStr | ) |
| def pyclearsilver.odb.r_deleteRow | ( | self, | |
| a_row_obj, | |||
cursor = None |
|||
| ) |
| def pyclearsilver.odb.r_insertRow | ( | self, | |
| a_row_obj, | |||
cursor = None, |
|||
replace = 0 |
|||
| ) |
| def pyclearsilver.odb.r_updateRow | ( | self, | |
| a_row_obj, | |||
cursor = None |
|||
| ) |
| def pyclearsilver.odb.reflect | ( | self | ) |
| def pyclearsilver.odb.repl_parsePrimaryKey | ( | key | ) |
| def pyclearsilver.odb.rollbackTransaction | ( | self, | |
cursor = None |
|||
| ) |
| def pyclearsilver.odb.save | ( | self, | |
cursor = None |
|||
| ) |
| def pyclearsilver.odb.synchronizeSchema | ( | self | ) |
| def pyclearsilver.odb.values | ( | elf | ) |
| tuple pyclearsilver::odb::all_rows = cursor.fetchall() |
| tuple pyclearsilver::odb::aval = a_row[col_num] |
| int pyclearsilver::odb::col_num = 0 |
| tuple pyclearsilver::odb::cursor = self.defaultCursor() |
for name, tbl in self._tables.items(): tbl.db = None
| dictionary pyclearsilver::odb::data_dict = {} |
| int pyclearsilver::odb::DEBUG = 0 |
| tuple pyclearsilver::odb::kBigString = _ODB_BigString() |
| tuple pyclearsilver::odb::kBlob = _ODB_Blob() |
| tuple pyclearsilver::odb::kDateTime = _ODB_DateTime() |
| tuple pyclearsilver::odb::kGUID = _ODB_GUID() |
| tuple pyclearsilver::odb::kInteger = _ODB_Integer() |
| tuple pyclearsilver::odb::kReal = _ODB_Real() |
| tuple pyclearsilver::odb::kTimeStamp = _ODB_TimeStamp() |
| tuple pyclearsilver::odb::kVarString = _ODB_VarString() |
| list pyclearsilver::odb::name = parts[1] |
| tuple pyclearsilver::odb::newrowobj = self.__defaultRowClass(self,data_dict,joined_cols = joined_cols) |
| tuple pyclearsilver::odb::parts = string.split(fullname, ".", 1) |
| tuple pyclearsilver::odb::return_rows = self.__defaultRowListClass() |
| string pyclearsilver::odb::sql = " LIMIT %s OFFSET %s " |
| list pyclearsilver::odb::table = parts[0] |