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{'})$