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 get(self):
QUERY_SELECT_CONDITION_LIST = file_processor.read_sql_file(
"sql/condition/select_condition_list.sql")
recipeList = database_processor.fetch_data_in_database_pd_dataframe(
QUERY_SELECT_CONDITION_LIST).to_dict(orient="records")
# START - Get nextId
QUERY_NEXTID_CONDITION = file_processor.read_sql_file(
"sql/condition/nextid_condition.sql")
sql_creation = QUERY_NEXTID_CONDITION
nextId = database_processor.fetch_data_in_database(sql_creation)
# END - Get nextId
if recipeList:
return {'payload': recipeList, 'nextId': nextId[0][0]}
api.abort(404)
def get(self):
QUERY_SELECT_QUANTITY_TYPE_LIST = file_processor.read_sql_file(
"sql/quantity_type/select_quantity_type_list.sql")
recipeList = database_processor.fetch_data_in_database_pd_dataframe(
QUERY_SELECT_QUANTITY_TYPE_LIST).to_dict(orient="records")
# 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
if recipeList:
return {'payload': recipeList, 'nextId': nextId[0][0]}
api.abort(404)
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 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 get(self):
args = getParser.parse_args()
QUERY_SELECT_SPICE = file_processor.read_sql_file(
"sql/spice/select_spice.sql")
sql_creation = QUERY_SELECT_SPICE.format(args['spice_id'])
recipeList = database_processor.fetch_data_in_database_pd_dataframe(
sql_creation).to_dict(orient="records")
# START - Get nextId
QUERY_NEXTID_SPICE = file_processor.read_sql_file(
"sql/spice/nextid_spice.sql")
sql_creation = QUERY_NEXTID_SPICE
nextId = database_processor.fetch_data_in_database(sql_creation)
# END - Get nextId
if recipeList:
return {'payload': recipeList, 'nextId': nextId[0][0]}
api.abort(404)
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_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 get(self):
args = getParser.parse_args()
QUERY_SELECT_INGREDIENT = file_processor.read_sql_file(
"sql/ingredient/select_ingredient.sql")
sql_creation = QUERY_SELECT_INGREDIENT.format(args['ingredient_id'])
recipeList = database_processor.fetch_data_in_database_pd_dataframe(
sql_creation).to_dict(orient="records")
# START - Get nextId
QUERY_NEXTID_INGREDIENT = file_processor.read_sql_file(
"sql/ingredient/nextid_ingredient.sql")
sql_creation = QUERY_NEXTID_INGREDIENT
nextId = database_processor.fetch_data_in_database(sql_creation)
# END - Get nextId
if recipeList:
return {'payload': recipeList, 'pk_autofill': nextId[0][0]}
api.abort(404)
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_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 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 get(self):
sql_court_status_list = file_processor.read_sql_file(
"sql/select_court_status_list.sql")
all_court_status_list = database_processor.fetch_data_in_database(
sql_court_status_list)
column = ['court_status_list_id', 'court_status_name']
items = [dict(zip(column, row)) for row in all_court_status_list]
return items
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 get(self):
QUERY_SELECT_INGREDIENT_LIST = file_processor.read_sql_file(
"sql/ingredient/select_ingredient_list.sql")
recipeList = database_processor.fetch_data_in_database_pd_dataframe(
QUERY_SELECT_INGREDIENT_LIST).to_dict(orient="records")
print(recipeList)
# 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).to_dict(orient="records")[0]
print(pk_autofill)
# END - Get nextId
if recipeList:
return {'payload': recipeList, 'pk_autofill': pk_autofill}
api.abort(404)
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)
def get(self):
QUERY_SELECT = file_processor.read_sql_file(
"sql/court_status_list.sql")
sql_statement = QUERY_SELECT
row_list = database_processor.fetch_data_in_database(sql_statement)
column = ['court_status_list_id', 'court_status_name']
items = [dict(zip(column, row)) for row in row_list]
return items
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 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_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 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_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 get(self):
QUERY_SELECT_ALL_TASKS = file_processor.read_sql_file(
"sql/select_all_tasks.sql")
sql_all_tasks = QUERY_SELECT_ALL_TASKS
all_tasks = self.database_processor.fetch_data_in_database(
sql_all_tasks)
column = [
'task_no', 'title', 'description', 'created_at', 'modified_at',
'due_date', 'resolution_date', 'priority', 'task_status'
]
items = [dict(zip(column, row)) for row in all_tasks]
return items
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 get(self):
parser = reqparse.RequestParser()
parser.add_argument('person_no',
required=True,
help="person_no cannot be blank!")
args = parser.parse_args()
QUERY_SELECT = file_processor.read_sql_file(
"sql/select_person_info.sql")
sql_statement = QUERY_SELECT.format("\'{}\'".format(args['person_no']))
row_list = database_processor.fetch_data_in_database(sql_statement)
column = ['person_no', 'first_name', 'last_name', 'member_no', 'role']
items = [dict(zip(column, row)) for row in row_list]
return items
def get(self):
parser = reqparse.RequestParser()
parser.add_argument('task_no',
required=True,
help="task_no cannot be blank!")
args = parser.parse_args()
QUERY_SELECT_TASK_DETAIL = file_processor.read_sql_file(
"sql/select_task_details.sql")
sql_task_detail = QUERY_SELECT_TASK_DETAIL.format(args['task_no'])
task_detail = database_processor.fetch_data_in_database(
sql_task_detail)
column = ['relationship_type', 'person_no', 'first_name', 'last_name']
items = [dict(zip(column, row)) for row in task_detail]
return items
def get(self):
QUERY_SELECT_RECIPE_LIST = file_processor.read_sql_file(
"sql/recipe/select_recipe_list.sql")
recipeList = database_processor.fetch_data_in_database_pd_dataframe(
QUERY_SELECT_RECIPE_LIST)
recipes = recipeList.groupby(['recipe_id', 'recipe_name'],
as_index=False).max('duration')[[
'recipe_id', 'recipe_name', 'duration'
]].rename(columns={
'recipe_name': 'name'
}).to_dict(orient="records")
tagList = recipeList.groupby(
['recipe_id', 'tag_name', 'tag_group'], as_index=False
).last()[['recipe_id', 'tag_name', 'tag_group']].to_dict(
orient="records"
) # .groupby(['recipe_id']).tag_name_group.apply(list).reset_index().to_dict(orient="records")
items = []
for recipe_r in recipes:
recipe_r['tags'] = []
for recipe_tl in tagList:
if recipe_r['recipe_id'] == recipe_tl['recipe_id']:
tag = {
key: recipe_tl[key]
for key in ['tag_name', 'tag_group']
}
recipe_r['tags'].append(tag)
items.append(recipe_r)
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
if items:
return {'payload': items, 'nextId': nextId[0][0]}
api.abort(404)
def get(self):
parser = reqparse.RequestParser()
parser.add_argument('date',
required=True,
help="date cannot be blank!")
args = parser.parse_args()
QUERY_SELECT = file_processor.read_sql_file(
"sql/court_status_date.sql")
sql_statement = QUERY_SELECT.format(args['date'])
row_list = database_processor.fetch_data_in_database(sql_statement)
column = [
'court_id', 'court_no', 'court_status_name', 'court_surface',
'court_type'
]
items = [dict(zip(column, row)) for row in row_list]
return items
