add example to query template

Penta, Antonio · Penta, Antonio · commit 32bf2d1ae944 · 2018-06-19T08:58:11.000+01:00
diff --git a/TemplateToRunQuery.ipynb b/TemplateToRunQuery.ipynb
@@ -2,7 +2,7 @@
  "cells": [
   {
    "cell_type": "code",
-   "execution_count": 4,
+   "execution_count": 1,
    "metadata": {},
    "outputs": [
     {
@@ -21,25 +21,16 @@
   },
   {
    "cell_type": "code",
-   "execution_count": 5,
+   "execution_count": 2,
    "metadata": {},
-   "outputs": [
-    {
-     "name": "stdout",
-     "output_type": "stream",
-     "text": [
-      "The sql extension is already loaded. To reload it, use:\n",
-      "  %reload_ext sql\n"
-     ]
-    }
-   ],
+   "outputs": [],
    "source": [
     "%load_ext sql "
    ]
   },
   {
    "cell_type": "code",
-   "execution_count": 6,
+   "execution_count": 3,
    "metadata": {},
    "outputs": [
     {
@@ -134,7 +125,7 @@
        " ('9', '11987', '144', '1 oz')]"
       ]
      },
-     "execution_count": 6,
+     "execution_count": 3,
      "metadata": {},
      "output_type": "execute_result"
     }
@@ -144,12 +135,117 @@
     "select * from composition limit 10"
    ]
   },
+  {
+   "cell_type": "code",
+   "execution_count": 4,
+   "metadata": {},
+   "outputs": [
+    {
+     "name": "stdout",
+     "output_type": "stream",
+     "text": [
+      " * postgresql://antoniopenta:***@goldsmith.clb2mudtmvnt.eu-central-1.rds.amazonaws.com:5432/goldsmiths\n",
+      "5 rows affected.\n"
+     ]
+    },
+    {
+     "data": {
+      "text/html": [
+       "<table>\n",
+       "    <tr>\n",
+       "        <th>stralcoholic</th>\n",
+       "    </tr>\n",
+       "    <tr>\n",
+       "        <td>None</td>\n",
+       "    </tr>\n",
+       "    <tr>\n",
+       "        <td>Alcoholic</td>\n",
+       "    </tr>\n",
+       "    <tr>\n",
+       "        <td>Optional alcohol</td>\n",
+       "    </tr>\n",
+       "    <tr>\n",
+       "        <td>Non alcoholic</td>\n",
+       "    </tr>\n",
+       "    <tr>\n",
+       "        <td>Non Alcoholic</td>\n",
+       "    </tr>\n",
+       "</table>"
+      ],
+      "text/plain": [
+       "[(None,),\n",
+       " ('Alcoholic',),\n",
+       " ('Optional alcohol',),\n",
+       " ('Non alcoholic',),\n",
+       " ('Non Alcoholic',)]"
+      ]
+     },
+     "execution_count": 4,
+     "metadata": {},
+     "output_type": "execute_result"
+    }
+   ],
+   "source": [
+    "%sql select distinct stralcoholic from cocktail;"
+   ]
+  },
+  {
+   "cell_type": "code",
+   "execution_count": 5,
+   "metadata": {},
+   "outputs": [
+    {
+     "name": "stdout",
+     "output_type": "stream",
+     "text": [
+      " * postgresql://antoniopenta:***@goldsmith.clb2mudtmvnt.eu-central-1.rds.amazonaws.com:5432/goldsmiths\n",
+      "5 rows affected.\n",
+      "+------------------+\n",
+      "|   stralcoholic   |\n",
+      "+------------------+\n",
+      "|       None       |\n",
+      "|    Alcoholic     |\n",
+      "| Optional alcohol |\n",
+      "|  Non alcoholic   |\n",
+      "|  Non Alcoholic   |\n",
+      "+------------------+\n"
+     ]
+    }
+   ],
+   "source": [
+    "result = %sql select distinct stralcoholic from cocktail;\n",
+    "print(result)"
+   ]
+  },
+  {
+   "cell_type": "code",
+   "execution_count": 6,
+   "metadata": {},
+   "outputs": [
+    {
+     "name": "stdout",
+     "output_type": "stream",
+     "text": [
+      " * postgresql://antoniopenta:***@goldsmith.clb2mudtmvnt.eu-central-1.rds.amazonaws.com:5432/goldsmiths\n",
+      "5 rows affected.\n",
+      "['stralcoholic']\n"
+     ]
+    }
+   ],
+   "source": [
+    "result = %sql select distinct stralcoholic from cocktail;\n",
+    "print(result.keys)"
+   ]
+  },
   {
    "cell_type": "code",
    "execution_count": null,
    "metadata": {},
    "outputs": [],
-   "source": []
+   "source": [
+    "result = %sql select distinct stralcoholic from cocktail;\n",
+    "df=pd."
+   ]
   }
  ],
  "metadata": {
