Anonymous user
JeopardyDatabase: Difference between revisions
no edit summary
imported>Jesstess (Created page with "right|300px == Project == Learn how to get data from a database in Python while writing parts of a Jeopardy game, using real Jeopardy data! == G...") |
imported>Jesstess No edit summary |
||
Line 32:
<pre>sqlite3 jeopardy.db < jeopardy.dump</pre>
This creates a sqlite3 database called <code>jeopardy.db</code>
=== Test your setup ===
<pre>sqlite3 jeopardy.db</pre>
That should start a sqlite prompt that looks like this:
<pre>
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite></pre>
At that sqlite prompt, type <code>.tables</code> and hit enter. That should display a list of the tables in this database:
<pre>sqlite> .tables
category clue
sqlite></pre>
From a command prompt, navigate to the <code>JeopardyDatabase</code> directory and run
<pre>python
You should see a
== Project steps ==
| |||