smindel / silverstripe-gis

src/ORM/SQLite3GISSchemaManager.php

<?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;

if (!class_exists(SQLite3SchemaManager::class)) return;

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"';
    }
}