In this assignment, you'll practice accessing data in sqlite$3$ database using Python. We will

use a database of Pokemon as an example

Use the following codes as the basis for this exercise.

import sqlite$3$

# create connection and cursor

conn $=$ sqlite$3.$ connect $(\text{'}$pokemon$.$db$\text{'})$

cursor $=$ conn. cursor $()$

# execute SQL query. In this example, show all data in $[$pokemon$\_$meta$]$ table

cursor.execute$("$SELECT $*$ from $[$pokemon$\_$meta$]")$

rows$=$cursor.fetchall$()$

# print the column names of the table

header$=""$

for column$\_$info in cursor.description:

header$+=$column$\_$info$[$

print$($header$)$

#print the table content

for row in rows:

print$($row$)$

#close connection after using it

conn.close$()$

In the sample codes, cursor. description provides the column names of the last query

$($cursor$.$execute$("$SELECT$*$ from $[$pokemon$\_$meta$]")$ in our case$).$ cursor.description returns a

list of tuple that contains the column information, and the first element of the tuple is the

name of the column. Hence when we iterate through the cursor.description list with

column$\_$info in the first for$-$loop, column$\_$info refers to the tuples in the list one by one, and

column$\_$info$[0]$ refers to the name of a column

The program above reads from a table named $[$pokemon$\_$meta$],$ and show all the content of

the table. Note that in order to run the program, you need to download the pokemon.db file

attached to this assignment and place it in the same folder with the code file.

Task $1$

$(2$points$)$ Extend the program so that it shows a list of all water pokemons instead of all

pokemons. Note either type$\_1$ or type$\_2$ can be "water". So the SQL command to be

used can be something like:

SELECT $*$ from $[$pokemon$\_$meta$]$ WHERE $[$type$\_1]=$'fire' OR

$[$type$\_2]=$'fire'