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’)