[{"_1":2,"_183":-5,"_184":-5},"loaderData",{"_3":4,"_17":18,"_25":26,"_162":163},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7,"_13":14,"_15":16},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","theme","system","contrast","normal","routes/_layout",{"_19":-5,"_20":21,"_22":21,"_23":21,"_24":21},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_27":28,"_29":-5,"_30":11,"_31":11,"_32":33,"_34":35,"_36":-5,"_37":11,"_38":39,"_88":89,"_113":114,"_151":-5,"_152":11,"_153":21,"_154":11,"_155":-5,"_156":11,"_157":-5,"_158":159,"_160":115,"_161":-7},"canonicalUrl","https://hub.docker.com/r/lpoaura/gn2pg/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","lpoaura","reponame","gn2pg","cloudBuildSource","isAutobuildsAvailable","repo",{"_40":41,"_42":43,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":55,"_57":35,"_32":33,"_58":59,"_60":44,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":62,"_69":70,"_71":11,"_72":33,"_73":74,"_79":11,"_80":81,"_85":33,"_86":87},"categories",[],"content_types",[44],"image","date_registered","2021-01-07T22:35:17.250917Z","description","Import tool from GeoNature to a PostgreSQL database through Export module API (client side)","is_private","last_updated","2021-06-13T23:43:56.906756Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[56],"application/vnd.docker.container.image.v1+json","name","pull_count",157,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","**************\n GN2PG Client\n**************\n\n.. image:: https://img.shields.io/badge/python-3.7+-yellowgreen\n :target: https://www.python.org/\n.. image:: https://img.shields.io/badge/PostgreSQL-10+-blue\n :target: https://www.postgresql.org/\n.. image:: https://img.shields.io/badge/packaging%20tool-poetry-important\n :target: https://python-poetry.org/\n.. image:: https://img.shields.io/badge/code%20style-black-black\n :target: https://github.com/psf/black\n.. image:: https://img.shields.io/badge/licence-AGPL--3.0-blue\n :target: https://opensource.org/licenses/AGPL-3.0\n\nThis project provides an import tool between GeoNature_ instances (client side).\nWidely inspired from `ClientApiVN `_\n\n\n.. contents:: Topics\n\n.. warning::\n Actually in development.\n\n\n\n.. image:: ./docs/source/_static/src_gn2pg.png\n :align: center\n :alt: Project logo\n\n\nProject Setup\n=============\n\nGN2PG Client can be installed by running ``pip``. It requires Python 3.7.4# to run.\n\n.. code-block:: bash\n\n pip install gn2pg-client\n\n\nIssues\n======\n\nPlease report any bugs or requests that you have using the `GitHub issue tracker `_!\n\nHowTo\n=====\n\nHelp\n####\n\n.. code-block:: bash\n\n gn2pg_cli --help\n\nInit config file\n################\n\nThis command init a TOML config file within ``~/.gn2pg`` hidden directory (in user ``HOME`` directory), named as you want. PLEASE DO NOT SPECIFY PATH!\n\n.. code-block:: bash\n\n gn2pg_cli --init \n\n\nConfig file is structured as this. ``[[source]]`` block can be duplicate as many as needed (one block for each source).\n\n.. code-block:: TOML\n\n # GN2PG configuration file\n\n # Local db configuration\n [db]\n db_host = \"localhost\"\n db_port = 5432\n db_user = \"\"\n db_password = \"\"\n db_name = \"\"\n db_schema_import = \"schema\"\n # Additional connection options (optional)\n [db.db_querystring]\n sslmode = \"prefer\"\n\n\n # Source configuration, \n # Ducplicate this block for each source (1 source = 1 export)\n [[source]]\n # Source name, will be use to tag stored data in import table\n name = \"Source1\"\n # GeoNature source login\n user_name = \"\"\n # GeoNature source password\n user_password = \"\"\n # GeoNature source URL\n url = \"\"\n # GeoNature source Export id\n export_id = 1\n # Data type is facultative. By default the value is 'synthese'. Therefore, triggers from to_gnsynthese.sql are not activated.\n # If you want to insert your date into a GeoNature database please choose either 'synthese_with_cd_nomenclature' or 'synthese_with_label'.\n # If not, delete the line.\n data_type = \"synthese_with_cd_nomenclature\"\n\n\n [[source]]\n # Source configuration\n name = \"Source2\"\n user_name = \"\"\n user_password = \"\"\n url = \"\"\n export_id = 1\n data_type = \"synthese_with_cd_nomenclature\"\n\n\n\n.. tip::\n\n You can add variable in source block ``enable = false`` to disable a source\n\n \nInitDB Schema and tables\n#########################\n\nTo create json tables where datas will be downloaded, run : \n\n.. code-block:: bash\n\n gn2pg_cli --json-tables-create \n\n\nFull download\n#############\n\nTo full download json datas into synthese_json table, run : \n\n.. code-block:: bash\n\n gn2pg_cli --full \n\nIncremental download\n####################\n\n.. warning::\n\n [WIP] Not yet implemented!\n\n\nLogs\n####\n\nLog files are stored in ``$HOME/.gn2pg/log`` directory.\n\nImport datas into GeoNature datas\n#################################\n\nDefault script to auto populate GeoNature is called \"to_gnsynthese\". \n\n.. code-block:: bash\n\n gn2pg_cli --custom-script to_gnsynthese \n\n\n.. tip::\n\n You can also replacing synthese script by your own scripts, using file path instead of ``to_gnsynthese``.\n\n\nContributing\n============\n\nAll devs must be done in forks. \n\nPull requests must be pulled to `dev` branch. For example with this command:\n\n.. code-block:: bash\n\n gh repo fork --clone lpoaura/gn2pg_client\n\n\nInstall project and development requirements (require `poetry `_):\n\n.. code-block:: bash\n\n poetry install\n\nMake your devs and pull requests.\n\nRun `gn2pg_cli` command in dev mode\n\n.. code-block:: bash\n\n poetry run gn2pg_cli \n\nRenew requirements file for non poetry developers\n#################################################\n\n.. code-block:: bash\n\n poetry export -f requirements.txt > requirements.txt\n\n\nLicence\n=======\n\n`GNU AGPLv3 `_\n\nTeam\n====\n\n* `@lpofredc `_ (`LPO Auvergne-Rhône-Alpes `_), main developper\n\n\n.. image:: https://raw.githubusercontent.com/lpoaura/biodivsport-widget/master/images/LPO_AuRA_l250px.png\n :align: center\n :height: 100px\n :alt: Logo LPOAuRA\n\n.. _GeoNature: https://geonature.fr/\n\n------------\n\nWith the financial support of the `DREAL Auvergne-Rhône-Alpes `_.\n\n.. image:: https://data.lpo-aura.org/web/images/blocmarque_pref_region_auvergne_rhone_alpes_rvb_web.png\n :align: center\n :height: 100px\n :alt: Logo DREAL AuRA","has_starred","hub_user","immutable_tags_settings",{"_75":11,"_76":77},"enabled","rules",[78],".*","is_automated","permissions",{"_82":21,"_83":11,"_84":11},"read","write","admin","user","storage_size",235413444,"orgData",{"_90":91,"_92":93,"_94":95,"_96":33,"_97":98,"_99":100,"_101":102,"_103":104,"_105":106,"_107":108,"_109":110,"_111":110,"_112":21},"id","efbd657679df460493c472aa2eb77d17","uuid","efbd6576-79df-4604-93c4-72aa2eb77d17","type","organization","orgname","full_name","LPO Auvergne-Rhône-Alpes","location","Lyon","company","LPO Agir pour la biodiversité (AuRA)","profile_url","https://auvergne-rhone-alpes.lpo.fr/","date_joined","2019-11-12T09:27:32.649418Z","gravatar_url","https://www.gravatar.com/avatar/1462fe5cb44a498db3f8088396be19a2?s=80&r=g&d=mm","gravatar_email","","badge","is_active","recentTags",[115],{"_116":44,"_117":118,"_119":120,"_90":121,"_122":123,"_50":140,"_141":118,"_142":33,"_143":56,"_57":144,"_145":146,"_147":131,"_148":140,"_149":66,"_150":21},"content_type","creator",8261465,"full_size",74291647,132430652,"images",[124],{"_125":126,"_127":128,"_129":110,"_130":131,"_132":133,"_134":135,"_136":110,"_137":-5,"_138":120,"_63":66,"_139":-5},"architecture","amd64","digest","sha256:7c9019473ce368d1dc0083cd66f02aee2acd0fc61f5d770ec5e5509fa31d73b7","features","last_pulled","2026-10-13T11:03:10.026789404Z","last_pushed","2021-06-13T23:43:57Z","os","linux","os_features","os_version","size","variant","2021-06-13T23:43:56.586184Z","last_updater","last_updater_username","media_type","latest-dev","repository",10637875,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"selectedTag","attestationsUrl","routes/_layout.r.$namespace.$reponame.tags",{"_38":164,"_171":172,"_158":181,"_182":11},{"_40":165,"_42":166,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":167,"_57":35,"_32":33,"_58":59,"_60":44,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":62,"_69":70,"_71":11,"_72":33,"_73":168,"_79":11,"_80":170,"_85":33,"_86":87},[],[44],[56],{"_75":11,"_76":169},[78],{"_82":21,"_83":11,"_84":11},"tags",{"_173":64,"_174":-5,"_175":-5,"_176":177},"count","next","previous","results",[178],{"_116":44,"_117":118,"_119":120,"_90":121,"_122":179,"_50":140,"_141":118,"_142":33,"_143":56,"_57":144,"_145":146,"_147":131,"_148":140,"_149":66,"_150":21},[180],{"_125":126,"_127":128,"_129":110,"_130":131,"_132":133,"_134":135,"_136":110,"_137":-5,"_138":120,"_63":66,"_139":-5},[],"canDeleteTags","actionData","errors"]

lpoaura/gn2pg

Tags for lpoaura/gn2pg