Skip to content

Latest commit

 

History

History
141 lines (130 loc) · 10.6 KB

INSTALL.md

File metadata and controls

141 lines (130 loc) · 10.6 KB
Raw

Symfony2 Install

composer.json

"require": {
    ...
    "creof/doctrine2-spatial": "dev-master"

You will also have to change the version requirement of doctrine to at least 2.1:

    "doctrine/orm": ">=2.1",

config.yml

Add the types and functions you need to your Symfony configuration. The doctrine type names are not hardcoded.

doctrine:
    dbal:
        types:
            geometry:   CrEOF\Spatial\DBAL\Types\GeometryType
            point:      CrEOF\Spatial\DBAL\Types\Geometry\PointType
            polygon:    CrEOF\Spatial\DBAL\Types\Geometry\PolygonType
            linestring: CrEOF\Spatial\DBAL\Types\Geometry\LineStringType

	    orm:
	        dql:
	            numeric_functions:
                        # for postgresql
                        starea:                  CrEOFSpatialORMQueryASTFunctionsPostgreSql\STArea
                        stasbinary:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STAsBinary
                        stasgeojson:             CrEOFSpatialORMQueryASTFunctionsPostgreSql\STAsGeoJson
                        stastext:                CrEOFSpatialORMQueryASTFunctionsPostgreSql\STAsText
                        stazimuth:               CrEOFSpatialORMQueryASTFunctionsPostgreSql\STAzimuth
                        stboundary:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STBoundary
                        STBuffer:                CrEOFSpatialORMQueryASTFunctionsPostgreSql\STBuffer
                        stcentroid:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STCentroid
                        stclosestpoint:          CrEOFSpatialORMQueryASTFunctionsPostgreSql\STClosestPoint
                        stcontains:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STContains
                        stcontainsproperly:      CrEOFSpatialORMQueryASTFunctionsPostgreSql\STContainsProperly
                        stcoveredby:             CrEOFSpatialORMQueryASTFunctionsPostgreSql\STCoveredBy
                        stcovers:                CrEOFSpatialORMQueryASTFunctionsPostgreSql\STCovers
                        stcrosses:               CrEOFSpatialORMQueryASTFunctionsPostgreSql\STCrosses
                        stdisjoint:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STDisjoint
                        stdistance:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STDistance
                        stdistancesphere:        CrEOFSpatialORMQueryASTFunctionsPostgreSql\STDistanceSphere
                        stdwithin:               CrEOFSpatialORMQueryASTFunctionsPostgreSql\STDWithin
                        stenvelope:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STEnvelope
                        stexpand:                CrEOFSpatialORMQueryASTFunctionsPostgreSql\STExpand
                        stextent:                CrEOFSpatialORMQueryASTFunctionsPostgreSql\STExtent
                        stgeomfromtext:          CrEOFSpatialORMQueryASTFunctionsPostgreSql\STGeomFromText
                        stintersection:          CrEOFSpatialORMQueryASTFunctionsPostgreSql\STIntersection
                        stintersects:            CrEOFSpatialORMQueryASTFunctionsPostgreSql\STIntersects
                        stlength:                CrEOFSpatialORMQueryASTFunctionsPostgreSql\STLength
                        stlinecrossingdirection: CrEOFSpatialORMQueryASTFunctionsPostgreSql\STLineCrossingDirection
                        stlineinterpolatepoint:  CrEOFSpatialORMQueryASTFunctionsPostgreSql\STLineInterpolatePoint
                        stmakebox2d:             CrEOFSpatialORMQueryASTFunctionsPostgreSql\STMakeBox2D
                        stmakeline:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STMakeLine
                        stmakepoint:             CrEOFSpatialORMQueryASTFunctionsPostgreSql\STMakePoint
                        stperimeter:             CrEOFSpatialORMQueryASTFunctionsPostgreSql\STPerimeter
                        stpoint:                 CrEOFSpatialORMQueryASTFunctionsPostgreSql\STPoint
                        stscale:                 CrEOFSpatialORMQueryASTFunctionsPostgreSql\STScale
                        stsetsrid:               CrEOFSpatialORMQueryASTFunctionsPostgreSql\STSetSRID
                        stsimplify:              CrEOFSpatialORMQueryASTFunctionsPostgreSql\STSimplify
                        ststartpoint:            CrEOFSpatialORMQueryASTFunctionsPostgreSql\STStartPoint
                        stsummary:               CrEOFSpatialORMQueryASTFunctionsPostgreSql\STSummary
                        sttouches:               CrEOFSpatialORMQueryASTFunctionsPostgreSql\STTouches
                        sttransform:             CrEOFSpatialORMQueryASTFunctionsPostgreSql\STTransform

                        # for mysql
                        area:                   CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Area
                        asbinary:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\AsBinary
                        astext:                 CrEOF\Spatial\ORM\Query\AST\Functions\MySql\AsText
                        buffer:                 CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Buffer
                        centroid:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Centroid
                        contains:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Contains
                        crosses:                CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Crosses
                        dimension:              CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Dimension
                        distance:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Distance
                        disjoint:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Disjoint
                        distancefrommultyLine:  CrEOF\Spatial\ORM\Query\AST\Functions\MySql\DistanceFromMultyLine
                        endpoint:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\EndPoint
                        envelope:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Envelope
                        equals:                 CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Equals
                        exteriorring:           CrEOF\Spatial\ORM\Query\AST\Functions\MySql\ExteriorRing
                        geodistpt:              CrEOF\Spatial\ORM\Query\AST\Functions\MySql\GeodistPt
                        geometrytype:           CrEOF\Spatial\ORM\Query\AST\Functions\MySql\GeometryType
                        geomfromtext:           CrEOF\Spatial\ORM\Query\AST\Functions\MySql\GeomFromText
                        glength:                CrEOF\Spatial\ORM\Query\AST\Functions\MySql\GLength
                        interiorringn:          CrEOF\Spatial\ORM\Query\AST\Functions\MySql\InteriorRingN
                        intersects:             CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Intersects
                        isclosed:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\IsClosed
                        isempty:                CrEOF\Spatial\ORM\Query\AST\Functions\MySql\IsEmpty
                        issimple:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\IsSimple
                        linestringfromwkb:      CrEOF\Spatial\ORM\Query\AST\Functions\MySql\LineStringFromWKB
                        linestring:             CrEOF\Spatial\ORM\Query\AST\Functions\MySql\LineString
                        mbrcontains:            CrEOF\Spatial\ORM\Query\AST\Functions\MySql\MBRContains
                        mbrdisjoint:            CrEOF\Spatial\ORM\Query\AST\Functions\MySql\MBRDisjoint
                        mbrequal:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\MBREqual
                        mbrintersects:          CrEOF\Spatial\ORM\Query\AST\Functions\MySql\MBRIntersects
                        mbroverlaps:            CrEOF\Spatial\ORM\Query\AST\Functions\MySql\MBROverlaps
                        mbrtouches:             CrEOF\Spatial\ORM\Query\AST\Functions\MySql\MBRTouches
                        mbrwithin:              CrEOF\Spatial\ORM\Query\AST\Functions\MySql\MBRWithin
                        numinteriorrings:       CrEOF\Spatial\ORM\Query\AST\Functions\MySql\NumInteriorRings
                        numpoints:              CrEOF\Spatial\ORM\Query\AST\Functions\MySql\NumPoints
                        overlaps:               CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Overlaps
                        pointfromwkb:           CrEOF\Spatial\ORM\Query\AST\Functions\MySql\PointFromWKB
                        pointn:                 CrEOF\Spatial\ORM\Query\AST\Functions\MySql\PointN
                        point:                  CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Point
                        srid:                   CrEOF\Spatial\ORM\Query\AST\Functions\MySql\SRID
                        startpoint:             CrEOF\Spatial\ORM\Query\AST\Functions\MySql\StartPoint
                        st_buffer:              CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STBuffer
                        st_contains:            CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STContains
                        st_crosses:             CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STCrosses
                        st_disjoint:            CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STDisjoint
                        st_equals:              CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STEquals
                        st_intersects:          CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STIntersects
                        st_overlaps:            CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STOverlaps
                        st_touches:             CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STTouches
                        st_within:              CrEOF\Spatial\ORM\Query\AST\Functions\MySql\STWithin
                        touches:                CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Touches
                        within:                 CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Within
                        x:                      CrEOF\Spatial\ORM\Query\AST\Functions\MySql\X
                        y:                      CrEOF\Spatial\ORM\Query\AST\Functions\MySql\Y

## Add new function in dql
Simply add new class in vendor\slavenin\doctrine2-spatial\lib\CrEOF\Spatial\ORM\Query\AST\Functions\MySql\ with need function name and config.yml.

Example:
```php
class Point extends AbstractSpatialDQLFunction
{
	protected $platforms = array('mysql');
	/*function name in dql*/
	protected $functionName = 'Point';
	/*min params count*/
    protected $minGeomExpr = 2;
	/*max params  count*/
	protected $maxGeomExpr = 2;
}