mql.go 2.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697
  1. package schema
  2. var MQLs = `
  3. create class if not exists m3cnet : / (
  4. ) with ttl=366 day, autosearch=true, version=false, key=manu, alias='m3cnet', namespace='m3cnet'
  5. ;
  6. create class if not exists master : m3cnet (
  7. id varchar "id",
  8. uniqueid varchar "UNIQUEID",
  9. name varchar "NAME",
  10. asmchangetime bigint "ASMCHANGETIME",
  11. basename varchar "BASENAME",
  12. changetime timestamp "CHANGETIME",
  13. ci_status varchar "CI_STATUS",
  14. ci_table varchar "CI_TABLE",
  15. cmdbmapping varchar "CMDBMAPPING",
  16. distname varchar "DISTNAME",
  17. emsname varchar "EMSNAME",
  18. entityid varchar "ENTITYID",
  19. entitytypes set<varchar> "ENTITYTYPES",
  20. entitytypesarr varchar "ENTITYTYPESARR",
  21. extraattr varchar "EXTRAATTR",
  22. ipaddress varchar "IPADDRESS",
  23. lastupdated timestamp "LASTUPDATED",
  24. originid varchar "ID",
  25. rel_status varchar "REL_STATUS",
  26. site varchar "SITE",
  27. site_source varchar "SITE_SOURCE",
  28. stage varchar "STAGE",
  29. sysid varchar "SYSID",
  30. vendor varchar "VENDOR",
  31. tags set<varchar> "TAGS",
  32. keys( uniqueid)
  33. ) with key=manu, alias='master'
  34. ;
  35. create class if not exists level1 : master (
  36. id varchar "id",
  37. uniqueid varchar "uniqueId,UNIQUEID",
  38. name varchar "name,NAME",
  39. distname varchar "distName,DISTNAME",
  40. entitytypes set<varchar> "entityTypes,ENTITYTYPES",
  41. extends map<varchar,varchar> "*",
  42. tags set<varchar> "tags,TAGS",
  43. ) with key=manu, partition=name, alias='level1'
  44. ;
  45. create class if not exists minfo : m3cnet (
  46. id varchar "id",
  47. uniqueid varchar "uniqueId",
  48. name varchar "name",
  49. distname varchar "distName",
  50. entitytypes set<varchar> "entityTypes",
  51. extends map<varchar,varchar> "*",
  52. tags set<varchar> "tags",
  53. keys( uniqueid)
  54. ) with key=manu, alias='minfo'
  55. ;
  56. create class if not exists level2 : minfo (
  57. ) with key=manu, partition=name, alias='level2'
  58. ;
  59. create class if not exists level3 : minfo (
  60. ) with key=manu, partition=name, alias='level3'
  61. ;
  62. create class if not exists level4 : minfo (
  63. ) with key=manu, partition=name, alias='level4'
  64. ;
  65. create class if not exists level5 : minfo (
  66. ) with key=manu, partition=name, alias='level5'
  67. ;
  68. create class if not exists level6 : minfo (
  69. ) with key=manu, partition=name, alias='level6'
  70. ;
  71. create class if not exists level7 : minfo (
  72. ) with key=manu, partition=name, alias='level7'
  73. ;
  74. create class if not exists level8 : minfo (
  75. ) with key=manu, partition=name, alias='level8'
  76. ;
  77. create edge type m3cnet.contain;
  78. create edge type m3cnet.depend;
  79. create edge type m3cnet.topology;
  80. `