odbtools/odbctest/mql/problem/basic/graph_local/34graph_insert_data.mql

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

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

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

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

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

insert into /m3graph_local/entity/oracle id="oracle_local:oracle1",runon=["linux_local:linux6"];
insert into /m3graph_local/entity/oracle id="oracle_local:oracle2",runon=["linux_local:linux9"];

insert into /m3graph_local/entity/app id="app_local:app1",depend=["weblogic_local:weblogic1"],runon=["linux_local:linux2"];
insert into /m3graph_local/entity/app id="app_local:app2",depend=["weblogic_local:weblogic2"],runon=["linux_local:linux4"];
insert into /m3graph_local/entity/app id="app_local:app3",depend=["weblogic_local:weblogic3"],runon=["linux_local:linux7"];

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

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

insert into /m3graph_local/entity/esx id="esx_local:esx1",connect=["switch_local:switch1","sanswitch_local:sanswitch1"];
insert into /m3graph_local/entity/esx id="esx_local:esx2",connect=["switch_local:switch2","sanswitch_local:sanswitch1"];
insert into /m3graph_local/entity/esx id="esx_local:esx3",connect=["switch_local:switch3","sanswitch_local:sanswitch1"];

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

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

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

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

insert into /m3graph_local/entity/switch id="switch_local:switch6",connect=["router_local:router3","router_local:router4"];
insert into /m3graph_local/entity/switch id="switch_local:switch7",connect=["router_local:router3","router_local:router4"];

insert into /m3graph_local/entity/sanswitch id="sanswitch_local:sanswitch1",connect=["esx_local:esx1","esx_local:esx2","esx_local:esx3","esx_local:esx4","esx_local:esx5","sanstorage_local:sanstorage1"];

insert into /m3graph_local/entity/sanswitch id="sanswitch_local:sanswitch2";

insert into /m3graph_local/entity/sanstorage id="sanstorage_local:sanstorage1",connect=["sanswitch_local:sanswitch1"];

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

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

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

insert into /m3graph_local/entity/db2 id="db2_local:db21",runon=["linux_local:linux10"];
insert into /m3graph_local/entity/db2 id="db2_local:db22",runon=["linux_local:linux12"];

insert into /m3graph_local/entity/weblogic id="weblogic_local:weblogic4",runon=["linux_local:linux11"];
insert into /m3graph_local/entity/weblogic id="weblogic_local:weblogic5",runon=["linux_local:linux13"];

insert into /m3graph_local/entity/app id="app_local:app4",runon=["linux_local:linux11"];
insert into /m3graph_local/entity/app id="app_local:app5",runon=["linux_local:linux13"];

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

insert into /m3graph_local/entity/esx id="esx_local:esx4",connect=["switch_local:switch1","sanswitch_local:sanswitch1"];
insert into /m3graph_local/entity/esx id="esx_local:esx5",connect=["switch_local:switch1","sanswitch_local:sanswitch1"];

create ("sanstorage_local:sanstorage1")-[:connect]->("sanswitch_local:sanswitch2")

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