-
Notifications
You must be signed in to change notification settings - Fork 87
/
Copy pathsetup.sh
executable file
·115 lines (103 loc) · 5.88 KB
/
setup.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
#!/bin/bash
PARAM1=$1
DATA_PATH=${PARAM1:="/data"}
PARAM2=$2
QUERY_PATH=${PARAM2:="/queries"}
echo "==============================================================================="
echo "Setting up the TigerGraph database"
echo "-------------------------------------------------------------------------------"
echo "DATA_PATH: ${DATA_PATH}"
echo "QUERY_PATH: ${QUERY_PATH}"
echo "==============================================================================="
t0=$SECONDS
gsql create_schema.gsql
gsql --graph LDBC_SNB load_static_1.gsql
gsql --graph LDBC_SNB load_static_2.gsql
gsql --graph LDBC_SNB load_dynamic_1.gsql
gsql --graph LDBC_SNB load_dynamic_2.gsql
echo "==============================================================================="
echo "Loading Data"
echo "-------------------------------------------------------------------------------"
t1=$SECONDS
gsql --graph LDBC_SNB "RUN LOADING JOB load_static_1 USING \
organisation=\"$DATA_PATH/static/organisation_0_0.csv\", \
place=\"$DATA_PATH/static/place_0_0.csv\", tagclass=\"$DATA_PATH/static/tagclass_0_0.csv\", \
tagclass_isSubclassOf_tagclass=\"$DATA_PATH/static/tagclass_isSubclassOf_tagclass_0_0.csv\", \
tag=\"$DATA_PATH/static/tag_0_0.csv\", \
tag_hasType_tagclass=\"$DATA_PATH/static/tag_hasType_tagclass_0_0.csv\""
gsql --graph LDBC_SNB "RUN LOADING JOB load_static_2 USING \
organisation_isLocatedIn_place=\"$DATA_PATH/static/organisation_isLocatedIn_place_0_0.csv\", \
place_isPartOf_place=\"$DATA_PATH/static/place_isPartOf_place_0_0.csv\""
gsql --graph LDBC_SNB "RUN LOADING JOB load_dynamic_1 USING \
comment=\"$DATA_PATH/dynamic/comment_0_0.csv\", \
comment_hasCreator_person=\"$DATA_PATH/dynamic/comment_hasCreator_person_0_0.csv\", \
comment_hasTag_tag=\"$DATA_PATH/dynamic/comment_hasTag_tag_0_0.csv\", \
comment_isLocatedIn_place=\"$DATA_PATH/dynamic/comment_isLocatedIn_place_0_0.csv\", \
comment_replyOf_comment=\"$DATA_PATH/dynamic/comment_replyOf_comment_0_0.csv\", \
comment_replyOf_post=\"$DATA_PATH/dynamic/comment_replyOf_post_0_0.csv\", \
forum=\"$DATA_PATH/dynamic/forum_0_0.csv\", \
forum_containerOf_post=\"$DATA_PATH/dynamic/forum_containerOf_post_0_0.csv\", \
forum_hasMember_person=\"$DATA_PATH/dynamic/forum_hasMember_person_0_0.csv\", \
forum_hasModerator_person=\"$DATA_PATH/dynamic/forum_hasModerator_person_0_0.csv\", \
forum_hasTag_tag=\"$DATA_PATH/dynamic/forum_hasTag_tag_0_0.csv\", \
person=\"$DATA_PATH/dynamic/person_0_0.csv\", \
person_hasInterest_tag=\"$DATA_PATH/dynamic/person_hasInterest_tag_0_0.csv\", \
person_isLocatedIn_place=\"$DATA_PATH/dynamic/person_isLocatedIn_place_0_0.csv\", \
person_knows_person=\"$DATA_PATH/dynamic/person_knows_person_0_0.csv\", \
person_likes_comment=\"$DATA_PATH/dynamic/person_likes_comment_0_0.csv\", \
person_likes_post=\"$DATA_PATH/dynamic/person_likes_post_0_0.csv\", \
person_studyAt_organisation=\"$DATA_PATH/dynamic/person_studyAt_organisation_0_0.csv\", \
person_workAt_organisation=\"$DATA_PATH/dynamic/person_workAt_organisation_0_0.csv\", \
post=\"$DATA_PATH/dynamic/post_0_0.csv\", \
post_hasCreator_person=\"$DATA_PATH/dynamic/post_hasCreator_person_0_0.csv\", \
post_hasTag_tag=\"$DATA_PATH/dynamic/post_hasTag_tag_0_0.csv\", \
post_isLocatedIn_place=\"$DATA_PATH/dynamic/post_isLocatedIn_place_0_0.csv\""
echo "==============================================================================="
echo "Parsing and compiling queries"
echo "-------------------------------------------------------------------------------"
t2=$SECONDS
gsql --graph LDBC_SNB PUT ExprFunctions FROM \"$QUERY_PATH/ExprFunctions.hpp\"
gsql --graph LDBC_SNB $QUERY_PATH/interactiveShort1.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveShort2.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveShort3.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveShort4.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveShort5.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveShort6.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveShort7.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex1.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex2.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex3.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex4.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex5.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex6.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex7.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex8.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex9.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex10.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex11.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex12.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex13.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveComplex14.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert1.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert2.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert3.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert4.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert5.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert6.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert7.gsql
gsql --graph LDBC_SNB $QUERY_PATH/interactiveInsert8.gsql
gsql --graph LDBC_SNB 'INSTALL QUERY *'
t3=$SECONDS
#echo "Vertex statistics:"
#curl -X POST "http://127.0.0.1:9000/builtins/LDBC_SNB" -d '{"function":"stat_vertex_number","type":"*"}'
#echo
#echo
#echo "Edge statistics:"
#curl -X POST "http://127.0.0.1:9000/builtins/LDBC_SNB" -d '{"function":"stat_edge_number","type":"*"}'
echo
echo "====================================================================================="
echo "TigerGraph database is ready for benchmark"
echo "Schema setup: $((t1-t0)) s"
echo "Loading: $((t2-t1)) s"
echo "Query installing: $((t3-t2)) s"
echo "====================================================================================="