History of the file that is called src/include/class.db.php at checkin 9e037ff8543fc30c

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]
2014-11-06
00:45
running_sum via sqlite n'était pas fiable, faisons-le en PHP file: [d57aaad273] check-in: [199862d6c4] user: bohwaz, branch: trunk, size: 10720 [annotate] [blame] [check-ins using] [diff]
2014-04-15
05:12
Gestion un peu plus intelligente des transactions file: [1638255074] check-in: [a172283519] user: bohwaz, branch: trunk, size: 11300 [annotate] [blame] [check-ins using] [diff]
2014-03-26
17:51
Corrections bugs DB et cron file: [366f753ead] check-in: [03918d4368] user: bohwaz, branch: trunk, size: 10637 [annotate] [blame] [check-ins using] [diff]
2014-03-21
03:44
rendre publique ces méthodes bien utiles file: [aedffdc1cb] check-in: [9e037ff854] user: bohwaz, branch: trunk, size: 10574 [annotate] [blame] [check-ins using] [diff]
2014-03-14
18:28
Passage à la syntaxe courte des array() dans PHP 5.4 file: [5025f71f76] check-in: [ee4dfba719] user: bohwaz, branch: trunk, size: 10457 [annotate] [blame] [check-ins using] [diff]
2014-02-12
14:45
Renommage des constantes GARRADIN_* en Garradin\* + support du login local par id ou email file: [70706b161b] check-in: [0f6cbac68b] user: bohwaz, branch: trunk, size: 10492 [annotate] [blame] [check-ins using] [diff]
14:14
Debug des arguments file: [55b4328232] check-in: [dd669f5faa] user: bohwaz, branch: trunk, size: 10501 [annotate] [blame] [check-ins using] [diff]
2014-01-08
17:28
Message d'erreur plus clair file: [b671e9bb0e] check-in: [4e264219a5] user: bohwaz, branch: trunk, size: 10467 [annotate] [blame] [check-ins using] [diff]
2013-10-01
02:26
Merge [464b2f5d24] correction évaluation entrée file: [005fc59201] check-in: [dfb7954c91] user: bohwaz, branch: trunk, size: 10456 [annotate] [blame] [check-ins using] [diff]
02:22
correction évaluation entrée file: [005fc59201] check-in: [464b2f5d24] user: bohwaz, branch: trunk, size: 10456 [annotate] [blame] [check-ins using] [diff]
2013-09-29
11:50
Correction pour les sous-appels de la fonction + suppression bidouille instructions sqlite3 file: [4856b84bc1] check-in: [fc0e512052] user: bohwaz, branch: trunk, size: 10425 [annotate] [blame] [check-ins using] [diff]
11:50
Correction pour les sous-appels de la fonction file: [4856b84bc1] check-in: [c0b53fcbb7] user: bohwaz, branch: trunk, size: 10425 [annotate] [blame] [check-ins using] [diff]
11:46
commiter le débug c'est mal file: [e50e296252] check-in: [37a6bb32bf] user: bohwaz, branch: trunk, size: 10293 [annotate] [blame] [check-ins using] [diff]
11:43
suppression bidouille avec les dates pour sqlite3 file: [6270ff371c] check-in: [187b73615f] user: bohwaz, branch: trunk, size: 10319 [annotate] [blame] [check-ins using] [diff]
11:27
Merges multiples de corrections dans la branche stable file: [5164eaa4a3] check-in: [3d710711d8] user: bohwaz, branch: trunk, size: 10766 [annotate] [blame] [check-ins using] [diff]
11:17
Fix [0d764c31f3b0032f00d8f5b541df8f212fac78f8] : toujours utiliser bindvalue pour les paramètres file: [5164eaa4a3] check-in: [b5d1b8123b] user: bohwaz, branch: trunk, size: 10766 [annotate] [blame] [check-ins using] [diff]
2013-07-27
12:20
Renamed include/class.db.php → src/include/class.db.php. Déplacement du code dans src/ file: [ef3d2d44df] check-in: [5112ee854a] user: bohwaz, branch: trunk, size: 12544 [annotate] [blame] [check-ins using] [diff]
2013-01-31
16:25
Correction de bugs en pagaille pour les champs membres + gestion dynamique des options pour select et multiple file: [ef3d2d44df] check-in: [9dbb21bd78] user: bohwaz, branch: trunk, size: 12544 [annotate] [blame] [check-ins using] [diff]
2012-12-23
03:13
Corrections pour namespaces file: [f7a224e087] check-in: [9c4927d404] user: bohwaz, branch: trunk, size: 12656 [annotate] [blame] [check-ins using] [diff]
2012-12-19
04:43
Utilisation des namespaces file: [92c22689a2] check-in: [9a0053fe6f] user: bohwaz, branch: trunk, size: 12646 [annotate] [blame] [check-ins using] [diff]
2012-10-16
05:57
preg_quote est trop généreux pour ça file: [a844357902] check-in: [463583f6e9] user: bohwaz, branch: trunk, size: 12633 [annotate] [blame] [check-ins using] [diff]
05:51
échapper ce qui va remplacer, sinon les $ sont interprétés forcément file: [9c827c97f3] check-in: [ef9ce8d490] user: bohwaz, branch: trunk, size: 12563 [annotate] [blame] [check-ins using] [diff]
2012-10-15
07:26
Solde cumulé file: [ae27085b95] check-in: [9ffecd790a] user: bohwaz, branch: trunk, size: 12551 [annotate] [blame] [check-ins using] [diff]
02:44
Clôture d'exercice et vérification que les opérations sont bien saisies dans l'exercice en cours. file: [21a2ac801a] check-in: [dcfb1107bd] user: bohwaz, branch: trunk, size: 11966 [annotate] [blame] [check-ins using] [diff]
2012-10-14
21:32
Ajout d'exercice file: [273234dfd7] check-in: [5e530f7499] user: bohwaz, branch: trunk, size: 11956 [annotate] [blame] [check-ins using] [diff]
2012-09-25
04:13
Appel possible à base64 pour trier binaire file: [d9ef2949fc] check-in: [7da1ae62e2] user: bohwaz, branch: trunk, size: 11912 [annotate] [blame] [check-ins using] [diff]
2012-09-04
02:27
Journal général comptable file: [a6d814eeab] check-in: [d990f66f2a] user: bohwaz, branch: trunk, size: 11854 [annotate] [blame] [check-ins using] [diff]
2012-05-20
04:44
Choix de la page parent Affichage des pages enfant sur le wiki file: [dfd3c82df1] check-in: [921e957683] user: bohwaz, branch: trunk, size: 11593 [annotate] [blame] [check-ins using] [diff]
2012-05-17
02:45
Une base de site public fonctionnel file: [acef0ac2c6] check-in: [f3e54a4c1b] user: bohwaz, branch: trunk, size: 11050 [annotate] [blame] [check-ins using] [diff]
2012-05-15
02:28
Boucles de recherche comme SPIP file: [320b4c12bb] check-in: [f1f17270e4] user: bohwaz, branch: trunk, size: 10894 [annotate] [blame] [check-ins using] [diff]
2012-03-11
23:58
Fixed [877f4fc1e7] (liste des adhérents avec un nom accentué) file: [fea644c3be] check-in: [1484069bbe] user: bohwaz, branch: trunk, size: 8594 [annotate] [blame] [check-ins using] [diff]
2012-02-29
21:35
Fix d'un bug qui se produit si un champ a le même préfixe qu'un autre champ

