Skip to content

Releases: teqfw/db

Enhanced selection DTO handling and order-by consistency

01 May 12:43

Choose a tag to compare

  • Refactored TeqFw_Db_Shared_Dto_List_Selection: separated class definition from metadata and improved DTO
    initialization via .create().
  • Added TeqFw_Db_Shared_Util_Select utility for composing selection DTOs from basic JS objects with support for
    filtering, sorting, and pagination.
  • Aligned all method signatures in Crud, Repository, and QueryBuilder to accept unified selection objects
    instead of conditions, sorting, and pagination separately.
  • Deprecated createDto() method in selection DTO, use create() instead for consistency.
  • Updated docblocks and type annotations across repository and query interfaces for clarity and correctness.
  • Minor refactorings to improve internal consistency and readability in database-related modules.

Support for `rowsLimit` and `rowsOffset` in selection

31 Mar 11:42

Choose a tag to compare

  • Added support for rowsLimit and rowsOffset parameters in selection queries.

Added `onCommit` and `onRollback` callbacks in TrxWrapper

24 Mar 13:37

Choose a tag to compare

  • Added onCommit and onRollback callbacks in TrxWrapper for handling post-transaction results.
  • Implemented fetchTablesByDependencyOrder in RdbTables and Schema to list tables by dependency order, enhanced date
    item formatting for exports.
  • Corrected export mechanisms in Export to properly handle table dependencies and data types.
  • Enhanced data import processing in Import, including proper sequence restoration and error handling during data
    insertion.
  • Refactored readMany and related methods in Crud and Schema for improved readability and extensibility, added
    selection parameters for data reading operations.

Use Selection in CRUD Base for `readMany`

28 Feb 14:15

Choose a tag to compare

  • Implemented selection functionality in the CRUD base for the readMany operation.

Use operations in `where` clause

27 Feb 05:23

Choose a tag to compare

  • Enhanced the query builder to handle array values in where clauses (e.g., ('id', ['<=', 4]) becomes
    ('id', '<=', 4)).
  • Improve JSDoc in TeqFw_Db_Back_App_Crud.updateOne to prevent IDEA highlights.

Enhanced Database Abstraction, New CRUD Engine, and SQLite Support

19 Jan 11:41

Choose a tag to compare

0.23.0

  • Introduced the TeqFw_Db_Back_Api_RDb_Schema_Object interface, deprecating TeqFw_Db_Back_RDb_Meta_IEntity.
  • Added a new CRUD engine TeqFw_Db_Back_App_Crud.
  • Introduced the transaction wrapper TeqFw_Db_Back_App_TrxWrapper for better transaction management.
  • Added the TeqFw_Db_Back_Api_RDb_Repository interface to define repository operations.
  • Enhanced support for SQLite in the CRUD engine, including better handling of primary keys.
  • Improved unit tests for CRUD operations with detailed scenarios.
  • Updated DEM loading logic to include optional test-specific data for schema initialization.
  • Added utilities for grouping and selecting columns in database queries.

Detect `Client_BetterSQLite3` constructor

10 Oct 10:32

Choose a tag to compare

  • Detect Client_BetterSQLite3 constructor.

Drop/create FK separately from the tables

10 Sep 09:14

Choose a tag to compare

  • Add the selection DTO for listing queries.
  • Add the model to convert the selection DTO to the knex query.
  • Extract the TeqFw_Db_Shared_Enum_Direction enumeration.
  • Fix the error in TeqFw_Db_Back_Cli_Export with the export from missed table.
  • Drop/create FK separately from the tables.
  • Remove the legacy format for depIds

Add the common export/import CLI commands

15 Apr 14:06

Choose a tag to compare

  • Add the common export/import CLI commands.
  • Add the TeqFw_Db_Back_Act_Dem_Tables action.
  • Use platform specific paths separators (win/*nix).
  • The class-based form for the TeqFw_Db_Back_Util.

Knex password and logger

15 Sep 05:24

Choose a tag to compare

  • WF-674 Update knex version in RA
  • WF-677 Add postprocessor chunk for loggers