################################################################################
-__all__ = []
+__all__ = ['IntegrityError', 'SQLAlchemyError']
################################################################################
__all__.append('get_architecture_suites')
+################################################################################
+
class Archive(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_archive')
+################################################################################
+
class BinAssociation(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('BinAssociation')
-class Binary(object):
+################################################################################
+
+class DBBinary(object):
def __init__(self, *args, **kwargs):
pass
def __repr__(self):
- return '<Binary %s (%s, %s)>' % (self.package, self.version, self.architecture)
+ return '<DBBinary %s (%s, %s)>' % (self.package, self.version, self.architecture)
-__all__.append('Binary')
+__all__.append('DBBinary')
def get_binary_from_id(id, session=None):
"""
- Returns Binary object for given C{id}
+ Returns DBBinary object for given C{id}
@type id: int
@param id: Id of the required binary
@param session: Optional SQLA session object (a temporary one will be
generated if not supplied)
- @rtype: Binary
- @return: Binary object for the given binary (None if not present)
+ @rtype: DBBinary
+ @return: DBBinary object for the given binary (None if not present)
"""
if session is None:
session = DBConn().session()
- q = session.query(Binary).filter_by(binary_id=id)
+ q = session.query(DBBinary).filter_by(binary_id=id)
if q.count() == 0:
return None
return q.one()
def get_binaries_from_name(package, session=None):
"""
- Returns list of Binary objects for given C{package} name
+ Returns list of DBBinary objects for given C{package} name
@type package: str
- @param package: Binary package name to search for
+ @param package: DBBinary package name to search for
@type session: Session
@param session: Optional SQL session object (a temporary one will be
generated if not supplied)
@rtype: list
- @return: list of Binary objects for the given name (may be empty)
+ @return: list of DBBinary objects for the given name (may be empty)
"""
if session is None:
session = DBConn().session()
- return session.query(Binary).filter_by(package=package).all()
+ return session.query(DBBinary).filter_by(package=package).all()
__all__.append('get_binaries_from_name')
+def get_binary_components(package, suitename, arch, session=None):
+# Check for packages that have moved from one component to another
+ query = """SELECT c.name FROM binaries b, bin_associations ba, suite s, location l, component c, architecture a, files f
+ WHERE b.package=:package AND s.suite_name=:suitename
+ AND (a.arch_string = :arch OR a.arch_string = 'all')
+ AND ba.bin = b.id AND ba.suite = s.id AND b.architecture = a.id
+ AND f.location = l.id
+ AND l.component = c.id
+ AND b.file = f.id"""
+
+ vals = {'package': package, 'suitename': suitename, 'arch': arch}
+
+ if session is None:
+ session = DBConn().session()
+ return session.execute(query, vals)
+
+__all__.append('get_binary_components')
+################################################################################
+
class Component(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_component')
+################################################################################
+
class DBConfig(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('DBConfig')
+################################################################################
+
class ContentFilename(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_or_set_contents_file_id')
+################################################################################
+
class ContentFilepath(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_or_set_contents_path_id')
+################################################################################
+
class ContentAssociation(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('insert_content_paths')
+################################################################################
+
class DSCFile(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('DSCFile')
+################################################################################
+
class PoolFile(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_poolfile_by_name')
+################################################################################
+
class Fingerprint(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('Fingerprint')
+################################################################################
+
class Keyring(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('Keyring')
+################################################################################
+
class Location(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_location')
+################################################################################
+
class Maintainer(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('Maintainer')
+################################################################################
+
class Override(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('Override')
+################################################################################
+
class OverrideType(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_override_type')
+################################################################################
+
class PendingContentAssociation(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('insert_pending_content_paths')
+################################################################################
+
class Priority(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_priority')
+################################################################################
+
class Queue(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('Queue')
+################################################################################
+
class QueueBuild(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('QueueBuild')
+################################################################################
+
class Section(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_section')
-class Source(object):
+################################################################################
+
+class DBSource(object):
def __init__(self, *args, **kwargs):
pass
def __repr__(self):
- return '<Source %s (%s)>' % (self.source, self.version)
+ return '<DBSource %s (%s)>' % (self.source, self.version)
-__all__.append('Source')
+__all__.append('DBSource')
def get_sources_from_name(source, session=None):
"""
- Returns list of Source objects for given C{source} name
+ Returns list of DBSource objects for given C{source} name
@type source: str
- @param source: Source package name to search for
+ @param source: DBSource package name to search for
@type session: Session
@param session: Optional SQL session object (a temporary one will be
generated if not supplied)
@rtype: list
- @return: list of Source objects for the given name (may be empty)
+ @return: list of DBSource objects for the given name (may be empty)
"""
if session is None:
session = DBConn().session()
- return session.query(Source).filter_by(source=source).all()
+ return session.query(DBSource).filter_by(source=source).all()
__all__.append('get_sources_from_name')
def get_source_in_suite(source, suite, session=None):
"""
- Returns list of Source objects for a combination of C{source} and C{suite}.
+ Returns list of DBSource objects for a combination of C{source} and C{suite}.
- B{source} - source package name, eg. I{mailfilter}, I{bbdb}, I{glibc}
- B{suite} - a suite name, eg. I{unstable}
__all__.append('get_source_in_suite')
+################################################################################
+
class SrcAssociation(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('SrcAssociation')
+################################################################################
+
class SrcUploader(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('SrcUploader')
+################################################################################
+
class Suite(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('get_suite')
+################################################################################
+
class SuiteArchitecture(object):
def __init__(self, *args, **kwargs):
pass
__all__.append('SuiteArchitecture')
-def get_suite_architectures(suite, session=None):
+def get_suite_architectures(suite, skipsrc=False, skipall=False, session=None):
"""
Returns list of Architecture objects for given C{suite} name
@type source: str
@param source: Suite name to search for
+ @type skipsrc: boolean
+ @param skipsrc: Whether to skip returning the 'source' architecture entry
+ (Default False)
+
+ @type skipall: boolean
+ @param skipall: Whether to skip returning the 'all' architecture entry
+ (Default False)
+
@type session: Session
@param session: Optional SQL session object (a temporary one will be
generated if not supplied)
q = session.query(Architecture)
q = q.join(SuiteArchitecture)
- q = q.join(Suite).filter_by(suite_name=suite).order_by('arch_string')
+ q = q.join(Suite).filter_by(suite_name=suite)
+ if skipsrc:
+ q = q.filter(Architecture.arch_string != 'source')
+ if skipall:
+ q = q.filter(Architecture.arch_string != 'all')
+ q = q.order_by('arch_string')
return q.all()
__all__.append('get_suite_architectures')
+################################################################################
+
class Uid(object):
def __init__(self, *args, **kwargs):
pass
suite_id = self.tbl_bin_associations.c.suite,
suite = relation(Suite),
binary_id = self.tbl_bin_associations.c.bin,
- binary = relation(Binary)))
+ binary = relation(DBBinary)))
- mapper(Binary, self.tbl_binaries,
+ mapper(DBBinary, self.tbl_binaries,
properties = dict(binary_id = self.tbl_binaries.c.id,
package = self.tbl_binaries.c.package,
version = self.tbl_binaries.c.version,
maintainer_id = self.tbl_binaries.c.maintainer,
maintainer = relation(Maintainer),
source_id = self.tbl_binaries.c.source,
- source = relation(Source),
+ source = relation(DBSource),
arch_id = self.tbl_binaries.c.architecture,
architecture = relation(Architecture),
poolfile_id = self.tbl_binaries.c.file,
filepath_id = self.tbl_content_associations.c.filepath,
filepath = relation(ContentFilepath),
binary_id = self.tbl_content_associations.c.binary_pkg,
- binary = relation(Binary)))
+ binary = relation(DBBinary)))
mapper(ContentFilename, self.tbl_content_file_names,
mapper(DSCFile, self.tbl_dsc_files,
properties = dict(dscfile_id = self.tbl_dsc_files.c.id,
source_id = self.tbl_dsc_files.c.source,
- source = relation(Source),
+ source = relation(DBSource),
poolfile_id = self.tbl_dsc_files.c.file,
poolfile = relation(PoolFile)))
mapper(Section, self.tbl_section,
properties = dict(section_id = self.tbl_section.c.id))
- mapper(Source, self.tbl_source,
+ mapper(DBSource, self.tbl_source,
properties = dict(source_id = self.tbl_source.c.id,
version = self.tbl_source.c.version,
maintainer_id = self.tbl_source.c.maintainer,
suite_id = self.tbl_src_associations.c.suite,
suite = relation(Suite),
source_id = self.tbl_src_associations.c.source,
- source = relation(Source)))
+ source = relation(DBSource)))
mapper(SrcUploader, self.tbl_src_uploaders,
properties = dict(uploader_id = self.tbl_src_uploaders.c.id,
source_id = self.tbl_src_uploaders.c.source,
- source = relation(Source,
+ source = relation(DBSource,
primaryjoin=(self.tbl_src_uploaders.c.source==self.tbl_source.c.id)),
maintainer_id = self.tbl_src_uploaders.c.maintainer,
maintainer = relation(Maintainer,
mapper(SuiteArchitecture, self.tbl_suite_architectures,
properties = dict(suite_id = self.tbl_suite_architectures.c.suite,
- suite = relation(Suite),
+ suite = relation(Suite, backref='suitearchitectures'),
arch_id = self.tbl_suite_architectures.c.architecture,
architecture = relation(Architecture)))