import sqlite$3$

from sqlite$3$ import Error

# Creates connection to sqlite in$-$memory database

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

$"""$

Create a connection to in$-$memory database

:return: Connection object

$"""$

# YOUR CODE HERE

# Use sqlite$3.$connect$("$:memory:"$)$ to create connection object

return conn

# Creates Horse table

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

$"""$

Create Horse table

:param conn: Connection object

:return: Nothing

$"""$

# YOUR CODE HERE

# Inserts row to Horse table given data tuple

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

$"""$

Create a new row in Horse table

:param conn: Connection object

:param data: tuple of values for new row

:return: Nothing

$"""$

# YOUR CODE HERE

# Use the $?$ character as placeholder for SQLite query parameters

# Selects and prints all rows of Horse table

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

$"""$

Query all rows in the Horse table

:param conn: the Connection object

:return: Nothing

$"""$

# YOUR CODE HERE

# DO NOT MODIFY main

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

# Create connection to sqlite in$-$memroy database

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

if conn is None:

print$("$Error$!$ cannot create the database connection."$)$

# 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

print$("$All horses:"$)$

select$\_$all$\_$horses$($conn$)5\mathrm{.}8$ LAB $-$ Database programming with Python $($SQLite$)$

Complete the Python program to create a Horse table, insert one row, and display the row. The main program calls four functions:

create$\_$connection $()$ creates a connection to the database.

create$\_$table $()$ creates the Horse table.

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

select$\_$all$\_$horses $()$ outputs all Horse rows.

Complete all four functions. Function parameters are described in the template. Do not modify the main program.

The Horse table should have five columns, with the following names, data types, constraints, and values:

$\backslash$table$[[$Name$,$Data type,Constraints,Value$],[$Id$,$integer,primary key, not null,$1],[$Name$,$text,,'Babe'$],[$Breed$,$text,,'Quarter horse'$],[$Height$,$double,,$15\mathrm{.}3],[$BirthDate$,$text,,$2015-02-{10}^{\text{'}}$