diff options
Diffstat (limited to 'lib/python2.7/site-packages/buildbot-0.8.8-py2.7.egg/buildbot/db/migrate/versions/021_fix_postgres_sequences.py')
-rw-r--r-- | lib/python2.7/site-packages/buildbot-0.8.8-py2.7.egg/buildbot/db/migrate/versions/021_fix_postgres_sequences.py | 52 |
1 files changed, 0 insertions, 52 deletions
diff --git a/lib/python2.7/site-packages/buildbot-0.8.8-py2.7.egg/buildbot/db/migrate/versions/021_fix_postgres_sequences.py b/lib/python2.7/site-packages/buildbot-0.8.8-py2.7.egg/buildbot/db/migrate/versions/021_fix_postgres_sequences.py deleted file mode 100644 index f412073d..00000000 --- a/lib/python2.7/site-packages/buildbot-0.8.8-py2.7.egg/buildbot/db/migrate/versions/021_fix_postgres_sequences.py +++ /dev/null @@ -1,52 +0,0 @@ -# This file is part of Buildbot. Buildbot is free software: you can -# redistribute it and/or modify it under the terms of the GNU General Public -# License as published by the Free Software Foundation, version 2. -# -# This program is distributed in the hope that it will be useful, but WITHOUT -# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS -# FOR A PARTICULAR PURPOSE. See the GNU General Public License for more -# details. -# -# You should have received a copy of the GNU General Public License along with -# this program; if not, write to the Free Software Foundation, Inc., 51 -# Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. -# -# Copyright Buildbot Team Members - -import sqlalchemy as sa - -def upgrade(migrate_engine): - # see bug #2119 - - # this only applies to postgres - if migrate_engine.dialect.name != 'postgresql': - return - - metadata = sa.MetaData() - metadata.bind = migrate_engine - - to_fix = [ - 'buildrequests.id', - 'builds.id', - 'buildsets.id', - 'changes.changeid', - 'patches.id', - 'sourcestampsets.id', - 'sourcestamps.id', - 'objects.id', - 'users.uid', - ] - - for col in to_fix: - tbl_name, col_name = col.split('.') - tbl = sa.Table(tbl_name, metadata, autoload=True) - col = tbl.c[col_name] - - res = migrate_engine.execute(sa.select([ sa.func.max(col) ])) - max = res.fetchall()[0][0] - - if max: - seq_name = "%s_%s_seq" % (tbl_name, col_name) - r = migrate_engine.execute("SELECT setval('%s', %d)" - % (seq_name, max)) - r.close() |