#Welcome to my Code Exercise This week will be excited by writing and pushing new code in this repo... :-)

Docket Environment Install

A pretty simplified docker-compose workflow that sets up a LEMP network of containers for local Laravel development. You can view the full article that inspired this User guide : https://www.digitalocean.com/community/tutorials/how-to-set-up-laravel-nginx-and-mysql-with-docker-compose#step-2-%E2%80%94-creating-the-docker-compose-file.

App specifications:

• Docker Ver 19.03
• Laravel 6.16.0
• MySql 5.7.22
• Nginx 1.9
• Blade 2.x

Laravel installation

To get started, make sure you have Docker installed on your system, and then clone this repository. Add your entire Laravel project to the src/ folder, then open a terminal and cloned Laravel respository.

docker-compose build && docker-compose up -d

Open up your browser of choice to http://localhost:8080 and you should see your Laravel app running as intended.

Containers created and their ports are as follows:

 nginx - :8080
 mysql - :3306
 php - :9000

Initialize Docker on Local Machine

Now we're ready to build and run our containers. Type this command in to start: ~$ docker-compose build && docker-compose up -d

wait...wait...wait...and Voila!

 Creating mysql ... done
 Creating app   ... done
 Creating nginx ... done

Now our Docker services (nginx,mysql,php) are running locally, let's check the status and running port by typing ~$ docker ps

 CONTAINER ID        IMAGE                 COMMAND                  CREATED             STATUS              PORTS                    NAMES
 804962a15939        nginx:stable-alpine   "nginx -g 'daemon of…"   20 seconds ago      Up 17 seconds       0.0.0.0:8080->80/tcp     nginx
 bb4259587954        sportradar_php        "docker-php-entrypoi…"   27 seconds ago      Up 23 seconds       0.0.0.0:9000->9000/tcp   app
 fd1bf423101d        sportradar_mysql      "docker-entrypoint.s…"   30 seconds ago      Up 1 second         0.0.0.0:3306->3306/tcp   mysqldb

Clone Laravel sourcecode

 mkdir src/
 git clone repo https://..... src
 rm -rf src/.git
 rm -rf README.md 

Run Composer to install dependencies

 docker-compose exec php php composer install
 docker-compose exec php php artisan key:generate
 docker-compose exec php php artisan cache:clear

Table creation for Migration on laravel

 docker-compose exec php php artisan make:migration create_authors
 docker-compose exec php php artisan make:migration create_books

Add to the new Classes "CreateAuthors" and "CreateBooks" the mondatory columns

class CreateAuthors extends Migration
  public function up()
     {
         Schema::create('authors', function (Blueprint $table) {
             $table->bigIncrements('id');
             $table->string('name',20);
             $table->integer('age');
             $table->lineString('address');
             $table->timestamps();
         });
     } 
     
 ------------------------------------------------------------------
 
 class CreateBooks extends Migration
 {
     /**
      * Run the migrations.
      *
      * @return void
      */
     public function up()
         {
             Schema::create('books', function (Blueprint $table) {
                 $table->bigIncrements('id');
                 $table->unsignedBigInteger('author_id');
                 $table->string('name',60);
                 $table->date('release_date');
                 $table->timestamps();
             });
     
             Schema::table('books', function (Blueprint $table){
                 $table->foreign('author_id')->references('id')->on('authors');
             });
         }

Then run the final command to create the tables + columns...Voila!

 docker-compose exec php php artisan migrate

Seeding and factory

-- AuthorFactory

$factory->define(Author::class, function (Faker $faker) {
$author = [
    'name'      => $faker->name,
    'age'       => $faker->randomNumber(2),
    'address'   => $faker->streetAddress
];

return $author;

 ------------------------------------------------------------------
 
 -- BookFactory
 
 $factory->define(Book::class, function (Faker $faker) {

     $book = [
         'name'          => $faker->text(60),
         'author_id'     => $faker->numberBetween(1,10),
         'release_date'  => $faker->unique()->dateTime('now'),
     ];
 
     return $book;
 });
 

 -- Author Seed
 
 class AuthorsTableSeeder extends Seeder
 {
     /**
      * Run the database seeds.
      *
      * @return void
      */
     public function run()
     {
         factory(Author::class,10)->create();
     }
 }
 
 ---------------------------------------------
 
 -- Book Seed
 
 class BooksTableSeeder extends Seeder
 {
     /**
      * Run the database seeds.
      *
      * @return void
      */
     public function run()
     {
         factory(Book::class,30)->create();
     }
 }

When files are ready and execute the following command to mock the table with data

docker-compose exec php php artisan migrate:fresh

docker-compose exec php php artisan db:seed