def main(): #drop the database tables #create the database and the tables db.drop_all() db.create_all() # Create stock, out of the box user UserArtV = User(name="Art Vandalay", email="*****@*****.**", picture="/static/costanza.jpg") db.session.add(UserArtV) db.session.commit() category1 = Category(name="Soccer") db.session.add(category1) db.session.commit() category2 = Category(name="Basketball") db.session.add(category2) db.session.commit() category3 = Category(name="Baseball") db.session.add(category3) db.session.commit() category4 = Category(name="Frisbee") db.session.add(category4) db.session.commit() category5 = Category(name="Snowboarding") db.session.add(category5) db.session.commit() category6 = Category(name="Rock Climbing") db.session.add(category6) db.session.commit() category7 = Category(name="Foosball") db.session.add(category7) db.session.commit() category8 = Category(name="Skating") db.session.add(category8) db.session.commit() category9 = Category(name="Hockey") db.session.add(category9) db.session.commit() item1 = Item(user_id=1, name="Stick", description="Interdum odio dignissim in nisi metus\ , a elit sit dis cubilia, fringilla praesent pulvinar porta.\ Sodales hac bibendum", category=category9) db.session.add(item1) db.session.commit() item2 = Item(user_id=1, name="Goggles", description="Primis dignissim mattis erat bibendum eu arcu quis\ cursus", category=category5) db.session.add(item2) db.session.commit() item3 = Item(user_id=1, name="Snowboard", description="Curae feugiat netus auctor lacus", category=category5) db.session.add(item3) db.session.commit() item4 = Item(user_id=1, name="Soccer Item 1", description="Nec odio consectetur cum \ consequat quam massa habitant placerat, nam tincidunt mi egestas \ eu taciti velit dictum aenean, vestibulum inceptos semper \ penatibus proin fringilla quisque. Cursus ridiculus facilisis \ class erat varius cum consequat, ac at justo mattis magna dui \ suscipit interdum, faucibus auctor rhoncus diam parturient a.", category=category1) db.session.add(item4) db.session.commit() item5 = Item(user_id=1, name="Soccer Item 2", description="Fermentum scelerisque \ facilisis tortor rhoncus magna maecenas, blandit ligula metus \ amet congue fames pulvinar, eget aliquam augue eros per. Vel \ etiam dolor ornare aliquet posuere inceptos maecenas nam, varius \ eget ad imperdiet mi phasellus turpis nisl libero, urna \ tristique aptent ultricies taciti montes parturient.", category=category1) db.session.add(item5) db.session.commit() item6 = Item(user_id=1, name="Soccer Item 3", description="Placerat primis taciti etiam \ ut convallis accumsan lorem tortor sapien faucibus cursus, quam \ nulla tempor morbi rhoncus suscipit sociis in litora amet enim, \ praesent aptent bibendum integer ornare dapibus justo rutrum \ aliquet vivamus. Taciti dignissim neque euismod elit maecenas \ aptent interdum mollis vel sociosqu donec, nunc gravida eget ad \ quisque viverra vitae amet hendrerit.", category=category1) db.session.add(item6) db.session.commit() item7 = Item(user_id=1, name="Soccer Item 4", description="Litora turpis et dignissim \ nascetur faucibus taciti vivamus interdum, tempor dapibus lorem \ venenatis enim conubia lacus netus hac, dis magnis vel nulla \ phasellus bibendum fringilla. Sed torquent taciti accumsan elit \ sagittis nulla magnis, sit praesent volutpat nam consectetur \ velit, magna sociis id ultrices diam non.", category=category1) db.session.add(item7) db.session.commit() item8 = Item(user_id=1, name="Frisbee", description="Interdum odio dignissim in nisi \ metus, a elit sit dis cubilia, fringilla praesent pulvinar \ porta. Sodales hac bibendum tincidunt risus mus himenaeos erat \ ac, mollis semper integer tempor lacus turpis libero, ridiculus \ primis curae aliquet nec rhoncus ante.", category=category4) db.session.add(item8) db.session.commit() item9 = Item(user_id=1, name="Bat", description="Primis dignissim mattis erat bibendum eu arcu \ quis cursus", category=category3) db.session.add(item9) db.session.commit() #commit changes db.session.commit() print "Added Categories, Items, and a User."
def tearDown(self): db.session.remove() db.drop_all() self.app_context.pop()
def drop_db(): """Drops the db tables.""" db.drop_all()
from catalog import db from catalog.models import Category db.drop_all() db.create_all() categories = [ "Art and Design", "Biography", "Business", "Crime", "Drama", "Fantasy", "Film and TV", "General Fiction", "History", "Literary Criticism", "Philosophy", "Poetry", "Religion", "Romance", "Science and Nature", "Science Fiction", ] for i, x in enumerate(categories): new_category = Category(name=x) db.session.add(new_category) db.session.commit()
def main(): #drop the database tables #create the database and the tables db.drop_all() db.create_all() # Create stock, out of the box user UserArtV = User(name="Art Vandalay", email="*****@*****.**", picture="/static/costanza.jpg") db.session.add(UserArtV) db.session.commit() category1 = Category(name="Soccer") db.session.add(category1) db.session.commit() category2 = Category(name="Basketball") db.session.add(category2) db.session.commit() category3 = Category(name="Baseball") db.session.add(category3) db.session.commit() category4 = Category(name="Frisbee") db.session.add(category4) db.session.commit() category5 = Category(name="Snowboarding") db.session.add(category5) db.session.commit() category6 = Category(name="Rock Climbing") db.session.add(category6) db.session.commit() category7 = Category(name="Foosball") db.session.add(category7) db.session.commit() category8 = Category(name="Skating") db.session.add(category8) db.session.commit() category9 = Category(name="Hockey") db.session.add(category9) db.session.commit() item1 = Item(user_id=1, name="Stick", description="Interdum odio dignissim in nisi metus\ , a elit sit dis cubilia, fringilla praesent pulvinar porta.\ Sodales hac bibendum", category=category9) db.session.add(item1) db.session.commit() item2 = Item( user_id=1, name="Goggles", description="Primis dignissim mattis erat bibendum eu arcu quis\ cursus", category=category5) db.session.add(item2) db.session.commit() item3 = Item(user_id=1, name="Snowboard", description="Curae feugiat netus auctor lacus", category=category5) db.session.add(item3) db.session.commit() item4 = Item(user_id=1, name="Soccer Item 1", description="Nec odio consectetur cum \ consequat quam massa habitant placerat, nam tincidunt mi egestas \ eu taciti velit dictum aenean, vestibulum inceptos semper \ penatibus proin fringilla quisque. Cursus ridiculus facilisis \ class erat varius cum consequat, ac at justo mattis magna dui \ suscipit interdum, faucibus auctor rhoncus diam parturient a.", category=category1) db.session.add(item4) db.session.commit() item5 = Item(user_id=1, name="Soccer Item 2", description="Fermentum scelerisque \ facilisis tortor rhoncus magna maecenas, blandit ligula metus \ amet congue fames pulvinar, eget aliquam augue eros per. Vel \ etiam dolor ornare aliquet posuere inceptos maecenas nam, varius \ eget ad imperdiet mi phasellus turpis nisl libero, urna \ tristique aptent ultricies taciti montes parturient.", category=category1) db.session.add(item5) db.session.commit() item6 = Item(user_id=1, name="Soccer Item 3", description="Placerat primis taciti etiam \ ut convallis accumsan lorem tortor sapien faucibus cursus, quam \ nulla tempor morbi rhoncus suscipit sociis in litora amet enim, \ praesent aptent bibendum integer ornare dapibus justo rutrum \ aliquet vivamus. Taciti dignissim neque euismod elit maecenas \ aptent interdum mollis vel sociosqu donec, nunc gravida eget ad \ quisque viverra vitae amet hendrerit.", category=category1) db.session.add(item6) db.session.commit() item7 = Item(user_id=1, name="Soccer Item 4", description="Litora turpis et dignissim \ nascetur faucibus taciti vivamus interdum, tempor dapibus lorem \ venenatis enim conubia lacus netus hac, dis magnis vel nulla \ phasellus bibendum fringilla. Sed torquent taciti accumsan elit \ sagittis nulla magnis, sit praesent volutpat nam consectetur \ velit, magna sociis id ultrices diam non.", category=category1) db.session.add(item7) db.session.commit() item8 = Item(user_id=1, name="Frisbee", description="Interdum odio dignissim in nisi \ metus, a elit sit dis cubilia, fringilla praesent pulvinar \ porta. Sodales hac bibendum tincidunt risus mus himenaeos erat \ ac, mollis semper integer tempor lacus turpis libero, ridiculus \ primis curae aliquet nec rhoncus ante.", category=category4) db.session.add(item8) db.session.commit() item9 = Item(user_id=1, name="Bat", description="Primis dignissim mattis erat bibendum eu arcu \ quis cursus", category=category3) db.session.add(item9) db.session.commit() #commit changes db.session.commit() print "Added Categories, Items, and a User."