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

0.2.51

What's Changed

• prevent Query error: Incorrect table name '' (1103). by @staabm in #456
• fix fatal error on query reflection with AssignOp operators by @staabm in #450

Full Changelog: 0.2.50...0.2.51

0.2.50

What's Changed

• fixed regression by @staabm in #453

Full Changelog: 0.2.49...0.2.50