def selectDifferenceType(self, parent_version=None, derived_version=None):
"""Execute the SQL expression to compute `DistroSeriesDifferenceType`.
:param parent_version: The parent series' last released version
of a package, if any.
:param derived_version: The derived series' last released
version of the same package, if any.
:return: A numeric `DistroSeriesDifferenceType` value.
"""
query = """
SELECT %s FROM (
SELECT %s AS source_version, %s AS parent_source_version
) AS input""" % (
compose_sql_difference_type(),
quote(derived_version),
quote(parent_version),
)
cur = cursor()
cur.execute(query)
result = cur.fetchall()
self.assertEqual(1, len(result))
self.assertEqual(1, len(result[0]))
return result[0][0]
def selectDifferenceType(self, parent_version=None, derived_version=None):
"""Execute the SQL expression to compute `DistroSeriesDifferenceType`.
:param parent_version: The parent series' last released version
of a package, if any.
:param derived_version: The derived series' last released
version of the same package, if any.
:return: A numeric `DistroSeriesDifferenceType` value.
"""
query = """
SELECT %s FROM (
SELECT %s AS source_version, %s AS parent_source_version
) AS input""" % (
compose_sql_difference_type(),
quote(derived_version),
quote(parent_version),
)
cur = cursor()
cur.execute(query)
result = cur.fetchall()
self.assertEqual(1, len(result))
self.assertEqual(1, len(result[0]))
return result[0][0]
def test_baseline(self):
query = compose_sql_difference_type()
self.assertIsInstance(query, basestring)
def test_baseline(self):
query = compose_sql_difference_type()
self.assertIsInstance(query, basestring)
