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()