hazaar/hazaar-dbi
1
0
Fork 0
Code Issues Pull requests Projects Releases 8 Packages Wiki Activity Actions

8 releases 49 tags

RSS feed
  • release-2.3.1 8e6f0c5a76

    Release 2.3.1 Stable

    jamie released this 2021-03-31 01:14:31 +00:00 | 174 commits to master since this release

    This release has the following updates:

    • #68 - Auto set date columns to Y-m-d format
    • #69 - Reading BYTEA columns
    • #71 - Transparent Table/field encryption is broken
    Downloads
  • release-2.3.0 f5e48119cb

    release-2.3.0 Stable

    jamie released this 2020-02-14 03:51:41 +00:00 | 276 commits to master since this release

    This release has the following new features and bug fixes:

    New features:

    • Added support for subquery fields. You can now pass a DBI query ie: Hazaar\DBI\Table objects, as a field and it will be automatically output as a string and aliased.
    • Added support for strict model filters. These filters allow the model to filter out certain fields based on the DBI action being performed.
      • INSERT will filter fields with insert=false.
      • UPDATE will filter fields with update=false.
      • dbi=false will filter fields for both.
    • #44 - Added datasync "keys" attribute. Allows the keys used to identify existing rows to be specified in the data sync files.
    • #45 - Data sync record column macros. Data sync record field values can now contain a simple macro string that looks up data from another table and column. See #45 for details.

    Bug fixes:

    • Inserts that use columns/data from a Hazaar\Model\Strict object will now include hidden fields.
    • Fixed DBI filesystem table definitions.
    • #46 - Fixed data sync of numeric columns.
    Downloads
  • release-2.2.5 3c0a54f7fc

    release-2.2.5 Stable

    jamie released this 2019-12-03 23:45:27 +00:00 | 293 commits to master since this release

    This update brings the following new features and bug fixes.

    New features:

    • Added a $json modifier to force values to be output as JSON encoded strings when sending to the database. Normally this is automatic if the value is an object (such as stdClass) but can now be forced if, for example, you need to JSON encode an array.

    Bug fixes:

    • Updated SQL compliant with regard to expression != BOOLEAN search criteria. Internally, != is converted to <> which when used with a boolean won't work.
    Downloads
  • release-2.2.4 bbb884fdae

    release-2.2.4 Stable

    jamie released this 2019-11-26 00:36:02 +00:00 | 295 commits to master since this release

    This update brings the following bug fixes:

    • Fixed column quoting when column value starts with a colon. A single colon will be interpreted as a placeholder for a prepared statement. Previously text such as '::1' would also be handled this way. Now we only look for a single colon.
    • #43 - Fixed select groups not being flushed between queries.
    Downloads
  • release-2.2.3 44a9ab3b3a

    release-2.2.3 Stable

    jamie released this 2019-11-14 01:14:52 +00:00 | 298 commits to master since this release

    This update brings the following new features:

    • Added DBI-FS backend method "touch()". Allows a file modification date to be set.
    • Added support for duplicate column names in alias groups. If you use alias groups, now if a column with the same name exists in each table, the column will be added to the corresponding table group.

    Bug fixes:

    • Fixed all the "continue 2" errors that pop up as of PHP7.3
    • Fixed up the DBI console module to comply with Hazaar MVC 2.5.4
    Downloads
  • release-2.2.2 409572dd30

    release-2.2.2 Stable

    jamie released this 2019-07-11 04:00:20 +00:00 | 308 commits to master since this release

    Urgent new feature for major client:

    • Fixed Hazaar\DBI\Result returning FALSE for empty result on valid query. Functions now return NULL as they did previously. FALSE should only be returned on an error.
    Downloads
  • release-2.2.1 53cd8e8b77

    release-2.2.1 Stable

    jamie released this 2019-05-03 05:13:03 +00:00 | 309 commits to master since this release

    Urgent new feature for major client:

    • DBI data sync function to truncate a table before syncing data back into it.
    Downloads
  • release-2.2.0 3c98507844

    release-2.2.0 Stable

    ghost released this 2019-05-02 00:22:26 +00:00 | 312 commits to master since this release

    This update brings the following new features:

    • Added option to "keep tables" when initialising a database schema
    • Migration replay files now support executing SQL statements.
    • Schema snapshots will now detect changes to columns.

    Bug fixes:

    • listTriggers correctly supports INFORMATION_SCHEMA columns.
    • Fixed exception handling during snapshot/migration in the application console.
    • Fixed data sync feature in migration replay files.
    Downloads