def __init__(self):
Table.__init__(self,
fields=[
Field('LINE_ID', FieldType.Int, PrimaryKeys(True)),
Field('HashTag', unique=True),
Field('Line')
])
def __init__(self):
Table.__init__(
self,
name='Points',
fields=(Field('HOST_REF', FieldType.Int), Field('PointName'),
Field('Start'), Field('End')),
foreign_keys=[ForeignKey('HOST_REF', 'TraceHost', 'HOST_ID')],
queries=[
Query(
'select_state', """SELECT {} FROM Points
WHERE HOST_REF = {} AND PointName = '{}'""")
])
def __init__(self):
Table.__init__(
self,
name='TimeLine',
fields=[
Field('TL_ID', FieldType.Int, PrimaryKeys(True)),
Field('TimeStamp', FieldType.Text)
],
queries=[
Query(
'select_last',
'SELECT TL_ID FROM TimeLine WHERE TimeStamp == "{timestamp}"'
)
])
def __init__(self):
super().__init__(fields=[
Field('OUTPUT_REF', FieldType.Int),
Field('ORDER_ID', FieldType.Int),
Field('LINE_REF', FieldType.Int)
],
foreign_keys=[
ForeignKey('OUTPUT_REF', 'TimeMeasurement',
'OUTPUT_ID'),
ForeignKey('LINE_REF', 'LinesCache', 'LINE_ID')
],
queries=[
Query(
'last_output_id',
'select max(OUTPUT_REF) from LinesCacheMap')
])
def __init__(self):
super().__init__()
for i in self._shown_fields:
f, t = self.FIELDS_TYPES[i]
self.add_field(Field(f.capitalize(), t))
def add_output_cache_reference(self):
self.add_field(Field('OUTPUT_REF', FieldType.Int))
self.add_foreign_key(
ForeignKey('OUTPUT_REF', 'LinesCacheMap', 'OUTPUT_REF'))
def add_time_reference(self):
self.add_field(Field('HOST_REF', FieldType.Int))
self.add_field(Field('TL_REF', FieldType.Int))
self.add_foreign_key(ForeignKey('TL_REF', 'TimeLine', 'TL_ID'))
self.add_foreign_key(ForeignKey('HOST_REF', 'TraceHost', 'HOST_ID'))
def __init__(self):
super().__init__(name='TraceHost')
self.add_field(Field('HOST_ID', FieldType.Int, PrimaryKeys(True)))
self.add_field(Field('HostName', FieldType.Text, PrimaryKeys(True)))