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 profile_columns():
return [
PkName('profile'),
Name('suite'),
Bigname('template'),
Text('description')
]
def currentenv_columns():
return [Name('hostname'), Bigname('name'), Text('value')]
from paella.sqlgen.classes import Column, Table
from paella.sqlgen.defaults import Text
from paella.sqlgen.defaults import PkBigname, Bigname, Name, Num
dpkg_tables = ['available', 'status', 'filelist', 'md5sums', 'conffiles']
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'),