$column_def = array('col1 CHAR(1)', 'col2 CHAR(2)', 'INDEX idx_col1_col2(col1, col2)');
$expected_flags = array('col1' => 'MULTIPLE_KEY PART_KEY', 'col2' => 'PART_KEY');
$create = 'CREATE TABLE test_mysqli_fetch_field_flags_table_1(id INT, ';
foreach ($column_def as $k => $v) {
$create .= sprintf('%s, ', $v);
}
$create = sprintf('%s)', substr($create, 0, -2));
if (mysqli_query($link, $create)) {
if (!($res = mysqli_query($link, 'SELECT * FROM test_mysqli_fetch_field_flags_table_1'))) {
printf("[009] Cannot run SELECT, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
// id column - skip it
$field = mysqli_fetch_field($res);
while ($field = mysqli_fetch_field($res)) {
if (!isset($expected_flags[$field->name])) {
printf("[010] Found unexpected field '%s'\n", $field->name);
continue;
}
list($missing_flags, $unexpected_flags, $flags_found) = checkFlags($field->flags, $expected_flags[$field->name], $flags);
if ($unexpected_flags) {
printf("[011] Found unexpected flags '%s' for %s, found '%s'\n", $unexpected_flags, $field->name, $flags_found);
}
if ($missing_flags) {
printf("[012] The flags '%s' have not been reported for %s, found '%s'\n", $missing_flags, $field->name, $flags_found);
}
}
}
mysqli_close($link);
print "done!";
$test_table_name = 'test_mysqli_fetch_field_flags_table_1';
require_once "clean_table.inc";
}
if (!is_dir("/dev/shm/1090data")) {
mkdir("/dev/shm/1090data");
}
if (!is_dir("/dev/shm/upload")) {
mkdir("/dev/shm/upload");
}
if (!is_dir("/dev/shm/cam1")) {
mkdir("/dev/shm/cam1");
}
while (true) {
$config = readConfiguration();
logMessage("Configuration has been read: " . json_encode($config));
check978Running();
check1090Running();
checkMotionRunning();
while (!checkConnect()) {
logMessage("No network Connection detected, connecting");
if (!connect()) {
logMessage("Connection failed");
}
}
if (!uploadADSB()) {
logMessage("ADSB Upload failed.");
}
getRelaySchedule();
checkrelaySchedule();
checkFlags();
uploadNewPics();
sleep($config->interactTimer);
}
