def getAuthorities(self): objClient = trans.db() authorities = objClient.getAllStatesAndAuthorities() objClient.closeConn() authorityList = list() authorityDict = {'authorities' : 'values'} for authrow in authorities: objAuthority = authority() objAuthority.authid = authrow[0] objAuthority.authdesc = authrow[1] objAuthority.authtag = authrow[2] objAuthority.stateid = authrow[3] objAuthority.stateabbrv = authrow[4] entry = objAuthority.__dict__ authorityList.append(entry) entry = "" authorityDict["authorities"] = authorityList authorityJson = json.JSONEncoder().encode(authorityDict) return authorityJson
def getStates(self): objClient = trans.db() states = objClient.getAllStates() objClient.closeConn() stateList = list() stateDict = {'states' : 'values'} for staterow in states: objState = authority() objState.stateid = staterow[0] objState.stateabbrv = staterow[1] entry = objState.__dict__ stateList.append(entry) entry = "" stateDict["states"] = stateList stateJson = json.JSONEncoder().encode(stateDict) return stateJson
def getCommentsByPostId(self, id): id = int(id) objClient = trans.db() commentResults = objClient.getComments(id) objClient.closeConn() commentsList = list() commentsDict = {'results': 'values'} for comment in commentResults: twiwpComment = comments() twiwpComment.from_user = comment[2] twiwpComment.text = comment[8] entry = twiwpComment.__dict__ commentsList.append(entry) entry = "" commentsDict["results"] = commentsList commentsJson = json.JSONEncoder().encode(commentsDict) return commentsJson