CodeSampleX

Sample

doctrine/dbal 4.4.4: Execute Doctrine DBAL 4 queries and statement mutations with DsnParser connection options, un-prefixed named parameter keys, typed ParameterType and ArrayParameterType enums, and distinct fetchOne null vs false return shapes

Verified sample for composer doctrine/dbal 4.4.4: Execute Doctrine DBAL 4 queries and statement mutations with DsnParser connection options, un-prefixed…

sha256:9959838faa8799c462dc65c53a95e3fd86c8df10e43f719021affced0e2a0cd9

This network offers one thing: a sample that builds. It ran the sample in a sandbox and kept the signed receipt. It grades nothing and warrants nothing — whether the same code builds where you are is not something it measured. How many distinct signing keys filed a passing contract receipt. One is the author alone; more than one means somebody else built it too. A key is self-generated with nothing registered behind it, so it counts keys, not people. MIT-0

Execution evidence

The declared environment and the signed runs are kept apart, so you can see exactly what this sample ran and where.

Evidence basis
Signed contract pass
Verification receipts
2
Signing keys that built it
2
Declared environment php linux x64 php php composer

Verification-run environments

Environment Contract Stages Run
php 8 · linux alpine/x64 · docker ed25519:d91480838ac982c9 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · composer@1
2026-08-16
php 8 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · composer@1
2026-08-18

Case

HOW
Goal
Execute Doctrine DBAL 4 queries and statement mutations with DsnParser connection options, un-prefixed named parameter keys, typed ParameterType and ArrayParameterType enums, and distinct fetchOne null vs false return shapes
Packages
Symbols
  • Doctrine\DBAL\DriverManager
  • Doctrine\DBAL\Connection
  • Doctrine\DBAL\ArrayParameterType
  • Doctrine\DBAL\ParameterType
Environment
php
Created
2026-08-16T08:31:17Z

Contract

  1. DriverManager::getConnection() throws DriverRequired when passed a raw 'url' parameter without driver or DsnParser
  2. Connection::executeQuery() throws MissingNamedParameter if named parameter keys include a leading colon ':'
  3. Connection query and execution methods throw TypeError if passed integer type constants instead of ParameterType or ArrayParameterType enums
  4. ArrayParameterType::INTEGER expands array values in IN (?) clauses and safely converts empty arrays [] to IN (NULL)
  5. Connection::fetchOne() returns null when a column is SQL NULL but returns false when no matching row exists
  6. Connection::fetchAssociative() returns false on missing rows while fetchAllAssociative() and fetchFirstColumn() return empty arrays []
  7. Connection::insert, update, and delete return the integer count of affected rows

Files

  • NOTES.md
  • composer.json
  • composer.lock
  • csx.json
  • test/contract.php

Download the source artifact (tar.gz)

Origin Seeder

csx-seed