Smindel\GIS\ORM\SQLite3GISSchemaManager

Complexity

Total Complexity

7

Size/Duplication

Total Lines	37
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

4 Methods

Rating	Name	Duplication	Size	Complexity
A	initialise()	0	6	2
A	translateBasicSelectGeo()	0	4	1
A	translateStGeometryTypeFilter()	0	10	3
A	geography()	0	4	1

<?php

namespace Smindel\GIS\ORM;

use SilverStripe\SQLite\SQLite3SchemaManager;

The type SilverStripe\SQLite\SQLite3SchemaManager was not found. Maybe you did not declare it correctly or list all dependencies?

use SilverStripe\ORM\DB;
use Smindel\GIS\GIS;

class SQLite3GISSchemaManager extends SQLite3SchemaManager
{
    use GISSchemaManager;

    protected static $is_initialised = false;

    public function initialise() {
        if (!self::$is_initialised) {
            $connector = DB::get_connector()->getRawConnector();

The method getRawConnector() does not exist on SilverStripe\ORM\Connect\DBConnector.

            $connector->loadExtension('mod_spatialite.so');
            $connector->exec("SELECT InitSpatialMetadata()");
            self::$is_initialised = true;
        }
    }

    public function geography($values)
    {
        // ATTENTION: GEOGRAPHY IS NOT SUPPORTED BY MYSQL. THIS IS STRICTLY FOR COMPATIBILITY
        return 'geometry';
    }

    public function translateStGeometryTypeFilter($field, $value, $inclusive)
    {
        $null = $inclusive ? '' : ' OR ' . DB::get_conn()->nullCheckClause($field, true);
        $fragment = sprintf(
            '%sLOWER(ST_GeometryType(%s)) = ?%s',
            $inclusive ? '' : 'NOT ',
            $field,
            $null
        );
        return [$fragment => strtolower($value)];
    }

    public function translateBasicSelectGeo()
    {
        DB::get_schema()->initialise();

The method initialise() does not exist on SilverStripe\ORM\Connect\DBSchemaManager. It seems like you code against a sub-type of SilverStripe\ORM\Connect\DBSchemaManager such as Smindel\GIS\ORM\MySQLGISSchemaManager.

        return 'CASE WHEN %s IS NULL THEN NULL ELSE \'SRID=\' || ST_SRID(%s) || \';\' || ST_AsText(%s) END AS "%s"';
    }
}