PokemORM

A laravel app to show how to use Eloquent, using pokemon as an example database

Prerequisites

• Developed on Docker
• Temporarily halt any docker containers using 127.0.0.1 ports 80 and 3306

Build - can take up to 30 mins

• Git Clone the repo
• Make a .env file: cp .env.example .env
• Install dependencies: docker run --rm -u "$(id -u):$(id -g)" -v $(pwd):/var/www/html -w /var/www/html laravelsail/php80-composer:latest composer install --ignore-platform-reqs
• Make the sail Docker File(s): php artisan sail:publish
• Start the docker containers: ./vendor/bin/sail up -d
• Open the container CLI: ./vendor/bin/sail shell
• Build the application: ./vendor/bin/phing build

Interact

• View the database with your MySQL GUI, using the credentials DB_DATABASE & DB_USERNAME in .env
• Alternatively, navigate to 127.0.0.1 in your browser
• Also, you can take advantage of Laravel Tinker to interact with the application, eg:
  • sail artisan tinker
  • $trainer = App\Trainer::create(['first_name' => 'kyam', 'second_name' => 'harris', 'home_town' => 1, 'favourite_type' => 1, 'favourite_pokemon' => 1, 'evil' => 0]); - will create a new Trainer row

Playground

Alternatively, interact with the models and data via Laravel Playground

Lesson Plan

Basics

• Models
• Selects
• Inserts
• Updates
• Deletes

Intermediate

• Relationships/joins
  • lesson5
• Scopes
  • lesson6
• Accessors & mutators
  • lesson7

Further reading

• Collections
• Sub-selects
• Unions

Documentation & Reading

Docs

Laravel

Eloquent

Eloquent Collections

Courses I liked

Test Driven Laravel

Eloquent Performance Patterns

Advanced Eloquent

Other Stuff

Slides

Article on ORM's

Todo

• Elite four?
• Nice front end forms/tables
• graphQL api
• SOAP api