From 2879d42de12cfb5a141197debbf7eaa53cd6750f Mon Sep 17 00:00:00 2001 From: Sylvain Afchain Date: Tue, 28 May 2013 17:45:04 +0200 Subject: Add index on expires column of the SQL token Backend Add migration script to add the index. bp index-token-expiry Change-Id: I36934c18979df5037d606d4846b29194750847af Fixes: bug #1168399 --- .../migrate_repo/versions/024_add_index_to_expires.py | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 keystone/common/sql/migrate_repo/versions/024_add_index_to_expires.py diff --git a/keystone/common/sql/migrate_repo/versions/024_add_index_to_expires.py b/keystone/common/sql/migrate_repo/versions/024_add_index_to_expires.py new file mode 100644 index 00000000..51073bf3 --- /dev/null +++ b/keystone/common/sql/migrate_repo/versions/024_add_index_to_expires.py @@ -0,0 +1,17 @@ +import sqlalchemy as sql + + +def upgrade(migrate_engine): + meta = sql.MetaData() + meta.bind = migrate_engine + token = sql.Table('token', meta, autoload=True) + idx = sql.Index('ix_token_expires', token.c.expires) + idx.create(migrate_engine) + + +def downgrade(migrate_engine): + meta = sql.MetaData() + meta.bind = migrate_engine + token = sql.Table('token', meta, autoload=True) + idx = sql.Index('ix_token_expires', token.c.expires) + idx.drop(migrate_engine) -- cgit