generated from HoloTech/holotech-plugin-template
56 lines
1.2 KiB
Python
56 lines
1.2 KiB
Python
from data import Registry, RowModel, Table
|
|
from data.columns import String, Timestamp, Integer, Bool
|
|
|
|
|
|
class Campaign(RowModel):
|
|
_tablename_ = "campaigns"
|
|
# _cache_ = {}
|
|
|
|
campaign_id = Integer(primary=True)
|
|
communityid = Integer()
|
|
target_rewards = Integer()
|
|
campaign_name = String()
|
|
started_at = Timestamp()
|
|
completed_at = Timestamp()
|
|
|
|
moderator_role_id = Integer()
|
|
logging_webhook_url = String()
|
|
|
|
created_at = Timestamp()
|
|
_timestamp = Timestamp()
|
|
|
|
class EarnedReward(RowModel):
|
|
_tablename_ = "campaign_rewards_earned"
|
|
# _cache_ = {}
|
|
|
|
earned_id = Integer(primary=True)
|
|
campaign_id = Integer()
|
|
profileid = Integer()
|
|
|
|
event_id = Integer()
|
|
twitch_user_id = String()
|
|
twitch_user_name = String()
|
|
|
|
fulfilled_at = Timestamp()
|
|
fulfilled_note = String()
|
|
|
|
earned_at = Timestamp()
|
|
earned_from = String()
|
|
modnote = String()
|
|
reference = String()
|
|
|
|
log_messageid = Integer()
|
|
|
|
_timestamp = Timestamp()
|
|
|
|
|
|
|
|
class CampaignData(Registry):
|
|
VERSION = ("REWARDCAMPAIGN", 1)
|
|
|
|
Campaign = Campaign
|
|
campaigns = Campaign.table
|
|
|
|
EarnedReward = EarnedReward
|
|
campaign_rewards_earned = EarnedReward.table
|