class album(db.Model): __bind_key__ = 'maimai' __tablename__ = 'album' id = db.Column(db.Integer, primary_key=True) dx_img_s = db.Column(db.VARCHAR(50)) play_dt = db.Column(db.DateTime, nullable=False) play_dt_utc = db.Column(db.DateTime, nullable=False) level_img_s = db.Column(db.VARCHAR(50)) name = db.Column(db.VARCHAR(50)) img = db.Column(db.VARCHAR(50), nullable=False) cache_dt = db.Column(db.DateTime, nullable=False) def __init__(self, dx_img_s, play_dt, play_dt_utc, level_img_s, name, img, cache_dt): self.dx_img_s = dx_img_s, self.play_dt = play_dt, self.play_dt_utc = play_dt_utc, self.level_img_s = level_img_s, self.name = name, self.img = img, self.cache_dt = cache_dt def __repr__(self): return '<album (%s, %s, %s, %s, %s, %s, %s, %s)>' % ( self.id, self.dx_img_s, self.play_dt, self.play_dt_utc, self.level_img_s, self.name, self.img, self.cache_dt) def to_json(self): num = { 'id': self.id, 'dx_img_s': self.dx_img_s, 'play_dt': self.play_dt, 'play_dt_utc': self.play_dt_utc, 'level_img_s': self.level_img_s, 'name': self.name, 'img': self.img, 'cache_dt': self.cache_dt } return num def save(self): db.session.add(self) db.session.commit() return self def update(self): db.session.commit() return self
class practice(db.Model): __bind_key__ = 'maimai' __tablename__ = 'practice' id = db.Column(db.Integer, primary_key=True, nullable=True) name = db.Column(db.VARCHAR(255), nullable=False) level_img_s = db.Column(db.VARCHAR(50)) tips = db.Column(db.VARCHAR(255)) insert_time = db.Column(db.DateTime) update_time = db.Column(db.DateTime) def __init__(self, name, level_img_s, tips): self.name = name self.level_img_s = level_img_s self.tips = tips def save(self): db.session.add(self) db.session.commit() return self def update(self): db.session.commit() return self
class musicInfo(db.Model): __bind_key__ = 'maimai' __tablename__ = 'musicinfo' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.VARCHAR(50), nullable=False) level_img_s = db.Column(db.VARCHAR(50), nullable=False) dx_img_s = db.Column(db.VARCHAR(50)) music_genre = db.Column(db.VARCHAR(50)) music_word = db.Column(db.VARCHAR(50)) music_level = db.Column(db.VARCHAR(50), nullable=False) music_version = db.Column(db.VARCHAR(50)) ver = db.Column(db.VARCHAR(50)) constant = db.Column(db.FLOAT(2)) cache_dt = db.Column(db.DateTime, nullable=False) def __init__(self, name, level_img_s, dx_img_s, music_genre, music_word, music_level, music_version, ver, cache_dt): self.name = name, self.level_img_s = level_img_s, self.dx_img_s = dx_img_s, self.music_genre = music_genre, self.music_word = music_word, self.music_level = music_level, self.music_version = music_version, self.ver = ver, self.cache_dt = cache_dt def __repr__(self): return '<musicInfo (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s,)>' % ( self.id, self.name, self.level_img_s, self.dx_img_s, self.music_genre, self.music_word, self.music_level, self.music_version, self.ver, self.cache_dt) def to_json(self): num = { 'id': self.id, 'name': self.name, 'level_img_s': self.level_img_s, 'dx_img_s': self.dx_img_s, 'music_genre': self.music_genre, 'music_word': self.music_word, 'music_level': self.music_level, 'music_version': self.music_version, 'ver': self.ver, 'cache_dt': self.cache_dt } return num def save(self): try: db.session.add(self) db.session.commit() except Exception as e: print(e) db.session.rollback() return self def update(self): db.session.commit() return self
class playlogDetail(db.Model): __bind_key__ = 'maimai' __tablename__ = 'playlogdetail' id = db.Column(db.Integer, primary_key=True) vs_rank = db.Column(db.VARCHAR(50)) vs_achievement = db.Column(db.Float(4)) vs_rating = db.Column(db.Integer) vs_grade = db.Column(db.VARCHAR(50)) chara_0_img_s = db.Column(db.VARCHAR(50)) chara_0_star = db.Column(db.Integer) chara_0_lv = db.Column(db.Integer) chara_1_img_s = db.Column(db.VARCHAR(50)) chara_1_star = db.Column(db.Integer) chara_1_lv = db.Column(db.Integer) chara_2_img_s = db.Column(db.VARCHAR(50)) chara_2_star = db.Column(db.Integer) chara_2_lv = db.Column(db.Integer) chara_3_img_s = db.Column(db.VARCHAR(50)) chara_3_star = db.Column(db.Integer) chara_3_lv = db.Column(db.Integer) chara_4_img_s = db.Column(db.VARCHAR(50)) chara_4_star = db.Column(db.Integer) chara_4_lv = db.Column(db.Integer) fast = db.Column(db.Integer) late = db.Column(db.Integer) grade = db.Column(db.Integer) grade_diff = db.Column(db.VARCHAR(50)) rating = db.Column(db.Integer) delux_rating = db.Column(db.Integer) delux_rating_diff = db.Column(db.VARCHAR(50)) grade_pic_s = db.Column(db.VARCHAR(50)) notes_tap_cp = db.Column(db.Integer) notes_tap_p = db.Column(db.Integer) notes_tap_great = db.Column(db.Integer) notes_tap_good = db.Column(db.Integer) notes_tap_miss = db.Column(db.Integer) notes_hold_cp = db.Column(db.Integer) notes_hold_p = db.Column(db.Integer) notes_hold_great = db.Column(db.Integer) notes_hold_good = db.Column(db.Integer) notes_hold_miss = db.Column(db.Integer) notes_slide_cp = db.Column(db.Integer) notes_slide_p = db.Column(db.Integer) notes_slide_great = db.Column(db.Integer) notes_slide_good = db.Column(db.Integer) notes_slide_miss = db.Column(db.Integer) notes_touch_cp = db.Column(db.Integer) notes_touch_p = db.Column(db.Integer) notes_touch_great = db.Column(db.Integer) notes_touch_good = db.Column(db.Integer) notes_touch_miss = db.Column(db.Integer) notes_break_cp = db.Column(db.Integer) notes_break_p = db.Column(db.Integer) notes_break_great = db.Column(db.Integer) notes_break_good = db.Column(db.Integer) notes_break_miss = db.Column(db.Integer) maxcombo = db.Column(db.VARCHAR(50)) maxsync = db.Column(db.VARCHAR(50)) level_img_s = db.Column(db.VARCHAR(50)) name = db.Column(db.VARCHAR(50)) cache_dt = db.Column(db.DateTime, nullable=False) def __init__( self, vs_rank, vs_achievement, vs_rating, vs_grade, chara_0_img_s, chara_0_star, chara_0_lv, chara_1_img_s, chara_1_star, chara_1_lv, chara_2_img_s, chara_2_star, chara_2_lv, chara_3_img_s, chara_3_star, chara_3_lv, chara_4_img_s, chara_4_star, chara_4_lv, fast, late, grade, grade_diff, rating, delux_rating, delux_rating_diff, grade_pic_s, notes_tap_cp, notes_tap_p, notes_tap_great, notes_tap_good, notes_tap_miss, notes_hold_cp, notes_hold_p, notes_hold_great, notes_hold_good, notes_hold_miss, notes_slide_cp, notes_slide_p, notes_slide_great, notes_slide_good, notes_slide_miss, notes_touch_cp, notes_touch_p, notes_touch_great, notes_touch_good, notes_touch_miss, notes_break_cp, notes_break_p, notes_break_great, notes_break_good, notes_break_miss, maxcombo, maxsync, level_img_s, name, cache_dt): self.vs_rank = vs_rank, self.vs_achievement = vs_achievement, self.vs_rating = vs_rating, self.vs_grade = vs_grade, self.chara_0_img_s = chara_0_img_s, self.chara_0_star = chara_0_star, self.chara_0_lv = chara_0_lv, self.chara_1_img_s = chara_1_img_s, self.chara_1_star = chara_1_star, self.chara_1_lv = chara_1_lv, self.chara_2_img_s = chara_2_img_s, self.chara_2_star = chara_2_star, self.chara_2_lv = chara_2_lv, self.chara_3_img_s = chara_3_img_s, self.chara_3_star = chara_3_star, self.chara_3_lv = chara_3_lv, self.chara_4_img_s = chara_4_img_s, self.chara_4_star = chara_4_star, self.chara_4_lv = chara_4_lv, self.fast = fast, self.late = late, self.grade = grade, self.grade_diff = grade_diff, self.rating = rating self.delux_rating = delux_rating, self.delux_rating_diff = delux_rating_diff, self.grade_pic_s = grade_pic_s, self.notes_tap_cp = notes_tap_cp, self.notes_tap_p = notes_tap_p, self.notes_tap_great = notes_tap_great, self.notes_tap_good = notes_tap_good, self.notes_tap_miss = notes_tap_miss, self.notes_hold_cp = notes_hold_cp, self.notes_hold_p = notes_hold_p, self.notes_hold_great = notes_hold_great, self.notes_hold_good = notes_hold_good, self.notes_hold_miss = notes_hold_miss, self.notes_slide_cp = notes_slide_cp, self.notes_slide_p = notes_slide_p, self.notes_slide_great = notes_slide_great, self.notes_slide_good = notes_slide_good, self.notes_slide_miss = notes_slide_miss, self.notes_touch_cp = notes_touch_cp, self.notes_touch_p = notes_touch_p, self.notes_touch_great = notes_touch_great, self.notes_touch_good = notes_touch_good, self.notes_touch_miss = notes_touch_miss, self.notes_break_cp = notes_break_cp, self.notes_break_p = notes_break_p, self.notes_break_great = notes_break_great, self.notes_break_good = notes_break_good, self.notes_break_miss = notes_break_miss, self.maxcombo = maxcombo, self.maxsync = maxsync, self.level_img_s = level_img_s, self.name = name, self.cache_dt = cache_dt def __repr__(self): return '<playlogDetail (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)>' % ( self.vs_rank, self.vs_achievement, self.vs_rating, self.vs_grade, self.chara_0_img_s, self.chara_0_star, self.chara_0_lv, self.chara_1_img_s, self.chara_1_star, self.chara_1_lv, self.chara_2_img_s, self.chara_2_star, self.chara_2_lv, self.chara_3_img_s, self.chara_3_star, self.chara_3_lv, self.chara_4_img_s, self.chara_4_star, self.chara_4_lv, self.fast, self.late, self.grade, self.grade_diff, self.rating, self.delux_rating, self.delux_rating_diff, self.grade_pic_s, self.maxcombo, self.maxsync, self.level_img_s, self.name, self.cache_dt) def to_json(self): num = { 'id': self.id, 'vs_rank': self.vs_rank, 'vs_achievement': self.vs_achievement, 'vs_rating': self.vs_rating, 'vs_grade': self.vs_grade, 'chara_0_img_s': self.chara_0_img_s, 'chara_0_star': self.chara_0_star, 'chara_0_lv': self.chara_0_lv, 'chara_1_img_s': self.chara_1_img_s, 'chara_1_star': self.chara_1_star, 'chara_1_lv': self.chara_1_lv, 'chara_2_img_s': self.chara_2_img_s, 'chara_2_star': self.chara_2_star, 'chara_2_lv': self.chara_2_lv, 'chara_3_img_s': self.chara_3_img_s, 'chara_3_star': self.chara_3_star, 'chara_3_lv': self.chara_3_lv, 'chara_4_img_s': self.chara_4_img_s, 'chara_4_star': self.chara_4_star, 'chara_4_lv': self.chara_4_lv, 'fast': self.fast, 'late': self.late, 'grade': self.grade, 'grade_diff': self.grade_diff, 'rating': self.rating, 'delux_rating': self.delux_rating, 'delux_rating_diff': self.delux_rating_diff, 'grade_pic_s': self.grade_pic_s, 'notes_tap_cp': self.notes_tap_cp, 'notes_tap_p': self.notes_tap_p, 'notes_tap_great': self.notes_tap_great, 'notes_tap_good': self.notes_tap_good, 'notes_tap_miss': self.notes_tap_miss, 'notes_hold_cp': self.notes_hold_cp, 'notes_hold_p': self.notes_hold_p, 'notes_hold_great': self.notes_hold_great, 'notes_hold_good': self.notes_hold_good, 'notes_hold_miss': self.notes_hold_miss, 'notes_slide_cp': self.notes_slide_cp, 'notes_slide_p': self.notes_slide_p, 'notes_slide_great': self.notes_slide_great, 'notes_slide_good': self.notes_slide_good, 'notes_slide_miss': self.notes_slide_miss, 'notes_touch_cp': self.notes_touch_cp, 'notes_touch_p': self.notes_touch_p, 'notes_touch_great': self.notes_touch_great, 'notes_touch_good': self.notes_touch_good, 'notes_touch_miss': self.notes_touch_miss, 'notes_break_cp': self.notes_break_cp, 'notes_break_p': self.notes_break_p, 'notes_break_great': self.notes_break_great, 'notes_break_good': self.notes_break_good, 'notes_break_miss': self.notes_break_miss, 'maxcombo': self.maxcombo, 'maxsync': self.maxsync, 'level_img_s': self.level_img_s, 'name': self.name, 'cache_dt': self.cache_dt, } return num def save(self): db.session.add(self) db.session.commit() return self def update(self): db.session.commit() return self
class Record(db.Model): __bind_key__ = 'maimai' __tablename__ = 'record' id = db.Column(db.Integer, primary_key=True) level_img_s = db.Column(db.VARCHAR(50)) vs_img_s = db.Column(db.VARCHAR(50)) track = db.Column(db.Integer) play_dt = db.Column(db.DateTime, nullable=False) play_dt_utc = db.Column(db.DateTime, nullable=False) clear = db.Column(db.Boolean) name = db.Column(db.VARCHAR(50)) img_s = db.Column(db.VARCHAR(255)) dx_img_s = db.Column(db.VARCHAR(50)) achievement = db.Column(db.Float(4)) score_rank_new = db.Column(db.Boolean) score_rank_img_s = db.Column(db.VARCHAR(50)) delux_score = db.Column(db.Integer) delux_new = db.Column(db.Boolean) fc_img_s = db.Column(db.VARCHAR(50)) fs_img_s = db.Column(db.VARCHAR(50)) rate_img_s = db.Column(db.VARCHAR(50)) single_rating = db.Column(db.FLOAT(4), default=0) cache_dt = db.Column(db.DateTime, nullable=False) def __init__(self, level_img_s, vs_img_s, track, play_dt, play_dt_utc, clear, name, img_s, dx_img_s, achievement, score_rank_new, score_rank_img_s, delux_score, delux_new, fc_img_s, fs_img_s, rate_img_s, cache_dt): self.level_img_s = level_img_s, self.vs_img_s = vs_img_s, self.track = track, self.play_dt = play_dt, self.play_dt_utc = play_dt_utc, self.clear = clear self.name = name, self.img_s = img_s, self.dx_img_s = dx_img_s, self.achievement = achievement, self.score_rank_new = score_rank_new self.score_rank_img_s = score_rank_img_s, self.delux_score = delux_score, self.delux_new = delux_new self.fc_img_s = fc_img_s, self.fs_img_s = fs_img_s, self.rate_img_s = rate_img_s, self.cache_dt = cache_dt, def __repr__(self): return '<PlayerData (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)>' % ( self.level_img_s, self.vs_img_s, self.track, self.play_dt, self.play_dt_utc, self.clear, self.name, self.img_s, self.dx_img_s, self.achievement, self.score_rank_new, self.score_rank_img_s, self.delux_score, self.delux_new, self.fc_img_s, self.fs_img_s, self.rate_img_s, self.single_rating, self.cache_dt) def to_json(self): num = { 'id': self.id, 'level_img_s': self.level_img_s, 'vs_img_s': self.vs_img_s, 'track': self.track, 'play_dt': self.play_dt, 'play_dt_utc': self.play_dt_utc, 'clear': self.clear, 'name': self.name, 'img_s': self.img_s, 'dx_img_s': self.dx_img_s, 'achievement': self.achievement, 'score_rank_new': self.score_rank_new, 'score_rank_img_s': self.score_rank_img_s, 'delux_score': self.delux_score, 'delux_new': self.delux_new, 'fc_img_s': self.fc_img_s, 'fs_img_s': self.fs_img_s, 'rate_img_s': self.rate_img_s, 'single_rating': self.single_rating, 'cache_dt': self.cache_dt, } return num def save(self): db.session.add(self) db.session.commit() return self def update(self): db.session.commit() return self
class HOME(db.Model): __bind_key__ = 'maimai' __tablename__ = 'home' id = db.Column(db.Integer, primary_key=True) basic_img = db.Column(db.VARCHAR(255)) trophy = db.Column(db.VARCHAR(50)) name = db.Column(db.VARCHAR(50)) rating = db.Column(db.Integer) rating_max = db.Column(db.Integer) rating_img = db.Column(db.VARCHAR(255)) grade_img = db.Column(db.VARCHAR(255)) star = db.Column(db.Integer) chara = db.Column(db.VARCHAR(255)) comment = db.Column(db.VARCHAR(255)) cache_dt = db.Column(db.DateTime, nullable=False) def __init__(self, basic_img, trophy, name, rating, rating_max, rating_img, grade_img, star, chara, comment, cache_dt): self.basic_img = basic_img, self.trophy = trophy, self.name = name, self.rating = rating, self.rating_max = rating_max, self.rating_img = rating_img, self.grade_img = grade_img, self.star = star, self.chara = chara, self.comment = comment, self.cache_dt = cache_dt def __repr__(self): return '<HOME (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, )>' % ( self.id, self.basic_img, self.trophy, self.name, self.rating, self.rating_max, self.rating_img, self.grade_img, self.star, self.chara, self.comment, self.cache_dt) def to_json(self): num = { 'id': self.id, 'basic_img': self.basic_img, 'trophy': self.trophy, 'name': self.name, 'rating': self.rating, 'rating_max': self.rating_max, 'rating_img': self.rating_img, 'grade_img': self.grade_img, 'star': self.star, 'chara': self.chara, 'comment': self.comment, 'cache_dt': self.cache_dt } return num def save(self): db.session.add(self) db.session.commit() return self def update(self): db.session.commit() return self