# SQLKids1 Example
# Create an SQL table using hardcoded Python statements.

import sqlite3

# Create database connection.
conn = sqlite3.connect('kids1.db')

# Create a Cursor object, that is responsable
# for executing SQL statements.
cur = conn.cursor( )

# Create kids table.
cur.execute( \
'''create table if not exists kids(
       name varchar(10),
       gender varchar(1),
       age integer);''')

# Populate kids table.
cur.execute( \
    "insert into kids values('Alice', 'F', 11);")
cur.execute( \
    "insert into kids values('Chad', 'M', 12);")
cur.execute( \
    "insert into kids values('Sally', 'F', 9);")
cur.execute( \
    "insert into kids values('Jason', 'M', 10);")

# Commit changes.
conn.commit( )

# Query kids table.
cur.execute("select * from kids;")

# Print results from query
print(cur.fetchall( ))

# Close database.
conn.close( )