Req_Str_Beh_Decomposition_Recipe.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "3ee4834f",
   "metadata": {},
   "source": [
    "# Initializing the SysML v2 API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6b5fef59",
   "metadata": {},
   "outputs": [],
   "source": [
    "from __future__ import print_function\n",
    "\n",
    "import time\n",
    "import requests\n",
    "from pprint import pprint\n",
    "import pandas as pd\n",
    "import json\n",
    "\n",
    "#host = \"<SysML2-API-Repo-Host:Port>\"\n",
    "host = \"Specify the URL of the SysML v2 API and Service Repository\""
   ]
  },
  {
   "cell_type": "markdown",
   "id": "04c1ff93",
   "metadata": {},
   "source": [
    "# Get projects"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "78788ed9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Project Name</th>\n",
       "      <th>Project ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Spacecraft project with Element CRUD - 2022-09...</td>\n",
       "      <td>0659c128-afd5-42a1-912b-962068f1f053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17b-Sequence-Modeling Fri Sep 09 17:37:26 EDT ...</td>\n",
       "      <td>0f7045bd-9a1c-4b54-90d9-775c0f642e1b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3a-Function-based Behavior-2 Fri Sep 09 17:26:...</td>\n",
       "      <td>128710cd-978f-4c6f-93ac-8afbbd194185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10c-Fuel Economy Analysis Fri Sep 09 17:30:43 ...</td>\n",
       "      <td>2909d482-a659-4307-9803-bdfcbe0a7989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PartTest Fri Sep 09 17:22:13 EDT 2022</td>\n",
       "      <td>2a2a4d7d-cd9e-41ec-bec0-2bf6fcea6767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>15_05-Unification of Expression and Constraint...</td>\n",
       "      <td>39dcf070-668c-4711-a231-c2640b9f7f88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>15_19-Materials with Properties Fri Sep 09 17:...</td>\n",
       "      <td>3bd937e0-ab2e-47a6-8f66-0458df9f29de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Spacecraft project with branches and tags - 20...</td>\n",
       "      <td>3c293f80-a0aa-46a5-8cde-25a31ec697e0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3a-Function-based Behavior-1 Wed Sep 21 11:44:...</td>\n",
       "      <td>413e8b6e-a4c7-483e-a212-eb25e7c47aff</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>14b-Language Extensions Fri Sep 09 17:35:06 ED...</td>\n",
       "      <td>431cd401-010c-401f-9101-115240312d24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>13b-Safety and Security Features Element Group...</td>\n",
       "      <td>46b226ce-8519-42de-96b4-07ff1045d0dd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Spacecraft project with Element CRUD - 2022-09...</td>\n",
       "      <td>4853c38b-85c5-40e5-9e83-b69c2e73415a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3a-Function-based Behavior-3 Fri Sep 09 17:26:...</td>\n",
       "      <td>48f9a623-2451-4150-8b98-58e3b3c515cd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>12a-Dependency Fri Sep 09 17:32:29 EDT 2022</td>\n",
       "      <td>49a60e69-b509-4191-b1c3-240de628110b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4a-Functional Allocation Wed Sep 21 11:45:43 E...</td>\n",
       "      <td>4f6c6172-ab0c-4572-b549-6b7da7e9e5fb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7b-Variant Configurations Fri Sep 09 17:28:59 ...</td>\n",
       "      <td>59c86238-ef81-434e-a389-5393312ba0d7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1c-Parts Tree Redefinition Wed Sep 21 11:43:30...</td>\n",
       "      <td>5b5474b6-68b8-43bf-b0f6-7d455bffa63d</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17a-Sequence-Modeling Fri Sep 09 17:37:07 EDT ...</td>\n",
       "      <td>653c5173-770d-4ea6-90dc-c173d049258c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>13a-Model Containment Fri Sep 09 17:33:03 EDT ...</td>\n",
       "      <td>6699f5e0-403b-414a-87c9-46671e702fab</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Spacecraft project with Element CRUD - 2022-09...</td>\n",
       "      <td>77dd61e8-456a-425b-ac05-385bf6c20161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11b-Safety and Security Feature Views Fri Sep ...</td>\n",
       "      <td>84f30a8f-f839-4a71-aee9-dff2a2d28dbf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1c-Parts Tree Redefinition Fri Sep 09 17:25:05...</td>\n",
       "      <td>85d874ae-1f68-4949-9b16-378f1cbc477e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2a-Parts Interconnection Wed Sep 21 11:43:57 E...</td>\n",
       "      <td>887e0281-066f-4667-a67b-d50e886d031c</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>14a-Language Extensions Fri Sep 09 17:34:49 ED...</td>\n",
       "      <td>8f0bc3b3-a580-40fd-b99b-0e8865984c4f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6-Individual and Snapshots Fri Sep 09 17:28:35...</td>\n",
       "      <td>913dab3f-4d5d-482d-9238-7491aead3e1a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PartTest Fri Sep 09 17:21:50 EDT 2022</td>\n",
       "      <td>91b2be09-16de-4d35-87a4-589f3274ce55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>11a-View-Viewpoint Fri Sep 09 17:31:42 EDT 2022</td>\n",
       "      <td>91fd6db5-4cfa-4970-b115-05010053ec72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>13b-Safety and Security Features Element Group...</td>\n",
       "      <td>95bfcea3-8ed7-4bd4-9e98-3d6ed311091e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Spacecraft project with branches and tags - 20...</td>\n",
       "      <td>978d0199-4e44-4090-8cb6-4253fd79e315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3a-Function-based Behavior-1 Fri Sep 09 17:26:...</td>\n",
       "      <td>9da34b47-38d0-4630-bcb4-c387d5fac1da</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>sysml Fri Sep 16 14:36:21 EDT 2022</td>\n",
       "      <td>9f7efdc8-e6d1-4cf4-a132-532e2f136e7f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>9-Verification-simplified Fri Sep 09 17:29:54 ...</td>\n",
       "      <td>a9a02019-b810-4fcb-9a9c-5cad061db29f</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>10b-Trade-off Among Alternative Configurations...</td>\n",
       "      <td>ada6b9b6-3534-43b3-a567-f97092ac26f1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>12b-Allocation Fri Sep 09 17:32:45 EDT 2022</td>\n",
       "      <td>b4c01f6d-8173-4d43-abd1-596bdb89d6d4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Spacecraft project with Element CRUD - 2022-09...</td>\n",
       "      <td>b67ebee6-b55e-4088-b059-c2f102989ac2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>8-Requirements Fri Sep 09 17:29:27 EDT 2022</td>\n",
       "      <td>b6a3450b-8624-45c2-8dd9-68d301a439fe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>15_10-Primitive Data Types Fri Sep 09 17:36:20...</td>\n",
       "      <td>bb65a453-67bc-4e6c-92c7-29734c80bab1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>sysml Fri Sep 16 14:49:18 EDT 2022</td>\n",
       "      <td>c60d5b4d-5f36-4083-ae1a-e61ed2be0e78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2a-Parts Interconnection Fri Sep 09 17:23:32 E...</td>\n",
       "      <td>c64923aa-79f4-419c-b983-6244fee741d6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5-State-based Behavior-1 Fri Sep 09 17:27:37 E...</td>\n",
       "      <td>c6b1d4d6-a66e-4097-8752-5307ecd9ebaf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2a-Parts Interconnection Fri Sep 09 17:25:35 E...</td>\n",
       "      <td>cb4e467e-772b-4054-849e-26e4b0e1e0c0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>10d-Dynamics Analysis Fri Sep 09 17:31:13 EDT ...</td>\n",
       "      <td>cceed28a-64fb-4401-81da-afcadd96d1d6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>13b-Safety and Security Features Element Group...</td>\n",
       "      <td>d4c21bc8-6778-4a97-b389-48b1e7b23260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>5-State-based Behavior-1a Fri Sep 09 17:28:06 ...</td>\n",
       "      <td>d63b8882-f41e-40ef-a4a2-cf74fa47f6dc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>14c-Language Extensions Fri Sep 09 17:35:25 ED...</td>\n",
       "      <td>da4e65b6-460d-447b-8cf9-56a3ad44e514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>3a-Function-based Behavior-2 Wed Sep 21 11:44:...</td>\n",
       "      <td>e27d992a-91e6-450a-b6f6-b79196ebeeb9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>3a-Function-based Behavior-3 Wed Sep 21 11:45:...</td>\n",
       "      <td>e4966bc8-bd9f-4c63-a43d-2c21fe512d31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>4a-Functional Allocation Fri Sep 09 17:27:13 E...</td>\n",
       "      <td>e7090e9d-74f0-4b63-a4a6-6dd8647b5bdd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Spacecraft project with Element CRUD - 2022-09...</td>\n",
       "      <td>f0594c9c-55ef-49f6-9591-d27d12cc0afb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Spacecraft project with Element CRUD - 2022-09...</td>\n",
       "      <td>f8161e56-586e-44ae-ab12-53ad1fc972de</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>18-Use Case Fri Sep 09 17:37:44 EDT 2022</td>\n",
       "      <td>ff0dfcc3-cf11-4d4f-961a-ae42326f6b12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Project Name  \\\n",
       "0   Spacecraft project with Element CRUD - 2022-09...   \n",
       "1   17b-Sequence-Modeling Fri Sep 09 17:37:26 EDT ...   \n",
       "2   3a-Function-based Behavior-2 Fri Sep 09 17:26:...   \n",
       "3   10c-Fuel Economy Analysis Fri Sep 09 17:30:43 ...   \n",
       "4               PartTest Fri Sep 09 17:22:13 EDT 2022   \n",
       "5   15_05-Unification of Expression and Constraint...   \n",
       "6   15_19-Materials with Properties Fri Sep 09 17:...   \n",
       "7   Spacecraft project with branches and tags - 20...   \n",
       "8   3a-Function-based Behavior-1 Wed Sep 21 11:44:...   \n",
       "9   14b-Language Extensions Fri Sep 09 17:35:06 ED...   \n",
       "10  13b-Safety and Security Features Element Group...   \n",
       "11  Spacecraft project with Element CRUD - 2022-09...   \n",
       "12  3a-Function-based Behavior-3 Fri Sep 09 17:26:...   \n",
       "13        12a-Dependency Fri Sep 09 17:32:29 EDT 2022   \n",
       "14  4a-Functional Allocation Wed Sep 21 11:45:43 E...   \n",
       "15  7b-Variant Configurations Fri Sep 09 17:28:59 ...   \n",
       "16  1c-Parts Tree Redefinition Wed Sep 21 11:43:30...   \n",
       "17  17a-Sequence-Modeling Fri Sep 09 17:37:07 EDT ...   \n",
       "18  13a-Model Containment Fri Sep 09 17:33:03 EDT ...   \n",
       "19  Spacecraft project with Element CRUD - 2022-09...   \n",
       "20  11b-Safety and Security Feature Views Fri Sep ...   \n",
       "21  1c-Parts Tree Redefinition Fri Sep 09 17:25:05...   \n",
       "22  2a-Parts Interconnection Wed Sep 21 11:43:57 E...   \n",
       "23  14a-Language Extensions Fri Sep 09 17:34:49 ED...   \n",
       "24  6-Individual and Snapshots Fri Sep 09 17:28:35...   \n",
       "25              PartTest Fri Sep 09 17:21:50 EDT 2022   \n",
       "26    11a-View-Viewpoint Fri Sep 09 17:31:42 EDT 2022   \n",
       "27  13b-Safety and Security Features Element Group...   \n",
       "28  Spacecraft project with branches and tags - 20...   \n",
       "29  3a-Function-based Behavior-1 Fri Sep 09 17:26:...   \n",
       "30                 sysml Fri Sep 16 14:36:21 EDT 2022   \n",
       "31  9-Verification-simplified Fri Sep 09 17:29:54 ...   \n",
       "32  10b-Trade-off Among Alternative Configurations...   \n",
       "33        12b-Allocation Fri Sep 09 17:32:45 EDT 2022   \n",
       "34  Spacecraft project with Element CRUD - 2022-09...   \n",
       "35        8-Requirements Fri Sep 09 17:29:27 EDT 2022   \n",
       "36  15_10-Primitive Data Types Fri Sep 09 17:36:20...   \n",
       "37                 sysml Fri Sep 16 14:49:18 EDT 2022   \n",
       "38  2a-Parts Interconnection Fri Sep 09 17:23:32 E...   \n",
       "39  5-State-based Behavior-1 Fri Sep 09 17:27:37 E...   \n",
       "40  2a-Parts Interconnection Fri Sep 09 17:25:35 E...   \n",
       "41  10d-Dynamics Analysis Fri Sep 09 17:31:13 EDT ...   \n",
       "42  13b-Safety and Security Features Element Group...   \n",
       "43  5-State-based Behavior-1a Fri Sep 09 17:28:06 ...   \n",
       "44  14c-Language Extensions Fri Sep 09 17:35:25 ED...   \n",
       "45  3a-Function-based Behavior-2 Wed Sep 21 11:44:...   \n",
       "46  3a-Function-based Behavior-3 Wed Sep 21 11:45:...   \n",
       "47  4a-Functional Allocation Fri Sep 09 17:27:13 E...   \n",
       "48  Spacecraft project with Element CRUD - 2022-09...   \n",
       "49  Spacecraft project with Element CRUD - 2022-09...   \n",
       "50           18-Use Case Fri Sep 09 17:37:44 EDT 2022   \n",
       "\n",
       "                              Project ID  \n",
       "0   0659c128-afd5-42a1-912b-962068f1f053  \n",
       "1   0f7045bd-9a1c-4b54-90d9-775c0f642e1b  \n",
       "2   128710cd-978f-4c6f-93ac-8afbbd194185  \n",
       "3   2909d482-a659-4307-9803-bdfcbe0a7989  \n",
       "4   2a2a4d7d-cd9e-41ec-bec0-2bf6fcea6767  \n",
       "5   39dcf070-668c-4711-a231-c2640b9f7f88  \n",
       "6   3bd937e0-ab2e-47a6-8f66-0458df9f29de  \n",
       "7   3c293f80-a0aa-46a5-8cde-25a31ec697e0  \n",
       "8   413e8b6e-a4c7-483e-a212-eb25e7c47aff  \n",
       "9   431cd401-010c-401f-9101-115240312d24  \n",
       "10  46b226ce-8519-42de-96b4-07ff1045d0dd  \n",
       "11  4853c38b-85c5-40e5-9e83-b69c2e73415a  \n",
       "12  48f9a623-2451-4150-8b98-58e3b3c515cd  \n",
       "13  49a60e69-b509-4191-b1c3-240de628110b  \n",
       "14  4f6c6172-ab0c-4572-b549-6b7da7e9e5fb  \n",
       "15  59c86238-ef81-434e-a389-5393312ba0d7  \n",
       "16  5b5474b6-68b8-43bf-b0f6-7d455bffa63d  \n",
       "17  653c5173-770d-4ea6-90dc-c173d049258c  \n",
       "18  6699f5e0-403b-414a-87c9-46671e702fab  \n",
       "19  77dd61e8-456a-425b-ac05-385bf6c20161  \n",
       "20  84f30a8f-f839-4a71-aee9-dff2a2d28dbf  \n",
       "21  85d874ae-1f68-4949-9b16-378f1cbc477e  \n",
       "22  887e0281-066f-4667-a67b-d50e886d031c  \n",
       "23  8f0bc3b3-a580-40fd-b99b-0e8865984c4f  \n",
       "24  913dab3f-4d5d-482d-9238-7491aead3e1a  \n",
       "25  91b2be09-16de-4d35-87a4-589f3274ce55  \n",
       "26  91fd6db5-4cfa-4970-b115-05010053ec72  \n",
       "27  95bfcea3-8ed7-4bd4-9e98-3d6ed311091e  \n",
       "28  978d0199-4e44-4090-8cb6-4253fd79e315  \n",
       "29  9da34b47-38d0-4630-bcb4-c387d5fac1da  \n",
       "30  9f7efdc8-e6d1-4cf4-a132-532e2f136e7f  \n",
       "31  a9a02019-b810-4fcb-9a9c-5cad061db29f  \n",
       "32  ada6b9b6-3534-43b3-a567-f97092ac26f1  \n",
       "33  b4c01f6d-8173-4d43-abd1-596bdb89d6d4  \n",
       "34  b67ebee6-b55e-4088-b059-c2f102989ac2  \n",
       "35  b6a3450b-8624-45c2-8dd9-68d301a439fe  \n",
       "36  bb65a453-67bc-4e6c-92c7-29734c80bab1  \n",
       "37  c60d5b4d-5f36-4083-ae1a-e61ed2be0e78  \n",
       "38  c64923aa-79f4-419c-b983-6244fee741d6  \n",
       "39  c6b1d4d6-a66e-4097-8752-5307ecd9ebaf  \n",
       "40  cb4e467e-772b-4054-849e-26e4b0e1e0c0  \n",
       "41  cceed28a-64fb-4401-81da-afcadd96d1d6  \n",
       "42  d4c21bc8-6778-4a97-b389-48b1e7b23260  \n",
       "43  d63b8882-f41e-40ef-a4a2-cf74fa47f6dc  \n",
       "44  da4e65b6-460d-447b-8cf9-56a3ad44e514  \n",
       "45  e27d992a-91e6-450a-b6f6-b79196ebeeb9  \n",
       "46  e4966bc8-bd9f-4c63-a43d-2c21fe512d31  \n",
       "47  e7090e9d-74f0-4b63-a4a6-6dd8647b5bdd  \n",
       "48  f0594c9c-55ef-49f6-9591-d27d12cc0afb  \n",
       "49  f8161e56-586e-44ae-ab12-53ad1fc972de  \n",
       "50  ff0dfcc3-cf11-4d4f-961a-ae42326f6b12  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "projects_url = f\"{host}/projects\" \n",
    "projects_response = requests.get(projects_url)\n",
    "\n",
    "if projects_response.status_code == 200:\n",
    "    projects = projects_response.json()\n",
    "    \n",
    "    df = pd.DataFrame({'Project Name':[], 'Project ID':[]})\n",
    "    for p in projects:\n",
    "        df = pd.concat([df, pd.DataFrame({'Project Name':[p['name']], 'Project ID':[p['@id']]})], ignore_index=True)\n",
    "    display(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d815e4fe",
   "metadata": {},
   "source": [
    "# Define a function to recursively iterate over feature members \n",
    "## Recursive graph traversal using FeatureMembership relations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "24ec6146",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_member_features(project_id, commit_id, element_id, member_type, indent):\n",
    "    \n",
    "    # Fetch the element\n",
    "    element_url = f\"{host}/projects/{project_id}/commits/{commit_id}/elements/{element_id}\" \n",
    "    response = requests.get(element_url)\n",
    "    \n",
    "    element_data = response.json()\n",
    "    element_name = element_data['name']\n",
    "    element_id = element_data['@id']\n",
    "    element_type = element_data ['@type']\n",
    "    \n",
    "    if element_type == member_type:\n",
    "        print(f\"{indent} - {element_name} (id = {element_id}, type = {element_type})\")\n",
    "        # Feature memberships\n",
    "        element_features = element_data['feature']\n",
    "        if len(element_features) > 0:\n",
    "            for feature in element_features:\n",
    "                get_member_features(project_id, commit_id, feature['@id'], member_type, indent + \"  \")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2aff54c2",
   "metadata": {},
   "source": [
    "# Parts tree navigation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "482ddfe4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'@id': '3fed527b-cd9f-4e7c-a0f3-360b8f02085d',\n",
      "  '@type': 'Commit',\n",
      "  'owningProject': {'@id': '85d874ae-1f68-4949-9b16-378f1cbc477e'},\n",
      "  'previousCommit': None,\n",
      "  'timestamp': '2022-09-09T17:24:55.229447-04:00'}]\n"
     ]
    }
   ],
   "source": [
    "parts_tree_project_id = '85d874ae-1f68-4949-9b16-378f1cbc477e'\n",
    "parts_tree_commit_id = ''\n",
    "\n",
    "commits_url = f\"{host}/projects/{parts_tree_project_id}/commits\" \n",
    "commits_response = requests.get(commits_url)\n",
    "if commits_response.status_code == 200:\n",
    "    commits = commits_response.json()\n",
    "    pprint(commits)\n",
    "    parts_tree_commit_id = commits[0]['@id']\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "487c0624",
   "metadata": {},
   "source": [
    "## Query to find vehicle1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "3d724e27",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'@id': 'b4f3d464-1319-45ee-a779-82d1b2252c3a',\n",
      "  '@type': 'PartUsage',\n",
      "  'name': 'vehicle1',\n",
      "  'owner': {'@id': 'ff4e8415-ed73-491d-8b7a-797caadcdf54'}}]\n"
     ]
    }
   ],
   "source": [
    "# Query vehicle1 (PartUsage) in the \n",
    "data = {\n",
    "  '@type':'Query',\n",
    "  'select': ['name','@id','@type','owner'],\n",
    "  'where': {\n",
    "    '@type': 'CompositeConstraint',\n",
    "    'operator': 'and',\n",
    "    'constraint': [\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': 'name',\n",
    "            'value': 'vehicle1'\n",
    "        },\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': '@type',\n",
    "            'value': 'PartUsage'\n",
    "        }\n",
    "    ]\n",
    "  }\n",
    "}\n",
    "\n",
    "payload = json.dumps(data)\n",
    "\n",
    "vehicle1_id = ''\n",
    "query_url = f\"{host}/projects/{parts_tree_project_id}/query-results\" \n",
    "\n",
    "query_response = requests.post(query_url, json=data)\n",
    "\n",
    "if query_response.status_code == 200:\n",
    "    query_response_json = query_response.json()\n",
    "    pprint(query_response_json)\n",
    "    vehicle1_id = query_response_json[0]['@id']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0092a660",
   "metadata": {},
   "source": [
    "## Parts tree for vehicle1 (recursive FeatureMembership relation navigation)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "406504bf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  - vehicle1 (id = b4f3d464-1319-45ee-a779-82d1b2252c3a, type = PartUsage)\n",
      "    - frontAxleAssembly (id = b7011eae-20bd-4cb6-b3e4-ead27a509f47, type = PartUsage)\n",
      "      - frontAxle (id = 0974ffce-137c-443b-a187-c6a049d2f2b3, type = PartUsage)\n",
      "      - frontWheel (id = 08e6ee25-0118-4b14-b4f6-7e728401fad3, type = PartUsage)\n",
      "    - rearAxleAssembly (id = 62e9d93a-aa5a-4a3c-ac22-22cea9f2db3a, type = PartUsage)\n",
      "      - rearAxle (id = b72abb4c-11a3-428a-85ea-a9457f429989, type = PartUsage)\n",
      "      - rearWheel (id = 9d35829f-eb02-46b1-a284-cab4c77ad529, type = PartUsage)\n"
     ]
    }
   ],
   "source": [
    "get_member_features(parts_tree_project_id,parts_tree_commit_id,vehicle1_id,'PartUsage',\" \")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eba630b9",
   "metadata": {},
   "source": [
    "## Query to find vehicle1_c1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "5c13178f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'@id': 'c0b96198-597c-489f-a026-bdac2c13444b',\n",
      "  '@type': 'PartUsage',\n",
      "  'name': 'vehicle1_c1',\n",
      "  'owner': {'@id': 'ff4e8415-ed73-491d-8b7a-797caadcdf54'}}]\n"
     ]
    }
   ],
   "source": [
    "\n",
    "data = {\n",
    "  '@type':'Query',\n",
    "  'select': ['name','@id','@type','owner'],\n",
    "  'where': {\n",
    "    '@type': 'CompositeConstraint',\n",
    "    'operator': 'and',\n",
    "    'constraint': [\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': 'name',\n",
    "            'value': 'vehicle1_c1'\n",
    "        },\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': '@type',\n",
    "            'value': 'PartUsage'\n",
    "        }\n",
    "    ]\n",
    "  }\n",
    "}\n",
    "payload = json.dumps(data)\n",
    "\n",
    "vehicle1_c1_id = ''\n",
    "query_url = f\"{host}/projects/{parts_tree_project_id}/query-results\" \n",
    "\n",
    "query_response = requests.post(query_url, json=data)\n",
    "\n",
    "if query_response.status_code == 200:\n",
    "    query_response_json = query_response.json()\n",
    "    pprint(query_response_json)\n",
    "    vehicle1_c1_id = query_response_json[0]['@id']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "10b45dd4",
   "metadata": {},
   "source": [
    "## Parts tree for vehicle1_c1 (recursive FeatureMembership relation navigation)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "1dbfe8f6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  - vehicle1_c1 (id = c0b96198-597c-489f-a026-bdac2c13444b, type = PartUsage)\n",
      "    - frontAxleAssembly_c1 (id = c85cf569-e305-4c9d-8503-f65aaa11e56c, type = PartUsage)\n",
      "      - frontAxle_c1 (id = 6ae2d0f5-3ad5-4413-8939-e1488d520644, type = PartUsage)\n",
      "      - frontWheel_1 (id = 6da39a5b-74f4-4bb4-b56a-3ec60a455e69, type = PartUsage)\n",
      "      - frontWheel_2 (id = d151d807-fe16-40e7-833b-d0985470aa88, type = PartUsage)\n",
      "      - frontWheel (id = 08e6ee25-0118-4b14-b4f6-7e728401fad3, type = PartUsage)\n",
      "    - rearAxleAssembly_c1 (id = 8f4829e8-49af-4802-9435-44145e61b533, type = PartUsage)\n",
      "      - rearAxle_c1 (id = 92a3c5e6-1652-4365-8383-28b79958c974, type = PartUsage)\n",
      "      - rearWheel_1 (id = 21c018fe-a614-4089-9ee8-348af9f550c0, type = PartUsage)\n",
      "      - rearWheel_2 (id = 090eafcd-7970-404f-8c81-d36403d558ca, type = PartUsage)\n",
      "      - rearWheel (id = 9d35829f-eb02-46b1-a284-cab4c77ad529, type = PartUsage)\n"
     ]
    }
   ],
   "source": [
    "get_member_features(parts_tree_project_id,parts_tree_commit_id,vehicle1_c1_id,'PartUsage',\" \")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b7319e39",
   "metadata": {},
   "source": [
    "# Behavior Tree Navigation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "c9c96cbe",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'@id': 'f934f9e3-8686-4e81-9918-66ab72394e8f',\n",
      "  '@type': 'Commit',\n",
      "  'owningProject': {'@id': '128710cd-978f-4c6f-93ac-8afbbd194185'},\n",
      "  'previousCommit': None,\n",
      "  'timestamp': '2022-09-09T17:26:11.688211-04:00'}]\n"
     ]
    }
   ],
   "source": [
    "behavior_project_id = '128710cd-978f-4c6f-93ac-8afbbd194185'\n",
    "behavior_project_commit_id = ''\n",
    "\n",
    "commits_url = f\"{host}/projects/{behavior_project_id}/commits\" \n",
    "commits_response = requests.get(commits_url)\n",
    "if commits_response.status_code == 200:\n",
    "    commits = commits_response.json()\n",
    "    pprint(commits)\n",
    "    behavior_project_commit_id = commits[0]['@id']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5d7c309e",
   "metadata": {},
   "source": [
    "## Query to find Provide Power behavior (ActionUsage)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "d5a63113",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'@id': '2619c029-185a-456f-9ea9-12b94171e1b1',\n",
      "  '@type': 'ActionUsage',\n",
      "  'name': 'provide power',\n",
      "  'owner': {'@id': '9a44fd3f-9173-418a-8f61-f01ec86a2fd7'}}]\n"
     ]
    }
   ],
   "source": [
    "data = {\n",
    "  '@type':'Query',\n",
    "  'select': ['name','@id','@type','owner'],\n",
    "  'where': {\n",
    "    '@type': 'CompositeConstraint',\n",
    "    'operator': 'and',\n",
    "    'constraint': [\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': 'name',\n",
    "            'value': 'provide power'\n",
    "        },\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': '@type',\n",
    "            'value': 'ActionUsage'\n",
    "        }\n",
    "    ]\n",
    "  }\n",
    "}\n",
    "\n",
    "payload = json.dumps(data)\n",
    "\n",
    "provide_power_id = ''\n",
    "query_url = f\"{host}/projects/{behavior_project_id}/query-results\" \n",
    "\n",
    "query_response = requests.post(query_url, json=data)\n",
    "\n",
    "if query_response.status_code == 200:\n",
    "    query_response_json = query_response.json()\n",
    "    pprint(query_response_json)\n",
    "    provide_power_id = query_response_json[0]['@id']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "10018cd0",
   "metadata": {},
   "source": [
    "## Behavior tree for vehicle1 (recursive FeatureMembership relation navigation)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "91193b07",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  - provide power (id = 2619c029-185a-456f-9ea9-12b94171e1b1, type = ActionUsage)\n",
      "    - generate torque (id = 5a353b3d-6b09-40b4-b86c-24a2eb5bbccc, type = ActionUsage)\n",
      "    - amplify torque (id = aa7783bb-641c-4860-9f5e-399b693bc918, type = ActionUsage)\n",
      "    - transfer torque (id = 4abcd2c6-a7a6-4b3e-9e07-19faea837303, type = ActionUsage)\n",
      "    - distribute torque (id = 72cf307d-af84-477a-8cb5-34f58b3d1952, type = ActionUsage)\n",
      "    - start (id = ac7a1de9-82ed-4e08-bcc5-361ec1aa5365, type = ActionUsage)\n"
     ]
    }
   ],
   "source": [
    "get_member_features(behavior_project_id, behavior_project_commit_id, provide_power_id,\"ActionUsage\",\" \")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a07cc348",
   "metadata": {},
   "source": [
    "# Requirement tree for vehicle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "89840b26",
   "metadata": {},
   "outputs": [],
   "source": [
    "simple_vehicle_model_project = '8b377f03-9f29-4ae9-b60b-d266dc4a8180'\n",
    "vehicle_commit = '10f84681-3d17-43be-b59a-89c480d1abeb'\n",
    "host = \"http://sysml2-sst.intercax.com:9000\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "5fa94a05-c45e-4d93-a145-7e5967a87cd9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'@id': 'e397abe0-85b1-46df-87b8-69128a583c7c',\n",
      "  '@type': 'RequirementUsage',\n",
      "  'name': 'vehicleSpecification',\n",
      "  'owner': None}]\n"
     ]
    }
   ],
   "source": [
    "data = {\n",
    "  '@type':'Query',\n",
    "  'select': ['name','@id','@type','owner'],\n",
    "  'where': {\n",
    "    '@type': 'CompositeConstraint',\n",
    "    'operator': 'and',\n",
    "    'constraint': [\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': 'name',\n",
    "            'value': 'vehicleSpecification'\n",
    "        },\n",
    "        {\n",
    "            '@type': 'PrimitiveConstraint',\n",
    "            'inverse': False,\n",
    "            'operator': '=',\n",
    "            'property': '@type',\n",
    "            'value': 'RequirementUsage'\n",
    "        }\n",
    "    ]\n",
    "  }\n",
    "}\n",
    "\n",
    "payload = json.dumps(data)\n",
    "\n",
    "vehicle_specification_id = ''\n",
    "query_url = f\"{host}/projects/{simple_vehicle_model_project}/query-results\" \n",
    "\n",
    "query_response = requests.post(query_url, json=data)\n",
    "\n",
    "if query_response.status_code == 200:\n",
    "    query_response_json = query_response.json()\n",
    "    pprint(query_response_json)\n",
    "    vehicle_specification_id = query_response_json[0]['@id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "bd2276aa",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  - vehicleSpecification (id = e397abe0-85b1-46df-87b8-69128a583c7c, type = RequirementUsage)\n",
      "    - vehicleMassRequirement (id = 9e144d15-af6c-4113-861f-29376923ee94, type = RequirementUsage)\n",
      "    - vehicleFuelEconomyRequirements (id = 11aa2bdc-43f9-4576-aae5-7f8d679a0d8f, type = RequirementUsage)\n",
      "      - cityFuelEconomyRequirement (id = 0e37be64-b3bd-4f24-b5c5-156b17eb0c90, type = RequirementUsage)\n",
      "      - highwayFuelEconomyRequirement (id = 8163dc3d-7145-470d-80f4-64dd67317a43, type = RequirementUsage)\n"
     ]
    }
   ],
   "source": [
    "get_member_features(simple_vehicle_model_project, vehicle_commit, vehicle_specification_id,\"RequirementUsage\",\" \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ee934c22-4fb4-4409-804d-91010d3cebab",
   "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.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}