Skip to content

Commit 2aad4fc

Browse files
meatballsmeatballs
committed
Update notebooks
1 parent 8610fa6 commit 2aad4fc

6 files changed

Lines changed: 58 additions & 23 deletions

File tree

‎chapters/01/index.html‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -76,7 +76,7 @@ <h1 id="Let's-Create-a-Database!">Let's Create a Database!<a class="anchor-link"
7676
</div>
7777
<div class="cell border-box-sizing code_cell rendered">
7878
<div class="input">
79-
<div class="prompt input_prompt">In&nbsp;[2]:</div>
79+
<div class="prompt input_prompt">In&nbsp;[1]:</div>
8080
<div class="inner_cell">
8181
<div class="input_area">
8282
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">import</span> <span class="nn">sqlalchemy</span> <span class="k">as</span> <span class="nn">sa</span>
@@ -104,7 +104,7 @@ <h1 id="Let's-Create-a-Database!">Let's Create a Database!<a class="anchor-link"
104104
</div>
105105
<div class="cell border-box-sizing code_cell rendered">
106106
<div class="input">
107-
<div class="prompt input_prompt">In&nbsp;[3]:</div>
107+
<div class="prompt input_prompt">In&nbsp;[2]:</div>
108108
<div class="inner_cell">
109109
<div class="input_area">
110110
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">engine</span> <span class="o">=</span> <span class="n">sa</span><span class="o">.</span><span class="n">create_engine</span><span class="p">(</span><span class="s1">&#39;sqlite:///flight.db&#39;</span><span class="p">)</span>
@@ -127,7 +127,7 @@ <h1 id="Let's-Create-a-Database!">Let's Create a Database!<a class="anchor-link"
127127
</div>
128128
<div class="cell border-box-sizing code_cell rendered">
129129
<div class="input">
130-
<div class="prompt input_prompt">In&nbsp;[4]:</div>
130+
<div class="prompt input_prompt">In&nbsp;[3]:</div>
131131
<div class="inner_cell">
132132
<div class="input_area">
133133
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">connection</span> <span class="o">=</span> <span class="n">engine</span><span class="o">.</span><span class="n">connect</span><span class="p">()</span>

‎chapters/02/index.html‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -76,7 +76,7 @@ <h1 id="Create-a-Table">Create a Table<a class="anchor-link" href="#Create-a-Tab
7676
</div>
7777
<div class="cell border-box-sizing code_cell rendered">
7878
<div class="input">
79-
<div class="prompt input_prompt">In&nbsp;[4]:</div>
79+
<div class="prompt input_prompt">In&nbsp;[1]:</div>
8080
<div class="inner_cell">
8181
<div class="input_area">
8282
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">import</span> <span class="nn">sqlalchemy</span> <span class="k">as</span> <span class="nn">sa</span>
@@ -182,7 +182,7 @@ <h1 id="Create-a-Table">Create a Table<a class="anchor-link" href="#Create-a-Tab
182182
</div>
183183
<div class="cell border-box-sizing code_cell rendered">
184184
<div class="input">
185-
<div class="prompt input_prompt">In&nbsp;[5]:</div>
185+
<div class="prompt input_prompt">In&nbsp;[2]:</div>
186186
<div class="inner_cell">
187187
<div class="input_area">
188188
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">sql</span> <span class="o">=</span> <span class="s2">&quot;&quot;&quot;</span>
@@ -215,13 +215,13 @@ <h1 id="Create-a-Table">Create a Table<a class="anchor-link" href="#Create-a-Tab
215215

216216
<div class="output_area">
217217

218-
<div class="prompt output_prompt">Out[5]:</div>
218+
<div class="prompt output_prompt">Out[2]:</div>
219219

220220

221221

222222

223223
<div class="output_text output_subarea output_execute_result">
224-
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x10ef4b8d0&gt;</pre>
224+
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x10eccd0f0&gt;</pre>
225225
</div>
226226

227227
</div>

‎chapters/03/index.html‎

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -76,7 +76,7 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
7676
</div>
7777
<div class="cell border-box-sizing code_cell rendered">
7878
<div class="input">
79-
<div class="prompt input_prompt">In&nbsp;[1]:</div>
79+
<div class="prompt input_prompt">In&nbsp;[4]:</div>
8080
<div class="inner_cell">
8181
<div class="input_area">
8282
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">import</span> <span class="nn">sqlalchemy</span> <span class="k">as</span> <span class="nn">sa</span>
@@ -106,7 +106,7 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
106106
</div>
107107
<div class="cell border-box-sizing code_cell rendered">
108108
<div class="input">
109-
<div class="prompt input_prompt">In&nbsp;[2]:</div>
109+
<div class="prompt input_prompt">In&nbsp;[5]:</div>
110110
<div class="inner_cell">
111111
<div class="input_area">
112112
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">sql</span> <span class="o">=</span> <span class="s2">&quot;&quot;&quot;</span>
@@ -126,13 +126,13 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
126126

127127
<div class="output_area">
128128

129-
<div class="prompt output_prompt">Out[2]:</div>
129+
<div class="prompt output_prompt">Out[5]:</div>
130130

131131

132132

133133

134134
<div class="output_text output_subarea output_execute_result">
135-
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x10bdf1320&gt;</pre>
135+
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x11249e400&gt;</pre>
136136
</div>
137137

