MediaWiki  1.28.0
OracleUpdater.php
Go to the documentation of this file.
1 <?php
31 
37  protected $db;
38 
39  protected function getCoreUpdateList() {
40  return [
41  [ 'disableContentHandlerUseDB' ],
42 
43  // 1.17
44  [ 'doNamespaceDefaults' ],
45  [ 'doFKRenameDeferr' ],
46  [ 'doFunctions17' ],
47  [ 'doSchemaUpgrade17' ],
48  [ 'doInsertPage0' ],
49  [ 'doRemoveNotNullEmptyDefaults' ],
50  [ 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ],
51 
52  // 1.18
53  [ 'addIndex', 'user', 'i02', 'patch-user_email_index.sql' ],
54  [ 'modifyField', 'user_properties', 'up_property', 'patch-up_property.sql' ],
55  [ 'addTable', 'uploadstash', 'patch-uploadstash.sql' ],
56  [ 'doRecentchangesFK2Cascade' ],
57 
58  // 1.19
59  [ 'addIndex', 'logging', 'i05', 'patch-logging_type_action_index.sql' ],
60  [ 'addField', 'revision', 'rev_sha1', 'patch-rev_sha1_field.sql' ],
61  [ 'addField', 'archive', 'ar_sha1', 'patch-ar_sha1_field.sql' ],
62  [ 'doRemoveNotNullEmptyDefaults2' ],
63  [ 'addIndex', 'page', 'i03', 'patch-page_redirect_namespace_len.sql' ],
64  [ 'addField', 'uploadstash', 'us_chunk_inx', 'patch-us_chunk_inx_field.sql' ],
65  [ 'addField', 'job', 'job_timestamp', 'patch-job_timestamp_field.sql' ],
66  [ 'addIndex', 'job', 'i02', 'patch-job_timestamp_index.sql' ],
67  [ 'doPageRestrictionsPKUKFix' ],
68 
69  // 1.20
70  [ 'addIndex', 'ipblocks', 'i05', 'patch-ipblocks_i05_index.sql' ],
71  [ 'addIndex', 'revision', 'i05', 'patch-revision_i05_index.sql' ],
72  [ 'dropField', 'category', 'cat_hidden', 'patch-cat_hidden.sql' ],
73 
74  // 1.21
75  [ 'addField', 'revision', 'rev_content_format',
76  'patch-revision-rev_content_format.sql' ],
77  [ 'addField', 'revision', 'rev_content_model',
78  'patch-revision-rev_content_model.sql' ],
79  [ 'addField', 'archive', 'ar_content_format', 'patch-archive-ar_content_format.sql' ],
80  [ 'addField', 'archive', 'ar_content_model', 'patch-archive-ar_content_model.sql' ],
81  [ 'addField', 'archive', 'ar_id', 'patch-archive-ar_id.sql' ],
82  [ 'addField', 'externallinks', 'el_id', 'patch-externallinks-el_id.sql' ],
83  [ 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ],
84  [ 'enableContentHandlerUseDB' ],
85  [ 'dropField', 'site_stats', 'ss_admins', 'patch-ss_admins.sql' ],
86  [ 'dropField', 'recentchanges', 'rc_moved_to_title', 'patch-rc_moved.sql' ],
87  [ 'addTable', 'sites', 'patch-sites.sql' ],
88  [ 'addField', 'filearchive', 'fa_sha1', 'patch-fa_sha1.sql' ],
89  [ 'addField', 'job', 'job_token', 'patch-job_token.sql' ],
90  [ 'addField', 'job', 'job_attempts', 'patch-job_attempts.sql' ],
91  [ 'addField', 'uploadstash', 'us_props', 'patch-uploadstash-us_props.sql' ],
92  [ 'modifyField', 'user_groups', 'ug_group', 'patch-ug_group-length-increase-255.sql' ],
93  [ 'modifyField', 'user_former_groups', 'ufg_group',
94  'patch-ufg_group-length-increase-255.sql' ],
95 
96  // 1.23
97  [ 'addIndex', 'logging', 'i06', 'patch-logging_user_text_type_time_index.sql' ],
98  [ 'addIndex', 'logging', 'i07', 'patch-logging_user_text_time_index.sql' ],
99  [ 'addField', 'user', 'user_password_expires', 'patch-user_password_expire.sql' ],
100  [ 'addField', 'page', 'page_links_updated', 'patch-page_links_updated.sql' ],
101  [ 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ],
102 
103  // 1.24
104  [ 'addField', 'page', 'page_lang', 'patch-page-page_lang.sql' ],
105 
106  // 1.25
107  [ 'dropTable', 'hitcounter' ],
108  [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ],
109  [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ],
110 
111  // 1.27
112  [ 'dropTable', 'msg_resource_links' ],
113  [ 'dropTable', 'msg_resource' ],
114  [ 'addField', 'watchlist', 'wl_id', 'patch-watchlist-wl_id.sql' ],
115 
116  // 1.28
117  [ 'addIndex', 'recentchanges', 'rc_name_type_patrolled_timestamp',
118  'patch-add-rc_name_type_patrolled_timestamp_index.sql' ],
119  [ 'addField', 'change_tag', 'ct_id', 'patch-change_tag-ct_id.sql' ],
120  [ 'addField', 'tag_summary', 'ts_id', 'patch-tag_summary-ts_id.sql' ],
121 
122  // KEEP THIS AT THE BOTTOM!!
123  [ 'doRebuildDuplicateFunction' ],
124 
125  ];
126  }
127 
133  protected function doNamespaceDefaults() {
134  $meta = $this->db->fieldInfo( 'page', 'page_namespace' );
135  if ( $meta->defaultValue() != null ) {
136  return;
137  }
138 
139  $this->applyPatch(
140  'patch_namespace_defaults.sql',
141  false,
142  'Altering namespace fields with default value'
143  );
144  }
145 
149  protected function doFKRenameDeferr() {
150  $meta = $this->db->query( '
151  SELECT COUNT(*) cnt
152  FROM user_constraints
153  WHERE constraint_type = \'R\' AND deferrable = \'DEFERRABLE\''
154  );
155  $row = $meta->fetchRow();
156  if ( $row && $row['cnt'] > 0 ) {
157  return;
158  }
159 
160  $this->applyPatch( 'patch_fk_rename_deferred.sql', false, "Altering foreign keys ... " );
161  }
162 
166  protected function doFunctions17() {
167  $this->applyPatch( 'patch_create_17_functions.sql', false, "Recreating functions" );
168  }
169 
174  protected function doSchemaUpgrade17() {
175  // check if iwlinks table exists which was added in 1.17
176  if ( $this->db->tableExists( 'iwlinks' ) ) {
177  return;
178  }
179  $this->applyPatch( 'patch_16_17_schema_changes.sql', false, "Updating schema to 17" );
180  }
181 
185  protected function doInsertPage0() {
186  $this->output( "Inserting page 0 if missing ... " );
187  $row = [
188  'page_id' => 0,
189  'page_namespace' => 0,
190  'page_title' => ' ',
191  'page_is_redirect' => 0,
192  'page_is_new' => 0,
193  'page_random' => 0,
194  'page_touched' => $this->db->timestamp(),
195  'page_latest' => 0,
196  'page_len' => 0
197  ];
198  $this->db->insert( 'page', $row, 'OracleUpdater:doInserPage0', [ 'IGNORE' ] );
199  $this->output( "ok\n" );
200  }
201 
206  protected function doRemoveNotNullEmptyDefaults() {
207  $meta = $this->db->fieldInfo( 'categorylinks', 'cl_sortkey_prefix' );
208  if ( $meta->isNullable() ) {
209  return;
210  }
211  $this->applyPatch(
212  'patch_remove_not_null_empty_defs.sql',
213  false,
214  'Removing not null empty constraints'
215  );
216  }
217 
218  protected function doRemoveNotNullEmptyDefaults2() {
219  $meta = $this->db->fieldInfo( 'ipblocks', 'ipb_by_text' );
220  if ( $meta->isNullable() ) {
221  return;
222  }
223  $this->applyPatch(
224  'patch_remove_not_null_empty_defs2.sql',
225  false,
226  'Removing not null empty constraints'
227  );
228  }
229 
234  protected function doRecentchangesFK2Cascade() {
235  $meta = $this->db->query( 'SELECT 1 FROM all_constraints WHERE owner = \'' .
236  strtoupper( $this->db->getDBname() ) .
237  '\' AND constraint_name = \'' .
238  $this->db->tablePrefix() .
239  'RECENTCHANGES_FK2\' AND delete_rule = \'CASCADE\''
240  );
241  $row = $meta->fetchRow();
242  if ( $row ) {
243  return;
244  }
245 
246  $this->applyPatch( 'patch_recentchanges_fk2_cascade.sql', false, "Altering RECENTCHANGES_FK2" );
247  }
248 
252  protected function doPageRestrictionsPKUKFix() {
253  $this->output( "Altering PAGE_RESTRICTIONS keys ... " );
254 
255  $meta = $this->db->query( 'SELECT column_name FROM all_cons_columns WHERE owner = \'' .
256  strtoupper( $this->db->getDBname() ) .
257  '\' AND constraint_name = \'' .
258  $this->db->tablePrefix() .
259  'PAGE_RESTRICTIONS_PK\' AND rownum = 1'
260  );
261  $row = $meta->fetchRow();
262  if ( $row['column_name'] == 'PR_ID' ) {
263  $this->output( "seems to be up to date.\n" );
264 
265  return;
266  }
267 
268  $this->applyPatch( 'patch-page_restrictions_pkuk_fix.sql', false );
269  $this->output( "ok\n" );
270  }
271 
275  protected function doRebuildDuplicateFunction() {
276  $this->applyPatch( 'patch_rebuild_dupfunc.sql', false, "Rebuilding duplicate function" );
277  }
278 
284  public function doUpdates( $what = [ 'core', 'extensions', 'purge', 'stats' ] ) {
285  parent::doUpdates( $what );
286 
287  $this->db->query( 'BEGIN fill_wiki_info; END;' );
288  }
289 
293  public function purgeCache() {
294  # We can't guarantee that the user will be able to use TRUNCATE,
295  # but we know that DELETE is available to us
296  $this->output( "Purging caches..." );
297  $this->db->delete( '/*Q*/' . $this->db->tableName( 'objectcache' ), '*', __METHOD__ );
298  $this->output( "done.\n" );
299  }
300 }
doRecentchangesFK2Cascade()
Removed forcing of invalid state on recentchanges_fk2.
applyPatch($path, $isFullPath=false, $msg=null)
Applies a SQL patch.
Class for handling database updates.
doSchemaUpgrade17()
Schema upgrade 16->17 there are no incremental patches prior to this.
doRemoveNotNullEmptyDefaults2()
output($str)
Output some text.
doRebuildDuplicateFunction()
rebuilding of the function that duplicates tables for tests
doFKRenameDeferr()
Uniform FK names + deferrable state.
doInsertPage0()
Insert page (page_id = 0) to prevent FK constraint violation.
DatabaseOracle $db
Handle to the database subclass.
doFunctions17()
Recreate functions to 17 schema layout.
doRemoveNotNullEmptyDefaults()
Remove DEFAULT '' NOT NULL constraints from fields as '' is internally converted to NULL in Oracle...
doNamespaceDefaults()
MySQL uses datatype defaults for NULL inserted into NOT NULL fields In namespace case that results in...
Class for handling updates to Oracle databases.
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
Definition: injection.txt:35
doPageRestrictionsPKUKFix()
Fixed wrong PK, UK definition.
purgeCache()
Overload: because of the DDL_MODE tablename escaping is a bit dodgy.
doUpdates($what=[ 'core', 'extensions', 'purge', 'stats'])
Overload: after this action field info table has to be rebuilt.