Operations¶

AkasicDB graph definitions and created graph state are available through SQL functions.

List Graph Definitions¶

akasicdb.list_graph_definition() returns all graph definitions and their creation state.

SELECT *
  FROM akasicdb.list_graph_definition();

Column	Type	Description
`graph_name`	`name`	Graph name
`is_created`	`boolean`	Whether the graph has been created
`match_with_graph_definition`	`boolean`	Whether the created graph matches the current graph definition
`updated_after_creation`	`boolean`	Whether vertices or edges have changed after graph creation

akasicdb.show_graph_definition(...) returns the vertex and edge definitions for one graph.

SELECT *
  FROM akasicdb.show_graph_definition('retail_graph');

Column	Type	Description
`entity_type`	`name`	`vertex` or `edge`
`label`	`name`	Vertex or edge label
`vertex_table`	`name`	Table used by the vertex definition
`ID_column`	`name`	Vertex identifier column
`src_label`	`name`	Source vertex label
`src_table`	`name`	Source table used by the edge query
`dst_label`	`name`	Destination vertex label
`dst_table`	`name`	Destination table used by the edge query
`query`	`name`	SQL query used by the vertex or edge definition

akasicdb.list_graph() returns information about graphs actually created from graph definitions.

SELECT *
  FROM akasicdb.list_graph();

Column	Type	Description
`graph_name`	`name`	Graph name
`match_with_graph_definition`	`boolean`	Whether the graph matches the current graph definition
`undefined_graph`	`boolean`	Whether the graph definition has been deleted
`updated_after_creation`	`boolean`	Whether vertices or edges have changed after graph creation