def addBlog():
result = {"seq": "seq", "cmd": "cmd", "data": {}, "code": "0", "msg": "ok"}
request_json = request.get_json()
title = request_json.get('title', '')
content = request_json.get('content', '')
categories = request_json.get('categories', '')
author = request_json.get('author', '')
connection = get_connection()
try:
with connection.cursor() as cursor:
sql = '''
INSERT INTO `test_nacos`.`blog` (
`title`,
`content`,
`author`,
`type`
)
VALUES
(
"{}","{}","{}","{}"
)
'''.format(title, content, author, categories)
print(sql)
cursor.execute(sql)
connection.commit()
sqldata = cursor.fetchall()
finally:
connection.close()
result['data'] = sqldata
return jsonify(result)
def search_thesis_by_id(id):
conn = get_connection()
with conn.cursor() as cursor:
cursor.execute('select * from thesis where id = :id', {'id': id})
result = dict_mapper(cursor)
return result
def search_faculty_by_email(email):
conn = get_connection()
with conn.cursor() as cursor:
cursor.execute(
'select * from faculty where upper(email) like upper(:email)',
{'email': '%' + email + '%'})
result = dict_mapper(cursor)
return result
def search_faculty_by_name(name):
conn = get_connection()
with conn.cursor() as cursor:
cursor.execute(
'select * from faculty where upper(name) like upper(:name)',
{'name': '%' + name + '%'
}) # needed for capitalizing names, or else search doesn't work
result = dict_mapper(cursor)
return result
def search_thesis_by_name(name):
conn = get_connection()
with conn.cursor() as cursor:
cursor.execute(
'select * from thesis where upper(NAME) like upper(:name)',
{'name': '%' + name + '%'})
result = dict_mapper(cursor)
return result
def search_faculty_by_phone(phone):
conn = get_connection()
with conn.cursor() as cursor:
cursor.execute(
'select * from faculty where upper(PHONE) like upper(:phone)',
{'phone': '%' + phone + '%'})
result = dict_mapper(cursor)
return result
def update_faculty_procedure(id, name, email, phone_number, did):
conn = get_connection()
with conn.cursor() as cursor:
try:
cursor.callproc('faculty_package.update_faculty',
[id, name, email, phone_number, did])
conn.commit()
return "success"
except DatabaseError as err:
error_obj, = err.args
print("error CODE: ", error_obj.code)
print("error MESSAGE: ", error_obj.message.split("\n")[0])
return error_message(error_obj.message)
def getBlog():
result = {"seq": "seq", "cmd": "cmd", "data": {}, "code": "0", "msg": "ok"}
print("start blog")
connection = get_connection()
try:
with connection.cursor() as cursor:
sql = '''
SELECT * FROM `test_nacos`.`blog` ORDER BY `id` DESC ;
'''
cursor.execute(sql)
sqldata = cursor.fetchall()
finally:
connection.close()
result['data'] = sqldata
return jsonify(result)
def getBlogById():
result = {"seq": "seq", "cmd": "cmd", "data": {}, "code": "0", "msg": "ok"}
print("start blog")
connection = get_connection()
id = request.args.get("id")
print(id)
try:
with connection.cursor() as cursor:
sql = '''
SELECT * FROM `test_nacos`.`blog` where id = '{}' ;
'''.format(id)
print(sql)
cursor.execute(sql)
sqldata = cursor.fetchall()
finally:
connection.close()
result['data'] = sqldata
return jsonify(result)
get_jwt [username] [password] - get JWT for Swagger API
drop - drop 'dnd_database'"""
if len(sys.argv) == 1:
print(usage)
elif len(sys.argv) > 1:
if sys.argv[1] == "seed":
parse_spells(spell_file)
create_classes()
create_races()
link_spells()
insert_items()
insert_weapons()
insert_armor()
if len(sys.argv) == 3:
if sys.argv[2] == "all":
create_users()
create_characters()
elif sys.argv[2] == "players":
create_users()
elif sys.argv[2] == "chars":
create_characters()
elif sys.argv[1] == "drop":
db.get_connection().drop_database('dnd_database')
elif sys.argv[1] == "get_jwt":
if not len(sys.argv) == 4:
print(usage)
print(get_jwt(sys.argv[2], sys.argv[3]))
else:
print(usage)
