def getCallMethodLs(): """ 2009-1-30 """ affiliated_table_name = model.Stock_250kDB.ResultsMethod.table.name list_info = hc.getCallMethodInfo(affiliated_table_name=affiliated_table_name) call_method_ls = [] for i in range(len(list_info.id_ls)): id = list_info.id_ls[i] label = list_info.label_ls[i] call_method_ls.append([id, label]) return call_method_ls
def getCallMethodLsGivenType(type_id, extra_table_name=None): """ 2009-2-22 add argument extra_table_name 2008-12-30 """ affiliated_table_name = model.Stock_250kDB.ResultsMethod.table.name if not extra_table_name: extra_table_name = model.Stock_250kDB.CandidateGeneTopSNPTestRM.table.name extra_tables = ' %s c '%extra_table_name extra_condition = 'c.results_id=s.id and c.type_id=%s'%type_id list_info = hc.getCallMethodInfo(affiliated_table_name=affiliated_table_name, extra_condition=extra_condition, extra_tables=extra_tables) call_method_ls = [] for i in range(len(list_info.id_ls)): id = list_info.id_ls[i] label = list_info.label_ls[i] call_method_ls.append([id, label]) return call_method_ls
def getCallMethodLsJson(self): """ 2009-11-30 return all possible call_method_ids in table association_overlapping_stat """ affiliated_table_name = model.Stock_250kDB.AssociationOverlappingStat.table.name list_info = hc.getCallMethodInfo(affiliated_table_name=affiliated_table_name) call_method_ls = [] for i in range(len(list_info.id_ls)): id = list_info.id_ls[i] label = list_info.label_ls[i] call_method_ls.append([id, label]) result = { 'options': [ dict(id=value, value=id) for id, value in call_method_ls ] } #result['options'].append({'id': u'[At the end]', 'value': u''}) result['options'].insert(0, {'id': u'Please Choose ...', 'value': 0}) return simplejson.dumps(result)