def family_env_columns():
return [
PkName('family'),
PkName('trait'),
PkBigname('name'),
Text('value')
]
def profile_columns():
return [
PkName('profile'),
Name('suite'),
Bigname('template'),
Text('description')
]
def __init__(self):
scol = PkName('script')
tcol = Name('type')
tcol.set_fk('scriptnames')
fcol = Text('scriptfile')
columns = [scol, tcol] + suiteversion_cols() + [fcol]
Table.__init__(self, 'scripts', columns)
def __init__(self):
idcol = PkNum('fileid')
idcol.set_auto_increment('textfile_ident')
mcol = Name('md5size')
mcol.constraint.unique = True
dcol = Text('data')
columns = [idcol, mcol, dcol]
Table.__init__(self, 'textfiles', columns)
def __init__(self, profiles_table):
profile_col = PkName('profile')
profile_col.set_fk(profiles_table)
trait_col = PkName('trait')
name_col = PkBigname('name')
value_col = Text('value')
cols = [profile_col, trait_col, name_col, value_col]
tablename = ujoin('profile', 'variables')
Table.__init__(self, tablename, cols)
def debconf_columns():
return [
PkBigname('name'),
Bigname('value'),
Bigname('owners'),
Bigname('flags'),
Bigname('template'),
Text('variables')
]
def packages_columns():
return [
PkBigname('package'),
Name('priority'),
Bigname('section'),
Num('installedsize'),
Bigname('filename'),
Bigname('maintainer'),
Bigname('size'),
Name('md5sum'),
Bigname('version'),
Text('description')
]
def defaultenv_columns():
return [PkName('section'), PkBigname('option'), Text('value')]
def currentenv_columns():
return [Name('hostname'), Bigname('name'), Text('value')]
def __init__(self, suite, traits_table):
cols = [PkBigname('name'), Text('value')]
tablename = ujoin(suite, 'variables')
_TraitRelation.__init__(self, traits_table, tablename, cols)
def trait_columns():
return [PkName('trait'), Name('priority'), Text('description')]
def __init__(self):
tcol = PkBigname('template')
fcol = Text('templatefile')
columns = [tcol] + suiteversion_cols() + [fcol]
Table.__init__(self, 'templates', columns)
other_tables = ['current']
common_columns = [
PkBigname('package'),
Name('essential'),
Name('priority'),
Name('section'),
Num('installedsize'),
Bigname('maintainer'),
Name('version')
]
#columns for /var/lib/dpkg/status
status_columns = common_columns + [
Name('status'),
Text('replaces'),
Text('provides'),
Text('predepends'),
Text('conflicts'),
Bigname('source'),
Text('suggests'),
Text('recommends'),
Text('depends'),
Text('conffiles'),
Text('description'),
Bigname('origin'),
Text('bugs'),
Text('enhances'),
Name('md5sum'),
Bigname('configversion')
]