$9\mathrm{.}8$ LAB $-$ Database programming with Python

LAB

$9\mathrm{.}8\mathrm{.}1$: LAB $-$ Database programming with Python

Complete the Python program to create a Horse table, insert one row, and print the row.

Implement the following functions. Function parameters are described in the template. Do not modify the main program. create$\_$connection$()$ creates a connection to the database. This function calls mysql$.$ connector. connect $()$ with three arguments:

$-$ user$=$'root'

$-$ host$=\text{'}127\mathrm{.}0\mathrm{.}0\mathrm{.}1\text{'}$

$-$ database$=$'zybooksdb'

The password argument is not necessary and can be omitted.

create$\_$table $()$ creates Horse, with five columns:

$-$ ID $-$ integer, primary key

$-$ Name $-$ varchar$(30)$

$-$ Breed $-$ varchar$(30)$

$-$ Height$-$double

$-$ BirthDate $-$ varchar$(10)$

Before creating Horse, drop the table if the table exists $($from a prior run$).$

insert$\_$horse $()$ inserts one row into Horse:

$(1,$ 'Babe', 'Quarter horse', $15\mathrm{.}3,\text{'}2015-02-10\text{'})$

select$\_$all$\_$horses $()$ selects and prints all Horse rows, as follows:

All horses:

$(1,$ 'Babe', 'Quarter Horse', $15\mathrm{.}3,\text{'}2015-02-10\text{'})$

Latest submission $-5$:$06$ PM EST on $11/10/24$

Only show failing tests

Open submission's code

$1$: Unit test all functions

$\backslash (0/9\backslash )$

Test create$\_$connection$(),$ create$\_$table$(),$ and insert$\_$row$()$ functions

Test create$\_$connection$(),$ create$\_$table$(),$ and insert$\_$row$()$ functions

$```$

b$/\_\_$init$\_\_.$py$",$ line $126,$ in import$\_$module

return $\_$bootstrap.$\_$gcd$\_$import$($name$[$level:$],$ package, level$)$

File $"",$ line $1050,$ in $\_$gcd$\_$import

File $"",$ line $1027,$ in $\_$find$\_$and$\_$load

File $"",$ line $1006,$ in $\_$find$\_$and$\_$load$\_$unlocked

File $"",$ line $688,$ in $\_$load$\_$unlocked

File $"",$ line$-883,$ in exec$\_$module

File $"",$ line $241,$ in $\_$call$\_$with$\_$frames$\_$removed

File $"/$usercode$/$coding$\_$rooms$\_$unit$\_$tests.py$",$ line $4$; in

import main

File $"/$usercode$/$main$.$py$",$ line $10,$ in

c$.$execute$(\text{'}\text{'}\text{'}$

sqlite$3.$OperationalError: table stocks already exists

$```$

$2$: Compare output

Compare program output to expected output

$```$

Traceback $($most recent call last$)$:

File $"/$usercode$/$main$.$py$",$ line $10,$ in

c$.$execute$(",\backslash$

sqlite$3.$OperationalError: table stocks already exists

$```$