0.2.65

What's Changed

• Create QueryReflection lazily to prevent eager creation of a database connection by @staabm in #554

Full Changelog: 0.2.64...0.2.65

0.2.64

What's Changed

• enable phpstan/phpstan-deprecation-rules by @staabm in #544
• handle optional dependencies in build step by @staabm in #545
• fix deprecations by @staabm in #546
• Fix query simulation leading to query error by @staabm in #549
• Fix another query simulation leading to query error by @staabm in #550
• error on from table-name create from function-call by @staabm in #459

Full Changelog: 0.2.63...0.2.64

0.2.63

What's Changed

• Add DoctrineKeyValueStyleRule by @hemberger in #529
• implement REPLACE() inference by @staabm in #539
• extracted DBA_MODE constants by @staabm in #540
• Fix query building with constant assignments by @staabm in #542
• run tests in php 7.2 with lowest by @staabm in #543

Full Changelog: 0.2.62...0.2.63

0.2.62

What's Changed

• Prefer inference-placeholder over taint-escape sql by @staabm in #536
• utilize composer autoloading in tests by @staabm in #537

Full Changelog: 0.2.61...0.2.62

0.2.61

What's Changed

• support sqlftw/sqlftw 0.1.7 by @staabm in #533
• Warn when queries cannot be resolved unexpectedly by @hemberger in #508
• enable rules for project internal analysis by @staabm in #530
• Test PHP 7.2 in github action by @staabm in #523
• Add ECS and apply standard sets by @TomasVotruba in #528

Full Changelog: 0.2.60...0.2.61

0.2.60

What's Changed

• Enable query-alias-test for pdo-mysql by @staabm in #520
• implement if-expression inference by @staabm in #521
• implement case-expression inference by @staabm in #522
• implement sum() inference by @staabm in #524
• Cover count(*) in tests by @staabm in #525
• Cover complex ifnull(max(...)) in tests by @staabm in #526

Full Changelog: 0.2.59...0.2.60

0.2.59

What's Changed

• coalesce() unions only types until the first non-nullable by @staabm in #519
• avg(nullable) can return null. avg(non-nullable) can't return null. by @staabm in #518

Full Changelog: 0.2.58...0.2.59

0.2.58

With this release phpstan-dba added new type narrowing capabilities based on SQL Query AST.
For now this feature needs to be enabled explicitly within your phpstan-dba configuration file:

See examples

$config = new RuntimeConfiguration();
$config->utilizeSqlAst(true);

Requirements:

• PHP 7.4+
• sqlftw/sqlftw need to be installed additionally via composer

What's Changed

• Implement sqlftw/sqlftw sql parser based type narrowing by @staabm in #505
• Fix wrong deprecated annotation by @mitelg in #512
• Stringify types later in the chain. by @staabm in #513

New Contributors

• @mitelg made their first contribution in #512

Full Changelog: 0.2.57...0.2.58

0.2.57

What's Changed

• Allow PHP 7.2 by @TomasVotruba in #511
• Allow placeholder validation for write queries by @hemberger in #506

New Contributors

• @hemberger made their first contribution in #506
• @TomasVotruba made their first contribution in #511

Full Changelog: 0.2.56...0.2.57

0.2.56

Improvements

Write-queries are analyzed by default and no longer executed and rollback'ed. the new logic also works for tables and databases which do not support transactions.

What's Changed

• transform write query into read query by @staabm in #497

Full Changelog: 0.2.55...0.2.56