Mapbender 3.0.6.3 API documenation
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Namespaces

  • FOM
    • CoreBundle
      • Component
      • DependencyInjection
      • Doctrine
        • Types
      • Form
        • DataTransformer
        • Type
    • ManagerBundle
      • Component
      • Configuration
      • Controller
      • DependencyInjection
        • Compiler
      • Form
        • Type
      • Routing
    • UserBundle
      • Command
      • Component
      • Controller
      • DependencyInjection
        • Factory
      • Entity
      • EventListener
      • Form
        • DataTransformer
        • EventListener
        • Type
      • Security
        • Authentication
          • Provider
          • Token
        • Authorization
          • Voter
        • Firewall
  • Mapbender
    • Component
    • CoreBundle
      • Asset
      • Command
      • Component
        • Exception
      • Controller
      • DataFixtures
        • ORM
          • Application
      • DependencyInjection
        • Compiler
      • Element
        • DataTransformer
        • EventListener
        • Type
      • Entity
      • EventListener
      • Extension
      • Form
        • DataTransformer
        • EventListener
        • Type
      • Security
      • Template
      • Tests
        • Controller
      • Utils
      • Validator
        • Constraints
    • DataSourceBundle
      • Component
        • Drivers
          • Interfaces
      • Controller
      • DependencyInjection
      • Element
        • Type
      • Entity
      • Extension
      • Tests
    • DigitizerBundle
      • Component
      • Element
        • Type
      • Entity
      • Utils
    • DrupalIntegrationBundle
      • DependencyInjection
      • Security
        • Authentication
          • Provider
          • Token
        • Authorization
          • Voter
        • Factory
        • Firewall
        • User
      • Session
    • KmlBundle
      • Element
    • ManagerBundle
      • Component
        • Exception
      • Controller
      • Form
        • DataTransformer
        • Type
      • Template
    • MobileBundle
      • DependencyInjection
      • Template
    • PrintBundle
      • Component
      • Element
        • Type
    • WmcBundle
      • Component
        • Exception
      • Element
        • Type
      • Entity
      • Form
        • Type
      • Tests
        • Component
    • WmsBundle
      • Component
        • Exception
      • Controller
      • DependencyInjection
      • Element
        • DataTransformer
        • EventListener
        • Type
      • Entity
      • Event
      • Form
        • DataTransformer
        • EventListener
        • Type
  • None
  • OwsProxy3
    • CoreBundle
      • Component
        • Exception
      • Controller
      • DependencyInjection
      • Entity
      • Event
      • EventListener
      • Worker
  • PHP

Classes

  • BaseDriver
  • DoctrineBaseDriver
  • Oracle
  • PostgreSQL
  • SQLite
  • YAML

Class PostgreSQL

Class PostgreSQL

Symfony\Component\DependencyInjection\ContainerAware
Extended by Mapbender\DataSourceBundle\Component\Drivers\BaseDriver
Extended by Mapbender\DataSourceBundle\Component\Drivers\DoctrineBaseDriver implements Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Base
Extended by Mapbender\DataSourceBundle\Component\Drivers\PostgreSQL implements Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Manageble, Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Routable, Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Geographic
Namespace: Mapbender\DataSourceBundle\Component\Drivers
Package: Mapbender\DataSourceBundle\Component\Drivers
Author: Andriy Oblivantsev <eslider@gmail.com>
Located at data-source/Component/Drivers/PostgreSQL.php

Methods summary

public Mapbender\DataSourceBundle\Entity\DataItem
# insert( array|Mapbender\DataSourceBundle\Entity\DataItem $item, boolean $cleanData = true )

Insert data item

Insert data item

Parameters

$item
$cleanData
Clean data before insert?

Returns

Mapbender\DataSourceBundle\Entity\DataItem
DataItem

Overrides

Mapbender\DataSourceBundle\Component\Drivers\DoctrineBaseDriver::insert
public boolean
# addGeometryColumn( string $tableName, string $type, string $srid, string $geomFieldName = "geom", string $schemaName = "public", integer $dimensions = 2 )

Add geometry column

Add geometry column

Parameters

$tableName
$type
$srid
$geomFieldName
$schemaName
$dimensions

Returns

boolean
bool

Throws

Doctrine\DBAL\DBALException
\Doctrine\DBAL\DBALException

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Geographic::addGeometryColumn()
public boolean
# createTable( mixed $name, string $idColumn = 'id', boolean $dropBeforeCreate = false )

Parameters

$name
$idColumn
$dropBeforeCreate

Returns

boolean
bool

Throws

Doctrine\DBAL\DBALException
\Doctrine\DBAL\DBALException

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Manageble::createTable()
public integer
# dropTable( mixed $name )

