db_seed.py

from app import app, db
from app.models import User, Feed

app.config["DEBUG"] = True
SQLALCHEMY_ECHO = True
SQLALCHEMY_DATABASE_URI = "sqlite:///app.db"

print("\nCreating DB Tables")
try:
    db.drop_all()
    db.create_all()
    print("Tables Created")
except Exception as e:
    print(e)
    print("Problem creating tables. Check DB connection parameters")

try:
    user = User()
    user.id = 0
    user.username = "admin"
    user.password = (
        "$2b$12$K6WtZoPwFi8yLmu20za5E.mJiW15vYmHDYJ1jLxR9IytJrSV/x32y"  # admin
    )
    db.session.add(user)
    db.session.commit()
    print("User created admin/admin")
except Exception as e:
    print(e)
    print("Problem in User creation")

try:
    user = User()
    user.id = 1
    user.username = "user"
    user.password = (
        "$2b$12$Sr35sAoWxKuq3hY8rf6yC.LjVHDd1ZF6jgsUZYGqvS1Mt3f7S4eSy"  # user
    )
    db.session.add(user)
    db.session.commit()
    print("User created user/user")
except Exception as e:
    print(e)
    print("Problem in User creation")

try:
    feed = Feed()
    feed.id = 1
    feed.name = "HowToGeek"
    feed.url = "https://feeds.howtogeek.com/HowToGeek"
    feed.user_id = 0
    db.session.add(feed)
    db.session.commit()
    print("Feed created")
except Exception as e:
    print(e)
    print("Problem in Feed creation")


try:
    feed = Feed()
    feed.id = 2
    feed.name = "BBC-Tech"
    feed.url = "http://feeds.bbci.co.uk/news/technology/rss.xml"
    feed.user_id = 0
    db.session.add(feed)
    db.session.commit()
    print("Feed created")
except Exception as e:
    print(e)
    print("Problem in Feed creation")