public function beforeDelete()
{
if ($this->getOwner()->getGalleryId()) {
$mapper = Manager::getInstance()->getMapper($this->mapper_alias);
$aContainer = $mapper->getContainer();
$categoryId = $this->getOwner()->getGalleryId();
// Удаляем все записи о фотках из базы
$oQuery = new DbUpdater(DbUpdater::TYPE_DELETE, $aContainer['TableName'], $aContainer['Object'], $this->getDbConnectionAlias());
$oCriteria = new CriteriaElement('category_id', Criteria::EQUAL, $categoryId);
$oQuery->addCriteria($mapper->parseUpdateCriteria($oCriteria->renderWhere()));
$oQuery->delete();
$this->getOwner()->getGallery()->delete();
}
return true;
}
<?php
// Be hacky/lazy and just use the same DRUPAL_ROOT namespace
define('DRUPAL_ROOT', dirname(realpath(__FILE__)));
// Load the general includes file.
require_once DRUPAL_ROOT . '/includes/gen.inc';
// Load up ALL the includes.
load_includes();
// Fire up the bootstrap-imitating conf_init()
conf_init();
// install_schemas();
$file = '/home/sdboyer/Documents/Academic/Padgett.PLSC57500/final/devarchive/2005-January.txt';
date_default_timezone_set('UTC');
$archive = new MailmanArchiveParser($file);
// $dat = introspect_spl_class($archive);
foreach ($archive as $item) {
$db = new DbUpdater($item);
$db->prepData();
}
$i = 'break on me';
* @package wpos
* @copyright Copyright (c) 2014 WallaceIT. (https://wallaceit.com.au)
* @link https://wallacepos.com
* @author Michael B Wallace <*****@*****.**>
* @since File available since 14/12/13 07:46 PM
*/
die("Please manually enable the installer before proceeding");
$_SERVER['APP_ROOT'] = "/";
if (!isset($_SERVER['DOCUMENT_ROOT'])) {
$_SERVER['DOCUMENT_ROOT'] = "/app";
// this is what dokku uses as docroot, we can catch it because it ain't defined (not using mod_php);
}
if (php_sapi_name() == "cli") {
$_SERVER['DOCUMENT_ROOT'] = "/app";
// explicitly define docroot
parse_str(implode('&', array_slice($argv, 1)), $_REQUEST);
}
require $_SERVER['DOCUMENT_ROOT'] . $_SERVER['APP_ROOT'] . 'library/wpos/AutoLoader.php';
//Autoload all the classes.
$dbUpdater = new DbUpdater();
// update
if (isset($_REQUEST['upgrade']) && isset($_REQUEST['version'])) {
$result = $dbUpdater->upgrade($_REQUEST['version']);
echo $result;
}
// install
if (isset($_REQUEST['install'])) {
$result = $dbUpdater->install();
echo $result;
}
die("<br/>Please remove the install/index.php file after installing, leaving it after installation is dangerous");
protected function update($table, $data, $pk)
{
$oQuery = new DbUpdater(DbUpdater::TYPE_UPDATE, $table, 't', $this->dbConnection);
$oQuery->setElement($data);
$oCriteria = new CriteriaElement('id', Criteria::EQUAL, $pk);
$oQuery->addCriteria($oCriteria->renderWhere());
$oQuery->update();
}
protected function updateTableData($table, $data)
{
if (isset($data['Insert'])) {
foreach ($data['Insert'] as $insert) {
$oQuery = new DbUpdater(DbUpdater::TYPE_INSERT, $table, 't', $this->_dbConnection);
$oQuery->setElement($insert);
$oQuery->insert();
}
}
if (isset($data['Update'])) {
foreach ($data['Update'] as $insert) {
$oQuery = new DbUpdater(DbUpdater::TYPE_UPDATE, $table, 't', $this->_dbConnection);
$oQuery->setElement($insert);
$oCriteria = new CriteriaElement('id', Criteria::EQUAL, $insert['id']);
$oQuery->addCriteria($oCriteria->renderWhere());
$oQuery->update();
}
}
}
function dbupdate()
{
startup_gettext();
if (!SINGLE_USER_MODE && $_SESSION["access_level"] < 10) {
$_SESSION["login_error_msg"] = __("Your access level is insufficient to run this script.");
render_login_form();
exit;
}
?>
<html>
<head>
<title>Database Updater</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<link rel="stylesheet" type="text/css" href="css/utility.css"/>
</head>
<style type="text/css">
span.ok { color : #009000; font-weight : bold; }
span.err { color : #ff0000; font-weight : bold; }
</style>
<body>
<script type='text/javascript'>
function confirmOP() {
return confirm("Update the database?");
}
</script>
<div class="floatingLogo"><img src="images/logo_small.png"></div>
<h1><?php
echo __("Database Updater");
?>
</h1>
<div class="content">
<?php
@($op = $_REQUEST["subop"]);
$updater = new DbUpdater(Db::get(), DB_TYPE, SCHEMA_VERSION);
if ($op == "performupdate") {
if ($updater->isUpdateRequired()) {
print "<h2>Performing updates</h2>";
print "<h3>Updating to schema version " . SCHEMA_VERSION . "</h3>";
print "<ul>";
for ($i = $updater->getSchemaVersion() + 1; $i <= SCHEMA_VERSION; $i++) {
print "<li>Performing update up to version {$i}...";
$result = $updater->performUpdateTo($i);
if (!$result) {
print "<span class='err'>FAILED!</span></li></ul>";
print_warning("One of the updates failed. Either retry the process or perform updates manually.");
print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t\t\t</form>";
break;
} else {
print "<span class='ok'>OK!</span></li>";
}
}
print "</ul>";
print_notice("Your Tiny Tiny RSS database is now updated to the latest version.");
print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t</form>";
} else {
print "<h2>Your database is up to date.</h2>";
print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t</form>";
}
} else {
if ($updater->isUpdateRequired()) {
print "<h2>Database update required</h2>";
print "<h3>";
printf("Your Tiny Tiny RSS database needs update to the latest version: %d to %d.", $updater->getSchemaVersion(), SCHEMA_VERSION);
print "</h3>";
print_warning("Please backup your database before proceeding.");
print "<form method='POST'>\n\t\t\t\t\t\t\t<input type='hidden' name='subop' value='performupdate'>\n\t\t\t\t\t\t\t<input type='submit' onclick='return confirmOP()' value='" . __("Perform updates") . "'>\n\t\t\t\t\t\t</form>";
} else {
print_notice("Tiny Tiny RSS database is up to date.");
print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t</form>";
}
}
?>
</div>
</body>
</html>
<?php
}
$feed_id = (int) $line["feed_id"];
}
$filter["enabled"] = $line["enabled"] ? "on" : "off";
$filter["rule"] = array(json_encode(array("reg_exp" => $line["reg_exp"], "feed_id" => $feed_id, "filter_type" => $line["filter_type"])));
$filter["action"] = array(json_encode(array("action_id" => $line["action_id"], "action_param_label" => $line["action_param"], "action_param" => $line["action_param"])));
// Oh god it's full of hacks
$_REQUEST = $filter;
$_SESSION["uid"] = $owner_uid;
$filters = new Pref_Filters($_REQUEST);
$filters->add();
}
}
}
if (isset($options["update-schema"])) {
_debug("checking for updates (" . DB_TYPE . ")...");
$updater = new DbUpdater(Db::get(), DB_TYPE, SCHEMA_VERSION);
if ($updater->isUpdateRequired()) {
_debug("schema update required, version " . $updater->getSchemaVersion() . " to " . SCHEMA_VERSION);
_debug("WARNING: please backup your database before continuing.");
_debug("Type 'yes' to continue.");
if (read_stdin() != 'yes') {
exit;
}
for ($i = $updater->getSchemaVersion() + 1; $i <= SCHEMA_VERSION; $i++) {
_debug("performing update up to version {$i}...");
$result = $updater->performUpdateTo($i);
_debug($result ? "OK!" : "FAILED!");
if (!$result) {
return;
}
}
function updateDb($dbConnectionInfo)
{
$toReturn = false;
$updater = new DbUpdater($dbConnectionInfo);
$result = $updater->updateDb();
if (!$result['updated']) {
echo $result['message'];
} else {
echo "Compatible database version found.";
$toReturn = true;
}
return $toReturn;
}
protected function saveForRelationData($oObject, $before = false)
{
$saveForRelation = $before ? $oObject->aForSaveRelationsDataBefore : $oObject->aForSaveRelationsData;
$objectId = $before ? 0 : (int) $oObject->getId();
if (!empty($saveForRelation)) {
$relations = $this->relations();
foreach ($saveForRelation as $rel => $val) {
$relation = $relations[$rel];
foreach ($val as $action => $data) {
$oRelMapper = Manager::getInstance()->getMapper($relation['ToMapperAlias']);
$aRelContainer = $oRelMapper->getContainer();
$sRelClassName = $aRelContainer['Object'];
switch ($action) {
case 'Delete':
// Удаляем все что есть
$oQuery = new DbUpdater(DbUpdater::TYPE_DELETE, $relation['TableName'], $sRelClassName, $this->getDbConnectionAlias());
$oCriteria = new CriteriaElement($relation['Field2'], Criteria::EQUAL, $objectId);
$oQuery->addCriteria($this->parseUpdateCriteria($oCriteria->renderWhere()));
$oQuery->delete();
break;
case 'Add':
// сохраняем в базу
if (is_array($data)) {
foreach ($data as $data_val) {
$oQuery = new DbUpdater(DbUpdater::TYPE_INSERT, $relation['TableName'], $sRelClassName, $this->getDbConnectionAlias());
$oQuery->setElement(array($relation['Field'] => $data_val, $relation['Field2'] => $objectId));
$oQuery->insert();
}
}
break;
// Has Many
// Has Many
case 'Set':
if (is_array($data)) {
$result = new SimpleCollection();
foreach ($data as $itm) {
if (!empty($itm['Id'])) {
$obj = $oRelMapper->findById($itm['Id']);
} else {
$obj = $oRelMapper->create();
}
unset($itm['Id']);
$obj->import($itm);
$obj->set($relation['Field'], $objectId);
$obj->save();
$result->add($obj);
}
}
break;
// Belongs To
// Belongs To
case 'SetOne':
if (is_array($data)) {
if (!empty($data['Id'])) {
$obj = $oRelMapper->findById($data['Id']);
} else {
$obj = $oRelMapper->create($data);
}
unset($data['Id']);
$obj->import($data);
$id = $obj->save();
$oObject->set($relation['Field'], $id);
$oObject->set($rel, $obj);
} else {
if (is_object($data)) {
if (!$data->getId()) {
$data->save();
}
$oObject->set($rel, $data);
}
}
break;
}
}
}
if ($before) {
$oObject->aForSaveRelationsDataBefore = array();
} else {
$oObject->aForSaveRelationsData = array();
}
return true;
}
return false;
}
// installer scripts
// update
if (isset($_REQUEST['upgrade']) && isset($_REQUEST['version'])) {
$dbUpdater = new DbUpdater();
$result = $dbUpdater->upgrade($_REQUEST['version']);
// register analytics
addAnalytics("upgrade");
echo $result;
exit;
}
// install
if (isset($_REQUEST['install'])) {
if (isset($_SESSION['setupvars'])) {
$_REQUEST['setupvars'] = $_SESSION['setupvars'];
}
$dbUpdater = new DbUpdater();
$result = $dbUpdater->install();
// register analytics
addAnalytics("install");
echo $result;
exit;
}
// gui installer
if (!isset($_SESSION['install_screen'])) {
$_SESSION['install_screen'] = 1;
} else {
if (isset($_REQUEST['screen']) && $_REQUEST['screen'] != "") {
$_SESSION['install_screen'] = $_REQUEST['screen'];
}
}
if (isset($_REQUEST['checkdb'])) {
private function processDbUpdates()
{
if (isset($_GET['db']) && $_GET['db'] == 'update') {
include_once LIB_ROOT . '/db_updater.class.php';
$db = new DbUpdater();
$db->setDbUpdatesFile(DOC_ROOT . '/db_updates.php');
$db->update();
}
}
