summaryrefslogtreecommitdiff
path: root/test/it_dbi.t
AgeCommit message (Collapse)AuthorFilesLines
2023-02-28adapt escaping of ints and floats to better handle booleans and strings as inputNathan Gass1-4/+7
2023-02-28Revert "special handling of boolean columns (accept false as value without ↵Nathan Gass1-8/+8
warning)" This reverts commit efeb9c4a97668672f8aaa263e4937461f0b1b725.
2023-02-28add tests that old values still work as expectedNathan Gass1-0/+6
2023-02-28special handling of boolean columns (accept false as value without warning)Nathan Gass1-8/+8
2023-01-30Make it_dbi base object iterable, simplify code, add testsChristian Schneider1-0/+8
2023-01-19add urbans testsNathan Gass1-0/+5
2023-01-19some tests to make sure we don't have any wrong conversions from int to floatNathan Gass1-6/+18
2022-10-03Fix it_dbi being used with it::map/iterator_to_arrayChristian Schneider1-0/+4
2021-01-27add some tests for boolean and float columnsNathan Gass1-9/+14
2021-01-26Fix error suppression for safety => 0Christian Schneider1-0/+1
2021-01-25Fix generating errors on SQL syntax errors, add tests for itChristian Schneider1-1/+14
2021-01-18test correct escaping using character that actually needs itUrban Müller1-4/+4
2020-09-03comment out broken testNathan Gass1-2/+3
2020-09-03dont depend on order of resultsNathan Gass1-1/+1
2020-09-03handle postgresql implementation of mysql replaceNathan Gass1-1/+1
2020-09-03use WHERE TRUE in tests which is compatible with postgresqlNathan Gass1-4/+4
2020-09-03escape ID to avoid postgresql lowercasing itNathan Gass1-5/+5
2020-09-03make _set tests independent of exact sql syntaxNathan Gass1-13/+6
2020-09-03add options to run tests on postgressql, adapt create table statements to ↵Nathan Gass1-14/+31
used db, avoid dependency on specific table in db
2020-08-27test for automatic creation of table classesNathan Gass1-0/+1
2020-07-01Simplify test, was under the wrong assumption that is() uses == instead of ===Christian Schneider1-2/+2
2020-07-01Preserve type when writing int to dyncolsChristian Schneider1-0/+2
2020-06-26Leave _data unchanged by __read_postprocess as update() needs that and add ↵Christian Schneider1-4/+13
test for it
2020-06-24Add static and pure replacements _read_postprocess/_write_preprocess for ↵Christian Schneider1-0/+32
deprecated _read_post_process/_write_pre_process
2020-04-21dbi: improve docs, enable LIMIT => falseUrban Müller1-0/+1
2020-04-21Add test for LIMIT with offset, add test descriptionsChristian Schneider1-2/+5
2020-04-21test for safe LIMITUrban Müller1-1/+1
2020-04-21support safe LIMITUrban Müller1-0/+5
2020-04-21use new array syntaxUrban Müller1-64/+64
2020-04-10Fix tests for new semantics of $it_dbi->delete_untouched()Christian Schneider1-5/+5
2018-10-25don't do JSON_EXTRACT when we use SQL functions with dyncolsDavid Flatz1-0/+2
2018-10-08improve tests and stylingDavid Flatz1-1/+2
2018-10-08handle setting a dyncol to null by removing the field in dyncolsDavid Flatz1-0/+8
2018-10-05fix addition of dynamic columns to record where dyncols is NULLDavid Flatz1-0/+5
2018-09-25syntax fixUrban Müller1-1/+1
2018-09-25use created class it_dbi_testUrban Müller1-6/+5
2018-08-13disable dyncols in WHERE when we have multiple tables because we can't trust ↵David Flatz1-0/+4
_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/+11
current one
2018-07-13rewrite dyncols to work around mariadb bug in JSON_SET; add write optimizationUrban Müller1-8/+28
2018-07-10change storage format of dynamic columns to JSONUrban Müller1-7/+8
2018-06-21no reason for different namingUrban Müller1-0/+364