sort($teams); foreach ($allteams as $team) { if (!in_array($team, $current)) { printf("missing %s\n", $team); $comp->insertTeam($con, $team); } } } function insertMatches($con, $comp, $matches) { foreach ($matches as $match) { $red = $match->RedAlliance; $blue = $match->BlueAlliance; $match->insert($con); $red->insert($con); $blue->insert($con); printf("%s - {$s}: %s, %s\n", $match->Number, $match->ID, $red->ID, $blue->ID); } } //---------------------------------------------------------------------------// $name = "Autodesk Portland Regional 2013"; $con = DB::connect(); $comp = competition::selectByName($con, $name); if (!$comp) { die("Competition \"{$name}\" not found."); } printf("Competition {$name} ID=%s\n", $comp->ID); $matches = readMatches($comp, "portland-2013.tsv"); // reportMatches(); addTeams($con, $comp, $matches); insertMatches($con, $comp, $matches);
$comp->insertTeam($con, $team->Number); } else { printf("Team %s to already added.\n", $team->Number); } } } function insertMatches($con, $comp, $matches) { foreach ($matches as $match) { $red = $match->RedAlliance; $blue = $match->BlueAlliance; $match->insert($con); $red->insert($con); $blue->insert($con); printf("%s - {$s}: %s, %s\n", $match->Number, $match->ID, $red->ID, $blue->ID); } } //---------------------------------------------------------------------------// $compname = $argv[1]; $teampath = $argv[2]; printf("Importing teams for competition %s from %s.\n", $compname, $teampath); $con = DB::connect(); $comp = competition::selectByName($con, $compname); if (!$comp) { die("Competition \"{$name}\" not found."); } printf("Competition {$name} ID=%s\n", $comp->ID); $teams = readTeams($comp, $teampath); // reportTeams($teams); addTeams($con, $comp, $teams);