/tests/Query/Mysql/TrigTest.php

<?php

namespace DoctrineExtensions\Tests\Query\Mysql;

class TrigTest extends \DoctrineExtensions\Tests\Query\MysqlTestCase
{
    public function setUp(): void
    {
        parent::setUp();

        $this->entity = 'DoctrineExtensions\Tests\Entities\BlogPost';
    }

    public function testSin()
    {
        $this->_assertFirstQuery('SIN');
        $this->_assertSecondQuery('SIN');

        $dql = "SELECT SIN(RADIANS(p.latitude)) FROM {$this->entity} p";
        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT SIN(RADIANS(b0_.latitude)) AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());

        $dql = "SELECT SIN(p.latitude * p.longitude) FROM {$this->entity} p";
        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT SIN(b0_.latitude * b0_.longitude) AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());

        $dql = "SELECT SIN(RADIANS(p.latitude) * RADIANS(p.longitude)) FROM {$this->entity} p";
        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT SIN(RADIANS(b0_.latitude) * RADIANS(b0_.longitude)) AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());

        if (\Doctrine\ORM\Version::compare('2.4.0') <= 0) {
            $dql = "SELECT p FROM {$this->entity} p WHERE p.longitude = SIN(RADIANS(p.latitude)) * RADIANS(p.longitude)";
        } else {
            $dql = "SELECT p FROM {$this->entity} p WHERE p.longitude = (SIN(RADIANS(p.latitude)) * RADIANS(p.longitude))";
        }

        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT b0_.id AS id_0, b0_.created AS created_1, b0_.longitude AS longitude_2, b0_.latitude AS latitude_3 FROM BlogPost b0_ WHERE b0_.longitude = SIN(RADIANS(b0_.latitude)) * RADIANS(b0_.longitude)';
        $this->assertEquals($sql, $q->getSql());

        $dql = "SELECT p FROM {$this->entity} p WHERE SIN(RADIANS(p.latitude)) * SIN(RADIANS(p.longitude)) = 1";
        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT b0_.id AS id_0, b0_.created AS created_1, b0_.longitude AS longitude_2, b0_.latitude AS latitude_3 FROM BlogPost b0_ WHERE SIN(RADIANS(b0_.latitude)) * SIN(RADIANS(b0_.longitude)) = 1';
        $this->assertEquals($sql, $q->getSql());

        if (\Doctrine\ORM\Version::compare('2.4.0') <= 0) {
            $dql = "SELECT SIN(RADIANS(p.latitude)) * SIN(RADIANS(p.longitude)) FROM {$this->entity} p ";
        } else {
            $dql = "SELECT (SIN(RADIANS(p.latitude)) * SIN(RADIANS(p.longitude))) FROM {$this->entity} p ";
        }

        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT SIN(RADIANS(b0_.latitude)) * SIN(RADIANS(b0_.longitude)) AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());
    }

    public function testAsin()
    {
        $this->_assertFirstQuery('ASIN');
        $this->_assertSecondQuery('ASIN');
    }

    public function testAcos()
    {
        $this->_assertFirstQuery('ACOS');
        $this->_assertSecondQuery('ACOS');

        if (\Doctrine\ORM\Version::compare('2.4.0') <= 0) {
            $dql = "SELECT ACOS(SIN(RADIANS(p.latitude)) + SIN(RADIANS(p.longitude))) * 1 FROM {$this->entity} p";
        } else {
            $dql = "SELECT (ACOS(SIN(RADIANS(p.latitude)) + SIN(RADIANS(p.longitude))) * 1) FROM {$this->entity} p";
        }

        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT ACOS(SIN(RADIANS(b0_.latitude)) + SIN(RADIANS(b0_.longitude))) * 1 AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());
    }

    public function testCos()
    {
        $this->_assertFirstQuery('COS');
        $this->_assertSecondQuery('COS');
    }

    public function testCot()
    {
        $this->_assertFirstQuery('COT');
        $this->_assertSecondQuery('COT');
    }

    public function testDegrees()
    {
        $this->_assertFirstQuery('DEGREES');
        $this->_assertSecondQuery('DEGREES');
    }

    public function testRadians()
    {
        $this->_assertFirstQuery('RADIANS');
        $this->_assertSecondQuery('RADIANS');
    }

    public function testTan()
    {
        $this->_assertFirstQuery('TAN');
        $this->_assertSecondQuery('TAN');
    }

    public function testAtan()
    {
        // test with 1 argument
        $this->_assertFirstQuery('ATAN');
        $this->_assertSecondQuery('ATAN');

        // test with 2 arguments
        $dql = "SELECT ATAN(p.latitude, p.longitude) FROM {$this->entity} p ";
        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT ATAN(b0_.latitude, b0_.longitude) AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());
    }

    public function testAtan2()
    {
        $dql = "SELECT ATAN2(p.latitude, p.longitude) FROM {$this->entity} p";
        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT ATAN2(b0_.latitude, b0_.longitude) AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());
    }

    public function testCosineLaw()
    {
        $lat = 0.0;
        $lng = 0.0;
        $radiusOfEarth = 6371;

        $cosineLaw = 'ACOS(SIN(' . deg2rad($lat) . ') * SIN(RADIANS(p.latitude)) '
                . '+ COS(' . deg2rad($lat) . ') * COS(RADIANS(p.latitude)) '
                . '* COS(RADIANS(p.longitude) - ' . deg2rad($lng) . ')'
                . ') * ' . $radiusOfEarth;

        if (\Doctrine\ORM\Version::compare('2.4.0') <= 0) {
            $dql = 'SELECT ' . $cosineLaw . " FROM {$this->entity} p";
        } else {
            $dql = 'SELECT (' . $cosineLaw . ") FROM {$this->entity} p";
        }

        $q = $this->entityManager->createQuery($dql);

        $sql = 'SELECT ACOS(SIN(0) * SIN(RADIANS(b0_.latitude)) + COS(0) * COS(RADIANS(b0_.latitude)) * COS(RADIANS(b0_.longitude) - 0)) * 6371 AS sclr_0 FROM BlogPost b0_';
        $this->assertEquals($sql, $q->getSql());
    }

    protected function _assertFirstQuery($func)
    {
        $q = $this->_getFirstDqlQuery($func);
        $sql = $this->_getFirstSqlQuery($func);
        $this->assertEquals($sql, $q->getSql());
    }

    protected function _assertSecondQuery($func)
    {
        $q = $this->_getSecondDqlQuery($func);
        $sql = $this->_getSecondSqlQuery($func);
        $this->assertEquals($sql, $q->getSql());
    }

    protected function _getFirstDqlQuery($func)
    {
        $dql = "SELECT p FROM {$this->entity} p WHERE " . $func . '(p.latitude) = 1';

        return $this->entityManager->createQuery($dql);
    }

    protected function _getFirstSqlQuery($func)
    {
        return 'SELECT b0_.id AS id_0, b0_.created AS created_1, '
        . 'b0_.longitude AS longitude_2, b0_.latitude AS latitude_3 '
        . 'FROM BlogPost b0_ WHERE ' . $func . '(b0_.latitude) = 1';
    }

    protected function _getSecondDqlQuery($func)
    {
        $dql = 'SELECT ' . $func . "(p.latitude) FROM {$this->entity} p";

        return $this->entityManager->createQuery($dql);
    }

    protected function _getSecondSqlQuery($func)
    {
        return 'SELECT ' . $func . '(b0_.latitude) AS sclr_0 FROM BlogPost b0_';
    }
}