part2.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "cbc93a60",
      "metadata": {
        "scrolled": false,
        "id": "cbc93a60"
      },
      "outputs": [],
      "source": [
        "!pip3 install sqlalchemy # ORM for databases\n",
        "!pip3 install ipython-sql # SQL magic function"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "67c934d6",
      "metadata": {
        "scrolled": false,
        "id": "67c934d6"
      },
      "outputs": [],
      "source": [
        "%load_ext sql"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "9435162c",
      "metadata": {
        "id": "9435162c"
      },
      "source": [
        "## Connect With Your Credentials\n",
        "\n",
        "The current connection string DOES NOT WORK!   \n",
        "Make sure to change the YOURUSER:YOURPASSWORD part of the connection string to your team's account information!"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "fa727023",
      "metadata": {
        "scrolled": false,
        "id": "fa727023"
      },
      "outputs": [],
      "source": [
        "%sql postgresql://YOURUNI:YOURPASSWORD@w4111.cisxo09blonu.us-east-1.rds.amazonaws.com/proj1part2"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# change your password\n",
        "%%sql ALTER ROLE YOURUNI   \n",
        "WITH PASSWORD 'YOURNEWPASSWORD';"
      ],
      "metadata": {
        "id": "VUqhKhKmzgDC"
      },
      "id": "VUqhKhKmzgDC",
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "7624a542",
      "metadata": {
        "scrolled": false,
        "id": "7624a542"
      },
      "outputs": [],
      "source": [
        "# create table\n",
        "%%sql CREATE TABLE R (\n",
        "    A int,\n",
        "    B int\n",
        ");\n",
        "INSERT INTO R VALUES (1,2);\n",
        "INSERT INTO R VALUES (3,4);"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# see table R\n",
        "%sql SELECT * FROM R;"
      ],
      "metadata": {
        "id": "gLYqefpce4hd"
      },
      "id": "gLYqefpce4hd",
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# see all the tables you have\n",
        "%%sql SELECT *\n",
        "FROM pg_catalog.pg_tables\n",
        "WHERE tableowner='YOURUNI'"
      ],
      "metadata": {
        "id": "UgqzsE_CejNs"
      },
      "id": "UgqzsE_CejNs",
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# drop table\n",
        "%sql DROP TABLE R;"
      ],
      "metadata": {
        "id": "oSoTAj3teggV"
      },
      "id": "oSoTAj3teggV",
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "id": "8ef51aa2",
      "metadata": {
        "scrolled": false,
        "id": "8ef51aa2"
      },
      "outputs": [],
      "source": [
        ""
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.8.3"
    },
    "colab": {
      "name": "part2.ipynb",
      "provenance": []
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}