diff options
author | Tobias Henkel <tobias.henkel@bmw.de> | 2018-01-08 13:48:07 +0100 |
---|---|---|
committer | Tobias Henkel <tobias.henkel@bmw.de> | 2018-04-10 15:51:25 +0200 |
commit | 073f5829e3de156e38dbe3afeb511c712ddd8897 (patch) | |
tree | beb198ac14c7f539f9eb25f77da009d8f04be86c /zuul/driver/sql/alembic/versions | |
parent | 5df8eaf1ae4a421f7fb3ebfbed1fa44e30f42ec2 (diff) | |
download | zuul-073f5829e3de156e38dbe3afeb511c712ddd8897.tar.gz |
Also prefix the indexes if needed
At least in postgres the index names are globally defined so we also
need to prefix the indexes if we are working with table prefixes.
Change-Id: Ie21ca82354948ca98d651cca4ae3df694cb374ae
Diffstat (limited to 'zuul/driver/sql/alembic/versions')
-rw-r--r-- | zuul/driver/sql/alembic/versions/20126015a87d_add_indexes.py | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/zuul/driver/sql/alembic/versions/20126015a87d_add_indexes.py b/zuul/driver/sql/alembic/versions/20126015a87d_add_indexes.py index 906df2131..106f16917 100644 --- a/zuul/driver/sql/alembic/versions/20126015a87d_add_indexes.py +++ b/zuul/driver/sql/alembic/versions/20126015a87d_add_indexes.py @@ -39,20 +39,22 @@ def upgrade(table_prefix=''): # To allow a dashboard to show a per-project view, optionally filtered # by pipeline. op.create_index( - 'project_pipeline_idx', prefixed_buildset, ['project', 'pipeline']) + table_prefix + 'project_pipeline_idx', + prefixed_buildset, ['project', 'pipeline']) # To allow a dashboard to show a per-project-change view op.create_index( - 'project_change_idx', prefixed_buildset, ['project', 'change']) + table_prefix + 'project_change_idx', + prefixed_buildset, ['project', 'change']) # To allow a dashboard to show a per-change view - op.create_index('change_idx', prefixed_buildset, ['change']) + op.create_index(table_prefix + 'change_idx', prefixed_buildset, ['change']) # To allow a dashboard to show a job lib view. buildset_id is included # so that it's a covering index and can satisfy the join back to buildset # without an additional lookup. op.create_index( - 'job_name_buildset_id_idx', prefixed_build, + table_prefix + 'job_name_buildset_id_idx', prefixed_build, ['job_name', 'buildset_id']) |