3 * Version of FileJournal that logs to a DB table.
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
21 * @ingroup FileJournal
22 * @author Aaron Schulz
26 * Version of FileJournal that logs to a DB table
29 class DBFileJournal
extends FileJournal
{
30 protected $wiki = false; // string; wiki DB name
33 * Construct a new instance from configuration.
35 * 'wiki' : wiki name to use for LoadBalancer
37 * @param $config Array
39 protected function __construct( array $config ) {
40 parent
::__construct( $config );
42 $this->wiki
= $config['wiki'];
46 * @see FileJournal::logChangeBatch()
49 protected function doLogChangeBatch( array $entries, $batchId ) {
50 $status = Status
::newGood();
53 $dbw = $this->getMasterDB();
54 } catch ( DBError
$e ) {
55 $status->fatal( 'filejournal-fail-dbconnect', $this->backend
);
59 $now = wfTimestamp( TS_UNIX
);
62 foreach ( $entries as $entry ) {
64 'fj_batch_uuid' => $batchId,
65 'fj_backend' => $this->backend
,
66 'fj_op' => $entry['op'],
67 'fj_path' => $entry['path'],
68 'fj_new_sha1' => $entry['newSha1'],
69 'fj_timestamp' => $dbw->timestamp( $now )
75 $dbw->insert( 'filejournal', $data, __METHOD__
);
77 } catch ( DBError
$e ) {
78 $status->fatal( 'filejournal-fail-dbquery', $this->backend
);
86 * @see FileJournal::doGetChangeEntries()
90 protected function doGetChangeEntries( $start, $limit ) {
91 $dbw = $this->getMasterDB();
93 $res = $dbw->select( 'filejournal', '*',
95 'fj_backend' => $this->backend
,
96 'fj_id >= ' . $dbw->addQuotes( (int)$start ) ), // $start may be 0
98 array_merge( array( 'ORDER BY' => 'fj_id ASC' ),
99 $limit ?
array( 'LIMIT' => $limit ) : array() )
103 foreach ( $res as $row ) {
105 foreach ( (array)$row as $key => $value ) {
106 $item[substr( $key, 3 )] = $value; // "fj_op" => "op"
115 * @see FileJournal::purgeOldLogs()
119 protected function doPurgeOldLogs() {
120 $status = Status
::newGood();
121 if ( $this->ttlDays
<= 0 ) {
122 return $status; // nothing to do
125 $dbw = $this->getMasterDB();
126 $dbCutoff = $dbw->timestamp( time() - 86400 * $this->ttlDays
);
129 $dbw->delete( 'filejournal',
130 array( 'fj_timestamp < ' . $dbw->addQuotes( $dbCutoff ) ),
139 * Get a master connection to the logging DB
141 * @return DatabaseBase
144 protected function getMasterDB() {
145 $lb = wfGetLBFactory()->newMainLB();
146 return $lb->getConnection( DB_MASTER
, array(), $this->wiki
);