MediaWiki REL1_30
DatabaseOracle.php
Go to the documentation of this file.
1<?php
29
33class DatabaseOracle extends Database {
35 protected $mLastResult = null;
36
38 protected $mAffectedRows;
39
41 private $ignoreDupValOnIndex = false;
42
44 private $sequenceData = null;
45
47 private $defaultCharset = 'AL32UTF8';
48
50 private $mFieldInfoCache = [];
51
52 function __construct( array $p ) {
53 global $wgDBprefix;
54
55 if ( $p['tablePrefix'] == 'get from global' ) {
56 $p['tablePrefix'] = $wgDBprefix;
57 }
58 $p['tablePrefix'] = strtoupper( $p['tablePrefix'] );
59 parent::__construct( $p );
60 Hooks::run( 'DatabaseOraclePostInit', [ $this ] );
61 }
62
63 function __destruct() {
64 if ( $this->mOpened ) {
65 MediaWiki\suppressWarnings();
66 $this->close();
67 MediaWiki\restoreWarnings();
68 }
69 }
70
71 function getType() {
72 return 'oracle';
73 }
74
75 function implicitGroupby() {
76 return false;
77 }
78
79 function implicitOrderby() {
80 return false;
81 }
82
92 function open( $server, $user, $password, $dbName ) {
93 global $wgDBOracleDRCP;
94 if ( !function_exists( 'oci_connect' ) ) {
95 throw new DBConnectionError(
96 $this,
97 "Oracle functions missing, have you compiled PHP with the --with-oci8 option?\n " .
98 "(Note: if you recently installed PHP, you may need to restart your webserver\n " .
99 "and database)\n" );
100 }
101
102 $this->close();
103 $this->mUser = $user;
104 $this->mPassword = $password;
105 // changed internal variables functions
106 // mServer now holds the TNS endpoint
107 // mDBname is schema name if different from username
108 if ( !$server ) {
109 // backward compatibillity (server used to be null and TNS was supplied in dbname)
110 $this->mServer = $dbName;
111 $this->mDBname = $user;
112 } else {
113 $this->mServer = $server;
114 if ( !$dbName ) {
115 $this->mDBname = $user;
116 } else {
117 $this->mDBname = $dbName;
118 }
119 }
120
121 if ( !strlen( $user ) ) { # e.g. the class is being loaded
122 return null;
123 }
124
125 if ( $wgDBOracleDRCP ) {
126 $this->setFlag( DBO_PERSISTENT );
127 }
128
129 $session_mode = $this->mFlags & DBO_SYSDBA ? OCI_SYSDBA : OCI_DEFAULT;
130
131 MediaWiki\suppressWarnings();
132 if ( $this->mFlags & DBO_PERSISTENT ) {
133 $this->mConn = oci_pconnect(
134 $this->mUser,
135 $this->mPassword,
136 $this->mServer,
137 $this->defaultCharset,
138 $session_mode
139 );
140 } elseif ( $this->mFlags & DBO_DEFAULT ) {
141 $this->mConn = oci_new_connect(
142 $this->mUser,
143 $this->mPassword,
144 $this->mServer,
145 $this->defaultCharset,
146 $session_mode
147 );
148 } else {
149 $this->mConn = oci_connect(
150 $this->mUser,
151 $this->mPassword,
152 $this->mServer,
153 $this->defaultCharset,
154 $session_mode
155 );
156 }
157 MediaWiki\restoreWarnings();
158
159 if ( $this->mUser != $this->mDBname ) {
160 // change current schema in session
161 $this->selectDB( $this->mDBname );
162 }
163
164 if ( !$this->mConn ) {
165 throw new DBConnectionError( $this, $this->lastError() );
166 }
167
168 $this->mOpened = true;
169
170 # removed putenv calls because they interfere with the system globaly
171 $this->doQuery( 'ALTER SESSION SET NLS_TIMESTAMP_FORMAT=\'DD-MM-YYYY HH24:MI:SS.FF6\'' );
172 $this->doQuery( 'ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT=\'DD-MM-YYYY HH24:MI:SS.FF6\'' );
173 $this->doQuery( 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS=\'.,\'' );
174
175 return $this->mConn;
176 }
177
183 protected function closeConnection() {
184 return oci_close( $this->mConn );
185 }
186
187 function execFlags() {
188 return $this->mTrxLevel ? OCI_NO_AUTO_COMMIT : OCI_COMMIT_ON_SUCCESS;
189 }
190
191 protected function doQuery( $sql ) {
192 wfDebug( "SQL: [$sql]\n" );
193 if ( !StringUtils::isUtf8( $sql ) ) {
194 throw new InvalidArgumentException( "SQL encoding is invalid\n$sql" );
195 }
196
197 // handle some oracle specifics
198 // remove AS column/table/subquery namings
199 if ( !$this->getFlag( DBO_DDLMODE ) ) {
200 $sql = preg_replace( '/ as /i', ' ', $sql );
201 }
202
203 // Oracle has issues with UNION clause if the statement includes LOB fields
204 // So we do a UNION ALL and then filter the results array with array_unique
205 $union_unique = ( preg_match( '/\/\* UNION_UNIQUE \*\/ /', $sql ) != 0 );
206 // EXPLAIN syntax in Oracle is EXPLAIN PLAN FOR and it return nothing
207 // you have to select data from plan table after explain
208 $explain_id = MWTimestamp::getLocalInstance()->format( 'dmYHis' );
209
210 $sql = preg_replace(
211 '/^EXPLAIN /',
212 'EXPLAIN PLAN SET STATEMENT_ID = \'' . $explain_id . '\' FOR',
213 $sql,
214 1,
215 $explain_count
216 );
217
218 MediaWiki\suppressWarnings();
219
220 $this->mLastResult = $stmt = oci_parse( $this->mConn, $sql );
221 if ( $stmt === false ) {
222 $e = oci_error( $this->mConn );
223 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
224
225 return false;
226 }
227
228 if ( !oci_execute( $stmt, $this->execFlags() ) ) {
229 $e = oci_error( $stmt );
230 if ( !$this->ignoreDupValOnIndex || $e['code'] != '1' ) {
231 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
232
233 return false;
234 }
235 }
236
237 MediaWiki\restoreWarnings();
238
239 if ( $explain_count > 0 ) {
240 return $this->doQuery( 'SELECT id, cardinality "ROWS" FROM plan_table ' .
241 'WHERE statement_id = \'' . $explain_id . '\'' );
242 } elseif ( oci_statement_type( $stmt ) == 'SELECT' ) {
243 return new ORAResult( $this, $stmt, $union_unique );
244 } else {
245 $this->mAffectedRows = oci_num_rows( $stmt );
246
247 return true;
248 }
249 }
250
251 function queryIgnore( $sql, $fname = '' ) {
252 return $this->query( $sql, $fname, true );
253 }
254
259 function freeResult( $res ) {
260 if ( $res instanceof ResultWrapper ) {
261 $res = $res->result;
262 }
263
264 $res->free();
265 }
266
271 function fetchObject( $res ) {
272 if ( $res instanceof ResultWrapper ) {
273 $res = $res->result;
274 }
275
276 return $res->fetchObject();
277 }
278
283 function fetchRow( $res ) {
284 if ( $res instanceof ResultWrapper ) {
285 $res = $res->result;
286 }
287
288 return $res->fetchRow();
289 }
290
295 function numRows( $res ) {
296 if ( $res instanceof ResultWrapper ) {
297 $res = $res->result;
298 }
299
300 return $res->numRows();
301 }
302
307 function numFields( $res ) {
308 if ( $res instanceof ResultWrapper ) {
309 $res = $res->result;
310 }
311
312 return $res->numFields();
313 }
314
315 function fieldName( $stmt, $n ) {
316 return oci_field_name( $stmt, $n );
317 }
318
319 function insertId() {
320 $res = $this->query( "SELECT lastval_pkg.getLastval FROM dual" );
321 $row = $this->fetchRow( $res );
322 return is_null( $row[0] ) ? null : (int)$row[0];
323 }
324
329 function dataSeek( $res, $row ) {
330 if ( $res instanceof ORAResult ) {
331 $res->seek( $row );
332 } else {
333 $res->result->seek( $row );
334 }
335 }
336
337 function lastError() {
338 if ( $this->mConn === false ) {
339 $e = oci_error();
340 } else {
341 $e = oci_error( $this->mConn );
342 }
343
344 return $e['message'];
345 }
346
347 function lastErrno() {
348 if ( $this->mConn === false ) {
349 $e = oci_error();
350 } else {
351 $e = oci_error( $this->mConn );
352 }
353
354 return $e['code'];
355 }
356
357 function affectedRows() {
358 return $this->mAffectedRows;
359 }
360
369 function indexInfo( $table, $index, $fname = __METHOD__ ) {
370 return false;
371 }
372
373 function indexUnique( $table, $index, $fname = __METHOD__ ) {
374 return false;
375 }
376
377 function insert( $table, $a, $fname = __METHOD__, $options = [] ) {
378 if ( !count( $a ) ) {
379 return true;
380 }
381
382 if ( !is_array( $options ) ) {
383 $options = [ $options ];
384 }
385
386 if ( in_array( 'IGNORE', $options ) ) {
387 $this->ignoreDupValOnIndex = true;
388 }
389
390 if ( !is_array( reset( $a ) ) ) {
391 $a = [ $a ];
392 }
393
394 foreach ( $a as &$row ) {
395 $this->insertOneRow( $table, $row, $fname );
396 }
397 $retVal = true;
398
399 if ( in_array( 'IGNORE', $options ) ) {
400 $this->ignoreDupValOnIndex = false;
401 }
402
403 return $retVal;
404 }
405
406 private function fieldBindStatement( $table, $col, &$val, $includeCol = false ) {
407 $col_info = $this->fieldInfoMulti( $table, $col );
408 $col_type = $col_info != false ? $col_info->type() : 'CONSTANT';
409
410 $bind = '';
411 if ( is_numeric( $col ) ) {
412 $bind = $val;
413 $val = null;
414
415 return $bind;
416 } elseif ( $includeCol ) {
417 $bind = "$col = ";
418 }
419
420 if ( $val == '' && $val !== 0 && $col_type != 'BLOB' && $col_type != 'CLOB' ) {
421 $val = null;
422 }
423
424 if ( $val === 'NULL' ) {
425 $val = null;
426 }
427
428 if ( $val === null ) {
429 if ( $col_info != false && $col_info->isNullable() == 0 && $col_info->defaultValue() != null ) {
430 $bind .= 'DEFAULT';
431 } else {
432 $bind .= 'NULL';
433 }
434 } else {
435 $bind .= ':' . $col;
436 }
437
438 return $bind;
439 }
440
448 private function insertOneRow( $table, $row, $fname ) {
449 global $wgContLang;
450
451 $table = $this->tableName( $table );
452 // "INSERT INTO tables (a, b, c)"
453 $sql = "INSERT INTO " . $table . " (" . implode( ',', array_keys( $row ) ) . ')';
454 $sql .= " VALUES (";
455
456 // for each value, append ":key"
457 $first = true;
458 foreach ( $row as $col => &$val ) {
459 if ( !$first ) {
460 $sql .= ', ';
461 } else {
462 $first = false;
463 }
464 if ( $this->isQuotedIdentifier( $val ) ) {
465 $sql .= $this->removeIdentifierQuotes( $val );
466 unset( $row[$col] );
467 } else {
468 $sql .= $this->fieldBindStatement( $table, $col, $val );
469 }
470 }
471 $sql .= ')';
472
473 $this->mLastResult = $stmt = oci_parse( $this->mConn, $sql );
474 if ( $stmt === false ) {
475 $e = oci_error( $this->mConn );
476 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
477
478 return false;
479 }
480 foreach ( $row as $col => &$val ) {
481 $col_info = $this->fieldInfoMulti( $table, $col );
482 $col_type = $col_info != false ? $col_info->type() : 'CONSTANT';
483
484 if ( $val === null ) {
485 // do nothing ... null was inserted in statement creation
486 } elseif ( $col_type != 'BLOB' && $col_type != 'CLOB' ) {
487 if ( is_object( $val ) ) {
488 $val = $val->fetch();
489 }
490
491 // backward compatibility
492 if ( preg_match( '/^timestamp.*/i', $col_type ) == 1 && strtolower( $val ) == 'infinity' ) {
493 $val = $this->getInfinity();
494 }
495
496 $val = ( $wgContLang != null ) ? $wgContLang->checkTitleEncoding( $val ) : $val;
497 if ( oci_bind_by_name( $stmt, ":$col", $val, -1, SQLT_CHR ) === false ) {
498 $e = oci_error( $stmt );
499 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
500
501 return false;
502 }
503 } else {
505 $lob[$col] = oci_new_descriptor( $this->mConn, OCI_D_LOB );
506 if ( $lob[$col] === false ) {
507 $e = oci_error( $stmt );
508 throw new DBUnexpectedError( $this, "Cannot create LOB descriptor: " . $e['message'] );
509 }
510
511 if ( is_object( $val ) ) {
512 $val = $val->fetch();
513 }
514
515 if ( $col_type == 'BLOB' ) {
516 $lob[$col]->writeTemporary( $val, OCI_TEMP_BLOB );
517 oci_bind_by_name( $stmt, ":$col", $lob[$col], -1, OCI_B_BLOB );
518 } else {
519 $lob[$col]->writeTemporary( $val, OCI_TEMP_CLOB );
520 oci_bind_by_name( $stmt, ":$col", $lob[$col], -1, OCI_B_CLOB );
521 }
522 }
523 }
524
525 MediaWiki\suppressWarnings();
526
527 if ( oci_execute( $stmt, $this->execFlags() ) === false ) {
528 $e = oci_error( $stmt );
529 if ( !$this->ignoreDupValOnIndex || $e['code'] != '1' ) {
530 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
531
532 return false;
533 } else {
534 $this->mAffectedRows = oci_num_rows( $stmt );
535 }
536 } else {
537 $this->mAffectedRows = oci_num_rows( $stmt );
538 }
539
540 MediaWiki\restoreWarnings();
541
542 if ( isset( $lob ) ) {
543 foreach ( $lob as $lob_v ) {
544 $lob_v->free();
545 }
546 }
547
548 if ( !$this->mTrxLevel ) {
549 oci_commit( $this->mConn );
550 }
551
552 return oci_free_statement( $stmt );
553 }
554
555 function nativeInsertSelect( $destTable, $srcTable, $varMap, $conds, $fname = __METHOD__,
556 $insertOptions = [], $selectOptions = [], $selectJoinConds = []
557 ) {
558 $destTable = $this->tableName( $destTable );
559
560 $sequenceData = $this->getSequenceData( $destTable );
561 if ( $sequenceData !== false &&
562 !isset( $varMap[$sequenceData['column']] )
563 ) {
564 $varMap[$sequenceData['column']] = 'GET_SEQUENCE_VALUE(\'' . $sequenceData['sequence'] . '\')';
565 }
566
567 // count-alias subselect fields to avoid abigious definition errors
568 $i = 0;
569 foreach ( $varMap as &$val ) {
570 $val = $val . ' field' . ( $i++ );
571 }
572
573 $selectSql = $this->selectSQLText(
574 $srcTable,
575 array_values( $varMap ),
576 $conds,
577 $fname,
578 $selectOptions,
579 $selectJoinConds
580 );
581
582 $sql = "INSERT INTO $destTable (" . implode( ',', array_keys( $varMap ) ) . ') ' . $selectSql;
583
584 if ( in_array( 'IGNORE', $insertOptions ) ) {
585 $this->ignoreDupValOnIndex = true;
586 }
587
588 $retval = $this->query( $sql, $fname );
589
590 if ( in_array( 'IGNORE', $insertOptions ) ) {
591 $this->ignoreDupValOnIndex = false;
592 }
593
594 return $retval;
595 }
596
597 public function upsert( $table, array $rows, array $uniqueIndexes, array $set,
598 $fname = __METHOD__
599 ) {
600 if ( !count( $rows ) ) {
601 return true; // nothing to do
602 }
603
604 if ( !is_array( reset( $rows ) ) ) {
605 $rows = [ $rows ];
606 }
607
608 $sequenceData = $this->getSequenceData( $table );
609 if ( $sequenceData !== false ) {
610 // add sequence column to each list of columns, when not set
611 foreach ( $rows as &$row ) {
612 if ( !isset( $row[$sequenceData['column']] ) ) {
613 $row[$sequenceData['column']] =
614 $this->addIdentifierQuotes( 'GET_SEQUENCE_VALUE(\'' .
615 $sequenceData['sequence'] . '\')' );
616 }
617 }
618 }
619
620 return parent::upsert( $table, $rows, $uniqueIndexes, $set, $fname );
621 }
622
623 function tableName( $name, $format = 'quoted' ) {
624 /*
625 Replace reserved words with better ones
626 Using uppercase because that's the only way Oracle can handle
627 quoted tablenames
628 */
629 switch ( $name ) {
630 case 'user':
631 $name = 'MWUSER';
632 break;
633 case 'text':
634 $name = 'PAGECONTENT';
635 break;
636 }
637
638 return strtoupper( parent::tableName( $name, $format ) );
639 }
640
641 function tableNameInternal( $name ) {
642 $name = $this->tableName( $name );
643
644 return preg_replace( '/.*\.(.*)/', '$1', $name );
645 }
646
653 private function getSequenceData( $table ) {
654 if ( $this->sequenceData == null ) {
655 $result = $this->doQuery( "SELECT lower(asq.sequence_name),
656 lower(atc.table_name),
657 lower(atc.column_name)
658 FROM all_sequences asq, all_tab_columns atc
659 WHERE decode(
660 atc.table_name,
661 '{$this->mTablePrefix}MWUSER',
662 '{$this->mTablePrefix}USER',
663 atc.table_name
664 ) || '_' ||
665 atc.column_name || '_SEQ' = '{$this->mTablePrefix}' || asq.sequence_name
666 AND asq.sequence_owner = upper('{$this->mDBname}')
667 AND atc.owner = upper('{$this->mDBname}')" );
668
669 while ( ( $row = $result->fetchRow() ) !== false ) {
670 $this->sequenceData[$row[1]] = [
671 'sequence' => $row[0],
672 'column' => $row[2]
673 ];
674 }
675 }
676 $table = strtolower( $this->removeIdentifierQuotes( $this->tableName( $table ) ) );
677
678 return ( isset( $this->sequenceData[$table] ) ) ? $this->sequenceData[$table] : false;
679 }
680
688 function textFieldSize( $table, $field ) {
689 $fieldInfoData = $this->fieldInfo( $table, $field );
690
691 return $fieldInfoData->maxLength();
692 }
693
694 function limitResult( $sql, $limit, $offset = false ) {
695 if ( $offset === false ) {
696 $offset = 0;
697 }
698
699 return "SELECT * FROM ($sql) WHERE rownum >= (1 + $offset) AND rownum < (1 + $limit + $offset)";
700 }
701
702 function encodeBlob( $b ) {
703 return new Blob( $b );
704 }
705
706 function decodeBlob( $b ) {
707 if ( $b instanceof Blob ) {
708 $b = $b->fetch();
709 }
710
711 return $b;
712 }
713
714 function unionQueries( $sqls, $all ) {
715 $glue = ' UNION ALL ';
716
717 return 'SELECT * ' . ( $all ? '' : '/* UNION_UNIQUE */ ' ) .
718 'FROM (' . implode( $glue, $sqls ) . ')';
719 }
720
721 function wasDeadlock() {
722 return $this->lastErrno() == 'OCI-00060';
723 }
724
725 function duplicateTableStructure( $oldName, $newName, $temporary = false,
726 $fname = __METHOD__
727 ) {
728 $temporary = $temporary ? 'TRUE' : 'FALSE';
729
730 $newName = strtoupper( $newName );
731 $oldName = strtoupper( $oldName );
732
733 $tabName = substr( $newName, strlen( $this->mTablePrefix ) );
734 $oldPrefix = substr( $oldName, 0, strlen( $oldName ) - strlen( $tabName ) );
735 $newPrefix = strtoupper( $this->mTablePrefix );
736
737 return $this->doQuery( "BEGIN DUPLICATE_TABLE( '$tabName', " .
738 "'$oldPrefix', '$newPrefix', $temporary ); END;" );
739 }
740
741 function listTables( $prefix = null, $fname = __METHOD__ ) {
742 $listWhere = '';
743 if ( !empty( $prefix ) ) {
744 $listWhere = ' AND table_name LIKE \'' . strtoupper( $prefix ) . '%\'';
745 }
746
747 $owner = strtoupper( $this->mDBname );
748 $result = $this->doQuery( "SELECT table_name FROM all_tables " .
749 "WHERE owner='$owner' AND table_name NOT LIKE '%!_IDX\$_' ESCAPE '!' $listWhere" );
750
751 // dirty code ... i know
752 $endArray = [];
753 $endArray[] = strtoupper( $prefix . 'MWUSER' );
754 $endArray[] = strtoupper( $prefix . 'PAGE' );
755 $endArray[] = strtoupper( $prefix . 'IMAGE' );
756 $fixedOrderTabs = $endArray;
757 while ( ( $row = $result->fetchRow() ) !== false ) {
758 if ( !in_array( $row['table_name'], $fixedOrderTabs ) ) {
759 $endArray[] = $row['table_name'];
760 }
761 }
762
763 return $endArray;
764 }
765
766 public function dropTable( $tableName, $fName = __METHOD__ ) {
767 $tableName = $this->tableName( $tableName );
768 if ( !$this->tableExists( $tableName ) ) {
769 return false;
770 }
771
772 return $this->doQuery( "DROP TABLE $tableName CASCADE CONSTRAINTS PURGE" );
773 }
774
775 function timestamp( $ts = 0 ) {
776 return wfTimestamp( TS_ORACLE, $ts );
777 }
778
786 public function aggregateValue( $valuedata, $valuename = 'value' ) {
787 return $valuedata;
788 }
789
793 public function getSoftwareLink() {
794 return '[{{int:version-db-oracle-url}} Oracle]';
795 }
796
800 function getServerVersion() {
801 // better version number, fallback on driver
802 $rset = $this->doQuery(
803 'SELECT version FROM product_component_version ' .
804 'WHERE UPPER(product) LIKE \'ORACLE DATABASE%\''
805 );
806 $row = $rset->fetchRow();
807 if ( !$row ) {
808 return oci_server_version( $this->mConn );
809 }
810
811 return $row['version'];
812 }
813
821 function indexExists( $table, $index, $fname = __METHOD__ ) {
822 $table = $this->tableName( $table );
823 $table = strtoupper( $this->removeIdentifierQuotes( $table ) );
824 $index = strtoupper( $index );
825 $owner = strtoupper( $this->mDBname );
826 $sql = "SELECT 1 FROM all_indexes WHERE owner='$owner' AND index_name='{$table}_{$index}'";
827 $res = $this->doQuery( $sql );
828 if ( $res ) {
829 $count = $res->numRows();
830 $res->free();
831 } else {
832 $count = 0;
833 }
834
835 return $count != 0;
836 }
837
844 function tableExists( $table, $fname = __METHOD__ ) {
845 $table = $this->tableName( $table );
846 $table = $this->addQuotes( strtoupper( $this->removeIdentifierQuotes( $table ) ) );
847 $owner = $this->addQuotes( strtoupper( $this->mDBname ) );
848 $sql = "SELECT 1 FROM all_tables WHERE owner=$owner AND table_name=$table";
849 $res = $this->doQuery( $sql );
850 if ( $res && $res->numRows() > 0 ) {
851 $exists = true;
852 } else {
853 $exists = false;
854 }
855
856 $res->free();
857
858 return $exists;
859 }
860
871 private function fieldInfoMulti( $table, $field ) {
872 $field = strtoupper( $field );
873 if ( is_array( $table ) ) {
874 $table = array_map( [ $this, 'tableNameInternal' ], $table );
875 $tableWhere = 'IN (';
876 foreach ( $table as &$singleTable ) {
877 $singleTable = $this->removeIdentifierQuotes( $singleTable );
878 if ( isset( $this->mFieldInfoCache["$singleTable.$field"] ) ) {
879 return $this->mFieldInfoCache["$singleTable.$field"];
880 }
881 $tableWhere .= '\'' . $singleTable . '\',';
882 }
883 $tableWhere = rtrim( $tableWhere, ',' ) . ')';
884 } else {
885 $table = $this->removeIdentifierQuotes( $this->tableNameInternal( $table ) );
886 if ( isset( $this->mFieldInfoCache["$table.$field"] ) ) {
887 return $this->mFieldInfoCache["$table.$field"];
888 }
889 $tableWhere = '= \'' . $table . '\'';
890 }
891
892 $fieldInfoStmt = oci_parse(
893 $this->mConn,
894 'SELECT * FROM wiki_field_info_full WHERE table_name ' .
895 $tableWhere . ' and column_name = \'' . $field . '\''
896 );
897 if ( oci_execute( $fieldInfoStmt, $this->execFlags() ) === false ) {
898 $e = oci_error( $fieldInfoStmt );
899 $this->reportQueryError( $e['message'], $e['code'], 'fieldInfo QUERY', __METHOD__ );
900
901 return false;
902 }
903 $res = new ORAResult( $this, $fieldInfoStmt );
904 if ( $res->numRows() == 0 ) {
905 if ( is_array( $table ) ) {
906 foreach ( $table as &$singleTable ) {
907 $this->mFieldInfoCache["$singleTable.$field"] = false;
908 }
909 } else {
910 $this->mFieldInfoCache["$table.$field"] = false;
911 }
912 $fieldInfoTemp = null;
913 } else {
914 $fieldInfoTemp = new ORAField( $res->fetchRow() );
915 $table = $fieldInfoTemp->tableName();
916 $this->mFieldInfoCache["$table.$field"] = $fieldInfoTemp;
917 }
918 $res->free();
919
920 return $fieldInfoTemp;
921 }
922
929 function fieldInfo( $table, $field ) {
930 if ( is_array( $table ) ) {
931 throw new DBUnexpectedError( $this, 'DatabaseOracle::fieldInfo called with table array!' );
932 }
933
934 return $this->fieldInfoMulti( $table, $field );
935 }
936
937 protected function doBegin( $fname = __METHOD__ ) {
938 $this->mTrxLevel = 1;
939 $this->doQuery( 'SET CONSTRAINTS ALL DEFERRED' );
940 }
941
942 protected function doCommit( $fname = __METHOD__ ) {
943 if ( $this->mTrxLevel ) {
944 $ret = oci_commit( $this->mConn );
945 if ( !$ret ) {
946 throw new DBUnexpectedError( $this, $this->lastError() );
947 }
948 $this->mTrxLevel = 0;
949 $this->doQuery( 'SET CONSTRAINTS ALL IMMEDIATE' );
950 }
951 }
952
953 protected function doRollback( $fname = __METHOD__ ) {
954 if ( $this->mTrxLevel ) {
955 oci_rollback( $this->mConn );
956 $this->mTrxLevel = 0;
957 $this->doQuery( 'SET CONSTRAINTS ALL IMMEDIATE' );
958 }
959 }
960
961 function sourceStream(
962 $fp,
963 callable $lineCallback = null,
964 callable $resultCallback = null,
965 $fname = __METHOD__, callable $inputCallback = null
966 ) {
967 $cmd = '';
968 $done = false;
969 $dollarquote = false;
970
971 $replacements = [];
972 // Defines must comply with ^define\s*([^\s=]*)\s*=\s?'\{\$([^\}]*)\}';
973 while ( !feof( $fp ) ) {
974 if ( $lineCallback ) {
975 call_user_func( $lineCallback );
976 }
977 $line = trim( fgets( $fp, 1024 ) );
978 $sl = strlen( $line ) - 1;
979
980 if ( $sl < 0 ) {
981 continue;
982 }
983 if ( '-' == $line[0] && '-' == $line[1] ) {
984 continue;
985 }
986
987 // Allow dollar quoting for function declarations
988 if ( substr( $line, 0, 8 ) == '/*$mw$*/' ) {
989 if ( $dollarquote ) {
990 $dollarquote = false;
991 $line = str_replace( '/*$mw$*/', '', $line ); // remove dollarquotes
992 $done = true;
993 } else {
994 $dollarquote = true;
995 }
996 } elseif ( !$dollarquote ) {
997 if ( ';' == $line[$sl] && ( $sl < 2 || ';' != $line[$sl - 1] ) ) {
998 $done = true;
999 $line = substr( $line, 0, $sl );
1000 }
1001 }
1002
1003 if ( $cmd != '' ) {
1004 $cmd .= ' ';
1005 }
1006 $cmd .= "$line\n";
1007
1008 if ( $done ) {
1009 $cmd = str_replace( ';;', ";", $cmd );
1010 if ( strtolower( substr( $cmd, 0, 6 ) ) == 'define' ) {
1011 if ( preg_match( '/^define\s*([^\s=]*)\s*=\s*\'\{\$([^\}]*)\}\'/', $cmd, $defines ) ) {
1012 $replacements[$defines[2]] = $defines[1];
1013 }
1014 } else {
1015 foreach ( $replacements as $mwVar => $scVar ) {
1016 $cmd = str_replace( '&' . $scVar . '.', '`{$' . $mwVar . '}`', $cmd );
1017 }
1018
1019 $cmd = $this->replaceVars( $cmd );
1020 if ( $inputCallback ) {
1021 call_user_func( $inputCallback, $cmd );
1022 }
1023 $res = $this->doQuery( $cmd );
1024 if ( $resultCallback ) {
1025 call_user_func( $resultCallback, $res, $this );
1026 }
1027
1028 if ( false === $res ) {
1029 $err = $this->lastError();
1030
1031 return "Query \"{$cmd}\" failed with error code \"$err\".\n";
1032 }
1033 }
1034
1035 $cmd = '';
1036 $done = false;
1037 }
1038 }
1039
1040 return true;
1041 }
1042
1043 function selectDB( $db ) {
1044 $this->mDBname = $db;
1045 if ( $db == null || $db == $this->mUser ) {
1046 return true;
1047 }
1048 $sql = 'ALTER SESSION SET CURRENT_SCHEMA=' . strtoupper( $db );
1049 $stmt = oci_parse( $this->mConn, $sql );
1050 MediaWiki\suppressWarnings();
1051 $success = oci_execute( $stmt );
1052 MediaWiki\restoreWarnings();
1053 if ( !$success ) {
1054 $e = oci_error( $stmt );
1055 if ( $e['code'] != '1435' ) {
1056 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
1057 }
1058
1059 return false;
1060 }
1061
1062 return true;
1063 }
1064
1065 function strencode( $s ) {
1066 return str_replace( "'", "''", $s );
1067 }
1068
1069 function addQuotes( $s ) {
1070 global $wgContLang;
1071 if ( isset( $wgContLang->mLoaded ) && $wgContLang->mLoaded ) {
1072 $s = $wgContLang->checkTitleEncoding( $s );
1073 }
1074
1075 return "'" . $this->strencode( $s ) . "'";
1076 }
1077
1078 public function addIdentifierQuotes( $s ) {
1079 if ( !$this->getFlag( DBO_DDLMODE ) ) {
1080 $s = '/*Q*/' . $s;
1081 }
1082
1083 return $s;
1084 }
1085
1086 public function removeIdentifierQuotes( $s ) {
1087 return strpos( $s, '/*Q*/' ) === false ? $s : substr( $s, 5 );
1088 }
1089
1090 public function isQuotedIdentifier( $s ) {
1091 return strpos( $s, '/*Q*/' ) !== false;
1092 }
1093
1094 private function wrapFieldForWhere( $table, &$col, &$val ) {
1095 global $wgContLang;
1096
1097 $col_info = $this->fieldInfoMulti( $table, $col );
1098 $col_type = $col_info != false ? $col_info->type() : 'CONSTANT';
1099 if ( $col_type == 'CLOB' ) {
1100 $col = 'TO_CHAR(' . $col . ')';
1101 $val = $wgContLang->checkTitleEncoding( $val );
1102 } elseif ( $col_type == 'VARCHAR2' ) {
1103 $val = $wgContLang->checkTitleEncoding( $val );
1104 }
1105 }
1106
1107 private function wrapConditionsForWhere( $table, $conds, $parentCol = null ) {
1108 $conds2 = [];
1109 foreach ( $conds as $col => $val ) {
1110 if ( is_array( $val ) ) {
1111 $conds2[$col] = $this->wrapConditionsForWhere( $table, $val, $col );
1112 } else {
1113 if ( is_numeric( $col ) && $parentCol != null ) {
1114 $this->wrapFieldForWhere( $table, $parentCol, $val );
1115 } else {
1116 $this->wrapFieldForWhere( $table, $col, $val );
1117 }
1118 $conds2[$col] = $val;
1119 }
1120 }
1121
1122 return $conds2;
1123 }
1124
1125 function selectRow( $table, $vars, $conds, $fname = __METHOD__,
1126 $options = [], $join_conds = []
1127 ) {
1128 if ( is_array( $conds ) ) {
1129 $conds = $this->wrapConditionsForWhere( $table, $conds );
1130 }
1131
1132 return parent::selectRow( $table, $vars, $conds, $fname, $options, $join_conds );
1133 }
1134
1144 $preLimitTail = $postLimitTail = '';
1145 $startOpts = '';
1146
1147 $noKeyOptions = [];
1148 foreach ( $options as $key => $option ) {
1149 if ( is_numeric( $key ) ) {
1150 $noKeyOptions[$option] = true;
1151 }
1152 }
1153
1154 $preLimitTail .= $this->makeGroupByWithHaving( $options );
1155
1156 $preLimitTail .= $this->makeOrderBy( $options );
1157
1158 if ( isset( $noKeyOptions['FOR UPDATE'] ) ) {
1159 $postLimitTail .= ' FOR UPDATE';
1160 }
1161
1162 if ( isset( $noKeyOptions['DISTINCT'] ) || isset( $noKeyOptions['DISTINCTROW'] ) ) {
1163 $startOpts .= 'DISTINCT';
1164 }
1165
1166 if ( isset( $options['USE INDEX'] ) && !is_array( $options['USE INDEX'] ) ) {
1167 $useIndex = $this->useIndexClause( $options['USE INDEX'] );
1168 } else {
1169 $useIndex = '';
1170 }
1171
1172 if ( isset( $options['IGNORE INDEX'] ) && !is_array( $options['IGNORE INDEX'] ) ) {
1173 $ignoreIndex = $this->ignoreIndexClause( $options['IGNORE INDEX'] );
1174 } else {
1175 $ignoreIndex = '';
1176 }
1177
1178 return [ $startOpts, $useIndex, $preLimitTail, $postLimitTail, $ignoreIndex ];
1179 }
1180
1181 public function delete( $table, $conds, $fname = __METHOD__ ) {
1182 if ( is_array( $conds ) ) {
1183 $conds = $this->wrapConditionsForWhere( $table, $conds );
1184 }
1185 // a hack for deleting pages, users and images (which have non-nullable FKs)
1186 // all deletions on these tables have transactions so final failure rollbacks these updates
1187 $table = $this->tableName( $table );
1188 if ( $table == $this->tableName( 'user' ) ) {
1189 $this->update( 'archive', [ 'ar_user' => 0 ],
1190 [ 'ar_user' => $conds['user_id'] ], $fname );
1191 $this->update( 'ipblocks', [ 'ipb_user' => 0 ],
1192 [ 'ipb_user' => $conds['user_id'] ], $fname );
1193 $this->update( 'image', [ 'img_user' => 0 ],
1194 [ 'img_user' => $conds['user_id'] ], $fname );
1195 $this->update( 'oldimage', [ 'oi_user' => 0 ],
1196 [ 'oi_user' => $conds['user_id'] ], $fname );
1197 $this->update( 'filearchive', [ 'fa_deleted_user' => 0 ],
1198 [ 'fa_deleted_user' => $conds['user_id'] ], $fname );
1199 $this->update( 'filearchive', [ 'fa_user' => 0 ],
1200 [ 'fa_user' => $conds['user_id'] ], $fname );
1201 $this->update( 'uploadstash', [ 'us_user' => 0 ],
1202 [ 'us_user' => $conds['user_id'] ], $fname );
1203 $this->update( 'recentchanges', [ 'rc_user' => 0 ],
1204 [ 'rc_user' => $conds['user_id'] ], $fname );
1205 $this->update( 'logging', [ 'log_user' => 0 ],
1206 [ 'log_user' => $conds['user_id'] ], $fname );
1207 } elseif ( $table == $this->tableName( 'image' ) ) {
1208 $this->update( 'oldimage', [ 'oi_name' => 0 ],
1209 [ 'oi_name' => $conds['img_name'] ], $fname );
1210 }
1211
1212 return parent::delete( $table, $conds, $fname );
1213 }
1214
1224 function update( $table, $values, $conds, $fname = __METHOD__, $options = [] ) {
1225 global $wgContLang;
1226
1227 $table = $this->tableName( $table );
1228 $opts = $this->makeUpdateOptions( $options );
1229 $sql = "UPDATE $opts $table SET ";
1230
1231 $first = true;
1232 foreach ( $values as $col => &$val ) {
1233 $sqlSet = $this->fieldBindStatement( $table, $col, $val, true );
1234
1235 if ( !$first ) {
1236 $sqlSet = ', ' . $sqlSet;
1237 } else {
1238 $first = false;
1239 }
1240 $sql .= $sqlSet;
1241 }
1242
1243 if ( $conds !== [] && $conds !== '*' ) {
1244 $conds = $this->wrapConditionsForWhere( $table, $conds );
1245 $sql .= ' WHERE ' . $this->makeList( $conds, LIST_AND );
1246 }
1247
1248 $this->mLastResult = $stmt = oci_parse( $this->mConn, $sql );
1249 if ( $stmt === false ) {
1250 $e = oci_error( $this->mConn );
1251 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
1252
1253 return false;
1254 }
1255 foreach ( $values as $col => &$val ) {
1256 $col_info = $this->fieldInfoMulti( $table, $col );
1257 $col_type = $col_info != false ? $col_info->type() : 'CONSTANT';
1258
1259 if ( $val === null ) {
1260 // do nothing ... null was inserted in statement creation
1261 } elseif ( $col_type != 'BLOB' && $col_type != 'CLOB' ) {
1262 if ( is_object( $val ) ) {
1263 $val = $val->getData();
1264 }
1265
1266 if ( preg_match( '/^timestamp.*/i', $col_type ) == 1 && strtolower( $val ) == 'infinity' ) {
1267 $val = '31-12-2030 12:00:00.000000';
1268 }
1269
1270 $val = ( $wgContLang != null ) ? $wgContLang->checkTitleEncoding( $val ) : $val;
1271 if ( oci_bind_by_name( $stmt, ":$col", $val ) === false ) {
1272 $e = oci_error( $stmt );
1273 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
1274
1275 return false;
1276 }
1277 } else {
1279 $lob[$col] = oci_new_descriptor( $this->mConn, OCI_D_LOB );
1280 if ( $lob[$col] === false ) {
1281 $e = oci_error( $stmt );
1282 throw new DBUnexpectedError( $this, "Cannot create LOB descriptor: " . $e['message'] );
1283 }
1284
1285 if ( is_object( $val ) ) {
1286 $val = $val->getData();
1287 }
1288
1289 if ( $col_type == 'BLOB' ) {
1290 $lob[$col]->writeTemporary( $val );
1291 oci_bind_by_name( $stmt, ":$col", $lob[$col], -1, SQLT_BLOB );
1292 } else {
1293 $lob[$col]->writeTemporary( $val );
1294 oci_bind_by_name( $stmt, ":$col", $lob[$col], -1, OCI_B_CLOB );
1295 }
1296 }
1297 }
1298
1299 MediaWiki\suppressWarnings();
1300
1301 if ( oci_execute( $stmt, $this->execFlags() ) === false ) {
1302 $e = oci_error( $stmt );
1303 if ( !$this->ignoreDupValOnIndex || $e['code'] != '1' ) {
1304 $this->reportQueryError( $e['message'], $e['code'], $sql, __METHOD__ );
1305
1306 return false;
1307 } else {
1308 $this->mAffectedRows = oci_num_rows( $stmt );
1309 }
1310 } else {
1311 $this->mAffectedRows = oci_num_rows( $stmt );
1312 }
1313
1314 MediaWiki\restoreWarnings();
1315
1316 if ( isset( $lob ) ) {
1317 foreach ( $lob as $lob_v ) {
1318 $lob_v->free();
1319 }
1320 }
1321
1322 if ( !$this->mTrxLevel ) {
1323 oci_commit( $this->mConn );
1324 }
1325
1326 return oci_free_statement( $stmt );
1327 }
1328
1329 function bitNot( $field ) {
1330 // expecting bit-fields smaller than 4bytes
1331 return 'BITNOT(' . $field . ')';
1332 }
1333
1334 function bitAnd( $fieldLeft, $fieldRight ) {
1335 return 'BITAND(' . $fieldLeft . ', ' . $fieldRight . ')';
1336 }
1337
1338 function bitOr( $fieldLeft, $fieldRight ) {
1339 return 'BITOR(' . $fieldLeft . ', ' . $fieldRight . ')';
1340 }
1341
1342 function getDBname() {
1343 return $this->mDBname;
1344 }
1345
1346 function getServer() {
1347 return $this->mServer;
1348 }
1349
1350 public function buildGroupConcatField(
1351 $delim, $table, $field, $conds = '', $join_conds = []
1352 ) {
1353 $fld = "LISTAGG($field," . $this->addQuotes( $delim ) . ") WITHIN GROUP (ORDER BY $field)";
1354
1355 return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')';
1356 }
1357
1363 public function buildStringCast( $field ) {
1364 return 'CAST ( ' . $field . ' AS VARCHAR2 )';
1365 }
1366
1367 public function getInfinity() {
1368 return '31-12-2030 12:00:00.000000';
1369 }
1370}
and give any other recipients of the Program a copy of this License along with the Program You may charge a fee for the physical act of transferring a and you may at your option offer warranty protection in exchange for a fee You may modify your copy or copies of the Program or any portion of thus forming a work based on the and copy and distribute such modifications or work under the terms of Section provided that you also meet all of these that in whole or in part contains or is derived from the Program or any part to be licensed as a whole at no charge to all third parties under the terms of this License c If the modified program normally reads commands interactively when you must cause when started running for such interactive use in the most ordinary way
Definition COPYING.txt:105
$wgDBprefix
Table name prefix.
$wgDBOracleDRCP
Set true to enable Oracle DCRP (supported from 11gR1 onward)
wfDebug( $text, $dest='all', array $context=[])
Sends a line to the debug log if enabled or, optionally, to a comment in output.
wfTimestamp( $outputtype=TS_UNIX, $ts=0)
Get a timestamp string in one of various formats.
as see the revision history and available at free of to any person obtaining a copy of this software and associated documentation to deal in the Software without including without limitation the rights to and or sell copies of the and to permit persons to whom the Software is furnished to do subject to the following WITHOUT WARRANTY OF ANY EXPRESS OR INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY DAMAGES OR OTHER WHETHER IN AN ACTION OF TORT OR ARISING FROM
if(!defined( 'MEDIAWIKI')) $fname
This file is not a valid entry point, perform no further processing unless MEDIAWIKI is defined.
Definition Setup.php:36
$line
Definition cdb.php:58
duplicateTableStructure( $oldName, $newName, $temporary=false, $fname=__METHOD__)
Creates a new table with structure copied from existing table.
doBegin( $fname=__METHOD__)
Issues the BEGIN command to the database server.
lastErrno()
Get the last error number.
addIdentifierQuotes( $s)
Quotes an identifier using backticks or "double quotes" depending on the database type.
bitAnd( $fieldLeft, $fieldRight)
wrapFieldForWhere( $table, &$col, &$val)
indexExists( $table, $index, $fname=__METHOD__)
Query whether a given index exists.
indexInfo( $table, $index, $fname=__METHOD__)
Returns information about an index If errors are explicitly ignored, returns NULL on failure.
bitOr( $fieldLeft, $fieldRight)
buildGroupConcatField( $delim, $table, $field, $conds='', $join_conds=[])
Build a GROUP_CONCAT or equivalent statement for a query.
getType()
Get the type of the DBMS, as it appears in $wgDBtype.
selectDB( $db)
Change the current database.
doRollback( $fname=__METHOD__)
Issues the ROLLBACK command to the database server.
strencode( $s)
Wrapper for addslashes()
affectedRows()
Get the number of rows affected by the last write query.
resource $mLastResult
listTables( $prefix=null, $fname=__METHOD__)
List all tables on the database.
makeSelectOptions( $options)
Returns an optional USE INDEX clause to go after the table, and a string to go at the end of the quer...
fieldInfoMulti( $table, $field)
Function translates mysql_fetch_field() functionality on ORACLE.
fieldInfo( $table, $field)
textFieldSize( $table, $field)
Returns the size of a text field, or -1 for "unlimited".
implicitOrderby()
Returns true if this database does an implicit order by when the column has an index For example: SEL...
encodeBlob( $b)
Some DBMSs have a special format for inserting into blob fields, they don't allow simple quoted strin...
int $mAffectedRows
The number of rows affected as an integer.
addQuotes( $s)
Adds quotes and backslashes.
doCommit( $fname=__METHOD__)
Issues the COMMIT command to the database server.
queryIgnore( $sql, $fname='')
getSequenceData( $table)
Return sequence_name if table has a sequence.
lastError()
Get a description of the last error.
getDBname()
Get the current DB name.
bool array $sequenceData
decodeBlob( $b)
Some DBMSs return a special placeholder object representing blob fields in result objects.
insertOneRow( $table, $row, $fname)
string $defaultCharset
Character set for Oracle database.
__destruct()
Run a few simple sanity checks and close dangling connections.
dropTable( $tableName, $fName=__METHOD__)
Delete a table.
implicitGroupby()
Returns true if this database does an implicit sort when doing GROUP BY.
insertId()
Get the inserted value of an auto-increment row.
closeConnection()
Closes a database connection, if it is open Returns success, true if already closed.
limitResult( $sql, $limit, $offset=false)
Construct a LIMIT query with optional offset.
sourceStream( $fp, callable $lineCallback=null, callable $resultCallback=null, $fname=__METHOD__, callable $inputCallback=null)
Read and execute commands from an open file handle.
getServer()
Get the server hostname or IP address.
wasDeadlock()
Determines if the last failure was due to a deadlock.
tableExists( $table, $fname=__METHOD__)
Query whether a given table exists (in the given schema, or the default mw one if not given)
dataSeek( $res, $row)
tableNameInternal( $name)
update( $table, $values, $conds, $fname=__METHOD__, $options=[])
indexUnique( $table, $index, $fname=__METHOD__)
fieldBindStatement( $table, $col, &$val, $includeCol=false)
insert( $table, $a, $fname=__METHOD__, $options=[])
INSERT wrapper, inserts an array into a table.
timestamp( $ts=0)
Convert a timestamp in one of the formats accepted by wfTimestamp() to the format used for inserting ...
doQuery( $sql)
The DBMS-dependent part of query()
selectRow( $table, $vars, $conds, $fname=__METHOD__, $options=[], $join_conds=[])
Single row SELECT wrapper.
wrapConditionsForWhere( $table, $conds, $parentCol=null)
open( $server, $user, $password, $dbName)
Usually aborts on failure.
fieldName( $stmt, $n)
Get a field name in a result object.
freeResult( $res)
Frees resources associated with the LOB descriptor.
__construct(array $p)
Constructor and database handle and attempt to connect to the DB server.
unionQueries( $sqls, $all)
Construct a UNION query This is used for providing overload point for other DB abstractions not compa...
aggregateValue( $valuedata, $valuename='value')
Return aggregated value function call.
nativeInsertSelect( $destTable, $srcTable, $varMap, $conds, $fname=__METHOD__, $insertOptions=[], $selectOptions=[], $selectJoinConds=[])
Native server-side implementation of insertSelect() for situations where we don't want to select ever...
isQuotedIdentifier( $s)
Returns if the given identifier looks quoted or not according to the database convention for quoting ...
getInfinity()
Find out when 'infinity' is.
static getLocalInstance( $ts=false)
Get a timestamp instance in the server local timezone ($wgLocaltimezone)
The oci8 extension is fairly weak and doesn't support oci_num_rows, among other things.
Definition ORAResult.php:11
static isUtf8( $value)
Test whether a string is valid UTF-8.
Relational database abstraction object.
Definition Database.php:45
resource null $mConn
Database connection.
Definition Database.php:92
setFlag( $flag, $remember=self::REMEMBER_NOTHING)
Set a flag for this connection.
Definition Database.php:623
getFlag( $flag)
Returns a boolean whether the flag $flag is set for this connection.
Definition Database.php:650
close()
Closes a database connection.
Definition Database.php:753
Result wrapper for grabbing data queried from an IDatabase object.
$res
Definition database.txt:21
For a write query
Definition database.txt:26
We use the convention $dbr for read and $dbw for write to help you keep track of whether the database object is a the world will explode Or to be a subsequent write query which succeeded on the master may fail when replicated to the slave due to a unique key collision Replication on the slave will stop and it may take hours to repair the database and get it back online Setting read_only in my cnf on the slave will avoid this but given the dire we prefer to have as many checks as possible We provide a but the wrapper functions like please read the documentation for tableName() and addQuotes(). You will need both of them. ------------------------------------------------------------------------ Basic query optimisation ------------------------------------------------------------------------ MediaWiki developers who need to write DB queries should have some understanding of databases and the performance issues associated with them. Patches containing unacceptably slow features will not be accepted. Unindexed queries are generally not welcome in MediaWiki
this class mediates it Skin Encapsulates a look and feel for the wiki All of the functions that render HTML and make choices about how to render it are here and are called from various other places when and is meant to be subclassed with other skins that may override some of its functions The User object contains a reference to a and so rather than having a global skin object we just rely on the global User and get the skin with $wgUser and also has some character encoding functions and other locale stuff The current user interface language is instantiated as and the local content language as $wgContLang
Definition design.txt:57
static configuration should be added through ResourceLoaderGetConfigVars instead & $vars
Definition hooks.txt:2198
in this case you re responsible for computing and outputting the entire conflict i e
Definition hooks.txt:1411
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped & $options
Definition hooks.txt:1971
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped noclasses & $ret
Definition hooks.txt:1975
processing should stop and the error should be shown to the user * false
Definition hooks.txt:187
please add to it if you re going to add events to the MediaWiki code where normally authentication against an external auth plugin would be creating a local account $user
Definition hooks.txt:247
returning false will NOT prevent logging $e
Definition hooks.txt:2146
const LIST_AND
Definition Defines.php:44
This document describes the state of Postgres support in and is fairly well maintained The main code is very well while extensions are very hit and miss it is probably the most supported database after MySQL Much of the work in making MediaWiki database agnostic came about through the work of creating Postgres as and are nearing end of but without copying over all the usage comments General notes on the but these can almost always be programmed around *Although Postgres has a true BOOLEAN boolean columns are always mapped to as the code does not always treat the column as a and VARBINARY columns should simply be TEXT The only exception is when VARBINARY is used to store true binary such as the math_inputhash column
Definition postgres.txt:44
const DBO_DDLMODE
Definition defines.php:16
const DBO_SYSDBA
Definition defines.php:15
const DBO_DEFAULT
Definition defines.php:13
const DBO_PERSISTENT
Definition defines.php:14