from db_test import DBDakTestCase
-from daklib.dbconn import Architecture, Suite, get_suite_architectures, \
- get_architecture_suites, Maintainer, DBSource, Location, PoolFile, \
- check_poolfile, get_poolfile_like_name, get_source_in_suite, \
- get_suites_source_in, add_dsc_to_db, source_exists, DBBinary, \
- get_suites_binary_in, add_deb_to_db
+from daklib.dbconn import *
from daklib.queue_install import package_to_suite
-from daklib.queue import get_newest_source, get_suite_version
+from daklib.queue import get_newest_source, get_suite_version_by_source, \
+ get_source_by_package_and_suite, get_suite_version_by_package
from sqlalchemy.orm.exc import MultipleResultsFound
import unittest
database.
"""
- def setup_suites(self):
- "setup a hash of Suite objects in self.suite"
-
- if 'suite' in self.__dict__:
- return
- self.suite = {}
- for suite_name in ('lenny', 'squeeze', 'sid'):
- self.suite[suite_name] = Suite(suite_name = suite_name, version = '-')
- self.session.add_all(self.suite.values())
-
- def setup_architectures(self):
- "setup Architecture objects in self.arch and connect to suites"
-
- if 'arch' in self.__dict__:
- return
- self.setup_suites()
- self.arch = {}
- for arch_string in ('source', 'all', 'i386', 'amd64', 'kfreebsd-i386'):
- self.arch[arch_string] = Architecture(arch_string)
- if arch_string != 'kfreebsd-i386':
- self.arch[arch_string].suites = self.suite.values()
- else:
- self.arch[arch_string].suites = [self.suite['squeeze'], self.suite['sid']]
- # hard code ids for source and all
- self.arch['source'].arch_id = 1
- self.arch['all'].arch_id = 2
- self.session.add_all(self.arch.values())
-
- def setup_locations(self):
- 'create some Location objects, TODO: add component'
-
- if 'loc' in self.__dict__:
- return
- self.loc = {}
- self.loc['main'] = Location(path = \
- '/srv/ftp-master.debian.org/ftp/pool/')
- self.loc['contrib'] = Location(path = \
- '/srv/ftp-master.debian.org/ftp/pool/')
- self.session.add_all(self.loc.values())
-
- def setup_poolfiles(self):
- 'create some PoolFile objects'
-
- if 'file' in self.__dict__:
- return
- self.setup_locations()
- self.file = {}
- self.file['hello_2.2-3.dsc'] = PoolFile(filename = 'main/h/hello/hello_2.2-3.dsc', \
- location = self.loc['main'], filesize = 0, md5sum = '')
- self.file['hello_2.2-2.dsc'] = PoolFile(filename = 'main/h/hello/hello_2.2-2.dsc', \
- location = self.loc['main'], filesize = 0, md5sum = '')
- self.file['hello_2.2-1.dsc'] = PoolFile(filename = 'main/h/hello/hello_2.2-1.dsc', \
- location = self.loc['main'], filesize = 0, md5sum = '')
- self.file['hello_2.2-1_i386.deb'] = PoolFile( \
- filename = 'main/h/hello/hello_2.2-1_i386.deb', \
- location = self.loc['main'], filesize = 0, md5sum = '')
- self.file['gnome-hello_2.2-1_i386.deb'] = PoolFile( \
- filename = 'main/h/hello/gnome-hello_2.2-1_i386.deb', \
- location = self.loc['main'], filesize = 0, md5sum = '')
- self.file['sl_3.03-16.dsc'] = PoolFile(filename = 'main/s/sl/sl_3.03-16.dsc', \
- location = self.loc['main'], filesize = 0, md5sum = '')
- self.file['python2.6_2.6.6-8.dsc'] = PoolFile( \
- filename = 'main/p/python2.6/python2.6_2.6.6-8.dsc', \
- location = self.loc['main'], filesize = 0, md5sum = '')
- self.session.add_all(self.file.values())
-
- def setup_maintainers(self):
- 'create some Maintainer objects'
-
- if 'maintainer' in self.__dict__:
- return
- self.maintainer = {}
- self.maintainer['maintainer'] = Maintainer(name = 'Mr. Maintainer')
- self.maintainer['uploader'] = Maintainer(name = 'Mrs. Uploader')
- self.maintainer['lazyguy'] = Maintainer(name = 'Lazy Guy')
- self.session.add_all(self.maintainer.values())
-
- def setup_sources(self):
- 'create DBSource objects'
-
- if 'source' in self.__dict__:
- return
- self.setup_maintainers()
- self.setup_suites()
- self.setup_poolfiles()
- self.source = {}
- self.source['hello_2.2-2'] = DBSource(source = 'hello', version = '2.2-2', \
- maintainer = self.maintainer['maintainer'], \
- changedby = self.maintainer['uploader'], \
- poolfile = self.file['hello_2.2-2.dsc'], install_date = self.now())
- self.source['hello_2.2-2'].suites.append(self.suite['sid'])
- self.source['hello_2.2-1'] = DBSource(source = 'hello', version = '2.2-1', \
- maintainer = self.maintainer['maintainer'], \
- changedby = self.maintainer['uploader'], \
- poolfile = self.file['hello_2.2-1.dsc'], install_date = self.now())
- self.source['hello_2.2-1'].suites.append(self.suite['sid'])
- self.source['sl_3.03-16'] = DBSource(source = 'sl', version = '3.03-16', \
- maintainer = self.maintainer['maintainer'], \
- changedby = self.maintainer['uploader'], \
- poolfile = self.file['sl_3.03-16.dsc'], install_date = self.now())
- self.source['sl_3.03-16'].suites.append(self.suite['squeeze'])
- self.source['sl_3.03-16'].suites.append(self.suite['sid'])
- self.session.add_all(self.source.values())
-
- def setup_binaries(self):
- 'create DBBinary objects'
-
- if 'binary' in self.__dict__:
- return
- self.setup_sources()
- self.setup_architectures()
- self.binary = {}
- self.binary['hello_2.2-1_i386'] = DBBinary(package = 'hello', \
- source = self.source['hello_2.2-1'], version = '2.2-1', \
- maintainer = self.maintainer['maintainer'], \
- architecture = self.arch['i386'], \
- poolfile = self.file['hello_2.2-1_i386.deb'])
- self.binary['hello_2.2-1_i386'].suites.append(self.suite['squeeze'])
- self.binary['hello_2.2-1_i386'].suites.append(self.suite['sid'])
- self.binary['gnome-hello_2.2-1_i386'] = DBBinary(package = 'gnome-hello', \
- source = self.source['hello_2.2-1'], version = '2.2-1', \
- maintainer = self.maintainer['maintainer'], \
- architecture = self.arch['i386'], \
- poolfile = self.file['gnome-hello_2.2-1_i386.deb'])
- self.binary['gnome-hello_2.2-1_i386'].suites.append(self.suite['squeeze'])
- self.binary['gnome-hello_2.2-1_i386'].suites.append(self.suite['sid'])
- self.session.add_all(self.binary.values())
-
def setUp(self):
super(PackageTestCase, self).setUp()
self.setup_binaries()
main = self.loc['main']
contrib = self.loc['contrib']
self.assertEqual('/srv/ftp-master.debian.org/ftp/pool/', main.path)
- count = len(self.file.keys())
+ count = len(self.file.keys()) - 2
self.assertEqual(count, main.files.count())
- self.assertEqual(0, contrib.files.count())
+ self.assertEqual(2, contrib.files.count())
poolfile = main.files. \
filter(PoolFile.filename.like('%/hello/hello%')). \
order_by(PoolFile.filename)[0]
main.files.remove(self.file['sl_3.03-16.dsc'])
contrib.files.append(self.file['sl_3.03-16.dsc'])
self.assertEqual(count - 1, main.files.count())
- self.assertEqual(1, contrib.files.count())
+ self.assertEqual(3, contrib.files.count())
# test fullpath
self.assertEqual('/srv/ftp-master.debian.org/ftp/pool/main/s/sl/sl_3.03-16.dsc', \
self.file['sl_3.03-16.dsc'].fullpath)
self.assertEqual((True, self.file['sl_3.03-16.dsc']), \
check_poolfile('main/s/sl/sl_3.03-16.dsc', 0, '', \
contrib.location_id, self.session))
+ # test string value of 2nd argument
+ self.assertEqual((True, self.file['sl_3.03-16.dsc']), \
+ check_poolfile('main/s/sl/sl_3.03-16.dsc', '0', '', \
+ contrib.location_id, self.session))
self.assertEqual((False, None), \
check_poolfile('foobar', 0, '', contrib.location_id, self.session))
self.assertEqual((False, self.file['sl_3.03-16.dsc']), \
lazyguy = self.maintainer['lazyguy']
self.assertEqual(lazyguy,
self.session.query(Maintainer).get(lazyguy.maintainer_id))
- self.assertEqual(3, len(maintainer.maintains_sources))
+ self.assertEqual(4, len(maintainer.maintains_sources))
self.assertTrue(self.source['hello_2.2-2'] in maintainer.maintains_sources)
self.assertEqual(maintainer.changed_sources, [])
self.assertEqual(uploader.maintains_sources, [])
- self.assertEqual(3, len(uploader.changed_sources))
+ self.assertEqual(4, len(uploader.changed_sources))
self.assertTrue(self.source['sl_3.03-16'] in uploader.changed_sources)
self.assertEqual(lazyguy.maintains_sources, [])
self.assertEqual(lazyguy.changed_sources, [])
self.assertEqual(self.source['hello_2.2-2'], get_newest_source('hello', self.session))
self.assertEqual(None, get_newest_source('foobar', self.session))
- def test_get_suite_version(self):
- 'test function get_suite_version()'
+ def test_get_suite_version_by_source(self):
+ 'test function get_suite_version_by_source()'
- result = get_suite_version('hello', self.session)
+ result = get_suite_version_by_source('hello', self.session)
self.assertEqual(2, len(result))
self.assertTrue(('sid', '2.2-1') in result)
self.assertTrue(('sid', '2.2-2') in result)
- result = get_suite_version('sl', self.session)
+ result = get_suite_version_by_source('sl', self.session)
self.assertEqual(2, len(result))
self.assertTrue(('squeeze', '3.03-16') in result)
self.assertTrue(('sid', '3.03-16') in result)
'''
# test Suite relation
- self.assertEqual(2, self.suite['sid'].binaries.count())
+ self.assertEqual(3, self.suite['sid'].binaries.count())
self.assertTrue(self.binary['hello_2.2-1_i386'] in \
self.suite['sid'].binaries.all())
self.assertEqual(0, self.suite['lenny'].binaries.count())
# test DBSource relation
- self.assertEqual(2, len(self.source['hello_2.2-1'].binaries))
+ self.assertEqual(3, len(self.source['hello_2.2-1'].binaries))
self.assertTrue(self.binary['hello_2.2-1_i386'] in \
self.source['hello_2.2-1'].binaries)
self.assertEqual(0, len(self.source['hello_2.2-2'].binaries))
upload = Upload(pkg)
poolfile = add_deb_to_db(upload, 'hello_2.2-2_i386.deb', self.session)
self.session.refresh(poolfile)
+ self.session.refresh(poolfile.binary)
self.assertEqual('main/h/hello/hello_2.2-2_i386.deb', poolfile.filename)
self.assertEqual('hello', poolfile.binary.package)
self.assertEqual('2.2-2', poolfile.binary.version)
self.assertEqual('deadbeef', poolfile.sha1sum)
self.assertEqual('deadbeef', poolfile.sha256sum)
+ def test_get_source_by_package_and_suite(self):
+ 'test get_source_by_package_and_suite()'
+
+ query = get_source_by_package_and_suite('hello', 'sid', self.session)
+ self.assertEqual(self.source['hello_2.2-1'], query.one())
+ query = get_source_by_package_and_suite('gnome-hello', 'squeeze', self.session)
+ self.assertEqual(self.source['hello_2.2-1'], query.one())
+ query = get_source_by_package_and_suite('hello', 'hamm', self.session)
+ self.assertEqual(0, query.count())
+ query = get_source_by_package_and_suite('foobar', 'squeeze', self.session)
+ self.assertEqual(0, query.count())
+
+ def test_get_suite_version_by_package(self):
+ 'test function get_suite_version_by_package()'
+
+ result = get_suite_version_by_package('hello', 'i386', self.session)
+ self.assertEqual(2, len(result))
+ self.assertTrue(('sid', '2.2-1') in result)
+ result = get_suite_version_by_package('hello', 'amd64', self.session)
+ self.assertEqual(0, len(result))
+ result = get_suite_version_by_package('python-hello', 'i386', self.session)
+ self.assertEqual([('squeeze', '2.2-1')], result)
+ result = get_suite_version_by_package('python-hello', 'amd64', self.session)
+ self.assertEqual([('squeeze', '2.2-1')], result)
+
+ def test_components(self):
+ 'test class Component'
+
+ self.assertEqual(self.loc['main'], self.comp['main'].location)
+ self.assertEqual(self.loc['contrib'], self.comp['contrib'].location)
+
+ def test_get_component_by_package_suite(self):
+ 'test get_component_by_package_suite()'
+
+ result = get_component_by_package_suite('hello', ['sid'], \
+ session = self.session)
+ self.assertEqual('main', result)
+ result = get_component_by_package_suite('hello', ['hamm'], \
+ session = self.session)
+ self.assertEqual(None, result)
+ result = get_component_by_package_suite('foobar', ['sid'], \
+ session = self.session)
+ self.assertEqual(None, result)
+ # test that the newest version is returned
+ result = get_component_by_package_suite('gnome-hello', ['squeeze'], \
+ session = self.session)
+ self.assertEqual('main', result)
+ result = get_component_by_package_suite('gnome-hello', ['sid'], \
+ session = self.session)
+ self.assertEqual('contrib', result)
+ # test arch_list
+ result = get_component_by_package_suite('hello', ['sid'], \
+ arch_list = ['i386'], session = self.session)
+ self.assertEqual('main', result)
+ result = get_component_by_package_suite('hello', ['sid'], \
+ arch_list = ['amd64'], session = self.session)
+ self.assertEqual(None, result)
+
if __name__ == '__main__':
unittest.main()