entrouvert
/
wcs-olap
16
0
Fork 0
Code Issues Pull Requests Releases Activity
190 Commits 6 Branches 81 Tags 385 KiB
Python 99.8%
Shell 0.2%
Go to file
Benjamin Dauvergne 05c4031776 feeder: prevent situation of half-dropped schema (#54658) 
To prevent loosing currently loaded data wcs-olap, failing ro rename the
temporary schema to its final name, wcs-olap will:

- first, inside a transaction, rename the current schema instead of
  dropping it, then rename the new schema to the current schema's name;
  in case of failure it will retry 33 times sleeping 1 second between
  each attempt;

- if successfull, drop the renamed old schema, again in a retry loop, if
  it fails to drop it logs an error, without aborting the current
  feeding.
 		2021-08-17 23:07:54 +02:00
debian debian: adapt dependency overriding to python3 (#41303) 2020-04-03 11:17:24 +02:00
tests feeder: add option post-sync-commands (#56164) 2021-08-14 23:41:16 +02:00
wcs_olap feeder: prevent situation of half-dropped schema (#54658) 2021-08-17 23:07:54 +02:00
Jenkinsfile build: update to use origin/main 2020-12-26 15:21:15 +01:00
MANIFEST.in remove create_dates.sql from install files 2017-02-28 09:49:47 +01:00
README.rst declare geolocation fields in schema files (fixes #14572) 2017-03-01 17:01:11 +01:00
get_wcs.sh trivial: use https to download wcs for tests (via #46904#note-2) 2020-09-24 19:57:39 +02:00
pylint.sh jenkins: adopt authentic way of doing tox.ini and Jenkinsfile 2020-06-26 11:40:21 +02:00
setup.py migrate to python3 (#39430) 2020-01-30 23:33:16 +01:00
tox.ini misc: integrate with sentry (#56038) 2021-08-07 15:35:30 +02:00

README.rst 

w.c.s. OLAP
~~~~~~~~~~~

Tool to export w.c.s. data in a database with star schema for making an OLAP
cube.

::

        usage: wcs-olap [--no-feed] [-a | --url URL] [-h] [--orig ORIG] [--key KEY]
                        [--pg-dsn PG_DSN] [--schema SCHEMA]
                        [config_path]

        Export W.C.S. data as a star schema in a postgresql DB

        positional arguments:
          config_path

        optional arguments:
          --no-feed        only produce the model
          -a, --all        synchronize all wcs
          --url URL        url of the w.c.s. instance
          -h, --help       show this help message and exit
          --orig ORIG      origin of the request for signatures
          --key KEY        HMAC key for signatures
          --pg-dsn PG_DSN  Psycopg2 DB DSN
          --schema SCHEMA  schema name

Requirements
------------

PostgreSQL > 9.4 is required.