Initialise a sqlitedb

db.py

import sqlite3
from aiohttp import web

# create a sqllite db
connection = sqlite3.connect("urlshortner.db")
cursor = connection.cursor()

routes = web.RouteTableDef()

if __name__ == "__main__":    
    cursor.execute("CREATE TABLE IF NOT EXISTS URLSHORTNER (longurl TEXT, shorturl TEXT, code TEXT UNIQUE)")
    app = web.Application()
    app.add_routes(routes)
    web.run_app(app, port=8000)