Text2SQL_Photon.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fcW9z1H_axZI"
      },
      "source": [
        "Setup Scripts"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_0xpzR5AbIOn"
      },
      "source": [
        "# **Wrap Scripts**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qTW5fu9L0AoY",
        "outputId": "94814371-e6ff-4de7-add7-1493a48150b8"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Cloning into 'TabularSemanticParsing'...\n",
            "remote: Enumerating objects: 422, done.\u001b[K\n",
            "remote: Counting objects: 100% (3/3), done.\u001b[K\n",
            "remote: Compressing objects: 100% (3/3), done.\u001b[K\n",
            "remote: Total 422 (delta 0), reused 0 (delta 0), pack-reused 419\u001b[K\n",
            "Receiving objects: 100% (422/422), 1.12 MiB | 17.19 MiB/s, done.\n",
            "Resolving deltas: 100% (224/224), done.\n",
            "/content/TabularSemanticParsing\n",
            "Requirement already satisfied: torch in /usr/local/lib/python3.7/dist-packages (1.10.0+cu111)\n",
            "Requirement already satisfied: torchvision in /usr/local/lib/python3.7/dist-packages (0.11.1+cu111)\n",
            "Requirement already satisfied: typing-extensions in /usr/local/lib/python3.7/dist-packages (from torch) (3.10.0.2)\n",
            "Requirement already satisfied: pillow!=8.3.0,>=5.3.0 in /usr/local/lib/python3.7/dist-packages (from torchvision) (7.1.2)\n",
            "Requirement already satisfied: numpy in /usr/local/lib/python3.7/dist-packages (from torchvision) (1.19.5)\n",
            "Collecting revtok==0.0.3\n",
            "  Downloading revtok-0.0.3-py3-none-any.whl (4.3 kB)\n",
            "Collecting tqdm==4.27\n",
            "  Downloading tqdm-4.27.0-py2.py3-none-any.whl (44 kB)\n",
            "\u001b[K     |████████████████████████████████| 44 kB 1.9 MB/s \n",
            "\u001b[?25hCollecting torchvision==0.2.1\n",
            "  Downloading torchvision-0.2.1-py2.py3-none-any.whl (54 kB)\n",
            "\u001b[K     |████████████████████████████████| 54 kB 3.4 MB/s \n",
            "\u001b[?25hCollecting mo-future>=2.20\n",
            "  Downloading mo-future-6.2.21303.tar.gz (10 kB)\n",
            "Collecting pyparsing==2.3.0\n",
            "  Downloading pyparsing-2.3.0-py2.py3-none-any.whl (59 kB)\n",
            "\u001b[K     |████████████████████████████████| 59 kB 8.0 MB/s \n",
            "\u001b[?25hCollecting wandb==0.8.30\n",
            "  Downloading wandb-0.8.30-py2.py3-none-any.whl (1.4 MB)\n",
            "\u001b[K     |████████████████████████████████| 1.4 MB 68.1 MB/s \n",
            "\u001b[?25hCollecting n2w\n",
            "  Downloading n2w-0.1.3.tar.gz (1.6 kB)\n",
            "Collecting matplotlib==3.0.2\n",
            "  Downloading matplotlib-3.0.2-cp37-cp37m-manylinux1_x86_64.whl (12.9 MB)\n",
            "\u001b[K     |████████████████████████████████| 12.9 MB 31.9 MB/s \n",
            "\u001b[?25hCollecting transformers==2.8.0\n",
            "  Downloading transformers-2.8.0-py3-none-any.whl (563 kB)\n",
            "\u001b[K     |████████████████████████████████| 563 kB 36.5 MB/s \n",
            "\u001b[?25hCollecting asciitree\n",
            "  Downloading asciitree-0.3.3.tar.gz (4.0 kB)\n",
            "Collecting apex\n",
            "  Downloading apex-0.9.10dev.tar.gz (36 kB)\n",
            "Collecting nltk==3.4.5\n",
            "  Downloading nltk-3.4.5.zip (1.5 MB)\n",
            "\u001b[K     |████████████████████████████████| 1.5 MB 60.8 MB/s \n",
            "\u001b[?25hCollecting rapidfuzz==0.9.1\n",
            "  Downloading rapidfuzz-0.9.1-cp37-cp37m-manylinux2010_x86_64.whl (2.0 MB)\n",
            "\u001b[K     |████████████████████████████████| 2.0 MB 51.1 MB/s \n",
            "\u001b[?25hCollecting records\n",
            "  Downloading records-0.5.3-py2.py3-none-any.whl (10 kB)\n",
            "Requirement already satisfied: babel in /usr/local/lib/python3.7/dist-packages (from -r requirements.txt (line 17)) (2.9.1)\n",
            "Requirement already satisfied: tabulate in /usr/local/lib/python3.7/dist-packages (from -r requirements.txt (line 18)) (0.8.9)\n",
            "Requirement already satisfied: scipy in /usr/local/lib/python3.7/dist-packages (from -r requirements.txt (line 19)) (1.4.1)\n",
            "Collecting sqlalchemy==1.3.20\n",
            "  Downloading SQLAlchemy-1.3.20-cp37-cp37m-manylinux2010_x86_64.whl (1.3 MB)\n",
            "\u001b[K     |████████████████████████████████| 1.3 MB 52.4 MB/s \n",
            "\u001b[?25hRequirement already satisfied: torch in /usr/local/lib/python3.7/dist-packages (from torchvision==0.2.1->-r requirements.txt (line 3)) (1.10.0+cu111)\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.7/dist-packages (from torchvision==0.2.1->-r requirements.txt (line 3)) (1.15.0)\n",
            "Requirement already satisfied: pillow>=4.1.1 in /usr/local/lib/python3.7/dist-packages (from torchvision==0.2.1->-r requirements.txt (line 3)) (7.1.2)\n",
            "Requirement already satisfied: numpy in /usr/local/lib/python3.7/dist-packages (from torchvision==0.2.1->-r requirements.txt (line 3)) (1.19.5)\n",
            "Collecting docker-pycreds>=0.4.0\n",
            "  Downloading docker_pycreds-0.4.0-py2.py3-none-any.whl (9.0 kB)\n",
            "Requirement already satisfied: nvidia-ml-py3>=7.352.0 in /usr/local/lib/python3.7/dist-packages (from wandb==0.8.30->-r requirements.txt (line 6)) (7.352.0)\n",
            "Collecting GitPython>=1.0.0\n",
            "  Downloading GitPython-3.1.24-py3-none-any.whl (180 kB)\n",
            "\u001b[K     |████████████████████████████████| 180 kB 52.7 MB/s \n",
            "\u001b[?25hCollecting sentry-sdk>=0.4.0\n",
            "  Downloading sentry_sdk-1.5.1-py2.py3-none-any.whl (140 kB)\n",
            "\u001b[K     |████████████████████████████████| 140 kB 73.5 MB/s \n",
            "\u001b[?25hCollecting configparser>=3.8.1\n",
            "  Downloading configparser-5.2.0-py3-none-any.whl (19 kB)\n",
            "Requirement already satisfied: python-dateutil>=2.6.1 in /usr/local/lib/python3.7/dist-packages (from wandb==0.8.30->-r requirements.txt (line 6)) (2.8.2)\n",
            "Requirement already satisfied: Click>=7.0 in /usr/local/lib/python3.7/dist-packages (from wandb==0.8.30->-r requirements.txt (line 6)) (7.1.2)\n",
            "Requirement already satisfied: requests>=2.0.0 in /usr/local/lib/python3.7/dist-packages (from wandb==0.8.30->-r requirements.txt (line 6)) (2.23.0)\n",
            "Requirement already satisfied: psutil>=5.0.0 in /usr/local/lib/python3.7/dist-packages (from wandb==0.8.30->-r requirements.txt (line 6)) (5.4.8)\n",
            "Collecting watchdog>=0.8.3\n",
            "  Downloading watchdog-2.1.6-py3-none-manylinux2014_x86_64.whl (76 kB)\n",
            "\u001b[K     |████████████████████████████████| 76 kB 6.5 MB/s \n",
            "\u001b[?25hRequirement already satisfied: PyYAML>=3.10 in /usr/local/lib/python3.7/dist-packages (from wandb==0.8.30->-r requirements.txt (line 6)) (3.13)\n",
            "Collecting gql==0.2.0\n",
            "  Downloading gql-0.2.0.tar.gz (18 kB)\n",
            "Collecting subprocess32>=3.5.3\n",
            "  Downloading subprocess32-3.5.4.tar.gz (97 kB)\n",
            "\u001b[K     |████████████████████████████████| 97 kB 9.1 MB/s \n",
            "\u001b[?25hCollecting shortuuid>=0.5.0\n",
            "  Downloading shortuuid-1.0.8-py3-none-any.whl (9.5 kB)\n",
            "Requirement already satisfied: kiwisolver>=1.0.1 in /usr/local/lib/python3.7/dist-packages (from matplotlib==3.0.2->-r requirements.txt (line 8)) (1.3.2)\n",
            "Requirement already satisfied: cycler>=0.10 in /usr/local/lib/python3.7/dist-packages (from matplotlib==3.0.2->-r requirements.txt (line 8)) (0.11.0)\n",
            "Requirement already satisfied: filelock in /usr/local/lib/python3.7/dist-packages (from transformers==2.8.0->-r requirements.txt (line 9)) (3.4.0)\n",
            "Collecting sentencepiece\n",
            "  Downloading sentencepiece-0.1.96-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.2 MB)\n",
            "\u001b[K     |████████████████████████████████| 1.2 MB 69.0 MB/s \n",
            "\u001b[?25hCollecting tokenizers==0.5.2\n",
            "  Downloading tokenizers-0.5.2-cp37-cp37m-manylinux1_x86_64.whl (5.6 MB)\n",
            "\u001b[K     |████████████████████████████████| 5.6 MB 61.2 MB/s \n",
            "\u001b[?25hCollecting sacremoses\n",
            "  Downloading sacremoses-0.0.46-py3-none-any.whl (895 kB)\n",
            "\u001b[K     |████████████████████████████████| 895 kB 52.3 MB/s \n",
            "\u001b[?25hCollecting boto3\n",
            "  Downloading boto3-1.20.26-py3-none-any.whl (131 kB)\n",
            "\u001b[K     |████████████████████████████████| 131 kB 73.2 MB/s \n",
            "\u001b[?25hRequirement already satisfied: regex!=2019.12.17 in /usr/local/lib/python3.7/dist-packages (from transformers==2.8.0->-r requirements.txt (line 9)) (2019.12.20)\n",
            "Collecting graphql-core<2,>=0.5.0\n",
            "  Downloading graphql-core-1.1.tar.gz (70 kB)\n",
            "\u001b[K     |████████████████████████████████| 70 kB 9.4 MB/s \n",
            "\u001b[?25hRequirement already satisfied: promise<3,>=2.0 in /usr/local/lib/python3.7/dist-packages (from gql==0.2.0->wandb==0.8.30->-r requirements.txt (line 6)) (2.3)\n",
            "Requirement already satisfied: typing-extensions>=3.7.4.3 in /usr/local/lib/python3.7/dist-packages (from GitPython>=1.0.0->wandb==0.8.30->-r requirements.txt (line 6)) (3.10.0.2)\n",
            "Collecting gitdb<5,>=4.0.1\n",
            "  Downloading gitdb-4.0.9-py3-none-any.whl (63 kB)\n",
            "\u001b[K     |████████████████████████████████| 63 kB 2.2 MB/s \n",
            "\u001b[?25hCollecting smmap<6,>=3.0.1\n",
            "  Downloading smmap-5.0.0-py3-none-any.whl (24 kB)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests>=2.0.0->wandb==0.8.30->-r requirements.txt (line 6)) (2.10)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests>=2.0.0->wandb==0.8.30->-r requirements.txt (line 6)) (1.24.3)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests>=2.0.0->wandb==0.8.30->-r requirements.txt (line 6)) (3.0.4)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests>=2.0.0->wandb==0.8.30->-r requirements.txt (line 6)) (2021.10.8)\n",
            "Requirement already satisfied: markdown in /usr/local/lib/python3.7/dist-packages (from n2w->-r requirements.txt (line 7)) (3.3.6)\n",
            "Collecting cryptacular\n",
            "  Downloading cryptacular-1.6.2.tar.gz (75 kB)\n",
            "\u001b[K     |████████████████████████████████| 75 kB 5.5 MB/s \n",
            "\u001b[?25h  Installing build dependencies ... \u001b[?25l\u001b[?25hdone\n",
            "  Getting requirements to build wheel ... \u001b[?25l\u001b[?25hdone\n",
            "    Preparing wheel metadata ... \u001b[?25l\u001b[?25hdone\n",
            "Collecting zope.sqlalchemy\n",
            "  Downloading zope.sqlalchemy-1.6-py2.py3-none-any.whl (22 kB)\n",
            "Collecting velruse>=1.0.3\n",
            "  Downloading velruse-1.1.1.tar.gz (709 kB)\n",
            "\u001b[K     |████████████████████████████████| 709 kB 69.0 MB/s \n",
            "\u001b[?25hCollecting pyramid>1.1.2\n",
            "  Downloading pyramid-2.0-py3-none-any.whl (246 kB)\n",
            "\u001b[K     |████████████████████████████████| 246 kB 66.6 MB/s \n",
            "\u001b[?25hCollecting pyramid_mailer\n",
            "  Downloading pyramid_mailer-0.15.1-py2.py3-none-any.whl (19 kB)\n",
            "Collecting wtforms\n",
            "  Downloading WTForms-3.0.0-py3-none-any.whl (136 kB)\n",
            "\u001b[K     |████████████████████████████████| 136 kB 79.1 MB/s \n",
            "\u001b[?25hCollecting wtforms-recaptcha\n",
            "  Downloading wtforms_recaptcha-0.3.2-py2.py3-none-any.whl (7.5 kB)\n",
            "Collecting hupper>=1.5\n",
            "  Downloading hupper-1.10.3-py2.py3-none-any.whl (26 kB)\n",
            "Collecting plaster-pastedeploy\n",
            "  Downloading plaster_pastedeploy-0.7-py2.py3-none-any.whl (7.8 kB)\n",
            "Collecting venusian>=1.0\n",
            "  Downloading venusian-3.0.0-py3-none-any.whl (13 kB)\n",
            "Collecting zope.deprecation>=3.5.0\n",
            "  Downloading zope.deprecation-4.4.0-py2.py3-none-any.whl (10 kB)\n",
            "Collecting plaster\n",
            "  Downloading plaster-1.0-py2.py3-none-any.whl (14 kB)\n",
            "Requirement already satisfied: setuptools in /usr/local/lib/python3.7/dist-packages (from pyramid>1.1.2->apex->-r requirements.txt (line 11)) (57.4.0)\n",
            "Collecting zope.interface>=3.8.0\n",
            "  Downloading zope.interface-5.4.0-cp37-cp37m-manylinux2010_x86_64.whl (251 kB)\n",
            "\u001b[K     |████████████████████████████████| 251 kB 73.7 MB/s \n",
            "\u001b[?25hCollecting translationstring>=0.4\n",
            "  Downloading translationstring-1.4-py2.py3-none-any.whl (15 kB)\n",
            "Collecting webob>=1.8.3\n",
            "  Downloading WebOb-1.8.7-py2.py3-none-any.whl (114 kB)\n",
            "\u001b[K     |████████████████████████████████| 114 kB 57.5 MB/s \n",
            "\u001b[?25hRequirement already satisfied: requests-oauthlib in /usr/local/lib/python3.7/dist-packages (from velruse>=1.0.3->apex->-r requirements.txt (line 11)) (1.3.0)\n",
            "Collecting anykeystore\n",
            "  Downloading anykeystore-0.2.tar.gz (10 kB)\n",
            "Collecting python3-openid\n",
            "  Downloading python3_openid-3.2.0-py3-none-any.whl (133 kB)\n",
            "\u001b[K     |████████████████████████████████| 133 kB 60.6 MB/s \n",
            "\u001b[?25hCollecting openpyxl<2.5.0\n",
            "  Downloading openpyxl-2.4.11.tar.gz (158 kB)\n",
            "\u001b[K     |████████████████████████████████| 158 kB 76.5 MB/s \n",
            "\u001b[?25hCollecting tablib>=0.11.4\n",
            "  Downloading tablib-3.1.0-py3-none-any.whl (48 kB)\n",
            "\u001b[K     |████████████████████████████████| 48 kB 7.0 MB/s \n",
            "\u001b[?25hRequirement already satisfied: docopt in /usr/local/lib/python3.7/dist-packages (from records->-r requirements.txt (line 16)) (0.6.2)\n",
            "Requirement already satisfied: jdcal in /usr/local/lib/python3.7/dist-packages (from openpyxl<2.5.0->records->-r requirements.txt (line 16)) (1.4.1)\n",
            "Requirement already satisfied: et_xmlfile in /usr/local/lib/python3.7/dist-packages (from openpyxl<2.5.0->records->-r requirements.txt (line 16)) (1.1.0)\n",
            "Requirement already satisfied: pytz>=2015.7 in /usr/local/lib/python3.7/dist-packages (from babel->-r requirements.txt (line 17)) (2018.9)\n",
            "Collecting jmespath<1.0.0,>=0.7.1\n",
            "  Downloading jmespath-0.10.0-py2.py3-none-any.whl (24 kB)\n",
            "Collecting s3transfer<0.6.0,>=0.5.0\n",
            "  Downloading s3transfer-0.5.0-py3-none-any.whl (79 kB)\n",
            "\u001b[K     |████████████████████████████████| 79 kB 10.5 MB/s \n",
            "\u001b[?25hCollecting botocore<1.24.0,>=1.23.26\n",
            "  Downloading botocore-1.23.26-py3-none-any.whl (8.5 MB)\n",
            "\u001b[K     |████████████████████████████████| 8.5 MB 57.6 MB/s \n",
            "\u001b[?25hCollecting urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1\n",
            "  Downloading urllib3-1.25.11-py2.py3-none-any.whl (127 kB)\n",
            "\u001b[K     |████████████████████████████████| 127 kB 73.3 MB/s \n",
            "\u001b[?25hCollecting pbkdf2\n",
            "  Downloading pbkdf2-1.3.tar.gz (6.4 kB)\n",
            "Requirement already satisfied: importlib-metadata>=4.4 in /usr/local/lib/python3.7/dist-packages (from markdown->n2w->-r requirements.txt (line 7)) (4.8.2)\n",
            "Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.7/dist-packages (from importlib-metadata>=4.4->markdown->n2w->-r requirements.txt (line 7)) (3.6.0)\n",
            "Collecting PasteDeploy>=2.0\n",
            "  Downloading PasteDeploy-2.1.1-py2.py3-none-any.whl (17 kB)\n",
            "Collecting repoze.sendmail>=4.1\n",
            "  Downloading repoze.sendmail-4.4.1-py2.py3-none-any.whl (41 kB)\n",
            "\u001b[K     |████████████████████████████████| 41 kB 47 kB/s \n",
            "\u001b[?25hCollecting transaction\n",
            "  Downloading transaction-3.0.1-py2.py3-none-any.whl (47 kB)\n",
            "\u001b[K     |████████████████████████████████| 47 kB 6.2 MB/s \n",
            "\u001b[?25hRequirement already satisfied: defusedxml in /usr/local/lib/python3.7/dist-packages (from python3-openid->velruse>=1.0.3->apex->-r requirements.txt (line 11)) (0.7.1)\n",
            "Requirement already satisfied: oauthlib>=3.0.0 in /usr/local/lib/python3.7/dist-packages (from requests-oauthlib->velruse>=1.0.3->apex->-r requirements.txt (line 11)) (3.1.1)\n",
            "Requirement already satisfied: joblib in /usr/local/lib/python3.7/dist-packages (from sacremoses->transformers==2.8.0->-r requirements.txt (line 9)) (1.1.0)\n",
            "Requirement already satisfied: MarkupSafe in /usr/local/lib/python3.7/dist-packages (from wtforms->apex->-r requirements.txt (line 11)) (2.0.1)\n",
            "Building wheels for collected packages: nltk, gql, mo-future, graphql-core, subprocess32, n2w, asciitree, apex, velruse, openpyxl, anykeystore, cryptacular, pbkdf2\n",
            "  Building wheel for nltk (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for nltk: filename=nltk-3.4.5-py3-none-any.whl size=1449920 sha256=5db18a2c478d1865aad3a2c2a358d695884c18c701f79fb861638b7390060a2a\n",
            "  Stored in directory: /root/.cache/pip/wheels/48/8b/7f/473521e0c731c6566d631b281f323842bbda9bd819eb9a3ead\n",
            "  Building wheel for gql (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for gql: filename=gql-0.2.0-py3-none-any.whl size=7639 sha256=9171865d9e7a1f2b1da78577e93e71b8d90c1cf0d6477a963c4ef304a7aadb4e\n",
            "  Stored in directory: /root/.cache/pip/wheels/b6/9a/56/5456fd32264a8fc53eefcb2f74e24e99a7ef4eb40a9af5c905\n",
            "  Building wheel for mo-future (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for mo-future: filename=mo_future-6.2.21303-py3-none-any.whl size=11616 sha256=8e9fd16d0d9492281e897e93aaef3cab477775f7556041f42f535362e3431b45\n",
            "  Stored in directory: /root/.cache/pip/wheels/a4/4a/5f/7143ccc62d5c3bfdc7eca57796e4e5cf632ad750a3dc8e1f34\n",
            "  Building wheel for graphql-core (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for graphql-core: filename=graphql_core-1.1-py3-none-any.whl size=104649 sha256=cb1dfff1f6243a5c2a3d3ea6cebc34ea3cde6c265d29977de99aa5e05a197abc\n",
            "  Stored in directory: /root/.cache/pip/wheels/6b/fd/8c/a20dd591c1a554070cc33fb58042867e6ac1c85395abe2e57a\n",
            "  Building wheel for subprocess32 (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for subprocess32: filename=subprocess32-3.5.4-py3-none-any.whl size=6502 sha256=b360121cd8aa509db6008fbbfa8fc6d9b8130ce72a1b84ec47f2e162a79c3a1e\n",
            "  Stored in directory: /root/.cache/pip/wheels/50/ca/fa/8fca8d246e64f19488d07567547ddec8eb084e8c0d7a59226a\n",
            "  Building wheel for n2w (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for n2w: filename=n2w-0.1.3-py3-none-any.whl size=2616 sha256=fbcbfe4b56c641742b4c962f1a055e09a6c9e78a05496d622825b933984d7e8d\n",
            "  Stored in directory: /root/.cache/pip/wheels/85/5d/cf/5f4b9e790c93237040b543640d18421ed1743365e5290b36d1\n",
            "  Building wheel for asciitree (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for asciitree: filename=asciitree-0.3.3-py3-none-any.whl size=5051 sha256=688bbf66a9586d46d2bcb8d2389ace85ff601691ee424cc21864539f1b0509e2\n",
            "  Stored in directory: /root/.cache/pip/wheels/12/1c/38/0def51e15add93bff3f4bf9c248b94db0839b980b8535e72a0\n",
            "  Building wheel for apex (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for apex: filename=apex-0.9.10.dev0-py3-none-any.whl size=46466 sha256=739ea519b7abbf31425e0397d320e81dae86b6543f495fe42f94554c9030f5df\n",
            "  Stored in directory: /root/.cache/pip/wheels/f0/00/2b/37b6028388b451bbd30230c62f5238aef3b11fdff9503138bc\n",
            "  Building wheel for velruse (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for velruse: filename=velruse-1.1.1-py3-none-any.whl size=50937 sha256=4c616d034214469d12b499d1699c22ce58f730ea3a2758d4315d30b6c5f7046f\n",
            "  Stored in directory: /root/.cache/pip/wheels/61/f0/95/7f8b3bb1cce5c78ca7a7922cf72383f886f70e358f0a18d60b\n",
            "  Building wheel for openpyxl (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for openpyxl: filename=openpyxl-2.4.11-py2.py3-none-any.whl size=222839 sha256=28e5e1102fdba6fcc9d643e3c2245475315c0e85e6f5529ca6440463262f07bf\n",
            "  Stored in directory: /root/.cache/pip/wheels/ee/c3/67/b0c36cbd1242ea70054d400cad5192f02728eb67014192fd85\n",
            "  Building wheel for anykeystore (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for anykeystore: filename=anykeystore-0.2-py3-none-any.whl size=17042 sha256=bd5a380388fa1287f8f42deaedc1a62b505effd2cf6f3b3f82fe0ec0c4e120c8\n",
            "  Stored in directory: /root/.cache/pip/wheels/12/14/12/afad2dc2b7ea0884e12f260b0723b49b98f39f08adb7b0414f\n",
            "  Building wheel for cryptacular (PEP 517) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for cryptacular: filename=cryptacular-1.6.2-cp37-cp37m-linux_x86_64.whl size=54543 sha256=f575ab66f1bf92af4d6dbb271a61fe92ace0e474d4485bf5e0971d3c8e569e74\n",
            "  Stored in directory: /root/.cache/pip/wheels/fc/e8/c2/4b71f45f434136d31df930960b8a916bb36ebe2144479a37a1\n",
            "  Building wheel for pbkdf2 (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Created wheel for pbkdf2: filename=pbkdf2-1.3-py3-none-any.whl size=5103 sha256=6651a87a9b469d022f0f472a1316ac3b9e35b3cd77fae5e2a1c190fb245ed090\n",
            "  Stored in directory: /root/.cache/pip/wheels/49/16/ea/daca297d70ee0782ac6e16e83b2c55b2ca42a2113750bc0489\n",
            "Successfully built nltk gql mo-future graphql-core subprocess32 n2w asciitree apex velruse openpyxl anykeystore cryptacular pbkdf2\n",
            "Installing collected packages: zope.interface, urllib3, plaster, PasteDeploy, jmespath, zope.deprecation, webob, venusian, translationstring, transaction, smmap, plaster-pastedeploy, hupper, botocore, wtforms, tqdm, sqlalchemy, s3transfer, repoze.sendmail, python3-openid, pyramid, pbkdf2, graphql-core, gitdb, anykeystore, zope.sqlalchemy, wtforms-recaptcha, watchdog, velruse, tokenizers, tablib, subprocess32, shortuuid, sentry-sdk, sentencepiece, sacremoses, pyramid-mailer, pyparsing, openpyxl, gql, GitPython, docker-pycreds, cryptacular, configparser, boto3, wandb, transformers, torchvision, revtok, records, rapidfuzz, nltk, n2w, mo-future, matplotlib, asciitree, apex\n",
            "  Attempting uninstall: urllib3\n",
            "    Found existing installation: urllib3 1.24.3\n",
            "    Uninstalling urllib3-1.24.3:\n",
            "      Successfully uninstalled urllib3-1.24.3\n",
            "  Attempting uninstall: tqdm\n",
            "    Found existing installation: tqdm 4.62.3\n",
            "    Uninstalling tqdm-4.62.3:\n",
            "      Successfully uninstalled tqdm-4.62.3\n",
            "  Attempting uninstall: sqlalchemy\n",
            "    Found existing installation: SQLAlchemy 1.4.27\n",
            "    Uninstalling SQLAlchemy-1.4.27:\n",
            "      Successfully uninstalled SQLAlchemy-1.4.27\n",
            "  Attempting uninstall: pyparsing\n",
            "    Found existing installation: pyparsing 3.0.6\n",
            "    Uninstalling pyparsing-3.0.6:\n",
            "      Successfully uninstalled pyparsing-3.0.6\n",
            "  Attempting uninstall: openpyxl\n",
            "    Found existing installation: openpyxl 2.5.9\n",
            "    Uninstalling openpyxl-2.5.9:\n",
            "      Successfully uninstalled openpyxl-2.5.9\n",
            "  Attempting uninstall: torchvision\n",
            "    Found existing installation: torchvision 0.11.1+cu111\n",
            "    Uninstalling torchvision-0.11.1+cu111:\n",
            "      Successfully uninstalled torchvision-0.11.1+cu111\n",
            "  Attempting uninstall: nltk\n",
            "    Found existing installation: nltk 3.2.5\n",
            "    Uninstalling nltk-3.2.5:\n",
            "      Successfully uninstalled nltk-3.2.5\n",
            "  Attempting uninstall: matplotlib\n",
            "    Found existing installation: matplotlib 3.2.2\n",
            "    Uninstalling matplotlib-3.2.2:\n",
            "      Successfully uninstalled matplotlib-3.2.2\n",
            "\u001b[31mERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.\n",
            "spacy 2.2.4 requires tqdm<5.0.0,>=4.38.0, but you have tqdm 4.27.0 which is incompatible.\n",
            "plotnine 0.6.0 requires matplotlib>=3.1.1, but you have matplotlib 3.0.2 which is incompatible.\n",
            "panel 0.12.1 requires tqdm>=4.48.0, but you have tqdm 4.27.0 which is incompatible.\n",
            "mizani 0.6.0 requires matplotlib>=3.1.1, but you have matplotlib 3.0.2 which is incompatible.\n",
            "fbprophet 0.7.1 requires tqdm>=4.36.1, but you have tqdm 4.27.0 which is incompatible.\n",
            "datascience 0.10.6 requires folium==0.2.1, but you have folium 0.8.3 which is incompatible.\n",
            "albumentations 0.1.12 requires imgaug<0.2.7,>=0.2.5, but you have imgaug 0.2.9 which is incompatible.\u001b[0m\n",
            "Successfully installed GitPython-3.1.24 PasteDeploy-2.1.1 anykeystore-0.2 apex-0.9.10.dev0 asciitree-0.3.3 boto3-1.20.26 botocore-1.23.26 configparser-5.2.0 cryptacular-1.6.2 docker-pycreds-0.4.0 gitdb-4.0.9 gql-0.2.0 graphql-core-1.1 hupper-1.10.3 jmespath-0.10.0 matplotlib-3.0.2 mo-future-6.2.21303 n2w-0.1.3 nltk-3.4.5 openpyxl-2.4.11 pbkdf2-1.3 plaster-1.0 plaster-pastedeploy-0.7 pyparsing-2.3.0 pyramid-2.0 pyramid-mailer-0.15.1 python3-openid-3.2.0 rapidfuzz-0.9.1 records-0.5.3 repoze.sendmail-4.4.1 revtok-0.0.3 s3transfer-0.5.0 sacremoses-0.0.46 sentencepiece-0.1.96 sentry-sdk-1.5.1 shortuuid-1.0.8 smmap-5.0.0 sqlalchemy-1.3.20 subprocess32-3.5.4 tablib-3.1.0 tokenizers-0.5.2 torchvision-0.2.1 tqdm-4.27.0 transaction-3.0.1 transformers-2.8.0 translationstring-1.4 urllib3-1.25.11 velruse-1.1.1 venusian-3.0.0 wandb-0.8.30 watchdog-2.1.6 webob-1.8.7 wtforms-3.0.0 wtforms-recaptcha-0.3.2 zope.deprecation-4.4.0 zope.interface-5.4.0 zope.sqlalchemy-1.6\n",
            "Collecting flask-ngrok\n",
            "  Downloading flask_ngrok-0.0.25-py3-none-any.whl (3.1 kB)\n",
            "Requirement already satisfied: requests in /usr/local/lib/python3.7/dist-packages (from flask-ngrok) (2.23.0)\n",
            "Requirement already satisfied: Flask>=0.8 in /usr/local/lib/python3.7/dist-packages (from flask-ngrok) (1.1.4)\n",
            "Requirement already satisfied: itsdangerous<2.0,>=0.24 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.8->flask-ngrok) (1.1.0)\n",
            "Requirement already satisfied: click<8.0,>=5.1 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.8->flask-ngrok) (7.1.2)\n",
            "Requirement already satisfied: Werkzeug<2.0,>=0.15 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.8->flask-ngrok) (1.0.1)\n",
            "Requirement already satisfied: Jinja2<3.0,>=2.10.1 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.8->flask-ngrok) (2.11.3)\n",
            "Requirement already satisfied: MarkupSafe>=0.23 in /usr/local/lib/python3.7/dist-packages (from Jinja2<3.0,>=2.10.1->Flask>=0.8->flask-ngrok) (2.0.1)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests->flask-ngrok) (3.0.4)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests->flask-ngrok) (2.10)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests->flask-ngrok) (2021.10.8)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests->flask-ngrok) (1.25.11)\n",
            "Installing collected packages: flask-ngrok\n",
            "Successfully installed flask-ngrok-0.0.25\n",
            "Collecting flask==0.12.2\n",
            "  Downloading Flask-0.12.2-py2.py3-none-any.whl (83 kB)\n",
            "\u001b[K     |████████████████████████████████| 83 kB 1.5 MB/s \n",
            "\u001b[?25hRequirement already satisfied: click>=2.0 in /usr/local/lib/python3.7/dist-packages (from flask==0.12.2) (7.1.2)\n",
            "Requirement already satisfied: itsdangerous>=0.21 in /usr/local/lib/python3.7/dist-packages (from flask==0.12.2) (1.1.0)\n",
            "Requirement already satisfied: Werkzeug>=0.7 in /usr/local/lib/python3.7/dist-packages (from flask==0.12.2) (1.0.1)\n",
            "Requirement already satisfied: Jinja2>=2.4 in /usr/local/lib/python3.7/dist-packages (from flask==0.12.2) (2.11.3)\n",
            "Requirement already satisfied: MarkupSafe>=0.23 in /usr/local/lib/python3.7/dist-packages (from Jinja2>=2.4->flask==0.12.2) (2.0.1)\n",
            "Installing collected packages: flask\n",
            "  Attempting uninstall: flask\n",
            "    Found existing installation: Flask 1.1.4\n",
            "    Uninstalling Flask-1.1.4:\n",
            "      Successfully uninstalled Flask-1.1.4\n",
            "Successfully installed flask-0.12.2\n",
            "/usr/lib/python3.7/runpy.py:125: RuntimeWarning: 'nltk.downloader' found in sys.modules after import of package 'nltk', but prior to execution of 'nltk.downloader'; this may result in unpredictable behaviour\n",
            "  warn(RuntimeWarning(msg))\n",
            "[nltk_data] Downloading package punkt to /root/nltk_data...\n",
            "[nltk_data]   Unzipping tokenizers/punkt.zip.\n",
            "Downloading...\n",
            "From: https://drive.google.com/uc?id=1dlrUdGMLvvvfR3kNVy76H12rR7gr4DXI\n",
            "To: /content/TabularSemanticParsing/bridge-spider-bert-large-ems-70-1-exe-68-2.tar.gz\n",
            "100% 3.59G/3.59G [00:28<00:00, 127MB/s]\n",
            "Downloading...\n",
            "From: https://drive.google.com/uc?id=1vk14iR4V_f5x4e17MAaL_L8T9wgjcKCy\n",
            "To: /content/TabularSemanticParsing/dev.eo.pred.restored.pkl.gz\n",
            "100% 192M/192M [00:00<00:00, 202MB/s]\n"
          ]
        }
      ],
      "source": [
        "\n",
        "! git clone https://github.com/salesforce/TabularSemanticParsing\n",
        "%cd TabularSemanticParsing\n",
        "\n",
        "! pip install torch torchvision\n",
        "! python3 -m pip install -r requirements.txt\n",
        "! pip install flask-ngrok\n",
        "! pip install flask==0.12.2\n",
        "\n",
        "! export PYTHONPATH=`pwd` && python -m nltk.downloader punkt\n",
        "\n",
        "! mkdir model\n",
        "\n",
        "! gdown https://drive.google.com/uc?id=1dlrUdGMLvvvfR3kNVy76H12rR7gr4DXI\n",
        "! mv bridge-spider-bert-large-ems-70-1-exe-68-2.tar.gz model\n",
        "! gunzip model/bridge-spider-bert-large-ems-70-1-exe-68-2.tar.gz\n",
        "\n",
        "! gdown https://drive.google.com/uc?id=1vk14iR4V_f5x4e17MAaL_L8T9wgjcKCy\n",
        "! mv dev.eo.pred.restored.pkl.gz data/spider\n",
        "! gunzip data/spider/dev.eo.pred.restored.pkl.gz"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "s-Bw0uJOxEX0"
      },
      "source": [
        "Upload chinook database"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1edObj1SwazA",
        "outputId": "4f8ce9ca-bf57-4981-ea38-6147c06042f4"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Downloading...\n",
            "From: https://drive.google.com/uc?id=1_AckYkinAnhqmRQtGsQgUKAnTHxxX5J0\n",
            "To: /content/TabularSemanticParsing/spider.zip\n",
            "100% 99.7M/99.7M [00:01<00:00, 61.7MB/s]\n",
            "Archive:  spider.zip\n",
            "   creating: ./spider/\n",
            "   creating: ./spider/database/\n",
            "   creating: ./spider/database/customer_deliveries/\n",
            "  inflating: ./spider/database/customer_deliveries/schema.sql  \n",
            "  inflating: ./spider/database/customer_deliveries/customer_deliveries.sqlite  \n",
            "   creating: ./spider/database/allergy_1/\n",
            "  inflating: ./spider/database/allergy_1/schema.sql  \n",
            "  inflating: ./spider/database/allergy_1/allergy_1.sqlite  \n",
            "   creating: ./spider/database/company_office/\n",
            "  inflating: ./spider/database/company_office/schema.sql  \n",
            "  inflating: ./spider/database/company_office/company_office.sqlite  \n",
            "   creating: ./spider/database/device/\n",
            "  inflating: ./spider/database/device/schema.sql  \n",
            "  inflating: ./spider/database/device/device.sqlite  \n",
            "   creating: ./spider/database/phone_1/\n",
            "  inflating: ./spider/database/phone_1/schema.sql  \n",
            "  inflating: ./spider/database/phone_1/phone_1.sqlite  \n",
            "   creating: ./spider/database/cre_Doc_Control_Systems/\n",
            "  inflating: ./spider/database/cre_Doc_Control_Systems/schema.sql  \n",
            "  inflating: ./spider/database/cre_Doc_Control_Systems/cre_Doc_Control_Systems.sqlite  \n",
            "   creating: ./spider/database/imdb/\n",
            "  inflating: ./spider/database/imdb/schema.sql  \n",
            "  inflating: ./spider/database/imdb/imdb.sqlite  \n",
            "   creating: ./spider/database/decoration_competition/\n",
            "  inflating: ./spider/database/decoration_competition/decoration_competition.sqlite  \n",
            "  inflating: ./spider/database/decoration_competition/schema.sql  \n",
            "   creating: ./spider/database/customers_campaigns_ecommerce/\n",
            "  inflating: ./spider/database/customers_campaigns_ecommerce/schema.sql  \n",
            "  inflating: ./spider/database/customers_campaigns_ecommerce/customers_campaigns_ecommerce.sqlite  \n",
            "   creating: ./spider/database/car_1/\n",
            "   creating: ./spider/database/car_1/data_csv/\n",
            "  inflating: ./spider/database/car_1/data_csv/countries.csv  \n",
            "  inflating: ./spider/database/car_1/data_csv/car-makers.csv  \n",
            "  inflating: ./spider/database/car_1/data_csv/continents.csv  \n",
            "  inflating: ./spider/database/car_1/data_csv/model-list.csv  \n",
            "  inflating: ./spider/database/car_1/data_csv/README.CARS.TXT  \n",
            "  inflating: ./spider/database/car_1/data_csv/cars.desc  \n",
            "  inflating: ./spider/database/car_1/data_csv/car-names.csv  \n",
            "  inflating: ./spider/database/car_1/data_csv/cars-data.csv  \n",
            "  inflating: ./spider/database/car_1/annotation.json  \n",
            "  inflating: ./spider/database/car_1/car_1.sql  \n",
            "  inflating: ./spider/database/car_1/q.txt  \n",
            "  inflating: ./spider/database/car_1/car_1.json  \n",
            " extracting: ./spider/database/car_1/link.txt  \n",
            "  inflating: ./spider/database/car_1/car_1.sqlite  \n",
            "   creating: ./spider/database/roller_coaster/\n",
            "  inflating: ./spider/database/roller_coaster/schema.sql  \n",
            "  inflating: ./spider/database/roller_coaster/roller_coaster.sqlite  \n",
            "   creating: ./spider/database/entrepreneur/\n",
            "  inflating: ./spider/database/entrepreneur/schema.sql  \n",
            "  inflating: ./spider/database/entrepreneur/entrepreneur.sqlite  \n",
            "   creating: ./spider/database/insurance_policies/\n",
            "  inflating: ./spider/database/insurance_policies/schema.sql  \n",
            "  inflating: ./spider/database/insurance_policies/insurance_policies.sqlite  \n",
            "   creating: ./spider/database/cre_Drama_Workshop_Groups/\n",
            "  inflating: ./spider/database/cre_Drama_Workshop_Groups/schema.sql  \n",
            "  inflating: ./spider/database/cre_Drama_Workshop_Groups/cre_Drama_Workshop_Groups.sqlite  \n",
            "   creating: ./spider/database/voter_1/\n",
            "  inflating: ./spider/database/voter_1/voter_1.sqlite  \n",
            "   creating: ./spider/database/journal_committee/\n",
            "  inflating: ./spider/database/journal_committee/schema.sql  \n",
            "  inflating: ./spider/database/journal_committee/journal_committee.sqlite  \n",
            "   creating: ./spider/database/performance_attendance/\n",
            "  inflating: ./spider/database/performance_attendance/schema.sql  \n",
            "  inflating: ./spider/database/performance_attendance/performance_attendance.sqlite  \n",
            "   creating: ./spider/database/store_1/\n",
            "  inflating: ./spider/database/store_1/schema.sql  \n",
            "  inflating: ./spider/database/store_1/store_1.sqlite  \n",
            "   creating: ./spider/database/school_player/\n",
            "  inflating: ./spider/database/school_player/schema.sql  \n",
            "  inflating: ./spider/database/school_player/school_player.sqlite  \n",
            "   creating: ./spider/database/scientist_1/\n",
            "  inflating: ./spider/database/scientist_1/schema.sql  \n",
            "  inflating: ./spider/database/scientist_1/scientist_1.sqlite  \n",
            "   creating: ./spider/database/student_transcripts_tracking/\n",
            "  inflating: ./spider/database/student_transcripts_tracking/schema.sql  \n",
            "  inflating: ./spider/database/student_transcripts_tracking/student_transcripts_tracking.sqlite  \n",
            "   creating: ./spider/database/department_store/\n",
            "  inflating: ./spider/database/department_store/schema.sql  \n",
            "  inflating: ./spider/database/department_store/department_store.sqlite  \n",
            "   creating: ./spider/database/cre_Doc_Template_Mgt/\n",
            "  inflating: ./spider/database/cre_Doc_Template_Mgt/schema.sql  \n",
            "  inflating: ./spider/database/cre_Doc_Template_Mgt/cre_Doc_Template_Mgt.sqlite  \n",
            "   creating: ./spider/database/local_govt_in_alabama/\n",
            "  inflating: ./spider/database/local_govt_in_alabama/schema.sql  \n",
            "  inflating: ./spider/database/local_govt_in_alabama/local_govt_in_alabama.sqlite  \n",
            "   creating: ./spider/database/browser_web/\n",
            "  inflating: ./spider/database/browser_web/schema.sql  \n",
            "  inflating: ./spider/database/browser_web/browser_web.sqlite  \n",
            "   creating: ./spider/database/cre_Docs_and_Epenses/\n",
            "  inflating: ./spider/database/cre_Docs_and_Epenses/schema.sql  \n",
            "  inflating: ./spider/database/cre_Docs_and_Epenses/cre_Docs_and_Epenses.sqlite  \n",
            "   creating: ./spider/database/apartment_rentals/\n",
            "  inflating: ./spider/database/apartment_rentals/schema.sql  \n",
            "  inflating: ./spider/database/apartment_rentals/apartment_rentals.sqlite  \n",
            "   creating: ./spider/database/flight_4/\n",
            " extracting: ./spider/database/flight_4/sql.txt  \n",
            "  inflating: ./spider/database/flight_4/flight_4.sqlite  \n",
            " extracting: ./spider/database/flight_4/link.txt  \n",
            "   creating: ./spider/database/hospital_1/\n",
            "  inflating: ./spider/database/hospital_1/schema.sql  \n",
            "  inflating: ./spider/database/hospital_1/hospital_1.sqlite  \n",
            "   creating: ./spider/database/soccer_1/\n",
            "  inflating: ./spider/database/soccer_1/schema.sql  \n",
            "  inflating: ./spider/database/soccer_1/soccer_1.sqlite  \n",
            "   creating: ./spider/database/gymnast/\n",
            "  inflating: ./spider/database/gymnast/schema.sql  \n",
            "  inflating: ./spider/database/gymnast/gymnast.sqlite  \n",
            "   creating: ./spider/database/soccer_2/\n",
            "  inflating: ./spider/database/soccer_2/schema.sql  \n",
            "  inflating: ./spider/database/soccer_2/soccer_2.sqlite  \n",
            "   creating: ./spider/database/formula_1/\n",
            "  inflating: ./spider/database/formula_1/formula_1.sql  \n",
            "   creating: ./spider/database/formula_1/data_csv/\n",
            "  inflating: ./spider/database/formula_1/data_csv/status.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/qualifying.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/results.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/pitStops.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/constructors.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/lapTimes.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/constructorResults.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/circuits.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/constructorStandings.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/races.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/seasons.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/drivers.csv  \n",
            "  inflating: ./spider/database/formula_1/data_csv/driverStandings.csv  \n",
            " extracting: ./spider/database/formula_1/formula_1.splite  \n",
            "  inflating: ./spider/database/formula_1/annotation.json  \n",
            "  inflating: ./spider/database/formula_1/formula_1.sqlite  \n",
            "   creating: ./spider/database/workshop_paper/\n",
            "  inflating: ./spider/database/workshop_paper/schema.sql  \n",
            "  inflating: ./spider/database/workshop_paper/workshop_paper.sqlite  \n",
            "   creating: ./spider/database/shop_membership/\n",
            "  inflating: ./spider/database/shop_membership/schema.sql  \n",
            "  inflating: ./spider/database/shop_membership/shop_membership.sqlite  \n",
            "   creating: ./spider/database/candidate_poll/\n",
            "  inflating: ./spider/database/candidate_poll/schema.sql  \n",
            "  inflating: ./spider/database/candidate_poll/candidate_poll.sqlite  \n",
            "   creating: ./spider/database/hr_1/\n",
            "  inflating: ./spider/database/hr_1/schema.sql  \n",
            "  inflating: ./spider/database/hr_1/hr_1.sqlite  \n",
            "   creating: ./spider/database/storm_record/\n",
            "  inflating: ./spider/database/storm_record/schema.sql  \n",
            "  inflating: ./spider/database/storm_record/storm_record.sqlite  \n",
            "   creating: ./spider/database/ship_mission/\n",
            "  inflating: ./spider/database/ship_mission/ship_mission.sqlite  \n",
            "  inflating: ./spider/database/ship_mission/schema.sql  \n",
            "   creating: ./spider/database/coffee_shop/\n",
            "  inflating: ./spider/database/coffee_shop/schema.sql  \n",
            "  inflating: ./spider/database/coffee_shop/coffee_shop.sqlite  \n",
            "   creating: ./spider/database/bike_1/\n",
            "  inflating: ./spider/database/bike_1/schema.sql  \n",
            "  inflating: ./spider/database/bike_1/bike_1.sqlite  \n",
            "   creating: ./spider/database/activity_1/\n",
            "  inflating: ./spider/database/activity_1/schema.sql  \n",
            "  inflating: ./spider/database/activity_1/activity_1.sqlite  \n",
            "   creating: ./spider/database/film_rank/\n",
            "  inflating: ./spider/database/film_rank/schema.sql  \n",
            "  inflating: ./spider/database/film_rank/film_rank.sqlite  \n",
            "   creating: ./spider/database/program_share/\n",
            "  inflating: ./spider/database/program_share/schema.sql  \n",
            "  inflating: ./spider/database/program_share/program_share.sqlite  \n",
            "   creating: ./spider/database/company_1/\n",
            "  inflating: ./spider/database/company_1/company_1.sqlite  \n",
            "  inflating: ./spider/database/company_1/link.txt  \n",
            "   creating: ./spider/database/college_2/\n",
            "  inflating: ./spider/database/college_2/TextBookExampleSchema.sql  \n",
            "  inflating: ./spider/database/college_2/college_2.sqlite  \n",
            " extracting: ./spider/database/college_2/link.txt  \n",
            "   creating: ./spider/database/voter_2/\n",
            "  inflating: ./spider/database/voter_2/schema.sql  \n",
            "  inflating: ./spider/database/voter_2/voter_2.sqlite  \n",
            "   creating: ./spider/database/student_assessment/\n",
            "  inflating: ./spider/database/student_assessment/schema.sql  \n",
            "  inflating: ./spider/database/student_assessment/student_assessment.sqlite  \n",
            "   creating: ./spider/database/mountain_photos/\n",
            "  inflating: ./spider/database/mountain_photos/schema.sql  \n",
            "  inflating: ./spider/database/mountain_photos/mountain_photos.sqlite  \n",
            "   creating: ./spider/database/insurance_fnol/\n",
            "  inflating: ./spider/database/insurance_fnol/schema.sql  \n",
            "  inflating: ./spider/database/insurance_fnol/insurance_fnol.sqlite  \n",
            "   creating: ./spider/database/race_track/\n",
            "  inflating: ./spider/database/race_track/schema.sql  \n",
            "  inflating: ./spider/database/race_track/race_track.sqlite  \n",
            "   creating: ./spider/database/body_builder/\n",
            "  inflating: ./spider/database/body_builder/schema.sql  \n",
            "  inflating: ./spider/database/body_builder/body_builder.sqlite  \n",
            "   creating: ./spider/database/tracking_orders/\n",
            "  inflating: ./spider/database/tracking_orders/tracking_orders.sqlite  \n",
            "  inflating: ./spider/database/tracking_orders/schema.sql  \n",
            "   creating: ./spider/database/employee_hire_evaluation/\n",
            "  inflating: ./spider/database/employee_hire_evaluation/schema.sql  \n",
            "  inflating: ./spider/database/employee_hire_evaluation/employee_hire_evaluation.sqlite  \n",
            "   creating: ./spider/database/tracking_share_transactions/\n",
            "  inflating: ./spider/database/tracking_share_transactions/schema.sql  \n",
            "  inflating: ./spider/database/tracking_share_transactions/tracking_share_transactions.sqlite  \n",
            "   creating: ./spider/database/cre_Theme_park/\n",
            "  inflating: ./spider/database/cre_Theme_park/schema.sql  \n",
            "  inflating: ./spider/database/cre_Theme_park/cre_Theme_park.sqlite  \n",
            "   creating: ./spider/database/customers_and_products_contacts/\n",
            "  inflating: ./spider/database/customers_and_products_contacts/schema.sql  \n",
            "  inflating: ./spider/database/customers_and_products_contacts/customers_and_products_contacts.sqlite  \n",
            "   creating: ./spider/database/tracking_grants_for_research/\n",
            "  inflating: ./spider/database/tracking_grants_for_research/schema.sql  \n",
            "  inflating: ./spider/database/tracking_grants_for_research/tracking_grants_for_research.sqlite  \n",
            "   creating: ./spider/database/city_record/\n",
            "  inflating: ./spider/database/city_record/city_record.sqlite  \n",
            "  inflating: ./spider/database/city_record/schema.sql  \n",
            "   creating: ./spider/database/assets_maintenance/\n",
            "  inflating: ./spider/database/assets_maintenance/schema.sql  \n",
            "  inflating: ./spider/database/assets_maintenance/assets_maintenance.sqlite  \n",
            "   creating: ./spider/database/music_4/\n",
            "  inflating: ./spider/database/music_4/schema.sql  \n",
            "  inflating: ./spider/database/music_4/music_4.sqlite  \n",
            "   creating: ./spider/database/wrestler/\n",
            "  inflating: ./spider/database/wrestler/schema.sql  \n",
            "  inflating: ./spider/database/wrestler/wrestler.sqlite  \n",
            "   creating: ./spider/database/customer_complaints/\n",
            "  inflating: ./spider/database/customer_complaints/schema.sql  \n",
            "  inflating: ./spider/database/customer_complaints/customer_complaints.sqlite  \n",
            "   creating: ./spider/database/store_product/\n",
            "  inflating: ./spider/database/store_product/schema.sql  \n",
            "  inflating: ./spider/database/store_product/store_product.sqlite  \n",
            "   creating: ./spider/database/local_govt_mdm/\n",
            "  inflating: ./spider/database/local_govt_mdm/schema.sql  \n",
            "  inflating: ./spider/database/local_govt_mdm/local_govt_mdm.sqlite  \n",
            "   creating: ./spider/database/world_1/\n",
            "  inflating: ./spider/database/world_1/world_1.sqlite  \n",
            "  inflating: ./spider/database/world_1/world_1.json  \n",
            "   creating: ./spider/database/flight_1/\n",
            "  inflating: ./spider/database/flight_1/flight_1.sqlite  \n",
            "  inflating: ./spider/database/flight_1/schema.sql  \n",
            "   creating: ./spider/database/ship_1/\n",
            "  inflating: ./spider/database/ship_1/schema.sql  \n",
            "  inflating: ./spider/database/ship_1/ship_1.sqlite  \n",
            "   creating: ./spider/database/climbing/\n",
            "  inflating: ./spider/database/climbing/schema.sql  \n",
            "  inflating: ./spider/database/climbing/climbing.sqlite  \n",
            "   creating: ./spider/database/game_injury/\n",
            "  inflating: ./spider/database/game_injury/schema.sql  \n",
            "  inflating: ./spider/database/game_injury/game_injury.sqlite  \n",
            "   creating: ./spider/database/school_finance/\n",
            "  inflating: ./spider/database/school_finance/schema.sql  \n",
            "  inflating: ./spider/database/school_finance/school_finance.sqlite  \n",
            "   creating: ./spider/database/game_1/\n",
            "  inflating: ./spider/database/game_1/schema.sql  \n",
            "  inflating: ./spider/database/game_1/game_1.sqlite  \n",
            "   creating: ./spider/database/architecture/\n",
            "  inflating: ./spider/database/architecture/schema.sql  \n",
            "  inflating: ./spider/database/architecture/architecture.sqlite  \n",
            "   creating: ./spider/database/e_government/\n",
            "  inflating: ./spider/database/e_government/schema.sql  \n",
            "  inflating: ./spider/database/e_government/e_government.sqlite  \n",
            "   creating: ./spider/database/college_1/\n",
            "  inflating: ./spider/database/college_1/TinyCollege.sql  \n",
            "  inflating: ./spider/database/college_1/college_1.sqlite  \n",
            " extracting: ./spider/database/college_1/link.txt  \n",
            "   creating: ./spider/database/tracking_software_problems/\n",
            "  inflating: ./spider/database/tracking_software_problems/schema.sql  \n",
            "  inflating: ./spider/database/tracking_software_problems/tracking_software_problems.sqlite  \n",
            "   creating: ./spider/database/farm/\n",
            "  inflating: ./spider/database/farm/schema.sql  \n",
            "  inflating: ./spider/database/farm/farm.sqlite  \n",
            "   creating: ./spider/database/culture_company/\n",
            "  inflating: ./spider/database/culture_company/schema.sql  \n",
            "  inflating: ./spider/database/culture_company/culture_company.sqlite  \n",
            "   creating: ./spider/database/pilot_record/\n",
            "  inflating: ./spider/database/pilot_record/schema.sql  \n",
            "  inflating: ./spider/database/pilot_record/pilot_record.sqlite  \n",
            "   creating: ./spider/database/school_bus/\n",
            "  inflating: ./spider/database/school_bus/schema.sql  \n",
            "  inflating: ./spider/database/school_bus/school_bus.sqlite  \n",
            "   creating: ./spider/database/inn_1/\n",
            "   creating: ./spider/database/inn_1/data_csv/\n",
            "  inflating: ./spider/database/inn_1/data_csv/Rooms.csv  \n",
            "  inflating: ./spider/database/inn_1/data_csv/README.INN.TXT  \n",
            "  inflating: ./spider/database/inn_1/data_csv/Reservations_t.csv  \n",
            "  inflating: ./spider/database/inn_1/data_csv/Reservations.csv  \n",
            "  inflating: ./spider/database/inn_1/annotation.json  \n",
            "  inflating: ./spider/database/inn_1/inn_1.sqlite  \n",
            "  inflating: ./spider/database/inn_1/inn_1.sql  \n",
            "  inflating: ./spider/database/inn_1/q.txt  \n",
            "  inflating: ./spider/database/inn_1/change_date.py  \n",
            " extracting: ./spider/database/inn_1/link.txt  \n",
            "   creating: ./spider/database/local_govt_and_lot/\n",
            "  inflating: ./spider/database/local_govt_and_lot/schema.sql  \n",
            "  inflating: ./spider/database/local_govt_and_lot/local_govt_and_lot.sqlite  \n",
            "   creating: ./spider/database/aircraft/\n",
            "  inflating: ./spider/database/aircraft/schema.sql  \n",
            "  inflating: ./spider/database/aircraft/aircraft.sqlite  \n",
            "   creating: ./spider/database/real_estate_properties/\n",
            "  inflating: ./spider/database/real_estate_properties/schema.sql  \n",
            "  inflating: ./spider/database/real_estate_properties/real_estate_properties.sqlite  \n",
            "   creating: ./spider/database/music_2/\n",
            "  inflating: ./spider/database/music_2/schema.sql  \n",
            "  inflating: ./spider/database/music_2/music_2.sqlite  \n",
            "   creating: ./spider/database/match_season/\n",
            "  inflating: ./spider/database/match_season/schema.sql  \n",
            "  inflating: ./spider/database/match_season/match_season.sqlite  \n",
            "   creating: ./spider/database/county_public_safety/\n",
            "  inflating: ./spider/database/county_public_safety/schema.sql  \n",
            "  inflating: ./spider/database/county_public_safety/county_public_safety.sqlite  \n",
            "   creating: ./spider/database/network_1/\n",
            "  inflating: ./spider/database/network_1/schema.sql  \n",
            "  inflating: ./spider/database/network_1/network_1.sqlite  \n",
            "   creating: ./spider/database/yelp/\n",
            "  inflating: ./spider/database/yelp/schema.sql  \n",
            "  inflating: ./spider/database/yelp/yelp.sqlite  \n",
            "   creating: ./spider/database/solvency_ii/\n",
            "  inflating: ./spider/database/solvency_ii/schema.sql  \n",
            "  inflating: ./spider/database/solvency_ii/solvency_ii.sqlite  \n",
            "   creating: ./spider/database/singer/\n",
            "  inflating: ./spider/database/singer/schema.sql  \n",
            "  inflating: ./spider/database/singer/singer.sqlite  \n",
            "   creating: ./spider/database/college_3/\n",
            "  inflating: ./spider/database/college_3/schema.sql  \n",
            "  inflating: ./spider/database/college_3/college_3.sqlite  \n",
            "   creating: ./spider/database/movie_1/\n",
            "  inflating: ./spider/database/movie_1/schema.sql  \n",
            "  inflating: ./spider/database/movie_1/movie_1.sqlite  \n",
            "   creating: ./spider/database/twitter_1/\n",
            "  inflating: ./spider/database/twitter_1/twitter_1.sqlite  \n",
            "   creating: ./spider/database/twitter_1/queries/\n",
            "  inflating: ./spider/database/twitter_1/queries/oracle-dialects.xml  \n",
            "  inflating: ./spider/database/twitter_1/queries/sqlserver-dialects.xml  \n",
            "  inflating: ./spider/database/twitter_1/queries/postgres-dialects.xml  \n",
            "   creating: ./spider/database/music_1/\n",
            "  inflating: ./spider/database/music_1/schema.sql  \n",
            "  inflating: ./spider/database/music_1/music_1.sqlite  \n",
            "   creating: ./spider/database/company_employee/\n",
            "  inflating: ./spider/database/company_employee/schema.sql  \n",
            "  inflating: ./spider/database/company_employee/company_employee.sqlite  \n",
            "   creating: ./spider/database/pets_1/\n",
            "  inflating: ./spider/database/pets_1/schema.sql  \n",
            "  inflating: ./spider/database/pets_1/pets_1.sqlite  \n",
            "   creating: ./spider/database/gas_company/\n",
            "  inflating: ./spider/database/gas_company/schema.sql  \n",
            "  inflating: ./spider/database/gas_company/gas_company.sqlite  \n",
            "   creating: ./spider/database/academic/\n",
            "  inflating: ./spider/database/academic/schema.sql  \n",
            "  inflating: ./spider/database/academic/academic.sqlite  \n",
            "   creating: ./spider/database/battle_death/\n",
            "  inflating: ./spider/database/battle_death/schema.sql  \n",
            "  inflating: ./spider/database/battle_death/battle_death.sqlite  \n",
            "   creating: ./spider/database/election_representative/\n",
            "  inflating: ./spider/database/election_representative/schema.sql  \n",
            "  inflating: ./spider/database/election_representative/election_representative.sqlite  \n",
            "   creating: ./spider/database/dog_kennels/\n",
            "  inflating: ./spider/database/dog_kennels/schema.sql  \n",
            "  inflating: ./spider/database/dog_kennels/dog_kennels.sqlite  \n",
            "   creating: ./spider/database/products_for_hire/\n",
            "  inflating: ./spider/database/products_for_hire/products_for_hire.sqlite  \n",
            "  inflating: ./spider/database/products_for_hire/schema.sql  \n",
            "   creating: ./spider/database/e_learning/\n",
            "  inflating: ./spider/database/e_learning/schema.sql  \n",
            "  inflating: ./spider/database/e_learning/e_learning.sqlite  \n",
            "   creating: ./spider/database/entertainment_awards/\n",
            "  inflating: ./spider/database/entertainment_awards/schema.sql  \n",
            "  inflating: ./spider/database/entertainment_awards/entertainment_awards.sqlite  \n",
            "   creating: ./spider/database/tvshow/\n",
            "  inflating: ./spider/database/tvshow/schema.sql  \n",
            "  inflating: ./spider/database/tvshow/tvshow.sqlite  \n",
            "   creating: ./spider/database/theme_gallery/\n",
            "  inflating: ./spider/database/theme_gallery/schema.sql  \n",
            "  inflating: ./spider/database/theme_gallery/theme_gallery.sqlite  \n",
            "   creating: ./spider/database/document_management/\n",
            "  inflating: ./spider/database/document_management/schema.sql  \n",
            "  inflating: ./spider/database/document_management/document_management.sqlite  \n",
            "   creating: ./spider/database/university_basketball/\n",
            "  inflating: ./spider/database/university_basketball/schema.sql  \n",
            "  inflating: ./spider/database/university_basketball/university_basketball.sqlite  \n",
            "   creating: ./spider/database/orchestra/\n",
            "  inflating: ./spider/database/orchestra/schema.sql  \n",
            "  inflating: ./spider/database/orchestra/orchestra.sqlite  \n",
            "   creating: ./spider/database/restaurants/\n",
            "  inflating: ./spider/database/restaurants/schema.sql  \n",
            "  inflating: ./spider/database/restaurants/restaurants.sqlite  \n",
            "   creating: ./spider/database/flight_2/\n",
            "   creating: ./spider/database/flight_2/data_csv/\n",
            "  inflating: ./spider/database/flight_2/data_csv/README.AIRLINES.txt  \n",
            "  inflating: ./spider/database/flight_2/data_csv/airports100.csv  \n",
            "  inflating: ./spider/database/flight_2/data_csv/airlines.csv  \n",
            "  inflating: ./spider/database/flight_2/data_csv/flights.csv  \n",
            "  inflating: ./spider/database/flight_2/annotation.json  \n",
            "  inflating: ./spider/database/flight_2/flight_2.sql  \n",
            "  inflating: ./spider/database/flight_2/flight_2.json  \n",
            "  inflating: ./spider/database/flight_2/flight_2.sqlite  \n",
            "  inflating: ./spider/database/flight_2/q.txt  \n",
            " extracting: ./spider/database/flight_2/link.txt  \n",
            "   creating: ./spider/database/student_1/\n",
            "   creating: ./spider/database/student_1/data_csv/\n",
            "  inflating: ./spider/database/student_1/data_csv/README.STUDENTS.TXT  \n",
            "  inflating: ./spider/database/student_1/data_csv/list.csv  \n",
            "  inflating: ./spider/database/student_1/data_csv/teachers.csv  \n",
            "  inflating: ./spider/database/student_1/annotation.json  \n",
            "  inflating: ./spider/database/student_1/student_1.sql  \n",
            "  inflating: ./spider/database/student_1/student_1.sqlite  \n",
            "  inflating: ./spider/database/student_1/q.txt  \n",
            " extracting: ./spider/database/student_1/link.txt  \n",
            "   creating: ./spider/database/party_host/\n",
            "  inflating: ./spider/database/party_host/schema.sql  \n",
            "  inflating: ./spider/database/party_host/party_host.sqlite  \n",
            "   creating: ./spider/database/epinions_1/\n",
            "  inflating: ./spider/database/epinions_1/epinions_1.sqlite  \n",
            "   creating: ./spider/database/wedding/\n",
            "  inflating: ./spider/database/wedding/schema.sql  \n",
            "  inflating: ./spider/database/wedding/wedding.sqlite  \n",
            "   creating: ./spider/database/department_management/\n",
            "  inflating: ./spider/database/department_management/schema.sql  \n",
            "  inflating: ./spider/database/department_management/department_management.sqlite  \n",
            "   creating: ./spider/database/products_gen_characteristics/\n",
            "  inflating: ./spider/database/products_gen_characteristics/schema.sql  \n",
            "  inflating: ./spider/database/products_gen_characteristics/products_gen_characteristics.sqlite  \n",
            "   creating: ./spider/database/riding_club/\n",
            "  inflating: ./spider/database/riding_club/schema.sql  \n",
            "  inflating: ./spider/database/riding_club/riding_club.sqlite  \n",
            "   creating: ./spider/database/loan_1/\n",
            "  inflating: ./spider/database/loan_1/schema.sql  \n",
            "  inflating: ./spider/database/loan_1/loan_1.sqlite  \n",
            "   creating: ./spider/database/small_bank_1/\n",
            "  inflating: ./spider/database/small_bank_1/small_bank_1.sqlite  \n",
            "   creating: ./spider/database/flight_company/\n",
            "  inflating: ./spider/database/flight_company/schema.sql  \n",
            "  inflating: ./spider/database/flight_company/flight_company.sqlite  \n",
            "   creating: ./spider/database/manufactory_1/\n",
            "  inflating: ./spider/database/manufactory_1/schema.sql  \n",
            "  inflating: ./spider/database/manufactory_1/manufactory_1.sqlite  \n",
            "   creating: ./spider/database/customers_and_addresses/\n",
            "  inflating: ./spider/database/customers_and_addresses/schema.sql  \n",
            "  inflating: ./spider/database/customers_and_addresses/customers_and_addresses.sqlite  \n",
            "   creating: ./spider/database/station_weather/\n",
            "  inflating: ./spider/database/station_weather/schema.sql  \n",
            "  inflating: ./spider/database/station_weather/station_weather.sqlite  \n",
            "   creating: ./spider/database/manufacturer/\n",
            "  inflating: ./spider/database/manufacturer/schema.sql  \n",
            "  inflating: ./spider/database/manufacturer/manufacturer.sqlite  \n",
            "   creating: ./spider/database/phone_market/\n",
            "  inflating: ./spider/database/phone_market/schema.sql  \n",
            "  inflating: ./spider/database/phone_market/phone_market.sqlite  \n",
            "   creating: ./spider/database/wta_1/\n",
            "  inflating: ./spider/database/wta_1/wta_1.sql  \n",
            "  inflating: ./spider/database/wta_1/wta_1.sqlite  \n",
            "   creating: ./spider/database/perpetrator/\n",
            "  inflating: ./spider/database/perpetrator/schema.sql  \n",
            "  inflating: ./spider/database/perpetrator/perpetrator.sqlite  \n",
            "   creating: ./spider/database/train_station/\n",
            "  inflating: ./spider/database/train_station/schema.sql  \n",
            "  inflating: ./spider/database/train_station/train_station.sqlite  \n",
            "   creating: ./spider/database/medicine_enzyme_interaction/\n",
            "  inflating: ./spider/database/medicine_enzyme_interaction/schema.sql  \n",
            "  inflating: ./spider/database/medicine_enzyme_interaction/medicine_enzyme_interaction.sqlite  \n",
            "   creating: ./spider/database/chinook_1/\n",
            "  inflating: ./spider/database/chinook_1/annotation.json  \n",
            "  inflating: ./spider/database/chinook_1/chinook_1.sqlite  \n",
            "   creating: ./spider/database/driving_school/\n",
            "  inflating: ./spider/database/driving_school/schema.sql  \n",
            "  inflating: ./spider/database/driving_school/driving_school.sqlite  \n",
            "   creating: ./spider/database/news_report/\n",
            "  inflating: ./spider/database/news_report/schema.sql  \n",
            "  inflating: ./spider/database/news_report/news_report.sqlite  \n",
            "   creating: ./spider/database/icfp_1/\n",
            "  inflating: ./spider/database/icfp_1/icfp_1.sqlite  \n",
            "  inflating: ./spider/database/icfp_1/q.txt  \n",
            "  inflating: ./spider/database/icfp_1/link.txt  \n",
            "   creating: ./spider/database/cre_Doc_Tracking_DB/\n",
            "  inflating: ./spider/database/cre_Doc_Tracking_DB/schema.sql  \n",
            "  inflating: ./spider/database/cre_Doc_Tracking_DB/cre_Doc_Tracking_DB.sqlite  \n",
            "   creating: ./spider/database/behavior_monitoring/\n",
            "  inflating: ./spider/database/behavior_monitoring/schema.sql  \n",
            "  inflating: ./spider/database/behavior_monitoring/behavior_monitoring.sqlite  \n",
            "   creating: ./spider/database/restaurant_1/\n",
            "  inflating: ./spider/database/restaurant_1/schema.sql  \n",
            "  inflating: ./spider/database/restaurant_1/restaurant_1.sqlite  \n",
            "   creating: ./spider/database/scholar/\n",
            "  inflating: ./spider/database/scholar/schema.sql  \n",
            "  inflating: ./spider/database/scholar/scholar.sqlite  \n",
            "   creating: ./spider/database/product_catalog/\n",
            "  inflating: ./spider/database/product_catalog/schema.sql  \n",
            "  inflating: ./spider/database/product_catalog/product_catalog.sqlite  \n",
            "   creating: ./spider/database/csu_1/\n",
            "  inflating: ./spider/database/csu_1/schema.sql  \n",
            "  inflating: ./spider/database/csu_1/csu_1.sqlite  \n",
            "   creating: ./spider/database/debate/\n",
            "  inflating: ./spider/database/debate/schema.sql  \n",
            "  inflating: ./spider/database/debate/debate.sqlite  \n",
            "   creating: ./spider/database/railway/\n",
            "  inflating: ./spider/database/railway/schema.sql  \n",
            "  inflating: ./spider/database/railway/railway.sqlite  \n",
            "   creating: ./spider/database/protein_institute/\n",
            "  inflating: ./spider/database/protein_institute/schema.sql  \n",
            "  inflating: ./spider/database/protein_institute/protein_institute.sqlite  \n",
            "   creating: ./spider/database/machine_repair/\n",
            "  inflating: ./spider/database/machine_repair/schema.sql  \n",
            "  inflating: ./spider/database/machine_repair/machine_repair.sqlite  \n",
            "   creating: ./spider/database/insurance_and_eClaims/\n",
            "  inflating: ./spider/database/insurance_and_eClaims/schema.sql  \n",
            "  inflating: ./spider/database/insurance_and_eClaims/insurance_and_eClaims.sqlite  \n",
            "   creating: ./spider/database/museum_visit/\n",
            "  inflating: ./spider/database/museum_visit/museum_visit.sqlite  \n",
            "  inflating: ./spider/database/museum_visit/schema.sql  \n",
            "   creating: ./spider/database/wine_1/\n",
            "   creating: ./spider/database/wine_1/data_csv/\n",
            "  inflating: ./spider/database/wine_1/data_csv/appellations.csv  \n",
            "  inflating: ./spider/database/wine_1/data_csv/grapes.csv  \n",
            "  inflating: ./spider/database/wine_1/data_csv/wine.csv  \n",
            "  inflating: ./spider/database/wine_1/data_csv/README.WINE.txt  \n",
            "  inflating: ./spider/database/wine_1/annotation.json  \n",
            "  inflating: ./spider/database/wine_1/wine_1.sqlite  \n",
            "  inflating: ./spider/database/wine_1/wine_1.sql  \n",
            "   creating: ./spider/database/wine_1/.ipynb_checkpoints/\n",
            "  inflating: ./spider/database/wine_1/q.txt  \n",
            " extracting: ./spider/database/wine_1/link.txt  \n",
            "   creating: ./spider/database/swimming/\n",
            "  inflating: ./spider/database/swimming/schema.sql  \n",
            "  inflating: ./spider/database/swimming/swimming.sqlite  \n",
            "   creating: ./spider/database/election/\n",
            "  inflating: ./spider/database/election/election.sqlite  \n",
            "  inflating: ./spider/database/election/schema.sql  \n",
            "   creating: ./spider/database/dorm_1/\n",
            "  inflating: ./spider/database/dorm_1/schema.sql  \n",
            "  inflating: ./spider/database/dorm_1/dorm_1.sqlite  \n",
            "   creating: ./spider/database/course_teach/\n",
            "  inflating: ./spider/database/course_teach/schema.sql  \n",
            "  inflating: ./spider/database/course_teach/course_teach.sqlite  \n",
            "   creating: ./spider/database/club_1/\n",
            "  inflating: ./spider/database/club_1/schema.sql  \n",
            "  inflating: ./spider/database/club_1/club_1.sqlite  \n",
            "   creating: ./spider/database/concert_singer/\n",
            "  inflating: ./spider/database/concert_singer/schema.sql  \n",
            "  inflating: ./spider/database/concert_singer/concert_singer.sqlite  \n",
            "   creating: ./spider/database/sakila_1/\n",
            "  inflating: ./spider/database/sakila_1/schema.sql  \n",
            "  inflating: ./spider/database/sakila_1/sakila_1.sqlite  \n",
            "   creating: ./spider/database/customers_card_transactions/\n",
            "  inflating: ./spider/database/customers_card_transactions/schema.sql  \n",
            "  inflating: ./spider/database/customers_card_transactions/customers_card_transactions.sqlite  \n",
            "   creating: ./spider/database/poker_player/\n",
            "  inflating: ./spider/database/poker_player/schema.sql  \n",
            "  inflating: ./spider/database/poker_player/poker_player.sqlite  \n",
            "   creating: ./spider/database/customers_and_invoices/\n",
            "  inflating: ./spider/database/customers_and_invoices/schema.sql  \n",
            "  inflating: ./spider/database/customers_and_invoices/customers_and_invoices.sqlite  \n",
            "   creating: ./spider/database/musical/\n",
            "  inflating: ./spider/database/musical/schema.sql  \n",
            "  inflating: ./spider/database/musical/musical.sqlite  \n",
            "   creating: ./spider/database/sports_competition/\n",
            "  inflating: ./spider/database/sports_competition/schema.sql  \n",
            "  inflating: ./spider/database/sports_competition/sports_competition.sqlite  \n",
            "   creating: ./spider/database/network_2/\n",
            "  inflating: ./spider/database/network_2/network_2.sqlite  \n",
            "  inflating: ./spider/database/network_2/schema.sql  \n",
            "   creating: ./spider/database/geo/\n",
            "  inflating: ./spider/database/geo/schema.sql  \n",
            "  inflating: ./spider/database/geo/geo.sqlite  \n",
            "   creating: ./spider/database/party_people/\n",
            "  inflating: ./spider/database/party_people/schema.sql  \n",
            "  inflating: ./spider/database/party_people/party_people.sqlite  \n",
            "   creating: ./spider/database/cinema/\n",
            "  inflating: ./spider/database/cinema/schema.sql  \n",
            "  inflating: ./spider/database/cinema/cinema.sqlite  \n",
            "   creating: ./spider/database/baseball_1/\n",
            "  inflating: ./spider/database/baseball_1/schema.sql  \n",
            "  inflating: ./spider/database/baseball_1/baseball_1.sqlite  \n",
            "   creating: ./spider/database/book_2/\n",
            "  inflating: ./spider/database/book_2/schema.sql  \n",
            "  inflating: ./spider/database/book_2/book_2.sqlite  \n",
            "  inflating: ./spider/dev.json       \n",
            "  inflating: ./spider/train_others.json  \n",
            "  inflating: ./spider/.DS_Store      \n",
            "  inflating: ./spider/dev_gold.sql   \n",
            "  inflating: ./spider/train_spider.json  \n",
            "  inflating: ./spider/train_gold.sql  \n",
            "  inflating: ./spider/README.txt     \n",
            "  inflating: ./spider/tables.json    \n"
          ]
        }
      ],
      "source": [
        "! gdown https://drive.google.com/uc?id=1_AckYkinAnhqmRQtGsQgUKAnTHxxX5J0\n",
        "! unzip spider.zip -d ."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "NAQBcQhI49JX"
      },
      "outputs": [],
      "source": [
        "! cp -a spider/. data/spider"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "b8l5YEbH8fVE"
      },
      "source": [
        "# **DB Setup**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "j5KsVyU38oZy"
      },
      "outputs": [],
      "source": [
        "import json\n",
        "\n",
        "def merge_two_objects(path1, path2, out_path):\n",
        "    with open(path1, 'r') as file:\n",
        "      f1 = json.load(file)\n",
        "    \n",
        "    with open(path2, 'r') as file:\n",
        "      f2 = json.load(file)\n",
        "     \n",
        "    f1.extend(f2)\n",
        "\n",
        "    with open(out_path, 'w') as file:\n",
        "      json.dump(f1, file)\n",
        "\n",
        "merge_two_objects('/content/TabularSemanticParsing/data/spider/train_others.json', \n",
        "                  '/content/TabularSemanticParsing/data/spider/train_spider.json',\n",
        "                  '/content/TabularSemanticParsing/data/spider/train.json')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fY-I_iU16nx9"
      },
      "source": [
        "# **Inference stuff**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 101,
          "referenced_widgets": [
            "3adec502a25a446a918fcae3c9407c9f",
            "1c27fa66f9dc40ca9444bae7807a1201",
            "15910270bab34b108259506c5393e76f",
            "db9b8d9147fc4040ab00b0e5a8d61cfe",
            "88b3c9c94f35492b952aea0e2be3a086",
            "61734f02065d4643bcd02f15b5c33bce",
            "61c6a5644aa141598c0c00101252c119",
            "d02007e7c87241c59ae524d3f42f0f89"
          ]
        },
        "id": "yTX0c7xnDde-",
        "outputId": "83831671-ba4b-45f4-c252-4c75f7a2a725"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "[Errno 2] No such file or directory: 'TabularSemanticParsing'\n",
            "/content/TabularSemanticParsing\n"
          ]
        },
        {
          "data": {
            "application/vnd.jupyter.widget-view+json": {
              "model_id": "3adec502a25a446a918fcae3c9407c9f",
              "version_major": 2,
              "version_minor": 0
            },
            "text/plain": [
              "HBox(children=(IntProgress(value=0, description='Downloading', max=231508, style=ProgressStyle(description_wid…"
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        },
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "\n"
          ]
        }
      ],
      "source": [
        "%cd TabularSemanticParsing\n",
        "import sqlalchemy\n",
        "from sqlalchemy import MetaData\n",
        "from src.data_processor.schema_graph import SchemaGraph\n",
        "from src.demos.demos import Text2SQLWrapper"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "_lR4XfDQEGho"
      },
      "outputs": [],
      "source": [
        "db = sqlalchemy.create_engine('sqlite:////content/TabularSemanticParsing/chinook.db')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "7d-nRRSzNlRz"
      },
      "outputs": [],
      "source": [
        "class NaturalQuery(object):\n",
        "    def __init__(self, db, name):\n",
        "      super().__init__()\n",
        "\n",
        "      self.db = db\n",
        "      \n",
        "      metadata = MetaData(db)\n",
        "      metadata.reflect()\n",
        "\n",
        "      self.metadata = metadata\n",
        "\n",
        "      schema = SchemaGraph(name=name)\n",
        "      schema.load_data_from_sqlalchemy_metadata(self.metadata.tables.values())\n",
        "\n",
        "      self.schema = schema\n",
        "\n",
        "    def args():\n",
        "      # I need: path_to_checkpoint\n",
        "      pass"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "ggS9qLAGAj4O"
      },
      "outputs": [],
      "source": [
        "from src.trans_checker.args import args as cs_args"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "RadsjFcOCzPF"
      },
      "outputs": [],
      "source": [
        "class Args(object):\n",
        "    def __init__(self):\n",
        "        self.model = 'bridge'\n",
        "        self.model_id = 2\n",
        "        self.inference = True\n",
        "        self.checkpoint_path='/content/TabularSemanticParsing/model/bridge-spider-bert-large-ems-70-1-exe-68-2.tar'\n",
        "        self.model_dir = 'model'\n",
        "        self.start_step = 0\n",
        "        self.num_log_steps = 500\n",
        "        self.optimizer = 'adam'\n",
        "        self.adam_beta1 = 0.9\n",
        "        self.adam_beta2 = 0.999\n",
        "        self.adam_eps = 1e-8\n",
        "        self.save_all_checkpoints = False\n",
        "        self.viz_dir = '/content/TabularSemanticParsing/viz'\n",
        "        self.xavier_initialization = True\n",
        "        self.decoder_hidden_dim = -1\n",
        "        self.ff_output_dropout_rate = 0.0\n",
        "        self.loss = \"cross_entropy\"\n",
        "        self.train = False\n",
        "        self.test = False\n",
        "\n",
        "    data_dir=\"data/spider\"\n",
        "    db_dir=\"data/spider/database\"\n",
        "    dataset_name=\"spider\"\n",
        "    model=\"bridge\"\n",
        "    question_split=True\n",
        "    query_split=False\n",
        "    question_only=True\n",
        "    normalize_variables=False\n",
        "    denormalize_sql=True\n",
        "    omit_from_clause=False\n",
        "    no_join_condition=False\n",
        "    table_shuffling=True\n",
        "    use_lstm_encoder=True\n",
        "    use_meta_data_encoding=True\n",
        "    use_graph_encoding=False\n",
        "    use_typed_field_markers=False\n",
        "    use_picklist=False\n",
        "    read_picklist=False\n",
        "    anchor_text_match_threshold=0.85\n",
        "    no_anchor_text=False\n",
        "    top_k_picklist_matches=2\n",
        "    sql_consistency_check=True\n",
        "    atomic_value_copy=False\n",
        "    process_sql_in_execution_order=True\n",
        "    share_vocab=False\n",
        "    sample_ground_truth=False\n",
        "    save_nn_weights_for_visualizations=False\n",
        "    vocab_min_freq=0\n",
        "    text_vocab_min_freq=0\n",
        "    program_vocab_min_freq=0\n",
        "    max_in_seq_len=512\n",
        "    max_out_seq_len=60\n",
        "\n",
        "    num_steps=100000\n",
        "    curriculum_interval=0\n",
        "    num_peek_steps=1000\n",
        "    num_accumulation_steps=2\n",
        "    save_best_model_only=True\n",
        "    train_batch_size=16\n",
        "    dev_batch_size=24\n",
        "    encoder_input_dim=1024\n",
        "    encoder_hidden_dim=400\n",
        "    decoder_input_dim=400\n",
        "    num_rnn_layers=1\n",
        "    num_const_attn_layers=0\n",
        "\n",
        "    use_oracle_tables=False\n",
        "    num_random_tables_added=0\n",
        "    use_additive_features=False\n",
        "\n",
        "    schema_augmentation_factor=1\n",
        "    random_field_order=False\n",
        "    data_augmentation_factor=1\n",
        "    augment_with_wikisql=False\n",
        "    num_values_per_field=0\n",
        "    pretrained_transformer=\"bert-large-uncased\"\n",
        "    fix_pretrained_transformer_parameters=False\n",
        "    bert_finetune_rate=0.00006\n",
        "    learning_rate=0.0005\n",
        "    learning_rate_scheduler=\"inverse-square\"\n",
        "    trans_learning_rate_scheduler=\"inverse-square\"\n",
        "    warmup_init_lr=0.0005\n",
        "    warmup_init_ft_lr=0.00003\n",
        "    num_warmup_steps=4000\n",
        "    emb_dropout_rate=0.3\n",
        "    pretrained_lm_dropout_rate=0\n",
        "    rnn_layer_dropout_rate=0\n",
        "    rnn_weight_dropout_rate=0\n",
        "    cross_attn_dropout_rate=0\n",
        "    cross_attn_num_heads=8\n",
        "    res_input_dropout_rate=0.2\n",
        "    res_layer_dropout_rate=0\n",
        "    ff_input_dropout_rate=0.4\n",
        "    ff_hidden_dropout_rate=0.0\n",
        "\n",
        "    grad_norm=0.3\n",
        "    decoding_algorithm=\"beam-search\"\n",
        "    beam_size=16\n",
        "    bs_alpha=1.05\n",
        "\n",
        "    data_parallel=False\n",
        "\n",
        "    leaderboard_submission=False\n",
        "    demo=False\n",
        "    use_pred_tables = False\n",
        "    execution_guided_decoding = False"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "AveIkLuuA_8Y"
      },
      "outputs": [],
      "source": [
        "#metadata = MetaData(db)\n",
        "#metadata.reflect()\n",
        "\n",
        "#schema = SchemaGraph(name='chinoo')\n",
        "#schema.load_data_from_sqlalchemy_metadata(metadata.tables.values())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "KtkWvtb1KWXh"
      },
      "outputs": [],
      "source": [
        "def create_t2s_model(args, cs_args, schema):\n",
        "  return Text2SQLWrapper(args, cs_args, schema)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 376,
          "referenced_widgets": [
            "285bc05050ca461f87156b453f56c7d7",
            "0b2ef47c39de4520b48d9f6d8f3a74ae",
            "da13bba803264bacb9ba3c5d6aba6c05",
            "3f81bde90bca47e78ff9c1db008492d7",
            "02dba1682ef84235a1e1e93702f4ff18",
            "70aaee903cc94fa7a6f3b2fb5c299e80",
            "8ed069675b9e4f8f9cb5654920f8ce21",
            "b2abc6cad4874912b6725b021506bc8f",
            "5a2ad590b6ea4ce6828d1f1b7544c51a",
            "6d538ddc6ee24f239ab1880a1556f0f7",
            "137b53118b164946abdc42c602cdd2a8",
            "b9752ce0528e43cf812416d9471afaff",
            "c83d4b718d2543bda45e7979036cff96",
            "965a3d1259d8420ab0d7ce94b044e046",
            "20a64f2c719f456a8b57ce3fc8603fb0",
            "2b90a2572fd748faa2d718d1ce54ef51"
          ]
        },
        "id": "FG0PX20JPeut",
        "outputId": "5ec01ac9-a152-48c6-99fe-18e92fdd54b3"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "* text vocab size = 30522\n",
            "* program vocab size = 99\n",
            "\n"
          ]
        },
        {
          "data": {
            "application/vnd.jupyter.widget-view+json": {
              "model_id": "285bc05050ca461f87156b453f56c7d7",
              "version_major": 2,
              "version_minor": 0
            },
            "text/plain": [
              "HBox(children=(IntProgress(value=0, description='Downloading', max=434, style=ProgressStyle(description_width=…"
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        },
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "\n"
          ]
        },
        {
          "data": {
            "application/vnd.jupyter.widget-view+json": {
              "model_id": "5a2ad590b6ea4ce6828d1f1b7544c51a",
              "version_major": 2,
              "version_minor": 0
            },
            "text/plain": [
              "HBox(children=(IntProgress(value=0, description='Downloading', max=1344997306, style=ProgressStyle(description…"
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        },
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "\n",
            "=> no checkpoint found at '/content/TabularSemanticParsing/model/trans_check_0.0001_3e-05_800/model-best.tar'\n",
            "./content created\n",
            "./content/TabularSemanticParsing created\n",
            "./content/TabularSemanticParsing/viz created\n",
            "* text vocab size = 30522\n",
            "* program vocab size = 99\n",
            "\n",
            "pretrained_transformer = bert-large-uncased\n",
            "fix_pretrained_transformer_parameters = False\n",
            "\n",
            "bridge module created\n",
            "=> loading checkpoint '/content/TabularSemanticParsing/model/bridge-spider-bert-large-ems-70-1-exe-68-2.tar'\n"
          ]
        }
      ],
      "source": [
        "schema = SchemaGraph(name='default')\n",
        "args = Args()\n",
        "t2s = create_t2s_model(args, cs_args, schema)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uDdt4goCjBBy",
        "outputId": "57d83eca-674c-4196-d1bb-a2b84fd0b5f5"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Collecting flask-cors\n",
            "  Downloading Flask_Cors-3.0.10-py2.py3-none-any.whl (14 kB)\n",
            "Requirement already satisfied: Flask>=0.9 in /usr/local/lib/python3.7/dist-packages (from flask-cors) (0.12.2)\n",
            "Requirement already satisfied: Six in /usr/local/lib/python3.7/dist-packages (from flask-cors) (1.15.0)\n",
            "Requirement already satisfied: click>=2.0 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.9->flask-cors) (7.1.2)\n",
            "Requirement already satisfied: Werkzeug>=0.7 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.9->flask-cors) (1.0.1)\n",
            "Requirement already satisfied: itsdangerous>=0.21 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.9->flask-cors) (1.1.0)\n",
            "Requirement already satisfied: Jinja2>=2.4 in /usr/local/lib/python3.7/dist-packages (from Flask>=0.9->flask-cors) (2.11.3)\n",
            "Requirement already satisfied: MarkupSafe>=0.23 in /usr/local/lib/python3.7/dist-packages (from Jinja2>=2.4->Flask>=0.9->flask-cors) (2.0.1)\n",
            "Installing collected packages: flask-cors\n",
            "Successfully installed flask-cors-3.0.10\n"
          ]
        }
      ],
      "source": [
        "! pip install flask-cors"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "background_save": true,
          "base_uri": "https://localhost:8080/"
        },
        "id": "Ygrbq1zVakQg",
        "outputId": "4b7351e8-4dc9-44c0-c7d3-a27f0e6005d4"
      },
      "outputs": [
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            " * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)\n"
          ]
        },
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            " * Running on http://ff13-35-203-150-144.ngrok.io\n",
            " * Traffic stats available on http://127.0.0.1:4040\n"
          ]
        },
        {
          "name": "stderr",
          "output_type": "stream",
          "text": [
            "127.0.0.1 - - [23/Dec/2021 09:00:24] \"\u001b[37mOPTIONS //schema HTTP/1.1\u001b[0m\" 200 -\n",
            "127.0.0.1 - - [23/Dec/2021 09:18:48] \"\u001b[37mOPTIONS //schema HTTP/1.1\u001b[0m\" 200 -\n",
            "127.0.0.1 - - [23/Dec/2021 09:19:48] \"\u001b[37mOPTIONS //query HTTP/1.1\u001b[0m\" 200 -\n",
            "127.0.0.1 - - [23/Dec/2021 09:19:56] \"\u001b[37mOPTIONS //query HTTP/1.1\u001b[0m\" 200 -\n",
            "127.0.0.1 - - [23/Dec/2021 09:20:31] \"\u001b[37mOPTIONS //query HTTP/1.1\u001b[0m\" 200 -\n"
          ]
        }
      ],
      "source": [
        "# flask_ngrok_example.py\n",
        "from flask import Flask, request, jsonify\n",
        "from flask_ngrok import run_with_ngrok\n",
        "from flask_cors import CORS\n",
        "\n",
        "app = Flask(__name__)\n",
        "CORS(app)\n",
        "run_with_ngrok(app)  # Start ngrok when app is run\n",
        "app.config['JSONIFY_PRETTYPRINT_REGULAR'] = False\n",
        "\n",
        "@app.route(\"/\")\n",
        "def hello():\n",
        "    return \"Hello World!\"\n",
        "\n",
        "\n",
        "@app.route(\"/schema\", methods=['POST'])\n",
        "def set_schema():\n",
        "    schema_data = request.get_json(force=True)\n",
        "    name = schema_data['name']\n",
        "    new_schema = SchemaGraph(name=name)\n",
        "    print(schema_data)\n",
        "    new_schema.load_data_from_spider_json(schema_data)\n",
        "    t2s.add_schema(new_schema)\n",
        "    return 'ok'\n",
        "\n",
        "\n",
        "@app.route(\"/query\", methods=['POST'])\n",
        "def query():\n",
        "    data = request.get_json(force=True)\n",
        "    print(data)\n",
        "    name = data['name']\n",
        "    text = data['text']\n",
        "    answer = t2s.process(text, name)\n",
        "    return jsonify(answer)\n",
        "\n",
        "if __name__ == '__main__':\n",
        "    app.run()  # If address is in use, may need to terminate other sessions:\n",
        "               # Runtime > Manage Sessions > Terminate Other Sessions"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "background_save": true
        },
        "id": "gMr4NagQT8QA"
      },
      "outputs": [],
      "source": [
        ""
      ]
    }
  ],
  "metadata": {
    "accelerator": "GPU",
    "colab": {
      "collapsed_sections": [],
      "name": "Text2SQL_Photon",
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    },
    "widgets": {
      "application/vnd.jupyter.widget-state+json": {
        "02dba1682ef84235a1e1e93702f4ff18": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "0b2ef47c39de4520b48d9f6d8f3a74ae": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "IntProgressModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "IntProgressModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "ProgressView",
            "bar_style": "success",
            "description": "Downloading",
            "description_tooltip": null,
            "layout": "IPY_MODEL_02dba1682ef84235a1e1e93702f4ff18",
            "max": 434,
            "min": 0,
            "orientation": "horizontal",
            "style": "IPY_MODEL_70aaee903cc94fa7a6f3b2fb5c299e80",
            "value": 434
          }
        },
        "137b53118b164946abdc42c602cdd2a8": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "HTMLModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HTMLModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HTMLView",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_20a64f2c719f456a8b57ce3fc8603fb0",
            "placeholder": "​",
            "style": "IPY_MODEL_2b90a2572fd748faa2d718d1ce54ef51",
            "value": "100% 1.34G/1.34G [01:59&lt;00:00, 11.3MB/s]"
          }
        },
        "15910270bab34b108259506c5393e76f": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "HTMLModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HTMLModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HTMLView",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_61c6a5644aa141598c0c00101252c119",
            "placeholder": "​",
            "style": "IPY_MODEL_d02007e7c87241c59ae524d3f42f0f89",
            "value": "100% 232k/232k [00:00&lt;00:00, 898kB/s]"
          }
        },
        "1c27fa66f9dc40ca9444bae7807a1201": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "IntProgressModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "IntProgressModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "ProgressView",
            "bar_style": "success",
            "description": "Downloading",
            "description_tooltip": null,
            "layout": "IPY_MODEL_88b3c9c94f35492b952aea0e2be3a086",
            "max": 231508,
            "min": 0,
            "orientation": "horizontal",
            "style": "IPY_MODEL_61734f02065d4643bcd02f15b5c33bce",
            "value": 231508
          }
        },
        "20a64f2c719f456a8b57ce3fc8603fb0": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "285bc05050ca461f87156b453f56c7d7": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "HBoxModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HBoxModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HBoxView",
            "box_style": "",
            "children": [
              "IPY_MODEL_0b2ef47c39de4520b48d9f6d8f3a74ae",
              "IPY_MODEL_da13bba803264bacb9ba3c5d6aba6c05"
            ],
            "layout": "IPY_MODEL_3f81bde90bca47e78ff9c1db008492d7"
          }
        },
        "2b90a2572fd748faa2d718d1ce54ef51": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "DescriptionStyleModel",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "DescriptionStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "description_width": ""
          }
        },
        "3adec502a25a446a918fcae3c9407c9f": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "HBoxModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HBoxModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HBoxView",
            "box_style": "",
            "children": [
              "IPY_MODEL_1c27fa66f9dc40ca9444bae7807a1201",
              "IPY_MODEL_15910270bab34b108259506c5393e76f"
            ],
            "layout": "IPY_MODEL_db9b8d9147fc4040ab00b0e5a8d61cfe"
          }
        },
        "3f81bde90bca47e78ff9c1db008492d7": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "5a2ad590b6ea4ce6828d1f1b7544c51a": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "HBoxModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HBoxModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HBoxView",
            "box_style": "",
            "children": [
              "IPY_MODEL_6d538ddc6ee24f239ab1880a1556f0f7",
              "IPY_MODEL_137b53118b164946abdc42c602cdd2a8"
            ],
            "layout": "IPY_MODEL_b9752ce0528e43cf812416d9471afaff"
          }
        },
        "61734f02065d4643bcd02f15b5c33bce": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "ProgressStyleModel",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "ProgressStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "bar_color": null,
            "description_width": "initial"
          }
        },
        "61c6a5644aa141598c0c00101252c119": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "6d538ddc6ee24f239ab1880a1556f0f7": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "IntProgressModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "IntProgressModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "ProgressView",
            "bar_style": "success",
            "description": "Downloading",
            "description_tooltip": null,
            "layout": "IPY_MODEL_c83d4b718d2543bda45e7979036cff96",
            "max": 1344997306,
            "min": 0,
            "orientation": "horizontal",
            "style": "IPY_MODEL_965a3d1259d8420ab0d7ce94b044e046",
            "value": 1344997306
          }
        },
        "70aaee903cc94fa7a6f3b2fb5c299e80": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "ProgressStyleModel",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "ProgressStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "bar_color": null,
            "description_width": "initial"
          }
        },
        "88b3c9c94f35492b952aea0e2be3a086": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "8ed069675b9e4f8f9cb5654920f8ce21": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "965a3d1259d8420ab0d7ce94b044e046": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "ProgressStyleModel",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "ProgressStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "bar_color": null,
            "description_width": "initial"
          }
        },
        "b2abc6cad4874912b6725b021506bc8f": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "DescriptionStyleModel",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "DescriptionStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "description_width": ""
          }
        },
        "b9752ce0528e43cf812416d9471afaff": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "c83d4b718d2543bda45e7979036cff96": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "d02007e7c87241c59ae524d3f42f0f89": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "DescriptionStyleModel",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "DescriptionStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "description_width": ""
          }
        },
        "da13bba803264bacb9ba3c5d6aba6c05": {
          "model_module": "@jupyter-widgets/controls",
          "model_module_version": "1.5.0",
          "model_name": "HTMLModel",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HTMLModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HTMLView",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_8ed069675b9e4f8f9cb5654920f8ce21",
            "placeholder": "​",
            "style": "IPY_MODEL_b2abc6cad4874912b6725b021506bc8f",
            "value": "100% 434/434 [00:00&lt;00:00, 12.2kB/s]"
          }
        },
        "db9b8d9147fc4040ab00b0e5a8d61cfe": {
          "model_module": "@jupyter-widgets/base",
          "model_module_version": "1.2.0",
          "model_name": "LayoutModel",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        }
      }
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}