#Welcome to my Code Exercise This week will be excited by writing and pushing new code in this repo... :-)
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
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:https://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
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
mkdir src/
git clone repo https://..... src
rm -rf src/.git
rm -rf README.md
docker-compose exec php php composer install
docker-compose exec php php artisan key:generate
docker-compose exec php php artisan cache:clear
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
-- 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