blob: 5e74eaae69079cb01b68d149d196b8b4fd7b6735 [file] [log] [blame]
/*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
\! cp -r regress/age_load/data regress/instance/data/age_load
LOAD 'age';
SET search_path TO ag_catalog;
SELECT create_graph('agload_test_graph');
NOTICE: graph "agload_test_graph" has been created
create_graph
--------------
(1 row)
SELECT create_vlabel('agload_test_graph','Country');
NOTICE: VLabel "Country" has been created
create_vlabel
---------------
(1 row)
SELECT load_labels_from_file('agload_test_graph', 'Country',
'age_load/countries.csv');
load_labels_from_file
-----------------------
(1 row)
SELECT create_vlabel('agload_test_graph','City');
NOTICE: VLabel "City" has been created
create_vlabel
---------------
(1 row)
SELECT load_labels_from_file('agload_test_graph', 'City',
'age_load/cities.csv');
load_labels_from_file
-----------------------
(1 row)
SELECT create_elabel('agload_test_graph','has_city');
NOTICE: ELabel "has_city" has been created
create_elabel
---------------
(1 row)
SELECT load_edges_from_file('agload_test_graph', 'has_city',
'age_load/edges.csv');
load_edges_from_file
----------------------
(1 row)
SELECT table_catalog, table_schema, lower(table_name) as table_name, table_type
FROM information_schema.tables
WHERE table_schema = 'agload_test_graph' ORDER BY table_name ASC;
table_catalog | table_schema | table_name | table_type
--------------------+-------------------+------------------+------------
contrib_regression | agload_test_graph | _ag_label_edge | BASE TABLE
contrib_regression | agload_test_graph | _ag_label_vertex | BASE TABLE
contrib_regression | agload_test_graph | city | BASE TABLE
contrib_regression | agload_test_graph | country | BASE TABLE
contrib_regression | agload_test_graph | has_city | BASE TABLE
(5 rows)
SELECT COUNT(*) FROM agload_test_graph."Country";
count
-------
53
(1 row)
SELECT COUNT(*) FROM agload_test_graph."City";
count
-------
72485
(1 row)
SELECT COUNT(*) FROM agload_test_graph."has_city";
count
-------
72485
(1 row)
SELECT COUNT(*) FROM cypher('agload_test_graph', $$MATCH(n) RETURN n$$) as (n agtype);
count
-------
72538
(1 row)
SELECT COUNT(*) FROM cypher('agload_test_graph', $$MATCH (a)-[e]->(b) RETURN e$$) as (n agtype);
count
-------
72485
(1 row)
SELECT create_vlabel('agload_test_graph','Country2');
NOTICE: VLabel "Country2" has been created
create_vlabel
---------------
(1 row)
SELECT load_labels_from_file('agload_test_graph', 'Country2',
'age_load/countries.csv', false);
load_labels_from_file
-----------------------
(1 row)
SELECT create_vlabel('agload_test_graph','City2');
NOTICE: VLabel "City2" has been created
create_vlabel
---------------
(1 row)
SELECT load_labels_from_file('agload_test_graph', 'City2',
'age_load/cities.csv', false);
load_labels_from_file
-----------------------
(1 row)
SELECT COUNT(*) FROM agload_test_graph."Country2";
count
-------
53
(1 row)
SELECT COUNT(*) FROM agload_test_graph."City2";
count
-------
72485
(1 row)
SELECT id FROM agload_test_graph."Country" LIMIT 10;
id
-----------------
844424930131970
844424930131971
844424930131974
844424930131983
844424930131989
844424930131990
844424930131996
844424930132002
844424930132023
844424930132025
(10 rows)
SELECT id FROM agload_test_graph."Country2" LIMIT 10;
id
------------------
1688849860263937
1688849860263938
1688849860263939
1688849860263940
1688849860263941
1688849860263942
1688849860263943
1688849860263944
1688849860263945
1688849860263946
(10 rows)
SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country {iso2 : 'BE'})
RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype, "n.iso2" agtype);
id(n) | n.name | n.iso2
-----------------+-----------+--------
844424930131990 | "Belgium" | "BE"
(1 row)
SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country2 {iso2 : 'BE'})
RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype, "n.iso2" agtype);
id(n) | n.name | n.iso2
------------------+-----------+--------
1688849860263942 | "Belgium" | "BE"
(1 row)
SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country {iso2 : 'AT'})
RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype, "n.iso2" agtype);
id(n) | n.name | n.iso2
-----------------+-----------+--------
844424930131983 | "Austria" | "AT"
(1 row)
SELECT * FROM cypher('agload_test_graph', $$MATCH(n:Country2 {iso2 : 'AT'})
RETURN id(n), n.name, n.iso2 $$) as ("id(n)" agtype, "n.name" agtype, "n.iso2" agtype);
id(n) | n.name | n.iso2
------------------+-----------+--------
1688849860263940 | "Austria" | "AT"
(1 row)
SELECT * FROM cypher('agload_test_graph', $$
MATCH (u:Country {region : "Europe"})
WHERE u.name =~ 'Cro.*'
RETURN u.name, u.region
$$) AS (result_1 agtype, result_2 agtype);
result_1 | result_2
-----------+----------
"Croatia" | "Europe"
(1 row)
SELECT drop_graph('agload_test_graph', true);
NOTICE: drop cascades to 7 other objects
DETAIL: drop cascades to table agload_test_graph._ag_label_vertex
drop cascades to table agload_test_graph._ag_label_edge
drop cascades to table agload_test_graph."Country"
drop cascades to table agload_test_graph."City"
drop cascades to table agload_test_graph.has_city
drop cascades to table agload_test_graph."Country2"
drop cascades to table agload_test_graph."City2"
NOTICE: graph "agload_test_graph" has been dropped
drop_graph
------------
(1 row)