https://docs.google.com/presentation/d/1wDoP99_deAmmwYxmi5rNa20b0-Ufjy8vjf4H3NqqtbY/edit?usp=sharing

config.local.neon.dist

parameters:


database:
	dsn: 'mysql:host=##dbhost##;dbname=##dbname##'
	user: ##dbuser##
	password: ##dbpassword##

makefile

run: get-robo
	php robo.phar install
	php robo.phar serve

get-robo:
	if [ ! -e "robo.phar" ] ; \
	then \
		wget http://robo.li/robo.phar ; \
	fi;

RoboFile.php

<?php

/**
 * This is project's console commands configuration for Robo task runner.
 *
 * @see http://robo.li/
 */
class RoboFile extends \Robo\Tasks
{
	const CONFIG_PATH = __DIR__ . '/app/config/config.local.neon';
	const CONFIG_DIST_PATH = __DIR__ . '/app/config/config.local.neon.dist';
	const DB_DUMP_PATH = __DIR__ . '/db_structure.sql';

	public function install()
	{
		$this->taskComposerInstall()->run();
		$this->taskNpmInstall()->run();
		$this->taskBowerInstall()->run();

		if ( ! file_exists(self::CONFIG_PATH)) {
			$this->configure();
		}

		$this->setupDatabase();

		$this->say('Compiling assets');
		$this->taskExec('npm start')->run();

		$this->say('All done!');
		$this->say('If there is error below this line, ignore it, it\'s Nette bug I think...');
	}

	public function serve()
	{
		$this->taskExec('open http://127.0.0.1:8000')->run();
		$this->taskServer()
			->dir('www')
			->printed(false)
			->run();
	}

	public function configure()
	{
		$vars = [
			'##dbhost##' => $this->askDefault('DB host:', '127.0.0.1'),
			'##dbname##' => $this->askDefault('DB name:', 'sporttip'),
			'##dbuser##' => $this->askDefault('DB user:', 'root'),
			'##dbpassword##' => $this->askDefault('DB password:', ''),
		];

		$config = $this->taskWriteToFile(self::CONFIG_PATH)
			->textFromFile(self::CONFIG_DIST_PATH);

		foreach ($vars as $var => $value) {
			$config->replace($var, $value);
		}

		$config->run();
	}

	public function setupAdmin()
	{
		/** @var \App\Services\User\UserFacade $userFacade */
		$userFacade = $this->getAppContainer()->getByType(\App\Services\User\UserFacade::class);

		$this->say('Creating user');
		$user = $userFacade->createUser([
			'username' => $this->ask('username'),
			'password' => $this->ask('password', true)
		], false);
		$this->say('Setting admin permisions');
		$userFacade->setAdmin($user->id);
		$this->say('Admin account ' . $user->username . ' created!');

	}

	public function setupDatabase()
	{
		/** @var \Nette\Database\Connection $db */
		$db = $this->getAppContainer()->getByType(\Nette\Database\Connection::class);
		try {
			$tables = $db->fetchAll('SHOW TABLES');
			if (count($tables) !== 0) {
				$this->say('DB already has tables, skipping db import');
				return;
			}
		} catch (Exception $e) {
			$this->yell('Connection failed!');
			$this->configure();
		}

		$this->say('Importing database');
		$db->beginTransaction();
		$db->query(file_get_contents(self::DB_DUMP_PATH));
		$db->commit();
		$this->say('DB Imported');

		if (strtolower($this->askDefault('Do you want to create admin account? [Y/n]', 'y')) === 'y') {
			$this->setupAdmin();
		}
	}

	/**
	 * @return \Nette\DI\Container
	 */
	private function getAppContainer()
	{
		return require __DIR__ . '/app/bootstrap.php';
	}
}