<?php
$username = 'root';
$password = '';

$oldDatabaseName = 'old2';

try {
	// 1. Make Connections
    $old = new PDO('mysql:host=127.0.0.1;dbname=old2', $username, $password);
    $new = new PDO('mysql:host=127.0.0.1;dbname=new2', $username, $password);
    // 2. Set Error Mode && Exception Mode
    $old->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    output('Connected to ' . $oldDatabaseName);
} catch (PDOException $e) {
    output("Connection Failed: " . $e->getMessage());
    exit;
}


// 3. Prepare SQL Query
$getAccounts = $old->prepare('SELECT * FROM accounts');
// 4. Execute SQL Query
$getAccounts->execute();
// 5. Fetch all accounts from executed SQL Query
$accounts = $getAccounts->fetchAll(PDO::FETCH_ASSOC);
// 6. Dump foreach all accounts
$roles = [];

if($accounts) {
	foreach ($accounts as $account) {
		array_push($roles, $account['role']);
	}

	$roles = array_unique($roles);

	foreach($roles as $role) {

		$getRoles = $new->prepare("SELECT name FROM roles WHERE name = :role");

		$getRoles->execute([
			':role' => 'Adminasd'
		]);

		$roles = $getRoles->fetch();

		var_dump($roles);
		exit;

		$insertRoles = $new->prepare("INSERT INTO `roles` (name) VALUES (:name)");

		$insertRoles->execute([
			':name' => $role
		]);
	}

	output(count($roles) . ' roles transfered.');

	foreach ($accounts as $account) {
    	// 7. Prepare SQL Query
    	$insertAccounts = $new->prepare("INSERT INTO `accounts` (email, password, role_id) VALUES (:email, :password, :role_id)");

    	switch($account['role']) {
    		case 'Bezoeker':
    			$roleID = 19;
    			break;
    		case 'Medewerker':
    			$roleID = 20;
    			break;
    		case 'Admin':
    			$roleID = 21;
    			break;
    	}

    	$insertAccounts->execute([
    		':email' => 1,
    		':password' => 2,
    		':role_id' => 3
    	]);
    }

    output(count($accounts) . ' accounts transfered.');

} else {
	output('No accounts found.');
	exit;
}

$getRecipes = $old->prepare("SELECT * FROM recipes");
$getRecipes->execute();

$recipes = $getIngredients->execute();

if($recipes) {

	foreach ($recipes as $recipe) {
		var_dump($recipe);
	}


} else {
	output('No recipes found.');
	exit;
}

function output($output){
	echo $output . "\n";
}