/cpp2sqlite

C++ tool to generate sqlite database containing Swiss Healthcare Public Domain Drug Information

Primary LanguageC++GNU General Public License v3.0GPL-3.0

cpp2sqlite

C++ tool to generate sqlite database containing Swiss Healthcare Public Domain Drug Information

History

This tool is a port of aips2sqlite

Requirements

  • Boost
  • C++17
  • sqlite
  • cmake
  • gcc-9
  • g++-9 sudo update-alternatives --install /usr/bin/g++ g++ /usr/bin/g++-9 9
  • xlnt with cmake -DSTATIC=on, also apply swissmedic.patch
  • jq (Command-line JSON processor)
  • json
  • xmllint

Installation

$ git clone
$ git submodule init
$ git submodule update

See build.sh

Usage

cpp2sqlite

./cpp2sqlite --inDir ~/.software/cpp2sqlite/input

deepl translation

_ run build/sappinfo to generate the unique language file.
_ comment in the line 20 of build.sh to do the translations.
_ if there are no errors, then commit intput/deepl.sappinfo.out.fr.txt.

Input Sources

_ AIPS
_ BAG XML
_ Refdata Artikel
_ Refdata Partner
_ Refdata SAI
_ Swissmedic
_ Swissmedic HPC
_ Swissmedic Chargenrückrufe
_ EPha
_ Swisspeddose
_ Sappinfo
_ Drugshortage

Output Sqlite Database

_ amiko_db_de
_ amiko_db_fr

Glossary

_ GTIN