class Notification(db.Model):
__table_args__ = {
'mysql_charset': 'utf8mb4',
'mysql_collate': default_collation
}
id = db.Column(db.Integer,
primary_key=True) # Auto-increment should be default
content = db.Column(db.Text(collation=default_collation), nullable=False)
last_update = db.Column(db.TIMESTAMP(timezone=True), nullable=False)
class Message(db.Model):
__table_args__ = {
'mysql_charset': 'utf8mb4',
'mysql_collate': default_collation
}
id = db.Column(db.Integer,
primary_key=True) # Auto-increment should be default
text = db.Column(db.Text(collation=default_collation), nullable=False)
message_id = db.Column(db.Integer, index=True, nullable=False)
chat_id = db.Column(db.String(50, collation=default_collation),
db.ForeignKey('chat.id'),
nullable=False)
video_id = db.Column(db.String(50, collation=default_collation),
db.ForeignKey('video.id'),
nullable=False)
class Chat(db.Model):
__table_args__ = {
'mysql_charset': 'utf8mb4',
'mysql_collate': default_collation
}
id = db.Column(db.String(50, collation=default_collation),
primary_key=True)
messages = relationship("Message", backref="chat")
class TelegramUser(db.Model):
__table_args__ = {
'mysql_charset': 'utf8mb4',
'mysql_collate': default_collation
}
id = db.Column(db.Integer, primary_key=True, autoincrement=False)
is_bot = db.Column(db.Boolean, nullable=False, default=False)
first_name = db.Column(db.String(50, collation=default_collation))
last_name = db.Column(db.String(50, collation=default_collation))
username = db.Column(db.String(50, collation=default_collation),
nullable=False,
index=True)
language_code = db.Column(db.String(50, collation=default_collation))
role = db.Column(db.String(50, collation=default_collation),
nullable=False,
default="normal user")
time_created = db.Column(db.TIMESTAMP(timezone=True),
nullable=False,
server_default=func.now())
time_updated = db.Column(db.TIMESTAMP(timezone=True),
nullable=False,
onupdate=func.now())
class Channel(db.Model):
__table_args__ = {
'mysql_charset': 'utf8mb4',
'mysql_collate': default_collation
}
id = db.Column(db.String(50, collation=default_collation),
primary_key=True)
name = db.Column(db.String(50, collation=default_collation),
nullable=False,
index=True)
subscribe = db.Column(db.Boolean, nullable=False, default=True)
last_subscribe = db.Column(db.TIMESTAMP(timezone=True))
topic_url = db.Column(db.String(150, collation=default_collation),
nullable=False,
index=True)
channel_url = db.Column(db.String(150, collation=default_collation),
nullable=False)
videos = relationship("Video", backref="channel")
chats = relationship("Chat",
secondary=association_table,
backref="channels")
class Video(db.Model):
__table_args__ = {
'mysql_charset': 'utf8mb4',
'mysql_collate': default_collation
}
id = db.Column(db.String(50, collation=default_collation),
primary_key=True)
channel_id = db.Column(db.String(50, collation=default_collation),
db.ForeignKey('channel.id'),
nullable=False)
title = db.Column(db.String(100, collation=default_collation), index=True)
title_zh = db.Column(db.String(100, collation=default_collation))
publish_time = db.Column(db.TIMESTAMP(timezone=True))
last_update = db.Column(db.TIMESTAMP(timezone=True))
deleted = db.Column(db.Boolean, nullable=False, default=False)
video_url = db.Column(db.String(150, collation=default_collation),
nullable=False)
is_livestream = db.Column(db.Boolean, nullable=True, default=False)
actual_start_time = db.Column(db.TIMESTAMP(timezone=True))
scheduled_start_time = db.Column(db.TIMESTAMP(timezone=True))
concurrent_viewers = db.Column(db.Integer)
active_livechat_id = db.Column(db.String(150, collation=default_collation),
index=True)
messages = relationship("Message", backref="video")
# coding: utf-8
import click
from flask.cli import with_appcontext
from sqlalchemy.orm import relationship
from sqlalchemy.sql import func
from KaguraMeaLive import app, db
default_collation = 'utf8mb4_unicode_ci'
association_table = db.Table(
'channel_chat',
db.Model.metadata,
db.Column('id', db.Integer,
primary_key=True), # Auto-increment should be default
db.Column('channel_id', db.String(50, collation=default_collation),
db.ForeignKey('channel.id')),
db.Column('chat_id', db.String(50, collation=default_collation),
db.ForeignKey('chat.id')))
class Channel(db.Model):
__table_args__ = {
'mysql_charset': 'utf8mb4',
'mysql_collate': default_collation
}
id = db.Column(db.String(50, collation=default_collation),
primary_key=True)
name = db.Column(db.String(50, collation=default_collation),
nullable=False,