MysqlTest

Complexity

Total Complexity

31

Size/Duplication

Total Lines	328
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

19 Methods

Rating	Name	Duplication	Size	Complexity
A	testInsertMultiPolygon()	0	12	1
A	testInsertMultiPoint()	0	8	1
A	testInsertLineString()	0	8	1
A	testDistanceSphere()	0	42	5
A	setUp()	0	8	1
A	testInsertGeometryCollection()	0	13	1
A	testDistanceSphereValue()	0	27	5
A	isMySQL8AfterFix()	0	6	1
A	testInsertPolygon()	0	8	1
A	testDistance()	0	32	1
A	createApplication()	0	22	1
A	testDistanceValue()	0	14	1
A	testInsertPoint()	0	6	1
A	assertException()	0	6	2
A	tearDown()	0	7	1
A	testUpdate()	0	19	1
A	assertDatabaseHas()	0	6	2
A	testSpatialFieldsNotDefinedException()	0	9	1
A	onMigrations()	0	13	3

<?php

use LaravelSpatial\SpatialServiceProvider;
use GeoJson\Geometry\GeometryCollection;
use GeoJson\Geometry\LineString;
use GeoJson\Geometry\MultiPoint;
use GeoJson\Geometry\MultiPolygon;
use GeoJson\Geometry\Point;
use GeoJson\Geometry\Polygon;
use Illuminate\Filesystem\Filesystem;

This use statement conflicts with another class in this namespace, Filesystem. Consider defining an alias.

use Illuminate\Support\Facades\DB;
use Laravel\BrowserKitTesting\TestCase as BaseTestCase;

This use statement conflicts with another class in this namespace, BaseTestCase. Consider defining an alias.

class MysqlTest extends BaseTestCase
{
    protected $is_postgres = false;

    protected $after_fix = false;

    /**
     * Boots the application.
     *
     * @return \Illuminate\Foundation\Application
     */
    public function createApplication()
    {
        $app = require __DIR__.'/../../vendor/laravel/laravel/bootstrap/app.php';
        $app->register(SpatialServiceProvider::class);

        $app->make('Illuminate\Contracts\Console\Kernel')->bootstrap();

        $app['config']->set('database.default', 'mysql');
        $app['config']->set('database.connections.mysql.host', env('DB_HOST', '127.0.0.1'));
        $app['config']->set('database.connections.mysql.database', 'spatial_test');
        $app['config']->set('database.connections.mysql.username', 'root');
        $app['config']->set('database.connections.mysql.password', '');
        $app['config']->set('database.connections.mysql.modes', [
            'ONLY_FULL_GROUP_BY',
            'STRICT_TRANS_TABLES',
            'NO_ZERO_IN_DATE',
            'NO_ZERO_DATE',
            'ERROR_FOR_DIVISION_BY_ZERO',
            'NO_ENGINE_SUBSTITUTION',
        ]);

        return $app;
    }

    /**
     * Setup DB before each test.
     *
     * @return void
     */
    public function setUp()
    {
        parent::setUp();

        $this->after_fix = $this->isMySQL8AfterFix();

        $this->onMigrations(function ($migrationClass) {
            (new $migrationClass())->up();
        });

        //\DB::listen(function($sql) {
        //    var_dump($sql);
        //});
    }

    public function tearDown()
    {
        $this->onMigrations(function ($migrationClass) {
            (new $migrationClass())->down();
        }, true);

        parent::tearDown();
    }

    // MySQL 8.0.4 fixed bug #26941370 and bug #88031
    protected function isMySQL8AfterFix()
    {
        $results = DB::select(DB::raw('select version()'));
        $mysql_version = $results[0]->{'version()'};

        return version_compare($mysql_version, '8.0.4', '>=');
    }

    protected function assertDatabaseHas($table, array $data, $connection = null)
    {
        if (method_exists($this, 'seeInDatabase')) {
            $this->seeInDatabase($table, $data, $connection);
        } else {
            parent::assertDatabaseHas($table, $data, $connection);
        }
    }

