PHP Database::setVersion Examples

Example #1

File: update_030001.php Project: thejandroman/Lychee

# Rename sorting to sortingPhotos
$query = Database::prepare($database, "UPDATE ? SET `key` = 'sortingPhotos' WHERE `key` = 'sorting' LIMIT 1", array(LYCHEE_TABLE_SETTINGS));
$result = $database->query($query);
if (!$result) {
    Log::error($database, 'update_030001', __LINE__, 'Could not update database (' . $database->error . ')');
    return false;
}
# Add identifier to settings
$query = Database::prepare($database, "SELECT `key` FROM `?` WHERE `key` = 'identifier' LIMIT 1", array(LYCHEE_TABLE_SETTINGS));
$result = $database->query($query);
if ($result->num_rows === 0) {
    $identifier = md5(microtime(true));
    $query = Database::prepare($database, "INSERT INTO `?` (`key`, `value`) VALUES ('identifier', '?')", array(LYCHEE_TABLE_SETTINGS, $identifier));
    $result = $database->query($query);
    if (!$result) {
        Log::error($database, 'update_030001', __LINE__, 'Could not update database (' . $database->error . ')');
        return false;
    }
} else {
    $identifier = md5(microtime(true));
    $query = Database::prepare($database, "UPDATE `?` SET `value` = '?' WHERE `key` = 'identifier' LIMIT 1", array(LYCHEE_TABLE_SETTINGS, $identifier));
    $result = $database->query($query);
    if (!$result) {
        Log::error($database, 'update_030001', __LINE__, 'Could not reset public albums (' . $database->error . ')');
        return false;
    }
}
# Set version
if (Database::setVersion($database, '030001') === false) {
    return false;
}

Example #2

File: update_020100_pgsql.php Project: rssc/Lychee

if (!defined('LYCHEE')) {
    exit('Error: Direct access is not allowed!');
}
$result = $database->query("SELECT tags FROM " . LYCHEE_TABLE_PHOTOS . " LIMIT 1");
if ($result === FALSE) {
    $result = $database->query("ALTER TABLE " . LYCHEE_TABLE_PHOTOS . " ADD tags CHARACTER VARYING(1000) DEFAULT ''");
    if ($result === FALSE) {
        Log::error($database, 'update_020100', __LINE__, 'Could not update database (' . print_r($database->errorInfo(), TRUE) . ')');
        return false;
    }
}
$result = $database->query("SELECT key FROM " . LYCHEE_TABLE_SETTINGS . " WHERE key = 'dropboxKey' LIMIT 1");
if ($result->rowCount() === 0) {
    $result = $database->query($database, "INSERT INTO " . LYCHEE_TABLE_SETTINGS . " (key, value) VALUES ('dropboxKey', '')");
    if ($result === FALSE) {
        Log::error($database, 'update_020100', __LINE__, 'Could not update database (' . print_r($database->errorInfo(), TRUE) . ')');
        return false;
    }
}
$result = $database->query("SELECT key FROM " . LYCHEE_TABLE_SETTINGS . " WHERE key = 'version' LIMIT 1");
if ($result->rowCount() === 0) {
    $result = $database->query("INSERT INTO " . LYCHEE_TABLE_SETTINGS . " (key, value) VALUES ('version', '020100')");
    if ($result === FALSE) {
        Log::error($database, 'update_020100', __LINE__, 'Could not update database (' . print_r($database->errorInfo(), TRUE) . ')');
        return false;
    }
} else {
    if (Database::setVersion($database, '020100') === false) {
        return false;
    }
}

Example #3

File: update_session.php Project: thejandroman/Lychee

#Add the sessions table
$query = Database::prepare($database, "CREATE TABLE `?` (`value` varchar(40) DEFAULT NULL,`expires` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;", array(LYCHEE_TABLE_SESSIONS));
$result = $database->query($query);
if (!$result) {
    Log::error($database, 'update_' . $version, __LINE__, 'Could not add the session table (' . $database->error . ')');
    return false;
}
# Add sessionLength to settings
$query = Database::prepare($database, "SELECT `key` FROM `?` WHERE `key` = 'sessionLength' LIMIT 1", array(LYCHEE_TABLE_SETTINGS));
$result = $database->query($query);
if ($result->num_rows === 0) {
    $sessionLength = 1440;
    $query = Database::prepare($database, "INSERT INTO `?` (`key`, `value`) VALUES ('sessionLength', '?')", array(LYCHEE_TABLE_SETTINGS, $sessionLength));
    $result = $database->query($query);
    if (!$result) {
        Log::error($database, 'update_' . $version, __LINE__, 'Could not update the database (' . $database->error . ')');
        return false;
    }
} else {
    $sessionLength = 1440;
    $query = Database::prepare($database, "UPDATE `?` SET `value` = '?' WHERE `key` = 'sessionLength' LIMIT 1", array(LYCHEE_TABLE_SETTINGS, $sessionLength));
    $result = $database->query($query);
    if (!$result) {
        Log::error($database, 'update_' . $version, __LINE__, 'Could not add the sessionLength to settings (' . $database->error . ')');
        return false;
    }
}
# Set version
if (Database::setVersion($database, $version) === false) {
    return false;
}