summaryrefslogtreecommitdiff
path: root/it_dbi.class
AgeCommit message (Collapse)AuthorFilesLines
2020-05-06Use random_bytes() instead of uniqid() now that we require PHP 7.0 for itoolsChristian Schneider1-1/+1
2020-04-29Check fields used with NI for NULL first to take advantage of indicesChristian Schneider1-1/+1
2020-04-21accept LIMIT 0Urban Müller1-1/+1
2020-04-21dbi: improve docs, enable LIMIT => falseUrban Müller1-9/+12
2020-04-21support safe LIMITUrban Müller1-0/+4
2020-03-31return deleted ids in delete_untouched for triggersUrban Müller1-3/+3
2020-02-10return 0 for no modified records if query was optimized awayUrban Müller1-3/+3
2019-09-11Fix auto_increment keys where warnings clobber insert_idChristian Schneider1-1/+3
2019-05-16show full sql statement on readback errsUrban Müller1-4/+4
2019-04-18close result in unbuffered mode for multiple unbuffered queriesNathan Gass1-0/+4
2019-02-13Remove migration functions as all old-style usages have been updatedChristian Schneider1-6/+0
2019-02-12Migrate old style constructors to __construct, temporary transition ↵Christian Schneider1-3/+9
functions for it_dbi (map, mapgen) and it_user (ad, login_user)
2018-10-25don't do JSON_EXTRACT when we use SQL functions with dyncolsDavid Flatz1-1/+1
2018-10-08improve tests and stylingDavid Flatz1-2/+4
2018-10-08handle setting a dyncol to null by removing the field in dyncolsDavid Flatz1-4/+14
2018-10-05fix addition of dynamic columns to record where dyncols is NULLDavid Flatz1-2/+2
2018-09-25update single dyncols fields; workaround for mariadb < 10.2.16 no longer neededUrban Müller1-4/+2
2018-08-13disable dyncols in WHERE when we have multiple tables because we can't trust ↵David Flatz1-1/+2
_fields anymore and columns might be prefixed with tablename
2018-08-09iterator should clear dynfields from previous iteration, may be missing in ↵Urban Müller1-0/+3
current one
2018-07-13rewrite dyncols to work around mariadb bug in JSON_SET; add write optimizationUrban Müller1-18/+35
2018-07-10Use a little bit less magic code to replace leading single-quote by json ↵Christian Schneider1-1/+1
path prefix
2018-07-10change storage format of dynamic columns to JSONUrban Müller1-7/+5
2018-06-27reapply "use safer it:: variants of file funcs", was not the culprit in ↵Urban Müller1-2/+2
jussi downtimes This reverts commit 99b7fc8dc08da090bb7f00c2882e1daeec4434ba.
2018-06-22Revert "use safer it:: variants of file funcs"Urban Müller1-2/+2
This reverts commit 05e7ceefa1f0a29c665381b54ac882f260ae6c22.
2018-06-21use safer it:: variants of file funcsUrban Müller1-2/+2
2018-01-29re-enable mysql warningsUrban Müller1-1/+1
2017-12-22disable until code fixedUrban Müller1-1/+1
2017-12-21ignore INSERT IGNOREUrban Müller1-2/+2
2017-12-20better namingUrban Müller1-2/+2
2017-12-20configurable warning suppressionUrban Müller1-1/+2
2017-12-20add query to errsUrban Müller1-1/+1
2017-12-19limit warning count, whitelistUrban Müller1-2/+2
2017-12-19whitelist inserts without defaults for nowUrban Müller1-4/+7
2017-12-19report mysql warningsUrban Müller1-2/+12
2017-11-30use utf8mb4 as default characterset for mysql connectionChristian A. Weber1-1/+1
2017-09-28only select ID for delete_untouched (memory and speed)Nathan Gass1-1/+1
2017-09-26Added update/insert/upsert tracking and delete_untouched() to delete rows ↵Christian Schneider1-2/+18
not touch by one of those functions
2017-08-15permit throttling of database operationsUrban Müller1-1/+4
2017-05-17catch misnamed columns even when setting them to nullUrban Müller1-1/+1
2017-05-17kill forbidden tabsUrban Müller1-6/+6
2017-05-17check for correct case of field namesUrban Müller1-0/+5
2017-04-26Style and dead code cleanupChristian Schneider1-17/+19
2017-04-25extract function _from from select and use it in for update and delete ↵Nathan Gass1-10/+17
statements, this enables JOIN and FROM keys for update and delete
2017-03-08remove comment, upsert should keep state of current iteratorDavid Flatz1-1/+1
2017-03-08combined update/insertUrban Müller1-0/+8
2016-11-22suppress both dyncols and _dyncols from _data; not real valuesUrban Müller1-0/+1
2016-11-10allow dynamic columnsUrban Müller1-5/+24
2016-10-19fix phan warningsUrban Müller1-5/+8
2016-08-10fix utf8 warnings for latin1 selectsNathan Gass1-2/+2
2016-06-21stricter active replication checkUrban Müller1-1/+1