138138
</div>
@@ -158,7 +158,7 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
158158
</div>
159159
<div class="cell border-box-sizing code_cell rendered">
160160
<div class="input">
161-
<div class="prompt input_prompt">In&nbsp;[3]:</div>
161+
<div class="prompt input_prompt">In&nbsp;[6]:</div>
162162
<div class="inner_cell">
163163
<div class="input_area">
164164
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">sql</span> <span class="o">=</span> <span class="s2">&quot;&quot;&quot;</span>
@@ -180,13 +180,13 @@ <h1 id="Add-Some-Data">Add Some Data<a class="anchor-link" href="#Add-Some-Data"
180180

181181
<div class="output_area">
182182

183-
<div class="prompt output_prompt">Out[3]:</div>
183+
<div class="prompt output_prompt">Out[6]:</div>
184184

185185

186186

187187

188188
<div class="output_text output_subarea output_execute_result">
189-
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x10c210518&gt;</pre>
189+
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x1124aa320&gt;</pre>
190190
</div>
191191

192192
</div>

‎chapters/05/index.html‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -76,7 +76,7 @@ <h1 id="Let's-Change-What-We-Added">Let's Change What We Added<a class="anchor-l
7676
</div>
7777
<div class="cell border-box-sizing code_cell rendered">
7878
<div class="input">
79-
<div class="prompt input_prompt">In&nbsp;[6]:</div>
79+
<div class="prompt input_prompt">In&nbsp;[1]:</div>
8080
<div class="inner_cell">
8181
<div class="input_area">
8282
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">import</span> <span class="nn">sqlalchemy</span> <span class="k">as</span> <span class="nn">sa</span>
@@ -97,7 +97,7 @@ <h1 id="Let's-Change-What-We-Added">Let's Change What We Added<a class="anchor-l
9797

9898
<div class="output_area">
9999

100-
<div class="prompt output_prompt">Out[6]:</div>
100+
<div class="prompt output_prompt">Out[1]:</div>
101101

102102

103103

@@ -196,7 +196,7 @@ <h1 id="Let's-Change-What-We-Added">Let's Change What We Added<a class="anchor-l
196196
</div>
197197
<div class="cell border-box-sizing code_cell rendered">
198198
<div class="input">
199-
<div class="prompt input_prompt">In&nbsp;[5]:</div>
199+
<div class="prompt input_prompt">In&nbsp;[2]:</div>
200200
<div class="inner_cell">
201201
<div class="input_area">
202202
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">sql</span> <span class="o">=</span> <span class="s2">&quot;&quot;&quot;</span>
@@ -218,7 +218,7 @@ <h1 id="Let's-Change-What-We-Added">Let's Change What We Added<a class="anchor-l
218218

219219
<div class="output_area">
220220

221-
<div class="prompt output_prompt">Out[5]:</div>
221+
<div class="prompt output_prompt">Out[2]:</div>
222222

223223

224224

‎chapters/06/index.html‎

Lines changed: 39 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -159,8 +159,8 @@ <h1 id="Delete-Some-Data">Delete Some Data<a class="anchor-link" href="#Delete-S
159159
<td>hab1</td>
160160
<td>2015-01-01 09:02:00</td>
161161
<td>25.5</td>
162-
<td>1019</td>
163-
<td>41</td>
162+
<td>1021</td>
163+
<td>42</td>
164164
<td>0.0</td>
165165
<td>0.0</td>
166166
<td>0.0</td>
@@ -259,8 +259,8 @@ <h1 id="Delete-Some-Data">Delete Some Data<a class="anchor-link" href="#Delete-S
259259
<td>hab1</td>
260260
<td>2015-01-01 09:02:00</td>
261261
<td>25.5</td>
262-
<td>1019</td>
263-
<td>41</td>
262+
<td>1021</td>
263+
<td>42</td>
264264
<td>0.0</td>
265265
<td>0.0</td>
266266
<td>0.0</td>
@@ -359,9 +359,44 @@ <h1 id="Delete-Some-Data">Delete Some Data<a class="anchor-link" href="#Delete-S
359359
<div class="inner_cell">
360360
<div class="text_cell_render border-box-sizing rendered_html">
361361
<p>And now our table is back to its empty state just as when we first created it.</p>
362+
<p>If we want to delete the table itself, we use a DROP statement.</p>
363+
<p>Let's try it:</p>
364+
365+
</div>
366+
</div>
367+
</div>
368+
<div class="cell border-box-sizing code_cell rendered">
369+
<div class="input">
370+
<div class="prompt input_prompt">In&nbsp;[8]:</div>
371+
<div class="inner_cell">
372+
<div class="input_area">
373+
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">connection</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s2">&quot;DROP TABLE readings&quot;</span><span class="p">)</span>
374+
</pre></div>
375+
376+
</div>
377+
</div>
378+
</div>
362379

380+
<div class="output_wrapper">
381+
<div class="output">
382+
383+
384+
<div class="output_area">
385+
386+
<div class="prompt output_prompt">Out[8]:</div>
387+
388+
389+
390+
391+
<div class="output_text output_subarea output_execute_result">
392+
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x105202d30&gt;</pre>
363393
</div>
394+
364395
</div>
396+
397+
</div>
398+
</div>
399+
365400
</div>
366401

367402

‎notebooks‎

0 commit comments

Comments
 (0)