Triggers to Delete/Upsert from json to Metadata/Synthese

[lpofredc]

Créer les fonctions et triggers pour mettre à jour la synthèse depuis les données téléchargées

[lpofredc]

Partially done (UPSERT, not DELETE) in v0.0.4-dev.
custom scripts to auto populate GeoNature db or anything else.

gn2gn_cli --custom-script synthese <myconfigfile>

gn2gn_cli --custom-script <mycustomscriptfullpath> <myconfigfile>

https://github.com/lpoaura/gn2gn_client/blob/dev/gn2gn/data/to_geonature.sql

[Adrien-Pajot]

Hi !

I just tested gn2pg and I want to thank you for this great API, it works perfectly ! I can import JSON data from a GeoNature export in my local base. I now want to go further and insert these new data in my gn_sythese.synthese.

In the docs you suggest to run : gn2pg_cli --custom-script to_gnsynthese
It returns :

2021-03-02 10:53:04,892 - CRITICAL - store_postgresql:custom_script - file to_gnsynthese DO NOT EXISTS, exit
Traceback (most recent call last):
File "/home/geonatureadmin/.local/bin/gn2pg_cli", line 8, in
sys.exit(run())
File "/home/geonatureadmin/.local/lib/python3.8/site-packages/gn2pg/main.py", line 268, in run
return main(sys.argv[1:])
File "/home/geonatureadmin/.local/lib/python3.8/site-packages/gn2pg/main.py", line 186, in main
manage_pg.custom_script(args.custom_script)
File "/home/geonatureadmin/.local/lib/python3.8/site-packages/gn2pg/store_postgresql.py", line 363, in custom_script
with open(file) as filecontent:
UnboundLocalError: local variable 'file' referenced before assignment

I checked your repo and here I see the v0.0.4-dev of gn2gn_cli which I suppose is the application of gn2pg between to GeoNature ? But are all the script of gn2gn implemented into gn2pg ?

Please @lpofredc, could you add documentation or explain me how to insert my json data into my gn_synthese.synthese ?

All the very best.

[lpofredc]

Fixed. Default command is:

gn2pg_cli --custom-script to_gnsynthese <myconfig>.toml