Bookshelf DB to practice SQLite

create_bookshelf.py

#!/usr/bin/python3

import cgitb
cgitb.enable

from helper import showData

import sqlite3

con = sqlite3.connect('database/bookshelf.db')
sql = con.cursor()

query = """
    CREATE TABLE IF NOT EXISTS programming_books(
        title TEXT,
        author TEXT,
        num_pages INTEGER,
        price REAL
    )
"""
sql.execute(query)

programming_books = [
    [
        'Effective Java', 
        'Joshua Bloch',
        392,
        54.99,
    ],
    [
        'Problem Solving With Algorithms And Data Structures Using Python',
        'Bradley Miller',
        425,
        35.99,
    ],
    [
        'Flask Web Development',
        'Miguel Grinberg',
        291,
        44.99,
    ],
]

for programming_book in programming_books:
    query = "INSERT INTO programming_books VALUES(?, ?, ?, ?)"
    sql.execute(query, programming_book)