02-geocoding.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Geocoding em Python\n",
    "\n",
    "Vamos experimentar determinar as coordenadas de um sítio a partir da morada."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# !pip install geocoder\n",
    "\n",
    "import geocoder\n",
    "import pandas as pd\n",
    "import folium"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "location = \"Praça Coronel Pacheco, Porto, Portugal\"\n",
    "\n",
    "g = geocoder.google(location)\n",
    "g.latlng"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[41.151237300000005, -8.61501626564905]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# outro provider, que o Google é limitado\n",
    "\n",
    "g = geocoder.komoot(location)\n",
    "g.latlng"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>nome</th>\n",
       "      <th>morada</th>\n",
       "      <th>país</th>\n",
       "      <th>localidade</th>\n",
       "      <th>codigo_postal</th>\n",
       "      <th>data_abertura</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Honorato Clérigos</td>\n",
       "      <td>Rua Cândido dos Reis, 12</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-151</td>\n",
       "      <td>2016-08-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prégar</td>\n",
       "      <td>Largo de São Domingos, 96</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-253</td>\n",
       "      <td>2016-07-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nook Hamburgaria Pregaria</td>\n",
       "      <td>Rua São João Brito 32</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-06-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alta Burguesia</td>\n",
       "      <td>Rua da Restauração, 1</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>De Gema</td>\n",
       "      <td>Rua do Almada, 253</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-038</td>\n",
       "      <td>2016-03-21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        nome                     morada      país localidade  \\\n",
       "0          Honorato Clérigos   Rua Cândido dos Reis, 12  Portugal      Porto   \n",
       "1                     Prégar  Largo de São Domingos, 96  Portugal      Porto   \n",
       "2  Nook Hamburgaria Pregaria      Rua São João Brito 32  Portugal      Porto   \n",
       "3             Alta Burguesia      Rua da Restauração, 1  Portugal      Porto   \n",
       "4                    De Gema        Rua do Almada, 253   Portugal      Porto   \n",
       "\n",
       "  codigo_postal data_abertura  \n",
       "0      4050-151    2016-08-04  \n",
       "1      4050-253    2016-07-30  \n",
       "2           NaN    2016-06-01  \n",
       "3           NaN    2016-04-21  \n",
       "4      4050-038    2016-03-21  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('data/hamburguerias_porto.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rua Cândido dos Reis, 12, Porto, Portugal -> [41.1473924, -8.6137725]\n",
      "Largo de São Domingos, 96, Porto, Portugal -> [41.1431111, -8.614765510487807]\n",
      "Rua São João Brito 32, Porto, Portugal -> [41.3428814, -8.5432602]\n",
      "Rua da Restauração, 1, Porto, Portugal -> [41.1945048, -8.5759202]\n",
      "Rua do Almada, 253 , Porto, Portugal -> [41.155516, -8.6191649]\n",
      "Via do Castelo do Queijo, 395, Porto, Portugal -> None\n",
      "Rua Amândio Galhano, 51, Porto, Portugal -> [41.1829043, -8.5993444]\n",
      "Rua de Ceuta, 63, Porto, Portugal -> [41.1483517, -8.6141162]\n",
      "Rua Adolfo Casais Monteiro, 17, Porto, Portugal -> [41.1493674, -8.6229257]\n",
      "Praça do Bom Sucesso, 132, Porto, Portugal -> [41.1551629, -8.6289998]\n",
      "Praça de Parada Leitão, 65, Porto, Portugal -> None\n",
      "Rua da Conceição, 106, Porto, Portugal -> [41.1499998, -8.6146717]\n",
      "Praça Guilherme Gomes Fernandes, 39, Porto, Portugal -> [41.1473299, -8.6148959]\n",
      "Passeio de São Lázaro, 51, Porto, Portugal -> [41.1464627, -8.6021514]\n",
      "Rua do Ateneu Comercial 8-14, Porto, Portugal -> [41.14830535, -8.60755299500439]\n",
      "Rua Senhora da Luz, 448, Porto, Portugal -> [41.1527511, -8.6781263]\n",
      "Rua Martires da Liberdade 130 , Porto, Portugal -> [41.1513262, -8.6138836]\n",
      "Rua das Galeria de Paris, 113, Porto, Portugal -> [41.1099157, -8.6139409]\n",
      "Rua das Oliveiras, 118, Porto, Portugal -> [41.1127505, -8.3964044]\n",
      "Praça Dom Afonso V, 55, Porto, Portugal -> [41.1593238, -8.6653715]\n",
      "Rua de Diu, Porto, Portugal -> [41.1711729, -8.550274]\n",
      "Avenida de Fernão de Magalhães, 500, Porto, Portugal -> [41.1777976, -8.5827625]\n",
      "Rua do Padrão, 152, Porto, Portugal -> [41.14609075, -8.601548366719744]\n",
      "Rua da Conceição, 59, Porto, Portugal -> [41.1928757, -8.613317]\n",
      "Rua da Picaria, 87, Porto, Portugal -> [41.148894, -8.6129889]\n",
      "Rua Pedro Homem de Mello, 242, Porto, Portugal -> None\n",
      "Rua de Cândido dos Reis, 126, Porto, Portugal -> [41.1307322, -8.610898]\n",
      "Rua da Torrinha, 134, Porto, Portugal -> [41.1524145, -8.6192752]\n",
      "Avenida do Brasil, 829, Porto, Portugal -> [41.1539893, -8.6792051]\n",
      "Praça Dona Filipa de Lencastre, 183, Porto, Portugal -> [41.1482679, -8.6129898]\n",
      "Rua da Picaria, 89, Porto, Portugal -> [41.148894, -8.6129889]\n",
      "Rua Professor Mota Pinto, 12, Porto, Portugal -> [41.1668447, -8.6530871]\n",
      "Rua Santa Catarina, 1433, Porto, Portugal -> [41.1601915, -8.6044449]\n",
      "Rua de Miguel Bombarda, 598, Porto, Portugal -> [41.1501741, -8.616987]\n",
      "Rua da Arroteia, 21, Porto, Portugal -> [41.1851523, -8.5969178]\n",
      "Praça de Guilherme Gomes Fernandes, 67, Porto, Portugal -> [41.14762065, -8.614804740940226]\n",
      "Rua de Cedofeita, 263, Porto, Portugal -> [41.1548151, -8.6046934]\n",
      "Rua de Miragaia, 54, Porto, Portugal -> [41.14581685, -8.614019899154705]\n",
      "Rua do Almada, 120, Porto, Portugal -> [41.1471894, -8.6120912]\n",
      "Rua de Santa Catarina, 591, Porto, Portugal -> [41.1509574, -8.6053649]\n",
      "Rua Egas Moniz, 490, Porto, Portugal -> [41.1804876, -8.3216525]\n",
      "Rua de Cedofeita, 382, Porto, Portugal -> [41.1462029, -8.606576739693143]\n",
      "Rua de Cedofeita, 50, Porto, Portugal -> [41.1441545, -8.6228811]\n"
     ]
    }
   ],
   "source": [
    "from time import sleep\n",
    "\n",
    "for index, row in df.iterrows():\n",
    "    # definir a morada completa que queremos procurar\n",
    "    location = '{}, {}, {}'.format(row['morada'], row['localidade'], 'Portugal')\n",
    "    # usar o serviço de geocoding para a encontrar\n",
    "    g = geocoder.komoot(location)\n",
    "    # calmex para não pressionar o servidor\n",
    "    sleep(2)\n",
    "    # caso encontre um valor, guardar no dataframe\n",
    "    if g.latlng:\n",
    "        df.at[index, 'lat'] = g.latlng[0]\n",
    "        df.at[index, 'lon'] = g.latlng[1]\n",
    "    print(location + \" -> \" + str(g.latlng))\n",
    "\n",
    "# gravar o resultado num novo ficheiro\n",
    "df.to_csv('data/hamburguerias_porto_latlon.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": false
   },
   "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>nome</th>\n",
       "      <th>morada</th>\n",
       "      <th>país</th>\n",
       "      <th>localidade</th>\n",
       "      <th>codigo_postal</th>\n",
       "      <th>data_abertura</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Honorato Clérigos</td>\n",
       "      <td>Rua Cândido dos Reis, 12</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-151</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>41.147392</td>\n",
       "      <td>-8.613772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Prégar</td>\n",
       "      <td>Largo de São Domingos, 96</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-253</td>\n",
       "      <td>2016-07-30</td>\n",
       "      <td>41.143111</td>\n",
       "      <td>-8.614766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nook Hamburgaria Pregaria</td>\n",
       "      <td>Rua São João Brito 32</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>41.342881</td>\n",
       "      <td>-8.543260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alta Burguesia</td>\n",
       "      <td>Rua da Restauração, 1</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-21</td>\n",
       "      <td>41.194505</td>\n",
       "      <td>-8.575920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>De Gema</td>\n",
       "      <td>Rua do Almada, 253</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-038</td>\n",
       "      <td>2016-03-21</td>\n",
       "      <td>41.155516</td>\n",
       "      <td>-8.619165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A Burguesa</td>\n",
       "      <td>Via do Castelo do Queijo, 395</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4100-429</td>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Tasquinha do Caco</td>\n",
       "      <td>Rua Amândio Galhano, 51</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-01-31</td>\n",
       "      <td>41.182904</td>\n",
       "      <td>-8.599344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dona Maria Pregaria</td>\n",
       "      <td>Rua de Ceuta, 63</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-12-19</td>\n",
       "      <td>41.148352</td>\n",
       "      <td>-8.614116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Boulevard Burger House</td>\n",
       "      <td>Rua Adolfo Casais Monteiro, 17</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-11-30</td>\n",
       "      <td>41.149367</td>\n",
       "      <td>-8.622926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NY Sliders</td>\n",
       "      <td>Praça do Bom Sucesso, 132</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-02</td>\n",
       "      <td>41.155163</td>\n",
       "      <td>-8.629000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>A Grande e à Francesa</td>\n",
       "      <td>Praça de Parada Leitão, 65</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ó Maria</td>\n",
       "      <td>Rua da Conceição, 106</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>41.150000</td>\n",
       "      <td>-8.614672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Prego da Baixa</td>\n",
       "      <td>Praça Guilherme Gomes Fernandes, 39</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-05-01</td>\n",
       "      <td>41.147330</td>\n",
       "      <td>-8.614896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Tasquinha do Caco</td>\n",
       "      <td>Passeio de São Lázaro, 51</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-01-31</td>\n",
       "      <td>41.146463</td>\n",
       "      <td>-8.602151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Munchie</td>\n",
       "      <td>Rua do Ateneu Comercial 8-14</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-12-09</td>\n",
       "      <td>41.148305</td>\n",
       "      <td>-8.607553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Peebz</td>\n",
       "      <td>Rua Senhora da Luz, 448</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4150-695</td>\n",
       "      <td>2014-12-01</td>\n",
       "      <td>41.152751</td>\n",
       "      <td>-8.678126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Black Mamba - Burgers &amp; Records</td>\n",
       "      <td>Rua Martires da Liberdade 130</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-359</td>\n",
       "      <td>2014-11-29</td>\n",
       "      <td>41.151326</td>\n",
       "      <td>-8.613884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>HD BAR TO BE WILD</td>\n",
       "      <td>Rua das Galeria de Paris, 113</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-284</td>\n",
       "      <td>2014-11-11</td>\n",
       "      <td>41.109916</td>\n",
       "      <td>-8.613941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Zé do Prego</td>\n",
       "      <td>Rua das Oliveiras, 118</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-448</td>\n",
       "      <td>2014-11-01</td>\n",
       "      <td>41.112750</td>\n",
       "      <td>-8.396404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Caffe.55</td>\n",
       "      <td>Praça Dom Afonso V, 55</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-11-01</td>\n",
       "      <td>41.159324</td>\n",
       "      <td>-8.665371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Hamburgueria do Mercado</td>\n",
       "      <td>Rua de Diu</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4150-235</td>\n",
       "      <td>2014-10-01</td>\n",
       "      <td>41.171173</td>\n",
       "      <td>-8.550274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Quinhentos</td>\n",
       "      <td>Avenida de Fernão de Magalhães, 500</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-09-01</td>\n",
       "      <td>41.177798</td>\n",
       "      <td>-8.582762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Casa Vasco</td>\n",
       "      <td>Rua do Padrão, 152</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-05-08</td>\n",
       "      <td>41.146091</td>\n",
       "      <td>-8.601548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SINS Sandwich</td>\n",
       "      <td>Rua da Conceição, 59</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-05-01</td>\n",
       "      <td>41.192876</td>\n",
       "      <td>-8.613317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Baixa Burger</td>\n",
       "      <td>Rua da Picaria, 87</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-03-01</td>\n",
       "      <td>41.148894</td>\n",
       "      <td>-8.612989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Baixa Burger</td>\n",
       "      <td>Rua Pedro Homem de Mello, 242</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-03-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Pão que ladra &amp; Destilaria</td>\n",
       "      <td>Rua de Cândido dos Reis, 126</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-01-01</td>\n",
       "      <td>41.130732</td>\n",
       "      <td>-8.610898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Real Hamburgaria Portuguesa</td>\n",
       "      <td>Rua da Torrinha, 134</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-609</td>\n",
       "      <td>2013-11-01</td>\n",
       "      <td>41.152414</td>\n",
       "      <td>-8.619275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Nova Copa</td>\n",
       "      <td>Avenida do Brasil, 829</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4150-154</td>\n",
       "      <td>2013-09-13</td>\n",
       "      <td>41.153989</td>\n",
       "      <td>-8.679205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Munchie</td>\n",
       "      <td>Praça Dona Filipa de Lencastre, 183</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-07-01</td>\n",
       "      <td>41.148268</td>\n",
       "      <td>-8.612990</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               nome                               morada  \\\n",
       "0                 Honorato Clérigos             Rua Cândido dos Reis, 12   \n",
       "1                            Prégar            Largo de São Domingos, 96   \n",
       "2         Nook Hamburgaria Pregaria                Rua São João Brito 32   \n",
       "3                    Alta Burguesia                Rua da Restauração, 1   \n",
       "4                           De Gema                  Rua do Almada, 253    \n",
       "5                        A Burguesa        Via do Castelo do Queijo, 395   \n",
       "6                 Tasquinha do Caco              Rua Amândio Galhano, 51   \n",
       "7               Dona Maria Pregaria                     Rua de Ceuta, 63   \n",
       "8            Boulevard Burger House       Rua Adolfo Casais Monteiro, 17   \n",
       "9                        NY Sliders            Praça do Bom Sucesso, 132   \n",
       "10            A Grande e à Francesa           Praça de Parada Leitão, 65   \n",
       "11                          Ó Maria                Rua da Conceição, 106   \n",
       "12                   Prego da Baixa  Praça Guilherme Gomes Fernandes, 39   \n",
       "13                Tasquinha do Caco            Passeio de São Lázaro, 51   \n",
       "14                          Munchie         Rua do Ateneu Comercial 8-14   \n",
       "15                            Peebz              Rua Senhora da Luz, 448   \n",
       "16  Black Mamba - Burgers & Records       Rua Martires da Liberdade 130    \n",
       "17                HD BAR TO BE WILD        Rua das Galeria de Paris, 113   \n",
       "18                      Zé do Prego               Rua das Oliveiras, 118   \n",
       "19                         Caffe.55               Praça Dom Afonso V, 55   \n",
       "20          Hamburgueria do Mercado                           Rua de Diu   \n",
       "21                       Quinhentos  Avenida de Fernão de Magalhães, 500   \n",
       "22                       Casa Vasco                   Rua do Padrão, 152   \n",
       "23                    SINS Sandwich                 Rua da Conceição, 59   \n",
       "24                     Baixa Burger                   Rua da Picaria, 87   \n",
       "25                     Baixa Burger        Rua Pedro Homem de Mello, 242   \n",
       "26       Pão que ladra & Destilaria         Rua de Cândido dos Reis, 126   \n",
       "27      Real Hamburgaria Portuguesa                 Rua da Torrinha, 134   \n",
       "28                        Nova Copa               Avenida do Brasil, 829   \n",
       "29                          Munchie  Praça Dona Filipa de Lencastre, 183   \n",
       "\n",
       "        país localidade codigo_postal data_abertura        lat       lon  \n",
       "0   Portugal      Porto      4050-151    2016-08-04  41.147392 -8.613772  \n",
       "1   Portugal      Porto      4050-253    2016-07-30  41.143111 -8.614766  \n",
       "2   Portugal      Porto           NaN    2016-06-01  41.342881 -8.543260  \n",
       "3   Portugal      Porto           NaN    2016-04-21  41.194505 -8.575920  \n",
       "4   Portugal      Porto      4050-038    2016-03-21  41.155516 -8.619165  \n",
       "5   Portugal      Porto      4100-429    2016-03-01        NaN       NaN  \n",
       "6   Portugal      Porto           NaN    2016-01-31  41.182904 -8.599344  \n",
       "7   Portugal      Porto           NaN    2015-12-19  41.148352 -8.614116  \n",
       "8   Portugal      Porto           NaN    2015-11-30  41.149367 -8.622926  \n",
       "9   Portugal      Porto           NaN    2015-07-02  41.155163 -8.629000  \n",
       "10  Portugal      Porto           NaN    2015-07-01        NaN       NaN  \n",
       "11  Portugal      Porto           NaN    2015-06-19  41.150000 -8.614672  \n",
       "12  Portugal      Porto           NaN    2015-05-01  41.147330 -8.614896  \n",
       "13  Portugal      Porto           NaN    2015-01-31  41.146463 -8.602151  \n",
       "14  Portugal      Porto           NaN    2014-12-09  41.148305 -8.607553  \n",
       "15  Portugal      Porto      4150-695    2014-12-01  41.152751 -8.678126  \n",
       "16  Portugal      Porto      4050-359    2014-11-29  41.151326 -8.613884  \n",
       "17  Portugal      Porto      4050-284    2014-11-11  41.109916 -8.613941  \n",
       "18  Portugal      Porto      4050-448    2014-11-01  41.112750 -8.396404  \n",
       "19  Portugal      Porto           NaN    2014-11-01  41.159324 -8.665371  \n",
       "20  Portugal      Porto      4150-235    2014-10-01  41.171173 -8.550274  \n",
       "21  Portugal      Porto           NaN    2014-09-01  41.177798 -8.582762  \n",
       "22  Portugal      Porto           NaN    2014-05-08  41.146091 -8.601548  \n",
       "23  Portugal      Porto           NaN    2014-05-01  41.192876 -8.613317  \n",
       "24  Portugal      Porto           NaN    2014-03-01  41.148894 -8.612989  \n",
       "25  Portugal      Porto           NaN    2014-03-01        NaN       NaN  \n",
       "26  Portugal      Porto           NaN    2014-01-01  41.130732 -8.610898  \n",
       "27  Portugal      Porto      4050-609    2013-11-01  41.152414 -8.619275  \n",
       "28  Portugal      Porto      4150-154    2013-09-13  41.153989 -8.679205  \n",
       "29  Portugal      Porto           NaN    2013-07-01  41.148268 -8.612990  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# conferir que ficou como queríamos\n",
    "df.head(30)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Mapear as hamburgarias!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Unnamed: 0</th>\n",
       "      <th>nome</th>\n",
       "      <th>morada</th>\n",
       "      <th>país</th>\n",
       "      <th>localidade</th>\n",
       "      <th>codigo_postal</th>\n",
       "      <th>data_abertura</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Honorato Clérigos</td>\n",
       "      <td>Rua Cândido dos Reis, 12</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-151</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>41.147392</td>\n",
       "      <td>-8.613773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Prégar</td>\n",
       "      <td>Largo de São Domingos, 96</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-253</td>\n",
       "      <td>2016-07-30</td>\n",
       "      <td>41.143111</td>\n",
       "      <td>-8.614766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Nook Hamburgaria Pregaria</td>\n",
       "      <td>Rua São João Brito 32</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>41.342881</td>\n",
       "      <td>-8.543260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Alta Burguesia</td>\n",
       "      <td>Rua da Restauração, 1</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-04-21</td>\n",
       "      <td>41.194505</td>\n",
       "      <td>-8.575920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>De Gema</td>\n",
       "      <td>Rua do Almada, 253</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Porto</td>\n",
       "      <td>4050-038</td>\n",
       "      <td>2016-03-21</td>\n",
       "      <td>41.155516</td>\n",
       "      <td>-8.619165</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0                       nome                     morada      país  \\\n",
       "0           0          Honorato Clérigos   Rua Cândido dos Reis, 12  Portugal   \n",
       "1           1                     Prégar  Largo de São Domingos, 96  Portugal   \n",
       "2           2  Nook Hamburgaria Pregaria      Rua São João Brito 32  Portugal   \n",
       "3           3             Alta Burguesia      Rua da Restauração, 1  Portugal   \n",
       "4           4                    De Gema        Rua do Almada, 253   Portugal   \n",
       "\n",
       "  localidade codigo_postal data_abertura        lat       lon  \n",
       "0      Porto      4050-151    2016-08-04  41.147392 -8.613773  \n",
       "1      Porto      4050-253    2016-07-30  41.143111 -8.614766  \n",
       "2      Porto           NaN    2016-06-01  41.342881 -8.543260  \n",
       "3      Porto           NaN    2016-04-21  41.194505 -8.575920  \n",
       "4      Porto      4050-038    2016-03-21  41.155516 -8.619165  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('data/hamburguerias_porto_latlon.csv')\n",
    "\n",
    "# em windows? problemas de encoding? Importar assim:\n",
    "# df = pd.read_csv('data/worldcitiespop.txt', encoding='ISO-8859-1')\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><iframe src=\"data:text/html;charset=utf-8;base64,PCFET0NUWVBFIGh0bWw+CjxoZWFkPiAgICAKICAgIDxtZXRhIGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlwZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PVVURi04IiAvPgogICAgPHNjcmlwdD5MX1BSRUZFUl9DQU5WQVM9ZmFsc2U7IExfTk9fVE9VQ0g9ZmFsc2U7IExfRElTQUJMRV8zRD1mYWxzZTs8L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2Nkbi5qc2RlbGl2ci5uZXQvbnBtL2xlYWZsZXRAMS4zLjQvZGlzdC9sZWFmbGV0LmpzIj48L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2FqYXguZ29vZ2xlYXBpcy5jb20vYWpheC9saWJzL2pxdWVyeS8xLjExLjEvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICA8c2NyaXB0IHNyYz0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4yLjAvanMvYm9vdHN0cmFwLm1pbi5qcyI+PC9zY3JpcHQ+CiAgICA8c2NyaXB0IHNyYz0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvTGVhZmxldC5hd2Vzb21lLW1hcmtlcnMvMi4wLjIvbGVhZmxldC5hd2Vzb21lLW1hcmtlcnMuanMiPjwvc2NyaXB0PgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL2Nkbi5qc2RlbGl2ci5uZXQvbnBtL2xlYWZsZXRAMS4zLjQvZGlzdC9sZWFmbGV0LmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9jc3MvYm9vdHN0cmFwLm1pbi5jc3MiLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4yLjAvY3NzL2Jvb3RzdHJhcC10aGVtZS5taW4uY3NzIi8+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vZm9udC1hd2Vzb21lLzQuNi4zL2Nzcy9mb250LWF3ZXNvbWUubWluLmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9MZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy8yLjAuMi9sZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy5jc3MiLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9yYXdjZG4uZ2l0aGFjay5jb20vcHl0aG9uLXZpc3VhbGl6YXRpb24vZm9saXVtL21hc3Rlci9mb2xpdW0vdGVtcGxhdGVzL2xlYWZsZXQuYXdlc29tZS5yb3RhdGUuY3NzIi8+CiAgICA8c3R5bGU+aHRtbCwgYm9keSB7d2lkdGg6IDEwMCU7aGVpZ2h0OiAxMDAlO21hcmdpbjogMDtwYWRkaW5nOiAwO308L3N0eWxlPgogICAgPHN0eWxlPiNtYXAge3Bvc2l0aW9uOmFic29sdXRlO3RvcDowO2JvdHRvbTowO3JpZ2h0OjA7bGVmdDowO308L3N0eWxlPgogICAgCiAgICA8bWV0YSBuYW1lPSJ2aWV3cG9ydCIgY29udGVudD0id2lkdGg9ZGV2aWNlLXdpZHRoLAogICAgICAgIGluaXRpYWwtc2NhbGU9MS4wLCBtYXhpbXVtLXNjYWxlPTEuMCwgdXNlci1zY2FsYWJsZT1ubyIgLz4KICAgIDxzdHlsZT4jbWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiIHsKICAgICAgICBwb3NpdGlvbjogcmVsYXRpdmU7CiAgICAgICAgd2lkdGg6IDEwMC4wJTsKICAgICAgICBoZWlnaHQ6IDEwMC4wJTsKICAgICAgICBsZWZ0OiAwLjAlOwogICAgICAgIHRvcDogMC4wJTsKICAgICAgICB9CiAgICA8L3N0eWxlPgo8L2hlYWQ+Cjxib2R5PiAgICAKICAgIAogICAgPGRpdiBjbGFzcz0iZm9saXVtLW1hcCIgaWQ9Im1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYiIgPjwvZGl2Pgo8L2JvZHk+CjxzY3JpcHQ+ICAgIAogICAgCiAgICAKICAgICAgICB2YXIgYm91bmRzID0gbnVsbDsKICAgIAoKICAgIHZhciBtYXBfMmIzY2U5YjU5NzY4NGEwODg2ZjNiNWNkNzJmMWY3Y2IgPSBMLm1hcCgKICAgICAgICAnbWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiJywgewogICAgICAgIGNlbnRlcjogWzQxLjE1MTM0LCAtOC42MTQ3N10sCiAgICAgICAgem9vbTogMTQsCiAgICAgICAgbWF4Qm91bmRzOiBib3VuZHMsCiAgICAgICAgbGF5ZXJzOiBbXSwKICAgICAgICB3b3JsZENvcHlKdW1wOiBmYWxzZSwKICAgICAgICBjcnM6IEwuQ1JTLkVQU0czODU3LAogICAgICAgIHpvb21Db250cm9sOiB0cnVlLAogICAgICAgIH0pOwoKICAgIAogICAgCiAgICB2YXIgdGlsZV9sYXllcl8xNjUxZGMwNTEwYzc0MmJhYjFhMWU0ZWJiNTA3MDcwNCA9IEwudGlsZUxheWVyKAogICAgICAgICdodHRwczovL3N0YW1lbi10aWxlcy17c30uYS5zc2wuZmFzdGx5Lm5ldC90b25lci97en0ve3h9L3t5fS5wbmcnLAogICAgICAgIHsKICAgICAgICAiYXR0cmlidXRpb24iOiBudWxsLAogICAgICAgICJkZXRlY3RSZXRpbmEiOiBmYWxzZSwKICAgICAgICAibWF4TmF0aXZlWm9vbSI6IDE4LAogICAgICAgICJtYXhab29tIjogMTgsCiAgICAgICAgIm1pblpvb20iOiAwLAogICAgICAgICJub1dyYXAiOiBmYWxzZSwKICAgICAgICAib3BhY2l0eSI6IDEsCiAgICAgICAgInN1YmRvbWFpbnMiOiAiYWJjIiwKICAgICAgICAidG1zIjogZmFsc2UKfSkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgIAogICAgICAgIHZhciBtYXJrZXJfNzc1NWJkZDNjY2U0NGU3ZmI1MjZmY2UxZGQ1N2JlOGUgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE0NzM5MjQsIC04LjYxMzc3MjUwMDAwMDAwMV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzBiMjRhNWQ0MmU1OTRhZDZiYWEzOWIwNWFlMGJlYjc5ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdyZWQnLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfNzc1NWJkZDNjY2U0NGU3ZmI1MjZmY2UxZGQ1N2JlOGUuc2V0SWNvbihpY29uXzBiMjRhNWQ0MmU1OTRhZDZiYWEzOWIwNWFlMGJlYjc5KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzRkZTc3ODFlNmJiYTRjN2U5YTc0MTk3MWI5MmFjODFiID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNWE3YTk3MjNkODllNDJmMGFkYWE1ZjJjMWQxYjQ1MzMgPSAkKGA8ZGl2IGlkPSJodG1sXzVhN2E5NzIzZDg5ZTQyZjBhZGFhNWYyYzFkMWI0NTMzIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Ib25vcmF0byBDbMOpcmlnb3M6IDIwMTYtMDgtMDQ8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzRkZTc3ODFlNmJiYTRjN2U5YTc0MTk3MWI5MmFjODFiLnNldENvbnRlbnQoaHRtbF81YTdhOTcyM2Q4OWU0MmYwYWRhYTVmMmMxZDFiNDUzMyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyXzc3NTViZGQzY2NlNDRlN2ZiNTI2ZmNlMWRkNTdiZThlLmJpbmRQb3B1cChwb3B1cF80ZGU3NzgxZTZiYmE0YzdlOWE3NDE5NzFiOTJhYzgxYikKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyXzA3OWI3MmMxZWVjZDQ1ODZiOWI0NzI2NTY5MjRjZGY4ID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xNDMxMTExMDAwMDAwMDYsIC04LjYxNDc2NTUxMDQ4NzgwOV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uX2YzNDAzM2NkYzhiYjQ0N2JhZjYzOWUwNzdhMDMxMThiID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdyZWQnLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfMDc5YjcyYzFlZWNkNDU4NmI5YjQ3MjY1NjkyNGNkZjguc2V0SWNvbihpY29uX2YzNDAzM2NkYzhiYjQ0N2JhZjYzOWUwNzdhMDMxMThiKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzJhMzgyOTM0MTRjNTQ1ZTc4MzMzNGIyMDYwYWQ2NDEyID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfZDg5NjFhMTc4Njg3NDg1ZDkxNmIzYzdjNGQ3MzE3NmYgPSAkKGA8ZGl2IGlkPSJodG1sX2Q4OTYxYTE3ODY4NzQ4NWQ5MTZiM2M3YzRkNzMxNzZmIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5QcsOpZ2FyOiAyMDE2LTA3LTMwPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF8yYTM4MjkzNDE0YzU0NWU3ODMzMzRiMjA2MGFkNjQxMi5zZXRDb250ZW50KGh0bWxfZDg5NjFhMTc4Njg3NDg1ZDkxNmIzYzdjNGQ3MzE3NmYpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl8wNzliNzJjMWVlY2Q0NTg2YjliNDcyNjU2OTI0Y2RmOC5iaW5kUG9wdXAocG9wdXBfMmEzODI5MzQxNGM1NDVlNzgzMzM0YjIwNjBhZDY0MTIpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl9mZTE3MDVjNjMxOTk0YzU3YmFhNzdlODIxMWY2Zjg2MiA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMzQyODgxNCwgLTguNTQzMjYwMl0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uX2M2ZDcwZjAwMmIzODQ5MDA5NzY3ZmMyNDZhMTBkOGQxID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdyZWQnLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfZmUxNzA1YzYzMTk5NGM1N2JhYTc3ZTgyMTFmNmY4NjIuc2V0SWNvbihpY29uX2M2ZDcwZjAwMmIzODQ5MDA5NzY3ZmMyNDZhMTBkOGQxKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2UwMmE2OGU5YjRkZjQwZDZiMjdjNzdlZDNmZWQ0OWVkID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNmE5MWNkZDVhMDAyNGEwMDhlYjM0ZGE4OTc3MGE1MTMgPSAkKGA8ZGl2IGlkPSJodG1sXzZhOTFjZGQ1YTAwMjRhMDA4ZWIzNGRhODk3NzBhNTEzIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Ob29rIEhhbWJ1cmdhcmlhIFByZWdhcmlhOiAyMDE2LTA2LTAxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9lMDJhNjhlOWI0ZGY0MGQ2YjI3Yzc3ZWQzZmVkNDllZC5zZXRDb250ZW50KGh0bWxfNmE5MWNkZDVhMDAyNGEwMDhlYjM0ZGE4OTc3MGE1MTMpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl9mZTE3MDVjNjMxOTk0YzU3YmFhNzdlODIxMWY2Zjg2Mi5iaW5kUG9wdXAocG9wdXBfZTAyYTY4ZTliNGRmNDBkNmIyN2M3N2VkM2ZlZDQ5ZWQpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl9hZmNlMmExYjQxOTI0NTA4YmMyZmJjODlhZGE0NmM5YyA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTk0NTA0OCwgLTguNTc1OTIwMTk5OTk5OTk5XSwKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgKS5hZGRUbyhtYXBfMmIzY2U5YjU5NzY4NGEwODg2ZjNiNWNkNzJmMWY3Y2IpOwogICAgICAgIAogICAgCgogICAgICAgICAgICAgICAgdmFyIGljb25fOTVkMzNkYjAxMjk4NGVjNzhlOWYyN2FiNDg3NTk5MjcgPSBMLkF3ZXNvbWVNYXJrZXJzLmljb24oewogICAgICAgICAgICAgICAgICAgIGljb246ICdpbmZvLXNpZ24nLAogICAgICAgICAgICAgICAgICAgIGljb25Db2xvcjogJ3doaXRlJywKICAgICAgICAgICAgICAgICAgICBtYXJrZXJDb2xvcjogJ3JlZCcsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl9hZmNlMmExYjQxOTI0NTA4YmMyZmJjODlhZGE0NmM5Yy5zZXRJY29uKGljb25fOTVkMzNkYjAxMjk4NGVjNzhlOWYyN2FiNDg3NTk5MjcpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfODc3YWQ1NzQ4NDRmNGIyNDg5MWJmYjU3OTBiMTY3NzkgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF80NDA2ZGFkZGI2NDk0N2EyODMyYjljODRkNmMxMDllNSA9ICQoYDxkaXYgaWQ9Imh0bWxfNDQwNmRhZGRiNjQ5NDdhMjgzMmI5Yzg0ZDZjMTA5ZTUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkFsdGEgQnVyZ3Vlc2lhOiAyMDE2LTA0LTIxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF84NzdhZDU3NDg0NGY0YjI0ODkxYmZiNTc5MGIxNjc3OS5zZXRDb250ZW50KGh0bWxfNDQwNmRhZGRiNjQ5NDdhMjgzMmI5Yzg0ZDZjMTA5ZTUpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl9hZmNlMmExYjQxOTI0NTA4YmMyZmJjODlhZGE0NmM5Yy5iaW5kUG9wdXAocG9wdXBfODc3YWQ1NzQ4NDRmNGIyNDg5MWJmYjU3OTBiMTY3NzkpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl83NjM0OWYxNGI3Mjg0NjRhYjhlYWQ4YzM2OTI1YWYwNiA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTU1NTE2LCAtOC42MTkxNjQ5MDAwMDAwMDFdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl9jY2M4YWMwMDk5MDI0YzY1OWM3NjQwN2U0NTU5YTcxOSA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAncmVkJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyXzc2MzQ5ZjE0YjcyODQ2NGFiOGVhZDhjMzY5MjVhZjA2LnNldEljb24oaWNvbl9jY2M4YWMwMDk5MDI0YzY1OWM3NjQwN2U0NTU5YTcxOSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF82YTcxZTA5OTdiOTk0ODNmYWZhNmZhZDAzYmFjZTgwMyA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzdkYzQzODlkZTQ1NDRkNDBiMmY5YThjYTU1ZWY5NjlkID0gJChgPGRpdiBpZD0iaHRtbF83ZGM0Mzg5ZGU0NTQ0ZDQwYjJmOWE4Y2E1NWVmOTY5ZCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+RGUgR2VtYTogMjAxNi0wMy0yMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfNmE3MWUwOTk3Yjk5NDgzZmFmYTZmYWQwM2JhY2U4MDMuc2V0Q29udGVudChodG1sXzdkYzQzODlkZTQ1NDRkNDBiMmY5YThjYTU1ZWY5NjlkKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfNzYzNDlmMTRiNzI4NDY0YWI4ZWFkOGMzNjkyNWFmMDYuYmluZFBvcHVwKHBvcHVwXzZhNzFlMDk5N2I5OTQ4M2ZhZmE2ZmFkMDNiYWNlODAzKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfODUxNzM1YWFkNGIzNDg5NjhjZmYxNzkzYmRmOTAxNDUgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE4MjkwNDMsIC04LjU5OTM0NDRdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl8yZDAyNGRlMTQyMzQ0NWZlYTBlZmY5NGI0MjMzNmVhOCA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAncmVkJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyXzg1MTczNWFhZDRiMzQ4OTY4Y2ZmMTc5M2JkZjkwMTQ1LnNldEljb24oaWNvbl8yZDAyNGRlMTQyMzQ0NWZlYTBlZmY5NGI0MjMzNmVhOCk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8yNGQ5NzBjNDQyNDg0ZGVkYTFlMGExMGJjNWMzZGI1MiA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzRhMGJhM2I0ZGMzODRmZThiYjVhMDAyNzgxZGIzYTkwID0gJChgPGRpdiBpZD0iaHRtbF80YTBiYTNiNGRjMzg0ZmU4YmI1YTAwMjc4MWRiM2E5MCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+VGFzcXVpbmhhIGRvIENhY286IDIwMTYtMDEtMzE8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzI0ZDk3MGM0NDI0ODRkZWRhMWUwYTEwYmM1YzNkYjUyLnNldENvbnRlbnQoaHRtbF80YTBiYTNiNGRjMzg0ZmU4YmI1YTAwMjc4MWRiM2E5MCk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyXzg1MTczNWFhZDRiMzQ4OTY4Y2ZmMTc5M2JkZjkwMTQ1LmJpbmRQb3B1cChwb3B1cF8yNGQ5NzBjNDQyNDg0ZGVkYTFlMGExMGJjNWMzZGI1MikKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyXzkzOTI1MmZjYWEyNTQwYWJhMzE1NGUwNzZjMjY5Y2RhID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xNDgzNTE3MDAwMDAwMDYsIC04LjYxNDExNjJdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl82MjdlZTNmODM3ZDk0OTJmYTI1MzQyZDA2MzYxZTQzMSA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfOTM5MjUyZmNhYTI1NDBhYmEzMTU0ZTA3NmMyNjljZGEuc2V0SWNvbihpY29uXzYyN2VlM2Y4MzdkOTQ5MmZhMjUzNDJkMDYzNjFlNDMxKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzhlOWQ2MDMyYTY2ODQxYWJhMzI1OTViMDIyNGI5MzFhID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNjU1MjcxYjY1NTQ5NDY3NGEwYmJkNDE4Mjc2YjI5MGIgPSAkKGA8ZGl2IGlkPSJodG1sXzY1NTI3MWI2NTU0OTQ2NzRhMGJiZDQxODI3NmIyOTBiIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Eb25hIE1hcmlhIFByZWdhcmlhOiAyMDE1LTEyLTE5PC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF84ZTlkNjAzMmE2Njg0MWFiYTMyNTk1YjAyMjRiOTMxYS5zZXRDb250ZW50KGh0bWxfNjU1MjcxYjY1NTQ5NDY3NGEwYmJkNDE4Mjc2YjI5MGIpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl85MzkyNTJmY2FhMjU0MGFiYTMxNTRlMDc2YzI2OWNkYS5iaW5kUG9wdXAocG9wdXBfOGU5ZDYwMzJhNjY4NDFhYmEzMjU5NWIwMjI0YjkzMWEpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl9mMWU2MTY0MDY3MmI0NDE1YTBmZmRmMGRhMjY2Yjc3NiA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTQ5MzY3NCwgLTguNjIyOTI1N10sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzU3NjAzMjhjMmUyMDQ3NDk4OGUyYmNjYzJkZGE5Y2Y0ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl9mMWU2MTY0MDY3MmI0NDE1YTBmZmRmMGRhMjY2Yjc3Ni5zZXRJY29uKGljb25fNTc2MDMyOGMyZTIwNDc0OTg4ZTJiY2NjMmRkYTljZjQpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfODE3M2VmZGRlNGMxNDhiYzg1NTM5MzQzNTBkYmU4MzIgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF81NTZjMDdjNTZmYTk0NmM5OGVhOGU3ODQxMGZiOTY5NyA9ICQoYDxkaXYgaWQ9Imh0bWxfNTU2YzA3YzU2ZmE5NDZjOThlYThlNzg0MTBmYjk2OTciIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkJvdWxldmFyZCBCdXJnZXIgSG91c2U6IDIwMTUtMTEtMzA8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzgxNzNlZmRkZTRjMTQ4YmM4NTUzOTM0MzUwZGJlODMyLnNldENvbnRlbnQoaHRtbF81NTZjMDdjNTZmYTk0NmM5OGVhOGU3ODQxMGZiOTY5Nyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyX2YxZTYxNjQwNjcyYjQ0MTVhMGZmZGYwZGEyNjZiNzc2LmJpbmRQb3B1cChwb3B1cF84MTczZWZkZGU0YzE0OGJjODU1MzkzNDM1MGRiZTgzMikKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyXzQyNGY3MTNmMmM1ZTQ3Y2JiZmVhOTYzMTViMjlmNGUzID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xNTUxNjI4OTk5OTk5OSwgLTguNjI4OTk5OF0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzc1ZGEzMzc0ZGUwNzQwMGRhNjk1YTM2NzdiODNlMjU1ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl80MjRmNzEzZjJjNWU0N2NiYmZlYTk2MzE1YjI5ZjRlMy5zZXRJY29uKGljb25fNzVkYTMzNzRkZTA3NDAwZGE2OTVhMzY3N2I4M2UyNTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfMzUxODc1MWVmYjk3NDk0NGFiNmM1MTAzNmJlYWU0NTAgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9mMDliOGIyNGY1YTc0ZmU0YjQyZTFiMDQ0OTllMTJhYyA9ICQoYDxkaXYgaWQ9Imh0bWxfZjA5YjhiMjRmNWE3NGZlNGI0MmUxYjA0NDk5ZTEyYWMiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPk5ZIFNsaWRlcnM6IDIwMTUtMDctMDI8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzM1MTg3NTFlZmI5NzQ5NDRhYjZjNTEwMzZiZWFlNDUwLnNldENvbnRlbnQoaHRtbF9mMDliOGIyNGY1YTc0ZmU0YjQyZTFiMDQ0OTllMTJhYyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyXzQyNGY3MTNmMmM1ZTQ3Y2JiZmVhOTYzMTViMjlmNGUzLmJpbmRQb3B1cChwb3B1cF8zNTE4NzUxZWZiOTc0OTQ0YWI2YzUxMDM2YmVhZTQ1MCkKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyXzY4ZWExM2QyM2JiODQzMDY5NzQwNTBhZmEwZWYzNzQ5ID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xNDk5OTk3OTk5OTk5OTYsIC04LjYxNDY3MTY5OTk5OTk5OV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uX2U5OTU2MGVlNGU2MzQyYzA5ZjU0YmJiODMyZWM2NWQ0ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl82OGVhMTNkMjNiYjg0MzA2OTc0MDUwYWZhMGVmMzc0OS5zZXRJY29uKGljb25fZTk5NTYwZWU0ZTYzNDJjMDlmNTRiYmI4MzJlYzY1ZDQpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfYjNhMDkyMTc4NWY0NDc2OTg2NjMwMmRjMzM5NGMxODUgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9lMzE3NGVmNmQzYzg0NTRhOGVmMTc0MDFkNzMzNjZmMCA9ICQoYDxkaXYgaWQ9Imh0bWxfZTMxNzRlZjZkM2M4NDU0YThlZjE3NDAxZDczMzY2ZjAiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPsOTIE1hcmlhOiAyMDE1LTA2LTE5PC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9iM2EwOTIxNzg1ZjQ0NzY5ODY2MzAyZGMzMzk0YzE4NS5zZXRDb250ZW50KGh0bWxfZTMxNzRlZjZkM2M4NDU0YThlZjE3NDAxZDczMzY2ZjApOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl82OGVhMTNkMjNiYjg0MzA2OTc0MDUwYWZhMGVmMzc0OS5iaW5kUG9wdXAocG9wdXBfYjNhMDkyMTc4NWY0NDc2OTg2NjMwMmRjMzM5NGMxODUpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl85NjM4Mzk5M2RlMmE0YzIxYjY4YzU3YzQ0OTMwZmFhNiA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTQ3MzI5OSwgLTguNjE0ODk1OV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uX2IwNTM4ODg3YzUyNzQ3N2M4MDM3MWNhOGY3OTg2NmFjID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl85NjM4Mzk5M2RlMmE0YzIxYjY4YzU3YzQ0OTMwZmFhNi5zZXRJY29uKGljb25fYjA1Mzg4ODdjNTI3NDc3YzgwMzcxY2E4Zjc5ODY2YWMpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfMmE2YzUzMWQ0YjEwNGJhYmI3MjIwNTA5NTM3YjU3Y2IgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF85MmYzMDM5ZGE4MTA0MmQ5YTc4MWFjMjUxODEzMzcyZCA9ICQoYDxkaXYgaWQ9Imh0bWxfOTJmMzAzOWRhODEwNDJkOWE3ODFhYzI1MTgxMzM3MmQiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlByZWdvIGRhIEJhaXhhOiAyMDE1LTA1LTAxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF8yYTZjNTMxZDRiMTA0YmFiYjcyMjA1MDk1MzdiNTdjYi5zZXRDb250ZW50KGh0bWxfOTJmMzAzOWRhODEwNDJkOWE3ODFhYzI1MTgxMzM3MmQpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl85NjM4Mzk5M2RlMmE0YzIxYjY4YzU3YzQ0OTMwZmFhNi5iaW5kUG9wdXAocG9wdXBfMmE2YzUzMWQ0YjEwNGJhYmI3MjIwNTA5NTM3YjU3Y2IpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl9jMGVkOTg0NTc3Nzc0ZDRhOTcyMzQxNDgzZWMzYzliOCA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTQ2NDYyNywgLTguNjAyMTUxNF0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uX2JiY2NmZTM3ZDVhMDQ5ZWFiMmZkYjQ4Y2E2OGVlNWZmID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl9jMGVkOTg0NTc3Nzc0ZDRhOTcyMzQxNDgzZWMzYzliOC5zZXRJY29uKGljb25fYmJjY2ZlMzdkNWEwNDllYWIyZmRiNDhjYTY4ZWU1ZmYpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfOTM1ZjVkOTZhZTU2NGJlY2IwZDA4M2RkNDZjYjMyMmYgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF8yZGE3OGE3YzNjMWI0YzI3YjgxYmQ2MDM0NmJlMGY2YSA9ICQoYDxkaXYgaWQ9Imh0bWxfMmRhNzhhN2MzYzFiNGMyN2I4MWJkNjAzNDZiZTBmNmEiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlRhc3F1aW5oYSBkbyBDYWNvOiAyMDE1LTAxLTMxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF85MzVmNWQ5NmFlNTY0YmVjYjBkMDgzZGQ0NmNiMzIyZi5zZXRDb250ZW50KGh0bWxfMmRhNzhhN2MzYzFiNGMyN2I4MWJkNjAzNDZiZTBmNmEpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl9jMGVkOTg0NTc3Nzc0ZDRhOTcyMzQxNDgzZWMzYzliOC5iaW5kUG9wdXAocG9wdXBfOTM1ZjVkOTZhZTU2NGJlY2IwZDA4M2RkNDZjYjMyMmYpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl8xNmM2MjkyYzUyMGM0ZWMyYjYzYTNlNmMxOTA0ZDQwZSA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTQ4MzA1MzUsIC04LjYwNzU1Mjk5NTAwNDM5XSwKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgKS5hZGRUbyhtYXBfMmIzY2U5YjU5NzY4NGEwODg2ZjNiNWNkNzJmMWY3Y2IpOwogICAgICAgIAogICAgCgogICAgICAgICAgICAgICAgdmFyIGljb25fODFkMjk3ZTg2ZTQ5NDkzMGI3MGIwN2Y5Y2RlNzhjMjMgPSBMLkF3ZXNvbWVNYXJrZXJzLmljb24oewogICAgICAgICAgICAgICAgICAgIGljb246ICdpbmZvLXNpZ24nLAogICAgICAgICAgICAgICAgICAgIGljb25Db2xvcjogJ3doaXRlJywKICAgICAgICAgICAgICAgICAgICBtYXJrZXJDb2xvcjogJ2dyZWVuJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyXzE2YzYyOTJjNTIwYzRlYzJiNjNhM2U2YzE5MDRkNDBlLnNldEljb24oaWNvbl84MWQyOTdlODZlNDk0OTMwYjcwYjA3ZjljZGU3OGMyMyk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF83ZGI4OGE4YWQ4OTI0MWUzODFjZDFlOWQxYmJmMmRmZSA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzNiODkxMTg2NjlkZDQyNDlhYzJmM2YyMjcwZTBmYWQ0ID0gJChgPGRpdiBpZD0iaHRtbF8zYjg5MTE4NjY5ZGQ0MjQ5YWMyZjNmMjI3MGUwZmFkNCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+TXVuY2hpZTogMjAxNC0xMi0wOTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfN2RiODhhOGFkODkyNDFlMzgxY2QxZTlkMWJiZjJkZmUuc2V0Q29udGVudChodG1sXzNiODkxMTg2NjlkZDQyNDlhYzJmM2YyMjcwZTBmYWQ0KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfMTZjNjI5MmM1MjBjNGVjMmI2M2EzZTZjMTkwNGQ0MGUuYmluZFBvcHVwKHBvcHVwXzdkYjg4YThhZDg5MjQxZTM4MWNkMWU5ZDFiYmYyZGZlKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfODM0YzZjZjVlYjNjNDkyYTk1OWRlZGQ0MzdjN2NkNTkgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE1Mjc1MTEsIC04LjY3ODEyNjNdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl9kOGNlYjM2MThjZGE0MzlkYWYzZTYyMmRiN2EyYmIzYSA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfODM0YzZjZjVlYjNjNDkyYTk1OWRlZGQ0MzdjN2NkNTkuc2V0SWNvbihpY29uX2Q4Y2ViMzYxOGNkYTQzOWRhZjNlNjIyZGI3YTJiYjNhKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzZjMjJlZTlmMmY3MzQzYjI4MTU2ODExNGZiNGFhZWJiID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfMTQwMzA2YzliYjVmNDcyOGEwMzRjNWRjMzk1NzU5MzMgPSAkKGA8ZGl2IGlkPSJodG1sXzE0MDMwNmM5YmI1ZjQ3MjhhMDM0YzVkYzM5NTc1OTMzIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5QZWViejogMjAxNC0xMi0wMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfNmMyMmVlOWYyZjczNDNiMjgxNTY4MTE0ZmI0YWFlYmIuc2V0Q29udGVudChodG1sXzE0MDMwNmM5YmI1ZjQ3MjhhMDM0YzVkYzM5NTc1OTMzKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfODM0YzZjZjVlYjNjNDkyYTk1OWRlZGQ0MzdjN2NkNTkuYmluZFBvcHVwKHBvcHVwXzZjMjJlZTlmMmY3MzQzYjI4MTU2ODExNGZiNGFhZWJiKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfNGIxM2U4M2QyMmIwNDFkODg3MjdkYjQ1YzkwODkxMWIgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE1MTMyNjIwMDAwMDAxLCAtOC42MTM4ODM2XSwKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgKS5hZGRUbyhtYXBfMmIzY2U5YjU5NzY4NGEwODg2ZjNiNWNkNzJmMWY3Y2IpOwogICAgICAgIAogICAgCgogICAgICAgICAgICAgICAgdmFyIGljb25fZGI3MGE5YWRkMGNhNDRhNjljZmZiMDQ1M2M5NmQ4M2UgPSBMLkF3ZXNvbWVNYXJrZXJzLmljb24oewogICAgICAgICAgICAgICAgICAgIGljb246ICdpbmZvLXNpZ24nLAogICAgICAgICAgICAgICAgICAgIGljb25Db2xvcjogJ3doaXRlJywKICAgICAgICAgICAgICAgICAgICBtYXJrZXJDb2xvcjogJ2dyZWVuJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyXzRiMTNlODNkMjJiMDQxZDg4NzI3ZGI0NWM5MDg5MTFiLnNldEljb24oaWNvbl9kYjcwYTlhZGQwY2E0NGE2OWNmZmIwNDUzYzk2ZDgzZSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF81MjY1MGMyMTIxZjI0ZDNkOWVlYTViMTVhMzkxZjg4MiA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzY4MzQyZDlmNjMyNDRkNTQ5MGQ1NjhjNzA2MjhkNmU5ID0gJChgPGRpdiBpZD0iaHRtbF82ODM0MmQ5ZjYzMjQ0ZDU0OTBkNTY4YzcwNjI4ZDZlOSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+QmxhY2sgTWFtYmEgLSBCdXJnZXJzICYgUmVjb3JkczogMjAxNC0xMS0yOTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfNTI2NTBjMjEyMWYyNGQzZDllZWE1YjE1YTM5MWY4ODIuc2V0Q29udGVudChodG1sXzY4MzQyZDlmNjMyNDRkNTQ5MGQ1NjhjNzA2MjhkNmU5KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfNGIxM2U4M2QyMmIwNDFkODg3MjdkYjQ1YzkwODkxMWIuYmluZFBvcHVwKHBvcHVwXzUyNjUwYzIxMjFmMjRkM2Q5ZWVhNWIxNWEzOTFmODgyKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfYzFlYTFiYjY0Yjk1NGUxNzg3MDQ0Y2Q1NmU3NjViN2QgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjEwOTkxNTcsIC04LjYxMzk0MDldLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl81YWVjYjAzYzBlYmU0ZjFhODg2NGU1ZDAyMDg1Y2NlNCA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfYzFlYTFiYjY0Yjk1NGUxNzg3MDQ0Y2Q1NmU3NjViN2Quc2V0SWNvbihpY29uXzVhZWNiMDNjMGViZTRmMWE4ODY0ZTVkMDIwODVjY2U0KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzU0ODBhMGIwNWJiMDRkNTU5ZmI2ZDEyZmFjZGViNGE2ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNjcwNGZmZGUxYzQ2NDUwYjlmZDYyNjIzMDM4MGNiNDUgPSAkKGA8ZGl2IGlkPSJodG1sXzY3MDRmZmRlMWM0NjQ1MGI5ZmQ2MjYyMzAzODBjYjQ1IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5IRCBCQVIgVE8gQkUgV0lMRDogMjAxNC0xMS0xMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfNTQ4MGEwYjA1YmIwNGQ1NTlmYjZkMTJmYWNkZWI0YTYuc2V0Q29udGVudChodG1sXzY3MDRmZmRlMWM0NjQ1MGI5ZmQ2MjYyMzAzODBjYjQ1KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfYzFlYTFiYjY0Yjk1NGUxNzg3MDQ0Y2Q1NmU3NjViN2QuYmluZFBvcHVwKHBvcHVwXzU0ODBhMGIwNWJiMDRkNTU5ZmI2ZDEyZmFjZGViNGE2KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfODdiNDU0NDdiOGRkNGRiYThlNzlkNGIxZjhhZTQzMzIgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjExMjc1MDUsIC04LjM5NjQwNDQwMDAwMDAwMl0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzJlNjM4NWNiMDE5YjQ1MjViZDkzNjk0NWY0NDM4YTA0ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl84N2I0NTQ0N2I4ZGQ0ZGJhOGU3OWQ0YjFmOGFlNDMzMi5zZXRJY29uKGljb25fMmU2Mzg1Y2IwMTliNDUyNWJkOTM2OTQ1ZjQ0MzhhMDQpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfYmY0YjVhNzFlMTQ4NDQ5MDg5YmNhZTg5Y2Q5NGM4ZWQgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF80YTJiOWNlOWU2YzE0ZTlmYTZhMWI2NGVjNTkwMzI2NSA9ICQoYDxkaXYgaWQ9Imh0bWxfNGEyYjljZTllNmMxNGU5ZmE2YTFiNjRlYzU5MDMyNjUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlrDqSBkbyBQcmVnbzogMjAxNC0xMS0wMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfYmY0YjVhNzFlMTQ4NDQ5MDg5YmNhZTg5Y2Q5NGM4ZWQuc2V0Q29udGVudChodG1sXzRhMmI5Y2U5ZTZjMTRlOWZhNmExYjY0ZWM1OTAzMjY1KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfODdiNDU0NDdiOGRkNGRiYThlNzlkNGIxZjhhZTQzMzIuYmluZFBvcHVwKHBvcHVwX2JmNGI1YTcxZTE0ODQ0OTA4OWJjYWU4OWNkOTRjOGVkKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfNTJlYjYwNjgxZWY4NGJhOTg4YzA2MmFiZWM1YjczNTQgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE1OTMyMzc5OTk5OTk5NiwgLTguNjY1MzcxNV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzE0MzU3YjlhNTdjODQ0ZjY4MmUzZWI4N2VhZGViM2UyID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl81MmViNjA2ODFlZjg0YmE5ODhjMDYyYWJlYzViNzM1NC5zZXRJY29uKGljb25fMTQzNTdiOWE1N2M4NDRmNjgyZTNlYjg3ZWFkZWIzZTIpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfMDc1N2YxZjFlNzM3NDEwMzhlMDE5NTdkYjU4M2ZiMTUgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF80MTVjNzExYTAyMTM0NGVkOGI2NDk4ODU2YjE1MzM0YSA9ICQoYDxkaXYgaWQ9Imh0bWxfNDE1YzcxMWEwMjEzNDRlZDhiNjQ5ODg1NmIxNTMzNGEiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkNhZmZlLjU1OiAyMDE0LTExLTAxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF8wNzU3ZjFmMWU3Mzc0MTAzOGUwMTk1N2RiNTgzZmIxNS5zZXRDb250ZW50KGh0bWxfNDE1YzcxMWEwMjEzNDRlZDhiNjQ5ODg1NmIxNTMzNGEpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl81MmViNjA2ODFlZjg0YmE5ODhjMDYyYWJlYzViNzM1NC5iaW5kUG9wdXAocG9wdXBfMDc1N2YxZjFlNzM3NDEwMzhlMDE5NTdkYjU4M2ZiMTUpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl9iYjI5YjRjZmZiMzQ0ZTYxYWUyYWUxZGFlZWEyNTNhZiA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTcxMTcyOSwgLTguNTUwMjc0XSwKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgKS5hZGRUbyhtYXBfMmIzY2U5YjU5NzY4NGEwODg2ZjNiNWNkNzJmMWY3Y2IpOwogICAgICAgIAogICAgCgogICAgICAgICAgICAgICAgdmFyIGljb25fNjkzNjQ2MzcxOTMxNDQ5OGI0NGZjZWRiMGU2ZWZiMGMgPSBMLkF3ZXNvbWVNYXJrZXJzLmljb24oewogICAgICAgICAgICAgICAgICAgIGljb246ICdpbmZvLXNpZ24nLAogICAgICAgICAgICAgICAgICAgIGljb25Db2xvcjogJ3doaXRlJywKICAgICAgICAgICAgICAgICAgICBtYXJrZXJDb2xvcjogJ2dyZWVuJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyX2JiMjliNGNmZmIzNDRlNjFhZTJhZTFkYWVlYTI1M2FmLnNldEljb24oaWNvbl82OTM2NDYzNzE5MzE0NDk4YjQ0ZmNlZGIwZTZlZmIwYyk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8wYzQ0ZDJlOWI5ZDQ0N2Q1YTE1MmJmNjIyMTczNzY2MCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sX2NhNjUyYzJlMGRkZTQxYjhhN2E1YzljNThkMjE2MDU2ID0gJChgPGRpdiBpZD0iaHRtbF9jYTY1MmMyZTBkZGU0MWI4YTdhNWM5YzU4ZDIxNjA1NiIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+SGFtYnVyZ3VlcmlhIGRvIE1lcmNhZG86IDIwMTQtMTAtMDE8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzBjNDRkMmU5YjlkNDQ3ZDVhMTUyYmY2MjIxNzM3NjYwLnNldENvbnRlbnQoaHRtbF9jYTY1MmMyZTBkZGU0MWI4YTdhNWM5YzU4ZDIxNjA1Nik7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyX2JiMjliNGNmZmIzNDRlNjFhZTJhZTFkYWVlYTI1M2FmLmJpbmRQb3B1cChwb3B1cF8wYzQ0ZDJlOWI5ZDQ0N2Q1YTE1MmJmNjIyMTczNzY2MCkKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyXzUzMDgyMDQ3YTRiYjRjMGE5ZGZkOGJiZmQxOGExN2Y5ID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xNzc3OTc2MDAwMDAwMDUsIC04LjU4Mjc2MjVdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl8zODNmZmQ0MGNkZjY0MTI5OWNmYzg5NTYxZGY1OTg3YiA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfNTMwODIwNDdhNGJiNGMwYTlkZmQ4YmJmZDE4YTE3Zjkuc2V0SWNvbihpY29uXzM4M2ZmZDQwY2RmNjQxMjk5Y2ZjODk1NjFkZjU5ODdiKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzFlZGU1MjVmMzM1ZTQxOTY5ZDAyMjE2ZDMwYjllMzRkID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfZTdmY2YzZTA3ZTA2NGFiNTkxNTY2OWEwMTAzOTcyYWUgPSAkKGA8ZGl2IGlkPSJodG1sX2U3ZmNmM2UwN2UwNjRhYjU5MTU2NjlhMDEwMzk3MmFlIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5RdWluaGVudG9zOiAyMDE0LTA5LTAxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF8xZWRlNTI1ZjMzNWU0MTk2OWQwMjIxNmQzMGI5ZTM0ZC5zZXRDb250ZW50KGh0bWxfZTdmY2YzZTA3ZTA2NGFiNTkxNTY2OWEwMTAzOTcyYWUpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl81MzA4MjA0N2E0YmI0YzBhOWRmZDhiYmZkMThhMTdmOS5iaW5kUG9wdXAocG9wdXBfMWVkZTUyNWYzMzVlNDE5NjlkMDIyMTZkMzBiOWUzNGQpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl85MmI2MzJjYTAxMmY0YmM0YThhYjFiNTBjMGUzY2ZkYiA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTQ2MDkwNzUsIC04LjYwMTU0ODM2NjcxOTc0NF0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uX2NlYzVhYTQ5YWNjZTQ3ZTY5MDNlZDNhYmQxOGJhZGYwID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl85MmI2MzJjYTAxMmY0YmM0YThhYjFiNTBjMGUzY2ZkYi5zZXRJY29uKGljb25fY2VjNWFhNDlhY2NlNDdlNjkwM2VkM2FiZDE4YmFkZjApOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfMTY1MDY3MWZiMDY5NDM2YjkzZmY3MTMxODkyOGZlODcgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9lMjYwNzFjOTBmMDA0ZTQ5YTE0ZWRhNWU4OWNmYzE3MyA9ICQoYDxkaXYgaWQ9Imh0bWxfZTI2MDcxYzkwZjAwNGU0OWExNGVkYTVlODljZmMxNzMiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkNhc2EgVmFzY286IDIwMTQtMDUtMDg8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzE2NTA2NzFmYjA2OTQzNmI5M2ZmNzEzMTg5MjhmZTg3LnNldENvbnRlbnQoaHRtbF9lMjYwNzFjOTBmMDA0ZTQ5YTE0ZWRhNWU4OWNmYzE3Myk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyXzkyYjYzMmNhMDEyZjRiYzRhOGFiMWI1MGMwZTNjZmRiLmJpbmRQb3B1cChwb3B1cF8xNjUwNjcxZmIwNjk0MzZiOTNmZjcxMzE4OTI4ZmU4NykKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyX2Y4NzZkN2ViYmQyMDRhZWFhMjNlZDVjNmI1YjMxNzg1ID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xOTI4NzU3LCAtOC42MTMzMTddLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl85YjFjMGYxM2RmNTA0OWU2OGFjNTYzMzcxNWE3ODc5NCA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfZjg3NmQ3ZWJiZDIwNGFlYWEyM2VkNWM2YjViMzE3ODUuc2V0SWNvbihpY29uXzliMWMwZjEzZGY1MDQ5ZTY4YWM1NjMzNzE1YTc4Nzk0KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzljYmU2M2M1YzhjNzRiN2M5Njk0NWIyNGZlOTRhYTJhID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfYmFkNDA5OWZkYWUyNDRmZTgwYzA3Y2JmNzA0NTUyNjUgPSAkKGA8ZGl2IGlkPSJodG1sX2JhZDQwOTlmZGFlMjQ0ZmU4MGMwN2NiZjcwNDU1MjY1IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5TSU5TIFNhbmR3aWNoOiAyMDE0LTA1LTAxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF85Y2JlNjNjNWM4Yzc0YjdjOTY5NDViMjRmZTk0YWEyYS5zZXRDb250ZW50KGh0bWxfYmFkNDA5OWZkYWUyNDRmZTgwYzA3Y2JmNzA0NTUyNjUpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl9mODc2ZDdlYmJkMjA0YWVhYTIzZWQ1YzZiNWIzMTc4NS5iaW5kUG9wdXAocG9wdXBfOWNiZTYzYzVjOGM3NGI3Yzk2OTQ1YjI0ZmU5NGFhMmEpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl83ZTkwNjk4YTZiYjA0MzdlYTE3YWI5YTcxYjhhZDMzOCA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTQ4ODk0LCAtOC42MTI5ODg5MDAwMDAwMDFdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl85MGEyY2JhZjhiZGI0MTE4OGIxMTBlMGFhNjcxOWI4MiA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfN2U5MDY5OGE2YmIwNDM3ZWExN2FiOWE3MWI4YWQzMzguc2V0SWNvbihpY29uXzkwYTJjYmFmOGJkYjQxMTg4YjExMGUwYWE2NzE5YjgyKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzgwZmIyYjc0ODA0ODQ1ZmM5NGZhZDNjZTI1NGNjNDhjID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfYjgwZjkzMDc0ZTI0NDM0NWI5NTEyZjBkY2U0M2I4NmMgPSAkKGA8ZGl2IGlkPSJodG1sX2I4MGY5MzA3NGUyNDQzNDViOTUxMmYwZGNlNDNiODZjIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5CYWl4YSBCdXJnZXI6IDIwMTQtMDMtMDE8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzgwZmIyYjc0ODA0ODQ1ZmM5NGZhZDNjZTI1NGNjNDhjLnNldENvbnRlbnQoaHRtbF9iODBmOTMwNzRlMjQ0MzQ1Yjk1MTJmMGRjZTQzYjg2Yyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyXzdlOTA2OThhNmJiMDQzN2VhMTdhYjlhNzFiOGFkMzM4LmJpbmRQb3B1cChwb3B1cF84MGZiMmI3NDgwNDg0NWZjOTRmYWQzY2UyNTRjYzQ4YykKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyXzgxNWRlMjBkZDU1ZTQ0MTViODQ5MDRiMzIxOTRhNzAxID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xMzA3MzIyMDAwMDAwMDQsIC04LjYxMDg5Nzk5OTk5OTk5OV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzBkZjc4YjRmMzI3ZTQwZjg4NWZhYWNiYzA2OWY2YTIwID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl84MTVkZTIwZGQ1NWU0NDE1Yjg0OTA0YjMyMTk0YTcwMS5zZXRJY29uKGljb25fMGRmNzhiNGYzMjdlNDBmODg1ZmFhY2JjMDY5ZjZhMjApOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfN2FjMGMxOTU1MGY4NDgzZGIxZjlhNjlkZTJhOWRlNTcgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9hOGJlZDliZjg3M2M0ZWE3YjA4Yjc5NWNmNDBmZmU0ZCA9ICQoYDxkaXYgaWQ9Imh0bWxfYThiZWQ5YmY4NzNjNGVhN2IwOGI3OTVjZjQwZmZlNGQiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlDDo28gcXVlIGxhZHJhICYgRGVzdGlsYXJpYTogMjAxNC0wMS0wMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfN2FjMGMxOTU1MGY4NDgzZGIxZjlhNjlkZTJhOWRlNTcuc2V0Q29udGVudChodG1sX2E4YmVkOWJmODczYzRlYTdiMDhiNzk1Y2Y0MGZmZTRkKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfODE1ZGUyMGRkNTVlNDQxNWI4NDkwNGIzMjE5NGE3MDEuYmluZFBvcHVwKHBvcHVwXzdhYzBjMTk1NTBmODQ4M2RiMWY5YTY5ZGUyYTlkZTU3KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfNWJhM2U2YWUyZjNjNGU5N2FmYjQ5MThhODNlMmM5YzkgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE1MjQxNDUsIC04LjYxOTI3NTE5OTk5OTk5OV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzA2NzliMjA3NDEyYjQ2Y2I4YzFlYmZlODUxOTZhMDZjID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl81YmEzZTZhZTJmM2M0ZTk3YWZiNDkxOGE4M2UyYzljOS5zZXRJY29uKGljb25fMDY3OWIyMDc0MTJiNDZjYjhjMWViZmU4NTE5NmEwNmMpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfYTYxY2U2NjJkMzlhNDQ0NzliNTJmNjUxNDFiYTFkYjYgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF8zOGM3YTljM2MyOTI0ZjdhOWQwZGQzMGE3N2I4OWQ1MyA9ICQoYDxkaXYgaWQ9Imh0bWxfMzhjN2E5YzNjMjkyNGY3YTlkMGRkMzBhNzdiODlkNTMiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlJlYWwgSGFtYnVyZ2FyaWEgUG9ydHVndWVzYTogMjAxMy0xMS0wMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfYTYxY2U2NjJkMzlhNDQ0NzliNTJmNjUxNDFiYTFkYjYuc2V0Q29udGVudChodG1sXzM4YzdhOWMzYzI5MjRmN2E5ZDBkZDMwYTc3Yjg5ZDUzKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfNWJhM2U2YWUyZjNjNGU5N2FmYjQ5MThhODNlMmM5YzkuYmluZFBvcHVwKHBvcHVwX2E2MWNlNjYyZDM5YTQ0NDc5YjUyZjY1MTQxYmExZGI2KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfYzAwYjNlMWQ5ODFmNDc3OWEwNzU5ZGMwNjNmOTlmZWYgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE1Mzk4OTMsIC04LjY3OTIwNTA5OTk5OTk5OV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzYwZGU2NzA2NzhjZjRjOGM4YTgxMDlhMGRiN2I5ZGU3ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl9jMDBiM2UxZDk4MWY0Nzc5YTA3NTlkYzA2M2Y5OWZlZi5zZXRJY29uKGljb25fNjBkZTY3MDY3OGNmNGM4YzhhODEwOWEwZGI3YjlkZTcpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfMzNmNzYwMDYxZTg2NGFkZmIyZTMyMTlhNzk5ZGQ1ODQgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9hODM2ZjU5ZWFkZWM0NTBlOTI0MjgxNjRiOGFjNzg3MSA9ICQoYDxkaXYgaWQ9Imh0bWxfYTgzNmY1OWVhZGVjNDUwZTkyNDI4MTY0YjhhYzc4NzEiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPk5vdmEgQ29wYTogMjAxMy0wOS0xMzwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfMzNmNzYwMDYxZTg2NGFkZmIyZTMyMTlhNzk5ZGQ1ODQuc2V0Q29udGVudChodG1sX2E4MzZmNTllYWRlYzQ1MGU5MjQyODE2NGI4YWM3ODcxKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfYzAwYjNlMWQ5ODFmNDc3OWEwNzU5ZGMwNjNmOTlmZWYuYmluZFBvcHVwKHBvcHVwXzMzZjc2MDA2MWU4NjRhZGZiMmUzMjE5YTc5OWRkNTg0KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfMThlYzg4ODA2MjEyNDM2N2E0MWU4N2YwNzlmYWYyNDkgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE0ODI2NzksIC04LjYxMjk4OThdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl8zZmM2YTYzMGI0NjY0MjdmYTdmYTk4NTMwYzAwMGM0MiA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfMThlYzg4ODA2MjEyNDM2N2E0MWU4N2YwNzlmYWYyNDkuc2V0SWNvbihpY29uXzNmYzZhNjMwYjQ2NjQyN2ZhN2ZhOTg1MzBjMDAwYzQyKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2M4MzZlMzQxMWZhODQzMmU4NGI1OTE4ODU2MTE0NWM2ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNDA2M2JkMWE1YjNmNDFhZjg2NmRmZjRiZjc1Y2VjNTEgPSAkKGA8ZGl2IGlkPSJodG1sXzQwNjNiZDFhNWIzZjQxYWY4NjZkZmY0YmY3NWNlYzUxIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5NdW5jaGllOiAyMDEzLTA3LTAxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9jODM2ZTM0MTFmYTg0MzJlODRiNTkxODg1NjExNDVjNi5zZXRDb250ZW50KGh0bWxfNDA2M2JkMWE1YjNmNDFhZjg2NmRmZjRiZjc1Y2VjNTEpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl8xOGVjODg4MDYyMTI0MzY3YTQxZTg3ZjA3OWZhZjI0OS5iaW5kUG9wdXAocG9wdXBfYzgzNmUzNDExZmE4NDMyZTg0YjU5MTg4NTYxMTQ1YzYpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl9kMmU5MmFiMTkxMmY0MjdmOThjODk3ZDEzNjlhODZjZiA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTQ4ODk0LCAtOC42MTI5ODg5MDAwMDAwMDFdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl9kMmY2YjE0YzY3MTE0NDY2YTkxMDE0MWIxODAzYzg2ZiA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfZDJlOTJhYjE5MTJmNDI3Zjk4Yzg5N2QxMzY5YTg2Y2Yuc2V0SWNvbihpY29uX2QyZjZiMTRjNjcxMTQ0NjZhOTEwMTQxYjE4MDNjODZmKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2EwYWQ0NGVmNDdlNTRiMTE5ZTg1YTJlNDI2NWFkNWQ3ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfMWMxMzc5ZWRkNDI1NGFmYTgyNmNiMTg1ZTIwM2E2YjggPSAkKGA8ZGl2IGlkPSJodG1sXzFjMTM3OWVkZDQyNTRhZmE4MjZjYjE4NWUyMDNhNmI4IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5CYWl4YSBCdXJnZXI6IDIwMTMtMDctMDE8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwX2EwYWQ0NGVmNDdlNTRiMTE5ZTg1YTJlNDI2NWFkNWQ3LnNldENvbnRlbnQoaHRtbF8xYzEzNzllZGQ0MjU0YWZhODI2Y2IxODVlMjAzYTZiOCk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyX2QyZTkyYWIxOTEyZjQyN2Y5OGM4OTdkMTM2OWE4NmNmLmJpbmRQb3B1cChwb3B1cF9hMGFkNDRlZjQ3ZTU0YjExOWU4NWEyZTQyNjVhZDVkNykKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyXzE5ZTIxOWM0NDMzMjRmMTY4MjgzZjA4NTkwMzcxMjRhID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xNjY4NDQ3MDAwMDAwMDYsIC04LjY1MzA4NzFdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl8zYzZlNjE2MTEwNzg0YTQ5OWI5MzRmZDQ5ZjU0ODc0ZSA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfMTllMjE5YzQ0MzMyNGYxNjgyODNmMDg1OTAzNzEyNGEuc2V0SWNvbihpY29uXzNjNmU2MTYxMTA3ODRhNDk5YjkzNGZkNDlmNTQ4NzRlKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzdkZGJlMzkyODEwYzQyMDY4NzFhMWE1ZDJkZDExNWYyID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNzk3ZTk5MGQ1ZWY4NGQ3MGJmZWVhZmRlZjI1MDM1MjQgPSAkKGA8ZGl2IGlkPSJodG1sXzc5N2U5OTBkNWVmODRkNzBiZmVlYWZkZWYyNTAzNTI0IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5JZGVpYXMgY29tIFNhYm9yOiAyMDEyLTA5LTExPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF83ZGRiZTM5MjgxMGM0MjA2ODcxYTFhNWQyZGQxMTVmMi5zZXRDb250ZW50KGh0bWxfNzk3ZTk5MGQ1ZWY4NGQ3MGJmZWVhZmRlZjI1MDM1MjQpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl8xOWUyMTljNDQzMzI0ZjE2ODI4M2YwODU5MDM3MTI0YS5iaW5kUG9wdXAocG9wdXBfN2RkYmUzOTI4MTBjNDIwNjg3MWExYTVkMmRkMTE1ZjIpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgdmFyIG1hcmtlcl9mYjZiZGQ0NTczNDA0MmY3YTZkMjRjNDM4NmM1M2I1NCA9IEwubWFya2VyKAogICAgICAgICAgICBbNDEuMTYwMTkxNDk5OTk5OTk2LCAtOC42MDQ0NDQ5XSwKICAgICAgICAgICAgewogICAgICAgICAgICAgICAgaWNvbjogbmV3IEwuSWNvbi5EZWZhdWx0KCkKICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgKS5hZGRUbyhtYXBfMmIzY2U5YjU5NzY4NGEwODg2ZjNiNWNkNzJmMWY3Y2IpOwogICAgICAgIAogICAgCgogICAgICAgICAgICAgICAgdmFyIGljb25fOGIzYzgzZGQxNDM5NGZhMWE1ZTQ3ODlmZmQyOGE4MDQgPSBMLkF3ZXNvbWVNYXJrZXJzLmljb24oewogICAgICAgICAgICAgICAgICAgIGljb246ICdpbmZvLXNpZ24nLAogICAgICAgICAgICAgICAgICAgIGljb25Db2xvcjogJ3doaXRlJywKICAgICAgICAgICAgICAgICAgICBtYXJrZXJDb2xvcjogJ2dyZWVuJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyX2ZiNmJkZDQ1NzM0MDQyZjdhNmQyNGM0Mzg2YzUzYjU0LnNldEljb24oaWNvbl84YjNjODNkZDE0Mzk0ZmExYTVlNDc4OWZmZDI4YTgwNCk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9iMzk3NmM2MWU2MGU0ZjI2YTZjNWRjNGI0ODA3MDExMCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sX2M0ZjBlMDA2NjEzNjQwZmRhODFjNjQ2YzcxMGZjYTNhID0gJChgPGRpdiBpZD0iaHRtbF9jNGYwZTAwNjYxMzY0MGZkYTgxYzY0NmM3MTBmY2EzYSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+VGFzdGUgQnVyZ3VlcjogMjAxMi0wMy0yOTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfYjM5NzZjNjFlNjBlNGYyNmE2YzVkYzRiNDgwNzAxMTAuc2V0Q29udGVudChodG1sX2M0ZjBlMDA2NjEzNjQwZmRhODFjNjQ2YzcxMGZjYTNhKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfZmI2YmRkNDU3MzQwNDJmN2E2ZDI0YzQzODZjNTNiNTQuYmluZFBvcHVwKHBvcHVwX2IzOTc2YzYxZTYwZTRmMjZhNmM1ZGM0YjQ4MDcwMTEwKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfNjY0NTdhNTJmYzNmNGE4Y2JhODQzMDZkODk2OGIyNTEgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE1MDE3NDEsIC04LjYxNjk4N10sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uX2QzY2UyNDE2ZTJlODQ0YzliYjU5MWI4YjU1NjQyNjFiID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl82NjQ1N2E1MmZjM2Y0YThjYmE4NDMwNmQ4OTY4YjI1MS5zZXRJY29uKGljb25fZDNjZTI0MTZlMmU4NDRjOWJiNTkxYjhiNTU2NDI2MWIpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfOTBkMDFmOTY3NjdjNDIwM2I3MmVmYzUzMzBmMmY0MGQgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF82MzAxNjMxNTJmYjg0OGU2OGYzN2M5NmY2MzBlOTkyYiA9ICQoYDxkaXYgaWQ9Imh0bWxfNjMwMTYzMTUyZmI4NDhlNjhmMzdjOTZmNjMwZTk5MmIiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkJ1Z28gQXJ0IEJ1cmdlcjogMjAxMS0wMi0wMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfOTBkMDFmOTY3NjdjNDIwM2I3MmVmYzUzMzBmMmY0MGQuc2V0Q29udGVudChodG1sXzYzMDE2MzE1MmZiODQ4ZTY4ZjM3Yzk2ZjYzMGU5OTJiKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfNjY0NTdhNTJmYzNmNGE4Y2JhODQzMDZkODk2OGIyNTEuYmluZFBvcHVwKHBvcHVwXzkwZDAxZjk2NzY3YzQyMDNiNzJlZmM1MzMwZjJmNDBkKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfZDMzMzFkOGUxMTYxNDcxZmJkZjFjYmY2NWI2MzNmMWEgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE4NTE1MjMsIC04LjU5NjkxNzgwMDAwMDAwMl0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzFjMmM0YjRlNjE3YTRjZWRhZGY0NDE2Yzk3Y2FjZTAyID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl9kMzMzMWQ4ZTExNjE0NzFmYmRmMWNiZjY1YjYzM2YxYS5zZXRJY29uKGljb25fMWMyYzRiNGU2MTdhNGNlZGFkZjQ0MTZjOTdjYWNlMDIpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfZGViYjU1ODg4ODc3NDEzZmFlYTMyYjcxZWVmZDEzN2QgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9kMDQxZGY5YWJlOTc0ZWM1OWZlNmRjZjg0MDk5YzRhNyA9ICQoYDxkaXYgaWQ9Imh0bWxfZDA0MWRmOWFiZTk3NGVjNTlmZTZkY2Y4NDA5OWM0YTciIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkx1bmF0aWMgQnVyZ3VlcjogMjAwOS0xMS0yNzwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfZGViYjU1ODg4ODc3NDEzZmFlYTMyYjcxZWVmZDEzN2Quc2V0Q29udGVudChodG1sX2QwNDFkZjlhYmU5NzRlYzU5ZmU2ZGNmODQwOTljNGE3KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfZDMzMzFkOGUxMTYxNDcxZmJkZjFjYmY2NWI2MzNmMWEuYmluZFBvcHVwKHBvcHVwX2RlYmI1NTg4ODg3NzQxM2ZhZWEzMmI3MWVlZmQxMzdkKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfMmZjZmYzZjBhZDhhNDc1Nzg5MDM1MDg1ZDYzZDkxMTggPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE0NzYyMDY1LCAtOC42MTQ4MDQ3NDA5NDAyMjZdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl9hZWUyZjhmZWUxYjE0OGQ4YmZlNTlkMDA2MzRlYWNmNSA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAncmVkJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyXzJmY2ZmM2YwYWQ4YTQ3NTc4OTAzNTA4NWQ2M2Q5MTE4LnNldEljb24oaWNvbl9hZWUyZjhmZWUxYjE0OGQ4YmZlNTlkMDA2MzRlYWNmNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9iMmY5YTk4ZThmMTE0NDNhOGViZDE3MzM2OGJkZmJlNCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzAxOWY5YjBmYTZkNTQzNTNhNzRkMmJjYTIxZjgyNWI0ID0gJChgPGRpdiBpZD0iaHRtbF8wMTlmOWIwZmE2ZDU0MzUzYTc0ZDJiY2EyMWY4MjViNCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+U3RlYWsgJmFwb3M7biBTaGFrZTogMjAxNy0wMS0yMzwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfYjJmOWE5OGU4ZjExNDQzYThlYmQxNzMzNjhiZGZiZTQuc2V0Q29udGVudChodG1sXzAxOWY5YjBmYTZkNTQzNTNhNzRkMmJjYTIxZjgyNWI0KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfMmZjZmYzZjBhZDhhNDc1Nzg5MDM1MDg1ZDYzZDkxMTguYmluZFBvcHVwKHBvcHVwX2IyZjlhOThlOGYxMTQ0M2E4ZWJkMTczMzY4YmRmYmU0KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfMWZiZmQ1MzEzOGIyNDVhM2JiMDU4NmRkOTI3Y2FhMjQgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE1NDgxNTEsIC04LjYwNDY5MzRdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl9kNGE1NTMyNDJlNTk0NjNiODdlZjA0ODhlNGJmMTdjYyA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAncmVkJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyXzFmYmZkNTMxMzhiMjQ1YTNiYjA1ODZkZDkyN2NhYTI0LnNldEljb24oaWNvbl9kNGE1NTMyNDJlNTk0NjNiODdlZjA0ODhlNGJmMTdjYyk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8yMjYzNmIzM2MwZWM0NzMxYmRjMmM0N2Q0YjBmNTg3MCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzViMDg0NTU5MmVhMjQ1OTZhYTcwNTE4ZDBiNTFkNzg4ID0gJChgPGRpdiBpZD0iaHRtbF81YjA4NDU1OTJlYTI0NTk2YWE3MDUxOGQwYjUxZDc4OCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+QmFvJmFwb3M7cyBUYWl3YW5lc2UgQnVyZ3VlcjogMjAxNy0wNS0wODwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfMjI2MzZiMzNjMGVjNDczMWJkYzJjNDdkNGIwZjU4NzAuc2V0Q29udGVudChodG1sXzViMDg0NTU5MmVhMjQ1OTZhYTcwNTE4ZDBiNTFkNzg4KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfMWZiZmQ1MzEzOGIyNDVhM2JiMDU4NmRkOTI3Y2FhMjQuYmluZFBvcHVwKHBvcHVwXzIyNjM2YjMzYzBlYzQ3MzFiZGMyYzQ3ZDRiMGY1ODcwKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfYzJjNGZkMmRkNDdmNDQxYWJkZmY5Y2UwNjJiMTY4ZGUgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE0NTgxNjg1LCAtOC42MTQwMTk4OTkxNTQ3MDVdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl8xYTA3MzNkYTNkMzg0NjJjYTA2MWNkZjk4ZTVhZjZkMCA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAncmVkJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyX2MyYzRmZDJkZDQ3ZjQ0MWFiZGZmOWNlMDYyYjE2OGRlLnNldEljb24oaWNvbl8xYTA3MzNkYTNkMzg0NjJjYTA2MWNkZjk4ZTVhZjZkMCk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8wMTI2ODVlN2Y1ZGU0YjFmYjZmZGJmMWNiNGUyYjU0YiA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzU1Mzk4Mzk2NjY4ZDQ4OGE4ODM0ZWNkYTVkM2U1ZDY4ID0gJChgPGRpdiBpZD0iaHRtbF81NTM5ODM5NjY2OGQ0ODhhODgzNGVjZGE1ZDNlNWQ2OCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+QmFja3NvbmBzIEZpbmUgQnVyZ2VycyBhbmQgTXVzc2VsczogMjAxNy0wMy0yNjwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfMDEyNjg1ZTdmNWRlNGIxZmI2ZmRiZjFjYjRlMmI1NGIuc2V0Q29udGVudChodG1sXzU1Mzk4Mzk2NjY4ZDQ4OGE4ODM0ZWNkYTVkM2U1ZDY4KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfYzJjNGZkMmRkNDdmNDQxYWJkZmY5Y2UwNjJiMTY4ZGUuYmluZFBvcHVwKHBvcHVwXzAxMjY4NWU3ZjVkZTRiMWZiNmZkYmYxY2I0ZTJiNTRiKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfODI5YzgyOTgwZDNhNDUzZGE2ZjU4ZTg1ODk0MjNiNjkgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE0NzE4OTM5OTk5OTk5NSwgLTguNjEyMDkxMl0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzY0NTAwYWVhN2JiNjQwNzJhYTJhODkxNTQ4YmRlNjkzID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdyZWQnLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfODI5YzgyOTgwZDNhNDUzZGE2ZjU4ZTg1ODk0MjNiNjkuc2V0SWNvbihpY29uXzY0NTAwYWVhN2JiNjQwNzJhYTJhODkxNTQ4YmRlNjkzKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzM1ZmZhOWRkY2RjMTRjOGJhZWM4ZWE1NjQwYjQ4ODQ0ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNDU4OTEyNjlmNzc2NGExYWI0N2I0MjI1OTQ2M2NkYzkgPSAkKGA8ZGl2IGlkPSJodG1sXzQ1ODkxMjY5Zjc3NjRhMWFiNDdiNDIyNTk0NjNjZGM5IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5IYXJkIFJvY2sgQ2Fmw6k6IDIwMTYtMTEtMjA8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzM1ZmZhOWRkY2RjMTRjOGJhZWM4ZWE1NjQwYjQ4ODQ0LnNldENvbnRlbnQoaHRtbF80NTg5MTI2OWY3NzY0YTFhYjQ3YjQyMjU5NDYzY2RjOSk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgbWFya2VyXzgyOWM4Mjk4MGQzYTQ1M2RhNmY1OGU4NTg5NDIzYjY5LmJpbmRQb3B1cChwb3B1cF8zNWZmYTlkZGNkYzE0YzhiYWVjOGVhNTY0MGI0ODg0NCkKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICB2YXIgbWFya2VyX2IwNGFlNDNmNjg1MjRlOTFhNDQwODUyOGE0NjM5Y2MzID0gTC5tYXJrZXIoCiAgICAgICAgICAgIFs0MS4xNTA5NTczOTk5OTk5OTYsIC04LjYwNTM2NDldLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl8zNzViMjA4OWM5MTg0YzhhYmQ0MDFhMDU0N2RmZTU1ZSA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAncmVkJywKICAgICAgICAgICAgICAgICAgICBwcmVmaXg6ICdnbHlwaGljb24nLAogICAgICAgICAgICAgICAgICAgIGV4dHJhQ2xhc3NlczogJ2ZhLXJvdGF0ZS0wJwogICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgbWFya2VyX2IwNGFlNDNmNjg1MjRlOTFhNDQwODUyOGE0NjM5Y2MzLnNldEljb24oaWNvbl8zNzViMjA4OWM5MTg0YzhhYmQ0MDFhMDU0N2RmZTU1ZSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF81MTAzMWVhM2M3ODM0YWE2OGVjNDA0MTQ3ZDg5YzI1NCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzljYzMzNmY0M2RmYzQwMTViMDg2NDRlOTEyNjU4ODQ0ID0gJChgPGRpdiBpZD0iaHRtbF85Y2MzMzZmNDNkZmM0MDE1YjA4NjQ0ZTkxMjY1ODg0NCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+UG9ydG8gQ2FjbzogMjAxNi0wNC0yMDwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfNTEwMzFlYTNjNzgzNGFhNjhlYzQwNDE0N2Q4OWMyNTQuc2V0Q29udGVudChodG1sXzljYzMzNmY0M2RmYzQwMTViMDg2NDRlOTEyNjU4ODQ0KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfYjA0YWU0M2Y2ODUyNGU5MWE0NDA4NTI4YTQ2MzljYzMuYmluZFBvcHVwKHBvcHVwXzUxMDMxZWEzYzc4MzRhYTY4ZWM0MDQxNDdkODljMjU0KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfNWI2ZDYyMDg0ZmE5NDI3N2JmZTg4ZmE4ODQ0ODZiODggPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE4MDQ4NzYsIC04LjMyMTY1MjQ5OTk5OTk5OV0sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzg0YmFmNTE2YWY4MTQ1OTdhMjY4MTU0MTljZTFlYmQ0ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdyZWQnLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfNWI2ZDYyMDg0ZmE5NDI3N2JmZTg4ZmE4ODQ0ODZiODguc2V0SWNvbihpY29uXzg0YmFmNTE2YWY4MTQ1OTdhMjY4MTU0MTljZTFlYmQ0KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzVhMzY2ZWM3ZTBmYjQ4NWM4NzJkMjVhMGNmNzc2Yjc3ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfY2JmMmQ2MTRiODBlNGQ5ODlhZWMzZDM1OTdhMDlmNTIgPSAkKGA8ZGl2IGlkPSJodG1sX2NiZjJkNjE0YjgwZTRkOTg5YWVjM2QzNTk3YTA5ZjUyIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5TYW50byBCdXJnYSBQb3J0bzogMjAxNy0wMy0zMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfNWEzNjZlYzdlMGZiNDg1Yzg3MmQyNWEwY2Y3NzZiNzcuc2V0Q29udGVudChodG1sX2NiZjJkNjE0YjgwZTRkOTg5YWVjM2QzNTk3YTA5ZjUyKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfNWI2ZDYyMDg0ZmE5NDI3N2JmZTg4ZmE4ODQ0ODZiODguYmluZFBvcHVwKHBvcHVwXzVhMzY2ZWM3ZTBmYjQ4NWM4NzJkMjVhMGNmNzc2Yjc3KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfZjUzYTNhMWE1YTY2NDYxMDlhYjgyZDM4NDA3Y2EyNzYgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE0NjIwMjksIC04LjYwNjU3NjczOTY5MzE0M10sCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIGljb246IG5ldyBMLkljb24uRGVmYXVsdCgpCiAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICkuYWRkVG8obWFwXzJiM2NlOWI1OTc2ODRhMDg4NmYzYjVjZDcyZjFmN2NiKTsKICAgICAgICAKICAgIAoKICAgICAgICAgICAgICAgIHZhciBpY29uXzU5MjU4YmQ5MjhkMTQ0ZTc4OTI2MjRmNDAzYWY4MTY2ID0gTC5Bd2Vzb21lTWFya2Vycy5pY29uKHsKICAgICAgICAgICAgICAgICAgICBpY29uOiAnaW5mby1zaWduJywKICAgICAgICAgICAgICAgICAgICBpY29uQ29sb3I6ICd3aGl0ZScsCiAgICAgICAgICAgICAgICAgICAgbWFya2VyQ29sb3I6ICdncmVlbicsCiAgICAgICAgICAgICAgICAgICAgcHJlZml4OiAnZ2x5cGhpY29uJywKICAgICAgICAgICAgICAgICAgICBleHRyYUNsYXNzZXM6ICdmYS1yb3RhdGUtMCcKICAgICAgICAgICAgICAgICAgICB9KTsKICAgICAgICAgICAgICAgIG1hcmtlcl9mNTNhM2ExYTVhNjY0NjEwOWFiODJkMzg0MDdjYTI3Ni5zZXRJY29uKGljb25fNTkyNThiZDkyOGQxNDRlNzg5MjYyNGY0MDNhZjgxNjYpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfNTc2OWI3ZjI1MzhiNGEzZWE5N2I4YzQ1NjNhYjU4ODQgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF82N2UxMDM0NzA2ODU0ZTBkYmJiYWYzNWI2YTY3MTUwYyA9ICQoYDxkaXYgaWQ9Imh0bWxfNjdlMTAzNDcwNjg1NGUwZGJiYmFmMzViNmE2NzE1MGMiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkhhbWJ1cmdhcmlhIGRhIFByYcOnYTogMjAxNS0wMS0wMTwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfNTc2OWI3ZjI1MzhiNGEzZWE5N2I4YzQ1NjNhYjU4ODQuc2V0Q29udGVudChodG1sXzY3ZTEwMzQ3MDY4NTRlMGRiYmJhZjM1YjZhNjcxNTBjKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBtYXJrZXJfZjUzYTNhMWE1YTY2NDYxMDlhYjgyZDM4NDA3Y2EyNzYuYmluZFBvcHVwKHBvcHVwXzU3NjliN2YyNTM4YjRhM2VhOTdiOGM0NTYzYWI1ODg0KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgIHZhciBtYXJrZXJfNjc1MzlkMWRhN2IyNGZhNjg3YmRkZWI5YTc1NjY4ZmEgPSBMLm1hcmtlcigKICAgICAgICAgICAgWzQxLjE0NDE1NDUsIC04LjYyMjg4MTFdLAogICAgICAgICAgICB7CiAgICAgICAgICAgICAgICBpY29uOiBuZXcgTC5JY29uLkRlZmF1bHQoKQogICAgICAgICAgICAgICAgfQogICAgICAgICAgICApLmFkZFRvKG1hcF8yYjNjZTliNTk3Njg0YTA4ODZmM2I1Y2Q3MmYxZjdjYik7CiAgICAgICAgCiAgICAKCiAgICAgICAgICAgICAgICB2YXIgaWNvbl8xZmZmNTVhOGNlYTc0MmQzOGE4OWYyNzAyNzRhZDAyYSA9IEwuQXdlc29tZU1hcmtlcnMuaWNvbih7CiAgICAgICAgICAgICAgICAgICAgaWNvbjogJ2luZm8tc2lnbicsCiAgICAgICAgICAgICAgICAgICAgaWNvbkNvbG9yOiAnd2hpdGUnLAogICAgICAgICAgICAgICAgICAgIG1hcmtlckNvbG9yOiAnZ3JlZW4nLAogICAgICAgICAgICAgICAgICAgIHByZWZpeDogJ2dseXBoaWNvbicsCiAgICAgICAgICAgICAgICAgICAgZXh0cmFDbGFzc2VzOiAnZmEtcm90YXRlLTAnCiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICBtYXJrZXJfNjc1MzlkMWRhN2IyNGZhNjg3YmRkZWI5YTc1NjY4ZmEuc2V0SWNvbihpY29uXzFmZmY1NWE4Y2VhNzQyZDM4YTg5ZjI3MDI3NGFkMDJhKTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2Y4NDVjYTc2ZDY1YTRjMTc5MTFiZmRhMDE2MTViNzI5ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfYzkzOWI5NDA3OWM2NGIwZDkwMjBlMDIwZGJiNTg3MDkgPSAkKGA8ZGl2IGlkPSJodG1sX2M5MzliOTQwNzljNjRiMGQ5MDIwZTAyMGRiYjU4NzA5IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5CdXJndWVyIFJhbmNoOiAyMDE1LTAxLTAxPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9mODQ1Y2E3NmQ2NWE0YzE3OTExYmZkYTAxNjE1YjcyOS5zZXRDb250ZW50KGh0bWxfYzkzOWI5NDA3OWM2NGIwZDkwMjBlMDIwZGJiNTg3MDkpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIG1hcmtlcl82NzUzOWQxZGE3YjI0ZmE2ODdiZGRlYjlhNzU2NjhmYS5iaW5kUG9wdXAocG9wdXBfZjg0NWNhNzZkNjVhNGMxNzkxMWJmZGEwMTYxNWI3MjkpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAo8L3NjcmlwdD4=\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x7f70368e6ef0>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# retirar entradas sem coordenadas\n",
    "df = df.dropna(subset=['lat'])\n",
    "\n",
    "# Vamos colocar os dados no mapa. \n",
    "m = folium.Map(location=[41.15134, -8.61477], zoom_start=14, tiles=\"stamentoner\")\n",
    "\n",
    "for index, row in df.iterrows():\n",
    "    lat = float(row['lat'])\n",
    "    lon = float(row['lon'])\n",
    "    popup = row['nome'].replace(\"'\", \"&apos;\") + ': ' + row['data_abertura']\n",
    "    year = row['data_abertura'].split('-')[0]\n",
    "    if int(year) > 2015:\n",
    "        color = 'red'\n",
    "    else:        \n",
    "        color = 'green'\n",
    "    folium.Marker([lat, lon], popup=popup, icon=folium.Icon(color=color)).add_to(m)\n",
    "\n",
    "m"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}