MysqlTest::testDistanceSphereValue() - Code Metrics - Inspection of "Initial tests" - danhunsaker/laravel-spatial - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Branch — testing (7f3043)

by Hennik
created 2019-01-02 03:47 UTC
MysqlTest::testDistanceSphereValue() A

↳ Parent: MysqlTest
Complexity

Conditions	5
Paths	27
Size

Total Lines	27
Code Lines	20
Duplication

Lines	0
Ratio	0 %
Importance

Changes	1
Bugs	0	Features	0
Metric	Value
eloc	20
c	1
b	0
f	0
dl	0
loc	27
rs	9.2888
cc	5
nc	27
nop	0
<?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;
.
|-- OtherDir
|   |-- Bar.php
|   `-- Foo.php
`-- SomeDir
    `-- Foo.php
use Illuminate\Support\Facades\DB;
use Laravel\BrowserKitTesting\TestCase as BaseTestCase;
.
|-- OtherDir
|   |-- Bar.php
|   `-- Foo.php
`-- SomeDir
    `-- Foo.php

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);
            /** @scrutinizer ignore-deprecated */ $this->setExpectedException($exceptionName);
        }
    }

    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]);

        $geo->save();

        NoSpatialFieldsModel::all();
    }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


        $geo->multi_shapes = new MultiPolygon([

            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]);


        $geo->multi_geometries = new GeometryCollection([

            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]);

        $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]);

        $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));
        $this->assertTrue($a->/** @scrutinizer ignore-call */ contains('location', $loc1->location));
        $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]);

            $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]);

        $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]);

            $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));
    //
    //}
}

danhunsaker / laravel-spatial

Branch — testing (7f3043)

MysqlTest::testDistanceSphereValue() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
