PHP Jsor\Doctrine\PostGIS\Schema SchemaManager::listSpatialGeometryColumns Examples

listSpatialGeometryColumns() public method

public listSpatialGeometryColumns ( $table )

Example #1

File: DBALSchemaEventSubscriber.php Project: novikovsergey/doctrine-postgis

 public function onSchemaDropTable(SchemaDropTableEventArgs $args)
 {
     if ($this->schemaManager->isPostGis2()) {
         return;
     }
     $table = $args->getTable();
     $hasSpatialGeometryColumn = count($this->schemaManager->listSpatialGeometryColumns($table->getName())) > 0;
     if ($hasSpatialGeometryColumn) {
         $args->setSql("SELECT DropGeometryTable('" . $table->getName() . "')")->preventDefault();
     }
 }

Example #2

File: SchemaManagerTest.php Project: jsor/doctrine-postgis

 public function testListSpatialGeometryColumnsWithReservedWords()
 {
     $schemaManager = new SchemaManager($this->_getConnection());
     $expected = array('user');
     $this->assertEquals($expected, $schemaManager->listSpatialGeometryColumns('"user"'));
 }

Example #3

File: SchemaManagerTest.php Project: novikovsergey/doctrine-postgis

 public function testListSpatialGeometryColumns()
 {
     $schemaManager = new SchemaManager($this->_getConnection());
     $expected = array('geometry', 'point', 'point_2d', 'point_3dz', 'point_3dm', 'point_4d', 'point_2d_nullable', 'point_2d_nosrid');
     $this->assertEquals($expected, $schemaManager->listSpatialGeometryColumns('foo.points'));
 }