Skip to content

Latest commit

 

History

History
executable file
·
106 lines (70 loc) · 4.04 KB

CHANGELOG.md

File metadata and controls

executable file
·
106 lines (70 loc) · 4.04 KB

Parable PHP Query

1.0.1

Changes

  • Small static analysis fix.

1.0.0

It's time! Finally a 1.0.0 release, locking the interface in place for at least a while.

Changes

  • Namespace Translator has been renamed to Translators for consistency.
  • Namespace Condition has been renamed to Conditions for consistency.

0.5.0

  • Added static analysis through psalm.
  • Renamed Exception to QueryException for clarity.
  • General php8 code style upgrades.

0.4.0

Changes

  • Dropped support for php7, php8 only from now on.

0.3.2 & 0.3.3

  • Removed unnecessary check whether an update query had an alias.
  • Fixed bug where values that implemented __toString() were not correctly identified as such, and would remain unquoted.
  • Fixed test assert value to be more specific.

0.3.1

Bugfixes

  • buildInsertValues() used the wrong glue to implode value sets.

0.3.0

Changes

  • The SupportsForceIndexTrait trait Query::forceIndex(string $key) and Query::getForceIndex(): ?string have been added, allowing you to force a specific index. Use PRIMARY_KEY_INDEX_VALUE in place of the actual primary key to force the primary key as an index.
  • Query::delete() and Query::update() no longer accept aliases since they caused issues.
  • AbstractCondition::VALUE_TYPE_VALUE and AbstractCondition::VALUE_TYPE_KEY have been removed.
  • Query::ORDER_ASC and Query::ORDER_DESC have been removed.
  • Query::VALID_TYPES has been removed, as it was unused.
  • All string values of AND and OR have been replaced with AbstractCondition::TYPE_AND and AbstractCondition::TYPE_OR.
  • ORDER_ASC and ORDER_DESC have been changed from int values to their corresponding string values ASC and DESC.
  • OrderBy::getDirectionAsString() has turned into OrderBy::getDirection().
  • The BuilderTest now also attempts to run the queries. Adding this step made some issues clear, which are now all fixed.

0.2.1

Changes

  • hasValueSets() was removed but proves useful enough to put back in.
  • Order renamed to OrderBy, can no longer be created without keys being passed.

0.2.0

Changes

  • Query::orderBy() now takes an Order object, rather than string values. Example: ->orderBy(Order::asc('id', 'username')), which will parse to ORDER BY id ASC, username ASC. Use ::desc for descending. You can call it multiple times, so you can do one key ASC, one key DESC, and then another ASC if you want.

    NOTE: Adding a key more than once is possible, but not if they are of different directions.

  • Most places where single-type values were being passed into a method as an array, it now expects the values to be passed as multiple parameters. These methods expect multiple parameters rather than an array:

    • Order::asc(...$keys)
    • Order::desc(...$keys)
    • Query::setColumns(...$columns)
    • Query::groupBy(...$keys)

  • Translators are now type-hinted as TranslatorInterface and all methods on AbstractTranslator have been made protected. This makes it easier to see what functionality is necessary to expose to the outside.

  • Query has gained some quality of life methods: hasWhereConditions(): bool, hasGroupBy(): bool, hasOrderBy(): bool and countValueSets(): int.

  • Query::createCleanClone() has been added, which will return a copy of the query you called it on, with no further configuration whatsoever being retained.

0.1.4

Bugfixes

  • Make sure we never try to quote() a non-string value by string-casting before we hand it over to PDO.

0.1.3

Changes

  • Code style fixes.
  • Fixed typo in exception.

0.1.2

Changes

  • Added hasValueSets() to Query
  • Added hasValues() to ValueSet
  • SupportsValuesTrait now treats null values to mean the value should be NULL-ed. Leaving out the value in the ValueSet values will simply not add it to the values list.

0.1.1

Changes

  • Added whereCondition to Query and onCondition to Join.

Bugfixes

  • Renamed whereCallable in Join to onCallable, as it should've been named in the first place.

0.1.0

Changes

  • First release.