def main(): # Creating rows for User table user = session.query(User).first() user.username = '******' session.commit() # Creating rows for Item table ball = Item() ball.name = 'ball' ball.description = 'Basketball' ball.start_time = datetime.utcnow session.add(ball) session.commit()
chris.username = "******" chris.password = "******" session.add(chris) session.commit() ashley = User(username = "******", password = "******") session.add(ashley) session.commit() lianna = User(username = "******", password = "******") session.add(lianna) session.commit() baseball = Item() baseball.name = "Giants World Series 2014" baseball.description = "Foul ball in game 2" chris.items.append(baseball) session.add(baseball) session.commit() guitar = Item(name = "Fender", description = "rock out with this electric guitar") ashley.items.append(guitar) session.add(guitar) session.commit() bid_ashley = Bid(price = 5000, item = baseball, bidder = ashley) session.add(bid_ashley) session.commit() bid_lianna = Bid(price = 2500, item = baseball, bidder = lianna) session.add(bid_lianna)
john.id = 1 john.username = "******" john.password = "******" session.add(john) session.commit() angela = User() angela.id = 2 angela.username = "******" angela.password = "******" session.add(angela) session.commit() car = Item() car.id = 1 car.name = "honda" car.description = "2005 japanese car in blue" session.add(car) session.commit() bike = Item() bike.id = 2 bike.name = "gt" bike.description = "2012 black bicycle" session.add(bike) session.commit()
jp = User() jp.username = "******" jp.password = "******" session.add(jp) session.commit() jenna = User() jenna.username = "******" jenna.password = "******" session.add(jenna) session.commit() baseball = Item() baseball.name='1986 World Series Baseball' baseball.description='A baseball signed by the 1986 NY Mets' baseball.user=jp session.add(baseball) session.commit() shirt = Item() shirt.name='U2 World Tour' shirt.description='A T-Shirt from the U2 1989 World Tour' shirt.user=jenna session.add(shirt) session.commit() """ #make one user auction a baseball ''' baseball = Item(name='1986 World Series Baseball', description='A baseball signed by the 1986 NY Mets', start_time='', owner=jp)
jayz.username = "******" jayz.password = "******" jayz.id = "56" session.add(jayz) session.commit() solange = User() solange.username = "******" solange.password = "******" solange.id = "1234" session.add(solange) session.commit() crown = Item() crown.name = "crown" crown.description = "a beautiful crown" crown.seller_id = solange.id session.add(crown) session.commit() baseball = Item() baseball.name = "baseball" baseball.description = "a beautiful golden baseball" baseball.seller_id = solange.id session.add(baseball) session.commit() jayzbid = Bid() jayzbid.price = 3 jayzbid.bidder_id = jayz.id jayzbid.bidded_item = baseball.id
session.commit() jaimie = User() jaimie.username = "******" jaimie.password = "******" session.add(jaimie) session.commit() #make one user auction a baseball ''' baseball = Item(name='1986 World Series Baseball', description='A baseball signed by the 1986 NY Mets', start_time='', owner=jp) ''' baseball = Item() baseball.name='1986 World Series Baseball' baseball.description='A baseball signed by the 1986 NY Mets' baseball.user=jp session.add(baseball) session.commit() #Have each other user place two bids on the baseball ''' bid1 = Bid(price=75.00, bidder=jenna, auction_item=baseball) ''' bid1 = Bid() bid1.price=75.00 bid1.bidder=jenna bid1.item=baseball session.add(bid1) session.commit()