def getAllSubBusinessDef(self): sql = ''' SELECT sb.id sb_id, sb.sb_code, sb.sb_name, mb.mb_name, sb.description FROM core_sub_business sb LEFT JOIN core_main_business mb ON sb.main_business_id = mb.id AND mb.is_deleted = FALSE WHERE sb.is_deleted = FALSE ''' sbList = executeQuery(sql) totalRecords = len(sbList) output = {} output["sEcho"] = 1 output["iTotalRecords"] = totalRecords output["iTotalDisplayRecords"] = totalRecords output["aaData"] = sbList return json.dumps(output, indent=4)
def getAllDomainDef(self): sql=''' SELECT d.id, d.domain_name, d.remark, d.description, d.is_alarm, pool.pool_name FROM core_domain d LEFT JOIN core_pool pool ON d.pool_id = pool.id AND pool.is_deleted = FALSE WHERE d.is_deleted = FALSE ''' domainList = executeQuery(sql) totalRecords = len(domainList) output = {} output["sEcho"] = 1 output["iTotalRecords"] = totalRecords output["iTotalDisplayRecords"] = totalRecords output["aaData"] = domainList return json.dumps(output, indent=4)
def getAllPoolDef(self): sql = ''' SELECT pool.id pool_id, pool.pool_name, pool.pool_code, stack.stack_name, sb.sb_name, pool.description FROM core_pool pool LEFT JOIN core_sub_business sb ON pool.sub_business_id = sb.id AND sb.is_deleted = FALSE LEFT JOIN core_main_business mb ON sb.main_business_id = mb.id AND mb.is_deleted = FALSE LEFT JOIN core_technology_stack stack ON pool.stack = stack.id WHERE pool.is_deleted = FALSE ''' sbList = executeQuery(sql) totalRecords = len(sbList) output = {} output["sEcho"] = 1 output["iTotalRecords"] = totalRecords output["iTotalDisplayRecords"] = totalRecords output["aaData"] = sbList return json.dumps(output, indent=4)
def getAllHostDef(self): sql=''' SELECT h.id host_id, h.host_name, h.host_code, h.internal_ip, h.outer_ip, hs.state_name, pool.pool_name, idc.idc_name, ht.type_name FROM core_host h LEFT JOIN core_pool_host ph ON h.id = ph.host_id LEFT JOIN core_pool pool ON ph.pool_id = pool.id AND pool.is_deleted=false LEFT JOIN core_idc_provider idc ON idc.id = h.idc_id AND idc.is_deleted=false LEFT JOIN core_host_type ht ON h.host_type = ht.id AND ht.is_deleted=false LEFT JOIN core_host_state hs ON hs.id = h.host_state AND hs.is_deleted=false where h.is_deleted=false ''' hostList = executeQuery(sql) totalRecords = len(hostList) output = {} output["sEcho"] = 1 output["iTotalRecords"] = totalRecords output["iTotalDisplayRecords"] = totalRecords output["aaData"] = hostList return json.dumps(output, indent=4)