示例#1
0
文件： main.py 项目： rtuita23/tbay 
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()
示例#2
0
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)
示例#3
0
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()
示例#4
0
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)
示例#5
0
文件： main.py 项目： eunnah/tbay 
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
示例#6
0
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()