APOC supports manual indexes for efficient full text search and lookups however when one exports the graph to Cypher according to the documentation, apoc.export.cypher.all(file,config),
exports whole database incl. indexes as Cypher statements to the provided file
however it seems to only include schema indexes. The exporting to separate files documentation provides the only clue that only schema indexes are exported per the schema.cypher extension. This is confirmed by testing,
> cypher-shell
Connected to Neo4j 3.2.1 at bolt://localhost:7687.
Type :help for a list of available commands or :exit to exit the shell.
Note that Cypher queries must end with a semicolon.
neo4j> CALL apoc.index.list();
+----------------------------------------------------------------------------------------------------------------------------------------------------+
| type | name | config |
+----------------------------------------------------------------------------------------------------------------------------------------------------+
| "NODE" | "id" | {autoUpdate: "true", `keysForLabel:Entity`: "id", type: "fulltext", to_lower_case: "true", provider: "lucene", labels: "Entity"} | |
| "NODE" | "uuid" | {type: "exact", provider: "lucene"} |
+----------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows available after 6 ms, consumed after another 0 ms
neo4j> CALL apoc.export.cypher.all('/tmp/graph.cypher', {format: 'plain', separateFiles: true});
+--------------------------------------------------------------------------------------------------------------------------------+
| file | source | format | nodes | relationships | properties | time | rows |
+--------------------------------------------------------------------------------------------------------------------------------+
| "/tmp/graph.cypher" | "database: nodes(504272), rels(1313576)" | "cypher" | 504272 | 1313576 | 8616039 | 95783 | 0 |
+--------------------------------------------------------------------------------------------------------------------------------+
1 row available after 95813 ms, consumed after another 5 ms
neo4j>
which results in the graph.schema.cypher file containing no reference to the manual index. I realize that these indexes are an APOC extension and not pure Cypher but I was wondering whether they should also be included as part of the export for completeness?
gem-neo4j
commented
1 year ago
APOC supports manual indexes for efficient full text search and lookups however when one exports the graph to Cypher according to the documentation,
apoc.export.cypher.all(file,config),however it seems to only include schema indexes. The exporting to separate files documentation provides the only clue that only schema indexes are exported per the
schema.cypherextension. This is confirmed by testing,which results in the
graph.schema.cypherfile containing no reference to the manual index. I realize that these indexes are an APOC extension and not pure Cypher but I was wondering whether they should also be included as part of the export for completeness?