All notable changes to this project will be documented in this file. This project adhere to the Semantic Versioning standard.
3.2.0 2026-01-05
- Feature - Add support for nested sub-WHERE clauses in
paginate()andget_total_items()methods. This allows building complex queries likeWHERE (col1 = 'a' OR col2 = 'b') AND col3 = 'c'. - Feature - Add new
stellarwp_schema_custom_table_paginate_queryfilter to allow modification of the paginate query before execution. - Feature - Add new
stellarwp_schema_custom_table_total_items_queryfilter to allow modification of the total items count query before execution. - Tweak - Rename hooks from
tec_common_*prefix tostellarwp_schema_*prefix for consistency with the StellarWP namespace.
The following hooks have been renamed:
tec_common_custom_table_query_pre_results→stellarwp_schema_custom_table_query_pre_resultstec_common_custom_table_query_post_results→stellarwp_schema_custom_table_query_post_resultstec_common_custom_table_query_results→stellarwp_schema_custom_table_query_resultstec_common_custom_table_query_where→stellarwp_schema_custom_table_query_where
- Fix - Handle array values correctly in the
get_*query methods.
3.1.3 2025-10-08
- Fix -
get_current_schemamethod will npw cache the schema of each implementation correctly.
3.1.2 2025-10-02
- Fix -
update_manymethod will now properly check if the transaction was successful.
3.1.1 2025-10-01
- Tweak - Fix the
get_all_bymethod to accept an order by clause.
3.1.0 2025-09-30
- Feature - Introduce new column types:
Blob_Column,Binary_Column, andBoolean_Column. - Feature - Introduce new PHP type: Blob. Blob will be stored as a base64 encoded string.
- Tweak - Update string based columns to have the ability to become primary keys. Those columns include: char, varchar, binary and varbinary.
3.0.0 2025-09-24
- Feature - Introduces stricter column and indexes definitions. This is NOT a backwards compatible change. Read the migration guide in docs/migrating-from-v2-to-v3.md.
- Fix - Avoid dead db in multisite installations with too early checks.
Feature - Bump di52 to 4.0.1 and all other deps.
- Tweak - Add @throws tags from the stellarwp/db library and better generics.
- Feature - Introduce truncate method which does what the empty_table method was doing. Update empty_table to actually empty the table instead of truncating it.
- Tweak - Decide if we can create/update during this requests based on blog's status, preventing multiple "check" queries.
- Fix -
Collection::get_by_group()now properly works with a single string group name. - Fix -
Group_FilterIterator::count()now properly returns the filtered count and not the base iterator count. - Fix -
Needs_Update_FilterIterator::count()now properly returns the filtered count and not the base iterator count. - Fix - Use proper PSR namespacing for tests.
- Tests - code clean up and file name standardization.
- Feature - Added
Table::has_foreign_key()method.
1.1.2 2022-11-2
- Tweak - Set the composer's
config.platform.phpto7.0.
1.1.1 2022-10-08
- Fix - Resolves some issues with docblocks that didn't pass PHPStan during actual usage of this library elsewhere.
1.1.0 2022-08-30
- Feature - Added stellarwp/db as a dependency.
- Tweak - Swapped out direct
$wpdbcalls with theDBclass. - Tweak - Reorganized abstract classes and interfaces into
Contracts/directories. - Tweak - Removed container and require the setting of a container via the
Configclass. - Tests - Added some tests for index checking on tables.
1.0.0 2022-08-17
- Feature - Initial version
- Docs - Documentation
- Tests - Automated tests