def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
title = ''
data_dic = json.loads(json.dumps(req_data))
titleExists = "title" in data_dic
if titleExists:
title = req_data['title']
else:
title = "NULL"
suggestion = Suggestion(req_data['typeId'], title,
req_data['story'], req_data['serverId'],
req_data['discordUserId'])
isSubmitted = SQL.submit_item_suggestion(suggestion)
if isSubmitted:
response = app.response_class(response=json.dumps(
{"Message": "Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
story = StoryModel(req_data[0]['Id'], req_data[0]['Title'],
req_data[0]['Story'],
req_data[0]['luS'][0]['ServerId'],
req_data[0]['IsActive'])
updated = SQL.update_story(story)
if updated:
response = app.response_class(response=json.dumps(
{"Message": "Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
password = ChangePasswordModel(req_data['userId'],
req_data['password'])
isUpdated = SQL.update_user_password(password)
if isUpdated:
response = app.response_class(response=json.dumps(
{"Message": "Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Fail"}),
status=424,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Fail"}),
status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
data = req_data['data']['FieldInfo']
userId = req_data['userId']
isNew = req_data['isNew']
form = FormModel(data['FormKey'], data['FieldSchema'],
data['ActionLink'], data['IsActive'],
req_data['formName'])
isUpdated = False
if isNew:
isUpdated = SQL.create_form(form, userId)
else:
isUpdated = SQL.update_form(form, userId)
if isUpdated:
response = app.response_class(response=json.dumps(
{"Message": "Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
user = RegisterAccountUser(req_data['accountid'],
req_data['username'],
req_data['firstname'],
req_data['lastname'],
req_data['discorduserid'],
req_data['password'])
isAuth = SQL.registerUser(user)
if isAuth:
response = app.response_class(response=json.dumps(
{"Message": "Register Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
isApproved = req_data['IsApproved']
id = req_data['Id']
userId = req_data['UserId']
isUpdated = SQL.update_submitted_item(isApproved, id, userId)
if isUpdated:
response = app.response_class(response=json.dumps(
{"Message": "Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
profile = AccountProfile(req_data['AccountId'],
req_data['AccountName'],
req_data['CreateDate'],
req_data['IsActive'])
data = SQL.update_account(profile)
if data:
response = app.response_class(response=json.dumps(data),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=200,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
data = request.get_json()
data = data[0]
role = data['r'][0]
role = role['Role']
discordUserId = None
data_dic = json.loads(json.dumps(data))
discordExists = "DiscordUserId" in data_dic
if discordExists:
discordUserId = data['DiscordUserId']
else:
discordUserId = "NULL"
userInfo = UserProfile(data['Username'], data['FirstName'],
data['LastName'], discordUserId,
data['IsActive'], data['IsLocked'], role)
SQL.update_user(userInfo)
response = app.response_class(response=json.dumps(
{"Message": "Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
pageId = request.args.get('pageId')
forms = SQL.get_all_forms_by_pageId(pageId)
forms = forms[0]
response = app.response_class(response=json.dumps(forms),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
data = SQL.get_all_roles()
response = app.response_class(response=json.dumps(data),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
formKey = request.args.get('formKey')
data = SQL.get_form_name(formKey)
response = app.response_class(response=json.dumps(data),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
userId = request.args.get('userId')
data = SQL.get_user_by_id(userId)
response = app.response_class(response=json.dumps(data),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
id = request.args.get('id')
wisdom = SQL.get_wisdom_by_id(id)
response = app.response_class(response=json.dumps(wisdom),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
paginationModel = PaginationHelper(
request.args, 'FormKey', ["FormKey", "FormName", "IsActive"])
forms = SQL.get_all_forms(paginationModel)
response = app.response_class(response=json.dumps(forms),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
accountId = request.args.get('accountId')
servers = SQL.get_servers_by_account(accountId)
response = app.response_class(response=json.dumps(servers),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def post(self):
req_data = request.get_json()
if req_data['token'] == "30hJtsCWVXRR6qX_vOx1YHmm6guK9tq_YUa_nJqu-4Q=":
key = Fernet.generate_key()
returnVal = {"Key": key}
response = app.response_class(data=json.dumps(returnVal),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=401,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
paginationModel = PaginationHelper(request.args, 'Title',
["Title", "Story", "IsActive"])
stories = SQL.get_all_stories(paginationModel)
response = app.response_class(response=json.dumps(stories),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
paginationModel = PaginationHelper(request.args, 'CreateDate', [
"Title", "CreateDate", "ItemType", "IsApproved", "IsReviewed"
])
items = SQL.get_submitted_items(paginationModel)
response = app.response_class(response=json.dumps(items),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
accountId = request.args.get('accountId')
isMaster = request.args.get('isMaster')
accountInformation = SQL.get_account_info_by_id(accountId)
response = app.response_class(
response=json.dumps(accountInformation),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
helpContentKey = request.args.get('helpContentKey')
isAdmin = request.args.get('isAdmin')
#do something here
helpContent = SQL.get_documentation(helpContentKey, isAdmin)
response = app.response_class(response=json.dumps(helpContent),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
user = User(req_data['username'], req_data['password'])
isAuth = SQL.login(user)
if isAuth:
response = app.response_class(response=json.dumps(isAuth),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
paginationModel = PaginationHelper(
request.args, 'HelpContentKey',
["HelpContentKey", "HelpTitle", "HelpContent", "IsActive"])
content = SQL.get_all_documentation(paginationModel)
response = app.response_class(response=json.dumps(content),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
id = request.args.get('id')
suggestion = SQL.get_submitted_item_by_id(id)
if suggestion:
response = app.response_class(response=json.dumps(suggestion),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
id = 0
data_dic = json.loads(json.dumps(req_data))
idExists = "Id" in data_dic
if idExists:
id = req_data['Id']
else:
id = 0
serverData = AccountServerModel(req_data['Id'],
req_data['ServerId'],
req_data['AccountId'],
req_data['Nickname'],
req_data['DailyWisdom'],
req_data['WeeklyStory'])
isSuccess = SQL.update_server(serverData)
if isSuccess:
response = app.response_class(response=json.dumps(
{"Message": "Success"}),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
else:
response = app.response_class(response=json.dumps(
{"Message": "Failure"}),
status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
isMaster = request.args.get('isMaster')
paginationModel = PaginationHelper(request.args, 'Username', [
"Id", "Username", "FirstName", "LastName", "IsActive",
"CreateDate"
])
data = SQL.get_all_users(isMaster, paginationModel)
response = app.response_class(response=json.dumps(data),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
accountId = request.args.get('accountId')
isMaster = request.args.get('masterAdmin')
paginationModel = PaginationHelper(request.args, "Username", [
"Username", "FirstName", "LastName", "IsActive", "IsLocked",
"CreateDate"
])
accountInformation = SQL.get_account_users(accountId, isMaster,
paginationModel)
response = app.response_class(
response=json.dumps(accountInformation),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def post(self):
if SQL.test_connect_to_dbo():
req_data = request.get_json()
#do something here
documentation = Documentation(req_data['helpContentKey'],
req_data['helpTitle'],
req_data['helpContent'],
req_data['isActive'],
req_data['userId'],
req_data['admin'])
helpContent = SQL.update_documentation(documentation)
response = app.response_class(response=json.dumps(helpContent),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
def get(self):
if SQL.test_connect_to_dbo():
serverId = request.args.get('id')
selectItem = SQL.get_select_item(serverId)
sql = Helpers.built_select_item_query(selectItem)
items = SQL.execute_built_query(sql)
nameValueKey = Helpers.get_name_and_value_columns(selectItem)
itemsToReturn = {"Items": items, "NameValueCols": nameValueKey}
response = app.response_class(response=json.dumps(itemsToReturn),
status=200,
mimetype='application/json')
return response
else:
response = app.response_class(status=424,
mimetype='application/json')
return response
