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)