# create sqlite table and populate with data
import sqlite3

with sqlite3.connect("blog.db") as connection:
    # get cursot to execute command
    c = connection.cursor()

    # create table
    c.execute("""create table posts
                (title text, post text) 
            """)

    # insert data into table
    c.execute('insert into posts values("Good", "I\'m good")')
    c.execute('insert into posts values("Well", "I\'m well")')
    c.execute('insert into posts values("Excellent", "I\'m excellent")')
    c.execute('insert into posts values("fine", "I\'m fine")')

    
