$password = "******";
$status = true;
// get handle
$dbhandle = new mysqli($dbhostname, $username, $password, $dbname);
if (false == $dbhandle) {
$status = false;
$logger->LogError("Unable to connect to database : {$dbhandle->error}");
}
// Create table
if (true == $status) {
$status = CreateTable_Version($dbhandle);
$logger->LogInfo("Create table status : {$status}");
}
// insert into table
if (true == $status) {
$status = InsertInto_Version($dbhandle, $VersionTable_V0MajorVersion, $VersionTable_V0MinorVersion, $VersionTable_dbStateGood, $id);
$logger->LogInfo("Insert into table status : {$status}");
}
// select and display record
if (true == $status) {
$status = SelectByIdFrom_Version($dbhandle, $id, $MajorVersion, $MinorVersion, $dbState);
$logger->LogInfo("Select into table status : {$status}");
}
// display record
if (true == $status) {
$logger->LogInfo("Major - {$MajorVersion}, Minor - {$MinorVersion}, dbState - {$dbState}");
}
// select and display record
if (true == $status) {
$status = SelectLastRowFrom_Version($dbhandle, $id, $MajorVersion, $MinorVersion, $dbState);
$logger->LogInfo("Select into table status : {$status}");
$logger->LogInfo("Main - Open connection to db");
$dbhandle = new mysqli($dbhostname, $username, $password, $dbname);
if ($dbhandle->connect_error == true) {
$logger->LogError("Unable to open connection to {$dbname} : {$dbhandle->error}");
$status = false;
}
if (true == $status) {
$logger->LogInfo("Checking if this is new deployment");
if (IsExisting_Version($dbhandle) == false) {
$logger->LogInfo("its a new deployment. Create table");
$status = CreateTable_Version($dbhandle);
if ($status == false) {
$logger->LogInfo("Unable to create version table");
} else {
$logger->LogInfo("Insert row into table");
$status = InsertInto_Version($dbhandle, $id, $CurrentMajorVersion, $CurrentMinorVersion, $dbStateGood);
if (false == $status) {
$logger->LogInfo("Unable to create row with version zero");
}
}
}
}
if (true == $status) {
$logger->LogInfo("checking the version, and if it is upgradable");
$status = IsUpgradable($dbhandle);
if (false == $status) {
$logger->LogError("Unable to upgrade the database from current version");
}
}
if (true == $status) {
$logger->LogInfo("Moving database to Upgrading state");
