Skip to content

Releases: ezSQL/ezsql

5.1.1: update version, removed unrelated methods from ezQuery class to globa…

22 Feb 20:29
Compare
Choose a tag to compare
…l functions only

- added/tested two additional security related functions, `is_traversal` and `sanitize_path` to go along with `clean_string`

minor bc, update docs/doc-blocks, new functions

20 Feb 01:24
Compare
Choose a tag to compare
  • renamed cleanInput to clean_string
  • renamed createCertificate to create_certificate
  • added global get_results to return result sets in different formats
  • added alter, altering shortcuts to modify table columns
  • tests/code coverage updates
  • many docs/doc-blocks corrections

new version, major breacking changes, updated docs/doc-blocks

16 Feb 19:48
Compare
Choose a tag to compare
  • The use of namespace in the global functions ezFunctions.php file.
    Usage of the global functions will require the user to begin a .php file something like:

    use function ezsql\functions\where;
    // Or
    use function ezsql\functions\{
        getInstance,
        selecting,
        inserting,
    };
  • Class properties that was accessible by magic methods get/set, now PSR 1 camelCase.

  • update class libraries and tests to match PSR 1, but still backwards with previous way.

  • Renamed select of ez_mysqli to dbSelect.

  • Renamed class method and behavior of selecting to select.

  • selecting, and new inserting methods, can be called without table name, only the other necessary parameters:

    • The table name with prefix, can be preset/stored with methods tableSetup(name, prefix), or setTable(name), setPrefix(append), if called without presetting, false is returned.
    • This feature will be added to all database CRUD access methods , each method name will have an ing ending added.
  • Removed global functions where table name passed in, use functions as outlined above using preset table names ending with ing.

Updates for PHP 8 compatibility, add GitHub Actions for macOS CI, doc-block fixes/updates

12 Feb 00:09
Compare
Choose a tag to compare
  • some unknown phpunit configuration issue causing macOS CI error, otherwise test passes
  • unable to include Microsoft Sql Server, docker throws:
    Cannot connect to the Docker daemon at unix:https:///var/run/docker.sock. Is the docker daemon running?

Code cleanup, refactor for PHP 8 compatibility, and bug fixes discovered in doing so

08 Feb 18:27
Compare
Choose a tag to compare
  • bug fixes, prior to PHP 8, **@** silenced errors which this library used to return **false** instead, that is not no longer possible with PHP 8
  • Linux and Windows CI tests move to GitHub Actions
  • General code style fixes
  • merged bug fix #199
  • fixed tests in issue #200, and corrections for PR #201

Added features, and bug fixes

27 Apr 02:29
c843017
Compare
Choose a tag to compare
  • merged #183 fixes exhausting memory issue
  • merged #185 where() was not handling additional _OR conditions
  • merged #186 added feature where() conditional grouping()

4.0.9: Merge pull request #180 from dpDesignz/table-joins

02 Feb 13:01
ec214bc
Compare
Choose a tag to compare
fixBug: Conditional Stacked Functions in selecting

4.0.8: Merge pull request #170 from dpDesignz/master

31 Aug 01:43
32d7834
Compare
Choose a tag to compare
continue fixBug: Error when trying to use $db->vardump()

4.0.7: Merge pull request #166 from dpDesignz/master

19 Aug 16:52
7494b92
Compare
Choose a tag to compare
  • bug fix #163
  • added debugOn() and debugOff() methods for simpler way to turn On/Off echoing output for varDump()

4.0.6: Merge pull request #160 from hubaishan/fixpgsql

01 Aug 14:18
b5991bd
Compare
Choose a tag to compare
fixBug: Creating default object from empty value in pgsql