init_db.py

import sqlite3

connection = sqlite3.connect("database.db")


with open("pokedex/schema.sql") as f:
    connection.executescript(f.read())

cur = connection.cursor()

with open("pokemon.txt") as file:
    lines = file.readlines()
    pokemon_number = 1
    for line in lines:
        name, description = line.split(";")
        cur.execute(
            f"INSERT INTO POKEDEX (id, pokemon_name, image_url, description) VALUES ("
            f"{pokemon_number}, "
            f'"{name}", '
            f'"https://raw.githubusercontent.com/PokeAPI/sprites/master/sprites/pokemon/{pokemon_number}.png", '
            f'"{description}")'
        )
        pokemon_number += 1

cur.execute('INSERT INTO SUBSCRIBERS (id, email) VALUES (1, "subscriber1@example.com")')
cur.execute('INSERT INTO SUBSCRIBERS (id, email) VALUES (2, "subscriber2@example.com")')

connection.commit()
connection.close()