Exemplo n.º 1
0
def put():
    finished = False
    while not finished:
        newuser = User()
        print "Please enter the name you would like to use for your user name: "
        newuser.username = raw_input()
        print "Please enter the password you would like to associate with this account:"
        newuser.password = raw_input()
        session.add(newuser)
        session.commit()
        print "Would you like to create additional accounts? Y/N: "
        answer = raw_input()
        if answer == "n":
            main()
Exemplo n.º 2
0
#!/usr/bin/python

from tbay import session, Item, User, Bid

chris = User() 
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)
Exemplo n.º 3
0
from tbay import User, Item, Bid, session
from datetime import datetime

john = User()
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()
Exemplo n.º 4
0
from tbay import User, Item, Bid, session

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
Exemplo n.º 5
0
from tbay import Item, User, Bid, session

#add three users to the database
"""
jp = User(username="******", password="******")
jenna = User(username="******", password="******")
jaimie = User(username="******", password="******")
"""

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'
Exemplo n.º 6
0
from tbay import User, Item, Bid, session

beyonce = User()
beyonce.username = "******"
beyonce.password = "******"

sylvester = User()
sylvester.username = "******"
sylvester.password = "******"

jayz = User()
jane.username = "******"
jane.password = "******"

Base.metadata.create_all(engine)

session.add_all([beyonce, sylvester, jayz])
session.commit()

baseball = Item()
headphones.name = "baseball"
headphones.description = "Who wants to play ball? Get your baseball here!"
session.add(baseball)
session.commit()
Exemplo n.º 7
0
Arquivo: main.py Projeto: eunnah/tbay 
from tbay import User, Item, Bid, session

beyonce = User()
beyonce.username = "******"
beyonce.password = "******"
beyonce.id = "78"
session.add(beyonce)
session.commit()

jayz = User()
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()
Exemplo n.º 8
0
from tbay import Item, User, Bid, session
from sqlalchemy import desc

#add three users to the database
"""
jp = User(username="******", password="******")
jenna = User(username="******", password="******")
jaimie = User(username="******", password="******")
"""

jp = User()
jp.username = "******"
jp.password = "******"
session.add(jp)
session.commit()

jenna = User()
jenna.username = "******"
jenna.password = "******"
session.add(jenna)
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)
Exemplo n.º 9
0
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)