def create(user_id: int, channel_id: int,
notification_role_id: Optional[int]) -> "NewsAuthorization":
row = NewsAuthorization(user_id=user_id,
channel_id=channel_id,
notification_role_id=notification_role_id)
db.add(row)
return row
def create(channel_id: int, donator_id: int,
searcher_id: int) -> "Channel":
row = Channel(channel_id=channel_id,
donator_id=donator_id,
searcher_id=searcher_id)
db.add(row)
return row
def create(member: int,
member_name: str,
timestamp: Optional[datetime] = None) -> "Join":
row = Join(member=member,
member_name=member_name,
timestamp=timestamp or datetime.utcnow())
db.add(row)
return row
def create(member: int, member_name: str, mod: int, reason: str) -> "Kick":
row = Kick(member=member,
member_name=member_name,
mod=mod,
timestamp=datetime.utcnow(),
reason=reason)
db.add(row)
return row
def create(user_id: int, content: str, channel: Messageable) -> "Log":
row = Log(
user_id=user_id,
content=content,
channel_id=channel.id,
channel_type=ChannelType.get_type(channel)
)
db.add(row)
return row
def create(member: int, member_name: str, reporter: int,
reason: str) -> "Report":
row = Report(member=member,
member_name=member_name,
reporter=reporter,
timestamp=datetime.utcnow(),
reason=reason)
db.add(row)
return row
def create(
user_id: int, last_contact: DateTime = datetime.utcnow()) -> "Donator":
row = Donator(user_id=user_id,
last_contact=last_contact,
used_invites=0,
invite_count=0,
state=State.INITIAL)
db.add(row)
return row
def create(member: int, member_name: str, new_name: str,
nick: bool) -> "UsernameUpdate":
row = UsernameUpdate(member=member,
member_name=member_name,
new_name=new_name,
nick=nick,
timestamp=datetime.utcnow())
db.add(row)
return row
def create(channel_id: int, message_id: int, emoji: str, role_id: int,
auto_remove: bool) -> "ReactionRole":
row = ReactionRole(
channel_id=channel_id,
message_id=message_id,
emoji_hex=encode(emoji),
role_id=role_id,
auto_remove=auto_remove,
)
db.add(row)
return row
def create(guild_id: int, code: str, guild_name: str, applicant: int,
approver: int) -> "AllowedInvite":
row = AllowedInvite(
guild_id=guild_id,
code=code,
guild_name=guild_name,
applicant=applicant,
approver=approver,
created_at=datetime.utcnow(),
)
db.add(row)
return row
def create(guild_id: int, guild_name: str, applicant: int, mod: int,
approved: bool) -> "InviteLog":
row = InviteLog(
guild_id=guild_id,
guild_name=guild_name,
applicant=applicant,
mod=mod,
timestamp=datetime.utcnow(),
approved=approved,
)
db.add(row)
return row
def create(member: int,
member_name: str,
mod: int,
days: int,
reason: str,
is_upgrade: bool = False) -> "Ban":
row = Ban(
member=member,
member_name=member_name,
mod=mod,
timestamp=datetime.utcnow(),
days=days,
reason=reason,
active=True,
deactivation_timestamp=None,
unban_reason=None,
unban_mod=None,
is_upgrade=is_upgrade,
)
db.add(row)
return row
def create(member: int, member_name: str) -> "Leave":
row = Leave(member=member,
member_name=member_name,
timestamp=datetime.utcnow())
db.add(row)
return row
def add(channel_id: int):
db.add(LogExclude(channel_id=channel_id))
def create(role_id: int, reverse: bool) -> "VerificationRole":
row = VerificationRole(role_id=role_id, reverse=reverse)
db.add(row)
return row
def create(subreddit: str, channel: int) -> "RedditChannel":
row = RedditChannel(subreddit=subreddit, channel=channel)
db.add(row)
return row
def create(channel: int) -> "CleverBotChannel":
row = CleverBotChannel(channel=channel)
db.add(row)
return row
def create(channel: int) -> "MediaOnlyChannel":
row = MediaOnlyChannel(channel=channel)
db.add(row)
return row
def create(user_id: int, enqueued_at: DateTime = datetime.utcnow()) -> "Searcher":
row = Searcher(user_id=user_id, state=State.INITIAL, enqueued_at=enqueued_at)
db.add(row)
return row
def create(role_id: int) -> "BTPRole":
row = BTPRole(role_id=role_id)
db.add(row)
return row
def create(name: str, channel_id: int, public: bool) -> "DynamicVoiceGroup":
row = DynamicVoiceGroup(name=name, channel_id=channel_id, public=public)
db.add(row)
return row
def create(channel_id: int, group_id: int, text_chat_id: int, owner: int) -> "DynamicVoiceChannel":
row = DynamicVoiceChannel(channel_id=channel_id, group_id=group_id, text_chat_id=text_chat_id, owner=owner)
db.add(row)
return row
def create(post_id: str) -> "RedditPost":
row = RedditPost(post_id=post_id, timestamp=datetime.utcnow())
db.add(row)
return row
def create(channel: int) -> "ReactionPinChannel":
row = ReactionPinChannel(channel=channel)
db.add(row)
return row
def create(name: str, description: str) -> "Jobs":
row = Jobs(name=name, description=description)
db.add(row)
return row
def create(job_name: str, question: str, order: int) -> "Questions":
row = Questions(job_name=job_name, question=question, order=order)
db.add(row)
return row
def create(role: int, voice_channel: int) -> "RoleVoiceLink":
link = RoleVoiceLink(role=role, voice_channel=voice_channel)
db.add(link)
return link
def create(category_id: int) -> "Category":
row = Category(category_id=category_id)
db.add(row)
return row
