For this lab, you will set up a few Eloquent models and write some queries. Start by creating a GitHub Gist called
lastname_firstname_lab1_eloquent.md. Write the code for each question in triple back ticks. Here is an example of what your lab submission should look like. Include a comment at the top of the code block for models to specify the location of that model.
To test out your code, use
php artisan tinker.
- Find all customers who work for “Apple Inc.”.
- Find invoice 5 and update its
BillingAddressto “123 Sesame Street”.
$theWho = Artist::find(144), create a new album for
- Create a relationship between an invoice and invoice items such that all invoice items for an invoice can be accessed through an
itemsproperty off of an invoice object.
- Create a relationship between an invoice and invoice items such that the invoice can be accessed from an invoice item object through an
NOTE: The primary key in the
invoice_items table is NOT
InvoiceItemId as you might expect. The primary key of
invoice_items is actually
InvoiceLineId. If you open up the database in SQLite from the command line, (see this page if you forgot), you will see that. This is pertinent to the last 2 questions.
Send an email to me and the TA with the link to your GitHub Gist. Please use the subject line ITP 405 Lab Submission - Laravel 3.