Udacity Project Tournament

• Install Vagrant and VirtualBox and ssh cleint ** To download vegrant the intruction go on this link Click Here

• Clone the fullstack-nanodegree-vm repository

• Launch the Vagrant VM

• Open SQL database and table definitions in a file (tournament.sql)

• Open Python functions filling out a template of an API (tournament.py)

• Run a test suite to verify your code (tournament_test.py)

CRUD Review

• Operations with SQLAlchemy

• In this lesson, we performed all of our CRUD operations with SQLAlchemy on an SQLite database. Before we perform any operations, we must first import the necessary libraries, connect to our restaurantMenu.db, and create a session to interface with the database:

• from sqlalchemy import create_engine

• from sqlalchemy.orm import sessionmaker

• from database_setup import Base, Restaurant, MenuItem

• engine = create_engine('sqlite:///restaurantMenu.db')

• Base.metadata.bind=engine

• DBSession = sessionmaker(bind = engine)

• session = DBSession()

CREATE

We created a new Restaurant and called it Pizza Palace: myFirstRestaurant = Restaurant(name = "Pizza Palace") session.add(myFirstRestaurant) sesssion.commit() We created a cheese pizza menu item and added it to the Pizza Palace Menu: cheesepizza = menuItem(name="Cheese Pizza", description = "Made with all natural ingredients and fresh mozzarella", course="Entree", price="$8.99", restaurant=myFirstRestaurant) session.add(cheesepizza) session.commit()

READ We read out information in our database using the query method in SQLAlchemy:

• firstResult = session.query(Restaurant).first()

firstResult.name

items = session.query(MenuItem).all() for item in items: print item.name

UPDATE

In order to update and existing entry in our database, we must execute the following commands:

• Find Entry
• Reset value(s)
• Add to session
• Execute session.commit()
• We found the veggie burger that belonged to the Urban Burger restaurant by executing the following query:
• veggieBurgers = session.query(MenuItem).filter_by(name= 'Veggie Burger')
• for veggieBurger in veggieBurgers:
  • print veggieBurger.id
  • print veggieBurger.price
  • print veggieBurger.restaurant.name
  • print "\n"

Then we updated the price of the veggie burger to $2.99:

• UrbanVeggieBurger = session.query(MenuItem).filter_by(id=8).one()
• UrbanVeggieBurger.price = '$2.99'
• session.add(UrbanVeggieBurger)
• session.commit()

DELETE

To delete an item from our database we must follow the following steps:

• Find the entry

• Session.delete(Entry)

• Session.commit()

• We deleted spinach Ice Cream from our Menu Items database with the following operations:

• spinach = session.query(MenuItem).filter_by(name = 'Spinach Ice Cream').one()

• session.delete(spinach)

• session.commit()

Copyright and License

• tournament.py supplied without rights information, contributed by Udacity.

• Remaining code by Edward Bryant is offered under a Creative Commons Attribution 4.0 International License.