    protected function assertException($exceptionName)
    {
        if (method_exists(parent::class, 'expectException')) {
            parent::expectException($exceptionName);
        } else {
            $this->setExpectedException($exceptionName);

The function PHPUnit_Framework_TestCase::setExpectedException() has been deprecated: Method deprecated since Release 5.2.0; use expectException() instead

        }
    }

    private function onMigrations(\Closure $closure, $reverse_sort = false)
    {
        $fileSystem = new Filesystem();
        $classFinder = new Tools\ClassFinder();

        $migrations = $fileSystem->files(__DIR__.'/Migrations');
        $reverse_sort ? rsort($migrations, SORT_STRING) : sort($migrations, SORT_STRING);

        foreach ($migrations as $file) {
            $fileSystem->requireOnce($file);
            $migrationClass = $classFinder->findClass($file);

            $closure($migrationClass);
        }
    }

    public function testSpatialFieldsNotDefinedException()
    {
        $this->assertException(\LaravelSpatial\Exceptions\SpatialFieldsNotDefinedException::class);

        $geo = new NoSpatialFieldsModel();
        $geo->geometry = new Point([1, 2]);

The property geometry does not exist on NoSpatialFieldsModel. Did you mean geometries?

        $geo->save();

        NoSpatialFieldsModel::all();
    }

