CREATE GRAPH

CREATE GRAPH sample_graph
(
	EDGES => INPUT_TABLE
	(
		SELECT
			id AS ID,
			wktline AS WKTLINE
		FROM sample_map
	),
	WEIGHTS => INPUT_TABLE
	(
		SELECT
			id AS EDGE_ID,
			cost AS VALUESPECIFIED
		FROM sample_map
	),
	OPTIONS => KV_PAIRS(recreate = 'true', graph_table = 'sample_graph_table')
)

CREATE GRAPH big_cities_graph
(
	NODES => INPUT_TABLE
	(
		SELECT
			city_location AS WKTPOINT
		FROM big_cities
	),
	EDGES => INPUT_TABLE
	(
		SELECT
			city1_location AS NODE1_WKTPOINT,
			city2_location AS NODE2_WKTPOINT
		FROM big_cities_map
	),
	WEIGHTS => INPUT_TABLE
	(
		SELECT
			(REMOVE_NULLABLE(ST_MAKELINE(city1_location, city2_location))) AS EDGE_WKTLINE,
			trip_time AS VALUESPECIFIED
		FROM big_cities_map
	),
	OPTIONS => KV_PAIRS(recreate = 'true', graph_table = 'big_cities_graph_table')
)

CREATE OR REPLACE GRAPH people
(
	NODES => INPUT_TABLES
	(
		(SELECT 'Gender' AS LABEL_KEY, 'MALE:FEMALE' AS LABEL),
		(SELECT 'Interest' AS LABEL_KEY, 'golf:business:dance:chess' AS LABEL),

		(SELECT 'Jane' AS NAME, 'FEMALE:business' AS LABEL),
		(SELECT 'Bill' AS NAME, 'MALE:golf' AS LABEL),
		(SELECT 'Susan' AS NAME, 'FEMALE:dance' AS LABEL),
		(SELECT 'Alex' AS NAME, 'MALE:chess' AS LABEL),
		(SELECT 'Tom' AS NAME, 'MALE:chess' AS LABEL)
	),
	EDGES => INPUT_TABLES
	(
		(SELECT 'Relation' AS LABEL_KEY, 'Friend:Family' AS LABEL),

		(SELECT 'Jane' AS NODE1_NAME, 'Bill' AS NODE2_NAME, 'Friend' AS LABEL),
		(SELECT 'Bill' AS NODE1_NAME, 'Alex' AS NODE2_NAME, 'Family' AS LABEL),
		(SELECT 'Bill' AS NODE1_NAME, 'Susan' AS NODE2_NAME, 'Friend' AS LABEL),
		(SELECT 'Susan' AS NODE1_NAME, 'Alex' AS NODE2_NAME, 'Friend' AS LABEL),
		(SELECT 'Alex' AS NODE1_NAME, 'Tom' AS NODE2_NAME, 'Friend' AS LABEL)
	),
	OPTIONS => KV_PAIRS(label_delimiter = ':', graph_table = 'people_graph_table')
)

CREATE DIRECTED GRAPH imdb
(
	NODES => INPUT_TABLES
	(
		-- Implicit labeling of movie nodes with the LABEL_KEY 'movie', as all movies have an associated genre
		(SELECT DISTINCT genre AS LABEL, 'movie' AS LABEL_KEY FROM movie),
		-- Implicit labeling of person nodes with the LABEL_KEY 'person', as all persons have an associated profession
		(SELECT DISTINCT profession AS LABEL, 'person' AS LABEL_KEY FROM person),

		-- Give each movie node a genre label; the LABEL_KEY 'movie' will also be associated with each
		(SELECT title AS NAME, genre AS LABEL FROM movie),
		-- Give each person node a profession label; the LABEL_KEY 'person' will also be associated with each
		(SELECT name AS NAME, profession AS LABEL FROM person),

		(SELECT DISTINCT CHAR64(YEAR(DOB)) AS NAME, CHAR64('year') AS LABEL FROM person),
		(SELECT DISTINCT CHAR64(released) AS NAME, CHAR64('year') AS LABEL FROM movie)
	),
	EDGES => INPUT_TABLES
	(
		(SELECT DISTINCT participation AS LABEL, 'participation' AS LABEL_KEY FROM imdb),

		(SELECT person AS NODE1_NAME, film AS NODE2_NAME, participation AS LABEL FROM imdb),
		(SELECT title AS NODE1_NAME, CHAR64(released) AS NODE2_NAME, CHAR64('released') AS LABEL FROM movie),
		(SELECT name AS NODE1_NAME, CHAR64(YEAR(dob)) AS NODE2_NAME, CHAR64('born') AS LABEL FROM person)
	),
	OPTIONS => KV_PAIRS(label_delimiter = ':', graph_table = 'imdb_graph_table')
)