odbtools/odbctest/mql/basic/graph_test/18graph_insert_data.mql

insert into /m3graph/entity/biz id="biz:查账系统",contain=["cluster:查账系统web集群","cluster:查账系统应用服务集群","ha:查账系统数据库HA"],depend=["biz:认证系统"];

insert into /m3graph/entity/cluster id="cluster:查账系统web集群",contain=["http:查账http1","http:查账http2","http:查账http3","http:查账http4"];

insert into /m3graph/entity/cluster id="cluster:查账系统应用服务集群",contain=["weblogic:weblogic1","weblogic:weblogic2","weblogic:weblogic3","app:app1","app:app2","app:app3"];

insert into /m3graph/entity/ha id="ha:查账系统数据库HA",contain=["oracle:oracle1","oracle:oracle2"];

insert into /m3graph/entity/http id="http:查账http1",runon=["linux:linux1"];
insert into /m3graph/entity/http id="http:查账http2",runon=["linux:linux3"];
insert into /m3graph/entity/http id="http:查账http3",runon=["linux:linux5"];
insert into /m3graph/entity/http id="http:查账http4",runon=["linux:linux8"];

insert into /m3graph/entity/oracle id="oracle:oracle1",runon=["linux:linux6"];
insert into /m3graph/entity/oracle id="oracle:oracle2",runon=["linux:linux9"];

insert into /m3graph/entity/app id="app:app1",depend=["weblogic:weblogic1"],runon=["linux:linux2"];
insert into /m3graph/entity/app id="app:app2",depend=["weblogic:weblogic2"],runon=["linux:linux4"];
insert into /m3graph/entity/app id="app:app3",depend=["weblogic:weblogic3"],runon=["linux:linux7"];

insert into /m3graph/entity/weblogic id="weblogic:weblogic1",runon=["linux:linux2"];
insert into /m3graph/entity/weblogic id="weblogic:weblogic2",runon=["linux:linux4"];
insert into /m3graph/entity/weblogic id="weblogic:weblogic3",runon=["linux:linux7"];

insert into /m3graph/entity/linux id="linux:linux1",runon=["esx:esx1"];
insert into /m3graph/entity/linux id="linux:linux2",runon=["esx:esx1"];
insert into /m3graph/entity/linux id="linux:linux3",runon=["esx:esx1"];
insert into /m3graph/entity/linux id="linux:linux4",runon=["esx:esx2"];
insert into /m3graph/entity/linux id="linux:linux5",runon=["esx:esx2"];
insert into /m3graph/entity/linux id="linux:linux6",runon=["esx:esx2"];
insert into /m3graph/entity/linux id="linux:linux7",runon=["esx:esx3"];
insert into /m3graph/entity/linux id="linux:linux8",runon=["esx:esx3"];
insert into /m3graph/entity/linux id="linux:linux9",runon=["esx:esx3"];

insert into /m3graph/entity/esx id="esx:esx1",connect=["switch:switch1","sanswitch:sanswitch1"];
insert into /m3graph/entity/esx id="esx:esx2",connect=["switch:switch2","sanswitch:sanswitch1"];
insert into /m3graph/entity/esx id="esx:esx3",connect=["switch:switch3","sanswitch:sanswitch1"];

insert into /m3graph/entity/switch id="switch:switch1",connect=["esx:esx1","esx:esx4","esx:esx5","switch:switch4","switch:switch5"];
insert into /m3graph/entity/switch id="switch:switch2",connect=["esx:esx2","switch:switch4","switch:switch5"];
insert into /m3graph/entity/switch id="switch:switch3",connect=["esx:esx3","switch:switch4","switch:switch5"];

insert into /m3graph/entity/switch id="switch:switch4",connect=["switch:switch1","switch:switch2","switch:switch3","router:router1","router:router2"];
insert into /m3graph/entity/switch id="switch:switch5",connect=["switch:switch1","switch:switch2","switch:switch3","router:router1","router:router2"];

insert into /m3graph/entity/router id="router:router1",connect=["switch:switch4","switch:switch5","router:router3","router:router4"];
insert into /m3graph/entity/router id="router:router2",connect=["switch:switch4","switch:switch5","router:router3","router:router4"];

insert into /m3graph/entity/router id="router:router3",connect=["router:router1","router:router2","switch:switch6","switch:switch7"];
insert into /m3graph/entity/router id="router:router4",connect=["router:router1","router:router2","switch:switch6","switch:switch7"];

insert into /m3graph/entity/switch id="switch:switch6",connect=["router:router3","router:router4"];
insert into /m3graph/entity/switch id="switch:switch7",connect=["router:router3","router:router4"];

insert into /m3graph/entity/sanswitch id="sanswitch:sanswitch1",connect=["esx:esx1","esx:esx2","esx:esx3","esx:esx4","esx:esx5","sanstorage:sanstorage1"];

insert into /m3graph/entity/sanswitch id="sanswitch:sanswitch2";

insert into /m3graph/entity/sanstorage id="sanstorage:sanstorage1",connect=["sanswitch:sanswitch1"];

insert into /m3graph/entity/biz id="biz:认证系统",contain=["ha:认证系统数据库HA","ha:认证系统应用服务集群"];

insert into /m3graph/entity/ha id="ha:认证系统数据库HA",contain=["db2:db21","db2:db22"];

insert into /m3graph/entity/ha id="ha:认证系统应用服务集群",contain=["weblogic:weblogic4","weblogic:weblogic5","app:app4","app:app5"];

insert into /m3graph/entity/db2 id="db2:db21",runon=["linux:linux10"];
insert into /m3graph/entity/db2 id="db2:db22",runon=["linux:linux12"];

insert into /m3graph/entity/weblogic id="weblogic:weblogic4",runon=["linux:linux11"];
insert into /m3graph/entity/weblogic id="weblogic:weblogic5",runon=["linux:linux13"];

insert into /m3graph/entity/app id="app:app4",runon=["linux:linux11"];
insert into /m3graph/entity/app id="app:app5",runon=["linux:linux13"];

insert into /m3graph/entity/linux id="linux:linux10",runon=["esx:esx4"];
insert into /m3graph/entity/linux id="linux:linux11",runon=["esx:esx4"];
insert into /m3graph/entity/linux id="linux:linux12",runon=["esx:esx5"];
insert into /m3graph/entity/linux id="linux:linux13",runon=["esx:esx5"];

insert into /m3graph/entity/esx id="esx:esx4",connect=["switch:switch1","sanswitch:sanswitch1"];
insert into /m3graph/entity/esx id="esx:esx5",connect=["switch:switch1","sanswitch:sanswitch1"];

create ("sanstorage:sanstorage1")-[:connect]->("sanswitch:sanswitch2")

/**
sleep(2s)
**/
;