stellarwp/schema

What's Changed

• Add support for nested sub-WHERE clauses and update hook naming by @dpanta94 in #49

Full Changelog: 3.1.4...3.2.0

• Feature - Add support for nested sub-WHERE clauses in paginate() and get_total_items() methods. This allows building complex queries like WHERE (col1 = 'a' OR col2 = 'b') AND col3 = 'c'.
• Feature - Add new stellarwp_schema_custom_table_paginate_query filter to allow modification of the paginate query before execution.
• Feature - Add new stellarwp_schema_custom_table_total_items_query filter to allow modification of the total items count query before execution.
• Tweak - Rename hooks from tec_common_* prefix to stellarwp_schema_* prefix for consistency with the StellarWP namespace.

Breaking Changes

The following hooks have been renamed:

• tec_common_custom_table_query_pre_results → stellarwp_schema_custom_table_query_pre_results
• tec_common_custom_table_query_post_results → stellarwp_schema_custom_table_query_post_results
• tec_common_custom_table_query_results → stellarwp_schema_custom_table_query_results
• tec_common_custom_table_query_where → stellarwp_schema_custom_table_query_where

What's Changed

• Fix/ensuring array values can be used by @dpanta94 in #48

Full Changelog: 3.1.3...3.1.4

• Fix - Handle array values correctly in the get_* query methods.

What's Changed

• Properly cache each implementation's schema by @dpanta94 in #47

Full Changelog: 3.1.2...3.1.3

• Fix - get_current_schema method will npw cache the schema of each implementation correctly.

What's Changed

• Fixing error during update evaluation by @dpanta94 in #46

Full Changelog: 3.1.1...3.1.2

• Fix - update_many method will now properly check if the transaction was successful.

What's Changed

• Adding the order by param in the get_all_by method by @dpanta94 in #45

Full Changelog: 3.1.0...3.1.1

• Tweak - Fix the get_all_by method to accept an order by clause.

What's Changed

• Feat/adding more column types by @dpanta94 in #44

Full Changelog: 3.0.0...3.1.0

• Feature - Introduce new column types: Blob_Column, Binary_Column, and Boolean_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.

What's Changed

• feat: Introduce v3 strict column definitions and enhanced type safety by @dpanta94 in #43

Migration docs:

https://github.com/stellarwp/schema/blob/main/docs/migrating-from-v2-to-v3.md

Full Changelog: 2.0.1...3.0.0

• 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.

What's Changed

• Fix - multsite table up by @lucatume in #40

Full Changelog: 2.0.0...2.0.1

• Fix - Avoid dead db in multisite installations with too early checks.

What's Changed

• Bump di52 to 4.0.1 and all other deps by @defunctl in #38. This fixes PHP 8.4 deprecation notices.

Upgrading to 2.0

• To upgrade to 2.x ensure any other libraries using lucatume/di52 are requiring version ^4.0.

Full Changelog: 1.1.9...2.0.0

Feature - Bump di52 to 4.0.1 and all other deps.

What's Changed

• Add throws tags and better generics by @defunctl in #36
• Update CHANGELOG.md for release 1.1.9 by @defunctl in #37

Full Changelog: 1.1.8...1.1.9

• 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.

• Tweak - Set the composer's config.platform.php to 7.0.

• Fix - Resolves some issues with docblocks that didn't pass PHPStan during actual usage of this library elsewhere.

Changed

• Feature - Added stellarwp/db as a dependency.
• Tweak - Swapped out direct $wpdb calls with the DB class.
• Tweak - Reorganized abstract classes and interfaces into Contracts/ directories.
• Tweak - Removed container and require the setting of a container via the Config class.
• Tests - Added some tests for index checking on tables.

Added

• Feature - Initial version
• Docs - Documentation
• Tests - Automated tests