def get_approved_expired_request(self, current_block_no, filter_parameter):
sub_query, sub_query_values = generate_sub_query_for_filter_params(
filter_parameter=filter_parameter)
if sub_query != "":
sub_query = " AND " + sub_query
query_response = self.repo.execute(
"SELECT request_id, requester, fund_total, documentURI, expiration, end_submission, end_evaluation, "
"status, request_title, requester_name, description, git_hub_link, training_data_set_uri, "
"acceptance_criteria, request_actor, created_at FROM service_request WHERE status = 1 AND expiration < %s"
+ sub_query, [current_block_no] + sub_query_values)
return query_response
def get_request_data_for_given_requester_and_status(
self, filter_parameter):
sub_query, sub_query_values = generate_sub_query_for_filter_params(
filter_parameter=filter_parameter)
if sub_query != "":
sub_query = " WHERE " + sub_query
query_response = self.repo.execute(
"SELECT request_id, requester, fund_total, documentURI, expiration, end_submission, end_evaluation, "
"status, request_title, requester_name, description, git_hub_link, training_data_set_uri, "
"acceptance_criteria, request_actor, created_at FROM service_request "
+ sub_query, sub_query_values)
return query_response
def get_closed_request(self, requester, filter_parameter):
sub_query, sub_query_values = generate_sub_query_for_filter_params(
filter_parameter=filter_parameter)
if sub_query != "":
sub_query = " AND " + sub_query
query_response = self.repo.execute(
"SELECT request_id, requester, request_fund, fund_total, documentURI, expiration, end_submission, end_evaluation, "
"status, request_title, requester_name, description, git_hub_link, training_data_set_uri, "
"acceptance_criteria, request_actor, created_at FROM service_request WHERE (SELECT count(*) FROM "
"foundation_member WHERE member_address = %s or requester = %s) AND status = 4"
+ sub_query, [requester, requester] + sub_query_values)
return query_response
def get_approved_request_with_no_votes(self, current_block_no,
filter_parameter):
sub_query, sub_query_values = generate_sub_query_for_filter_params(
filter_parameter=filter_parameter)
if sub_query != "":
sub_query = " AND " + sub_query
query_response = self.repo.execute(
"SELECT request_id, requester, request_fund, fund_total, documentURI, expiration, end_submission, end_evaluation, "
"status, request_title, requester_name, description, git_hub_link, training_data_set_uri, "
"acceptance_criteria, request_actor, created_at FROM service_request WHERE status = %s AND expiration > %s AND "
"end_evaluation < %s AND request_id NOT IN (select request_id FROM rfai_vote rv) "
+ sub_query, [
RFAIStatusCodes.APPROVED.value, current_block_no,
current_block_no
] + sub_query_values)
return query_response
