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"