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

0.2.55

Improvements

• Support for delete, insert, update, replace by @jakubvojacek, @staabm in #483

Enable it via RuntimeConfiguration:

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

requires transaction support in db schema and db driver

Full Changelog: 0.2.54...0.2.55

0.2.54

Features

• Detect syntax errors in Dibi\Connection::* by @jakubvojacek in #463
• Dibi type inference by @staabm in #468

Improvements

• fix PHPStan 1.9.3 compat by @staabm in #486
• Throw exception in case we are not able to start a transaction by @staabm in #487
• implement DbaApi by @jakubvojacek in #480

What's Changed

• simplify test-suite config by @staabm in #464
• simplify return type extensions by @staabm in #467
• fix github action phpunit annotations by @staabm in #471
• Adds new placeholders by @jakubvojacek in #473
• Fix aggregate functions in dibi::fetchSingle by @jakubvojacek in #478
• test with empty result cache by @staabm in #482
• remove duplicate mysqli_stmt stub definitions by @staabm in #485

Full Changelog: 0.2.53...0.2.54

0.2.53

• fix ReplayAndRecordingQueryReflector to report consistent results with RecordingReflector

Full Changelog: 0.2.52...0.2.53

0.2.52

• work arround PHPStorm integration issues which lead to useless cache-files. phpstan-dba should be run across the whole project

Full Changelog: 0.2.51...0.2.52