AdapterSqlite¶
-
class
OC\DB\
AdapterSqlite
¶ Source: lib/private/DB/AdapterSqlite.php#32 Parent: OC\DB\Adapter
Methods¶
-
public
OC\DB\AdapterSqlite::
lockTable
($tableName)¶ Source: Parameters: - $tableName (string)
-
public
OC\DB\AdapterSqlite::
unlockTable
()¶ Source: lib/private/DB/AdapterSqlite.php#41
-
public
OC\DB\AdapterSqlite::
fixupStatement
($statement)¶ Source: lib/private/DB/AdapterSqlite.php#45
-
public
OC\DB\AdapterSqlite::
insertIfNotExist
($table, $input, $compare=null)¶ - Insert a row if the matching row does not exists. To accomplish proper race condition avoidanceit is needed that there is also a unique constraint on the values. Then this method willcatch the exception and return 0.
Source: Parameters: - $table (string) The table name (will replace PREFIX with the actual prefix)
- $input (array) data that should be inserted into the table (column name => value)
- $compare (array | null) List of values that should be checked for “if not exists”
If this is null or an empty array, all keys of $input will be compared Please note: text fields (clob) must not be used in the compare array
Returns: int number of inserted rows
Throws: \Doctrine\DBAL\Exception
Deprecated: 15.0.0 - use unique index and “try { $db->insert() } catch (UniqueConstraintViolationException $e) }” instead, because it is more reliable and does not have the risk for deadlocks - see https://github.com/nextcloud/server/pull/12371