exportTestData.php

<?php

use GCCISWebProjects\Utilities\DatabaseTable\PDOMysqlDriver;
use GCCISWebProjects\Utilities\DatabaseTable\Condition\AlwaysTrueCondition;
require_once __DIR__ . "/../../vendor/autoload.php";
$db = new PDOMysqlDriver("/tmp/mysql.sock");
$db->query("USE gwp;");
foreach(array_map(fn(array $x):string => $x[0], iterator_to_array($db->query("SHOW TABLES"))) as $table) {
    $data = (iterator_to_array($db->query("SELECT * FROM `$table`")));
    // Take out integer keys
    $data = array_map(fn(array $row):array => array_filter($row, "is_string", ARRAY_FILTER_USE_KEY), $data);
    if($data) {
        $file = fopen(__DIR__ . "/../../_starterData/$table.csv", "w");
        fputcsv($file, array_keys($data[0]));
        foreach($data as $row) {
            fputcsv($file, array_map(fn($s):string => is_null($s) ? "\\N" : strval($s), array_values($row)));
        }
    }
}