hdx-data-freshness-dbclean 1.0.2

Description:

hdxdatafreshnessdbclean 1.0.2

Utility to clean Freshness Database




DEPRECATED - code moved to https://github.com/OCHA-DAP/hdx-data-freshness
This script cleans the freshness database.
Usage
python -m hdx.freshness.dbactions [-db/--db_uri=] [-dp/--db_params=] [action]

Either db_uri or db_params must be provided or the environment variable DB_URI
must be set. db_uri or DB_URI are of form:
postgresql+psycopg://user:password@host:port/database
db_params is of form:
database=XXX,host=X.X.X.X,username=XXX,password=XXX,port=1234, ssh_host=X.X.X.X,ssh_port=1234,ssh_username=XXX, ssh_private_key=/home/XXX/.ssh/keyfile
action:


"clone" which creates a shallow clone of the database which only
has all the runs and one dataset and its resources per run for testing
purposes.


"clean" (the default) cleans the database by removing runs according to these
rules:

Keep a handful of runs around the end of each quarter all the way back to
the first run in 2017
Keep daily runs going back 2 years
Keep weekly runs from 2 to 4 years back
Keep monthly runs for 4 years back and earlier