| /* |
| * 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. |
| */ |
| LOAD 'age'; |
| SET search_path TO ag_catalog; |
| -- |
| -- Test graph names |
| -- |
| -- length |
| -- invalid (length < 3) |
| SELECT create_graph('db'); |
| ERROR: graph name is invalid |
| -- valid (though length > 63, it's truncated automatically before reaching validation function) |
| SELECT create_graph('oiblpsacrufgxiilyevvoiblpsacrufgxiilyevvoiblpsacrufgxiilyevvsdss'); |
| NOTICE: graph "oiblpsacrufgxiilyevvoiblpsacrufgxiilyevvoiblpsacrufgxiilyevvsds" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- valid |
| SELECT create_graph('mydatabase'); |
| NOTICE: graph "mydatabase" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- numeric characters |
| -- invalid (first character numeric; only alphabetic allowed) |
| SELECT create_graph('2mydatabase'); |
| ERROR: graph name is invalid |
| -- valid |
| SELECT create_graph('mydatabase2'); |
| NOTICE: graph "mydatabase2" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- special characters |
| -- invalid (newline character) |
| SELECT create_graph('my |
| database'); |
| ERROR: graph name is invalid |
| -- invalid (space character) |
| SELECT create_graph('my database'); |
| ERROR: graph name is invalid |
| -- invalid (symbol character) |
| SELECT create_graph('my&database'); |
| ERROR: graph name is invalid |
| -- valid (non-ascii alphabet) |
| SELECT create_graph('mydätabase'); |
| NOTICE: graph "mydätabase" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| SELECT create_graph('mydঅtabase'); |
| NOTICE: graph "mydঅtabase" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- dots, dashes, underscore |
| -- valid |
| SELECT create_graph('main.db'); |
| NOTICE: graph "main.db" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- invalid (ends with dot) |
| SELECT create_graph('main.db.'); |
| ERROR: graph name is invalid |
| -- valid |
| SELECT create_graph('main-db'); |
| NOTICE: graph "main-db" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- invalid (ends with dash) |
| SELECT create_graph('main.db-'); |
| ERROR: graph name is invalid |
| -- valid |
| SELECT create_graph('_mydatabase'); |
| NOTICE: graph "_mydatabase" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| SELECT create_graph('my_database'); |
| NOTICE: graph "my_database" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- test rename |
| -- invalid |
| SELECT alter_graph('mydatabase', 'RENAME', '1mydatabase'); |
| ERROR: new graph name is invalid |
| -- valid |
| SELECT alter_graph('mydatabase', 'RENAME', 'mydatabase1'); |
| NOTICE: graph "mydatabase" renamed to "mydatabase1" |
| alter_graph |
| ------------- |
| |
| (1 row) |
| |
| -- clean up |
| SELECT drop_graph('mydatabase1', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table mydatabase1._ag_label_vertex |
| drop cascades to table mydatabase1._ag_label_edge |
| NOTICE: graph "mydatabase1" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('mydätabase', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table "mydätabase"._ag_label_vertex |
| drop cascades to table "mydätabase"._ag_label_edge |
| NOTICE: graph "mydätabase" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('mydঅtabase', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table "mydঅtabase"._ag_label_vertex |
| drop cascades to table "mydঅtabase"._ag_label_edge |
| NOTICE: graph "mydঅtabase" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('mydatabase2', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table mydatabase2._ag_label_vertex |
| drop cascades to table mydatabase2._ag_label_edge |
| NOTICE: graph "mydatabase2" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('main.db', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table "main.db"._ag_label_vertex |
| drop cascades to table "main.db"._ag_label_edge |
| NOTICE: graph "main.db" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('main-db', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table "main-db"._ag_label_vertex |
| drop cascades to table "main-db"._ag_label_edge |
| NOTICE: graph "main-db" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('_mydatabase', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table _mydatabase._ag_label_vertex |
| drop cascades to table _mydatabase._ag_label_edge |
| NOTICE: graph "_mydatabase" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('my_database', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table my_database._ag_label_vertex |
| drop cascades to table my_database._ag_label_edge |
| NOTICE: graph "my_database" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| SELECT drop_graph('oiblpsacrufgxiilyevvoiblpsacrufgxiilyevvoiblpsacrufgxiilyevvsds', true); |
| NOTICE: drop cascades to 2 other objects |
| DETAIL: drop cascades to table oiblpsacrufgxiilyevvoiblpsacrufgxiilyevvoiblpsacrufgxiilyevvsds._ag_label_vertex |
| drop cascades to table oiblpsacrufgxiilyevvoiblpsacrufgxiilyevvoiblpsacrufgxiilyevvsds._ag_label_edge |
| NOTICE: graph "oiblpsacrufgxiilyevvoiblpsacrufgxiilyevvoiblpsacrufgxiilyevvsds" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| -- |
| -- Test label names |
| -- |
| SELECT create_graph('graph123'); |
| NOTICE: graph "graph123" has been created |
| create_graph |
| -------------- |
| |
| (1 row) |
| |
| -- length |
| -- invalid |
| SELECT create_vlabel('graph123', ''); |
| ERROR: label name is invalid |
| SELECT create_elabel('graph123', ''); |
| ERROR: label name is invalid |
| -- valid |
| SELECT create_vlabel('graph123', 'labelx'); |
| NOTICE: VLabel "labelx" has been created |
| create_vlabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_elabel('graph123', 'labely'); |
| NOTICE: ELabel "labely" has been created |
| create_elabel |
| --------------- |
| |
| (1 row) |
| |
| -- special characters |
| -- invalid (newline character) |
| SELECT create_vlabel('graph123', 'my |
| label'); |
| ERROR: label name is invalid |
| SELECT create_elabel('graph123', 'my |
| label'); |
| ERROR: label name is invalid |
| -- invalid (space character) |
| SELECT create_vlabel('graph123', 'my label'); |
| ERROR: label name is invalid |
| SELECT create_elabel('graph123', 'my label'); |
| ERROR: label name is invalid |
| -- invalid (symbol character) |
| SELECT create_vlabel('graph123', 'my&label'); |
| ERROR: label name is invalid |
| SELECT create_elabel('graph123', 'my&label'); |
| ERROR: label name is invalid |
| -- valid (non-ascii alphabet) |
| SELECT create_vlabel('graph123', 'myläbelx'); |
| NOTICE: VLabel "myläbelx" has been created |
| create_vlabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_elabel('graph123', 'myläbely'); |
| NOTICE: ELabel "myläbely" has been created |
| create_elabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_vlabel('graph123', 'mylঅbelx'); |
| NOTICE: VLabel "mylঅbelx" has been created |
| create_vlabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_elabel('graph123', 'mylঅbely'); |
| NOTICE: ELabel "mylঅbely" has been created |
| create_elabel |
| --------------- |
| |
| (1 row) |
| |
| -- valid (underscore) |
| SELECT create_vlabel('graph123', '_labelx'); |
| NOTICE: VLabel "_labelx" has been created |
| create_vlabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_elabel('graph123', '_labely'); |
| NOTICE: ELabel "_labely" has been created |
| create_elabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_vlabel('graph123', 'label_x'); |
| NOTICE: VLabel "label_x" has been created |
| create_vlabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_elabel('graph123', 'label_y'); |
| NOTICE: ELabel "label_y" has been created |
| create_elabel |
| --------------- |
| |
| (1 row) |
| |
| -- numeric |
| -- invalid |
| SELECT create_vlabel('graph123', '1label'); |
| ERROR: label name is invalid |
| SELECT create_elabel('graph123', '2label'); |
| ERROR: label name is invalid |
| -- valid |
| SELECT create_vlabel('graph123', 'label1'); |
| NOTICE: VLabel "label1" has been created |
| create_vlabel |
| --------------- |
| |
| (1 row) |
| |
| SELECT create_elabel('graph123', 'label2'); |
| NOTICE: ELabel "label2" has been created |
| create_elabel |
| --------------- |
| |
| (1 row) |
| |
| -- label creation with cypher |
| -- invalid |
| SELECT * from cypher('graph123', $$ CREATE (a:`my&label`) $$) as (a agtype); |
| ERROR: label name is invalid |
| LINE 1: SELECT * from cypher('graph123', $$ CREATE (a:`my&label`) $$... |
| ^ |
| SELECT * from cypher('graph123', $$ CREATE (:A)-[:`my&label2`]->(:C) $$) as (a agtype); |
| ERROR: label name is invalid |
| LINE 1: SELECT * from cypher('graph123', $$ CREATE (:A)-[:`my&label2... |
| ^ |
| -- valid |
| SELECT * from cypher('graph123', $$ CREATE (a:`mylabel`) $$) as (a agtype); |
| a |
| --- |
| (0 rows) |
| |
| SELECT * from cypher('graph123', $$ CREATE (:A)-[:`mylabel2`]->(:C) $$) as (a agtype); |
| a |
| --- |
| (0 rows) |
| |
| -- clean up |
| SELECT drop_graph('graph123', true); |
| NOTICE: drop cascades to 18 other objects |
| DETAIL: drop cascades to table graph123._ag_label_vertex |
| drop cascades to table graph123._ag_label_edge |
| drop cascades to table graph123.labelx |
| drop cascades to table graph123.labely |
| drop cascades to table graph123."myläbelx" |
| drop cascades to table graph123."myläbely" |
| drop cascades to table graph123."mylঅbelx" |
| drop cascades to table graph123."mylঅbely" |
| drop cascades to table graph123._labelx |
| drop cascades to table graph123._labely |
| drop cascades to table graph123.label_x |
| drop cascades to table graph123.label_y |
| drop cascades to table graph123.label1 |
| drop cascades to table graph123.label2 |
| drop cascades to table graph123.mylabel |
| drop cascades to table graph123."A" |
| drop cascades to table graph123.mylabel2 |
| drop cascades to table graph123."C" |
| NOTICE: graph "graph123" has been dropped |
| drop_graph |
| ------------ |
| |
| (1 row) |
| |
| -- |
| -- End of test |
| -- |