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