Parameters

$name

Returns

integer
int

Throws

Doctrine\DBAL\DBALException
\Doctrine\DBAL\DBALException

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Manageble::dropTable()
public string
# getTableGeomType( string $tableName, string $schema = null )

Get table geom type

Get table geom type

Parameters

$tableName
Table name. The name can contains schema name splited by dot.
$schema

Returns

string
string

Throws

Doctrine\DBAL\DBALException
\Doctrine\DBAL\DBALException

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Geographic::getTableGeomType()
public integer
# getLastInsertId( )

Get last insert id

Get last insert id

Returns

integer
int

Overrides

Mapbender\DataSourceBundle\Component\Drivers\DoctrineBaseDriver::getLastInsertId

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Manageble::getLastInsertId()
public integer
# getNodeFromGeom( mixed $waysVerticesTableName, mixed $waysGeomFieldName, string $ewkt, null $transformTo = null, string $idKey = "id" )

Get nearest node to given geometry

Get nearest node to given geometry

Important: <-> operator works not well!!

Parameters

$waysVerticesTableName
$waysGeomFieldName
$ewkt
EWKT
$transformTo
$idKey

Returns

integer
Node ID

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Routable::getNodeFromGeom()
public Mapbender\DataSourceBundle\Entity\Feature[]
# routeBetweenNodes( mixed $waysTableName, mixed $waysGeomFieldName, integer $startNodeId, integer $endNodeId, mixed $srid, boolean $directedGraph = false, boolean $hasReverseCost = false )

Route between nodes

Route between nodes

Parameters

$waysTableName
$waysGeomFieldName
$startNodeId
$endNodeId
$srid
$directedGraph
directed graph
$hasReverseCost
Has reverse cost, only can be true, if directed graph=true

Returns

Mapbender\DataSourceBundle\Entity\Feature[]
\Mapbender\DataSourceBundle\Entity\Feature[]

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Routable::routeBetweenNodes()
public array
# listDatabases( )

Returns

array
array

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Manageble::listDatabases()
public array
# listSchemas( mixed $databaseName )

Parameters

$databaseName

Returns

array
array

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Manageble::listSchemas()
public array
# listTables( mixed $schemaName )

Get database table names

Get database table names

Parameters

$schemaName

Returns

array
array

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Manageble::listTables()
public mixed
# transformEwkt( mixed $ewkt, null $srid = null )

Parameters

$ewkt
$srid

Returns

mixed
mixed

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Geographic::transformEwkt()
public string
# getIntersectCondition( string $wkt, string $geomFieldName, string $srid, string $sridTo )

Parameters

$wkt
WKT
$geomFieldName
geometry field name
$srid
SRID convert from
$sridTo
SRID convert to

Returns

string
SQL

Inheritdoc

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Geographic::getIntersectCondition()
public string
# getGeomAttributeAsWkt( string $geometryAttribute, string $sridTo )

Parameters

$geometryAttribute
$sridTo
SRID convert to

Returns

string
SQL

Inheritdoc

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Geographic::getGeomAttributeAsWkt()
public string
# findGeometryFieldSrid( string $tableName, string $geomFieldName )

Parameters

$tableName
$geomFieldName

Returns

string
SQL

Inheritdoc

Implementation of

Mapbender\DataSourceBundle\Component\Drivers\Interfaces\Geographic::findGeometryFieldSrid()

Methods inherited from Mapbender\DataSourceBundle\Component\Drivers\DoctrineBaseDriver

canRead(), canWrite(), cleanData(), connect(), extractTypeValues(), fetchColumn(), fetchList(), get(), getByCriteria(), getById(), getPlatformName(), getSelectQueryBuilder(), getStoreFields(), getTableName(), getVersion(), isReady(), prepareResults(), remove(), save(), search(), setFilter(), setTable(), update()

Methods inherited from Mapbender\DataSourceBundle\Component\Drivers\BaseDriver

__construct(), create(), getConnection(), getFields(), getUniqueId(), getWktType(), roundGeometry(), setFields(), setUniqueId()

Magic methods summary

Constants summary

Constants inherited from Mapbender\DataSourceBundle\Component\Drivers\DoctrineBaseDriver

MAX_RESULTS

Properties summary

Properties inherited from Mapbender\DataSourceBundle\Component\Drivers\DoctrineBaseDriver

$connection, $sqlFilter, $tableName

Properties inherited from Mapbender\DataSourceBundle\Component\Drivers\BaseDriver

$fields, $settings, $uniqueId

Mapbender 3.0.6.3 API documenation API documentation generated by ApiGen 2.8.0