<?php
//THIS FILE MUST NOT BE AVAILABLE IN PRODUCTION SYSTEMS!!!!
require __DIR__ . '/../vendor/autoload.php';
$database = new Slim\PDO\Database('mysql:host=localhost;dbname=projectist;charset=utf8', 'root', '');
$project_names = array('Inotice', 'Dongstrip', 'Overtaxon', 'Stattex', 'Stanhow', 'Sansailcity', 'Aceredcode', 'viaware', 'Sonla', 'Codefax', 'Goodfix', 'Transfase', 'unazoom', 'Canenix', 'X-zim', 'Bamdrill', 'Zoo-code', 'Medlane', 'Dingmedfax', 'zathcane', 'K-zone', 'Dan-ex', 'Unifinfan', 'Suntrans', 'Y-ex', 'zimla', 'Over-city', 'Doubleware', 'Plusing', 'templine', 'Geolex', 'Yearhex', 'Hatgofase', 'Stat-con', 'Media-tex', 'Redtom', 'J-tancore');
$sql = "TRUNCATE TABLE projects";
$database->exec($sql);
echo "Truncating the projects Table<br>";
foreach ($project_names as $project_name) {
//insert some projects
$project = new \App\Models\Project($database);
$project->CreateNew('code_test2', $project_name, 'owner_test', 'portfolio_test', 'rag_status_test');
$project->Save();
$project = null;
echo "saved Project {$project_name} <br>";
}
