quotes_list.py

import sqlite3, requests

# Get data from the Mock API using GET HTTP method
# response data type will be byte

response = requests.get("https://new-age-quotes.herokuapp.com/quotes")

# Check if the request was successful
if response.status_code == 200:
    print('Success!')
elif response.status_code == 404:
    print('Not Found.')


# Convert bytes into a JSON list data
quotes = response.json()

# Create an empty database
connection = sqlite3.connect('quotes_list.db')

# communication with database via cursor with SQL commands
cursor = connection.cursor()

# Create table/s for our database
cursor.execute("create table quotes (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)")

# Fill that table
for i in range(len(quotes)):
    cursor.execute("insert into quotes (name) values (?)",[quotes[i]])
    print("added->", quotes[i])

# Do not forget to save (commit) and close the database connection
connection.commit()
connection.close()