class BargainerModel(UserType): __type_name__ = 'bargainer' algo_type = columns.Text(required=True) current_price_history = columns.List( value_type=UserDefinedType(CurrentPriceModel), default=[]) price_change_history = columns.List( value_type=UserDefinedType(PriceChangeModel), default=[])
class Reviews(Model): id = UUID(primary_key=True, default=uuid.uuid4, partition_key=True) actor = UserDefinedType(user, default=user()) book = UserDefinedType(book, default=book(author=author())) gid = Integer(required=True, index=True) rating = Integer(required=True, index=True) text = Text() comments_count = Integer() textblob = UserDefinedType(textblob, default=textblob(instantiated=False))
class review(UserType): id = UUID(primary_key=True, default=uuid.uuid4, partition_key=True) actor = UserDefinedType(user) book = UserDefinedType(book) gid = Integer(required=True, index=True) rating = Integer(required=True, index=True) text = Text() comments_count = Integer() textblob = UserDefinedType(textblob)
class Recommendation(Model): id = UUID(primary_key=True, default=uuid.uuid4, partition_key=True) user_gid = Integer(required=True, index=True) username = Text() user_image = Text() item_recommended = List(Integer) books_details_recommended = List(UserDefinedType(book)) precision = Double(default=0.0, index=True) recall = Double(default=0.0, index=True) book_details_retrieved = Boolean(default=False, index=True) most_common_shelves = List(UserDefinedType(shelve), required=False) common_shelves_retrieved = Boolean(default=False, index=True)
class UserOrderModel(Model): __table_name__ = "user_order5" account_name = columns.Text(required=True, primary_key=True) place_time = columns.DateTime(required=True, primary_key=True, clustering_order='ASC') type = columns.Text(required=True) code = columns.Text(required=True) direction = columns.Text(required=True) quantity = columns.Float(required=True) status = columns.Text(required=True) reason = columns.Text(required=True) remark = columns.Text() real_order_id = columns.Text() failed_reason = columns.Text() cancel_reason = columns.Text() ideal_price = columns.Float() filled_start_time = columns.DateTime() filled_end_time = columns.DateTime() filled_quantity = columns.Float() filled_avg_price = columns.Float() fee = columns.Float() limit_price = columns.Float() stop_price = columns.Float() execution_map = columns.Map( key_type=columns.Text, value_type=UserDefinedType(UserOrderExecutionModel), default={}) # price_change_history = columns.List(value_type=UserDefinedType(PriceChangeModel), default=[]) bargainer = columns.UserDefinedType(BargainerModel)
class book(UserType): id = UUID(primary_key=True, default=uuid.uuid4, partition_key=True) gid = Integer(required=True, index=True) title = Text(required=True, index=True) isbn = Text(index=True) isbn13 = Text() publication_date = DateTime(index=True) description = Text() average_rating = Double(required=True, index=True) ratings_count = Integer(required=True) reviews_count = Integer() small_book = Boolean( ) # no shelves, review_count, description, smilar_book author = UserDefinedType(author, default=author()) list_shelves = List(UserDefinedType(shelve)) error_retrieving_shelves = Boolean(default=False)
class Books(Model): id = UUID(primary_key=True, default=uuid.uuid4, partition_key=True) gid = Integer(primary_key=True, required=True, index=True) title = Text(required=True, index=True) isbn = Text() isbn13 = Text() publication_date = DateTime(index=True) description = Text() average_rating = Double(required=True, index=True) ratings_count = Integer(required=True) reviews_count = Integer() small_book = Boolean( default=True, index=True) # no shelves, review_count, description, smilar_book author = UserDefinedType(author, default=author()) #Specific to model reviews_retrieved = Boolean(default=False, required=False, index=True) shelves_retrieved = Boolean(default=False, required=False, index=True) #Lists list_shelves = List(UserDefinedType(shelve), required=False) list_reviews = List(UserDefinedType(review), required=False)
class AccountModel(Model): __table_name__ = "account" tp = columns.Text(required=True) name = columns.Text(required=True, primary_key=True) cash = columns.Float(required=True) initial_cash = columns.Float(required=True) positions = columns.Map(key_type=columns.Text, value_type=columns.Float, default={}) history_net_value = columns.Map(key_type=columns.DateTime(), value_type=columns.Float(), default={}) orders = columns.List(value_type=UserDefinedType(UserOrderModel))
class Users(Model): id = UUID(primary_key=True, default=uuid.uuid4, partition_key=True) gid = Integer(required=True, index=True) name = Text(required=True, index=True) friends_count = Integer() reviews_count = Integer(index=True) age = Integer(index=True) gender = Text(index=True) location = Text(index=True) small_user = Boolean(default=False, index=True) private = Boolean(default=False, index=True) #specific to model friends_retrieved = Boolean(default=False, index=True) reviews_retrieved = Boolean(default=False, index=True) shelves_reviews_retrieved = Boolean(default=False, index=True) reviews_filtered = Boolean(default=False, index=True) test_set = Boolean(default=False, index=True) #Lists list_reviews = List(UserDefinedType(review)) list_friends = List(UserDefinedType(user)) short_list_reviews = List(UserDefinedType(review)) most_common_shelves = List(UserDefinedType(shelve), required=False)
class MeasurementRaw(Model): __keyspace__ = 'measurements' site = columns.Text(required=True, primary_key=True) meas_name = columns.Text(required=True, primary_key=True) ts = columns.DateTime(primary_key=True) # timestamp in schema sensor = columns.Text(required=True, primary_key=True) station = columns.Text(required=True, primary_key=True) company = columns.Text(required=True, primary_key=True) lat_lon = UserDefinedType(Geopoint) meas_description = columns.Text() meas_status = columns.Boolean() meas_unit = columns.Text() meas_val_b = columns.Boolean() meas_val_f = columns.Float() meas_val_s = columns.Text()
class Authors(Model): id = UUID(primary_key=True, default=uuid.uuid4(), partition_key=True) name = Text(required=True, index=True) gid = Integer(required=True, index=True) age = Integer(index=True) gender = Text(index=True) location = Text(index=True) interests = Text() born_at = DateTime(index=True) diet_at = DateTime(index=True) friends_count = Integer() reviews_count = Integer() fans_count = Integer() author_followers_count = Integer() works_count = Integer() average_rating = Double() ratings_count = Integer() text_reviews_count = Integer() #Lists list_books = List(UserDefinedType(book))
class UserOrderModel(UserType): __type_name__ = "user_order" type = columns.Text(required=True) code = columns.Text(required=True) direction = columns.Text(required=True) quantity = columns.Float(required=True) place_time = columns.DateTime(required=True) status = columns.Text(required=True) filled_start_time = columns.DateTime() filled_end_time = columns.DateTime() filled_quantity = columns.Float() filled_avg_price = columns.Float() fee = columns.Float() delay_time = columns.Text() limit_price = columns.Float() cross_price = columns.Float() cross_direction = columns.Text() execution_map = columns.Map( key_type=columns.Text, value_type=UserDefinedType(UserOrderExecutionModel), default={})
class PriceChangeModel(UserType): __type_name__ = "price_change2" time = columns.DateTime() pre_price = columns.Float() after_price = columns.Float() current_price = UserDefinedType(CurrentPriceModel)
class UserModel(Model): test_id = Integer(primary_key=True) class_param = UserDefinedType(User)
class textblob(UserType): instantiated = Boolean() tags = List(UserDefinedType(tb_tag)) noun_phrases = List(Text) sentences = List(UserDefinedType(tb_sentence))
class Shelves(Model): id = UUID(primary_key=True, default=uuid.uuid4, partition_key=True) gid = Integer() shelve = Text(required=True, index=True) count = Integer() list_book = List(UserDefinedType(book))