class HypeSquadHouseReacted(db.Table, table_name="hypesquad_house_reacted"):
"""
Let's just store all people who have reacted, and which guild they came
from since this game is guild agnostic.
"""
guild_id = db.Column(db.Integer(big=True))
user_id = db.Column(db.Integer(big=True))
class TimeTable(db.Table, table_name="tz_store"):
""" Create the table for timezones. Make it unique per user, with guild array. """
user_id = db.Column(db.Integer(big=True), primary_key=True)
guild_ids = db.Column(db.Array(db.Integer(big=True)))
tz = db.Column(db.String, unique=True)
class Plonks(db.Table):
""" Create db table for plonks. """
id = db.PrimaryKeyColumn()
guild_id = db.Column(db.Integer(big=True), index=True)
# this can either be a channel_id or an author_id
entity_id = db.Column(db.Integer(big=True), index=True, unique=True)
class TwitchClipTable(db.Table):
""" Creates the Clip table for storing clip following data. """
id = db.PrimaryKeyColumn()
guild_id = db.Column(db.Integer(big=True))
channel_id = db.Column(db.Integer(big=True))
broadcaster_id = db.Column(db.String())
last_25_clips = db.Column(db.Array(db.String()))
class Commands(db.Table):
id = db.PrimaryKeyColumn()
guild_id = db.Column(db.Integer(big=True), index=True)
channel_id = db.Column(db.Integer(big=True))
author_id = db.Column(db.Integer(big=True), index=True)
used = db.Column(db.Datetime, index=True)
prefix = db.Column(db.String)
command = db.Column(db.String, index=True)
failed = db.Column(db.Boolean, index=True)
class SnipeDeleteTable(db.Table, table_name="snipe_deletes"):
id = db.PrimaryKeyColumn()
user_id = db.Column(db.Integer(big=True))
guild_id = db.Column(db.Integer(big=True))
channel_id = db.Column(db.Integer(big=True))
message_id = db.Column(db.Integer(big=True))
message_content = db.Column(db.String())
attachment_urls = db.Column(db.Array(db.String()), nullable=True)
delete_time = db.Column(db.Integer(big=True))
class TwitchTable(db.Table):
""" Create the twitch database table. """
id = db.PrimaryKeyColumn()
guild_id = db.Column(db.Integer(big=True))
channel_id = db.Column(db.Integer(big=True))
streamer_name = db.Column(db.String)
streamer_last_game = db.Column(db.String())
streamer_last_datetime = db.Column(db.Datetime())
class SnipeEditTable(db.Table, table_name="snipe_edits"):
id = db.PrimaryKeyColumn()
user_id = db.Column(db.Integer(big=True))
guild_id = db.Column(db.Integer(big=True))
channel_id = db.Column(db.Integer(big=True))
message_id = db.Column(db.Integer(big=True))
before_content = db.Column(db.String())
after_content = db.Column(db.String())
edited_time = db.Column(db.Integer(big=True))
jump_url = db.Column(db.String)
class TodoTable(db.Table, table_name="todos"):
id = db.PrimaryKeyColumn()
owner_id = db.Column(db.Integer(big=True))
content = db.Column(db.String)
added_at = db.Column(db.Datetime)
jump_url = db.Column(db.String)
class CommandConfig(db.Table, table_name="command_config"):
""" Create db table for command config. """
id = db.PrimaryKeyColumn()
guild_id = db.Column(db.Integer(big=True), index=True)
channel_id = db.Column(db.Integer(big=True))
name = db.Column(db.String)
whitelist = db.Column(db.Boolean)
@classmethod
def create_table(cls, *, exists_ok=True):
statement = super().create_table(exists_ok=exists_ok)
# create the unique index
sql = "CREATE UNIQUE INDEX IF NOT EXISTS command_config_uniq_idx ON command_config (channel_id, name, whitelist);"
return statement + "\n" + sql
class Profiles(db.Table):
# this is the user_id
id = db.Column(db.Integer(big=True), primary_key=True)
nnid = db.Column(db.String)
# merger from the ?fc stuff
fc_3ds = db.Column(db.String)
fc_switch = db.Column(db.String)
class TodoTable(db.Table, table_name="todos"):
id = db.PrimaryKeyColumn()
owner_id = db.Column(db.Integer(big=True))
content = db.Column(db.String)
added_at = db.Column(db.Datetime(timezone=True),
default="now() at time zone 'utc'")
jump_url = db.Column(db.String)
class StatisticsTable(db.Table, table_name="statistics"):
id = db.PrimaryKeyColumn()
message_deletes = db.Column(db.Integer(big=True))
bulk_message_deletes = db.Column(db.Integer(big=True))
message_edits = db.Column(db.Integer(big=True))
bans = db.Column(db.Integer(big=True))
unbans = db.Column(db.Integer(big=True))
channel_deletes = db.Column(db.Integer(big=True))
channel_creates = db.Column(db.Integer(big=True))
command_count = db.Column(db.Integer(big=True))
class HypeSquadHouse(db.Table, table_name="hypesquad_house"):
"""
# ! This is probably just a documentation thing right now for db table.
# ? I seen this format for RDanny tables and liked it so.....
Documents the table layout, should be easy to read.
"""
guild_id = db.Column(db.Integer(big=True))
balance_count = db.Column(db.Integer)
bravery_count = db.Column(db.Integer)
brilliance_count = db.Column(db.Integer)
class TagLookup(db.Table, table_name="tag_lookup"):
id = db.PrimaryKeyColumn()
# we will create more indexes manually
name = db.Column(db.String, index=True)
location_id = db.Column(db.Integer(big=True), index=True)
owner_id = db.Column(db.Integer(big=True))
created_at = db.Column(db.Datetime, default="now() at time zone 'utc'")
tag_id = db.Column(db.ForeignKey("tags", "id"))
@classmethod
def create_table(cls, *, exists_ok=True):
statement = super().create_table(exists_ok=exists_ok)
# create the indexes
sql = (
"CREATE INDEX IF NOT EXISTS tag_lookup_name_trgm_idx ON tag_lookup USING GIN (name gin_trgm_ops);\n"
"CREATE INDEX IF NOT EXISTS tag_lookup_name_lower_idx ON tag_lookup (LOWER(name));\n"
"CREATE UNIQUE INDEX IF NOT EXISTS tag_lookup_uniq_idx ON tag_lookup (LOWER(name), location_id);"
)
return statement + "\n" + sql
class WelcomeTable(db.Table, table_name="welcome_config"):
guild_id = db.Column(db.Integer(big=True), index=False, primary_key=True)
welcome_channel = db.Column(db.Integer(big=True))
welcome_message = db.Column(db.String)
class SnipeConfigTable(db.Table, table_name="snipe_config"):
id = db.Column(db.Integer(big=True), primary_key=True)
blacklisted_channels = db.Column(db.Array(db.Integer(big=True)))
blacklisted_members = db.Column(db.Array(db.Integer(big=True)))
class LewdConfigTable(db.Table, table_name="lewd_config"):
"""Database ORM fun."""
guild_id = db.Column(db.Integer(big=True), primary_key=True)
blacklist = db.Column(db.Array(db.String()))
auto_six_digits = db.Column(db.Boolean)
class Feeds(db.Table):
id = db.PrimaryKeyColumn()
channel_id = db.Column(db.Integer(big=True))
role_id = db.Column(db.Integer(big=True))
name = db.Column(db.String)
class BooruConfigTable(db.Table, table_name="booru_config"):
""" Database ORM fun. """
guild_id = db.Column(db.Integer(big=True), primary_key=True)
blacklist = db.Column(db.Array(db.String()))
class BlockTable(db.Table, table_name="owner_blocked"):
""" Keeping track of whom I blocked and why. """
user_id = db.Column(db.Integer(big=True), primary_key=True)
reason = db.Column(db.String)