    public function testInsertPoint()
    {
        $geo = new GeometryModel();
        $geo->location = new Point([1, 2]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->save();
        $this->assertDatabaseHas($geo->getTable(), ['id' => $geo->id]);
    }

    public function testInsertLineString()
    {
        $geo = new GeometryModel();

        $geo->location = new Point([1, 2]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->line = new LineString([new Point([1, 1]), new Point([2, 2])]);

The property line does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->save();
        $this->assertDatabaseHas($geo->getTable(), ['id' => $geo->id]);
    }

    public function testInsertPolygon()
    {
        $geo = new GeometryModel();

        $geo->location = new Point([1, 2]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->shape = new Polygon([[[0, 10],[10, 10],[10, 0],[0, 0],[0, 10]]]);

The property shape does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->save();
        $this->assertDatabaseHas($geo->getTable(), ['id' => $geo->id]);
    }

    public function testInsertMultiPoint()
    {
        $geo = new GeometryModel();

        $geo->location = new Point([1, 2]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->multi_locations = new MultiPoint([new Point([1, 1]), new Point([2, 2])]);

The property multi_locations does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->save();
        $this->assertDatabaseHas($geo->getTable(), ['id' => $geo->id]);
    }

    public function testInsertMultiPolygon()
    {
        $geo = new GeometryModel();

        $geo->location = new Point([1, 2]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->multi_shapes = new MultiPolygon([

The property multi_shapes does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

            new Polygon([[[0, 10],[10, 10],[10, 0],[0, 0],[0, 10]]]),
            new Polygon([[[0, 0],[0, 5],[5, 5],[5, 0],[0, 0]]]),
        ]);
        $geo->save();
        $this->assertDatabaseHas($geo->getTable(), ['id' => $geo->id]);
    }

    public function testInsertGeometryCollection()
    {
        $geo = new GeometryModel();

        $geo->location = new Point([1, 2]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->multi_geometries = new GeometryCollection([

The property multi_geometries does not exist on GeometryModel. Did you mean geometries?

            new Polygon([[[0, 10],[10, 10],[10, 0],[0, 0],[0, 10]]]),
            new Polygon([[[0, 0],[0, 5],[5, 5],[5, 0],[0, 0]]]),
            new Point([0, 0]),
        ]);
        $geo->save();
        $this->assertDatabaseHas($geo->getTable(), ['id' => $geo->id]);
    }

    public function testUpdate()
    {
        $geo = new GeometryModel();
        $geo->location = new Point([1, 2]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $geo->save();

        $to_update = GeometryModel::all()->first();
        $to_update->location = new Point([2, 3]);
        $to_update->save();

        $this->assertDatabaseHas($geo->getTable(), ['id' => $to_update->id]);

        $all = GeometryModel::all();
        $this->assertCount(1, $all);

        $updated = $all->first();
        $this->assertInstanceOf(Point::class, $updated->location);
        $this->assertEquals(2, $updated->location->getCoordinates()[0]);
        $this->assertEquals(3, $updated->location->getCoordinates()[1]);
    }

    public function testDistance()
    {
        $loc1 = new GeometryModel();
        $loc1->location = new Point([1, 1]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $loc1->save();

        $loc2 = new GeometryModel();
        $loc2->location = new Point([2, 2]); // Distance from loc1: 1.4142135623731
        $loc2->save();

        $loc3 = new GeometryModel();
        $loc3->location = new Point([3, 3]); // Distance from loc1: 2.8284271247462
        $loc3->save();

        $a = GeometryModel::distance('location', $loc1->location, 2)->get();
        $this->assertCount(2, $a);
        $this->assertTrue($a->contains('location', $loc1->location));

The method contains() does not exist on Countable. It seems like you code against a sub-type of Countable such as Illuminate\Pagination\LengthAwarePaginator or Illuminate\Support\Collection or Illuminate\Http\Resources\Json\ResourceCollection or SplObjectStorage or Carbon\CarbonPeriod or Illuminate\Pagination\Paginator or Symfony\Component\Finder\Finder or Illuminate\Support\ViewErrorBag or Symfony\Component\HttpFoundation\HeaderBag or PHPUnit_Extensions_TestDecorator or PHPUnit_Framework_TestCase.

The method contains() does not exist on Traversable. It seems like you code against a sub-type of Traversable such as Illuminate\Pagination\LengthAwarePaginator or Illuminate\Support\Collection or Illuminate\Http\Resources\Json\ResourceCollection or Illuminate\Pagination\Paginator or Symfony\Component\Finder\Finder or Symfony\Component\HttpFoundation\HeaderBag or SplObjectStorage or Carbon\CarbonPeriod.

        $this->assertTrue($a->contains('location', $loc2->location));
        $this->assertFalse($a->contains('location', $loc3->location));

        // Excluding self
        $b = GeometryModel::distanceExcludingSelf('location', $loc1->location, 2)->get();
        $this->assertCount(1, $b);
        $this->assertFalse($b->contains('location', $loc1->location));
        $this->assertTrue($b->contains('location', $loc2->location));
        $this->assertFalse($b->contains('location', $loc3->location));

        $c = GeometryModel::distance('location', $loc1->location, 1)->get();
        $this->assertCount(1, $c);
        $this->assertTrue($c->contains('location', $loc1->location));
        $this->assertFalse($c->contains('location', $loc2->location));
        $this->assertFalse($c->contains('location', $loc3->location));
    }

    public function testDistanceSphere()
    {
        try {
            $loc1 = new GeometryModel();
            $loc1->location = new Point([-73.971732, 40.767864]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

            $loc1->save();

            $loc2 = new GeometryModel();
            $loc2->location = new Point([-73.971271, 40.767664]); // Distance from loc1: 44.741406484588
            $loc2->save();

            $loc3 = new GeometryModel();
            $loc3->location = new Point([-73.977619, 40.761434]); // Distance from loc1: 870.06424066202
            $loc3->save();

            $a = GeometryModel::distanceSphere('location', $loc1->location, 200)->get();
            $this->assertCount(2, $a);
            $this->assertTrue($a->contains('location', $loc1->location));
            $this->assertTrue($a->contains('location', $loc2->location));
            $this->assertFalse($a->contains('location', $loc3->location));

            // Excluding self
            $b = GeometryModel::distanceSphereExcludingSelf('location', $loc1->location, 200)->get();
            $this->assertCount(1, $b);
            $this->assertFalse($b->contains('location', $loc1->location));
            $this->assertTrue($b->contains('location', $loc2->location));
            $this->assertFalse($b->contains('location', $loc3->location));

            if ($this->is_postgres || $this->after_fix) {
                $c = GeometryModel::distanceSphere('location', $loc1->location, 44.741406484236)->get();
            } else {
                $c = GeometryModel::distanceSphere('location', $loc1->location, 44.741406484587)->get();
            }
            $this->assertCount(1, $c);
            $this->assertTrue($c->contains('location', $loc1->location));
            $this->assertFalse($c->contains('location', $loc2->location));
            $this->assertFalse($c->contains('location', $loc3->location));
        } catch (\Illuminate\Database\QueryException $e) {
            if (strpos($e->getMessage(), 'FUNCTION spatial_test.ST_Distance_Sphere does not exist') > -1) {
                $this->markTestSkipped('Spherical distance tests [distanceSphere*()] not supported on the current DBMS');
            }
            throw $e;
        }
    }

    public function testDistanceValue()
    {
        $loc1 = new GeometryModel();
        $loc1->location = new Point([1, 1]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

        $loc1->save();

        $loc2 = new GeometryModel();
        $loc2->location = new Point([2, 2]); // Distance from loc1: 1.4142135623731
        $loc2->save();

        $a = GeometryModel::distanceValue('location', $loc1->location)->get();
        $this->assertCount(2, $a);
        $this->assertEquals(0, $a[0]->distance);
        $this->assertEquals(1.4142135623, $a[1]->distance); // PHP floats' 11th+ digits don't matter
    }

    public function testDistanceSphereValue()
    {
        try {
            $loc1 = new GeometryModel();
            $loc1->location = new Point([-73.971732, 40.767864]);

The property location does not seem to exist on GeometryModel. Are you sure there is no database migration missing?

            $loc1->save();

            $loc2 = new GeometryModel();
            $loc2->location = new Point([-73.971271, 40.767664]); // Distance from loc1: 44.741406484236
            $loc2->save();

            $a = GeometryModel::distanceSphereValue('location', $loc1->location)->get();
            $this->assertCount(2, $a);
            $this->assertEquals(0, $a[0]->distance);

            if ($this->is_postgres) {
                $this->assertEquals("44.7415664", number_format($a[1]->distance, 7)); // Postgres calculates this differently?
            } elseif ($this->after_fix) {
                $this->assertEquals(44.7414064842, $a[1]->distance); // PHP floats' 11th+ digits don't matter
            } else {
                $this->assertEquals(44.7414064845, $a[1]->distance); // PHP floats' 11th+ digits don't matter
            }
        } catch (\Illuminate\Database\QueryException $e) {
            if (strpos($e->getMessage(), 'FUNCTION spatial_test.ST_Distance_Sphere does not exist') > -1) {
                $this->markTestSkipped('Spherical distance tests [distanceSphere*()] not supported on the current DBMS');
            }
            throw $e;
        }
    }

    //public function testBounding() {
    //    $point = new Point([0, 0]);
    //
    //    $linestring1 = \GeoJson\Geometry\LineString::fromWkt("LINESTRING(1 1, 2 2)");
    //    $linestring2 = \GeoJson\Geometry\LineString::fromWkt("LINESTRING(20 20, 24 24)");
    //    $linestring3 = \GeoJson\Geometry\LineString::fromWkt("LINESTRING(0 10, 10 10)");
    //
    //    $geo1 = new GeometryModel();
    //    $geo1->location = $point;
    //    $geo1->line = $linestring1;
    //    $geo1->save();
    //
    //    $geo2 = new GeometryModel();
    //    $geo2->location = $point;
    //    $geo2->line = $linestring2;
    //    $geo2->save();
    //
    //    $geo3 = new GeometryModel();
    //    $geo3->location = $point;
    //    $geo3->line = $linestring3;
    //    $geo3->save();
    //
    //    $polygon = new Polygon([[[0, 10],[10, 10],[10, 0],[0, 0],[0, 10]]]);
    //
    //    $result = GeometryModel::Bounding($polygon, 'line')->get();
    //    $this->assertCount(2, $result);
    //    $this->assertTrue($result->contains($geo1));
    //    $this->assertFalse($result->contains($geo2));
    //    $this->assertTrue($result->contains($geo3));
    //
    //}
}