FreshRSS (Customized)/app/Models/DatabaseDAOPGSQL.php, branch 1.22.0

Chore/processing of depreciations and updating code to php72 minimum (#5504)

2023-07-07T20:36:27+00:00

* processing of depreciations and updating of code to php7.2 minimum * Autoformat many strange array indenting And revert a few unwanted changes --------- Co-authored-by: Luc Co-authored-by: Alexandre Alapetite

PHPStan Level 7 for more DAO PDO (#5328)

2023-04-28T12:01:11+00:00

* PHPStan Level 7 for more DAO PDO With new function to address common type and check problems * A bit more * PHPStan Level 7 for FreshRSS_Entry

PHPStan level 6 for all PDO and Exception classes (#5239)

2023-03-31T06:23:39+00:00

* PHPStan level 6 for all PDO and Exception classes Contributes to https://github.com/FreshRSS/FreshRSS/issues/4112 * Fix type * Now also our remaining own librairies * Motivation for a few more files * A few more DAO classes * Last interface

Fix PostgreSQL size calculation (#4249)

2022-03-03T13:28:17+00:00

Regression from https://github.com/FreshRSS/FreshRSS/pull/3488

Draft:Add interface and add typehinting (#4130)

2022-02-05T10:47:28+00:00

* Add interface and add typehinting * Simplify and complete * inheritdoc Co-authored-by: Luc SANCHEZ Co-authored-by: Alexandre Alapetite

Travis: Enforce phpcs line length + whitespace (#3488)

2021-02-28T11:26:24+00:00

* Update Travis line length * Also check whitespace in CSS files * Fix line length ext.php * More syntax, string templates * Fix exclude-pattern * Test JS files as well

Fix DB optimize for MySQL (#2647)

2019-11-11T18:48:23+00:00

`pdo->exec()` is not appropriate for MySQL `OPTIMIZE` because `OPTIMIZE` returns some data and not only a code and then fails.

Fix PostgreSQL size bug for uppercase (#2631)

2019-11-04T17:13:13+00:00

Crash for users with uppercase letters

Fix PostgreSQL and SQLite DB size estimation (#2562)

2019-10-06T20:17:28+00:00

PDO refactoring for code simplification (#2522)

2019-09-29T14:22:50+00:00

* PDO refactor * Automatic prefix when using the syntax `_tableName` * Uniformity: MySQL is now PDO::ATTR_EMULATE_PREPARES = false just like SQLite and PostgreSQL, with consequences such as only one statement per query * Use PDO methods exec(), query(), prepare() + execute() in a more efficient way * Remove auto-update SQL code for versions older than FreshRSS 1.5 (3 years old) * The name of the default category is set in PHP instead of in the DB (simplies SQL and allows changing the name according to the FreshRSS language) * Rename `->bd` to `->pdo` (less of a frenshism, and more informative) * Fix some requests, which were not compatible with MySQL prepared statements * Whitespace * Fix syntax for PostgreSQL sequences + MySQL install * Minor formatting * Fix lastInsertId for PostgreSQL * Use PHP 5.6+ const Take advantage of https://github.com/FreshRSS/FreshRSS/pull/2527 https://www.php.net/manual/en/migration56.new-features.php * A bit of forgotten PHP 5.6 simplification for cURL * Forgotten $s * Mini fix custom user config https://github.com/FreshRSS/FreshRSS/pull/2490/files#r326290346 * More work on install.php but not finished * install.php working * More cleaning of PDO in install * Even more simplification Take advantage of PDO->exec() to run multiple statements * Disallow changing the name of the default category https://github.com/FreshRSS/FreshRSS/pull/2522#discussion_r326967724