class Warehouse(Model):
W_ID = columns.Integer(primary_key=True)
W_NAME = columns.Text(max_length=10)
W_STREET1 = columns.Text(max_length=20)
W_STREET2 = columns.Text(max_length=20)
W_CITY = columns.Text(max_length=20)
W_STATE = columns.Text(max_length=2)
W_ZIP = columns.Text(max_length=9)
W_TAX = columns.Decimal()
W_YTD = columns.Decimal()
class Coin(Model):
# id=columns.UUID(partition_key=True, default=uuid.uuid4)
pair=columns.Text(partition_key=True, required=True)
day=columns.Text(partition_key=True)
name=columns.Text(required=True)
ticker=columns.Text(required=True)
icon_url=columns.Text(required=False)
price=columns.Decimal(required=False)
btc_price=columns.Decimal(required=False)
source=columns.Text()
created_at=columns.DateTime(primary_key=True, clustering_order="DESC")
class OrderLine(Model):
OL_W_ID = columns.Integer(partition_key=True)
OL_D_ID = columns.Integer(partition_key=True)
OL_O_ID = columns.Integer(partition_key=True)
OL_NUMBER = columns.Integer(primary_key=True)
OL_I_ID = columns.Integer()
OL_DELIVERY_D = columns.DateTime(required=False)
OL_AMOUNT = columns.Decimal()
OL_SUPPLY_W_ID = columns.Integer()
OL_QUANTITY = columns.Decimal()
OL_DIST_INFO = columns.Text(max_length=24)
class District(Model):
D_W_ID = columns.Integer(partition_key=True)
D_ID = columns.Integer(partition_key=True)
D_NAME = columns.Text(max_length=10)
D_STREET1 = columns.Text(max_length=20)
D_STREET2 = columns.Text(max_length=20)
D_CITY = columns.Text(max_length=20)
D_STATE = columns.Text(max_length=2)
D_ZIP = columns.Text(max_length=9)
D_TAX = columns.Decimal()
D_YTD = columns.Decimal()
D_NEXT_O_ID = columns.Integer()
class RaceData(Model):
raceDataId = columns.UUID(primary_key=True, default=uuid.uuid4)
petId = columns.UUID(index=True, default=uuid.uuid4)
raceId = columns.UUID(index=True, default=uuid.uuid4)
petName = columns.Text(index=True)
petCategoryName = columns.Text(required=False)
petCategoryId = columns.UUID(index=True, default=uuid.uuid4)
interval = columns.Integer()
runnerPosition = columns.Integer()
runnerDistance = columns.Decimal()
startTime = columns.DateTime()
finished = columns.Boolean()
runnerPreviousDistance = columns.Decimal()
__keyspace__ = 'gpmr'
class airlineontime(Model):
# __keyspace__ = 'thirdeye_test'
__table_name__ = 'airlineontime'
id = columns.UUID(primary_key=True)
crsdeptime = columns.Integer()
crsarrtime = columns.Integer()
flight_date = columns.Date()
reporting_airline = columns.Text()
tail_number = columns.Text()
originairportid = columns.Integer()
destairportid = columns.Integer()
carriername = columns.Text()
manufacturer = columns.Text()
aircraft_issue_date = columns.Date()
aircraft_model = columns.Text()
aircraft_type = columns.Text()
aircraft_engine = columns.Text()
origincityname = columns.Text()
depdel15 = columns.Integer()
arrdel15 = columns.Integer()
carrierdelay = columns.Integer()
weatherdelay = columns.Integer()
nasdelay = columns.Integer()
securitydelay = columns.Integer()
lateaircraftdelay = columns.Integer()
close = columns.Decimal()
class Order(Model):
O_W_ID = columns.Integer(partition_key=True)
O_D_ID = columns.Integer(partition_key=True)
O_C_ID = columns.Integer(index=True)
O_ID = columns.Integer(primary_key=True)
O_CARRIER_ID = columns.Integer()
O_OL_CNT = columns.Decimal()
O_ALL_LOCAL = columns.Integer()
O_ENTRY_D = columns.DateTime()
class Stock(Model):
S_W_ID = columns.Integer(partition_key=True)
S_I_ID = columns.Integer(partition_key=True)
S_QUANTITY = columns.Decimal()
S_YTD = columns.Decimal()
S_ORDER_CNT = columns.Integer()
S_REMOTE_CNT = columns.Integer()
S_DIST_01 = columns.Text(max_length=24)
S_DIST_02 = columns.Text(max_length=24)
S_DIST_03 = columns.Text(max_length=24)
S_DIST_04 = columns.Text(max_length=24)
S_DIST_05 = columns.Text(max_length=24)
S_DIST_06 = columns.Text(max_length=24)
S_DIST_07 = columns.Text(max_length=24)
S_DIST_08 = columns.Text(max_length=24)
S_DIST_09 = columns.Text(max_length=24)
S_DIST_10 = columns.Text(max_length=24)
S_DATA = columns.Text(max_length=50)
class GeoName(Model):
geonameid = columns.Integer(primary_key=True)
name = columns.Text()
asciiname = columns.Text()
alternatenames = columns.Text()
latitude = columns.Decimal()
longitude = columns.Decimal()
feature_class = columns.Text()
feature_code = columns.Text()
country_code = columns.Text()
cc2 = columns.Text()
admin1_code = columns.Text()
admin2_code = columns.Text()
admin3_code = columns.Text()
admin4_code = columns.Text()
population = columns.BigInt()
elevation = columns.Integer()
dem = columns.Integer()
timezone = columns.Text()
modification_date = columns.Date()
class Video(Model):
video_id = columns.UUID(primary_key=True, default=uuid.uuid4, partition_key=True)
language = columns.Text(primary_key=True, max_length=100, default='English', partition_key=True)
correctness = columns.Decimal(default=0.0)
video_codec = columns.Text()
user_id = columns.UUID()
date_created = columns.DateTime(index=True)
title = columns.Text(required=True, max_length=500)
description = columns.Text(min_length=1, max_length=1000)
data = columns.Text(required=True)
category = columns.Text()
class RaceNormal(Model):
raceNormalId = columns.UUID(primary_key=True, default=uuid.uuid4)
raceId = columns.UUID(index=True, default=uuid.uuid4)
petCategoryId = columns.UUID(index=True, default=uuid.uuid4)
petCategoryName = columns.Text(index=True, required=False)
currentTime = columns.DateTime()
normals = columns.List(value_type=columns.Decimal())
normalLoc = columns.Float()
normalScale = columns.Float()
normalSize = columns.Integer()
__keyspace__ = 'gpmr'
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 Clean_Daily_Measurement(Model):
station_id = columns.Text(primary_key=True, required=True) #indicativo
measure_date = columns.Date(primary_key=True, required=True) #fecha
max_temp_hour = columns.Text(required=False) #horatmax
min_temp_hour = columns.Text(required=False) #horatmin
max_temp = columns.Decimal(required=False, index=True) #tmax
med_temp = columns.Decimal(required=False) #tmed
min_temp = columns.Decimal(required=False, index=True) #tmin
max_press_hour = columns.Text(required=False) #horaPresMax
min_press_hour = columns.Text(required=False) #horaPresMin
max_pressure = columns.Decimal(required=False, index=True) #presMax
min_pressure = columns.Decimal(required=False, index=True) #presMin
precip = columns.Decimal(required=False, index=True) #prec
wind_med_vel = columns.Decimal(required=False, index=True) #velmedia
wind_dir = columns.Text(required=False) #dir
wind_streak = columns.Decimal(required=False, index=True) #racha
wind_streak_hour = columns.Text(required=False) #horaracha
insolation = columns.Decimal(required=False, index=True) #sol
class Customer(Model):
C_W_ID = columns.Integer(partition_key=True)
C_D_ID = columns.Integer(partition_key=True)
C_ID = columns.Integer(partition_key=True)
C_FIRST = columns.Text(max_length=16)
C_MIDDLE = columns.Text(max_length=2)
C_LAST = columns.Text(max_length=16)
C_STREET1 = columns.Text(max_length=20)
C_STREET2 = columns.Text(max_length=20)
C_CITY = columns.Text(max_length=20)
C_STATE = columns.Text(max_length=2)
C_ZIP = columns.Text(max_length=9)
C_PHONE = columns.Text(max_length=16)
C_SINCE = columns.DateTime()
C_CREDIT = columns.Text(max_length=2)
C_CREDIT_LIM = columns.Decimal()
C_DISCOUNT = columns.Decimal()
C_BALANCE = columns.Decimal()
C_YTD_PAYMENT = columns.Float()
C_PAYMENT_CNT = columns.Integer()
C_DELIVERY_CNT = columns.Integer()
C_DATA = columns.Text(max_length=500)
class Link(Model):
video_id = columns.UUID(primary_key=True)
url = columns.Text(primary_key=True)
time_tag = columns.Decimal(primary_key=True)
comment = columns.Text(max_length=200)
def as_dict(self):
return {
"video_id": str(self.video_id),
"url": self.url,
"time_tag": float(self.time_tag),
"comment": self.comment
}
class RaceResult(Model):
raceResultId = columns.UUID(primary_key=True, default=uuid.uuid4)
raceId = columns.UUID(index=True, default=uuid.uuid4)
raceParticipantId = columns.UUID(index=True, default=uuid.uuid4)
petCategoryId = columns.UUID(index=True, default=uuid.uuid4)
petName = columns.Text(index=True)
petType = columns.Text(required=False)
petColor = columns.Text()
petCategoryName = columns.Text(required=False)
finishPosition = columns.Integer()
finishTime = columns.Decimal()
startTime = columns.DateTime()
__keyspace__ = 'gpmr'
class test(Model):
id = columns.UUID(required=True, partition_key=True)
ls = columns.List(
columns.Text,
required=False,
)
lsi = columns.List(
columns.Integer,
required=False,
)
dm = columns.Decimal(required=False, )
created_at = columns.DateTime()
updated_at = columns.DateTime()
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 airlineontime_delaytype(Model):
__keyspace__ = 'thirdeye_test'
__table_name__ = 'airlineontime_delaytype'
id = columns.UUID(primary_key=True)
year = columns.Integer()
quarter = columns.Integer()
month = columns.Integer()
dayofmonth = columns.Integer()
dayofweek = columns.Integer()
flight_date = columns.Date()
crsdeptime = columns.Integer()
actualdeptime = columns.Integer()
depdelay = columns.Integer()
depdelayminutes = columns.Integer()
crsarrtime = columns.Integer()
actualarrtime = columns.Integer()
arrdelay = columns.Integer()
arrdelayminutes = columns.Integer()
reporting_airline = columns.Text()
tail_number = columns.Text()
originairportid = columns.Integer()
destairportid = columns.Integer()
carriername = columns.Text()
manufacturer = columns.Text()
aircraft_issue_date = columns.Date()
aircraft_model = columns.Text()
aircraft_type = columns.Text()
aircraft_engine = columns.Text()
origincityname = columns.Text()
originstatename = columns.Text()
originstatecode = columns.Text()
destinationcityname = columns.Text()
destinationstatename = columns.Text()
destinationstatecode = columns.Text()
depdel15 = columns.Integer()
arrdel15 = columns.Integer()
cancelled = columns.Integer()
carrierdelay = columns.Integer()
weatherdelay = columns.Integer()
nasdelay = columns.Integer()
securitydelay = columns.Integer()
lateaircraftdelay = columns.Integer()
close = columns.Decimal()
ownership = columns.Text()
class Earthquake(Model):
eventId = columns.Text(primary_key=True, required=True)
place = columns.Text(required=True, index=True)
time = columns.Text(required=True, index=True)
fecha = columns.DateTime(required=True, index=True)
magnitude = columns.Decimal(required=True)
depth = columns.Decimal(required=True)
longitude = columns.Decimal(required=True, index=True)
latitude = columns.Decimal(required=True, index=True)
geojson = columns.Text(required=True)
quadrant = columns.Text(index=True)
quadrantX = columns.Decimal(index=True)
quadrantY = columns.Decimal(index=True)
class ScyllaOrderItem(Model):
order_id = columns.UUID(primary_key=True, default=uuid.uuid4)
item_id = columns.UUID(primary_key=True, default=uuid.uuid4)
price = columns.Decimal()
item_num = columns.BigInt()
class Payments(Model):
id = columns.UUID(primary_key=True, default=uuid.uuid4)
user_id = columns.UUID(default=uuid.uuid4)
order_id = columns.UUID(default=uuid.uuid4, index=True)
status = columns.Boolean()
amount = columns.Decimal()
class Stops(Model):
stop_id = columns.Text(primary_key=True)
stop_name = columns.Text(required=False)
stop_lon = columns.Decimal(required=True)
stop_lat = columns.Decimal(required=True)
location_type = columns.Text(required=False)
class ScyllaUser(Model):
id = columns.UUID(primary_key=True, default=uuid.uuid4)
credit = columns.Decimal()
class Item(Model):
I_ID = columns.Integer(primary_key=True)
I_NAME = columns.Text(max_length=24)
I_PRICE = columns.Decimal()
I_IM_ID = columns.Integer()
I_DATA = columns.Text(max_length=50)
class ScyllaStockItem(Model):
id = columns.UUID(primary_key=True, default=uuid.uuid4)
price = columns.Decimal()
in_stock = columns.BigInt()
class Q13Entry(Model):
__keyspace__ = KEYSPACE
dow = 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 Q24Entry(Model):
__keyspace__ = KEYSPACE
origin_dest = columns.Ascii(partition_key=True)
delay = columns.Decimal()
