import mysql$.$connector

import sys

import time

# Create a database connection

def create$\_$connection$()$:

$"""$

$$ Create a connection to 'zybooksdb' database

$$ :return: Connection object

$"""$

$$ # YOUR CODE HERE

$$ conn $=$ mysql$.$connector.connect$($

$$ user $=$ 'root',

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

$$ database $=$ 'zybooksdb'

$)$

$$ return conn

# Create Horse table

def create$\_$table$($conn$)$:

$"""$

$$ Create Horse table

$$ :param conn: Connection object

$$ :return: Nothing

$"""$

$$ cursor $=$ conn.cursor$()$

# YOUR CODE HERE

$$ cursor.execute$("$DROP TABLE IF EXISTS Horse"$)$

$$ cursor.execute$("""$

$$ CREATE TABLE Horse $($

$$ ID INT PRIMARY KEY,

$$ Nmae VARCHAR$(30),$

$$ Breed VARCHAR$(30),$

$$ Height DOUBLE,

$$ BirthDatr VARCHAR$(10)$

$)$

$""")$

# Insert row to Horse table using paramenters

def insert$\_$horse$($conn$,$ horse$\_$data$)$:

$"""$

$$ Create a new row in Horse table

$$ :param conn: Connection object

$$ :param data: Tuple of values to be inserted in row

$$ :return: Nothing

$"""$

$$

$$ # YOUR CODE HERE

$$ cursor $=$ conn.cursor$()$

$$ insert$\_$query$="""$

$$ INSERT INTO Horse $($ID$,$ Name, Breed, Height, BirthDate$)$

$$ VALUES $(\%$s$,\%$s$,\%$s$,\%$s$,\%$s$)$

$"""$

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

$$ cursor.execute$($insert$\_$query, horse$\_$data$)$

$$ conn.commit$()$

# Select and print all rows of Horse table

def select$\_$all$\_$horses$($conn$)$:

$"""$

$$ Query all rows in the Horse table

$$ :param conn: Connection object

$$ :return: Nothing

$"""$

$$

$$ # YOUR CODE HERE

$$ cursor $=$ conn.CURSOR$()$

$$ cursor.execute$("$select $*$ FROM Horse"$)$

$$ rows $=$ cursor.fetchall$()$

$$ for row in rows:

$$ Print$($row$)$

# DO NOT MODIFY main

if $\_\_$name$\_\_==\text{'}\_\_$main$\_\_\text{'}$:

$$ # Create database connection

$$ conn $=$ create$\_$connection$()$

$$ if conn is None:

$$ exit$()$

$$ # Create Horse table

$$ create$\_$table$($conn$)$

$$

$$ # Insert row to Horse table

$$ horse$\_$data $=(1,$ "Babe", "Quarter Horse", $15\mathrm{.}3,"2015-02-10")$

$$ insert$\_$horse$($conn$,$ horse$\_$data$)$

$$ # Select and print all Horse table rows

$$ select$\_$all$\_$horses$($conn$)$

$$ conn.close$()$