This is an automated email from the ASF dual-hosted git repository. jgemignani pushed a commit to branch PG12 in repository https://gitbox.apache.org/repos/asf/age.git
commit 423ce19bc6c56f00483b56f0ff6f98518d93a94e Author: Rafsun Masud <[email protected]> AuthorDate: Tue Oct 25 15:02:38 2022 -0400 add regression tests for delete_global_graphs (#336) --- Makefile | 1 + regress/expected/age_global_graph.out | 196 ++++++++++++++++++++++++++++++++++ regress/sql/age_global_graph.sql | 68 ++++++++++++ 3 files changed, 265 insertions(+) diff --git a/Makefile b/Makefile index f375011..98f5599 100644 --- a/Makefile +++ b/Makefile @@ -91,6 +91,7 @@ REGRESS = scan \ cypher_union \ cypher_call \ cypher_merge \ + age_global_graph \ age_load \ index \ analyze \ diff --git a/regress/expected/age_global_graph.out b/regress/expected/age_global_graph.out new file mode 100644 index 0000000..171ec1b --- /dev/null +++ b/regress/expected/age_global_graph.out @@ -0,0 +1,196 @@ +LOAD 'age'; +SET search_path TO ag_catalog; +-- +-- test delete_specific_GRAPH_global_contexts function +-- +-- create 3 graphs +SELECT * FROM create_graph('age_global_graph_1'); +NOTICE: graph "age_global_graph_1" has been created + create_graph +-------------- + +(1 row) + +SELECT * FROM cypher('age_global_graph_1', $$ CREATE (v:vertex_from_graph_1) RETURN v $$) AS (v agtype); + v +----------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_1", "properties": {}}::vertex +(1 row) + +SELECT * FROM create_graph('age_global_graph_2'); +NOTICE: graph "age_global_graph_2" has been created + create_graph +-------------- + +(1 row) + +SELECT * FROM cypher('age_global_graph_2', $$ CREATE (v:vertex_from_graph_2) RETURN v $$) AS (v agtype); + v +----------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_2", "properties": {}}::vertex +(1 row) + +SELECT * FROM create_graph('age_global_graph_3'); +NOTICE: graph "age_global_graph_3" has been created + create_graph +-------------- + +(1 row) + +SELECT * FROM cypher('age_global_graph_3', $$ CREATE (v:vertex_from_graph_3) RETURN v $$) AS (v agtype); + v +----------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_3", "properties": {}}::vertex +(1 row) + +-- load contexts using the vertex_stats command +SELECT * FROM cypher('age_global_graph_3', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + result +----------------------------------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_3", "in_degree": 0, "out_degree": 0, "self_loops": 0} +(1 row) + +SELECT * FROM cypher('age_global_graph_2', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + result +----------------------------------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_2", "in_degree": 0, "out_degree": 0, "self_loops": 0} +(1 row) + +SELECT * FROM cypher('age_global_graph_1', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + result +----------------------------------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_1", "in_degree": 0, "out_degree": 0, "self_loops": 0} +(1 row) + +-- delete age_global_graph_2's context +-- should return true (succeeded) +SELECT * FROM cypher('age_global_graph_2', $$ RETURN delete_global_graphs('age_global_graph_2') $$) AS (result agtype); + result +-------- + true +(1 row) + +-- delete age_global_graph_1's context +-- should return true (succeed) because previous command should not delete the 1st graph's context +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs('age_global_graph_1') $$) AS (result agtype); + result +-------- + true +(1 row) + +-- delete age_global_graph_3's context +-- should return true (succeed) because previous commands should not delete the 3rd graph's context +SELECT * FROM cypher('age_global_graph_3', $$ RETURN delete_global_graphs('age_global_graph_3') $$) AS (result agtype); + result +-------- + true +(1 row) + +-- delete all graphs' context again +-- should return false (did not succeed) for all of them because already removed +SELECT * FROM cypher('age_global_graph_2', $$ RETURN delete_global_graphs('age_global_graph_2') $$) AS (result agtype); + result +-------- + false +(1 row) + +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs('age_global_graph_1') $$) AS (result agtype); + result +-------- + false +(1 row) + +SELECT * FROM cypher('age_global_graph_3', $$ RETURN delete_global_graphs('age_global_graph_3') $$) AS (result agtype); + result +-------- + false +(1 row) + + +-- +-- test delete_GRAPH_global_contexts function +-- +-- load contexts again +SELECT * FROM cypher('age_global_graph_3', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + result +----------------------------------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_3", "in_degree": 0, "out_degree": 0, "self_loops": 0} +(1 row) + +SELECT * FROM cypher('age_global_graph_2', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + result +----------------------------------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_2", "in_degree": 0, "out_degree": 0, "self_loops": 0} +(1 row) + +SELECT * FROM cypher('age_global_graph_1', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + result +----------------------------------------------------------------------------------------------------------- + {"id": 844424930131969, "label": "vertex_from_graph_1", "in_degree": 0, "out_degree": 0, "self_loops": 0} +(1 row) + +-- delete all graph contexts +-- should return true +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs(NULL) $$) AS (result agtype); + result +-------- + true +(1 row) + +-- delete all graphs' context individually +-- should return false for all of them because already removed +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs('age_global_graph_1') $$) AS (result agtype); + result +-------- + false +(1 row) + +SELECT * FROM cypher('age_global_graph_2', $$ RETURN delete_global_graphs('age_global_graph_2') $$) AS (result agtype); + result +-------- + false +(1 row) + +SELECT * FROM cypher('age_global_graph_3', $$ RETURN delete_global_graphs('age_global_graph_3') $$) AS (result agtype); + result +-------- + false +(1 row) + +-- drop graphs +SELECT * FROM drop_graph('age_global_graph_1', true); +NOTICE: drop cascades to 3 other objects +DETAIL: drop cascades to table age_global_graph_1._ag_label_vertex +drop cascades to table age_global_graph_1._ag_label_edge +drop cascades to table age_global_graph_1.vertex_from_graph_1 +NOTICE: graph "age_global_graph_1" has been dropped + drop_graph +------------ + +(1 row) + +SELECT * FROM drop_graph('age_global_graph_2', true); +NOTICE: drop cascades to 3 other objects +DETAIL: drop cascades to table age_global_graph_2._ag_label_vertex +drop cascades to table age_global_graph_2._ag_label_edge +drop cascades to table age_global_graph_2.vertex_from_graph_2 +NOTICE: graph "age_global_graph_2" has been dropped + drop_graph +------------ + +(1 row) + +SELECT * FROM drop_graph('age_global_graph_3', true); +NOTICE: drop cascades to 3 other objects +DETAIL: drop cascades to table age_global_graph_3._ag_label_vertex +drop cascades to table age_global_graph_3._ag_label_edge +drop cascades to table age_global_graph_3.vertex_from_graph_3 +NOTICE: graph "age_global_graph_3" has been dropped + drop_graph +------------ + +(1 row) + +-- +-- End of tests +-- diff --git a/regress/sql/age_global_graph.sql b/regress/sql/age_global_graph.sql new file mode 100644 index 0000000..a62d335 --- /dev/null +++ b/regress/sql/age_global_graph.sql @@ -0,0 +1,68 @@ +LOAD 'age'; +SET search_path TO ag_catalog; + +-- +-- test delete_specific_GRAPH_global_contexts function +-- + +-- create 3 graphs +SELECT * FROM create_graph('age_global_graph_1'); +SELECT * FROM cypher('age_global_graph_1', $$ CREATE (v:vertex_from_graph_1) RETURN v $$) AS (v agtype); + +SELECT * FROM create_graph('age_global_graph_2'); +SELECT * FROM cypher('age_global_graph_2', $$ CREATE (v:vertex_from_graph_2) RETURN v $$) AS (v agtype); + +SELECT * FROM create_graph('age_global_graph_3'); +SELECT * FROM cypher('age_global_graph_3', $$ CREATE (v:vertex_from_graph_3) RETURN v $$) AS (v agtype); + +-- load contexts using the vertex_stats command +SELECT * FROM cypher('age_global_graph_3', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_2', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_1', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + +-- delete age_global_graph_2's context +-- should return true (succeeded) +SELECT * FROM cypher('age_global_graph_2', $$ RETURN delete_global_graphs('age_global_graph_2') $$) AS (result agtype); + +-- delete age_global_graph_1's context +-- should return true (succeed) because previous command should not delete the 1st graph's context +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs('age_global_graph_1') $$) AS (result agtype); + +-- delete age_global_graph_3's context +-- should return true (succeed) because previous commands should not delete the 3rd graph's context +SELECT * FROM cypher('age_global_graph_3', $$ RETURN delete_global_graphs('age_global_graph_3') $$) AS (result agtype); + +-- delete all graphs' context again +-- should return false (did not succeed) for all of them because already removed +SELECT * FROM cypher('age_global_graph_2', $$ RETURN delete_global_graphs('age_global_graph_2') $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs('age_global_graph_1') $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_3', $$ RETURN delete_global_graphs('age_global_graph_3') $$) AS (result agtype); + + +-- +-- test delete_GRAPH_global_contexts function +-- + +-- load contexts again +SELECT * FROM cypher('age_global_graph_3', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_2', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_1', $$ MATCH (u) RETURN vertex_stats(u) $$) AS (result agtype); + +-- delete all graph contexts +-- should return true +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs(NULL) $$) AS (result agtype); + +-- delete all graphs' context individually +-- should return false for all of them because already removed +SELECT * FROM cypher('age_global_graph_1', $$ RETURN delete_global_graphs('age_global_graph_1') $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_2', $$ RETURN delete_global_graphs('age_global_graph_2') $$) AS (result agtype); +SELECT * FROM cypher('age_global_graph_3', $$ RETURN delete_global_graphs('age_global_graph_3') $$) AS (result agtype); + +-- drop graphs +SELECT * FROM drop_graph('age_global_graph_1', true); +SELECT * FROM drop_graph('age_global_graph_2', true); +SELECT * FROM drop_graph('age_global_graph_3', true); + +-- +-- End of tests +--
