[Buildbot-commits] [Buildbot] #1860: python < 2.7 generate sdist tarball without sqlalchemy-migrate repo

[Buildbot]

#1860: python < 2.7 generate sdist tarball without sqlalchemy-migrate repo
-----------------------+-----------------------
Reporter:  jollyroger  |       Owner:
    Type:  defect      |      Status:  reopened
Priority:  critical    |   Milestone:  0.8.4
 Version:  master      |  Resolution:
Keywords:  simple      |
-----------------------+-----------------------

Comment (by jollyroger):

 Ok, here's the output(stripped):
 {{{
 buildbot.test.integration.test_upgrade
   TestWeirdChanges
     testUpgradeChangeLinks ...
 NAMES schedulerid schedulerid
 NAMES id id
                                          [ERROR]
     testUpgradeChangeNoRevision ...
 NAMES schedulerid schedulerid
 NAMES id id
                                     [ERROR]
     testUpgradeChangeProperties ...
 NAMES schedulerid schedulerid
 NAMES id id
                                     [ERROR]
     testUpgradeListsAsFilenames ...
 NAMES schedulerid schedulerid
 NAMES id id
                                     [ERROR]
   UpgradeTest075
     test_test ...
 NAMES schedulerid schedulerid
 NAMES id id
                                                       [ERROR]
   UpgradeTestCitools
     test_test ...
 NAMES schedulerid schedulerid
 NAMES id id
                                                       [ERROR]
   UpgradeTestEmpty
     test_emptydb_modelmatches ...
 NAMES schedulerid schedulerid
 NAMES id id
                                       [ERROR]
 buildbot.test.regressions.test_import_unicode_changes
   TestUnicodeChanges
     testAsciiChange ...
 NAMES schedulerid schedulerid
 NAMES id id
                                                 [ERROR]
     testNonUnicodeChange ...
 [OK]
     testUTF16Change ...
 NAMES schedulerid schedulerid
 NAMES id id
                                                 [ERROR]
     testUnicodeChange ...
 NAMES schedulerid schedulerid
 NAMES id id
                                               [ERROR]

 --- skipped ---

 buildbot.test.unit.test_db_model
   DBConnector_Basic
     test_is_current_empty ...
 [OK]
     test_is_current_full ...
 NAMES schedulerid schedulerid
 NAMES id id
                                            [ERROR]
 }}}

 So the case is failing on 'builds' table. I added all absent tables' stubs
 and all the tests were passed.
 (Did some reverse engineering though, so no relations were created). It
 appears that _trial_temp/test.db database is empty (at least after running
 the tests) so there is no way to get table structure by loading table from
 the database.

 Here are stubs I used:

 {{{
 sa.Table("builds", metadata,
     sa.Column('id', sa.Integer, autoincrement=False, primary_key=True),
     sa.Column('number', sa.Integer),
     sa.Column('brid', sa.Integer),
     sa.Column('start_time', sa.Integer),
     sa.Column('finish_time', sa.Integer),
 )

 sa.Table("buildrequests", metadata,
     sa.Column('id', sa.Integer, autoincrement=False, primary_key=True),
     sa.Column('buildsetid', sa.Integer),
     sa.Column('buildername', sa.String(256), nullable=False),
     sa.Column('priority', sa.Integer),
     sa.Column('claimed_at', sa.Integer),
     sa.Column('claimed_by_name', sa.String(256), nullable=False),
     sa.Column('claimed_by_incarnation', sa.String(256), nullable=False),
     sa.Column('complete', sa.Integer),
     sa.Column('results', sa.SmallInteger),
     sa.Column('submitted_at', sa.Integer),
     sa.Column('complete_at', sa.Integer),
 )

 sa.Table("buildsets", metadata,
     sa.Column('id', sa.Integer, autoincrement=False, primary_key=True),
     sa.Column('external_idstring', sa.String(256), nullable=False),
     sa.Column('reason', sa.String(256), nullable=False),
     sa.Column('sourcestampid', sa.Integer),
     sa.Column('submitted_at', sa.Integer),
     sa.Column('complete', sa.SmallInteger),
     sa.Column('complete_at', sa.Integer),
     sa.Column('results', sa.SmallInteger),
 )

 sa.Table("patches", metadata,
     sa.Column('id', sa.Integer, autoincrement=False, primary_key=True),
     sa.Column('patchlevel', sa.Integer),
     sa.Column('patch_base64', sa.Text, nullable=False),
     sa.Column('subdir', sa.Text, nullable=False),
 )
 }}}

-- 
Ticket URL: <http://trac.buildbot.net/ticket/1860#comment:13>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation