Fantoir-datasource

The fantoir-datasource tool allows to import and manage FANTOIR datasource.

Usage

$ fantoir-datasource help

Import FANTOIR database into PostgreSQL

Usage: fantoir-datasource <COMMAND>

Commands:
  fetch     Fetch the last version of the FANTOIR file
  import    Import from FANTOIR file generated by the DGFIP
  promote   Promote an imported FANTOIR table as the current FANTOIR table to use
  wikidata  Query Wikidata SPARQL end-point to enrich FANTOIR information
  query     Query the imported FANTOIR table
  help      Print this message or the help of the given subcommand(s)

Fetch

Check through the data.economie.gouv.fr API the last version available, compare with FANTOIRmmyy file present in working directory (if any). Download it, unzip it if needed.

To force overwrite the file, use fantoir-datasource fetch --overwrite.

Exit code can be used to programmatically know what happened:

Exit codes

Code	Description
0	Fetch operation succeeded
2	Parsing arguments issue (not fetch specific)
4	FANTOIR file already exist and --overwrite not specified
8	Download issue, at filesystem or HTTP level, stderr will provide information for humans or store in a log
n	Exit code from unzip command (man 1 unzip)
127	Error with the unzip process, without knowing the unzip exit code

If the file is extracted and all is fine, the script will print on stdout:

FANTOIR_FILE=FANTOIR1022