def deleteanimelist(): # if request.method == 'POST': content = request.get_json(silent=True) updateanimelist = Managedb() updateanimelist.deletedb(content, current_user.uid) return "Update Successful"
def getlclist(): content = request.get_json(silent=True) firstIndex = content['page'] * content['perPage'] - content['perPage'] lastIndex = firstIndex + content['perPage'] - 1 content = {k: v for k, v in content.items() if v is not None} getnaimelist = Managedb() df = pd.DataFrame(getnaimelist.readlclist(), columns=[ 'animelicenseid', 'anilistid', 'romaji', 'season', 'year', 'format', 'imgurl', 'licensor', 'musethyt', 'bilibili', 'aisplay', 'netflix', 'anioneyt', 'iqiyi', 'flixer', 'wetv', 'trueid', 'viu', 'pops', 'linetv', 'amazon', 'iflix' ]) df = df.sort_values(by=['year'], ascending=False, ignore_index=True) df = df.fillna(0) if len(df.index) - 1 < firstIndex: return "Page ended" if (len(df.index) - 1 < lastIndex): lastIndex = len(df.index) - 1 df = df.loc[firstIndex:lastIndex] json = df.to_dict('records') return jsonify(json)
def signup(): if current_user.is_authenticated: return "Already login" form = RegisterForm() content = request.get_json(silent=True) if len(content['uname']) < 5 and len(content['pwd']) < 5: return 'Username and password must contain 5 character or more' for x in FORBIDDEN_STRING: if content['uname'].find(x) > -1: warning = 'Username must not contain spacebar and any of the follow characters: \", \\, /, :, ?, *, <, >, |' return warning hashed_password = generate_password_hash(content['pwd'], method='sha256') readuser = Managedb() userlist = readuser.readuserlist() count = 0 _isuidGenerate = False for x in userlist: if x[1] == content['uname']: return "Username already taken" for x in userlist: if x[0] != count: newuseruid = count _isuidGenerate = True break count += 1 if _isuidGenerate == False: newuseruid = count new_user = Userdata(uid=newuseruid, uname=content['uname'], pwd=hashed_password) db.session.add(new_user) db.session.commit() return 'Register successful'
def addanime(): content = request.get_json(silent=True) addtodb = Managedb() addtodb.writedb(content, current_user.uid) return "Update Successful"
def getanimelist(): getnaimelist = Managedb() df = pd.DataFrame(getnaimelist.readdb(current_user.uid), columns=[ 'listid', 'uid', 'anilistid', 'malid', 'status', 'episode', 'rating', 'romaji', 'imgurl', 'totaleps' ]) df = df.sort_values(by=['romaji'], ascending=True) json = df.to_dict('records') return jsonify(json)
def changepassword(): content = request.get_json(silent=True) if len(content['newpwd']) < 5: return 'Username and password must contain 5 character or more' if check_password_hash(current_user.pwd, content['oldpwd']): hashed_password = generate_password_hash(content['newpwd'], method='sha256') changepwd = Managedb() changepwd.updateuserpassword(current_user.uid, hashed_password) return "Change password successful" warning = 'Old password is incorrect' return warning
def filterlclist(): # if request.method == 'POST': getnaimelist = Managedb() content = request.get_json(silent=True) try: print(content['perPage']) print(content['page']) except: print("Value error") return "Value error" # content = {'season': 'Winter'} firstIndex = content['page'] * content['perPage'] - content['perPage'] lastIndex = firstIndex + content['perPage'] - 1 content['perPage'] = None content['page'] = None df = pd.DataFrame(getnaimelist.readlclist(), columns=[ 'animelicenseid', 'anilistid', 'romaji', 'season', 'year', 'format', 'imgurl', 'licensor', 'musethyt', 'bilibili', 'aisplay', 'netflix', 'anioneyt', 'iqiyi', 'flixer', 'wetv', 'trueid', 'viu', 'pops', 'linetv', 'amazon', 'iflix' ]) if content['streaming'] != None: df = df.loc[df[content['streaming']] == 1] del content['streaming'] content = {k: v for k, v in content.items() if v is not None} df = df.loc[(df[list(content)] == pd.Series(content)).all(axis=1)] df = df.reset_index(drop=False) if len(df.index) - 1 < firstIndex: return "Page ended" if (len(df.index) - 1 < lastIndex): lastIndex = len(df.index) - 1 df = df.loc[firstIndex:lastIndex] df = df.sort_values(by=['year'], ascending=True, ignore_index=True) df = df.fillna(0).reset_index() json = df.to_dict('records') return jsonify(json)
def searchlclist(): content = request.get_json(silent=True) try: print(content['search']) print(content['perPage']) print(content['page']) except: print("Value error") return "Value error" firstIndex = content['page'] * content['perPage'] - content['perPage'] lastIndex = firstIndex + content['perPage'] - 1 content = {k: v for k, v in content.items() if v is not None} if content['search'] == None: return jsonify([]) if len(content['search']) < 2: return jsonify([]) getnaimelist = Managedb() df = pd.DataFrame(getnaimelist.readlclist(), columns=[ 'animelicenseid', 'anilistid', 'romaji', 'season', 'year', 'format', 'imgurl', 'licensor', 'musethyt', 'bilibili', 'aisplay', 'netflix', 'anioneyt', 'iqiyi', 'flixer', 'wetv', 'trueid', 'viu', 'pops', 'linetv', 'amazon', 'iflix' ]) df = df[df['romaji'].str.lower().str.contains(content['search'].lower())] df = df.sort_values(by=['year'], ascending=True, ignore_index=True) df = df.fillna(0) if len(df.index) - 1 < firstIndex: return "Page ended" if (len(df.index) - 1 < lastIndex): lastIndex = len(df.index) - 1 df = df.loc[firstIndex:lastIndex] json = df.to_dict('records') return jsonify(json)
def getlcbyid(): content = request.get_json(silent=True) content = {k: v for k, v in content.items() if v is not None} getnaimelist = Managedb() df = pd.DataFrame(getnaimelist.readlcbyid(content['anilistid']), columns=[ 'animelicenseid', 'anilistid', 'romaji', 'season', 'year', 'format', 'imgurl', 'licensor', 'musethyt', 'bilibili', 'aisplay', 'netflix', 'anioneyt', 'iqiyi', 'flixer', 'wetv', 'trueid', 'viu', 'pops', 'linetv', 'amazon', 'iflix' ]) df = df.sort_values(by=['year'], ascending=True, ignore_index=True) df = df.fillna(0) json = df.to_dict('records') return jsonify(json)
def updateanimelist(): content = request.get_json(silent=True) updateanimelist = Managedb() updateanimelist.updatedb(content, current_user.uid) return "Update Successful"