Qore PgsqlSqlUtil Module Reference  1.3
PgsqlSqlUtil::PgsqlTable Member List

This is the complete list of members for PgsqlSqlUtil::PgsqlTable, including all inherited members.

addCheckConstraint(string cname, string src, *hash opt, *reference< string > sql)SqlUtil::AbstractTable
addColumn(string cname, hash opt, bool nullable=True, *reference lsql)SqlUtil::AbstractTable
addCustomCopOperator(string name, hash operator)SqlUtil::AbstractTable
addForeignConstraint(string cname, softlist cols, string table, *softlist tcols, *hash opt, *reference< string > sql)SqlUtil::AbstractTable
addIndex(string iname, bool unique, softlist cols, *hash opt, *reference< string > sql)SqlUtil::AbstractTable
AdditionalColumnDescOptionsSqlUtil::AbstractTable
addPrimaryKey(string pkname, softlist cols, *hash opt, *reference< string > sql)SqlUtil::AbstractTable
addTrigger(string tname, string src, *hash opt, *reference lsql)SqlUtil::AbstractTable
addUniqueConstraint(string cname, softlist cols, *hash opt, *reference< string > sql)SqlUtil::AbstractTable
AlignTableOptionsSqlUtil::AbstractTable
asteriskRequiresPrefix()SqlUtil::AbstractTableprivate
bindEmptyStringsAsNull()SqlUtil::AbstractTable
cache(*hash opts)SqlUtil::AbstractTable
CacheOptionsSqlUtil::AbstractTable
checkExistence()SqlUtil::AbstractTable
clear()SqlUtil::AbstractTable
clearImpl()PgsqlSqlUtil::PgsqlTableprivate
ColumnDescOptionsSqlUtil::AbstractTable
ColumnOptionsSqlUtil::AbstractTable
columnsSqlUtil::AbstractTableprivate
commit()SqlUtil::AbstractTable
ConstraintOptionsSqlUtil::AbstractTable
constraintsSqlUtil::AbstractTableprivate
constraintsLinkedToIndexesImpl()PgsqlSqlUtil::PgsqlTableprivatevirtual
SqlUtil::AbstractSqlUtilBase::constructor(AbstractDatasource nds, *hash nopts)SqlUtil::AbstractSqlUtilBaseprivate
copy(AbstractTable old)SqlUtil::AbstractTable
copyImpl(AbstractTable old)PgsqlSqlUtil::PgsqlTableprivate
SqlUtil::AbstractTable::copyImpl(AbstractTable old)SqlUtil::AbstractTableprivatepure virtual
create(*hash opt)SqlUtil::AbstractTable
createCommit(*hash opt)SqlUtil::AbstractTable
createNoCommit(*hash opt)SqlUtil::AbstractTable
del(hash cond, reference< string > sql, hash opt)SqlUtil::AbstractTable
del(hash cond, hash opt)SqlUtil::AbstractTable
del(hash cond, reference< string > sql)SqlUtil::AbstractTable
del(hash cond)SqlUtil::AbstractTable
del()SqlUtil::AbstractTable
delCommit(hash cond, reference< string > sql, hash opt)SqlUtil::AbstractTable
delCommit(hash cond, hash opt)SqlUtil::AbstractTable
delCommit(hash cond, reference< string > sql)SqlUtil::AbstractTable
delCommit(hash cond)SqlUtil::AbstractTable
delCommit()SqlUtil::AbstractTable
delNoCommit(*hash cond, *reference< string > sql)SqlUtil::AbstractTable
describe()SqlUtil::AbstractTable
doSelectLimitOnlyUnlockedImpl(reference< string > sql, reference< list > args, *hash qh)PgsqlSqlUtil::PgsqlTableprivatevirtual
doSelectOrderByWithOffsetSqlUnlockedImpl(reference< string > sql, reference< list > args, *hash qh, *hash jch, *hash ch, *hash psch, list coll)PgsqlSqlUtil::PgsqlTableprivatevirtual
drop(*hash opt)SqlUtil::AbstractTable
dropColumn(string cname, *reference lsql)SqlUtil::AbstractTable
dropCommit(*hash opt)SqlUtil::AbstractTable
dropConstraint(string cname, *reference< string > sql)SqlUtil::AbstractTable
dropForeignConstraint(string cname, *reference< string > sql)SqlUtil::AbstractTable
dropIndex(string iname, *reference< string > sql)SqlUtil::AbstractTable
dropNoCommit(*hash opt)SqlUtil::AbstractTable
dropPrimaryKey(*reference lsql)SqlUtil::AbstractTable
dropTrigger(string tname, *reference< string > sql)SqlUtil::AbstractTable
dsSqlUtil::AbstractSqlUtilBaseprivate
dsdescSqlUtil::AbstractSqlUtilBaseprivate
empty()SqlUtil::AbstractTable
emptyData()SqlUtil::AbstractTable
find(auto id)SqlUtil::AbstractTable
find(list ids)SqlUtil::AbstractTable
find(hash row)SqlUtil::AbstractTable
findAll(*hash cond)SqlUtil::AbstractTable
findSingle(*hash cond)SqlUtil::AbstractTable
findUniqueConstraint(string name)SqlUtil::AbstractTable
ForeignConstraintOptionsSqlUtil::AbstractTable
foreignConstraintsSqlUtil::AbstractTableprivate
getAddCheckConstraintSql(string cname, string src, *hash copt, *hash opt)SqlUtil::AbstractTable
getAddColumnSql(string cname, hash copt, bool nullable=True, *hash opt)SqlUtil::AbstractTable
getAddForeignConstraintSql(string cname, softlist cols, string table, *softlist tcols, *hash fkopt, *hash opt)SqlUtil::AbstractTable
getAddIndexSql(string iname, bool unique, softlist cols, *hash ixopt, *hash opt)SqlUtil::AbstractTable
getAddPrimaryKeySql(string pkname, softlist cols, *hash pkopt, *hash opt)SqlUtil::AbstractTable
getAddTriggerSql(string tname, string src, *hash topt, *hash opt)SqlUtil::AbstractTable
getAddUniqueConstraintSql(string cname, softlist cols, *hash ukopt, *hash opt)SqlUtil::AbstractTable
getAlignSql(AbstractTable t, *hash opt)SqlUtil::AbstractTable
getAlignSqlString(AbstractTable t, *hash opt)SqlUtil::AbstractTable
getBaseType()SqlUtil::AbstractTable
getBulkUpsertClosure(hash example_row, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
getCacheOptions()SqlUtil::AbstractTableprivate
getColumnOperatorMap()SqlUtil::AbstractTableprivate
getColumnOperatorMapImpl()PgsqlSqlUtil::PgsqlTableprivate
getColumnOptions()SqlUtil::AbstractTableprivate
getColumnSqlName(string col)SqlUtil::AbstractTable
getColumnSqlNames(softlist cols)SqlUtil::AbstractTable
getConstraints()SqlUtil::AbstractTable
getCreateConstraintsSql(*hash opt, bool cache=True)SqlUtil::AbstractTable
getCreateForeignConstraintsSql(*hash opt, bool cache=True)SqlUtil::AbstractTable
getCreateIndexesSql(*hash opt, bool cache=True)SqlUtil::AbstractTable
getCreateMiscSql(*hash opt, bool cache=True)SqlUtil::AbstractTable
getCreatePrimaryKeySql(*hash opt, bool cache=True)SqlUtil::AbstractTable
getCreateSql(*hash opt)SqlUtil::AbstractTable
getCreateSqlImpl(list l)PgsqlSqlUtil::PgsqlTableprivate
getCreateSqlString(*hash opt)SqlUtil::AbstractTable
getCreateTableSql(*hash opt)SqlUtil::AbstractTable
getCreateTableSqlImpl(*hash opt)PgsqlSqlUtil::PgsqlTableprivate
getCreateTriggersSql(*hash opt, bool cache=True)SqlUtil::AbstractTable
getDatasource()SqlUtil::AbstractSqlUtilBase
getDatasourceDesc()SqlUtil::AbstractSqlUtilBase
getDesc()SqlUtil::AbstractTable
getDriverName()SqlUtil::AbstractSqlUtilBase
getDropAllConstraintsAndIndexesOnColumnSql(string cname, *hash opt)SqlUtil::AbstractTable
getDropColumnSql(string cname, *hash opt)SqlUtil::AbstractTable
getDropConstraintIfExistsSql(string cname, *hash opt, *reference< AbstractConstraint > cref)SqlUtil::AbstractTable
getDropConstraintSql(string cname, *hash opt)SqlUtil::AbstractTable
getDropIndexSql(string iname, *hash opt)SqlUtil::AbstractTable
getDropPrimaryKeySql(*hash opt)SqlUtil::AbstractTable
getDropSql(*hash opt)SqlUtil::AbstractTable
getDropTriggerSql(string tname, *hash opt)SqlUtil::AbstractTable
getForeignConstraintOptions()SqlUtil::AbstractTableprivate
getForeignConstraints(*hash opt)SqlUtil::AbstractTable
getIndexes()SqlUtil::AbstractTable
getInsertFromIteratorOptions()SqlUtil::AbstractTableprivate
getInsertOperatorMap()PgsqlSqlUtil::PgsqlTableprivate
getInsertOptions()SqlUtil::AbstractTableprivate
getModifyColumnSql(string cname, hash copt, bool nullable=True, *hash opt)SqlUtil::AbstractTable
getName()SqlUtil::AbstractTable
getPrimaryKey()SqlUtil::AbstractTable
getPseudoColumnHash()SqlUtil::AbstractTableprivate
getRawUpdateOperatorMap()PgsqlSqlUtil::PgsqlTableprivate
getRenameColumnSql(string old_name, string new_name, *hash opt)SqlUtil::AbstractTable
getRenameSql(string new_name, *hash opt)SqlUtil::AbstractTable
getRowIterator(*hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
getRowIterator(*hash sh, *hash opt)SqlUtil::AbstractTable
getRowIteratorNoExec(*hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
getSchemaName()PgsqlSqlUtil::PgsqlTable
getSelectOptions()SqlUtil::AbstractTableprivate
getSelectSql(*hash sh, *reference< list > args)SqlUtil::AbstractTable
getSqlDataCallbackOptions()SqlUtil::AbstractTableprivate
getSqlFromList(list l)SqlUtil::AbstractTable
getSqlName()PgsqlSqlUtil::PgsqlTable
getSqlValue(auto v)SqlUtil::AbstractTable
getSqlValueImpl(auto v)PgsqlSqlUtil::PgsqlTableprivatevirtual
getStatement(*hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
getStatement(*hash sh, *hash opt)SqlUtil::AbstractTable
getStatementNoExec(*hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
getStatementNoExec(*hash sh, *hash opt)SqlUtil::AbstractTable
getTableColumnDescOptions()SqlUtil::AbstractTableprivate
getTableOptions()SqlUtil::AbstractTableprivate
getTablespaceName()PgsqlSqlUtil::PgsqlTable
getTriggerOptions()SqlUtil::AbstractTableprivate
getTriggers()SqlUtil::AbstractTable
getTruncateSql(*hash opt)SqlUtil::AbstractTable
getUniqueConstraintIterator()SqlUtil::AbstractTable
getUpdateOperatorMap()SqlUtil::AbstractTableprivate
getUpsertClosure(hash row, int upsert_strategy=UpsertAuto, *hash opt)SqlUtil::AbstractTable
getUpsertClosureWithValidation(hash example_row, int upsert_strategy=UpsertAuto, *hash opt)SqlUtil::AbstractTable
getUpsertOptions()SqlUtil::AbstractTableprivate
getWhereOperatorMap()SqlUtil::AbstractTableprivate
hasArrayBind()PgsqlSqlUtil::PgsqlTablevirtual
hasReturning()SqlUtil::AbstractTable
hasReturningImpl()SqlUtil::AbstractTableprivate
inDbSqlUtil::AbstractTableprivate
inDb()SqlUtil::AbstractTable
indexesSqlUtil::AbstractTableprivate
IndexOptionsSqlUtil::AbstractTable
insert(hash row)SqlUtil::AbstractTable
insert(hash row, reference< string > sql)SqlUtil::AbstractTable
insert(hash row, hash opt)SqlUtil::AbstractTable
insert(hash row, reference< string > sql, hash opt)SqlUtil::AbstractTable
insertCommit(hash row)SqlUtil::AbstractTable
insertCommit(hash row, reference< string > sql)SqlUtil::AbstractTable
insertCommit(hash row, hash opt)SqlUtil::AbstractTable
insertCommit(hash row, reference< string > sql, hash opt)SqlUtil::AbstractTable
insertFromIterator(Qore::AbstractIterator i, *hash opt)SqlUtil::AbstractTable
insertFromIteratorCommit(Qore::AbstractIterator i, *hash opt)SqlUtil::AbstractTable
insertFromIteratorNoCommit(Qore::AbstractIterator i, *hash opt)SqlUtil::AbstractTable
InsertFromIteratorOptionsSqlUtil::AbstractTable
insertFromSelect(list cols, AbstractTable source, hash sh, reference< string > sql, hash opt)SqlUtil::AbstractTable
insertFromSelect(list cols, AbstractTable source)SqlUtil::AbstractTable
insertFromSelect(list cols, AbstractTable source, hash sh)SqlUtil::AbstractTable
insertFromSelect(list cols, AbstractTable source, hash sh, reference< string > sql)SqlUtil::AbstractTable
insertFromSelect(list cols, AbstractTable source, hash sh, hash opt)SqlUtil::AbstractTable
insertFromSelectCommit(list cols, AbstractTable source, hash sh, reference< string > sql, hash opt)SqlUtil::AbstractTable
insertFromSelectCommit(list cols, AbstractTable source)SqlUtil::AbstractTable
insertFromSelectCommit(list cols, AbstractTable source, hash sh)SqlUtil::AbstractTable
insertFromSelectCommit(list cols, AbstractTable source, hash sh, reference< string > sql)SqlUtil::AbstractTable
insertFromSelectCommit(list cols, AbstractTable source, hash sh, hash opt)SqlUtil::AbstractTable
insertFromSelectNoCommit(list cols, AbstractTable source, *hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
insertNoCommit(hash row, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
insertNoCommit(hash row, hash opt)SqlUtil::AbstractTable
InsertOptionsSqlUtil::AbstractTable
l()SqlUtil::AbstractSqlUtilBaseprivate
manualSqlUtil::AbstractTableprivate
modifyColumn(string cname, hash opt, bool nullable=True, *reference lsql)SqlUtil::AbstractTable
nameSqlUtil::AbstractTableprivate
native_caseSqlUtil::AbstractTableprivate
optsSqlUtil::AbstractSqlUtilBaseprivate
PgsqlCopMapPgsqlSqlUtil::PgsqlTable
PgsqlIopMapPgsqlSqlUtil::PgsqlTable
PgsqlNameMapPgsqlSqlUtil::PgsqlTable
PgsqlTableDescriptionHashOptionsPgsqlSqlUtil::PgsqlTable
PgsqlTruncDatePgsqlSqlUtil::PgsqlTable
PgsqlTypeMapPgsqlSqlUtil::PgsqlTable
PgsqlUopMapPgsqlSqlUtil::PgsqlTable
primaryKeySqlUtil::AbstractTableprivate
QoreTypeMapPgsqlSqlUtil::PgsqlTable
removeForeignConstraint(string cname)SqlUtil::AbstractTable
rename(string new_name, *reference< string > sql, *Tables table_cache)SqlUtil::AbstractTable
renameColumn(string old_name, string new_name, reference< string > sql)SqlUtil::AbstractTable
renameConstraint(string old_name, string new_name, reference lsql)SqlUtil::AbstractTable
renameIndex(string old_name, string new_name, reference< string > sql)SqlUtil::AbstractTable
rollback()SqlUtil::AbstractTable
rowCount()SqlUtil::AbstractTable
schemaPgsqlSqlUtil::PgsqlTableprivate
select(*hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
select(*hash sh, *hash opt)SqlUtil::AbstractTable
SelectOptionsSqlUtil::AbstractTable
selectRow(*hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
selectRow(*hash sh, *hash opt)SqlUtil::AbstractTable
selectRows(*hash sh, *reference< string > sql, *hash opt)SqlUtil::AbstractTable
selectRows(*hash sh, *hash opt)SqlUtil::AbstractTable
setDatasource(AbstractDatasource nds)SqlUtil::AbstractTable
setupTable(hash desc, *hash opt)SqlUtil::AbstractTable
SqlDataCallbackOptionsSqlUtil::AbstractTable
supportsTablespacesImpl()PgsqlSqlUtil::PgsqlTableprivatevirtual
TableCreationOptionsSqlUtil::AbstractTable
TableDescriptionHashOptionsSqlUtil::AbstractTable
TableOmissionOptionsSqlUtil::AbstractTable
TableOptionsSqlUtil::AbstractTable
tablespacePgsqlSqlUtil::PgsqlTableprivate
triggerFunctionsPgsqlSqlUtil::PgsqlTableprivate
TriggerOptionsSqlUtil::AbstractTable
triggersSqlUtil::AbstractTableprivate
truncate()SqlUtil::AbstractTable
truncateCommit()SqlUtil::AbstractTable
truncateNoCommit()SqlUtil::AbstractTable
tryExec(string sql)SqlUtil::AbstractTable
tryExecArgs(string sql, *softlist args)SqlUtil::AbstractTable
tryExecArgsImpl(string sql, *softlist args)PgsqlSqlUtil::PgsqlTableprivate
tryExecRaw(string sql)SqlUtil::AbstractTable
tryExecRawImpl(string sql, *softlist args)PgsqlSqlUtil::PgsqlTableprivate
SqlUtil::AbstractTable::tryExecRawImpl(string sql)SqlUtil::AbstractTableprivate
uniqueIndexCreatesConstraintImpl()PgsqlSqlUtil::PgsqlTableprivatevirtual
update(hash set, hash cond, reference< string > sql, hash opt)SqlUtil::AbstractTable
update(hash set, hash cond, reference< string > sql)SqlUtil::AbstractTable
update(hash set, hash cond, hash opt)SqlUtil::AbstractTable
update(hash set, hash cond)SqlUtil::AbstractTable
update(hash set)SqlUtil::AbstractTable
updateCommit(hash set, hash cond, reference< string > sql, hash opt)SqlUtil::AbstractTable
updateCommit(hash set, hash cond, reference< string > sql)SqlUtil::AbstractTable
updateCommit(hash set, hash cond, hash opt)SqlUtil::AbstractTable
updateCommit(hash set, hash cond)SqlUtil::AbstractTable
updateCommit(hash set)SqlUtil::AbstractTable
updateNoCommit(hash set, *hash cond, *reference< string > sql)SqlUtil::AbstractTable
updateNoCommit(hash set, *hash cond, *hash opt)SqlUtil::AbstractTable
upsert(hash row, int upsert_strategy=UpsertAuto, *hash opt)SqlUtil::AbstractTable
UpsertAutoSqlUtil::AbstractTable
upsertCommit(hash row, int upsert_strategy=UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromIterator(Qore::AbstractIterator i, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromIteratorCommit(Qore::AbstractIterator i, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromIteratorNoCommit(Qore::AbstractIterator i, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromSelect(AbstractTable t, *hash sh, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromSelect(Table t, *hash sh, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromSelectCommit(AbstractTable t, *hash sh, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromSelectCommit(Table t, *hash sh, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromSelectNoCommit(AbstractTable t, *hash sh, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
upsertFromSelectNoCommit(Table t, *hash sh, int upsert_strategy=AbstractTable::UpsertAuto, *hash opt)SqlUtil::AbstractTable
UpsertInsertFirstSqlUtil::AbstractTable
UpsertInsertOnlySqlUtil::AbstractTable
upsertNoCommit(hash row, int upsert_strategy=UpsertAuto)SqlUtil::AbstractTable
UpsertOptionsSqlUtil::AbstractTable
UpsertResultDescriptionMapSqlUtil::AbstractTable
UpsertResultLetterMapSqlUtil::AbstractTable
UpsertResultMapSqlUtil::AbstractTable
UpsertSelectFirstSqlUtil::AbstractTable
UpsertStrategyDescriptionMapSqlUtil::AbstractTable
UpsertStrategyMapSqlUtil::AbstractTable
UpsertUpdateFirstSqlUtil::AbstractTable
UpsertUpdateOnlySqlUtil::AbstractTable
UR_DeletedSqlUtil::AbstractTable
UR_InsertedSqlUtil::AbstractTable
UR_UnchangedSqlUtil::AbstractTable
UR_UpdatedSqlUtil::AbstractTable
UR_VerifiedSqlUtil::AbstractTable
validateColumnOptions(string cname, reference< hash > opt, bool nullable)SqlUtil::AbstractTableprivate
validateHashKeysForWhitespaces(auto node)SqlUtil::AbstractSqlUtilBaseprivate