summaryrefslogtreecommitdiff
path: root/it_dbi.class
AgeCommit message (Collapse)AuthorFilesLines
2021-01-06add special handling of numeric keys to _set and _values consistent with _whereNathan Gass1-7/+21
2021-01-06Merge branch 'master' into ng/postgresqlNathan Gass1-26/+5
2021-01-05Remove 11 year old FIXME comment, code has been in use like that long enough :-)Christian Schneider1-1/+1
2021-01-05Remove support for obsolete _read_post_process/_write_pre_process, use ↵Christian Schneider1-24/+0
static _read_postprocess/_write_preprocess instead
2020-11-27log write throttlesUrban Müller1-0/+3
2020-09-03avoid forbidden syntaxNathan Gass1-1/+1
2020-09-03avoid arrow functions as we support php 7.0Nathan Gass1-9/+17
2020-09-03fix indentationNathan Gass1-3/+3
2020-09-03go back to $GLOBALS['it_dbi'] for backward compatibilityNathan Gass1-13/+13
2020-09-03escape uppercase field names for postgresqlNathan Gass1-0/+2
2020-09-03escape ID to avoid postgresql lowercasing itNathan Gass1-1/+1
2020-09-03make sure connection exists for escape_name same as escape_stringNathan Gass1-2/+12
2020-09-02extract mysql specific json code into overridable functionsNathan Gass1-11/+31
2020-09-01allow to add a suffix after INSERT (for ON FOO sql syntax)Nathan Gass1-2/+2
2020-09-01generate postgres compatible where statementsNathan Gass1-2/+2
2020-08-31add _escape_name as backticks are mysql specificNathan Gass1-2/+7
2020-08-31use insert values instead of mysql speficif insert setNathan Gass1-9/+35
2020-08-31use late static binding to enable subclassingNathan Gass1-27/+30
2020-08-28isolate mysql specific codeNathan Gass1-65/+119
2020-08-27use existing tables methodNathan Gass1-2/+1
2020-07-14document current behaviourUrban Müller1-0/+1
2020-07-01Preserve type when writing int to dyncolsChristian Schneider1-1/+3
2020-06-26Register fields added by _read_postprocess() so they get clear()edChristian Schneider1-0/+5
2020-06-26Leave _data unchanged by __read_postprocess as update() needs that and add ↵Christian Schneider1-1/+1
test for it
2020-06-25Streamline _read_postprocess: remove support for unset(), add support to ↵Christian Schneider1-14/+2
postprocess localized fields, conversion of fields (e.g. int fields) is now done after read_postprocess
2020-06-25Call old _read_post_process/_write_pre_process last to preserve old ↵Christian Schneider1-4/+3
semantics as they can have side-effects
2020-06-24Add static and pure replacements _read_postprocess/_write_preprocess for ↵Christian Schneider1-7/+44
deprecated _read_post_process/_write_pre_process
2020-06-02declare static func as suchUrban Müller1-1/+1
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