if ($is_exist === true) {
$result = cubrid_execute($dh, "DROP TABLE \"" . $db["table"] . "\";");
if ($result === false) {
printf("DB Error %d (%d): %s\n", cubrid_error_code(), cubrid_error_code_facility(), cubrid_error_msg());
cubrid_rollback($dh);
cubrid_disconnect($dh);
exit(0);
}
cubrid_close_request($result);
cubrid_commit($dh);
$is_exist = false;
}
if ($is_exist === false) {
$result = cubrid_execute($dh, "CREATE TABLE \"" . $db["table"] . "\" (\n \"index\" INTEGER NOT NULL,\n \"addr1\" CHARACTER VARYING(12) NOT NULL,\n \"addr2\" CHARACTER VARYING(30) NOT NULL,\n \"addr3\" CHARACTER VARYING(64) NOT NULL,\n \"addr4\" CHARACTER VARYING(24) NOT NULL,\n \"zipcode\" CHARACTER(7) NOT NULL\n );");
if ($result === false) {
printf("DB Error %d (%d): %s\n", cubrid_error_code(), cubrid_error_code_facility(), cubrid_error_msg());
cubrid_rollback($dh);
cubrid_disconnect($dh);
exit(0);
}
cubrid_close_request($result);
cubrid_commit($dh);
$result = cubrid_execute($dh, "CREATE UNIQUE INDEX \"" . $db["table"] . "_idx\"\n ON \"" . $db["table"] . "\" (\"index\" ASC);");
if ($result === false) {
printf("Cannot create index.\n");
cubrid_rollback($dh);
} else {
cubrid_close_request($result);
cubrid_commit($dh);
}
}
protected function tearDown()
{
if ($this->error_flag) {
echo "Req:" . $this->req;
echo "Error Code: ", cubrid_error_code();
echo "Error Facility: ", cubrid_error_code_facility();
echo "Error Message: ", cubrid_error_msg();
}
if ($this->req) {
cubrid_close_request($this->req);
}
if ($this->con) {
cubrid_disconnect($this->con);
}
if (VERBOSE_OUTPUT == true) {
echo "\r\nCleanup completed.";
}
}
