drop table if exists vmreports.vm_gpu;
create table vmreports.vm (
	"Name" varchar(255) NULL,
	"ClientID" varchar(255) NULL, --WZ
	"VCD" varchar(255) NULL, --vcloud
	"Org" varchar(255) NULL,	
	"OrgVDC" varchar(255) NULL,	
	"vCenter" varchar(255) NULL,
	"GPU" jsonb NULL,
	"OrgStatus" varchar(255) NULL,	
	"Object_UUID" uuid NOT NULL,
	ts timestamptz NOT NULL
	,CONSTRAINT PK_vm_gpu PRIMARY KEY (ts, "Object_UUID")
);
grant all on vmreports.vm to nifi;

/*
{
"type": "record",
"name": "vmreports.vm_gpu",
"namespace": "org.apache.nifi",
"fields": [ 
	{"name":"Object_UUID", "type":{"type": "string", "logicalType": "uuid"}},	
	{"name":"ts","type":{"type": "long", "logicalType": "local-timestamp-millis"}},
	
	{"name":"Name", "type":["string" ,"null"]},
	{"name":"ClientID", "type":["string" ,"null"]},
	{"name":"VCD", "type":["string" ,"null"]},
	{"name":"Org", "type":["string" ,"null"]},
	{"name":"OrgVDC", "type":["string" ,"null"]},
	{"name":"vCenter", "type":["string" ,"null"]},
	{"name":"GPU", "type":["string" ,"null"]},
	{"name":"OrgStatus", "type":["string" ,"null"]}
]
}
*/

/*
{    
   "*": {
     "objId":"[&1].Name",
     "1":"[&1].ClientID",
     "2":"[&1].VCD",
     "3":"[&1].Org",
     "4":"[&1].OrgVDC",
     "5":"[&1].vCenter",
     "6":"[&1].GPU",
     "7":"[&1].OrgStatus",
     "objUUID":"[&1].Object_UUID"
   }
 } 
*/