def get(self):
parser = reqparse.RequestParser()
parser.add_argument('court_id',
required=True,
help="court_id cannot be blank!")
parser.add_argument('court_status_list_id',
required=True,
help="court_status_list_id cannot be blank!")
parser.add_argument('valid_from',
required=True,
help="valid_from cannot be blank!")
parser.add_argument('valid_to',
required=True,
help="valid_to cannot be blank!")
parser.add_argument('changed_by',
required=True,
help="changed_by cannot be blank!")
args = parser.parse_args()
sql_court_status_update = QUERY_CALL_COURT_STATUS_INSERT.format(
args['court_id'], args['court_status_list_id'], args['valid_from'],
args['valid_to'], args['changed_by'])
court_status_update = database_processor.fetch_data_in_database(
sql_court_status_update)
column = ['update_status']
items = [dict(zip(column, row)) for row in court_status_update]
return items
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 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 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 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):
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_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 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
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 = file_processor.read_sql_file(
"sql/task_details_comments.sql")
sql_statement = QUERY_SELECT.format(args['task_no'])
row_list = database_processor.fetch_data_in_database(sql_statement)
column = [
'relationship_type', 'title', 'comment', 'created_at',
'modified_at', 'person_no', 'first_name', 'last_name'
]
items = [dict(zip(column, row)) for row in row_list]
return items
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 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 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 get(self):
parser = reqparse.RequestParser()
parser.add_argument('members_no', required=True,
help="members_no cannot be blank!")
parser.add_argument('valid_from', required=True,
help="valid_from cannot be blank!")
parser.add_argument('valid_to', required=True,
help="valid_to cannot be blank!")
args = parser.parse_args()
QUERY_SELECT_BENEFIT = file_processor.read_sql_file(
"sql/select_benefit.sql")
sql_benefit = QUERY_SELECT_BENEFIT.format(
args['members_no'], args['valid_from'], args['valid_to'])
benefit = database_processor.fetch_data_in_database(sql_benefit)
column = ['member_no', 'description', 'sum_part_time', 'sum_claim']
items = [dict(zip(column, row)) for row in benefit]
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)