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)
