def getProposalsGlobalSearchByKeywordFromProposalTable(keyword):
sql = "SELECT * FROM proposal.proposal_final WHERE proposal_id LIKE '%" + keyword + "%'" + " OR final_proposal_title LIKE '%" + keyword + "%'" + " OR final_proposal_idea LIKE '%" + keyword + "%'" + " OR final_project_location LIKE '%" + keyword + "%'" + " OR cost LIKE '%" + keyword + "%'" + " OR proposal_need LIKE '%" + keyword + "%'" + " OR final_proposal_latitude LIKE '%" + keyword + "%'" + " OR final_proposal_longitude LIKE '%" + keyword + "%'" + " OR project_type LIKE '%" + keyword + "%'" + " OR department LIKE '%" + keyword + "%'" + " OR who_benefits LIKE '%" + keyword + "%'" + " OR council_district LIKE '%" + keyword + "%'" + " OR neihborhood LIKE '%" + keyword + "%'"
rows = execute(sql)
results = []
for row in rows:
results.append(toProposalObject(row))
return json.dumps(results)
def getProposalsSearchNeedByKeywordFromProposalTable(keyword):
sql = "SELECT * FROM proposal.proposal_final WHERE proposal_need LIKE '%" + keyword + "%'"
rows = execute(sql)
results = []
for row in rows:
results.append(toProposalObject(row))
return json.dumps(results)
def getProposalsInDistrictFromProposalTable(district):
sql = "SELECT * FROM proposal.proposal_final WHERE council_district = %d" % district
rows = execute(sql)
results = []
for row in rows:
results.append(toProposalObject(row))
return json.dumps(results)
def getAllProposalsFromProposalTable():
sql = "SELECT * FROM proposal.proposal_final"
rows = execute(sql)
results = []
for row in rows:
results.append(toProposalObject(row))
return json.dumps(results)
def getProposalByIdFromProposalTable(id):
sql = "SELECT * FROM proposal.proposal_final WHERE proposal_id = %d" % id
rows = execute(sql)
results = []
for row in rows:
results.append(toProposalObject(row))
return json.dumps(results)
def getProposalsInStageFromProposalAndStageTable(stage):
stageTableName = "stage.stage%d" % stage
sql = "SELECT * FROM proposal.proposal_final join %s on proposal.proposal_final.proposal_id = %s.proposal_id" % (
stageTableName, stageTableName)
rows = execute(sql)
results = []
for row in rows:
results.append(toProposalObject(row))
return json.dumps(results)