4_insert_data.mql 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1111', 'SScrew:1111', 50, 9);
  2. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1112', 'SScrew:1111', 50, 9);
  3. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1113', 'SScrew:1111', 50, 9);
  4. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1114', 'SScrew:1111', 50, 9);
  5. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1221', 'SScrew:1112', 40, 8);
  6. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1222', 'SScrew:1112', 40, 8);
  7. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1223', 'SScrew:1112', 40, 8);
  8. insert into SScrew (id, name, sise, screwlevel) values ('SScrew:1224', 'SScrew:1112', 40, 8);
  9. insert into WWheel (id,name,color,sise,screw) values ('WWheel:111', '111','black', 75, ["SScrew:1111"]);
  10. insert into WWheel (id,name,color,sise,screw) values ('WWheel:122', '122','black', 60, ["SScrew:1112"]);
  11. insert into WWheel (id,rotations) values ("WWheel:122", [10000]) at '2021-09-13 00:00:00';
  12. insert into WWheel (id,rotations) values ("WWheel:122", [15000]) at '2021-09-12 00:00:00';
  13. insert into WWheel (id,rotations) values ("WWheel:122", [5000]) at '2021-09-11 00:00:00';
  14. insert into WWheel (id,rotations) values ("WWheel:122", [20000]) at '2021-09-13 00:00:00';
  15. insert into WWheel (id,rotations) values ("WWheel:122", [25000]) at '2021-09-12 00:00:00';
  16. insert into WWheel (id,rotations) values ("WWheel:122", [15000]) at '2021-09-11 00:00:00';
  17. insert into CCamry (id, name, capacity,lightsize, speed, wheel) values ('CCamry:11', 'CCamry:11',[4.0,5.0,6.0,7.0], [3,3],120, ['WWheel:111'] );
  18. insert into CCamry (id, name, capacity,lightsize, speed, wheel) values ('CCamry:12', 'CCamry:12',[4.0,5.0,6.0,7.0], [3,3],120, ['WWheel:122'] );
  19. insert into CCamry (id, name, capacity,lightsize, speed) values ('CCamry:13', 'CCamry:13',[4.0,5.0,6.0,7.0], [3,3],120);
  20. insert into WWheel (id, wheel4logs['file1.log']) values ('WWheel:111', ["DEBUG 2020-09-25 00:49:59,456 Hello.java:124 - test logs for car
  21. DEBUG 2020-09-25 00:49:59,456 Hello.java:124 - test logs for car
  22. DEBUG 2020-09-25 00:49:59,456 Hello.java:124 - test logs for car
  23. DEBUG 2020-09-25 00:49:59,456 Hello.java:117 - test logs for wheel
  24. DEBUG 2020-09-25 00:49:59,667 Hello.java:124 - test logs for car
  25. DEBUG 2020-09-25 00:49:59,667 Hello.java:124 - test logs for car
  26. WARN 2020-09-25 00:50:01,043 SelectStatement.java:429 - test logs for wheel22
  27. WARN 2020-09-25 00:50:04,072 SelectStatement.java:429 - test logs for wheel22
  28. INFO 2020-09-25 00:50:08,837 World.java:143 - [object] No need to add fields
  29. INFO 2020-09-25 00:50:08,840 World.java:143 - [vobject] No need to add fields"])
  30. ;