/** * UpdateDatabaseState * Add code to perform actual database updgrad operation * * @param $dbhandle handle to database * @return $status true if operation was successful */ function UpdateDatabaseState($dbhandle, $state) { $logger = LoggerSingleton::GetInstance(); $logger->LogInfo("UpdateDatabaseState - Enter ({$state})"); $logger->LogInfo("UpdateDatabaseState - Get last row of version table"); $status = SelectLastRowFrom_Version($dbhandle, $id, $MajorVersion, $MinorVersion, $dbState); if (false == $status) { $logger->LogError("UpdateDatabaseState - Unable to get last row"); } if (true == $status) { $logger->LogInfo("UpdateDatabaseState - Update last row with the db state"); $status = UpdateInto_Version($dbhandle, $id, $MajorVersion, $MinorVersion, $state); if (false == $status) { $logger->LogError("UpdateDatabaseState - Unable to change to new state {$state}"); } } $logger->LogInfo("UpdateDatabaseState status - {$status}"); return $status; }
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}"); } // display record if (true == $status) { $logger->LogInfo("Major - {$MajorVersion}, Minor - {$MinorVersion}, dbState - {$dbState}"); } // delete record if (true == $status) { $status = DeleteFrom_Version($dbhandle, $id); $logger->LogInfo("Delete into table status : {$status}"); } // Drop table if ($status == true) { $status = DropTable_Version($dbhandle); $logger->LogInfo("Drop table status : {$status}");