def bid():
finished = False
while not finished:
biduser = raw_input(
"Please enter the user who wishes to place a bid: ")
biduser = session.query(User).filter(User.username == biduser).first()
biditem = raw_input("What item would you like to bid on? ")
biditem = session.query(Item).filter(Item.itemname == biditem).first()
print "what is the about of your bid?"
newbid = Bid(price=int(raw_input()))
session.add(newbid)
biduser.userbids.append(newbid)
biditem.item_bids.append(newbid)
session.commit()
print "would you like to bid on another item? Y/N: "
answer = raw_input()
if answer == "n":
main()
def query():
finished = False
while not finished:
print "Please see below for a listing of all items up for auction and their bids:"
print ""
results = session.query(User).all()
for result in results:
print result.username
for item in result.items:
print "item =", item.itemname
for bids in result.userbids:
print "bids =", bids.biditem.itemname, ": ", bids.price
print ""
maxbid = (session.query(Bid).order_by(Bid.price.desc()).limit(1))
for maxi in maxbid:
print "And the highest bid is from:", maxi.biduser.username, "with", maxi.price, "dollars!"
print "Congratulations", maxi.biduser.username, "you are now the proud owner of a shiny new", bids.biditem.itemname, "!"
print ""
print "Would you like to run another query? Y/N?: "
answer = raw_input()
if answer == "n":
main()
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()
def item():
finished = False
while not finished:
print "Please enter the user name for the user who would like to enter an item for auction: "
username = raw_input()
itemuser = session.query(User).filter(
User.username == username).first()
print "Please enter the name of the item you would llike to put up for auction: "
newitem = Item()
newitem.itemname = raw_input()
print "Enter a description of the item: "
newitem.itemdescription = raw_input()
itemuser.items.append(newitem)
session.commit()
print "would you like to add additional items? Y/N: "
answer = raw_input()
if answer == "n":
main()
def main():
# add users
beyonce = User(username="******", password="******")
ariana = User(username="******", password="******")
miley = User(username="******", password="******")
session.add_all([beyonce, ariana, miley])
session.commit()
# Make one user auction a baseball
baseball = Item(name="baseball",
description="Baseball from Babe Ruth's first home run",
seller=ariana)
session.add(baseball)
session.commit()
print("{} started an auction for {} at {}".format(
baseball.seller, baseball.name,
baseball.start_time.strftime('%m/%d/%y')))
# Have each other use two bids on the baseball
starting_bid = Bid(price=100.00, item=baseball, bidder=ariana)
bknowles_bid = Bid(price=150.00, item=baseball, bidder=beyonce)
mcyrus_bid = Bid(price=200.00, item=baseball, bidder=miley)
bid_list = [bknowles_bid, mcyrus_bid]
session.add_all([starting_bid, bknowles_bid, mcyrus_bid])
session.commit()
for bid in bid_list:
print("{} placed a bid on a {} for {}".format(bid.bidder, bid.item,
bid.price))
# Perform a query to find out which user placed the highest bid
highest_bid = session.query(Bid).order_by(Bid.price.desc()).first()
print("{} had the highest bid at ${}".format(highest_bid.bidder.username,
highest_bid.price))
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) session.commit() highest_bid = session.query(Bid).filter(Bid.item==baseball).order_by(Bid.price.desc()).first() #bid = session.query(Bid).(baseball) #session.query(Bid).filter(price>3000) print highest_bid.bidder.username
beyonce = User() beyonce.username = "******" beyonce.password = "******" session.add(beyonce) patricia = User(username="******", password="******") session.add(patricia) session.commit() # Returns a list of all of the user objects # Note that user objects won't display very prettily by default - # you'll see their type (User) and their internal identifiers. session.query(User).all() # Returns a list of all of the user objects # Returns the first user session.query(User.username).first() # Finds the user with the primary key equal to 1 session.query(User).get(1) # Returns a list of all of the usernames in ascending order session.query(User.username).order_by(User.username).all() # # Returns the description of all of the basesballs # session.query(Item.description).filter(Item.name == "baseball").all() # Return the item id and description for all baseballs which were created in the past. Remember to import the datetime object: from datetime import datetime # session.query(Item.id, Item.description).filter(Item.name == "baseball", Item.start_time < datetime.utcnow()).all()
user_id = Column(Integer, ForeignKey('users.id'), nullable=False)
user = relationship('User', backref='bids')
Base.metadata.create_all(engine)
if __name__ == '__main__':
from tbay import session
from sqlalchemy import desc
beyonce = User(username='******', password='******')
christina = User(username='******', password='******')
britney = User(username='******', password='******')
microphone = Item(name="microphone", description="Mika's gold microphone.")
bids = [
Bid(price=500.0, user=christina, item=microphone),
Bid(price=1150.0, user=beyonce, item=microphone),
Bid(price=200.0, user=christina, item=microphone),
Bid(price=201.0, user=beyonce, item=microphone),
]
session.add_all([beyonce, christina, britney, microphone] + bids)
session.commit()
highest_bid = (session.query(Bid).filter(Bid.item == microphone).order_by(
desc(Bid.price)).first())
print(highest_bid.user.username)
print(highest_bid.item.description)
from tbay import User, Item, Bid, session perry = User(name="Perry",password="******") baseball = Item(name="BaseBall") perry.items = [baseball] jesse = User(name="Jesse",password="******") monica = User(name="Monica",password="******") bid1 = Bid(price=23.8,bidder=jesse,item=baseball) bid2 = Bid(price=18.5, bidder=monica,item=baseball) session.add_all([perry, jesse, monica, baseball, bid1, bid2]) session.commit() highestBid = session.query(Bid).order_by(Bid.price.desc()).first() print(highestBid.price, highestBid.bidder.name)
from tbay import User, Item, bid, session Charlie = User(user_name="Cgozalez", password="******") session.add(Charlie) Daniel = User(user_name="Dsmith", password="******") session.add(Daniel) Spec = Item(name="Spec", description="design") session.add(Spec) Blackrain = Item(name="Black Rain", description="cloud") session.add(Blackrain) session.commit() print(session.query(User).all())
from tbay import User, Item, Bid, session
from datetime import datetime
#name = Column(String, nullable=False)
#password = Column(String, nullable=False)
#beyonce = User(id=1, name = "Beyonce", password = "******")
#session.add(beyonce)
#session.commit()
# Query the database
print("Printing the first user ")
firstuser = session.query(User).first()
print("First: {}".format(firstuser))
print("Printing all the rows from the User table ")
userlist = []
userlist = session.query(User).all()
for user in userlist:
print("user {}".format(user))
print "Return a user with a user id of 2"
id = 1
user = session.query(User).get(id)
print "User with {} and user is {}".format(id,user)
print "Returning all users orderend by name in ascending order"
userlist = []
userlist = session.query(User.name).order_by(User.name).all()
for user in userlist:
print("user {}".format(user))
from tbay import User, Item, Bid, session
from datetime import datetime
#name = Column(String, nullable=False)
#password = Column(String, nullable=False)
#beyonce = User(id=1, name = "Beyonce", password = "******")
#session.add(beyonce)
#session.commit()
# Query the database
print("Printing the first user ")
firstuser = session.query(User).first()
print("First: {}".format(firstuser))
print("Printing all the rows from the User table ")
userlist = []
userlist = session.query(User).all()
for user in userlist:
print("user {}".format(user))
print "Return a user with a user id of 2"
id = 1
user = session.query(User).get(id)
print "User with {} and user is {}".format(id, user)
print "Returning all users orderend by name in ascending order"
userlist = []
userlist = session.query(User.name).order_by(User.name).all()
for user in userlist:
print("user {}".format(user))
bid3 = Bid()
bid3.price=90.00
bid3.bidder=jenna
bid3.item=baseball
session.add(bid3)
session.commit()
bid4 = Bid()
bid4.price=95.00
bid4.bidder=jaimie
bid4.item=baseball
session.add(bid4)
session.commit()
item_list = session.query(Item).all()
print(item_list[0].bids)
for bid in item_list[0].bids:
print(bid.price)
bids = session.query(Bid).filter(Bid.item == item_list[0]).order_by(desc(Bid.price)).all()
for x in bids:
print(x.price)
print(x.bidder.username)
print("The winner is: ")
print(bids[0].bidder.username)
"""
from tbay import Item, User, Bid, session jp = User() jp.username = "******" jp.password = "******" session.add(jp) session.commit() jenna = User() jenna.username = "******" jenna.password = "******" session.add(jenna) session.commit() toy = Item() toy.name = "boat" toy.user = jp session.add(toy) session.commit() user_jp = session.query(User).filter(User.username == "jpc").first() print(user_jp) print(user_jp.username) print(jp.items) find_users = session.query(User).all() print(find_users)
session.add(jesse)
# Create Brendan
brendan = User(username='******', password='******')
session.add(brendan)
session.commit()
# Add a baseball
baseball = Item(name='baseball',
description='A very nice baseball indeed',
seller=jesse)
session.add(baseball)
session.commit()
# Larisa and Brendan bid
lbid = Bid(price=0.20, item=baseball, bidder=larisa)
bbid = Bid(price=0.25, item=baseball, bidder=brendan)
session.add(lbid)
session.add(bbid)
session.commit()
# Find the highest bid
highbid = session.query(Bid).filter(Bid.item == baseball).order_by(
Bid.price.desc()).first()
print "{} bought a {} ('{}') for {}".format(highbid.bidder.username,
highbid.item.name,
highbid.item.description,
highbid.price)