C'est toujours pas idéal comme code, mais c'est mieux que rien file: [c858b8cf7c] check-in: [ab3a68aaa3] user: bohwaz, branch: trunk, size: 8496 [annotate] [blame] [check-ins using] [diff]

2012-01-30
02:49
+ Affichage de page sur le wiki + Débuts de la modification de page de wiki file: [2f2758ec9d] check-in: [87a69406bb] user: bohwaz, branch: trunk, size: 8253 [annotate] [blame] [check-ins using] [diff]
01:25
+ Objet de gestion wiki + Initialisation du wiki à l'installation file: [20862eeeec] check-in: [e67d902412] user: bohwaz, branch: trunk, size: 8098 [annotate] [blame] [check-ins using] [diff]
2012-01-29
18:16
Recherche de membre file: [20aa05353d] check-in: [90554e2c55] user: bohwaz, branch: trunk, size: 7470 [annotate] [blame] [check-ins using] [diff]
2011-12-14
21:17
Liste des catégories file: [e25de4a9c2] check-in: [4a65c22cc7] user: bohwaz, branch: trunk, size: 7367 [annotate] [blame] [check-ins using] [diff]
19:09
Ajout page fiche membre + Mise à jour cotisation Ajout page message (non fonctionnelle) Ajout choix des champs modifiables par les membres Etc. file: [2bb48e7aff] check-in: [c9c83d62d7] user: bohwaz, branch: trunk, size: 7360 [annotate] [blame] [check-ins using] [diff]
2011-12-13
20:18
Modification de membre file: [f2e7266fd1] check-in: [f3956886ca] user: bohwaz, branch: trunk, size: 7364 [annotate] [blame] [check-ins using] [diff]
19:41
Correction pour que simpleStatementFetch* soit fonctionnel file: [7a556aeae3] check-in: [f811c29a1a] user: bohwaz, branch: trunk, size: 6965 [annotate] [blame] [check-ins using] [diff]
2011-12-12
18:18
Gestion plus simple des droits file: [43a2014608] check-in: [2a52f7577e] user: bohwaz, branch: trunk, size: 6699 [annotate] [blame] [check-ins using] [diff]
04:13
+ mini design de base + correction bug fetchresult + on évolue dans les droits + récup des droits au login file: [dcfb6370d3] check-in: [0091b53a43] user: bohwaz, branch: trunk, size: 6430 [annotate] [blame] [check-ins using] [diff]
2011-11-22
01:50
Process d'installation fonctionnel ! file: [5931695276] check-in: [813042295e] user: bohwaz, branch: trunk, size: 6418 [annotate] [blame] [check-ins using] [diff]
2011-11-18
03:57
Nouveaux facilitateurs de requête file: [c38158224a] check-in: [1f8df74dab] user: bohwaz, branch: trunk, size: 6165 [annotate] [blame] [check-ins using] [diff]
2011-11-17
03:39
+ Garradin_DB étends SQLite3 + Singleton pour DB et Config + Mise à jour de Config + Débuts de Membres file: [daa789e03c] check-in: [aa141e2493] user: bohwaz, branch: trunk, size: 2424 [annotate] [blame] [check-ins using] [diff]
2011-11-15
18:34
Added: Base des premiers objets Schéma DB file: [58e65c050e] check-in: [4c36ea10e5] user: bohwaz, branch: trunk, size: 482 [annotate] [blame] [check-ins using]