Skip to content
This repository was archived by the owner on May 11, 2021. It is now read-only.

Releases: atk4/dsql

1.1.0

08 Mar 09:53
Compare
Choose a tag to compare

This version now officially supports PHP 7.1, as well as adding
optional dependency for SQL formatter (credit to
jdorn). When running
getDebugQuery(true) you'll be getting a well formatted and
justified SQL query.

If after upgrading to 1.1.* branch your application complains
about missing class "SqlFormatter", then your autoloader is
not configured correctly and as a work-around you would need to:

composer require jdorn/sql-formatter

1.0.10

08 Mar 09:38
Compare
Choose a tag to compare
release

1.0.9

08 Mar 09:39
Compare
Choose a tag to compare
releasiing

1.0.8

25 Jul 22:58
Compare
Choose a tag to compare

Calling $dsql->set('foo', 4)->set('foo', 10); now works differently.
It used to record "foo=10" in insert/update record, but now it will
simply add both statement. With MySQL at least the first value is
used.

Calling set() multiple times should behave similarly how adding
multiple conditions on the same field. It's not up to DSQL to
select which value to use.

  • Field in set() can now be an expression
  • Improved formatting a bit

1.0.6

18 Jul 22:27
Compare
Choose a tag to compare
  • Fix problem when more than 28 parameters are specified
  • Permit use of JOIN and table alias in MySQL update
  • Better var_dump() results (more concise info, show proper query)

1.0.5

15 Jul 22:30
Compare
Choose a tag to compare
  • added transaction support
  • made getDebugQuery() use false by default
  • Style Improvement

1.0.4

05 Jul 09:35
Compare
Choose a tag to compare
  • added getDebugQuery(false) which will output in TEXT instead of HTML
  • bugfixes

1.0.3

05 Jul 09:35
Compare
Choose a tag to compare
  • fix critical bug preventing from passing float as parameters

1.0.2

28 Jun 16:09
Compare
Choose a tag to compare

Minor cleanups and improvements to code coverage

  • improve __toString() handling, will not attempt to catch exception

1.0.1

23 Jun 11:59
Compare
Choose a tag to compare

This is now our first stable release. It features clean-ups from 1.0.0:

  • selectTemplate() is replaced with mode()
  • upadted docs to use $c->query() instead of "new Query()" (better use pattern)
  • added examples for having()
  • added method reset()
  • added method option()
  • Expressionable now receives parent $expression as argument
  • documented orExpr(), andExpr()
  • documented template_* properties
  • improved PSR compatibility
  • escapeChar is dropped (too generic)
  • introduced softEscape and made escape more strict
  • improved and cleaned up documentation
  • updated REDAME highlighting our USP