CHANGES.txt

GeoAlchemy 2 Changelog
======================

0.16.0
------

* Test: Add test in test_functional.py for custom Geometry that uses WKT elements @adrien-berchet (#525)
* Add option to ensure all dialects are properly tested in CI @adrien-berchet (#526)
* Improve MariaDB support @adrien-berchet (#524)

0.15.2
------

* Fix: Can handle negative coordinates with Spatialite @adrien-berchet (#517)

0.15.1
------

* Fix: Default SRID is bypassed when using floating point coordinates @aballet (#509)
* Test: Dispose of the connection pools of the test engines @adrien-berchet (#511)

0.15.0
------

* Specific process for geometries with Z or M coordinate with SpatiaLite dialect @spd5 (#506)
* Chore: Fix type hints on stubs @adrien-berchet (#504)

0.14.7
------

* Allow geometry_type to be None at the type level to match documentation @logankaser (#500)
* CI: Fix Py312 job in tox @adrien-berchet (#501)
* Docs: Add Zenodo badge on the main page @adrien-berchet (#498)

0.14.6
------

* Fix: Fix specific compilation rules for MariaDB @adrien-berchet (#495)

0.14.5
------

* Feat: Add experimental support for MariaDB @tebrown (#491)
* CI: Setup pre-commit.ci @adrien-berchet (#492)

0.14.4
------

* Type: Fix modified check_ctor_args to pass default SRS_ID value in case of null @satyamsoni2211 (#488)
* Build: Add Py312 support @adrien-berchet (#487)

0.14.3
------

* Fix: Handle empty doctrings in optimized mode @adrien-berchet (#484)
* Test: Check for max width and height in raster insertion example @adrien-berchet (#482)

0.14.2
------

* Test: Add a container to run the tests @mbway (#479)
* Feat: Added type stub generation for dynamic functions @mbway (#478)
* Docs: Add new mapping style example in the gallery @adrien-berchet (#473)

0.14.1
------

* Add type annotations @shuttle1987 (#464)
* Test: Minor improvements @adrien-berchet (#465)
* Docs: Add util to replace keywords in docstrings @adrien-berchet (#461)
* Docs: Fix badges and link to docs @adrien-berchet (#460)

0.14.0
------

* Split load_spatialite into load_spatialite_driver and init_spatialite @adrien-berchet (#459)
* Remove the management parameter @adrien-berchet (#415)
* Add GeoPackage support @adrien-berchet (#456)
* CI: Use new action to setup Mamba @adrien-berchet (#455)
* Fix codespell config and typo 'prodived' -> 'provided' @djm93dev (#454)
* Fix ReadTheDocs generation @adrien-berchet (#452)
* Fix compatibility with Alembic>1.11 @adrien-berchet (#447)
* Add Py311 support @adrien-berchet (#446)
* Add an example to insert raster entries in gallery @adrien-berchet (#438)
* fix: handle mysql schemas in column reflection @EtienneDG (#443)
* Fix: Shapely remains optional requirement @adrien-berchet (#441)
* Fix CI @adrien-berchet (#439)
* Add auto extended feature and methods for WKT/WKB conversion from/to extended elements @adrien-berchet (#435)
* setup.py needs to know about subpackages @EdwardBetts (#434)
* Reorganize tests and fix nullable propagation and some other bugs @adrien-berchet (#433)
* Reorganize dialect-specific code @adrien-berchet (#432)
* Add partial MySQL support @adrien-berchet (#330)

0.13.3
------

* Fix compatibility with Alembic>1.11 @adrien-berchet (#449)

0.13.2
------

* Install Python and Pypy using Micromamba in CI @adrien-berchet (#428)
* Move SQLite functions to the relevant module @adrien-berchet (#427)
* Remove schema from the engine used in tests for SQLite dialect @adrien-berchet (#426)
* Improve monkeypatch robustness and related tests in Alembic helpers @adrien-berchet (#425)
* Fix compatibility with SQLAlchemy>=2 @adrien-berchet (#424)


0.13.1
------

* Fix: Use empty event for unsupported dialects @adrien-berchet (#418)

0.13.0
------

* Remove some irrelevant checks for Raster type @adrien-berchet (#418)
* Add precommit and format the code @adrien-berchet (#416)
* Refactor: Reorganize functions into dialect-specific functions @adrien-berchet (#414)
* Add dependabot config @adrien-berchet (#411)
* Use build package in publish job and remove useless wheel config @adrien-berchet (#407)


0.12.5
------

* Fix alembic_helpers.create_geospatial_table() use the proper schema @adrien-berchet (#404)

0.12.4
------

* Fix alembic_helpers.create_geo_table() to handle foreign keys @adrien-berchet (#398)

0.12.3
------

* Replace pkg_resources usage with packaging + importlib.metadata @jacob-indigo (#392)
* Add a test for reflection of a view with spatial columns @adrien-berchet (#391)

0.12.2
------

* Provide alembic_helpers.include_object again @adrien-berchet (#388)
* Change doc font and increase page width @adrien-berchet (#389)
* Fix doc for Alembic helpers @adrien-berchet (#386)

0.12.1
------

* Fix semicolon in index query for postgresql @adrien-berchet (#383)

0.12.0
------

* Improve documentation for functions applied to types other than Geometry @adrien-berchet (#380)
* Improve reflection mechanism and alembic interactions @adrien-berchet (#374)
* Functions returning Box types now return None types instead of Geometry types @EdwardBetts @adrien-berchet (#375)
* Improve the gallery example for TypeDecorator @adrien-berchet (#373)

0.11.1
------

* Improve doc formatting @adrien-berchet (#369)

0.11.0
------

* Add Alembic helpers for Add/Drop spatial columns with SQLite @adrien-berchet (#362)
* Add GitHub URL for PyPi @andriyor (#364)
* Add a simple API to register custom mapping for SQLite function names @adrien-berchet (#360)
* Example of specific compilation for sided buffer with SQLite dialect @adrien-berchet (#361)
* Remove metaclass as in SQLAlchemy, rework the tests and some reformatting @adrien-berchet (#357)
* Use RecoverGeometryColumn instead of AddGeometryColumn with SQLite @adrien-berchet (#354)
* Fix spatial index declaration @adrien-berchet (#344)

0.10.2
------

* Use 'load_dialect_impl()' instead of 'impl' to get the type of the TypeDecorator objects @adrien-berchet (#343)

0.10.1
------

* Fix creation of columns using a TypeDecorator @adrien-berchet (#343)

0.10.0
------

* Fix cache warnings @adrien-berchet (#338)
* Drop support for Python < 3.6 @adrien-berchet (#337)
* Change KeyError into AttributeError in the comparator_factory of CompositeType @adrien-berchet (#335)
* Add SummaryStats type for the ST_SummaryStatsAgg function @adrien-berchet (#334)

0.9.4
-----

* Fix warnings in preparation for SQLAlchemy v2.0 @robintw (#331)

0.9.3
-----

* Add support for not nullable column for SQLite @adrien-berchet (#327)

0.9.2
-----

* Add support for N-D intersects '&&&' operator @dlbrittain (#324)

0.9.1
-----

* Fix quotes in index creation @adrien-berchet (#321)

0.9.0
-----

* Add many missing functions @adrien-berchet (#298)
* Add support for N-D index creation @dlbrittain (#316)

0.8.5
-----

* Add dosctrings to remove sphinx warnings @adrien-berchet (#300)
* Update setup.py to point to new home page location @EdwardBetts (#296)
* Add an internal function registry @adrien-berchet (#293)
* Update CI and tests @adrien-berchet (#286, #287, #303, #307)
* Add doc for functions that are defined for both Geometry and Raster @adrien-berchet (#285)
* Add new examples in the gallery @adrien-berchet (#282, #283, #299)

0.8.4
-----

* Fix ST_AsGeoJSON function @adrien-berchet (#279)
* Add many missing functions @adrien-berchet (#276)

0.8.3
-----

* Use setuptools_scm to manage versions @adrien-berchet (#271)
* Fix insert/update for RasterElement @adrien-berchet (#270)

0.8.2
-----

* Fix __eq__() method in _SpatialElement so it can work with any type @adrien-berchet (#265)

0.8.1
-----

* Fix ReadTheDoc compilation @adrien-berchet

0.8.0
-----

* Fix Shapely requirements for Pypy @adrien-berchet (#262)
* Add a gallery with tests and doc based on examples given in #219, #244 and #251 @adrien-berchet (#260)
* Add support of the feature version of St_AsGeoJson() @adrien-berchet @zzzeek (#258)
* Add __eq__ to WKBElement and make shape.from_shape() able to create extended elements @adrien-berchet @matthew-emw (#247)
* Extract all SQL concepts from Elements and refactor Raster type @adrien-berchet @elemoine @zzzeek (#256)

0.7.0
-----

* Update test matrix removing Python 3.4 and adding 3.6, 3.7, 3.8 @cjmayo (#253)
* Add reflection example in doc @adrien-berchet (#252)
* Fix tests with PostGIS 3 @elemoine (#250)
* Add default compilation rules to elements and functions which are required for SQLAlchemy < 1.1 @adrien-berchet (#242)
* Raise an AttributeError when a function does not starts with ST_* @adrien-berchet @elemoine (#240)
* Replace ST_Distance_Sphere by ST_DistanceSphere @borisuvarov (#237)
* Make shape.to_shape() work for extended WKTElement objects @adrien-berchet (#236)

0.6.3
-----

* Add some missing functions @adrien-berchet (#224)
* Do not register functions.GenericFunction for sqlalchemy>=1.3.4 @adrien-berchet (#226)
* Redefine the geometry_type/dimension consistency checks @elemoine (#228)
* Correct a spelling mistake @EdwardBetts (#229)
* Do not assume the "public" schema @elemoine (#231)
* Add all geometry constructors @adrien-berchet (#232)

0.6.2
-----

* Support WKBElement objects as bind values @elemoine (#221)
* Document the use of spatial functions in primaryjoin conditions @elemoine (#222)

0.6.1
-----

* Change WKBElement to read SRID from the EWKB string @SergeBouchut (#209)
* Change WKTElement to read SRID from the EWKT string @adrien-berchet @elemoine (#211)

0.6.0
-----

* Add AsGeoJSON for SpatiaLite @TomGoBravo @elemoine (#204)
* Remove the use_st_prefix argument and use SpatiaLite-compiled functions @elemoine (#204)

0.5.0
-----

* Add support for function ST_Azimuth @simlmx (#175)
* Remove Python 3.3 from the test matrix @elemoine (#179)
* Correct spelling mistakes @EdwardBetts @elemoine (#180)
* Make WKTElement and WKBElement pickable @elemoine (#182)
* Add SpatiaLite support @elemoine (#181)
* Fix to_shape with SpatiaLite @elemoine (#185)

0.4.2
-----

* Fix ST_LineLocatePoint return type @fredj (#170)

0.4.1
-----

* Fix docstring for overlaps_or_above @dcere (#166)
* Add a WKTElement extended example @movermeyer (#164)
* Add checks to _GISType constructor @elemoine (#162)
* Support geometry column with no typmod @elemoine (#161)
* Add ST_AsTWKB function. @JacobHayes (#146)
* Create MANIFEST.in. @pmlandwher (#147)
* Fix build_sphinx maximum recursion depth. @ifedapoolarewaju (#148)
* Fix typo in elements code. @elemoine (#153)

0.4.0
-----

* Adapt links for "Read the Docs". @adamchainz (#134)
* Simplify and fix tests. @elemoine (#138)
* Set result_type when using operators. @elemoine (#140)
* Add use_typmod option for AddGeometryColumn. @tsauerwein (#141)

0.3.0
-----

* Read geometries with ST_AsEWKB. @loicgasser, @fredj, @elemoine (#122)
* Fix SpatialElement.__str__ on Python 3 @b11z, @elemoine (#130)
* Fix flake8 in tests @loicgrasser (#125)

0.2.6
-----

* Distribute GeoAlchemy as wheels (#114)

0.2.5
-----

* PyPy Support (#79)
* Wrap column name in double-quotes (#83)
* Add ST_Z, ST_AsEWKB and ST_AsEWKT functions (#91)
* Python 3 Support (#99)
* Travis config changes (#100, #102)

0.2.4
-----

* SQLAlchemy 0.9.4 compatibility. @quiqua (#75 and #76)

0.2.3
-----

* Add ST_Simplify. @nik-cars (#68)
* SQLAlchemy 0.9 compatibility. @ilj (#59)

0.2.2
-----

* Support EWKT and working with DBAPI's executemany(). Addresses issues
  reported by @pgiraud. @elemoine (#62)

0.2.1
-----

* Fix bug where AddGeometryColumn and DropGeometryColumn were not given
  the actual schema of the table @dolfandringa (#55)

0.2
---

* ST_Dump support @Turbo87 (#18)
* Use of Travis CI and coveralls.io @Turbo87
* New doc theme, new logo @Turbo87 (#23)
* PostGIS 2 Raster support @Turbo87 (#25)

0.1
---

* Initial release (PostGIS 2 support, Geometry et Geography types)