DSE203-originalcode.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1901c42b-28f4-4576-b0b8-697dcb2ac649",
   "metadata": {},
   "source": [
    "# Programming Assignment 1\n",
    "## model transformers:\n",
    "### 4. Semistructured to Property Graph\n",
    "Each of the six groups should choose one and implement it in Python with a README file and some documentation. The implementation can be delivered in one of three ways: a command line utility, a Python package, or a REST API. A model transformer will take as input (a) a data file (e.g., CSV) of a specific model, and (b) a mapping configuration (in class we have seen several examples -- see the Model Transformation slides) and output a transformed data file. The developing group should also produce a sample input data file and its corresponding output data file. If any implementation uses an existing library or has some dependency (e.g., it uses Java), it should be mentioned in the README file so that the users can configure their environment accordingly. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "e80b8b32-b56c-466a-896f-c1f3d28a15fc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import argparse\n",
    "import json\n",
    "\n",
    "def load_json_data(input_file):\n",
    "    try:\n",
    "        with open(input_file, 'r') as data_json:\n",
    "            source_data = json.load(data_json)\n",
    "        return source_data\n",
    "    except FileNotFoundError:\n",
    "        print(f\"Error: The file '{input_file}' was not found.\")\n",
    "        return None\n",
    "\n",
    "# Create an argument parser\n",
    "parser = argparse.ArgumentParser(description=\"Load JSON data from a file\")\n",
    "\n",
    "# Add arguments for input file and mapping configuration file\n",
    "parser.add_argument(\"input_file\", help=\"Path to the input JSON data file\")\n",
    "parser.add_argument(\"map_cfg_file\", help=\"Path to the mapping configuration file\")\n",
    "\n",
    "# Parse the command-line arguments\n",
    "# args = parser.parse_args()\n",
    "\n",
    "# Specify the input file path here\n",
    "#input_file = './people2.json'  # Replace with the actual file path\n",
    "#map_cfg_file = './people_map_cfg.json'\n",
    "\n",
    "#input_file = './books.json'  # Replace with the actual file path\n",
    "#map_cfg_file = './books_map_cfg.json'\n",
    "input_file = './movies.json'  # Replace with the actual file path\n",
    "map_cfg_file = './movies_map_cfg.json'\n",
    "\n",
    "# Load data from the specified input file\n",
    "source_data = load_json_data(input_file)\n",
    "mapping_config = load_json_data(map_cfg_file)\n",
    "\n",
    "# if source_data and mapping_config:\n",
    "# Your data processing code goes here\n",
    "# print(source_data)\n",
    "# print(mapping_config)\n",
    "\n",
    "# Initialize the property graph\n",
    "property_graph = {\n",
    "    \"graph\": {\n",
    "        \"nodes\": [],\n",
    "        \"edges\": []\n",
    "    }\n",
    "}\n",
    "\n",
    "# add nodes to the property graph\n",
    "\n",
    "\n",
    "for i in range(len(mapping_config['schema-map']['nodes'])):\n",
    "    for element in source_data[mapping_config['schema-map']['nodes'][i]['label']]:\n",
    "        node = {\n",
    "            \"node\": {\n",
    "                \"id\": element[mapping_config['schema-map']['nodes'][i]['node-id']],\n",
    "                \"label\": mapping_config['schema-map']['nodes'][i]['label'],\n",
    "                \"properties\": {}  # mapping_config['schema-map']['nodes'][i]['node-properties']\n",
    "            }\n",
    "        }\n",
    "    \n",
    "        # Map properties to the node\n",
    "        for property_name, property_mapping in mapping_config['schema-map']['nodes'][i]['node-properties'].items():\n",
    "            # Assuming property_mapping is a dictionary\n",
    "            data_value = property_mapping.get(\"data_value\", None)\n",
    "            data_type = property_mapping.get(\"data_type\", None)\n",
    "    \n",
    "            # Now, you can split the data_value (assuming it's a string)\n",
    "            if data_value is not None:\n",
    "                for key in data_value.split('.'):\n",
    "                    property_value = element.get(key, None)\n",
    "                    if property_value is None:\n",
    "                        break\n",
    "    \n",
    "            if property_value is not None:\n",
    "                node[\"node\"][\"properties\"][property_name] = {\n",
    "                    \"datatype\": data_type,  # comment: modify this based on the actual data types\n",
    "                    \"data value\": property_value\n",
    "                }\n",
    "    \n",
    "        property_graph[\"graph\"][\"nodes\"].append(node)\n",
    "    '''\n",
    "    # source data and add edges to the property graph\n",
    "for j in range(len(mapping_config['schema-map']['edges'])):\n",
    "    for element in source_data[mapping_config['schema-map']['edges'][j]['_source_type']]:\n",
    "        source_id = element[mapping_config['schema-map']['edges'][j]['_source']]\n",
    "        target = element.get(mapping_config['schema-map']['edges'][j]['edge-type'], [])\n",
    "\n",
    "        for target_id in target:\n",
    "            edge = {\n",
    "                \"edge\": {\n",
    "                    \"id\": len(property_graph[\"graph\"][\"edges\"]) + 1,\n",
    "                    \"relationship\": mapping_config['schema-map']['edges'][j]['relationship'],\n",
    "                    \"from_node_id\": source_id,\n",
    "                    \"to_node_id\": target_id,\n",
    "                    \"properties\": {}\n",
    "                }\n",
    "            }\n",
    "\n",
    "            property_graph[\"graph\"][\"edges\"].append(edge)\n",
    "    \n",
    "# Save the property graph in JSON format\n",
    "with open(\"property_graph.json\", \"w\") as output_file:\n",
    "    json.dump(property_graph, output_file, indent=4)\n",
    "\n",
    "property_graph\n",
    "'''\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b825ec43-3247-4408-8f63-c875365d948c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'graph': {'nodes': [{'node': {'id': 'The Murder of Nicole Brown Simpson',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': \"The Murder of Nicole Brown Simpson is a 2019 American crime horror film directed by Daniel Farrands. The film is loosely based on the murder of Nicole Brown Simpson, presenting a version of events in which Brown Simpson is murdered by serial killer Glen Edward Rogers, and not by O. J. Simpson, her ex-husband and the primary suspect in the case. Though Mena Suvari's performance as Nicole Brown was praised, the film was panned by critics.\"},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/e/ed/The_Murder_of_Nicole_Brown_Simpson_poster.jpg'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 263},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 380},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Mena Suvari', 'Nick Stahl', 'Taryn Manning']}}}},\n",
       "   {'node': {'id': 'Bad Boys for Life',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': \"Bad Boys for Life is a 2020 American buddy cop action comedy film directed by Adil & Bilall. It is the sequel to Bad Boys II (2003) and the third installment in the Bad Boys franchise. Will Smith, Martin Lawrence, Joe Pantoliano and Theresa Randle reprise their roles in the film and are joined by Paola Núñez, Vanessa Hudgens, Jacob Scipio, Alexander Ludwig, Charles Melton, Kate del Castillo and Nicky Jam. The film was produced by Smith, Jerry Bruckheimer, and Doug Belgrad, with a screenplay written by Chris Bremner, Peter Craig and Joe Carnahan. In Bad Boys for Life, Miami detectives Mike Lowrey and Marcus Burnett investigate a string of murders tied to Lowrey's troubled past.\"},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/9/90/Bad_Boys_for_Life_poster.jpg'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 219},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 325},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Will Smith',\n",
       "        'Martin Lawrence',\n",
       "        'Vanessa Hudgens',\n",
       "        'Alexander Ludwig',\n",
       "        'Charles Melton',\n",
       "        'Paola Nunez',\n",
       "        'Kate del Castillo',\n",
       "        'Nicky Jam',\n",
       "        'Joe Pantoliano']}}}},\n",
       "   {'node': {'id': 'Dolittle',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': \"Dolittle is a 2020 American fantasy adventure film directed by Stephen Gaghan from a screenplay by Gaghan, Dan Gregor, and Doug Mand, based on a story by Thomas Shepherd. Dolittle is based on the title character created by Hugh Lofting and is primarily inspired by the author's second Doctor Dolittle book, The Voyages of Doctor Dolittle (1922). Robert Downey Jr. stars as the title character, alongside Antonio Banderas and Michael Sheen in live-action roles, with Emma Thompson, Rami Malek, John Cena, Kumail Nanjiani, Octavia Spencer, Tom Holland, Craig Robinson, Ralph Fiennes, Selena Gomez, and Marion Cotillard voicing an array of creatures.\"},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/1/1f/Dolittle_%282020_film_poster%29.png'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 220},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 326},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Robert Downey Jr.',\n",
       "        'Antonio Banderas',\n",
       "        'Michael Sheen',\n",
       "        'Emma Thompson',\n",
       "        'Rami Malek',\n",
       "        'John Cena',\n",
       "        'Kumail Nanjiani',\n",
       "        'Octavia Spencer',\n",
       "        'Tom Holland',\n",
       "        'Craig Robinson',\n",
       "        'Ralph Fiennes',\n",
       "        'Selena Gomez',\n",
       "        'Marion Cotillard']}}}},\n",
       "   {'node': {'id': 'A Fall from Grace',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': 'A Fall from Grace is a 2020 American thriller film produced, written, and directed by Tyler Perry and his first to be released by Netflix. The film follows a woman who finds a dangerous new love and the novice attorney who defends her in a sensational court case. This was the final film of actor Cicely Tyson before her death in January 2021.'},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/4/4e/AFallFromGrace.png'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 259},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 383},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Crystal R. Fox',\n",
       "        'Phylicia Rashad',\n",
       "        'Bresha Webb',\n",
       "        'Mehcad Brooks',\n",
       "        'Cicely Tyson',\n",
       "        'Tyler Perry']}}}},\n",
       "   {'node': {'id': 'The Gentlemen',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': 'The Gentlemen is a 2019 action comedy film written, directed and produced by Guy Ritchie, who developed the story along with Ivan Atkinson and Marn Davies. The film stars Matthew McConaughey, Charlie Hunnam, Henry Golding, Michelle Dockery, Jeremy Strong, Eddie Marsan, Colin Farrell, and Hugh Grant. It follows an American cannabis wholesaler in England who is looking to sell his business, setting off a chain of blackmail and schemes to undermine him.'},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/0/06/The_Gentlemen_poster.jpg'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 259},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 383},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Matthew McConaughey',\n",
       "        'Charlie Hunnam',\n",
       "        'Henry Golding',\n",
       "        'Michelle Dockery',\n",
       "        'Jeremy Strong',\n",
       "        'Eddie Marsan',\n",
       "        'Colin Farrell',\n",
       "        'Hugh Grant']}}}},\n",
       "   {'node': {'id': 'The Turning',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': 'The Turning is a 2020 American gothic supernatural horror film directed by Floria Sigismondi and written by Carey W. Hayes and Chad Hayes. It is a modern adaptation of the 1898 ghost story The Turn of the Screw by Henry James. It stars Mackenzie Davis, Finn Wolfhard, Brooklynn Prince, and Joely Richardson, and follows a young governess in 1994 who is hired to watch over two children after their parents are killed.'},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/a/a2/The_Turning_poster_2020.jpg'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 251},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 397},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Mackenzie Davis',\n",
       "        'Finn Wolfhard',\n",
       "        'Brooklynn Prince',\n",
       "        'Joely Richardson']}}}},\n",
       "   {'node': {'id': 'The Last Full Measure',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': \"The Last Full Measure is a 2019 American war drama film written and directed by Todd Robinson. It follows the efforts of fictional Pentagon staffer Scott Huffman and many veterans to see the Medal of Honor awarded to William H. Pitsenbarger, a United States Air Force Pararescueman who flew in helicopter rescue missions during the Vietnam War to aid downed soldiers and pilots. Based on true events, the film stars Sebastian Stan, Christopher Plummer, William Hurt, Ed Harris, Samuel L. Jackson, Jeremy Irvine, and Peter Fonda. It was the final film appearance of Fonda, who died before the film’s release; and Plummer's final on screen appearance before his death in 2021, though it had filmed prior to Knives Out which was released before it.\"},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/9/9d/The_Last_Full_Measure_2019_poster.jpg'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 256},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 378},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Sebastian Stan',\n",
       "        'Christopher Plummer',\n",
       "        'William Hurt',\n",
       "        'Ed Harris',\n",
       "        'Samuel L. Jackson',\n",
       "        'Peter Fonda',\n",
       "        'LisaGay Hamilton',\n",
       "        'Jeremy Irvine',\n",
       "        'Diane Ladd',\n",
       "        'Amy Madigan',\n",
       "        'John Savage',\n",
       "        'Bradley Whitford']}}}},\n",
       "   {'node': {'id': 'John Henry',\n",
       "     'label': 'Movies',\n",
       "     'properties': {'Extract': {'datatype': 'string',\n",
       "       'data value': 'John Henry is a 2020 American thriller drama film starring Terry Crews and Ludacris, and directed by Will Forbes. Inspired by the folk lore of John Henry, the plot follows an ex-gang member from Los Angeles who must help two immigrant children who are on the run from his former crime boss. The film had a limited release on January 24, 2020, and received negative reviews from critics.'},\n",
       "      'thumbnail_url': {'datatype': 'string',\n",
       "       'data value': 'https://upload.wikimedia.org/wikipedia/en/b/b8/JohnHenryPoster.jpeg'},\n",
       "      'thumbnail_width': {'datatype': 'string', 'data value': 220},\n",
       "      'thumbnail_height': {'datatype': 'string', 'data value': 316},\n",
       "      'Cast': {'datatype': 'list',\n",
       "       'data value': ['Terry Crews',\n",
       "        'Ludacris',\n",
       "        'Jamila Velazquez',\n",
       "        'Ken Foree',\n",
       "        'Tyler Alvarez',\n",
       "        'Joseph Julian Soria']}}}},\n",
       "   {'node': {'id': 'Mena Suvari',\n",
       "     'label': 'People',\n",
       "     'properties': {'Age': {'datatype': 'numeric', 'data value': 20},\n",
       "      'Gender': {'datatype': 'string', 'data value': 'Male'},\n",
       "      'friends': {'datatype': 'list', 'data value': [2, 3]}}}},\n",
       "   {'node': {'id': 'Terry Crews',\n",
       "     'label': 'People',\n",
       "     'properties': {'Age': {'datatype': 'numeric', 'data value': 25},\n",
       "      'Gender': {'datatype': 'string', 'data value': 'Female'},\n",
       "      'friends': {'datatype': 'list', 'data value': [1]}}}},\n",
       "   {'node': {'id': 'Ludacris',\n",
       "     'label': 'People',\n",
       "     'properties': {'Age': {'datatype': 'numeric', 'data value': 22},\n",
       "      'Gender': {'datatype': 'string', 'data value': 'Male'},\n",
       "      'friends': {'datatype': 'list', 'data value': [1, 4]}}}},\n",
       "   {'node': {'id': 'Joseph Julian Soria',\n",
       "     'label': 'People',\n",
       "     'properties': {'Age': {'datatype': 'numeric', 'data value': 52},\n",
       "      'Gender': {'datatype': 'string', 'data value': 'Male'},\n",
       "      'friends': {'datatype': 'list', 'data value': [3]}}}}],\n",
       "  'edges': []}}"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "property_graph"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6abe6416",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'schema-map': {'nodes': [{'node-type': '$.Movies',\n",
       "    'label': 'Movies',\n",
       "    'node-id': 'title',\n",
       "    'node-properties': {'Extract': {'data_type': 'string',\n",
       "      'data_value': 'extract'},\n",
       "     'thumbnail_url': {'data_type': 'string', 'data_value': 'thumbnail'},\n",
       "     'thumbnail_width': {'data_type': 'string',\n",
       "      'data_value': 'thumbnail_width'},\n",
       "     'thumbnail_height': {'data_type': 'string',\n",
       "      'data_value': 'thumbnail_height'},\n",
       "     'Generes': {'data_type': 'list', 'data_value': 'generes'},\n",
       "     'Cast': {'data_type': 'list', 'data_value': 'cast'}}},\n",
       "   {'node-type': '$.People',\n",
       "    'label': 'People',\n",
       "    'node-id': 'Name',\n",
       "    'node-properties': {'Age': {'data_type': 'numeric', 'data_value': 'Age'},\n",
       "     'Gender': {'data_type': 'string', 'data_value': 'Gender'},\n",
       "     'friends': {'data_type': 'list', 'data_value': 'friends'}}}],\n",
       "  'edges': [{'edge-type': 'cast',\n",
       "    'relationship': 'PLAYED_IN',\n",
       "    'direction': 'Out',\n",
       "    'edge-id': '',\n",
       "    'edge-properties': '',\n",
       "    '_source': 'id',\n",
       "    '_source_type': 'People',\n",
       "    '_target': 'Cast',\n",
       "    '_target_type': 'Movies'}]}}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mapping_config"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "73f9ac9e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "71f53ae4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'edge-type': 'cast', 'relationship': 'PLAYED_IN', 'direction': 'Out', 'edge-id': '', 'edge-properties': '', '_source': 'id', '_source_type': 'People', '_target': 'Cast', '_target_type': 'Movies'}\n",
      "People Movies id Cast\n",
      "Src Nodes\n",
      "[{'node': {'id': 'Mena Suvari', 'label': 'People', 'properties': {'Age': {'datatype': 'numeric', 'data value': 20}, 'Gender': {'datatype': 'string', 'data value': 'Male'}, 'friends': {'datatype': 'list', 'data value': [2, 3]}}}}, {'node': {'id': 'Terry Crews', 'label': 'People', 'properties': {'Age': {'datatype': 'numeric', 'data value': 25}, 'Gender': {'datatype': 'string', 'data value': 'Female'}, 'friends': {'datatype': 'list', 'data value': [1]}}}}, {'node': {'id': 'Ludacris', 'label': 'People', 'properties': {'Age': {'datatype': 'numeric', 'data value': 22}, 'Gender': {'datatype': 'string', 'data value': 'Male'}, 'friends': {'datatype': 'list', 'data value': [1, 4]}}}}, {'node': {'id': 'Joseph Julian Soria', 'label': 'People', 'properties': {'Age': {'datatype': 'numeric', 'data value': 52}, 'Gender': {'datatype': 'string', 'data value': 'Male'}, 'friends': {'datatype': 'list', 'data value': [3]}}}}]\n",
      "Trgt Nodes\n",
      "[{'node': {'id': 'The Murder of Nicole Brown Simpson', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': \"The Murder of Nicole Brown Simpson is a 2019 American crime horror film directed by Daniel Farrands. The film is loosely based on the murder of Nicole Brown Simpson, presenting a version of events in which Brown Simpson is murdered by serial killer Glen Edward Rogers, and not by O. J. Simpson, her ex-husband and the primary suspect in the case. Though Mena Suvari's performance as Nicole Brown was praised, the film was panned by critics.\"}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/e/ed/The_Murder_of_Nicole_Brown_Simpson_poster.jpg'}, 'thumbnail_width': {'datatype': 'string', 'data value': 263}, 'thumbnail_height': {'datatype': 'string', 'data value': 380}, 'Cast': {'datatype': 'list', 'data value': ['Mena Suvari', 'Nick Stahl', 'Taryn Manning']}}}}, {'node': {'id': 'Bad Boys for Life', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': \"Bad Boys for Life is a 2020 American buddy cop action comedy film directed by Adil & Bilall. It is the sequel to Bad Boys II (2003) and the third installment in the Bad Boys franchise. Will Smith, Martin Lawrence, Joe Pantoliano and Theresa Randle reprise their roles in the film and are joined by Paola Núñez, Vanessa Hudgens, Jacob Scipio, Alexander Ludwig, Charles Melton, Kate del Castillo and Nicky Jam. The film was produced by Smith, Jerry Bruckheimer, and Doug Belgrad, with a screenplay written by Chris Bremner, Peter Craig and Joe Carnahan. In Bad Boys for Life, Miami detectives Mike Lowrey and Marcus Burnett investigate a string of murders tied to Lowrey's troubled past.\"}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/9/90/Bad_Boys_for_Life_poster.jpg'}, 'thumbnail_width': {'datatype': 'string', 'data value': 219}, 'thumbnail_height': {'datatype': 'string', 'data value': 325}, 'Cast': {'datatype': 'list', 'data value': ['Will Smith', 'Martin Lawrence', 'Vanessa Hudgens', 'Alexander Ludwig', 'Charles Melton', 'Paola Nunez', 'Kate del Castillo', 'Nicky Jam', 'Joe Pantoliano']}}}}, {'node': {'id': 'Dolittle', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': \"Dolittle is a 2020 American fantasy adventure film directed by Stephen Gaghan from a screenplay by Gaghan, Dan Gregor, and Doug Mand, based on a story by Thomas Shepherd. Dolittle is based on the title character created by Hugh Lofting and is primarily inspired by the author's second Doctor Dolittle book, The Voyages of Doctor Dolittle (1922). Robert Downey Jr. stars as the title character, alongside Antonio Banderas and Michael Sheen in live-action roles, with Emma Thompson, Rami Malek, John Cena, Kumail Nanjiani, Octavia Spencer, Tom Holland, Craig Robinson, Ralph Fiennes, Selena Gomez, and Marion Cotillard voicing an array of creatures.\"}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/1/1f/Dolittle_%282020_film_poster%29.png'}, 'thumbnail_width': {'datatype': 'string', 'data value': 220}, 'thumbnail_height': {'datatype': 'string', 'data value': 326}, 'Cast': {'datatype': 'list', 'data value': ['Robert Downey Jr.', 'Antonio Banderas', 'Michael Sheen', 'Emma Thompson', 'Rami Malek', 'John Cena', 'Kumail Nanjiani', 'Octavia Spencer', 'Tom Holland', 'Craig Robinson', 'Ralph Fiennes', 'Selena Gomez', 'Marion Cotillard']}}}}, {'node': {'id': 'A Fall from Grace', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': 'A Fall from Grace is a 2020 American thriller film produced, written, and directed by Tyler Perry and his first to be released by Netflix. The film follows a woman who finds a dangerous new love and the novice attorney who defends her in a sensational court case. This was the final film of actor Cicely Tyson before her death in January 2021.'}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/4/4e/AFallFromGrace.png'}, 'thumbnail_width': {'datatype': 'string', 'data value': 259}, 'thumbnail_height': {'datatype': 'string', 'data value': 383}, 'Cast': {'datatype': 'list', 'data value': ['Crystal R. Fox', 'Phylicia Rashad', 'Bresha Webb', 'Mehcad Brooks', 'Cicely Tyson', 'Tyler Perry']}}}}, {'node': {'id': 'The Gentlemen', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': 'The Gentlemen is a 2019 action comedy film written, directed and produced by Guy Ritchie, who developed the story along with Ivan Atkinson and Marn Davies. The film stars Matthew McConaughey, Charlie Hunnam, Henry Golding, Michelle Dockery, Jeremy Strong, Eddie Marsan, Colin Farrell, and Hugh Grant. It follows an American cannabis wholesaler in England who is looking to sell his business, setting off a chain of blackmail and schemes to undermine him.'}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/0/06/The_Gentlemen_poster.jpg'}, 'thumbnail_width': {'datatype': 'string', 'data value': 259}, 'thumbnail_height': {'datatype': 'string', 'data value': 383}, 'Cast': {'datatype': 'list', 'data value': ['Matthew McConaughey', 'Charlie Hunnam', 'Henry Golding', 'Michelle Dockery', 'Jeremy Strong', 'Eddie Marsan', 'Colin Farrell', 'Hugh Grant']}}}}, {'node': {'id': 'The Turning', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': 'The Turning is a 2020 American gothic supernatural horror film directed by Floria Sigismondi and written by Carey W. Hayes and Chad Hayes. It is a modern adaptation of the 1898 ghost story The Turn of the Screw by Henry James. It stars Mackenzie Davis, Finn Wolfhard, Brooklynn Prince, and Joely Richardson, and follows a young governess in 1994 who is hired to watch over two children after their parents are killed.'}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/a/a2/The_Turning_poster_2020.jpg'}, 'thumbnail_width': {'datatype': 'string', 'data value': 251}, 'thumbnail_height': {'datatype': 'string', 'data value': 397}, 'Cast': {'datatype': 'list', 'data value': ['Mackenzie Davis', 'Finn Wolfhard', 'Brooklynn Prince', 'Joely Richardson']}}}}, {'node': {'id': 'The Last Full Measure', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': \"The Last Full Measure is a 2019 American war drama film written and directed by Todd Robinson. It follows the efforts of fictional Pentagon staffer Scott Huffman and many veterans to see the Medal of Honor awarded to William H. Pitsenbarger, a United States Air Force Pararescueman who flew in helicopter rescue missions during the Vietnam War to aid downed soldiers and pilots. Based on true events, the film stars Sebastian Stan, Christopher Plummer, William Hurt, Ed Harris, Samuel L. Jackson, Jeremy Irvine, and Peter Fonda. It was the final film appearance of Fonda, who died before the film’s release; and Plummer's final on screen appearance before his death in 2021, though it had filmed prior to Knives Out which was released before it.\"}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/9/9d/The_Last_Full_Measure_2019_poster.jpg'}, 'thumbnail_width': {'datatype': 'string', 'data value': 256}, 'thumbnail_height': {'datatype': 'string', 'data value': 378}, 'Cast': {'datatype': 'list', 'data value': ['Sebastian Stan', 'Christopher Plummer', 'William Hurt', 'Ed Harris', 'Samuel L. Jackson', 'Peter Fonda', 'LisaGay Hamilton', 'Jeremy Irvine', 'Diane Ladd', 'Amy Madigan', 'John Savage', 'Bradley Whitford']}}}}, {'node': {'id': 'John Henry', 'label': 'Movies', 'properties': {'Extract': {'datatype': 'string', 'data value': 'John Henry is a 2020 American thriller drama film starring Terry Crews and Ludacris, and directed by Will Forbes. Inspired by the folk lore of John Henry, the plot follows an ex-gang member from Los Angeles who must help two immigrant children who are on the run from his former crime boss. The film had a limited release on January 24, 2020, and received negative reviews from critics.'}, 'thumbnail_url': {'datatype': 'string', 'data value': 'https://upload.wikimedia.org/wikipedia/en/b/b8/JohnHenryPoster.jpeg'}, 'thumbnail_width': {'datatype': 'string', 'data value': 220}, 'thumbnail_height': {'datatype': 'string', 'data value': 316}, 'Cast': {'datatype': 'list', 'data value': ['Terry Crews', 'Ludacris', 'Jamila Velazquez', 'Ken Foree', 'Tyler Alvarez', 'Joseph Julian Soria']}}}}]\n",
      "Mena Suvari ['Mena Suvari', 'Nick Stahl', 'Taryn Manning']\n",
      "Mena Suvari ['Will Smith', 'Martin Lawrence', 'Vanessa Hudgens', 'Alexander Ludwig', 'Charles Melton', 'Paola Nunez', 'Kate del Castillo', 'Nicky Jam', 'Joe Pantoliano']\n",
      "Mena Suvari ['Robert Downey Jr.', 'Antonio Banderas', 'Michael Sheen', 'Emma Thompson', 'Rami Malek', 'John Cena', 'Kumail Nanjiani', 'Octavia Spencer', 'Tom Holland', 'Craig Robinson', 'Ralph Fiennes', 'Selena Gomez', 'Marion Cotillard']\n",
      "Mena Suvari ['Crystal R. Fox', 'Phylicia Rashad', 'Bresha Webb', 'Mehcad Brooks', 'Cicely Tyson', 'Tyler Perry']\n",
      "Mena Suvari ['Matthew McConaughey', 'Charlie Hunnam', 'Henry Golding', 'Michelle Dockery', 'Jeremy Strong', 'Eddie Marsan', 'Colin Farrell', 'Hugh Grant']\n",
      "Mena Suvari ['Mackenzie Davis', 'Finn Wolfhard', 'Brooklynn Prince', 'Joely Richardson']\n",
      "Mena Suvari ['Sebastian Stan', 'Christopher Plummer', 'William Hurt', 'Ed Harris', 'Samuel L. Jackson', 'Peter Fonda', 'LisaGay Hamilton', 'Jeremy Irvine', 'Diane Ladd', 'Amy Madigan', 'John Savage', 'Bradley Whitford']\n",
      "Mena Suvari ['Terry Crews', 'Ludacris', 'Jamila Velazquez', 'Ken Foree', 'Tyler Alvarez', 'Joseph Julian Soria']\n",
      "Terry Crews ['Mena Suvari', 'Nick Stahl', 'Taryn Manning']\n",
      "Terry Crews ['Will Smith', 'Martin Lawrence', 'Vanessa Hudgens', 'Alexander Ludwig', 'Charles Melton', 'Paola Nunez', 'Kate del Castillo', 'Nicky Jam', 'Joe Pantoliano']\n",
      "Terry Crews ['Robert Downey Jr.', 'Antonio Banderas', 'Michael Sheen', 'Emma Thompson', 'Rami Malek', 'John Cena', 'Kumail Nanjiani', 'Octavia Spencer', 'Tom Holland', 'Craig Robinson', 'Ralph Fiennes', 'Selena Gomez', 'Marion Cotillard']\n",
      "Terry Crews ['Crystal R. Fox', 'Phylicia Rashad', 'Bresha Webb', 'Mehcad Brooks', 'Cicely Tyson', 'Tyler Perry']\n",
      "Terry Crews ['Matthew McConaughey', 'Charlie Hunnam', 'Henry Golding', 'Michelle Dockery', 'Jeremy Strong', 'Eddie Marsan', 'Colin Farrell', 'Hugh Grant']\n",
      "Terry Crews ['Mackenzie Davis', 'Finn Wolfhard', 'Brooklynn Prince', 'Joely Richardson']\n",
      "Terry Crews ['Sebastian Stan', 'Christopher Plummer', 'William Hurt', 'Ed Harris', 'Samuel L. Jackson', 'Peter Fonda', 'LisaGay Hamilton', 'Jeremy Irvine', 'Diane Ladd', 'Amy Madigan', 'John Savage', 'Bradley Whitford']\n",
      "Terry Crews ['Terry Crews', 'Ludacris', 'Jamila Velazquez', 'Ken Foree', 'Tyler Alvarez', 'Joseph Julian Soria']\n",
      "Ludacris ['Mena Suvari', 'Nick Stahl', 'Taryn Manning']\n",
      "Ludacris ['Will Smith', 'Martin Lawrence', 'Vanessa Hudgens', 'Alexander Ludwig', 'Charles Melton', 'Paola Nunez', 'Kate del Castillo', 'Nicky Jam', 'Joe Pantoliano']\n",
      "Ludacris ['Robert Downey Jr.', 'Antonio Banderas', 'Michael Sheen', 'Emma Thompson', 'Rami Malek', 'John Cena', 'Kumail Nanjiani', 'Octavia Spencer', 'Tom Holland', 'Craig Robinson', 'Ralph Fiennes', 'Selena Gomez', 'Marion Cotillard']\n",
      "Ludacris ['Crystal R. Fox', 'Phylicia Rashad', 'Bresha Webb', 'Mehcad Brooks', 'Cicely Tyson', 'Tyler Perry']\n",
      "Ludacris ['Matthew McConaughey', 'Charlie Hunnam', 'Henry Golding', 'Michelle Dockery', 'Jeremy Strong', 'Eddie Marsan', 'Colin Farrell', 'Hugh Grant']\n",
      "Ludacris ['Mackenzie Davis', 'Finn Wolfhard', 'Brooklynn Prince', 'Joely Richardson']\n",
      "Ludacris ['Sebastian Stan', 'Christopher Plummer', 'William Hurt', 'Ed Harris', 'Samuel L. Jackson', 'Peter Fonda', 'LisaGay Hamilton', 'Jeremy Irvine', 'Diane Ladd', 'Amy Madigan', 'John Savage', 'Bradley Whitford']\n",
      "Ludacris ['Terry Crews', 'Ludacris', 'Jamila Velazquez', 'Ken Foree', 'Tyler Alvarez', 'Joseph Julian Soria']\n",
      "Joseph Julian Soria ['Mena Suvari', 'Nick Stahl', 'Taryn Manning']\n",
      "Joseph Julian Soria ['Will Smith', 'Martin Lawrence', 'Vanessa Hudgens', 'Alexander Ludwig', 'Charles Melton', 'Paola Nunez', 'Kate del Castillo', 'Nicky Jam', 'Joe Pantoliano']\n",
      "Joseph Julian Soria ['Robert Downey Jr.', 'Antonio Banderas', 'Michael Sheen', 'Emma Thompson', 'Rami Malek', 'John Cena', 'Kumail Nanjiani', 'Octavia Spencer', 'Tom Holland', 'Craig Robinson', 'Ralph Fiennes', 'Selena Gomez', 'Marion Cotillard']\n",
      "Joseph Julian Soria ['Crystal R. Fox', 'Phylicia Rashad', 'Bresha Webb', 'Mehcad Brooks', 'Cicely Tyson', 'Tyler Perry']\n",
      "Joseph Julian Soria ['Matthew McConaughey', 'Charlie Hunnam', 'Henry Golding', 'Michelle Dockery', 'Jeremy Strong', 'Eddie Marsan', 'Colin Farrell', 'Hugh Grant']\n",
      "Joseph Julian Soria ['Mackenzie Davis', 'Finn Wolfhard', 'Brooklynn Prince', 'Joely Richardson']\n",
      "Joseph Julian Soria ['Sebastian Stan', 'Christopher Plummer', 'William Hurt', 'Ed Harris', 'Samuel L. Jackson', 'Peter Fonda', 'LisaGay Hamilton', 'Jeremy Irvine', 'Diane Ladd', 'Amy Madigan', 'John Savage', 'Bradley Whitford']\n",
      "Joseph Julian Soria ['Terry Crews', 'Ludacris', 'Jamila Velazquez', 'Ken Foree', 'Tyler Alvarez', 'Joseph Julian Soria']\n"
     ]
    }
   ],
   "source": [
    "for edge in mapping_config['schema-map']['edges']:\n",
    "    print(edge)\n",
    "    src_type = edge['_source_type']\n",
    "    trgt_type = edge['_target_type']\n",
    "    src_match = edge['_source']\n",
    "    trgt_match = edge['_target']\n",
    "    print(src_type,trgt_type,src_match, trgt_match)\n",
    "    src_nodes = []\n",
    "    target_nodes = []\n",
    "    for node in property_graph['graph']['nodes']:\n",
    "        if node['node']['label'] == src_type:\n",
    "            src_nodes.append(node)\n",
    "        if node['node']['label'] == trgt_type:\n",
    "            target_nodes.append(node)\n",
    "    print(\"Src Nodes\")\n",
    "    print(src_nodes)\n",
    "    print(\"Trgt Nodes\")\n",
    "    print(target_nodes)\n",
    "    edge_id = 0\n",
    "    for s_node in src_nodes:\n",
    "        for t_node in target_nodes:\n",
    "            if t_node['node']['properties'][trgt_match]['datatype'] == 'list':\n",
    "                print(s_node['node'][src_match],t_node['node']['properties'][trgt_match]['data value'])\n",
    "                if s_node['node'][src_match] in t_node['node']['properties'][trgt_match]['data value']: \n",
    "                    edge_node = {\n",
    "                        \"edge\": {\n",
    "                            \"id\": len(property_graph[\"graph\"][\"edges\"]) + 1,\n",
    "                            #\"relationship\": mapping_config['schema-map']['edges'][edge_node]['relationship'],\n",
    "                            \"from_node_id\": s_node['node']['id'],\n",
    "                            \"to_node_id\": t_node['node']['id'],\n",
    "                            \"properties\": {}\n",
    "                        }\n",
    "                    }\n",
    "                    property_graph[\"graph\"][\"edges\"].append(edge_node)\n",
    "                \n",
    "            elif s_node['node'][src_match] == t_node['node']['properties'][trgt_match]['data value']:\n",
    "                edge_node = {\n",
    "                        \"edge\": {\n",
    "                            \"id\": len(property_graph[\"graph\"][\"edges\"]) + 1,\n",
    "                            #\"relationship\": mapping_config['schema-map']['edges'][edge_node]['relationship'],\n",
    "                            \"from_node_id\": s_node['node']['id'],\n",
    "                            \"to_node_id\": t_node['node']['id'],\n",
    "                            \"properties\": {}\n",
    "                        }\n",
    "                \n",
    "                }\n",
    "                property_graph[\"graph\"][\"edges\"].append(edge_node)\n",
    "               \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "89eb421d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'node': {'id': 'Joseph Julian Soria', 'label': 'People', 'properties': {'Age': {'datatype': 'numeric', 'data value': 52}, 'Gender': {'datatype': 'string', 'data value': 'Male'}, 'friends': {'datatype': 'list', 'data value': [3]}}}}\n"
     ]
    }
   ],
   "source": [
    "print(node)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "3d81d51c",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'nodes': [{'node': {'id': 'The Murder of Nicole Brown Simpson',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': \"The Murder of Nicole Brown Simpson is a 2019 American crime horror film directed by Daniel Farrands. The film is loosely based on the murder of Nicole Brown Simpson, presenting a version of events in which Brown Simpson is murdered by serial killer Glen Edward Rogers, and not by O. J. Simpson, her ex-husband and the primary suspect in the case. Though Mena Suvari's performance as Nicole Brown was praised, the film was panned by critics.\"},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/e/ed/The_Murder_of_Nicole_Brown_Simpson_poster.jpg'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 263},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 380},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Mena Suvari', 'Nick Stahl', 'Taryn Manning']}}}},\n",
       "  {'node': {'id': 'Bad Boys for Life',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': \"Bad Boys for Life is a 2020 American buddy cop action comedy film directed by Adil & Bilall. It is the sequel to Bad Boys II (2003) and the third installment in the Bad Boys franchise. Will Smith, Martin Lawrence, Joe Pantoliano and Theresa Randle reprise their roles in the film and are joined by Paola Núñez, Vanessa Hudgens, Jacob Scipio, Alexander Ludwig, Charles Melton, Kate del Castillo and Nicky Jam. The film was produced by Smith, Jerry Bruckheimer, and Doug Belgrad, with a screenplay written by Chris Bremner, Peter Craig and Joe Carnahan. In Bad Boys for Life, Miami detectives Mike Lowrey and Marcus Burnett investigate a string of murders tied to Lowrey's troubled past.\"},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/9/90/Bad_Boys_for_Life_poster.jpg'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 219},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 325},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Will Smith',\n",
       "       'Martin Lawrence',\n",
       "       'Vanessa Hudgens',\n",
       "       'Alexander Ludwig',\n",
       "       'Charles Melton',\n",
       "       'Paola Nunez',\n",
       "       'Kate del Castillo',\n",
       "       'Nicky Jam',\n",
       "       'Joe Pantoliano']}}}},\n",
       "  {'node': {'id': 'Dolittle',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': \"Dolittle is a 2020 American fantasy adventure film directed by Stephen Gaghan from a screenplay by Gaghan, Dan Gregor, and Doug Mand, based on a story by Thomas Shepherd. Dolittle is based on the title character created by Hugh Lofting and is primarily inspired by the author's second Doctor Dolittle book, The Voyages of Doctor Dolittle (1922). Robert Downey Jr. stars as the title character, alongside Antonio Banderas and Michael Sheen in live-action roles, with Emma Thompson, Rami Malek, John Cena, Kumail Nanjiani, Octavia Spencer, Tom Holland, Craig Robinson, Ralph Fiennes, Selena Gomez, and Marion Cotillard voicing an array of creatures.\"},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/1/1f/Dolittle_%282020_film_poster%29.png'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 220},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 326},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Robert Downey Jr.',\n",
       "       'Antonio Banderas',\n",
       "       'Michael Sheen',\n",
       "       'Emma Thompson',\n",
       "       'Rami Malek',\n",
       "       'John Cena',\n",
       "       'Kumail Nanjiani',\n",
       "       'Octavia Spencer',\n",
       "       'Tom Holland',\n",
       "       'Craig Robinson',\n",
       "       'Ralph Fiennes',\n",
       "       'Selena Gomez',\n",
       "       'Marion Cotillard']}}}},\n",
       "  {'node': {'id': 'A Fall from Grace',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': 'A Fall from Grace is a 2020 American thriller film produced, written, and directed by Tyler Perry and his first to be released by Netflix. The film follows a woman who finds a dangerous new love and the novice attorney who defends her in a sensational court case. This was the final film of actor Cicely Tyson before her death in January 2021.'},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/4/4e/AFallFromGrace.png'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 259},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 383},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Crystal R. Fox',\n",
       "       'Phylicia Rashad',\n",
       "       'Bresha Webb',\n",
       "       'Mehcad Brooks',\n",
       "       'Cicely Tyson',\n",
       "       'Tyler Perry']}}}},\n",
       "  {'node': {'id': 'The Gentlemen',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': 'The Gentlemen is a 2019 action comedy film written, directed and produced by Guy Ritchie, who developed the story along with Ivan Atkinson and Marn Davies. The film stars Matthew McConaughey, Charlie Hunnam, Henry Golding, Michelle Dockery, Jeremy Strong, Eddie Marsan, Colin Farrell, and Hugh Grant. It follows an American cannabis wholesaler in England who is looking to sell his business, setting off a chain of blackmail and schemes to undermine him.'},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/0/06/The_Gentlemen_poster.jpg'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 259},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 383},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Matthew McConaughey',\n",
       "       'Charlie Hunnam',\n",
       "       'Henry Golding',\n",
       "       'Michelle Dockery',\n",
       "       'Jeremy Strong',\n",
       "       'Eddie Marsan',\n",
       "       'Colin Farrell',\n",
       "       'Hugh Grant']}}}},\n",
       "  {'node': {'id': 'The Turning',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': 'The Turning is a 2020 American gothic supernatural horror film directed by Floria Sigismondi and written by Carey W. Hayes and Chad Hayes. It is a modern adaptation of the 1898 ghost story The Turn of the Screw by Henry James. It stars Mackenzie Davis, Finn Wolfhard, Brooklynn Prince, and Joely Richardson, and follows a young governess in 1994 who is hired to watch over two children after their parents are killed.'},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/a/a2/The_Turning_poster_2020.jpg'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 251},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 397},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Mackenzie Davis',\n",
       "       'Finn Wolfhard',\n",
       "       'Brooklynn Prince',\n",
       "       'Joely Richardson']}}}},\n",
       "  {'node': {'id': 'The Last Full Measure',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': \"The Last Full Measure is a 2019 American war drama film written and directed by Todd Robinson. It follows the efforts of fictional Pentagon staffer Scott Huffman and many veterans to see the Medal of Honor awarded to William H. Pitsenbarger, a United States Air Force Pararescueman who flew in helicopter rescue missions during the Vietnam War to aid downed soldiers and pilots. Based on true events, the film stars Sebastian Stan, Christopher Plummer, William Hurt, Ed Harris, Samuel L. Jackson, Jeremy Irvine, and Peter Fonda. It was the final film appearance of Fonda, who died before the film’s release; and Plummer's final on screen appearance before his death in 2021, though it had filmed prior to Knives Out which was released before it.\"},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/9/9d/The_Last_Full_Measure_2019_poster.jpg'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 256},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 378},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Sebastian Stan',\n",
       "       'Christopher Plummer',\n",
       "       'William Hurt',\n",
       "       'Ed Harris',\n",
       "       'Samuel L. Jackson',\n",
       "       'Peter Fonda',\n",
       "       'LisaGay Hamilton',\n",
       "       'Jeremy Irvine',\n",
       "       'Diane Ladd',\n",
       "       'Amy Madigan',\n",
       "       'John Savage',\n",
       "       'Bradley Whitford']}}}},\n",
       "  {'node': {'id': 'John Henry',\n",
       "    'label': 'Movies',\n",
       "    'properties': {'Extract': {'datatype': 'string',\n",
       "      'data value': 'John Henry is a 2020 American thriller drama film starring Terry Crews and Ludacris, and directed by Will Forbes. Inspired by the folk lore of John Henry, the plot follows an ex-gang member from Los Angeles who must help two immigrant children who are on the run from his former crime boss. The film had a limited release on January 24, 2020, and received negative reviews from critics.'},\n",
       "     'thumbnail_url': {'datatype': 'string',\n",
       "      'data value': 'https://upload.wikimedia.org/wikipedia/en/b/b8/JohnHenryPoster.jpeg'},\n",
       "     'thumbnail_width': {'datatype': 'string', 'data value': 220},\n",
       "     'thumbnail_height': {'datatype': 'string', 'data value': 316},\n",
       "     'Cast': {'datatype': 'list',\n",
       "      'data value': ['Terry Crews',\n",
       "       'Ludacris',\n",
       "       'Jamila Velazquez',\n",
       "       'Ken Foree',\n",
       "       'Tyler Alvarez',\n",
       "       'Joseph Julian Soria']}}}},\n",
       "  {'node': {'id': 'Mena Suvari',\n",
       "    'label': 'People',\n",
       "    'properties': {'Age': {'datatype': 'numeric', 'data value': 20},\n",
       "     'Gender': {'datatype': 'string', 'data value': 'Male'},\n",
       "     'friends': {'datatype': 'list', 'data value': [2, 3]}}}},\n",
       "  {'node': {'id': 'Terry Crews',\n",
       "    'label': 'People',\n",
       "    'properties': {'Age': {'datatype': 'numeric', 'data value': 25},\n",
       "     'Gender': {'datatype': 'string', 'data value': 'Female'},\n",
       "     'friends': {'datatype': 'list', 'data value': [1]}}}},\n",
       "  {'node': {'id': 'Ludacris',\n",
       "    'label': 'People',\n",
       "    'properties': {'Age': {'datatype': 'numeric', 'data value': 22},\n",
       "     'Gender': {'datatype': 'string', 'data value': 'Male'},\n",
       "     'friends': {'datatype': 'list', 'data value': [1, 4]}}}},\n",
       "  {'node': {'id': 'Joseph Julian Soria',\n",
       "    'label': 'People',\n",
       "    'properties': {'Age': {'datatype': 'numeric', 'data value': 52},\n",
       "     'Gender': {'datatype': 'string', 'data value': 'Male'},\n",
       "     'friends': {'datatype': 'list', 'data value': [3]}}}}],\n",
       " 'edges': [{'edge': {'id': 1,\n",
       "    'from_node_id': 'Mena Suvari',\n",
       "    'to_node_id': 'The Murder of Nicole Brown Simpson',\n",
       "    'properties': {}}},\n",
       "  {'edge': {'id': 2,\n",
       "    'from_node_id': 'Terry Crews',\n",
       "    'to_node_id': 'John Henry',\n",
       "    'properties': {}}},\n",
       "  {'edge': {'id': 3,\n",
       "    'from_node_id': 'Ludacris',\n",
       "    'to_node_id': 'John Henry',\n",
       "    'properties': {}}},\n",
       "  {'edge': {'id': 4,\n",
       "    'from_node_id': 'Joseph Julian Soria',\n",
       "    'to_node_id': 'John Henry',\n",
       "    'properties': {}}}]}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "property_graph['graph']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f1538856",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}