aboutsummaryrefslogtreecommitdiffstats
path: root/lib/python2.7/site-packages/buildbot-0.8.8-py2.7.egg/buildbot/db/migrate/versions/021_fix_postgres_sequences.py
diff options
context:
space:
mode:
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.py52
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()