History for src/include/lib/Garradin/DB.php

2023-10-14
20:05
Renamed to src/include/lib/Paheko/DB.php. Merge dev into trunk check-in: [f06bcbc973] user: bohwaz, branch: trunk, size: 0
2023-07-21
13:28
Renamed to src/include/lib/Paheko/DB.php. Rename everything from Garradin to Paheko check-in: [736b20220e] user: bohwaz, branch: dev, size: 0
2023-07-14
14:11
Implement migration for reservations/bookings file: [389bc96636] check-in: [90f68eb1e3] user: bohwaz, branch: dev, size: 11756 [annotate] [blame] [check-ins using] [diff]
2023-07-06
02:27
Use specific tables to link transactions and users to files, as joining on LIKE is just too slow file: [1bc6dc70f0] check-in: [d6ad927e5a] user: bohwaz, branch: dev, size: 11701 [annotate] [blame] [check-ins using] [diff]
2023-07-04
22:53
Add md5 function in SQL file: [b8de5a923f] check-in: [424361d9f9] user: bohwaz, branch: dev, size: 11408 [annotate] [blame] [check-ins using] [diff]
2023-05-11
21:16
Change whitespaces to tabs file: [6485b16b18] check-in: [6b7b7a4fd4] user: bohwaz, branch: dev, size: 11371 [annotate] [blame] [check-ins using] [diff]
2023-03-11
19:24
Merge trunk into dev file: [8826d5d1a7] check-in: [5134a286ff] user: bohwaz, branch: dev, size: 13870 [annotate] [blame] [check-ins using] [diff]
2023-03-01
23:34
Handle case where LIKE doesn't work anymore file: [b153f0e4eb] check-in: [21a41ae385] user: bohwaz, branch: trunk, size: 12975 [annotate] [blame] [check-ins using] [diff]
21:48
Fix search to use unicode LIKE, fix [555d13cb7087c709830813d0a518e767072c88bb] file: [35620b75cc] check-in: [9766c1623b] user: bohwaz, branch: dev, size: 13341 [annotate] [blame] [check-ins using] [diff]
2023-02-27
23:14
Fix Unicode LIKE to correctly handle _ and % characters file: [b4bbb0ebf2] check-in: [00c271c482] user: bohwaz, branch: trunk, size: 12949 [annotate] [blame] [check-ins using] [diff]
2023-01-13
16:30
Merge trunk changes file: [56869016fb] check-in: [4e559e8fb6] user: bohwaz, branch: dev, size: 12948 [annotate] [blame] [check-ins using] [diff]
2023-01-05
19:47
Use TRUNCATE as default journal mode for SQLite to be safe, but recommend WAL file: [937dc0e057] check-in: [27fae968f7] user: bohwaz, branch: trunk, size: 12446 [annotate] [blame] [check-ins using] [diff]
2023-01-02
17:49
Allow to set SQLite journal mode, and detect OVH hosting, so that WAL is disabled on OVH to avoid corruption issues file: [187570815e] check-in: [593cc029a8] user: bohwaz, branch: trunk, size: 12442 [annotate] [blame] [check-ins using] [diff]
2022-10-26
02:12
Only apply journal_mode if necessary, this gains about 4-5 ms on every page! file: [0ab3ecee7f] check-in: [c84ca4b90a] user: bohwaz, branch: dev, size: 12785 [annotate] [blame] [check-ins using] [diff]
2022-09-13
19:14
Add DB_OPEN_SQL constant file: [c379aac3c9] check-in: [b38c094aba] user: bohwaz, branch: dev, size: 12728 [annotate] [blame] [check-ins using] [diff]
2022-08-26
20:33
Refactor/rename Emails to use Smartyer templates for email content file: [cf2da7e9fc] check-in: [f10ad977cd] user: bohwaz, branch: dev, size: 12652 [annotate] [blame] [check-ins using] [diff]
2022-08-07
01:53
DB: Avoid conflicts on schema updates, and throw exception if foreign keys cannot be disabled file: [4800ed1936] check-in: [14c4520225] user: bohwaz, branch: dev, size: 12631 [annotate] [blame] [check-ins using] [diff]
2022-06-27
23:21
Merge trunk into dev file: [5aab2bab44] check-in: [8e3dffbfb1] user: bohwaz, branch: dev, size: 12224 [annotate] [blame] [check-ins using] [diff]
2022-06-20
18:42
Fix PHP 8.1 warning with null value file: [e7b3d0adf7] check-in: [475924850e] user: bohwaz, branch: trunk, size: 12121 [annotate] [blame] [check-ins using] [diff]
2022-06-07
16:12
Change services list to a dynamic list, so that we can order the list file: [3cf7637a9e] check-in: [fb19d55ba5] user: bohwaz, branch: trunk, size: 12032 [annotate] [blame] [check-ins using] [diff]
2022-06-03
18:58
Merge latest trunk/emails to dev file: [aed5d26533] check-in: [42f4f0980c] user: bohwaz, branch: dev, size: 11796 [annotate] [blame] [check-ins using] [diff]
2022-05-13
17:03
Display email status in user details file: [cb00319b74] check-in: [750ce5c9a6] user: bohwaz, branch: emails, size: 11693 [annotate] [blame] [check-ins using] [diff]
2022-03-11
02:04
Upgrade new user form file: [8b5989552e] check-in: [2591fb802e] user: bohwaz, branch: dev, size: 11711 [annotate] [blame] [check-ins using] [diff]
2022-03-10
19:37
Merge trunk changes file: [48056982fc] check-in: [e72b734527] user: bohwaz, branch: dev, size: 11628 [annotate] [blame] [check-ins using] [diff]
2022-03-05
00:28
Fix issues with french apostrophes in user search file: [0e139875a3] check-in: [79a2d31f0d] user: bohwaz, branch: trunk, size: 11608 [annotate] [blame] [check-ins using] [diff]
2022-03-04
23:44
Fix Unicode LIKE in SQLite to be able to match accents file: [f9346ac0ca] check-in: [a8c911229a] user: bohwaz, branch: trunk, size: 11453 [annotate] [blame] [check-ins using] [diff]
2022-02-16
23:07
Add a config constant to enable SQL queries debug to track slow queries file: [b474eeed4f] check-in: [d500eccadc] user: bohwaz, branch: trunk, size: 11454 [annotate] [blame] [check-ins using] [diff]
2022-02-11
14:57
Merge with trunk file: [1adef257c6] check-in: [a2054097bc] user: bohwaz, branch: dev, size: 7354 [annotate] [blame] [check-ins using] [diff]
2022-01-28
01:13
Fix database reset file: [4e240a6ef3] check-in: [6844b8190e] user: bohwaz, branch: trunk, size: 7334 [annotate] [blame] [check-ins using] [diff]
2022-01-12
00:57
Use a transliterated duplicate table, not a FTS4 table, as it would not resolve the issue of ordering unicode names file: [effc6bd097] check-in: [a419cfbfe5] user: bohwaz, branch: dev, size: 7298 [annotate] [blame] [check-ins using] [diff]
00:11
Rename custom unicode collation to U_NOCASE, don't replace the native NOCASE collation as it can lead to index errors and malformed database file: [9f8f9d6d3b] check-in: [5cd6df6ced] user: bohwaz, branch: trunk, size: 7278 [annotate] [blame] [check-ins using] [diff]
2022-01-10
12:43
Merge with trunk file: [9094fbc33a] check-in: [ea0c0a5981] user: bohwaz, branch: dev, size: 7288 [annotate] [blame] [check-ins using] [diff]
2022-01-07
00:41
Fix bug in LIKE function: _ meta characted was not parsed correctly file: [1adcbf8a97] check-in: [a947f59eaf] user: bohwaz, branch: trunk, size: 7276 [annotate] [blame] [check-ins using] [diff]
2022-01-02
18:29
Remove LIKE and NOCASE hacks, use a function and a copied table instead to search in users file: [b936d9dff2] check-in: [a8eb440e42] user: bohwaz, branch: dev, size: 7274 [annotate] [blame] [check-ins using] [diff]
2021-12-30
13:40
Fix upgrade from 1.0.x, thanks @ddgallo file: [1efae1a655] check-in: [1b89de7a68] user: bohwaz, branch: trunk, size: 7262 [annotate] [blame] [check-ins using] [diff]
2021-10-10
14:47
Make sure we are connected file: [f878c985d1] check-in: [1fe6b88e3d] user: bohwaz, branch: trunk, size: 7085 [annotate] [blame] [check-ins using] [diff]
2021-09-16
16:32
Fix [c2d24575a84954ef0718e35e64f1e9ff67be4c5c] search in multiline fields failed file: [ba3c284bd4] check-in: [495331c9bf] user: bohwaz, branch: trunk, size: 7058 [annotate] [blame] [check-ins using] [diff]
2021-07-24
15:03
Fix LIKE handling to be correct for "begins with" and "ends with" LIKEs, see [28fc79a800036f41] file: [0f64109cbd] check-in: [e214118d85] user: bohwaz, branch: trunk, size: 7057 [annotate] [blame] [check-ins using] [diff]
2021-06-01
21:34
Fix backup restore with custom NOCASE collation, add migration file: [7ce0e3f7d3] check-in: [bbba6082eb] user: bohwaz, branch: trunk, size: 6688 [annotate] [blame] [check-ins using] [diff]
2021-05-22
04:02
Make sure to remove punctuation as well file: [e8db354fd5] check-in: [0b821fce4f] user: bohwaz, branch: trunk, size: 6593 [annotate] [blame] [check-ins using] [diff]
03:58
Fix: bring case-insensitive unicode comparison to LIKE operator in SQLite as it doesn't handle it by default file: [4b3fbe283f] check-in: [d8061fc854] user: bohwaz, branch: trunk, size: 6590 [annotate] [blame] [check-ins using] [diff]
2021-03-30
21:45
Fix collation file: [8dd3841b1b] check-in: [9ecbcbce5c] user: bohwaz, branch: dev, size: 5245 [annotate] [blame] [check-ins using] [diff]
21:21
Fix dirname/basename locale issues file: [f7de57d793] check-in: [3dd4c3e1c4] user: bohwaz, branch: dev, size: 5632 [annotate] [blame] [check-ins using] [diff]
2021-03-14
16:25
Replace SQLite NOCASE collation with custom unicode case-insensitive collation file: [d0ee50b78a] check-in: [005d502877] user: bohwaz, branch: dev, size: 5600 [annotate] [blame] [check-ins using] [diff]
2021-03-13
13:52
Add parent column to files table, fix web page sync file: [b1d1bcbcbe] check-in: [046420ec1f] user: bohwaz, branch: dev, size: 5231 [annotate] [blame] [check-ins using] [diff]
2021-03-10
23:38
Search in documents (not yet transactions nor user files) file: [782415d211] check-in: [e0a8822c94] user: bohwaz, branch: dev, size: 5172 [annotate] [blame] [check-ins using] [diff]
2021-03-02
19:09
Fix version fetch in backup management file: [d35485e300] check-in: [859c815d86] user: bohwaz, branch: dev, size: 5115 [annotate] [blame] [check-ins using] [diff]
2021-02-05
02:19
Ready for alpha1, maybe file: [0fbc5c09f2] check-in: [bae8f80e3c] user: bohwaz, branch: dev, size: 5051 [annotate] [blame] [check-ins using] [diff]
2021-01-28
18:33
Refactor user categories file: [24f55fe516] check-in: [a9a60352ba] user: bohwaz, branch: dev, size: 4329 [annotate] [blame] [check-ins using] [diff]
16:08
Store version in user_version pragma now file: [8fdc67bb4a] check-in: [ddc306861e] user: bohwaz, branch: dev, size: 4130 [annotate] [blame] [check-ins using] [diff]
2021-01-13
02:58
Move modifiers to a separate file file: [98b21aac12] check-in: [6a04aa967f] user: bohwaz, branch: dev, size: 2270 [annotate] [blame] [check-ins using] [diff]
2020-11-12
23:30
Improve SQLite performance file: [dad60ad267] check-in: [44ec7357a9] user: bohwaz, branch: dev, size: 2180 [annotate] [blame] [check-ins using] [diff]
2020-10-24
20:44
Fix install issues file: [7aa040ef50] check-in: [fbf65537ea] user: bohwaz, branch: dev, size: 1919 [annotate] [blame] [check-ins using] [diff]
2020-04-21
23:16
Fix upgrade file: [9be1dc4464] check-in: [c9d0003024] user: bohwaz, branch: dev, size: 2115 [annotate] [blame] [check-ins using] [diff]
2020-01-20
00:14
Adaptation au nouveau KD2\DB\SQLite3 file: [76f153c2da] check-in: [6ed70e24ff] user: bohwaz, branch: dev, size: 2694 [annotate] [blame] [check-ins using] [diff]
2019-12-17
16:02
Merge avec trunk file: [1f3b4719e4] check-in: [12a00549c1] user: bohwaz, branch: dev, size: 2858 [annotate] [blame] [check-ins using] [diff]
2019-10-10
17:33
Correction procédure mise à jour pour tenir compte des versions récentes de SQLite qui changent le comportement lors de la mise à jour d'une table liée à des clés étrangères file: [b5f765f6ec] check-in: [23a0bc4602] user: bohwaz, branch: trunk, size: 2621 [annotate] [blame] [check-ins using] [diff]
2019-02-14
17:11
Débuts de la màj 0.10.0 file: [ba4dc3d887] check-in: [636b063ed2] user: bohwaz, branch: dev, size: 2519 [annotate] [blame] [check-ins using] [diff]
2019-01-22
10:51
Suppression des undo triggers file: [5b61f7e017] check-in: [c0b5eec9e9] user: bohwaz, branch: dev, size: 2149 [annotate] [blame] [check-ins using] [diff]
2019-01-09
21:14
Undo log des requêtes SQL file: [dadf975219] check-in: [4f901f656b] user: bohwaz, branch: dev, size: 4916 [annotate] [blame] [check-ins using] [diff]
2018-11-16
16:33
Améliorer performances et temps d'attente pour SQLite file: [41264a6c51] check-in: [68844e02d3] user: bohwaz, branch: trunk, size: 2161 [annotate] [blame] [check-ins using] [diff]
2018-10-17
11:14
Vérifions les dépendances dans la mise à jour aussi, au cas où file: [69073dd36f] check-in: [50f325e4d7] user: bohwaz, branch: dev, size: 2022 [annotate] [blame] [check-ins using] [diff]
2018-08-04
00:42
Ajout possibilité de remettre à zéro la base de données (réinstallation en fait) file: [7fa1101431] check-in: [d489756c8e] user: bohwaz, branch: dev, size: 1856 [annotate] [blame] [check-ins using] [diff]
2017-08-03
04:32
Fix: ne pas activer les foreign keys à chaque appel à connect() mais seulement à la connexion file: [1dead0b7c1] check-in: [dddd19cda5] user: bohwaz, branch: dev, size: 1758 [annotate] [blame] [check-ins using] [diff]
04:21
Cohérence avec SQLite3 en ligne de commande: utilisation de .load au lieu de .import file: [527ac0b77d] check-in: [26b4188c11] user: bohwaz, branch: dev, size: 1723 [annotate] [blame] [check-ins using] [diff]
2017-06-30
05:42
Déplacement de la grosse majorité de la logique de DB dans KD2, suppression des méthodes simple* dépréciées file: [ef10557379] check-in: [8cf9568498] user: bohwaz, branch: dev, size: 1727 [annotate] [blame] [check-ins using] [diff]
2017-06-06
00:01
DB: Forcer la fin des transactions en cas de crash du script pour empêcher de crasher la DB file: [e4161210dd] check-in: [0bd6e3acda] user: bohwaz, branch: dev, size: 19844 [annotate] [blame] [check-ins using] [diff]
2017-05-19
07:25
Modernisation compta / changement aussi de la gestion des forms pour faire de l'objet file: [3716397b8d] check-in: [61ac1e5c2a] user: bohwaz, branch: dev, size: 19463 [annotate] [blame] [check-ins using] [diff]
05:46
Modernisation/remise en fonctionnement des fichiers dans le wiki file: [9faaff99f4] check-in: [2db443930d] user: bohwaz, branch: dev, size: 19460 [annotate] [blame] [check-ins using] [diff]
2017-05-17
07:07
Ajout méthode openBlob file: [fec2e78e68] check-in: [2b37df9aad] user: bohwaz, branch: dev, size: 19428 [annotate] [blame] [check-ins using] [diff]
2017-05-16
06:09
DB: Fix legacy compatibility functions file: [d7e2b85339] check-in: [f9c05b3c39] user: bohwaz, branch: dev, size: 19334 [annotate] [blame] [check-ins using] [diff]
2017-05-11
07:04
Stockage des dates en UTC dans Sqlite file: [877e8d23cd] check-in: [024fc1876c] user: bohwaz, branch: dev, size: 19159 [annotate] [blame] [check-ins using] [diff]
2017-05-09
06:58
DB: Ajout méthode close(), et autorisation d'avoir un WHERE vide dans UPDATE file: [f8181ce16e] check-in: [4569a5c086] user: bohwaz, branch: dev, size: 19055 [annotate] [blame] [check-ins using] [diff]
2017-05-08
07:29
Ajout d'une contrainte sur les champs date pour empêcher d'y mettre des trucs qui ne sont pas des dates file: [63d8b000ce] check-in: [51a82e5421] user: bohwaz, branch: dev, size: 18856 [annotate] [blame] [check-ins using] [diff]
2017-05-05
07:35
Amélioration de la vérification de hash pour l'import de DB file: [a155d87551] check-in: [42d8fe5ab5] user: bohwaz, branch: dev, size: 18299 [annotate] [blame] [check-ins using] [diff]
2017-05-04
07:38
Modernisation/corrections du code file: [8264aea346] check-in: [abedb2727c] user: bohwaz, branch: dev, size: 18148 [annotate] [blame] [check-ins using] [diff]
2017-05-03
07:24
Les méthodes de compatibilité antérieure doivent avoir le même comportement qu'avant et ne pas utiliser les générateurs file: [e113f77c7c] check-in: [8a5e92420a] user: bohwaz, branch: dev, size: 18152 [annotate] [blame] [check-ins using] [diff]
2017-05-01
05:45
Modernisation du code file: [411399aa29] check-in: [2eb85374b2] user: bohwaz, branch: dev, size: 18158 [annotate] [blame] [check-ins using] [diff]
04:45
Rendre getArgType public car utilisé dans Squelette file: [e3dd232e5a] check-in: [b82b088636] user: bohwaz, branch: dev, size: 18062 [annotate] [blame] [check-ins using] [diff]
2017-04-27
05:27
Les fonctions get* doivent toujours retourner un tableau file: [f26c99ab91] check-in: [29880c37a5] user: bohwaz, branch: dev, size: 18065 [annotate] [blame] [check-ins using] [diff]
05:10
Améliorations permises par passage à PHP 5.6 file: [ac30598b52] check-in: [653437ae4f] user: bohwaz, branch: dev, size: 17719 [annotate] [blame] [check-ins using] [diff]
2017-03-29
04:48
Ajout documentation dans DB.php et ajout de tests pour la DB file: [9ea38a4c6c] check-in: [8422f038fe] user: bohwaz, branch: dev, size: 17915 [annotate] [blame] [check-ins using] [diff]
2017-03-17
04:50
Correction de quelques bugs dans la gestion de DB file: [7f184d61e2] check-in: [171c9591b4] user: bohwaz, branch: dev, size: 12687 [annotate] [blame] [check-ins using] [diff]
03:47
DB: nouveaux noms de méthodes, utilisation d'objets en retour, simplification, lazy loading, etc. file: [599bdd31e0] check-in: [37e2badee2] user: bohwaz, branch: dev, size: 12485 [annotate] [blame] [check-ins using] [diff]
2017-03-09
04:29
DB: Ajoute la possibilité optionnelle de retourner un résultat sous forme d'objet plutôt que de tableau file: [51ccbaed54] check-in: [a2973bcf60] user: bohwaz, branch: dev, size: 11242 [annotate] [blame] [check-ins using] [diff]
2016-05-31
04:10
Augmenter le timeout en cas de concurrency, car des fois on a des erreurs sur certaines assos file: [b1c44ce023] check-in: [0a88984edf] user: bohwaz, branch: trunk, size: 11293 [annotate] [blame] [check-ins using] [diff]
2015-03-10
04:30
Upload de fichier fonctionnel file: [ce44687ceb] check-in: [9ed4a2c5d0] user: bohwaz, branch: trunk, size: 11148 [annotate] [blame] [check-ins using] [diff]
2015-02-18
19:16
Fonctionnalité rapprochement bancaire file: [7e56a5c401] check-in: [2fe1c3aa3e] user: bohwaz, branch: trunk, size: 10746 [annotate] [blame] [check-ins using] [diff]
2015-01-18
07:03
Optimisation : un seul appel pour savoir le type file: [7406e12909] check-in: [acafe56460] user: bohwaz, branch: trunk, size: 10738 [annotate] [blame] [check-ins using] [diff]
05:16
Forcer le type de bindValue, sinon bindValue(1, 0) ne fonctionne pas correctement (WTF) file: [0be01e7f47] check-in: [bb7d06009b] user: bohwaz, branch: trunk, size: 10713 [annotate] [blame] [check-ins using] [diff]
2014-12-18
19:41
Passage à PSR-0 + Dépendances simplifiées avec KD2fw file: [0b1250347f] check-in: [c39efc2c38] user: bohwaz, branch: trunk, size: 10720 [annotate] [blame] [check-ins using] [diff]
18:41
Renamed src/include/class.db.php → src/include/lib/Garradin/DB.php. Déplacement des objets pour adopter PSR-0 file: [d57aaad273] check-in: [e1d5bc8368] user: bohwaz, branch: trunk, size: 10720 [annotate] [blame] [check-ins using] [diff]