Doctrine\Tests\DBAL\Functional\Platform\DateExpressionTest::diff()

Complexity

Conditions	1
Paths	1

Size

Total Lines	17
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function diff(string $date1, string $date2, int $expected)
    {
        $table = new Table('date_expr_test');
        $table->addColumn('date1', 'date');
        $table->addColumn('date2', 'date');
        $this->_conn->getSchemaManager()->dropAndCreateTable($table);
        $this->_conn->insert('date_expr_test', [
            'date1' => $date1,
            'date2' => $date2,
        ]);

        $platform = $this->_conn->getDatabasePlatform();

        $sql  = sprintf('SELECT %s FROM date_expr_test', $platform->getDateDiffExpression('date1', 'date2'));
        $diff = $this->_conn->query($sql)->fetchColumn();

        self::assertEquals($expected, $diff);
    }