def delete(self): args = deleteParser.parse_args() QUERY_DELETE_TAG = file_processor.read_sql_file( "sql/tag/delete_tag.sql") sql_creation = QUERY_DELETE_TAG.format(args['tag_id']) database_processor.insert_data_into_database(sql_creation) return 201
def put(self): # court_id, court_status_list_id, valid_from, valid_to, modified_at, changed_by court_id = request.args.get('court_id') if not request.args.get("court_id"): raise RuntimeError("court_id is missing") court_status_list_id = request.args.get('court_status_list_id') if not request.args.get("court_status_list_id"): raise RuntimeError("court_status_list_id is missing") valid_from = request.args.get('valid_from') if not request.args.get("valid_from"): raise RuntimeError("valid_from is missing") valid_to = request.args.get('valid_to') if not request.args.get("valid_to"): raise RuntimeError("valid_to is missing") changed_by = request.args.get('changed_by') if not request.args.get("changed_by"): raise RuntimeError("changed_by is missing") modified_at = request.args.get('modified_at') if modified_at == '': modified_at = 'NULL' QUERY_INSERT = file_processor.read_sql_file( "sql/court_status_insert.sql") sql_insert_statement = QUERY_INSERT.format(court_id, court_status_list_id, "\'{}\'".format(valid_from), "\'{}\'".format(valid_to), modified_at, "\'{}\'".format(changed_by)) database_processor.insert_data_into_database(sql_insert_statement) return 201
def delete(self): args = deleteParser.parse_args() QUERY_DELETE_RECIPE = file_processor.read_sql_file( "sql/recipe/delete_recipe.sql") sql_creation = QUERY_DELETE_RECIPE.format(args['recipe_id']) database_processor.insert_data_into_database(sql_creation) return 201
def delete(self): args = deleteParser.parse_args() QUERY_DELETE_CONDITION = file_processor.read_sql_file( "sql/condition/delete_condition.sql") sql_creation = QUERY_DELETE_CONDITION.format(args['condition_id']) database_processor.insert_data_into_database(sql_creation) return 201
def delete(self): args = deleteParser.parse_args() QUERY_DELETE_SPICE = file_processor.read_sql_file( "sql/spice/delete_spice.sql") sql_creation = QUERY_DELETE_SPICE.format(args['spice_id']) database_processor.insert_data_into_database(sql_creation) return 201
def delete(self): args = deleteParser.parse_args() QUERY_DELETE_INGREDIENT = file_processor.read_sql_file( "sql/ingredient/delete_ingredient.sql") sql_creation = QUERY_DELETE_INGREDIENT.format(args['ingredient_id']) database_processor.insert_data_into_database(sql_creation) return 201
def put(self): args = updateParser.parse_args() QUERY_PUT_RECIPE = file_processor.read_sql_file( "sql/recipe/put_recipe.sql") sql_creation = QUERY_PUT_RECIPE.format("\'{}\'".format(args['name']), args['recipe_id']) database_processor.insert_data_into_database(sql_creation) return 201
def put(self): args = updateParser.parse_args() QUERY_PUT_CONDITION = file_processor.read_sql_file( "sql/condition/put_condition.sql") sql_creation = QUERY_PUT_CONDITION.format( "\'{}\'".format(args['name']), args['condition_id']) database_processor.insert_data_into_database(sql_creation) return 201
def put(self): args = updateParser.parse_args() QUERY_PUT_TAG = file_processor.read_sql_file("sql/tag/put_tag.sql") sql_creation = QUERY_PUT_TAG.format("\'{}\'".format(args['tag_group']), "\'{}\'".format(args['name']), args['tag_id']) database_processor.insert_data_into_database(sql_creation) return 201
def delete(self): args = deleteParser.parse_args() QUERY_DELETE_QUANTITY_TYPE = file_processor.read_sql_file( "sql/quantity_type/delete_quantity_type.sql") sql_creation = QUERY_DELETE_QUANTITY_TYPE.format( args['quantity_type_id']) database_processor.insert_data_into_database(sql_creation) return 201
def post(self): args = postParser.parse_args() QUERY_POST_RECIPE_TAG = file_processor.read_sql_file( "sql/recipe_tag/post_recipe_tag.sql") sql_creation = QUERY_POST_RECIPE_TAG.format(args['recipe_id'], args['tag_id']) sql_creation = sql_processor.handleNone(sql_creation) database_processor.insert_data_into_database(sql_creation) return 201
def put(self): args = updateParser.parse_args() QUERY_PUT_QUANTITY_TYPE = file_processor.read_sql_file( "sql/quantity_type/put_quantity_type.sql") sql_creation = QUERY_PUT_QUANTITY_TYPE.format( "\'{}\'".format(args['quantity_type']), "\'{}\'".format(args['abbreviation']), args['quantity_type_id']) database_processor.insert_data_into_database(sql_creation) return 201
def put(self): args = updateParser.parse_args() QUERY_PUT_INGREDIENT = file_processor.read_sql_file( "sql/ingredient/put_ingredient.sql") sql_creation = QUERY_PUT_INGREDIENT.format( "\'{}\'".format(args['name']), "\'{}\'".format(args['description']), args['ingredient_id']) sql_creation = sql_processor.handleNone(sql_creation) database_processor.insert_data_into_database(sql_creation) return 201
def put(self): person_no = request.args.get('person_no') is_member = request.args.get('is_member') member_no = request.args.get('member_no') first_name = request.args.get('first_name') last_name = request.args.get('last_name') QUERY_INSERT_PERSON = file_processor.read_sql_file( "sql/insert_person.sql") sql_insert_person = QUERY_INSERT_PERSON.format( person_no, is_member, member_no, "\'{}\'".format(first_name), "\'{}\'".format(last_name)) database_processor.insert_data_into_database(sql_insert_person) return 201
def post(self): args = postParser.parse_args() QUERY_POST_RECIPE = file_processor.read_sql_file( "sql/recipe/post_recipe.sql") sql_creation = QUERY_POST_RECIPE.format("\'{}\'".format(args['name'])) sql_creation = sql_processor.handleNone(sql_creation) database_processor.insert_data_into_database(sql_creation) # START Get nextId QUERY_NEXTID_RECIPE = file_processor.read_sql_file( "sql/recipe/nextid_recipe.sql") sql_creation = QUERY_NEXTID_RECIPE nextId = database_processor.fetch_data_in_database(sql_creation) # END - Get nextId return ({'nextId': nextId[0][0]}, 201)
def post(self): args = postParser.parse_args() QUERY_POST_TAG = file_processor.read_sql_file("sql/tag/post_tag.sql") sql_creation = QUERY_POST_TAG.format( "\'{}\'".format(args['tag_group']), "\'{}\'".format(args['name'])) sql_creation = sql_processor.handleNone(sql_creation) database_processor.insert_data_into_database(sql_creation) # START Get nextId QUERY_NEXTID_TAG = file_processor.read_sql_file( "sql/tag/nextid_tag.sql") sql_creation = QUERY_NEXTID_TAG nextId = database_processor.fetch_data_in_database(sql_creation) # END - Get nextId return ({'nextId': nextId[0][0]}, 201)
def post(self): args = postParser.parse_args() QUERY_POST_QUANTITY_TYPE = file_processor.read_sql_file( "sql/quantity_type/post_quantity_type.sql") sql_creation = QUERY_POST_QUANTITY_TYPE.format( "\'{}\'".format(args['quantity_type']), "\'{}\'".format(args['abbreviation'])) sql_creation = sql_processor.handleNone(sql_creation) database_processor.insert_data_into_database(sql_creation) # START Get nextId QUERY_NEXTID_QUANTITY_TYPE = file_processor.read_sql_file( "sql/quantity_type/nextid_quantity_type.sql") sql_creation = QUERY_NEXTID_QUANTITY_TYPE nextId = database_processor.fetch_data_in_database(sql_creation) # END - Get nextId return ({'nextId': nextId[0][0]}, 201)
def post(self): args = postParser.parse_args() QUERY_POST_INGREDIENT = file_processor.read_sql_file( "sql/ingredient/post_ingredient.sql") sql_creation = QUERY_POST_INGREDIENT.format( "\'{}\'".format(args['name']), "\'{}\'".format(args['description'])) sql_creation = sql_processor.handleNone(sql_creation) database_processor.insert_data_into_database(sql_creation) # START Get nextId QUERY_NEXTID_INGREDIENT = file_processor.read_sql_file( "sql/ingredient/nextid_ingredient.sql") sql_creation = QUERY_NEXTID_INGREDIENT pk_autofill = database_processor.fetch_data_in_database_pd_dataframe( sql_creation) # END - Get nextId return ({'pk_autofill': pk_autofill}, 201)