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 coursor.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.

Task $2$

Currently, the table did not reflect the fact that Squirtle can evolve into Wartortle, and

Wartotle evolve into Blastoise

$(2$ points$)$ Extend the program, so that it updates the $[$pokemon$\_$meta$]$ table, so that the

$[$evolve$\_$into$]$ column reflects the correct evolution relationship between Squirtle,

Wartortle, and Blastoise.

You will need to use update command for Squirtle and Wartortle. For example for

Squirtle:

UPDATE $[$pokemon$\_$meta$]$ set $[$evolve$\_$to$]=$'Wartortle' WHERE

$[$name$]=\text{'}$ Squirtle' $\text{'}$

Don't forget to commit the changes

$(1$ point$)$ print out the updated records for Squirtle, Wartortle, and Blastoise to double

check your results.

Your output should look like the following $($with headings$)$:

$pokede{x}_{\text{I}}D,$ name, $typ{e}_1,typ{e}_2,bas{e}_w$eight, base height, catch chance, base $cp,$ candy type, egg type, evolve $to$

$(7,$ 'Squirtle', 'water', 'None', $9\mathrm{.}0,0\mathrm{.}5,0\mathrm{.}9,32,$ 'Squirtle Candy', $5,$ 'Wartortle', $25)$

$(8,$ 'Wartortle', 'water', 'None', $22\mathrm{.}5,1\mathrm{.}0,0\mathrm{.}8,40,$ 'Squirtle Candy', $,$ 'Blastoise', $100)$

$(9,$ 'Blastoise', 'water', 'None', $85\mathrm{.}5,1\mathrm{.}6,0\mathrm{.}3,53,$ 'Squirtle Candy', $0,$ 'None', $-1)$