PHP SelectLastRowFrom_Version Examples

Example #1

File: setup.php Project: ravikiranmara/todo-atodo-list

/**
* 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;
}

Example #2

File: test_Version_createInsertDeleteDrop.php Project: ravikiranmara/todo-atodo-list

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}");