create edge type collide "collide" ;

create table if not exists Screw (
  sise 		 int ,
  screwlevel float 
) ;

create table if not exists Wheel ( 
		color				varchar	,
		sise				int	,
		screw       		Screw[4] ,
		
		index( color,sise) 
) ;

create table if not exists Car ( 
		color				varchar	,
		sise				int		,
		wheel				Wheel[4..4]	,
		
		index( color,sise) 
) ;

create table if not exists Camry extends Car ( 
		capacity		list<double> ,
		lightsize		list<int>	 ,
		speed			int			 ,
		
		index( capacity,lightsize,speed) 
) ;

alter table Wheel add column wheel4logs	block {
						"type"  : 	"logs"
					   }

alter table Wheel add column rotations block {
				"params": [
						["count", "int", "", "转数"]
				],
				"type": "tsdb"
		}	"转数";

insert into Screw (id, name, sise, screwlevel) values ('Screw:1111', 'Screw:1111', 50, 9);
insert into Screw (id, name, sise, screwlevel) values ('Screw:1112', 'Screw:1111', 50, 9);
insert into Screw (id, name, sise, screwlevel) values ('Screw:1113', 'Screw:1111', 50, 9);
insert into Screw (id, name, sise, screwlevel) values ('Screw:1114', 'Screw:1111', 50, 9);
insert into Screw (id, name, sise, screwlevel) values ('Screw:1221', 'Screw:1112', 40, 8);
insert into Screw (id, name, sise, screwlevel) values ('Screw:1222', 'Screw:1112', 40, 8);
insert into Screw (id, name, sise, screwlevel) values ('Screw:1223', 'Screw:1112', 40, 8);
insert into Screw (id, name, sise, screwlevel) values ('Screw:1224', 'Screw:1112', 40, 8);

insert into Wheel (id,name,color,sise,screw) values ('Wheel:111', '111','black', 75, ["Screw:1111"]);
insert into Wheel (id,name,color,sise,screw) values ('Wheel:122', '122','black', 60, ["Screw:1112"]);


insert into Wheel (id,rotations) values ("Wheel:122", [10000]) at '2021-09-13 00:00:00';
insert into Wheel (id,rotations) values ("Wheel:122", [15000]) at '2021-09-12 00:00:00';
insert into Wheel (id,rotations) values ("Wheel:122", [5000]) at '2021-09-11 00:00:00';

insert into Wheel (id,rotations) values ("Wheel:122", [20000]) at '2021-09-13 00:00:00';
insert into Wheel (id,rotations) values ("Wheel:122", [25000]) at '2021-09-12 00:00:00';
insert into Wheel (id,rotations) values ("Wheel:122", [15000]) at '2021-09-11 00:00:00';

insert into Camry (id, name, capacity,lightsize, speed, wheel) values ('Camry:11', 'Camry:11',[4.0,5.0,6.0,7.0], [3,3],120, ['Wheel:111'] );
insert into Camry (id, name, capacity,lightsize, speed, wheel) values ('Camry:12', 'Camry:12',[4.0,5.0,6.0,7.0], [3,3],120, ['Wheel:122'] );
insert into Camry (id, name, capacity,lightsize, speed) values ('Camry:13', 'Camry:13',[4.0,5.0,6.0,7.0], [3,3],120);

insert into Wheel (id, wheel4logs['file1.log']) values ('Wheel:111', ["DEBUG 2020-09-25 00:49:59,456 Hello.java:124 - test logs for car
DEBUG 2020-09-25 00:49:59,456 Hello.java:124 - test logs for car
DEBUG 2020-09-25 00:49:59,456 Hello.java:124 - test logs for car
DEBUG 2020-09-25 00:49:59,456 Hello.java:117 - test logs for wheel
DEBUG 2020-09-25 00:49:59,667 Hello.java:124 - test logs for car
DEBUG 2020-09-25 00:49:59,667 Hello.java:124 - test logs for car
WARN  2020-09-25 00:50:01,043 SelectStatement.java:429 - test logs for wheel22
WARN  2020-09-25 00:50:04,072 SelectStatement.java:429 - test logs for wheel22
INFO  2020-09-25 00:50:08,837 World.java:143 - [object] No need to add fields
INFO  2020-09-25 00:50:08,840 World.java:143 - [vobject] No need to add fields"])


create ("Camry:11") - [:collide] -> ("Camry:13"),("Camry:13") - [:collide] -> ("Camry:11")


match ('Camry:1*')-[*]->()

-- 大于40 小于60 应该是1个对象，大于60
select id,wheel["sise","color"] from  Camry where wheel.screw.sise > 39

-- 大于9999有2个对象，大于10000 小于20000的有1个对象
select id,wheel["sise","color"] from  Camry where wheel.rotations.time('2021-09-13 00:00:00','').sum(count).assert($1 > 12000)

-- 大于40 小于60 应该是1个对象，限定一个与camry:13有碰撞的
select id,wheel["sise","color"] from Camry c join ("Camry:13")-[:collide*1]-(h) on c.id = h.id where wheel.screw.sise > 39

delete from Camry with version
delete from Car with version
delete from Wheel with version
delete from Screw2 with version