diff options
author | Sylvain Afchain <sylvain.afchain@enovance.com> | 2013-05-28 17:45:04 +0200 |
---|---|---|
committer | Dolph Mathews <dolph.mathews@gmail.com> | 2013-05-28 16:21:16 -0500 |
commit | 2879d42de12cfb5a141197debbf7eaa53cd6750f (patch) | |
tree | bec76a5b0edb1872ba00e768d6f7118dff2d641d | |
parent | cdfa4d47fb932fe43ed5c3eff689e70145d8e429 (diff) | |
download | keystone-2013.2.b1.tar.gz |
Add index on expires column of the SQL token Backend2013.2.b1
Add migration script to add the index.
bp index-token-expiry
Change-Id: I36934c18979df5037d606d4846b29194750847af
Fixes: bug #1168399
-rw-r--r-- | keystone/common/sql/migrate_repo/versions/024_add_index_to_expires.py | 17 |
1 files changed, 17 insertions, 0 deletions
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 000000000..51073bf3d --- /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) |