def setUpClass(cls): db.session.rollback() Pet.query.delete() db.session.commit() Specie.query.delete() db.session.commit() cat = Specie(species="cat") dog = Specie(species="dog") por = Specie(species="porcupine") db.session.add_all([cat, dog, por]) db.session.commit() pet1 = Pet(name="Woofly", species_id=2, photo_url="http://127.0.0.1:5000/static/images/woofly.png", age=1, notes="woofly-notes") pet2 = Pet( name="Taylor", species_id=1, photo_url="http://127.0.0.1:5000/static/images/taylor.jpg", age=8, notes= "A truly lovable, friendly cat!! Any adoptee will be lucky to have her.", available=False) db.session.add(pet1) db.session.commit() db.session.add(pet2) db.session.commit()
def setUpClass(cls): db.session.rollback() Pet.query.delete() db.session.commit() Specie.query.delete() db.session.commit() cat = Specie(species="cat") dog = Specie(species="dog") por = Specie(species="porcupine") db.session.add_all([cat, dog, por]) db.session.commit()
from app import db from models import Specie, Pet db.drop_all() db.create_all() cat = Specie(species="cat") dog = Specie(species="dog") por = Specie(species="porcupine") db.session.add_all([cat, dog, por]) db.session.commit() woof = Pet(name="Woofly", species_id=2, photo_url="/static/images/woofly.png", age=1) tay = Pet( name="Taylor", species_id=1, photo_url="/static/images/taylor.jpg", age=8, notes= "A truly lovable, friendly cat!! Any adoptee will be lucky to have her.", available=False) porc = Pet(name="Porchetta", species_id=3, photo_url="/static/images/porchetta.png", age=1, available=True) snar = Pet(name="Snargle", species_id=1,
"""Seed file to make sample data for adopt db.""" from models import Pet, Specie, PetSpeciesTag, db from app import app # Create all tables db.session.rollback() db.drop_all() db.create_all() ####### add species ####### pet = Specie(species="Cat") pet2 = Specie(species="Porcupine") pet3 = Specie(species="Dog") pets = [pet, pet2, pet3] db.session.add_all(pets) db.session.commit() ####### add Pets ####### whiskers = Pet( name="Whiskers", specie_id=1, image_url="https://static01.nyt.com/images/2019/12/20/arts/00cats-1/00cats-1-videoSixteenByNineJumbo1600-v3.jpg", age=2, notes="fun and playful cat...", available=True, ) supercat = Pet(