$this->
init();
$sql = <<<EOT
INSERT INTO products(name, price, stock, picture, tags, created_at)
VALUES (?, ?, ?, ?, ?, ?)
EOT;
$stmt =
$this->conn->
prepare($sql);
$stmt->
bindValue(1, 'product1'
);
$stmt->
bindValue(2, 12.5
);
$stmt->
bindValue(3, 5, ParameterType::INTEGER
);
$stmt->
bindValue(4,
$res =
$this->
getResourceFromString('mydata'
), ParameterType::BINARY
);
$stmt->
bindValue(5,
['foo', 'bar'
], Types::SIMPLE_ARRAY
);
$stmt->
bindValue(6,
new \
DateTimeImmutable('2022-06-12 11:00:00'
), Types::DATETIME_IMMUTABLE
);
$executeMethod($stmt);
$debug =
$this->debugDataHolder->
getData()['default'
] ??
[];
$this->
assertCount(2,
$debug);
$this->
assertSame($sql,
$debug[1
]['sql'
]);
$this->
assertSame(['product1', 12.5, 5,
$res, 'foo,bar', '2022-06-12 11:00:00'
],
$debug[1
]['params'
]);
$this->
assertSame([ParameterType::STRING, ParameterType::STRING, ParameterType::INTEGER, ParameterType::BINARY, ParameterType::STRING, ParameterType::STRING
],
$debug[1
]['types'
]);
$this->
assertGreaterThan(0,
$debug[1
]['executionMS'
]);
}