diff --git a/sql/Makefile b/sql/Makefile index ae73de6..9f92954 100644 --- a/sql/Makefile +++ b/sql/Makefile @@ -1,48 +1,49 @@ # Depends: postgresql-client, postgresql-autodoc DBNAME = softwareheritage-scheduler-dev DOCDIR = autodoc SQL_SCHEMA = swh-scheduler-schema.sql -SQLS = $(SQL_SCHEMA) +SQL_DATA = swh-scheduler-data.sql +SQLS = $(SQL_SCHEMA) $(SQL_DATA) PSQL_BIN = psql PSQL_FLAGS = --echo-all -X -v ON_ERROR_STOP=1 PSQL = $(PSQL_BIN) $(PSQL_FLAGS) all: createdb: createdb-stamp createdb-stamp: $(SQL_INIT) createdb $(DBNAME) touch $@ filldb: filldb-stamp filldb-stamp: createdb-stamp cat $(SQLS) | $(PSQL) $(DBNAME) touch $@ dropdb: -dropdb $(DBNAME) dumpdb: swh-scheduler.dump swh-scheduler.dump: filldb-stamp pg_dump -Fc $(DBNAME) > $@ doc: autodoc-stamp $(DOCDIR)/swh-scheduler.pdf autodoc-stamp: filldb-stamp test -d $(DOCDIR)/ || mkdir $(DOCDIR) postgresql_autodoc -d $(DBNAME) -f $(DOCDIR)/swh cp -a $(DOCDIR)/swh-scheduler.dot $(DOCDIR)/swh-scheduler.dot.orig touch $@ $(DOCDIR)/swh-scheduler.pdf: autodoc-stamp dot -T pdf $(DOCDIR)/swh-scheduler.dot > $(DOCDIR)/swh-scheduler.pdf clean: rm -rf *-stamp $(DOCDIR)/ distclean: clean dropdb rm -f swh-scheduler.dump .PHONY: all initdb createdb dropdb doc clean diff --git a/sql/swh-scheduler-data.sql b/sql/swh-scheduler-data.sql new file mode 100644 index 0000000..672ea82 --- /dev/null +++ b/sql/swh-scheduler-data.sql @@ -0,0 +1,52 @@ +insert into task_type( + type, + description, + backend_name, + default_interval, min_interval, max_interval, backoff_factor, + max_queue_length) +values ( + 'swh-loader-mount-dump-and-load-svn-repository', + 'Loading svn repositories from svn dump', + 'swh.loader.svn.tasks.MountAndLoadSvnRepositoryTsk', + '1 day', '1 day', '1 day', 1, + 1000); + +insert into task_type( + type, + description, + backend_name, + default_interval, min_interval, max_interval, backoff_factor, + max_queue_length) +values ( + 'swh-deposit-archive-loading', + 'Loading deposit archive into swh through swh-loader-tar', + 'swh.deposit.loader.tasks.LoadDepositArchiveTsk', + '1 day', '1 day', '1 day', 1, + 1000); + + +insert into task_type( + type, + description, + backend_name, + default_interval, min_interval, max_interval, backoff_factor, + max_queue_length) +values ( + 'swh-deposit-archive-checks', + 'Loading deposit archive into swh through swh-loader-tar', + 'swh.deposit.loader.tasks.ChecksDepositTsk', + '1 day', '1 day', '1 day', 1, + 1000); + +insert into task_type( + type, + description, + backend_name, + default_interval, min_interval, max_interval, backoff_factor, + max_queue_length) +values ( + 'swh-vault-cooking', + 'Cook a Vault bundle', + 'swh.vault.cooking_tasks.SWHCookingTask', + '1 day', '1 day', '1 day', 1, + 10000);