class Events(Model):
eventid = columns.Text(primary_key=True)
url = columns.Text()
title = columns.Text()
description = columns.Text()
start_time = columns.DateTime()
stop_time = columns.DateTime()
venue_id = columns.Text()
venue_name = columns.Text()
venue_address = columns.Text()
city_name = columns.Text()
region_name = columns.Text()
postal_code = columns.Text()
country_name = columns.Text()
created = columns.DateTime()
modified = columns.DateTime()
links = columns.Map(columns.Text(), columns.Text())
categories = columns.Set(columns.Text())
tags = columns.Set(columns.Text())
images = columns.Set(columns.Text())
latitude = columns.Float()
longitude = columns.Float()
performers = columns.Set(columns.Text())
def __repr__(self):
return '%s %s' % (self.eventid, self.title)
class ads_table(Model):
ad_id = columns.BigInt(primary_key = True)
actions_per_impression = columns.Float()
clicks = columns.Float()
cost_per_unique_click = columns.Float()
date_start = columns.Text(primary_key = True)
date_end = columns.Text()
class Event(BaseModel):
user_id = columns.Text(primary_key=True) # partition key
event_id = columns.UUID(primary_key=True, default=uuid.uuid4)
date_start = columns.DateTime()
end_date = columns.DateTime()
description = columns.Text()
rrule_id = columns.UUID()
latitude = columns.Float()
longitude = columns.Float()
class joined_table(Model):
account_id = columns.BigInt(primary_key=True)
ad_group_id = columns.BigInt(primary_key=True)
bid_type = columns.Text()
clicks = columns.Float()
cost_per_unique_click = columns.Float()
cost_per_result = columns.Float()
reach = columns.Integer()
result_rate = columns.Float()
date_start = columns.Text()
class adsinfo(Model):
ad_id = columns.BigInt(primary_key=True)
actions_per_impression = columns.Float()
clicks = columns.Float()
cost_per_unique_click = columns.Float()
cost_per_result = columns.Float()
result_rate = columns.Float()
reach = columns.Integer()
date_start = columns.Text(primary_key=True)
date_stop = columns.Text()
class bid_table(Model):
account_id = columns.BigInt(primary_key=True)
ad_group_id = columns.BigInt(primary_key=True)
bid_actions = columns.Float()
bid_clicks = columns.Float()
bid_impressions = columns.Float()
bid_reach = columns.Float()
bid_social = columns.Float()
bid_type = columns.Text()
target_max_age = columns.Integer()
target_min_age = columns.Integer()
target_gender = columns.Integer()
target_country = columns.Text()
class GithubEvent(MBase):
id = columns.BigInt(primary_key=True)
type = columns.Text()
actor = columns.Text()
org = columns.Text()
repo = columns.Text()
created_at = columns.Float()
payload = columns.Text()
class movieCatalog2(Model):
from cqlengine import columns
from cqlengine.models import Model
from cqlengine import connection
from cqlengine.management import sync_table
CASSANDRA_KEYSPACE = "playground"
pid = columns.Integer(primary_key=True)
asin = columns.Text(primary_key=True)
brand = columns.Text()
imUrl = columns.Text()
price = columns.Float()
title = columns.Text()
class predictions3(Model):
user = columns.Integer(primary_key=True)
product = columns.Integer()
rating = columns.Float(primary_key=True, clustering_order="DESC")
class stock_counts_batch(Model):
user = columns.Text(primary_key=True)
company = columns.Text(primary_key=True)
stock_total = columns.Integer()
portfolio_ratio = columns.Float()
contact_limit = columns.Float()
class userprofile9(Model):
uid = columns.Integer(primary_key=True)
reviewerid = columns.Text()
reviewername = columns.Text()
numofreviews = columns.Float()
ratings = columns.Map(columns.Text, columns.Float)
class GDP(Model):
__keyspace__ = "magicformula"
__table_name__ = "gdp"
key = columns.Text(primary_key=True)
value = columns.Float()
date = columns.Date()
class recommendations9(Model):
uid = columns.Integer(primary_key=True)
mid = columns.Integer(primary_key=True)
rating = columns.Float()
class cost_table(Model):
bid_type = columns.Text(primary_key=True)
cost_per_result = columns.Float()
cost_per_action = columns.Float()
class reviewerProfile(Model):
user = columns.Integer(primary_key=True)
product = columns.Integer(primary_key=True)
rating = columns.Float(primary_key=True, clustering_order="DESC")
