laravel_demo/app/Console/Commands/LoadSampleData.php

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use App\Models\Comment;
use App\Models\Article;
use App\Models\Author;
use App\Models\Book;

class LoadSampleData extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'app:load-sample-data';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Command description';

    /**
     * Execute the console command.
     */
    public function handle()
    {
		$article = new Article;
		$article->title = "Использование netcat-openbsd в качестве HTTP сервера";
		$article->description = "Если нет нормального веб-сервера...";
		$article->content = "<p>При необходимости передать файл по HTTP, но отсутствии какого-либо веб-сервера, можно использовать netcat:</p><pre><code>cat <(echo -en \"HTTP/1.0 200 OK\\r\\n\\r\\n\") arch/x86/boot/bzImage | nc -N -l -p 8080</code></pre>";
		$article->publish_at = now();
		$article->status = Article::STATUS_PUBLISHED;
		$article->save();

        $article->comments()->create([
			"name" => "somebody",
			"email" => "a@mail.ru",
			"content" => "Ну и дичь",
        ]);

        $article->comments()->create([
			"name" => "bodysome",
			"email" => "b@mail.ru",
			"content" => "https://www.youtube.com/watch?v=dQw4w9WgXcQ",
        ]);

		$article = new Article;
		$article->title = "Построение спектрограмм при помощи ffmpeg";
		$article->description = "Спектрограммы с микрофона в реальном времени";
		$article->content = "<p>Под Linux, если есть pipewire (Или вообще везде так можно?), можно сделать так:<p><pre><code>ffplay -f lavfi -i 'amovie=mpv:f=pulse,aderivative,volume=10,showspectrum=color=viridis:s=1024x384' -an</code></pre><p>Просмотреть доступные устройства можно так:</p><pre><code>$ pw-link -o\nMidi-Bridge:Midi Through:(capture_0) Midi Through Port-0\nalsa_output.pci-0000_00_1f.3.analog-stereo:monitor_FL\nalsa_output.pci-0000_00_1f.3.analog-stereo:monitor_FR\nalsa_input.pci-0000_00_1f.3.analog-stereo:capture_FL\nalsa_input.pci-0000_00_1f.3.analog-stereo:capture_FR\nmpv:output_FL\nmpv:output_FR\n</code></pre>";
		$article->publish_at = now();
		$article->status = Article::STATUS_PUBLISHED;
		$article->save();

		$article = new Article;
		$article->title = "Test article";
		$article->description = "Short description";
		$article->content = "Test article contents";
		$article->publish_at = now();
		$article->save();

        $author = new Author;
        $author->name = "Howard Johnson";
        $author->save();

        $book = new Book;
        $book->name = "High-Speed Digital Design: A Handbook of Black Magic";
        $book->isbn = "9780133957242";
        $book->year = 1993;
        $book->pagecount = 446;
        $book->author_id = $author->id;
        $book->annotation = "Focuses on a combination of digital and analog circuit theory. Helps engineers who work with digital systems, shorten their product development cycles and fix their latest high-speed design problems. DLC: Digital electronics.";
        $book->save();

        $author = new Author;
        $author->name = "Харкевич А.А.";
        $author->save();

        $book = new Book;
        $book->name = "Основы радиотехники";
        $book->isbn = "978-5-9221-0790-7";
        $book->year = 2007;
        $book->pagecount = 512;
        $book->author_id = $author->id;
        $book->annotation = "В курс теоретических основ радиотехники вошли: общие вопросы передачи и приема сигналов, исследование прохождения электрических сигналов через внутренние цепи аппаратуры и распространения сигналов по линиям и волноводам, исследование основных радиотехнических процессов. Математический аппарат курса включает решение линейных дифференциальных уравнений с постоянными и переменными коэффициентами и решение нелинейных дифференциальных уравнений. Настоящее издание полностью воспроизводит текст издания 1962 года, которое было допущено Министерством высшего и среднего специального образования СССР в качестве учебного пособия для высших учебных заведений СССР.";
        $book->save();

        $author = new Author;
        $author->name = "Allen Downey";
        $author->save();

        $book = new Book;
        $book->name = "Think DSP";
        $book->isbn = "978-1491938454";
        $book->year = 2016;
        $book->pagecount = 153;
        $book->author_id = $author->id;
        $book->annotation = "If you understand basic mathematics and know how to program with Python, you're ready to dive into signal processing. While most resources start with theory to teach this complex subject, this practical book introduces techniques by showing you how they're applied in the real world. In the first chapter alone, you'll be able to decompose a sound into its harmonics, modify the harmonics, and generate new sounds.";
        $book->save();

        $book->comments()->create([
			"name" => "somebody",
			"email" => "a@mail.ru",
			"content" => "Отличная книга!"
        ]);

        $book = new Book;
        $book->name = "Think Stats";
        $book->isbn = "978-1491907337";
        $book->year = 2014;
        $book->pagecount = 264;
        $book->author_id = $author->id;
        $book->annotation = "If you know how to program, you have the skills to turn data into knowledge, using tools of probability and statistics. This concise introduction shows you how to perform statistical analysis computationally, rather than mathematically, with programs written in Python.";
        $book->save();

        $author = new Author;
        $author->name = "Robert Lucky";
        $author->save();

        $book = new Book;
        $book->name = "Silicon Dreams: Information, Man, and Machine";
        $book->isbn = "9780312029609";
        $book->year = 1989;
        $book->pagecount = 440;
        $book->author_id = $author->id;
        $book->annotation = "Silicon Dreams is a highly informed discussion of the new information age, from the Executive Director of Research at Bell Labs. Robert Lucky addresses such questions as what information is, how it is generated, captured, stored, and communicated, and goes on to explain information theory, cryptology, speech synthesis and recognition, and much more. Charts, diagrams, photographs.";
        $book->save();
    }
}