|
@@ 295-314 (lines=20) @@
|
| 292 |
|
* |
| 293 |
|
* @dataProvider dateAddSubProvider |
| 294 |
|
*/ |
| 295 |
|
public function testDateAdd(string $unit, int $amount, int $expectedValue, int $delta = 0) : void |
| 296 |
|
{ |
| 297 |
|
$query = sprintf( |
| 298 |
|
'SELECT CURRENT_TIMESTAMP() as now, DATE_ADD(CURRENT_TIMESTAMP(), %d, \'%s\') AS add FROM %s m', |
| 299 |
|
$amount, |
| 300 |
|
$unit, |
| 301 |
|
CompanyManager::class |
| 302 |
|
); |
| 303 |
|
|
| 304 |
|
$result = $this->_em->createQuery($query) |
| 305 |
|
->setMaxResults(1) |
| 306 |
|
->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
| 307 |
|
|
| 308 |
|
self::assertArrayHasKey('now', $result); |
| 309 |
|
self::assertArrayHasKey('add', $result); |
| 310 |
|
|
| 311 |
|
$diff = strtotime($result['add']) - strtotime($result['now']); |
| 312 |
|
|
| 313 |
|
self::assertEquals($expectedValue, $diff, '', $delta); |
| 314 |
|
} |
| 315 |
|
|
| 316 |
|
/** |
| 317 |
|
* @group DDC-1014 |
|
@@ 322-341 (lines=20) @@
|
| 319 |
|
* |
| 320 |
|
* @dataProvider dateAddSubProvider |
| 321 |
|
*/ |
| 322 |
|
public function testDateSub(string $unit, int $amount, int $expectedValue, int $delta = 0) : void |
| 323 |
|
{ |
| 324 |
|
$query = sprintf( |
| 325 |
|
'SELECT CURRENT_TIMESTAMP() as now, DATE_SUB(CURRENT_TIMESTAMP(), %d, \'%s\') AS sub FROM %s m', |
| 326 |
|
$amount, |
| 327 |
|
$unit, |
| 328 |
|
CompanyManager::class |
| 329 |
|
); |
| 330 |
|
|
| 331 |
|
$result = $this->_em->createQuery($query) |
| 332 |
|
->setMaxResults(1) |
| 333 |
|
->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
| 334 |
|
|
| 335 |
|
self::assertArrayHasKey('now', $result); |
| 336 |
|
self::assertArrayHasKey('sub', $result); |
| 337 |
|
|
| 338 |
|
$diff = strtotime($result['now']) - strtotime($result['sub']); |
| 339 |
|
|
| 340 |
|
self::assertEquals($expectedValue, $diff, '', $delta); |
| 341 |
|
} |
| 342 |
|
|
| 343 |
|
public function dateAddSubProvider() : array |
| 344 |
|
{ |
doctrine /
orm
