select count(*) from /birddata/yearmonth WHERE date like '201201*'
/**
output()
match(count,17848)
**/
;


select count(*) from /birddata/yearmonth WHERE date like '201201%'
/**
output()
match(count,17848)
**/
;



match ('univ_college:1633b364ee864b8ead7936054d249580')
-[:contain]->()
-[:contain]->()
-[:teach]->('univ_doctor:*')
/**
output()
match('graph.edges.len', 134)
match('graph.nodes.len', 135)
**/
;


match (c:'univ_college:1633b364ee864b8ead7936054d249580')
-[:contain]->()
-[:contain]->()
-[:teach]->(d:'univ_doctor:*')
return c.name,d.name
/**
output()
count(100)
**/
;

MATCH (staff:/mingdao1/staff)
-[:is_member_of_project*1..1]->
(project:/mingdao1/project WHERE attr1 = 'CN002859P') 
/**
output()
match('graph.edges.len', 12)
match('graph.nodes.len', 13)
**/
;

MATCH (staff:/mingdao1/staff)
-[:is_member_of_project*1..1]->
(project:/mingdao1/project WHERE attr1 = 'CN002859P') 
RETURN staff.attr0 AS "staff_no", staff.attr1 AS "staff_name", staff.staff_perf AS "work_hours" 
into temp11
;

match 
('mingdao1_contract:ef86a698-329c-40be-a96b-b53c406e15ec',
'mingdao1_project:CN003391S-精工金属生产车间一体化智能管控中心平台实施技术服务项目')
-[]-
()
/**
output()
match('graph.edges.len', 1)
match('graph.nodes.len', 2)
**/
;

#/uino/ | univ_college:* | print class,id
/**
output()
**/
;


select distinct class from /uino/ limit -1
/**
output()
**/
;

match ('univ_research_center:0dc1ab4d10944a0d84b07c9968dfd197')<-[:contain]-()
/**
output()
match('graph.edges.len', 1)
match('graph.nodes.len', 2)
**/
;

match ('univ_college:1633b364ee864b8ead7936054d249580')-[:contain]->()
/**
output()
match('graph.edges.len', 5)
match('graph.nodes.len', 6)
**/
;

select staff_no, staff_name, 
work_hours.time('2023-06-09 00:00:00','2023-06-10 00:00:00').find(name = 'CN002859P').unit('sum', '1d') 
from temp11
/**
output()
**/
;

select staff_perf from /mingdao1/staff where attr0='UN0193'
/**
timeout(5m)
output()
**/
;

MATCH 
(staff:/mingdao1/staff WHERE attr1 = '钟宏')
-[:is_solve_person_of_case*1..1]->
(case:/mingdao1/case WHERE attr30 >= '2024-01-01' AND attr30 <= '2024-12-31')
-[:is_case_of_project*1..1]->
(project:/mingdao1/project)
<-[:is_contract_of_project*1..1]-
(contract:/mingdao1/contract), 
(project)
<-[:is_admin_of_project*1..1]-
(pm:/mingdao1/staff) 
RETURN contract.attr18 AS "contract_amount", contract.id AS "contract_id", pm.attr1 AS "pm_name", pm.attr0 AS "pm_id" 
WITH TIMEOUT = 6m
/**
output()
**/
;

select * from /mingdao1/contract where id='mingdao1_contract:ef86a698-329c-40be-a96b-b53c406e15ec'
/**
output()
**/
;