class main(Model):
product_type = columns.Ascii(primary_key=True)
date = columns.Date(primary_key=True)
product_id = columns.Ascii(primary_key=True)
parameters = columns.Map(columns.Ascii(),
columns.Map(columns.Ascii(),
columns.Ascii()))
class Q3Entry(Model):
__keyspace__ = KEYSPACE
date_origin_dest1 = columns.Ascii(partition_key=True)
date1 = columns.Ascii()
origin = columns.Ascii()
dest1 = columns.Ascii()
dest2 = columns.Ascii(primary_key=True)
total_delay = columns.Decimal()
datetime1 = columns.Ascii()
flight1 = columns.Ascii()
datetime2 = columns.Ascii()
flight2 = columns.Ascii()
class NotificationTtl(BaseModel):
"""
Table to store ttl configuration for each kind of notification
ttl_code: chars to identify a ttl.
ttl_duration: default duration for this kind of ttl
description: free text description
"""
ttl_code = columns.Ascii(primary_key=True)
ttl_duration = columns.Integer()
description = columns.Text()
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()
class Notification(BaseModel):
"""
Table to store notifications queues in cassandra
user_id: user's id to which notification belongs to.
notif_id: time UUID V1 (en.wikipedia.org/wiki/Universally_unique_identifier)
emitter : backend entity that's emitting the message.
type: a single word to describe notification's type: event, info, feedback..
reference: (optional) a reference number previously sent by frontend.
body: could be a simple word or a more complex structure like a json.
"""
user_id = columns.UUID(primary_key=True)
notif_id = columns.TimeUUID(primary_key=True)
emitter = columns.Text()
type = columns.Ascii()
reference = columns.Text()
body = columns.Blob()
class User(models.Model):
# User model
user_id = columns.UUID(primary_key=True, default=uuid.uuid4)
nick = columns.Ascii(max_length=25)
gender = columns.UserDefinedType(Gender, required=True)
class Director(models.Model):
# Director Class
director_id = columns.UUID(primary_key=True, default=uuid.uuid4)
name = columns.Ascii(max_length=80, required=True)
age = columns.Integer(required=True)
country = columns.Set(value_type=str)
class Award(models.Model):
# Award Table
award_id = columns.UUID(primary_key=True, default=uuid.uuid4)
title = columns.Ascii(max_length=50, required=True)
organization = columns.Ascii(max_length=100, required=True)
class BaseActivity(Model):
feed_id = columns.Ascii(primary_key=True, partition_key=True)
activity_id = columns.VarInt(primary_key=True, clustering_order='desc')
class AggregatedActivity(BaseActivity):
activities = columns.Bytes(required=False)
created_at = columns.DateTime(required=False)
group = columns.Ascii(required=False)
updated_at = columns.DateTime(required=False)
class Q24Entry(Model):
__keyspace__ = KEYSPACE
origin_dest = columns.Ascii(partition_key=True)
delay = columns.Decimal()
class Q21Entry(Model):
__keyspace__ = KEYSPACE
origin = columns.Ascii(partition_key=True)
carrier = columns.Ascii(primary_key=True)
delay = columns.Decimal()
class Q13Entry(Model):
__keyspace__ = KEYSPACE
dow = columns.Ascii(partition_key=True)
delay = columns.Decimal()
class Q11Entry(Model):
__keyspace__ = KEYSPACE
airport = columns.Ascii(partition_key=True)
count = columns.Integer()
class Q23Entry(Model):
__keyspace__ = KEYSPACE
origin_dest = columns.Ascii(partition_key=True)
delay = columns.Decimal(primary_key=True, clustering_order="ASC")
carrier = columns.Ascii()
