2017 © Pedro Peláez
 

library data-source

Mapbender data source handler

image

mapbender/data-source

Mapbender data source handler

  • Wednesday, July 11, 2018
  • by eSlider
  • Repository
  • 25 Watchers
  • 0 Stars
  • 2,915 Installations
  • PHP
  • 5 Dependents
  • 0 Suggesters
  • 0 Forks
  • 4 Open issues
  • 53 Versions
  • 16 % Grown

The README.md

Deprecated

This repository is deprecated. Its functionality will be integrated into the mapbender digitizer repository in version 2.0 and the code has already been ported to the develop branch. Propose any changes there., (*1)


Old description: Mapbender data source module

Components abstracting raw doctrine tables into repositories., (*2)

The base DataStore is a repository promoting loaded rows into DataItem objects, and also supports DataItem objects when updating / inserting., (*3)

FeatureType is an extended repository type with spatial data support. It loads / stores Feature objects, with dedicated methods for accessing / replacing the geometry. The geometry is internally always an EWKT, but methods are provided to get / update the plain WKT or the SRID individually., (*4)

Only a single geometry column per table is supported., (*5)

Main repository methods

Method search loads all rows from the table and promotes them into an array of DataItem / Feature objects. Accepts an array of controlling parameters. Allowed params are maxResults, where (string; additional SQL where clause). FeatureType additionally supports params srid (explicit geometry output SRID) and intersect (string; (E)WKT geometry to spatially limit results)., (*6)

Method count Accepts the same parameters as search, but returns only the number of matched rows., (*7)

Method getById loads one DataItem / Feature. Filters are skipped., (*8)

Methods save, insert, update perform storage. save auto-inflects to insert or update, depending on the presence of an id in the passed argument. These methods accept either DataItem / Feature objects or arrays. The affected or new row is reloaded and returned as a DataItem / Feature object., (*9)

Method delete removes the row corresponding with an id or a specific DataItem / Feature object., (*10)

Configuring repositories

Named DataStore / FeatureType repositorys can be pre-configured globally via container parameters (dataStores and featureTypes respectively), or instantiated ad hoc from a configuration array., (*11)

DataStore configuration supports the following values:, (*12)

name type description default
connection string name of doctrine connection "default"
table string name of table; required -none-
uniqueId string name of primary id column "id"
fields list of strings names of columns to load into DataItem / Feature objects null (=auto-detect columns)
filter string valid SQL where clause to build into all search invocations null
geomField (FeatureType only) string name of the geometry column "geom"
srid (FeatureType only) integer or null Source srid of geomField; used only if detection fails (certain views) null

NOTE: you should not attempt placing spatial data into the "default" database containing your Doctrine entities. You will encounter errors running Doctrine schema updates., (*13)

NOTE: Both the filter setting and the where search param may use a magic placeholder :userName, which is automatically bound to the name of the user running the query., (*14)

The Versions

11/07 2018

dev-feature/rvr-sql-filter

dev-feature/rvr-sql-filter

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

13/12 2017

dev-feature/spatialite-integration

dev-feature/spatialite-integration

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

12/12 2017

dev-feature/cookBook

dev-feature/cookBook

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

05/10 2017

dev-master

9999999-dev

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

05/10 2017

0.1.6

0.1.6.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

28/09 2017

dev-feature/migrate-feature-type

dev-feature/migrate-feature-type

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

28/09 2017

dev-fix/json-response-type

dev-fix/json-response-type

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

20/07 2017

0.1.5

0.1.5.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

04/07 2017

dev-hotfix/translations

dev-hotfix/translations

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

04/07 2017

0.1.4

0.1.4.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

29/05 2017

0.1.3

0.1.3.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

09/04 2017

0.1.1

0.1.1.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

09/04 2017

0.1.2

0.1.2.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

28/02 2017

dev-refactor/drivers

dev-refactor/drivers

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

20/12 2016

0.0.35

0.0.35.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

The Development Requires

data mapbender data source

08/11 2016

0.0.34

0.0.34.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

31/08 2016

dev-feature/oracle-support

dev-feature/oracle-support

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

05/08 2016

0.0.33

0.0.33.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

19/07 2016

dev-feature/datatstore-mapping

dev-feature/datatstore-mapping

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

19/07 2016

0.0.32

0.0.32.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

27/06 2016

0.0.31

0.0.31.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

30/05 2016

0.0.30

0.0.30.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

05/04 2016

0.0.29

0.0.29.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

04/04 2016

0.0.28

0.0.28.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

01/04 2016

0.0.27

0.0.27.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

18/03 2016

0.0.26

0.0.26.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

11/03 2016

0.0.25

0.0.25.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

10/03 2016

0.0.24

0.0.24.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

09/03 2016

0.0.23

0.0.23.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

09/03 2016

dev-feature/lifecyle-function-support

dev-feature/lifecyle-function-support

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

08/03 2016

0.0.22

0.0.22.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

04/03 2016

0.0.21

0.0.21.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

03/03 2016

0.0.20

0.0.20.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

03/03 2016

0.0.19

0.0.19.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

03/03 2016

0.0.18

0.0.18.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

03/03 2016

0.0.17

0.0.17.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

02/03 2016

0.0.16

0.0.16.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

29/01 2016

0.0.15

0.0.15.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.14

0.0.14.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.13

0.0.13.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.11

0.0.11.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.12

0.0.12.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.10

0.0.10.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.9

0.0.9.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.8

0.0.8.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.7

0.0.7.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.6

0.0.6.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.5

0.0.5.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

26/01 2016

0.0.4

0.0.4.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

19/01 2016

0.0.3

0.0.3.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

14/01 2016

0.0.2

0.0.2.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

15/12 2015

0.0.1

0.0.1.0

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source

21/09 2015

0.0.1-beta.1

0.0.1.0-beta1

Mapbender data source handler

  Sources   Download

MIT

The Requires

 

data mapbender data source