diff options
| author | Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com> | 2024-06-12 11:24:07 +0200 |
|---|---|---|
| committer | Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com> | 2024-06-25 16:21:01 +0200 |
| commit | b7243681dd70b25fdefc9fe62c63bab840691c94 (patch) | |
| tree | 63f38202a09e1d171d5edca207e179f5deb35931 /lib/private/DB | |
| parent | 1e19566aa4fa6f08f01ebad8a7d21ebb0974ae01 (diff) | |
| download | nextcloud-server-b7243681dd70b25fdefc9fe62c63bab840691c94.tar.gz nextcloud-server-b7243681dd70b25fdefc9fe62c63bab840691c94.zip | |
feat(dbal): add proper insert ignore conflict method for SQLite
Signed-off-by: Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com>
Diffstat (limited to 'lib/private/DB')
| -rw-r--r-- | lib/private/DB/AdapterSqlite.php | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/lib/private/DB/AdapterSqlite.php b/lib/private/DB/AdapterSqlite.php index e84f62e8d80..24274cbcda6 100644 --- a/lib/private/DB/AdapterSqlite.php +++ b/lib/private/DB/AdapterSqlite.php @@ -76,4 +76,19 @@ class AdapterSqlite extends Adapter { return 0; } } + + public function insertIgnoreConflict(string $table, array $values): int { + $builder = $this->conn->getQueryBuilder(); + $builder->insert($table); + $updates = []; + foreach ($values as $key => $value) { + $builder->setValue($key, $builder->createNamedParameter($value)); + } + + return $this->conn->executeStatement( + $builder->getSQL() . ' ON CONFLICT DO NOTHING', + $builder->getParameters(), + $builder->getParameterTypes() + ); + } } |