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