Add ref_url column to the buildset reporter table
This change adds a ref_url column to the zuul_buildset sql table to be able
to render change/ref url when querying buildset.
Change-Id: I91a9a3e5e3b362885e36fa0993b07c750adc69d3
diff --git a/tests/unit/test_connection.py b/tests/unit/test_connection.py
index 4214e9f..de3b7cf 100644
--- a/tests/unit/test_connection.py
+++ b/tests/unit/test_connection.py
@@ -69,7 +69,7 @@
insp = sa.engine.reflection.Inspector(
self.connections.connections['resultsdb'].engine)
- self.assertEqual(10, len(insp.get_columns(buildset_table)))
+ self.assertEqual(11, len(insp.get_columns(buildset_table)))
self.assertEqual(10, len(insp.get_columns(build_table)))
def test_sql_results(self):
@@ -109,6 +109,8 @@
self.assertEqual('SUCCESS', buildset0['result'])
self.assertEqual('Build succeeded.', buildset0['message'])
self.assertEqual('tenant-one', buildset0['tenant'])
+ self.assertEqual('https://hostname/%d' % buildset0['change'],
+ buildset0['ref_url'])
buildset0_builds = conn.execute(
sa.sql.select([reporter.connection.zuul_build_table]).