mirror of
https://github.com/FreshRSS/FreshRSS.git
synced 2026-05-20 09:30:36 +00:00
Alexandre Alapetite
aeb55693e4
* New SQL wrapper function `fetchInt()`
* Favour use of `fetchAssoc()`, `fetchInt()`, `fetchColumn()`
* Favour Nowdoc / Heredoc syntax for SQL
* Update indenting to PHP 8.1+ convention
* Favour `bindValue()` instead of position `?` when possible
* Favour `bindValue()` over `bindParam()`
* More uniform and robust syntax when using `bindValue()`, checking return code
19 lines
374 B
PHP
19 lines
374 B
PHP
<?php
|
|
declare(strict_types=1);
|
|
|
|
class FreshRSS_TagDAOPGSQL extends FreshRSS_TagDAO {
|
|
|
|
#[\Override]
|
|
public function sqlIgnore(): string {
|
|
return ''; //TODO
|
|
}
|
|
|
|
#[\Override]
|
|
public function sqlResetSequence(): bool {
|
|
$sql = <<<'SQL'
|
|
SELECT setval('`_tag_id_seq`', COALESCE(MAX(id), 0) + 1, false) FROM `_tag`
|
|
SQL;
|
|
return $this->pdo->exec($sql) !== false;
|
|
}
|
|
}
|