class ConnBaseModel(Model):
__table_name__ = 'connection'
#columns.DateTime.truncate_microseconds = True
id = columns.UUID(primary_key=True, default=uuid.uuid4)
ts = columns.DateTime(primary_key=True, partition_key=True)
#
# CONN / SSH / DHCP / DNS / HTTP
log_type = columns.Text(discriminator_column=True, index=True)
#
uid = columns.Text(required=True)
orig_h = columns.Inet(required=True, index=True)
orig_p = columns.Integer(required=True, index=True)
resp_h = columns.Inet(required=True, index=True)
resp_p = columns.Integer(required=True, index=True)
proto = columns.Text(required=True, index=True)
duration = columns.Float(required=False)
orig_bytes = columns.Integer(required=False)
resp_bytes = columns.Integer(required=False)
conn_state = columns.Text(required=False)
#local_orig = False
# local_resp False
missed_bytes = columns.Integer(required=False)
history = columns.Text(required=False)
orig_pkts = columns.Integer(required=False)
orig_ip_bytes = columns.Integer(required=False)
resp_pkts = columns.Integer(required=False)
resp_ip_bytes = columns.Integer(required=False)
orig_l2_addr = columns.Text(required=False)
resp_l2_addr = columns.Text(required=False)
class DHCP(ConnBaseModel):
__discriminator_value__ = 'DHCP'
client_addr = columns.Inet(required=False)
mac = columns.Text(required=False)
host_name = columns.Text(required=False)
msg_types = columns.Set(value_type=columns.Text, required=False)
duration = columns.Float(required=False)
assigned_ip = columns.Text(required=False)
lease_time = columns.Text(required=False)
trans_id1 = columns.Text(required=False)
class AllDatatypes(UserType):
a = columns.Ascii()
b = columns.BigInt()
c = columns.Blob()
d = columns.Boolean()
e = columns.DateTime()
f = columns.Decimal()
g = columns.Double()
h = columns.Float()
i = columns.Inet()
j = columns.Integer()
k = columns.Text()
l = columns.TimeUUID()
m = columns.UUID()
n = columns.VarInt()
class AllDatatypesModel(Model):
id = columns.Integer(primary_key=True)
a = columns.Ascii()
b = columns.BigInt()
c = columns.Blob()
d = columns.Boolean()
e = columns.DateTime()
f = columns.Decimal()
g = columns.Double()
h = columns.Float()
i = columns.Inet()
j = columns.Integer()
k = columns.Text()
l = columns.TimeUUID()
m = columns.UUID()
n = columns.VarInt()
