Staging instance, all changes can be removed at any time

Skip to content

sql: Remove no longer used table and function

Antoine Lambert requested to merge anlambert/swh-scheduler:sql-remove-dead-code into master

Database table priority_ratio and function swh_scheduler_nb_priority_tasks are no longer used by swh-scheduler interface so better removing them.

$ createdb swh-scheduler

# using scheduler master branch
$ swh db init-admin --dbname postgresql://anlambert:****@localhost:5432/swh-scheduler scheduler

$ swh db init --dbname postgresql://anlambert:****@localhost:5432/swh-scheduler scheduler
INFO:swh.core.cli.db:Initializing database version to 35 from the scheduler datastore
DONE database for scheduler initialized at version 35

# using scheduler feature branch
$ swh db upgrade --dbname postgresql://anlambert:****@localhost:5432/swh-scheduler --to-version=36 scheduler
INFO:swh.core.db.db_utils:Executing migration script '/home/anlambert/swh/swh-environment/swh-scheduler/build/__editable__.swh.scheduler-2.2.3.dev6+ga98798f-py3-none-any/swh/scheduler/sql/upgrades/36.sql'
Migration to version 36 done

Merge request reports