check_model.py doesn't provide any useful sql code

[gmauro]

We executed the check_model.py script against our DB and we got a not much useful message. The script is reporting 3 indexes are missing but isn't providing any sql code to fix the issue (or fix it by itself).

(venv) galaxy@sn04:~/server/scripts$ python check_model.py -c ../config/galaxy.yml
/opt/galaxy/venv/lib64/python3.6/site-packages/sqlalchemy/dialects/postgresql/base.py:3426: SAWarning: Predicate of partial index ix_partial_both ignored during reflection
  % idx_name
/opt/galaxy/venv/lib64/python3.6/site-packages/sqlalchemy/dialects/postgresql/base.py:3426: SAWarning: Predicate of partial index ix_partial_job_state__default_ ignored during reflection
  % idx_name
/opt/galaxy/venv/lib64/python3.6/site-packages/sqlalchemy/dialects/postgresql/base.py:3426: SAWarning: Predicate of partial index ix_partial_job_state_new ignored during reflection
  % idx_name
[
    [
        "ix_workflow_step_input_workflow_step_id_name_unique",
        "workflow_step_input",
        [
            "name",
            "workflow_step_id"
        ]
    ],
    [
        "ix_history_importing",
        "history",
        "importing"
    ],
    [
        "ix_job_params",
        "job",
        "params"
    ]
]

[nsoranzo]

For these 3:

• CREATE UNIQUE INDEX ix_workflow_step_input_workflow_step_id_name_unique ON workflow_step_input (name, workflow_step_id);
• CREATE INDEX ix_history_importing ON history (importing);
• CREATE INDEX ix_job_params ON job (params);

[gmauro]

Thanks @nsoranzo