jsor/doctrine-postgis

What's Changed

• Fixed POINT notation in README by @cheack in #71
• DBAL v4, Middleware, Driver, Platform, and SchemaManager implementation by @GwendolenLynch in #61
• Support for PostGIS 3.2, 3.4 & 3.6 testing by @GwendolenLynch in #67

New Contributors

• @cheack made their first contribution in #71
• @GwendolenLynch made their first contribution in #61

Full Changelog: v2.3.0...v2.4.0

• Switch to platform options from deprecated custom schema options. Thanks @sasa-b (#64).
• Better compatibility with different Doctrine ORM versions.

• Switch to platform options from deprecated custom schema options. Thanks @sasa-b (#64).
• Better compatibility with different Doctrine ORM versions.

• Make handling create table sql simple and robust. Reuse native Platform::getCreateTableSQL() instead of copying the code from Doctrine.
• Skip create table generation if a table has no spatial indexes.

• Make handling create table sql simple and robust. Reuse native Platform::getCreateTableSQL() instead of copying the code from Doctrine.
• Skip create table generation if a table has no spatial indexes.

• Remove persistent Connection/SchemaManager instance from event listeners.
  The event listeners now always use the connection instance provided by the
  event args.

• Remove persistent Connection/SchemaManager instance from event listeners. The event listeners now always use the connection instance provided by the event args.

2.0.0 - 2021-10-07

New major release which introduces a new dependency version support matrix.

Other Changes

• The following DQL functions have been removed, mostly because they are also no longer available in PostGIS:

  • ST_MakeBox3D (use ST_3DMakeBox instead)
  • ST_AsKML
  • ST_Distance_Sphere (use ST_DistanceSphere instead)
  • ST_Distance_Spheroid (use ST_DistanceSpheroid instead)
  • ST_Length3D (use ST_3DLength instead)
  • ST_Length_Spheroid (use ST_LengthSpheroid instead)
  • ST_Length2D_Spheroid
  • ST_Shift_Longitude (use ST_ShiftLongitude instead)

• The dummy RasterType has been removed. Register a custom type mapping instead, e.g. $platform->registerDoctrineTypeMapping('raster', 'string').

• Add parameter and return type declarations.

• Switch from Travis CI to GitHub Actions for running CI pipeline.

• Add Docker setup to allow running tests against the different supported PostgreSQL / PostGIS versions.

New major release which introduces a new dependency version support matrix.

Other Changes

• The following DQL functions have been removed, mostly because they are also no
  longer available in PostGIS:

  • ST_MakeBox3D (use ST_3DMakeBox instead)
  • ST_AsKML
  • ST_Distance_Sphere (use ST_DistanceSphere instead)
  • ST_Distance_Spheroid (use ST_DistanceSpheroid instead)
  • ST_Length3D (use ST_3DLength instead)
  • ST_Length_Spheroid (use ST_LengthSpheroid instead)
  • ST_Length2D_Spheroid
  • ST_Shift_Longitude (use ST_ShiftLongitude instead)

• The dummy RasterType has been removed. Register a custom type mapping
  instead, e.g. $platform->registerDoctrineTypeMapping('raster', 'string').

• Add parameter and return type declarations.

• Switch from Travis CI to GitHub Actions for running CI pipeline.

• Add Docker setup to allow running tests against the different supported
  PostgreSQL / PostGIS versions.

This release now allows installation on PHP 8.

Note: While it is possible to install this library on PHP 8, it is not officially support right now. Use with care and at your own risk.

• This release now allows installation on PHP 8.

  Note: While it is possible to install this library on PHP 8, it is not officially support right now. Use with care and at your own risk.

• This release drops support for the EOL versions of PHP 5.3, 5.4 and 5.5.

• This release drops support for the EOL versions of PHP 5.3, 5.4 and 5.5.

• Fix: Remove setting unsupported primary option when creating the Doctrine\DBAL\Schema\Column object. This prevents triggering a deprecation error for DBAL >= 2.7. Thanks @simonwelsh (#38).
• Feature: Run test against PHP 7.2. Thanks @carusogabriel (#35).

• Fix: Remove setting unsupported primary option when creating the Doctrine\DBAL\Schema\Column object. This prevents triggering a deprecation error for DBAL >= 2.7. Thanks @simonwelsh (#38).
  • Feature: Run test against PHP 7.2. Thanks @carusogabriel (#35).

• Feature: New functions ST_DistanceSphere, ST_DistanceSpheroid and ST_LengthSpheroid. Those functions should be used in PostGIS 2.2 and onwards instead of the deprecated functions ST_Distance_Sphere, ST_Distance_Spheroid and ST_Length_Spheroid. Thanks to @JunkMyFunk for the report (#32).
• Feature: Tests now use namespaced classes from PHPUnit. Thanks @carusogabriel (#33).

• Feature: New functions ST_DistanceSphere, ST_DistanceSpheroid and ST_LengthSpheroid. Those functions should be used in PostGIS 2.2 and onwards instead of the deprecated functions ST_Distance_Sphere, ST_Distance_Spheroid and ST_Length_Spheroid. Thanks to @JunkMyFunk for the report (#32).
  • Feature: Tests now use namespaced classes from PHPUnit. Thanks @carusogabriel (#33).

• Fix: Ensure SRID values from metadata are casted to int to prevent unecessary schema diffs when using XML mappings. Thanks to @HenningCash for the report (#30).

• Fix: Ensure SRID values from metadata are casted to int to prevent unecessary schema diffs when using XML mappings. Thanks to @HenningCash for the report (#30).

• Feature: New function ST_AddPoint. Thanks @ltsstar (#26).
  • Feature: New function Geography.

• Feature: New function Geometry. Thanks @dragosprotung (#22).

• Feature: New function ST_SnapToGrid. Thanks @dragosprotung (#21).

• Fix: Fix handling of table and column names using reserved words. Thanks to @maximilian-walter for reporting (#19).

• Fix: The event subscribers now allow multiple calls to postConnect for the same connection instance. This is done by MasterSlaveConnection for example when switching master/slave connections. Thanks to @gcavana for reporting, patch courtesy of @NoiseByNorthwest in #17.

• Feature: New raster DBAL type. Note: This type is not suited to be used in entity mappings. It just prevents "Unknown database type..." exceptions thrown during database inspections by the schema tool.

• First stable release.