/**
* @param null $db
*/
public function __construct($db = null)
{
if ($db == null) {
global $wgExternalSharedDB;
$app = F::app();
$db = wfgetDB(DB_MASTER, array(), $wgExternalSharedDB);
}
$this->databaseConnection = $db;
}
public static function removeAllNamespacePages($idNS, $nameNS)
{
$dbw = wfgetDB(DB_MASTER);
$res = $dbw->select('page', array('page_id', 'page_title', 'page_len', 'page_latest'), array('page_namespace' => $idNS));
$sToken = RequestContext::getMain()->getUser()->getEditToken();
foreach ($res as $row) {
$oParams = new DerivativeRequest(RequestContext::getMain()->getRequest(), array('action' => 'delete', 'pageid' => $row->page_id, 'reason' => wfMessage('bs-namespacemanager-deletens-deletepages', $nameNS)->text(), 'token' => $sToken), true);
$api = new ApiMain($oParams, true);
$api->execute();
}
return true;
}
private function getDB()
{
return wfgetDB(DB_SLAVE, array(), $this->app->wg->DBname);
}
/**
* @covers Revision::newFromArchiveRow
*/
public function testNewFromArchiveRow()
{
$page = $this->createPage('RevisionStorageTest_testNewFromArchiveRow', 'Lorem Ipsum', CONTENT_MODEL_WIKITEXT);
$orig = $page->getRevision();
$page->doDeleteArticle('test Revision::newFromArchiveRow');
$dbr = wfgetDB(DB_SLAVE);
$res = $dbr->select('archive', '*', array('ar_rev_id' => $orig->getId()));
$this->assertTrue(is_object($res), 'query failed');
$row = $res->fetchObject();
$res->free();
$rev = Revision::newFromArchiveRow($row);
$this->assertRevEquals($orig, $rev);
}
<?php
// example: SERVER_ID=5915 php maintenance/wikia/GoogleWebmasterToolsSync/initial_sync_account.php --conf /usr/wikia/docroot/wiki.factory/LocalSettings.php
global $IP;
require_once __DIR__ . "/common.php";
GWTLogHelper::notice(__FILE__ . " script starts.");
try {
global $wgExternalSharedDB;
$app = F::app();
$db = wfgetDB(DB_MASTER, array(), $wgExternalSharedDB);
function generateUserId(DatabaseBase $db)
{
$res = $db->select("webmaster_user_accounts", array('max(user_id) as maxid'), array(), __METHOD__);
if ($res->fetchObject()->maxid == null) {
return 1;
}
return $res->fetchObject()->maxid + 1;
}
function tryInsertUser(DatabaseBase $db, GWTUser $u)
{
$res = $db->select("webmaster_user_accounts", array('user_id'), array("user_name" => $u->getEmail()), __METHOD__);
$obj = null;
if ($obj = $res->fetchObject()) {
return $obj->user_id;
}
//echo "insert: " . $u->getEmail() . "\n";
$user_id = generateUserId($db);
if ($db->insert("webmaster_user_accounts", array("user_id" => $user_id, "user_name" => $u->getEmail(), "user_password" => $u->getPassword()))) {
throw new Exception("can't insert user id = " . $user_id . " name = " . $u->getEmail());
}
return $user_id;
/**
* Removes the object from the database.
*
* @since 0.1
*
* @return boolean Success indicator
*/
public function removeFromDB()
{
$dbr = wfgetDB(DB_SLAVE);
$submissionsForSurvey = $dbr->select('survey_submissions', array('submission_id'), array('submission_survey_id' => $this->getId()));
$dbw = wfGetDB(DB_MASTER);
$dbw->begin();
$sucecss = parent::removeFromDB();
$sucecss = $dbw->delete('survey_questions', array('question_survey_id' => $this->getId())) && $sucecss;
$sucecss = $dbw->delete('survey_submissions', array('submission_survey_id' => $this->getId())) && $sucecss;
foreach ($submissionsForSurvey as $nr => $submission) {
$sucecss = $dbw->delete('survey_answers', array('answer_submission_id' => $submission->id)) && $sucecss;
if ($nr % 500 == 0) {
$dbw->commit();
$dbw->begin();
}
}
$dbw->commit();
return $sucecss;
}
