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)
