Commit graph

38 commits

Author SHA1 Message Date
Jan Böhmer
e223078af9 Added a custom function to make PostgresSQL searches case insensitive
This is required only for postgres as every other database is case invariant by default. But to achieve a portable way, we implement it via a custom DQL function.

This fixes issue #784
2024-12-02 00:17:54 +01:00
Jan Böhmer
235d572f8c Use DatetimeImmutable instead of DateTime wherever possible 2024-06-22 17:36:54 +02:00
Jan Böhmer
8c45a40f9e Explicitly configure some deprecated configuration options 2024-06-19 23:47:38 +02:00
Jan Böhmer
0a482da93e Use postgres native array_position function instead of our FIELD function and pass it as array literal instead of variadic function
Otherwise we will run into errors, that we can not give more than 100 arguments to a function
2024-06-17 23:13:04 +02:00
Jan Böhmer
9db822eabd Use natural sorting for string datatables columns when using postgres
The natural sorting solution is quite portable, so this should be possible for other database types too later
2024-06-17 21:38:16 +02:00
Jan Böhmer
6e9b337b49 Fixed regex function for postgres 2024-06-13 23:18:25 +02:00
Jan Böhmer
c58ff5861d Replaced the non standard IFNULL function which postgres does not know with the COALSCE function 2024-06-13 23:01:53 +02:00
Jan Böhmer
971bb92a8c Fixed error caused by ArrayType fields which is required by the webauthn bundle but was removed in doctrine/orm 4.0
We simple forward port the ArrayType class from orm 3.8 to fix this error
2024-06-10 21:11:11 +02:00
Jan Böhmer
1911c62edd Upgraded DAMA doctrine test bundle 2023-12-03 23:58:19 +01:00
Jan Böhmer
abc554c7b8 Updated doctrine recipe 2023-12-03 22:44:55 +01:00
Jan Böhmer
62b1e33616 Fixed field ordering on SQLite 2023-07-29 16:42:27 +02:00
Jan Böhmer
d3ead8742e Implement a special field2 function, to migitiate the argument count limit in sqlite
This fixes issue #332 on SQLite DBs
2023-07-26 23:23:25 +02:00
Jan Böhmer
a4d411656b Added a field extension for SQLite and let the database sort the elements by the given ID order directly 2023-07-23 01:19:48 +02:00
Jan Böhmer
affed459df Updated recipe of doctrine/doctrine-bundle 2023-06-11 13:49:21 +02:00
Jan Böhmer
7191ece7a5 Configure doctrine to use attributes instead of annotations 2023-05-28 01:55:30 +02:00
Jan Böhmer
1a3f0675bf Updated doctrine bundle recipe 2023-05-27 20:51:05 +02:00
Jan Böhmer
342ed382e3 Properly mark the tinyint column with a comment, so that migrations can properly detect that no changes are needed 2023-04-09 00:04:13 +02:00
Jan Böhmer
c75cdecbe8 Upgraded doctrine-bundle recipe 2023-02-11 22:27:51 +01:00
Jan Böhmer
f62937096f Moved doctrine custom type definitions to Doctrine\Types namespace 2022-12-31 18:42:56 +01:00
Jan Böhmer
f8aee65d9e Simplified the available permissions 2022-10-31 21:13:27 +01:00
Jan Böhmer
687ee80255 Save permissions as JSON in user/group entities. 2022-10-30 21:51:24 +01:00
Jan Böhmer
8f94a58c71 Allow to order and filter by the amount sum of parts. 2022-09-04 03:37:54 +02:00
Jan Böhmer
f3680ea7de Parse markdown using stimulus controller. 2022-03-06 14:54:08 +01:00
Jan Böhmer
08267b88b0 Use BigDecimal object type for Supplier shipping costs, instead of bcmath string. 2020-05-18 22:07:09 +02:00
Jan Böhmer
86ee10e582 Search options now working. Added Regex search. 2020-03-08 13:05:53 +01:00
Jan Böhmer
d5f018a738 Added an database migration to improve the log schema. 2020-01-26 20:27:37 +01:00
Jan Böhmer
64cf8097bc Updated doctrine recipes. 2020-01-07 18:48:34 +01:00
Jan Böhmer
311a342634 Fixed deprecation caused by datatype declaration. 2020-01-01 18:19:40 +01:00
Jan Böhmer
9c22149afd Let doctrine detect its driver and db_version automatically. 2019-11-23 18:01:45 +01:00
Jan Böhmer
1ae905ae78 Use number aware naming strategy for doctrine.
Fixes a deprecation notice.
2019-11-23 17:48:24 +01:00
Jan Böhmer
01da705b54 Collect backtrace for each doctrine query. 2019-09-18 17:53:48 +02:00
Jan Böhmer
c94d3cdc68 Explicitly set that our utc datetypes does not need an comment
This fixes an deprecation warning.
2019-09-17 14:02:30 +02:00
Jan Böhmer
d2bae3a4f2 Use the users timezone for showing dates from the database.
In the database the values are now saved in UTC.
2019-09-12 22:16:33 +02:00
Jan Böhmer
0ec73618ac Set the correct database version, otherwise we get messy migrations. 2019-09-02 14:21:40 +02:00
Jan Böhmer
2f39ac90a2 Added migration from old Database to new database. 2019-08-06 13:18:29 +02:00
Jan Böhmer
42c8222e35 Protect internal table against the doctrine migration system. 2019-08-03 13:25:49 +02:00
Jan Böhmer
cd4a1470e3 Protect internal table against the doctrine migration system 2019-08-02 16:19:15 +02:00
Jan Böhmer
e5bec36c80 Initial commit 2019-02-23 16:49:38 +01:00