Esempio n. 1
0
    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,
Esempio n. 4
0
"""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(