{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'NodeName': 'VARCHAR(64)', 'Status': 'VARCHAR(16)', 'CpuPct': 'DECIMAL(6,3) DEFAULT 0', 'CpuCount': 'INT DEFAULT 0', 'MemUsed': 'BIGINT DEFAULT 0', 'MemTotal': 'BIGINT DEFAULT 0', 'MemPct': 'DECIMAL(5,1) DEFAULT 0', 'DiskUsed': 'BIGINT DEFAULT 0', 'DiskTotal': 'BIGINT DEFAULT 0', 'Uptime': 'INT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'Vmid': 'INT', 'Name': 'VARCHAR(128)', 'VmType': 'VARCHAR(8)', 'Status': 'VARCHAR(16)', 'CpuPct': 'DECIMAL(6,3) DEFAULT 0', 'MemUsed': 'BIGINT DEFAULT 0', 'MemMax': 'BIGINT DEFAULT 0', 'MemPct': 'DECIMAL(5,1) DEFAULT 0', 'DiskWrite': 'BIGINT DEFAULT 0', 'DiskRead': 'BIGINT DEFAULT 0', 'NetIn': 'BIGINT DEFAULT 0', 'NetOut': 'BIGINT DEFAULT 0', 'Uptime': 'INT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
INSERT INTO data_proxmox_node
(Guid, Package, NodeName, Status,
CpuPct, CpuCount,
MemUsed, MemTotal, MemPct,
DiskUsed, DiskTotal, Uptime, Module)
VALUES
('{guid}', '{package}', '{node_name}', 'online',
{cpu_pct}, {cpu_count},
{mem_used}, {mem_total}, {mem_pct},
{disk_used}, {disk_total}, {uptime},
'ObjServiceProxmox')
INSERT INTO data_proxmox_vm
(Guid, Package, Vmid, Name,
VmType, Status,
CpuPct, MemUsed, MemMax, MemPct,
DiskWrite, DiskRead,
NetIn, NetOut, Uptime, Module)
VALUES
('{guid}', '{package}',
{vmid}, '{name}',
'{vm_type}', '{status}',
{cpu_pct}, {mem_used}, {mem_max}, {mem_pct},
{disk_write}, {disk_read},
{net_in}, {net_out}, {uptime},
'ObjServiceProxmox')