COLUMN_INDEX_PREFIX
COLUMN_INDEX_PREFIX
Prefix for index names which are autmaticly createt from fuman
Microsoft SQL Server via PDO DbLib (best choice for MSSQL)
getDbType(\Fuman_Db_DataType $type) : string
Converts a dataType to the db data-type
\Fuman_Db_DataType | $type |
createTables(\Fuman_Table $table)
{@inheritdoc}
\Fuman_Table | $table |
handleLastInsertId(\Fuman_Table $table) : string
handles `get last insert id`, not all drivers support this
\Fuman_Table | $table |
reorderSequence(string $seqNoColumnName, \Fuman_Table $table, \Fuman_Db_Where|null $constraint = null) : void
Reorders/clean up sequence column in table
string | $seqNoColumnName | |
\Fuman_Table | $table | |
\Fuman_Db_Where|null | $constraint |
getFullTextRankingQuery(string $columnName, array $parsed, \Fuman_Db_Parameters $parameters) : string
Gets the fulltext search query
string | $columnName | |
array | $parsed | |
\Fuman_Db_Parameters | $parameters |
equals(\Fuman_Db_Abstract $db) : boolean
Compares database object
\Fuman_Db_Abstract | $db |
sqlJoin() : \Fuman_Db_SqlJoin
Gets a new Fuman_Db_SqlJoin instance
decodeValue(string $value, \Fuman_Db_DataType $dataType) : string
Decodes a database value
string | $value | |
\Fuman_Db_DataType | $dataType |
encodeValue(string $value, \Fuman_Db_DataType $dataType, boolean $quoteValue = true) : string
Encodes a database value
string | $value | |
\Fuman_Db_DataType | $dataType | |
boolean | $quoteValue |
encodeParameters(\Fuman_Db_Parameters $parameters) : array
Encodes a database value
\Fuman_Db_Parameters | $parameters |
createTable(\Fuman_Table $table) : boolean
Creates an table with given blueprint of Fuman_Table {@link Fuman_Table}
\Fuman_Table | $table |
deleteTable(\Fuman_Table $table) : boolean
Deletes an table of {@link Fuman_Table}
\Fuman_Table | $table |
getRecordsBySql(string $sql, array $values = array(), string $recordClass = 'Fuman_Db_Record') : array|array<mixed,\Fuman_Db_Record>
Gets records by sql statement
string | $sql | |
array | $values | |
string | $recordClass |
saveRecord(\Fuman_Db_Record $record) : boolean
Inserts or Updates an Record. Behaviour depends on Fuman_Db_Record::saved
\Fuman_Db_Record | $record |
deleteRecord(\Fuman_Db_Record $record, \Fuman_Db_Where|null $where = null) : boolean
Deletes an record
\Fuman_Db_Record | $record | |
\Fuman_Db_Where|null | $where |
deleteRecords(\Fuman_Table $table, \Fuman_Db_Where $where) : integer
Returns the count of the affected rows
\Fuman_Table | $table | |
\Fuman_Db_Where | $where |
getColumnSQL(\Fuman_Table $table, \Fuman_Db_Parameters $parameters, \Fuman_Db_Query_ColumnList $columnList = null, null|string $tableName = null, boolean $ignoreSQLColumns = false) : string
Creates column sql
\Fuman_Table | $table | |
\Fuman_Db_Parameters | $parameters | |
\Fuman_Db_Query_ColumnList | $columnList | |
null|string | $tableName | |
boolean | $ignoreSQLColumns |
getRecordSet(\Fuman_Table $table, \Fuman_Db_RecordSetMeta $meta, string|null $recordClass = null) : \Fuman_Db_RecordSet
Get records from table base on meta
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta | $meta | |
string|null | $recordClass |
getSelectSqlQuery(\Fuman_Table $table, \Fuman_Db_RecordSetMeta $meta, \Fuman_Db_Parameters $parameters) : string
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta | $meta | |
\Fuman_Db_Parameters | $parameters |
getSelectSql(string $sql, \Fuman_Table $table, \Fuman_Db_RecordSetMeta $meta, \Fuman_Db_Parameters $parameters) : string
Gets the sql query
string | $sql | |
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta | $meta | |
\Fuman_Db_Parameters | $parameters |
getRecordsSetBySelectSql(string $sql, \Fuman_Table $table, \Fuman_Db_RecordSetMeta|null $meta = null, \Fuman_Db_Parameters|null $parameters = null, string|null $recordClass = null) : \Fuman_Db_RecordSet
Gets records set using an sql statement (WHERE and ORDER BY will be added automatically)
string | $sql | |
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta|null | $meta | |
\Fuman_Db_Parameters|null | $parameters | |
string|null | $recordClass |
getRecordSetBySql(string $sql, \Fuman_Table $table, \Fuman_Db_RecordSetMeta|null $meta = null, \Fuman_Db_Parameters|null $parameters = null, string|null $recordClass = null) : \Fuman_Db_RecordSet
Gets records set using an sql statement
string | $sql | |
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta|null | $meta | |
\Fuman_Db_Parameters|null | $parameters | |
string|null | $recordClass |
getCountSqlQuery(\Fuman_Table $table, \Fuman_Db_RecordSetMeta $meta, \Fuman_Db_Parameters $parameters) : string
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta | $meta | |
\Fuman_Db_Parameters | $parameters |
countRecords(\Fuman_Table $table, \Fuman_Db_RecordSetMeta $meta) : integer
Counts records
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta | $meta |
getRecordIndexOf(\Fuman_Table $table, \Fuman_Db_Record $record, \Fuman_Db_RecordSetMeta $meta) : integer
Gets index/position of record in record set
\Fuman_Table | $table | |
\Fuman_Db_Record | $record | |
\Fuman_Db_RecordSetMeta | $meta |
synchronizeSearchIndex(\Fuman_Table $table, \stdClass $state) : boolean
Synchronize/update search index
\Fuman_Table | $table | |
\stdClass | $state |
logQuery(string $sql, \Fuman_Db_Parameters|array|null $parameters = null, \Fuman_Table|null $table = null) : void
Fills the placeholders and writes sql to Fuman_Util_Logger::debug
string | $sql | |
\Fuman_Db_Parameters|array|null | $parameters | @ishacky |
\Fuman_Table|null | $table |
_addLimit(string $sql, \Fuman_Table $table, \Fuman_Db_RecordSetMeta $meta) : string
Adds limit statement to query
string | $sql | |
\Fuman_Table | $table | |
\Fuman_Db_RecordSetMeta | $meta |
_checkReadOnly(string $command, \Fuman_Table $table) : boolean
Checks if read only flag on table
Adds error message if read only Returns true if table is read only
string | $command | |
\Fuman_Table | $table |
_insertRecord(\Fuman_Db_Record $record) : boolean
Inserts a record
\Fuman_Db_Record | $record |
_executeInsertRecord(string $sql, array|\Fuman_Db_Parameters $parameters, \Fuman_Db_Record $record) : boolean
Called by _insertRecord (MS SQL must extend query to get lastInsertId
string | $sql | |
array|\Fuman_Db_Parameters | $parameters | @ishacky |
\Fuman_Db_Record | $record |
_updateRecord(\Fuman_Db_Record $record) : boolean
Updates a record
\Fuman_Db_Record | $record |
_getSearchIndexStat(\Fuman_Table $table, \Fuman_Table|null $dataTable = null, integer|null $minValue = null, integer|null $maxValue = null) : \stdClass|null
Statistic helper for search index
Object: stat_min (min id) stat_max (max id) stat_count stat_sum (sum(id)) stat_sumpow (sum(pow(id,2)))
\Fuman_Table | $table | |
\Fuman_Table|null | $dataTable | |
integer|null | $minValue | |
integer|null | $maxValue |
_getFullTextRankingLikeQuery(string $columnName, array $parsed, \Fuman_Db_Parameters $parameters) : string
Gets the fulltext search query only based on LIKE
string | $columnName | |
array | $parsed | |
\Fuman_Db_Parameters | $parameters |
_getFullTextRankingLikeQueryPart(string $columnName, string $value, \Fuman_Db_Parameters $parameters) : string
Gets the fulltext search query LIKE part
string | $columnName | |
string | $value | |
\Fuman_Db_Parameters | $parameters |
_checkForMaxResultWarning(\PDOStatement $statement, array $values, string $functionName) : void
Checks if the given statement has more than self::WARN_MAX_RESULTS rows. If true, an error message will be written.
\PDOStatement | $statement | |
array | $values | |
string | $functionName |