Releases: lpoaura/GN2PG
1.6.5
Fixes
- Fix trigger to populate additional data (fix #73).
Version note
If you are using triggers to automatically populate GeoNature database, you should apply new SQL scripts:
pip install --upgrade gn2pg-client
gn2pg_cli --custom-script to_gnsynthese <myconfigfile>
psql -d <database name> -c 'UPDATE gn2pg_import.data_json SET item=item;'
Full Changelog: 1.6.4...1.6.5
1.6.4
1.6.3
What's Changed
- fix #65
Other Changes
New Contributors
- @dependabot made their first contribution in #54
Full Changelog: 1.6.2...1.6.3
1.6.2
Full Changelog: v1.6.1...1.6.2
v1.6.1
v1.6.0
What's Changed
- fix email conflict error on t_roles by not populating email by @lpofredc in #46
- fix Erreur en fin d'update sur 'total_filtered' #49
❗ Caution
If GeoNature sources are on latest versions (v2.13.x), ensure that Utils-Flask-SQLAlchemy is version 0.3.6+ as mentionned in #48.
📝 Update
pip install --upgrade gn2pg-client
If client database is a GeoNature DB, apply last SQL Scripts
gn2pg_cli --custom-script to_gnsynthese <myconfigfile>
Full Changelog: v1.5.1...v1.6.0
v1.5.1
What's Changed
With the financial support of Office français de la biodiversité.
Full Changelog: v1.5.0...v1.5.1
v1.5.0
What's Changed
- Update geonature_export_sinp_with_cd_nomenclature.sql by @pierre56 in #38
- Andriacap feat/flask admin view by @lpofredc in #41
- Feat : flask admin view - Tableau de bord by @andriacap in #39
- Fix/pylint by @andriacap in #43
- v1.5.0 by @lpofredc in #42
❗ The minimum version of the source GeoNature instance required for the incremental update must be a version 2.12.0
With the financial support of Office français de la biodiversité.
New Contributors
- @pierre56 made their first contribution in #38
- @andriacap made their first contribution in #39
Full Changelog: v1.4.0...v1.5.0
v1.4.0
What's Changed
- Feat/parallelisation by @ophdlv in #30
- fix: SADeprecationWarning > Calling URL() directly is deprecated by @lpofredc in #32
- Refactor/tests and optimisation by @ophdlv in #29
- Update README.rst authors by @camillemonchicourt in #34
- Update README.md by @lpofredc in #35
- Changelog 1.4.0 by @camillemonchicourt in #33
- Draft: Improve code quality (PyLint) and french traduction by @lpofredc in #36
- New Github actions Workflows by @lpofredc in #37
New Contributors
- @ophdlv made their first contribution in #30
- @camillemonchicourt made their first contribution in #34
Full Changelog: 1.3.0...v1.4.0
ToDo on update
Unused database table datasets_json
can be dropped:
BEGIN;
DROP TABLE gn2pg_import.datasets_json;
COMMIT;
v1.3.0
Changes
- Add optional query strings on API calls, almost required to order export API using key
orderby
TODO
On client side
pip install --upgrade gn2pg-client
- for those who use gn2pg to populate a GeoNature database, you must apply new
to_gnsynthese.sql
script. To proceed, simply execute:
gn2pg_cli --custom-script to_gnsynthese <yourconfigfile>
You must also update your config file to add a custom query string to order results by id_synthese
as mentionned in template and docs:
# Source configuration,
# Duplicate this block for each source (1 source = 1 export)
[[source]]
# Source name, will be use to tag stored data in import table
name = "Source1"
# GeoNature source login
user_name = "<monuser>"
# GeoNature source password
user_password = "<monPwd>"
# GeoNature source URL
url = "<http://geonature1/>"
# GeoNature source Export id
export_id = 1
data_type = "synthese_with_metadata"
# GeoNature ID application (default is 3)
id_application = 1
# Additional export API QueryStrings to filter or order data, you can add multiple columns by separating column names with ":"
[source.query_strings]
orderby = 'id_synthese'
If you upgrade directly from version before 1.2.0, A unique constraint on utilisateurs.t_roles.uuid_role
is required. A PR have been proposed to PnX-SI/UsersHub-authentification-module#46. Or you can add this manually with this query:
ALTER TABLE utilisateurs.t_roles
ADD CONSTRAINT t_roles_uuid_un_tmp
UNIQUE (uuid_role)
;
On provider side
-
actors identify informations have been restructured in
synthese_with_metadata
view. you must apply new scripts provided in indata/source_sample
. -
Export API with LIMIT OFFSET can return unordered results as mentionned in PostgreSQL documentation, to solve this issue, waiting an official new relase of module [PnX-SI/Utils-Flask-SQLAlchemy], you must patch geonature dependency by changing those lines in file
~/geonature/backend/venv/lib/python3.7/site-packages/utils_flask_sqla/generic.py
with