# SQLKids2 Example
# Create an SQL table using data read from keyboard

import sqlite3

# Attach to database created by SQLKids2 Example.
conn = sqlite3.connect('kids2.db')
cur = conn.cursor( )

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

# Read data from keyboard.
name = input("Enter name: ")
gender = input("Enter gender: ")
age = int(input("Enter age: "))
          
# Insert values into database.
cur.execute(f'''insert into kids values(
  '{name}', '{gender}', {age});''')

# Commit changes.
conn.commit( )

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

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

# Close database.
conn.close( )