def get_storages(auth, region): result = {"storage_device": []} conn = db.getDevicesConn() try: with conn.cursor() as cursor: sql = "SELECT * FROM Storage where regionname=%s" cursor.execute(sql, (region,)) res = cursor.fetchall() for r in res: tmp = {} tmp["id"] = r["id"] tmp["name"] = r["name"] tmp["description"] = r.get("description", "") tmp["model"] = r.get("model", "") tmp["vendor"] = r.get("vendor", "") tmp["device_type"] = r.get("device_type", "") tmp["capacity"] = r.get("capacity", "") tmp["mac_address"] = r.get("mac_address", "") tmp["ip_address"] = r.get("ip_address", "") result["storage_device"].append(tmp) except Exception as exc: return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)
def get_storages(auth, region): result = {'storage_device': []} conn = db.getDevicesConn() try: with conn.cursor() as cursor: sql = "SELECT * FROM Storage where regionname=%s" cursor.execute(sql, (region,)) res = cursor.fetchall() for r in res: tmp = {} tmp['id'] = r['id'] tmp['name'] = r['name'] tmp['description'] = r.get('description', '') tmp['model'] = r.get('model', '') tmp['vendor'] = r.get('vendor', '') tmp['device_type'] = r.get('device_type', '') tmp['capacity'] = r.get('capacity', '') tmp['mac_address'] = r.get('mac_address', '') tmp['ip_address'] = r.get('ip_address', '') result['storage_device'].append(tmp) except Exception as exc: log.error(exc) return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)
def get_storages(auth, region): result = {'storage_device': []} conn = db.getDevicesConn() try: with conn.cursor() as cursor: sql = "SELECT * FROM Storage where regionname=%s" cursor.execute(sql, (region, )) res = cursor.fetchall() for r in res: tmp = {} tmp['id'] = r['id'] tmp['name'] = r['name'] tmp['description'] = r.get('description', '') tmp['model'] = r.get('model', '') tmp['vendor'] = r.get('vendor', '') tmp['device_type'] = r.get('device_type', '') tmp['capacity'] = r.get('capacity', '') tmp['mac_address'] = r.get('mac_address', '') tmp['ip_address'] = r.get('ip_address', '') result['storage_device'].append(tmp) except Exception as exc: log.error(exc) return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)
def get_hosts(auth, region): result = {'hosts': []} conn = db.getDevicesConn() host_sql = 'SELECT t1.id, t1.os_name,t1.hostname,'\ ' t1.description, t1.ip_address, t1.hypervisor,'\ ' t1.model, t1.vendor, t1.cpu_count, t1.cpu_model,'\ ' t1.cpu_frequence, t1.cpu_socket, t1.cpu_core,'\ ' t1.memory_size '\ ' FROM Host t1'\ ' WHERE t1.regionname=%s' tmp_disk_sql = 'SELECT t1.name,'\ ' t1.capacity'\ ' FROM Disk t1 WHERE t1.host_id = %s' tmp_nic_sql = 'SELECT t1.name,'\ ' t1.description,'\ ' t1.status,'\ ' t1.mac_address'\ ' FROM Port t1 WHERE t1.host_id = %s' try: with conn.cursor() as cursor: cursor.execute(host_sql, (region,)) res = cursor.fetchall() for r in res: nics = [] disks = [] with conn.cursor() as nic_cursor: nic_cursor.execute(tmp_nic_sql, (r['id'],)) nic_res = nic_cursor.fetchall() for nic in nic_res: nics.append(nic) r['nics'] = nics with conn.cursor() as disk_cursor: disk_cursor.execute(tmp_disk_sql, (r['id'],)) disk_res = disk_cursor.fetchall() for disk in disk_res: disks.append(disk) r['disks'] = disks result['hosts'].append(r) except Exception as exc: log.error(exc) return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)
def get_hosts(auth, region): result = {'hosts': []} conn = db.getDevicesConn() host_sql = 'SELECT t1.id, t1.os_name,t1.hostname,'\ ' t1.description, t1.ip_address, t1.hypervisor,'\ ' t1.model, t1.vendor, t1.cpu_count, t1.cpu_model,'\ ' t1.cpu_frequence, t1.cpu_socket, t1.cpu_core,'\ ' t1.memory_size '\ ' FROM Host t1'\ ' WHERE t1.regionname=%s' tmp_disk_sql = 'SELECT t1.name,'\ ' t1.capacity'\ ' FROM Disk t1 WHERE t1.host_id = %s' tmp_nic_sql = 'SELECT t1.name,'\ ' t1.description,'\ ' t1.status,'\ ' t1.mac_address'\ ' FROM Port t1 WHERE t1.host_id = %s' try: with conn.cursor() as cursor: cursor.execute(host_sql, (region, )) res = cursor.fetchall() for r in res: nics = [] disks = [] with conn.cursor() as nic_cursor: nic_cursor.execute(tmp_nic_sql, (r['id'], )) nic_res = nic_cursor.fetchall() for nic in nic_res: nics.append(nic) r['nics'] = nics with conn.cursor() as disk_cursor: disk_cursor.execute(tmp_disk_sql, (r['id'], )) disk_res = disk_cursor.fetchall() for disk in disk_res: disks.append(disk) r['disks'] = disks result['hosts'].append(r) except Exception as exc: log.error(exc) return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)
def get_hosts(auth, region): result = {"hosts": []} conn = db.getDevicesConn() host_sql = ( "SELECT t1.id, t1.os_name,t1.hostname," " t1.description, t1.ip_address, t1.hypervisor," " t1.model, t1.vendor, t1.cpu_count, t1.cpu_model," " t1.cpu_frequence, t1.cpu_socket, t1.cpu_core," " t1.memory_size " " FROM Host t1" " WHERE t1.regionname=%s" ) tmp_disk_sql = "SELECT t1.name," " t1.capacity" " FROM Disk t1 WHERE t1.host_id = %s" tmp_nic_sql = ( "SELECT t1.name," " t1.description," " t1.status," " t1.mac_address" " FROM Port t1 WHERE t1.host_id = %s" ) try: with conn.cursor() as cursor: cursor.execute(host_sql, (region,)) res = cursor.fetchall() for r in res: nics = [] disks = [] with conn.cursor() as nic_cursor: nic_cursor.execute(tmp_nic_sql, (r["id"],)) nic_res = nic_cursor.fetchall() for nic in nic_res: nics.append(nic) r["nics"] = nics with conn.cursor() as disk_cursor: disk_cursor.execute(tmp_disk_sql, (r["id"],)) disk_res = disk_cursor.fetchall() for disk in disk_res: disks.append(disk) r["disks"] = disks result["hosts"].append(r) except Exception as exc: return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)
def get_networks(auth, region): result = {'network_device': []} conn = db.getDevicesConn() try: with conn.cursor() as cursor: sql = 'SELECT id, name, description, model,'\ ' vendor, device_type, port_num,'\ ' total_ram FROM Network'\ ' WHERE regionname = %s' cursor.execute(sql, (region,)) res = cursor.fetchall() for r in res: result['network_device'].append(r) except Exception as exc: log.error(exc) return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)
def get_networks(auth, region): result = {'network_device': []} conn = db.getDevicesConn() try: with conn.cursor() as cursor: sql = 'SELECT id, name, description, model,'\ ' vendor, device_type, port_num,'\ ' total_ram FROM Network'\ ' WHERE regionname = %s' cursor.execute(sql, (region, )) res = cursor.fetchall() for r in res: result['network_device'].append(r) except Exception as exc: log.error(exc) return make_response(json.dumps(exc.message), 500) finally: conn.close() return make_response(json.dumps(result), 200)