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)
