Write a Python program that connects to a sqlite database. Create a table called Horses with the following fields: id (integer): a primary key and not null name (text) breed (text) height (real) birthday (text) Next, insert the following data row into the Horses table: id: 1 name: 'Babe' breed: 'Quarter Horse' height: 15.3 birthday: '2015-02-10' Output all records from the Horses table. Ex: With the above row inserted, the output should be: All Horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')

Write a Python program that connects to a sqlite database.

Create a table called Horses with the following fields:

• id (integer): a primary key and not null
• name (text)
• breed (text)
• height (real)
• birthday (text)

Next, insert the following data row into the Horses table:

id: 1 name: 'Babe' breed: 'Quarter Horse' height: 15.3 birthday: '2015-02-10'

Output all records from the Horses table.

Ex: With the above row inserted, the output should be:

All Horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')

This is what I came up withbut it doesn't accomplish the task. 

import sqlite3
from sqlite3 import Error

def create_connection(db_file):
""" create a database connection to the SQLite database
specified by db_file
:param db_file: database file
:return: Connection object or None
"""
conn = None
try:
conn = sqlite3.connect(db_file)
return conn
except Error as e:
print(e)

return conn

def create_table(conn, create_table_sql):
""" create a table from the create_table_sql statement
:param conn: Connection object
:param create_table_sql: a CREATE TABLE statement
:return:
"""
try:
cursor = conn.cursor()
cursor.execute(create_table_sql)
except Error as e:
print(e)

def insert_horse(conn_data):
cursor = conn.cursor()
cursor.execute(sql = insert_ horses(id,name,breed,height,birthday)
VALUES(?,?,?,?,?) '''
conn.commit()

def select_all_horses(conn):
cursor = conn.cursor()
cursor.execute(select_all_horses)

rows = cursor. fetchall()

for conn.fetchall
print(row)

if __name__ == '__main__':
database = "HorseTable.db"
conn = create_connection(database)

create_table_sql = """ CREATE TABLE IF NOT EXISTS Horses (
id integer PRIMARY KEY,
name text NOT NULL,
breed text,
height real,
birthday text
); """

create_table(conn, create_table_sql)

data = sql = Horses(id,name,breed,height,birthday)
VALUES(?,?,?,?,?) '''
insert_Horse(conn.data)

print(‘all .Horses)
print(‘Records Inserted’)