===========
TABLE SETUP
===========

graph_q_social.people table object successfully created.
5 records inserted into graph_q_social.people table.
graph_q_social.knows table object successfully created.
5 records inserted into graph_q_social.knows table.

===========
GRAPH SETUP
===========

Creating graph_q_social.social_relationships
graph_q_social.social_relationships creation success!
Number of nodes: 5
Number of edges: 5

=====================
QUERY GRAPH EXAMPLE 1
=====================

Querying graph_q_social.social_relationships for nodes connected to Jane where the node has an interest in chess and it is not connected via family
graph_q_social.social_relationships graph queried successfully.

Query results for adjacency table graph_q_social.social_relationships_queried_jane_to_chess:
+-----------------+--------------------+--------------------+-----------+-----------+
|   QUERY_EDGE_ID | QUERY_NODE1_NAME   | QUERY_NODE2_NAME   |   PATH_ID |   RING_ID |
+=================+====================+====================+===========+===========+
|               1 | Jane               | Bill               |         2 |         1 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               2 | Bill               | Susan              |         2 |         2 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               5 | Susan              | Alex               |         2 |         3 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               1 | Jane               | Bill               |         3 |         1 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               2 | Bill               | Susan              |         3 |         2 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               5 | Susan              | Alex               |         3 |         3 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               4 | Alex               | Tom                |         3 |         4 |
+-----------------+--------------------+--------------------+-----------+-----------+

Query results for target nodes table graph_q_social.social_relationships_queried_jane_to_chess_nodes:
+------------------------+------------------------+--------------------------+--------------------------+-----------+
|   QUERY_NODE_ID_SOURCE |   QUERY_NODE_ID_TARGET | QUERY_NODE_NAME_SOURCE   | QUERY_NODE_NAME_TARGET   |   RING_ID |
+========================+========================+==========================+==========================+===========+
|                      4 |                      3 | Jane                     | Alex                     |         3 |
+------------------------+------------------------+--------------------------+--------------------------+-----------+
|                      4 |                      5 | Jane                     | Tom                      |         4 |
+------------------------+------------------------+--------------------------+--------------------------+-----------+

=====================
QUERY GRAPH EXAMPLE 2
=====================

Querying graph_q_social.social_relationships for nodes connected to directly to 'males'
graph_q_social.social_relationships graph queried successfully.

Query results for adjacency table graph_q_social.social_relationships_queried_males:
+-----------------+--------------------+--------------------+
|   QUERY_EDGE_ID | QUERY_NODE1_NAME   | QUERY_NODE2_NAME   |
+=================+====================+====================+
|               1 | Jane               | Bill               |
+-----------------+--------------------+--------------------+
|               2 | Bill               | Susan              |
+-----------------+--------------------+--------------------+
|               3 | Bill               | Alex               |
+-----------------+--------------------+--------------------+
|               3 | Bill               | Alex               |
+-----------------+--------------------+--------------------+
|               4 | Alex               | Tom                |
+-----------------+--------------------+--------------------+
|               4 | Alex               | Tom                |
+-----------------+--------------------+--------------------+
|               5 | Susan              | Alex               |
+-----------------+--------------------+--------------------+

Query results for target nodes table graph_q_social.social_relationships_queried_males_nodes:
+------------------------+--------------------------+
|   QUERY_NODE_ID_TARGET | QUERY_NODE_NAME_TARGET   |
+========================+==========================+
|                      1 | Susan                    |
+------------------------+--------------------------+
|                      1 | Susan                    |
+------------------------+--------------------------+
|                      2 | Bill                     |
+------------------------+--------------------------+
|                      3 | Alex                     |
+------------------------+--------------------------+
|                      3 | Alex                     |
+------------------------+--------------------------+
|                      4 | Jane                     |
+------------------------+--------------------------+
|                      5 | Tom                      |
+------------------------+--------------------------+

=====================
QUERY GRAPH EXAMPLE 3
=====================

Querying graph_q_social.social_relationships for 'female' nodes or nodes interested in 'chess'.
graph_q_social.social_relationships graph queried successfully.

Query results for adjacency table graph_q_social.social_relationships_queried_females_or_chess:
No adjacencies or targets found.

Query results for target nodes table graph_q_social.social_relationships_queried_females_or_chess_nodes:
+------------------------+--------------------------+
|   QUERY_NODE_ID_TARGET | QUERY_NODE_NAME_TARGET   |
+========================+==========================+
|                      1 | Susan                    |
+------------------------+--------------------------+
|                      3 | Alex                     |
+------------------------+--------------------------+
|                      4 | Jane                     |
+------------------------+--------------------------+
|                      5 | Tom                      |
+------------------------+--------------------------+

=====================
QUERY GRAPH EXAMPLE 4
=====================

Querying graph_q_social.social_relationships for nodes connected to 'females' where the node has an interest in chess
graph_q_social.social_relationships graph queried successfully.

Query results for adjacency table graph_q_social.social_relationships_queried_females_to_chess:
+-----------------+--------------------+--------------------+-----------+-----------+
|   QUERY_EDGE_ID | QUERY_NODE1_NAME   | QUERY_NODE2_NAME   |   PATH_ID |   RING_ID |
+=================+====================+====================+===========+===========+
|               1 | Jane               | Bill               |         1 |         1 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               3 | Bill               | Alex               |         1 |         2 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               5 | Susan              | Alex               |         3 |         1 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               5 | Susan              | Alex               |         4 |         1 |
+-----------------+--------------------+--------------------+-----------+-----------+
|               4 | Alex               | Tom                |         4 |         2 |
+-----------------+--------------------+--------------------+-----------+-----------+

Query results for target nodes table graph_q_social.social_relationships_queried_females_to_chess_nodes:
+------------------------+------------------------+--------------------------+--------------------------+-----------+
|   QUERY_NODE_ID_SOURCE |   QUERY_NODE_ID_TARGET | QUERY_NODE_NAME_SOURCE   | QUERY_NODE_NAME_TARGET   |   RING_ID |
+========================+========================+==========================+==========================+===========+
|                      1 |                      3 | Susan                    | Alex                     |         1 |
+------------------------+------------------------+--------------------------+--------------------------+-----------+
|                      1 |                      5 | Susan                    | Tom                      |         2 |
+------------------------+------------------------+--------------------------+--------------------------+-----------+
|                      4 |                      3 | Jane                     | Alex                     |         2 |
+------------------------+------------------------+--------------------------+--------------------------+-----------+