MediaWiki  REL1_31
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  // 1.29
123  [ 'addField', 'externallinks', 'el_index_60', 'patch-externallinks-el_index_60.sql' ],
124  [ 'addField', 'user_groups', 'ug_expiry', 'patch-user_groups-ug_expiry.sql' ],
125 
126  // 1.30
127  [ 'doAutoIncrementTriggers' ],
128  [ 'addIndex', 'site_stats', 'PRIMARY', 'patch-site_stats-pk.sql' ],
129 
130  // Should have been in 1.30
131  [ 'addTable', 'comment', 'patch-comment-table.sql' ],
132  // This field was added in 1.31, but is put here so it can be used by 'migrateComments'
133  [ 'addField', 'image', 'img_description_id', 'patch-image-img_description_id.sql' ],
134  // Should have been in 1.30
135  [ 'migrateComments' ],
136 
137  // 1.31
138  [ 'addTable', 'slots', 'patch-slots.sql' ],
139  [ 'addField', 'slots', 'slot_origin', 'patch-slot-origin.sql' ],
140  [ 'addTable', 'content', 'patch-content.sql' ],
141  [ 'addTable', 'slot_roles', 'patch-slot_roles.sql' ],
142  [ 'addTable', 'content_models', 'patch-content_models.sql' ],
143  [ 'migrateArchiveText' ],
144  [ 'addTable', 'actor', 'patch-actor-table.sql' ],
145  [ 'migrateActors' ],
146  [ 'modifyTable', 'site_stats', 'patch-site_stats-modify.sql' ],
147  [ 'populateArchiveRevId' ],
148  [ 'addIndex', 'recentchanges', 'rc_namespace_title_timestamp',
149  'patch-recentchanges-nttindex.sql' ],
150 
151  // KEEP THIS AT THE BOTTOM!!
152  [ 'doRebuildDuplicateFunction' ],
153 
154  ];
155  }
156 
162  protected function doNamespaceDefaults() {
163  $meta = $this->db->fieldInfo( 'page', 'page_namespace' );
164  if ( $meta->defaultValue() != null ) {
165  return;
166  }
167 
168  $this->applyPatch(
169  'patch_namespace_defaults.sql',
170  false,
171  'Altering namespace fields with default value'
172  );
173  }
174 
178  protected function doFKRenameDeferr() {
179  $meta = $this->db->query( '
180  SELECT COUNT(*) cnt
181  FROM user_constraints
182  WHERE constraint_type = \'R\' AND deferrable = \'DEFERRABLE\''
183  );
184  $row = $meta->fetchRow();
185  if ( $row && $row['cnt'] > 0 ) {
186  return;
187  }
188 
189  $this->applyPatch( 'patch_fk_rename_deferred.sql', false, "Altering foreign keys ... " );
190  }
191 
195  protected function doFunctions17() {
196  $this->applyPatch( 'patch_create_17_functions.sql', false, "Recreating functions" );
197  }
198 
203  protected function doSchemaUpgrade17() {
204  // check if iwlinks table exists which was added in 1.17
205  if ( $this->db->tableExists( 'iwlinks' ) ) {
206  return;
207  }
208  $this->applyPatch( 'patch_16_17_schema_changes.sql', false, "Updating schema to 17" );
209  }
210 
214  protected function doInsertPage0() {
215  $this->output( "Inserting page 0 if missing ... " );
216  $row = [
217  'page_id' => 0,
218  'page_namespace' => 0,
219  'page_title' => ' ',
220  'page_is_redirect' => 0,
221  'page_is_new' => 0,
222  'page_random' => 0,
223  'page_touched' => $this->db->timestamp(),
224  'page_latest' => 0,
225  'page_len' => 0
226  ];
227  $this->db->insert( 'page', $row, 'OracleUpdater:doInserPage0', [ 'IGNORE' ] );
228  $this->output( "ok\n" );
229  }
230 
235  protected function doRemoveNotNullEmptyDefaults() {
236  $meta = $this->db->fieldInfo( 'categorylinks', 'cl_sortkey_prefix' );
237  if ( $meta->isNullable() ) {
238  return;
239  }
240  $this->applyPatch(
241  'patch_remove_not_null_empty_defs.sql',
242  false,
243  'Removing not null empty constraints'
244  );
245  }
246 
247  protected function doRemoveNotNullEmptyDefaults2() {
248  $meta = $this->db->fieldInfo( 'ipblocks', 'ipb_by_text' );
249  if ( $meta->isNullable() ) {
250  return;
251  }
252  $this->applyPatch(
253  'patch_remove_not_null_empty_defs2.sql',
254  false,
255  'Removing not null empty constraints'
256  );
257  }
258 
263  protected function doRecentchangesFK2Cascade() {
264  $meta = $this->db->query( 'SELECT 1 FROM all_constraints WHERE owner = \'' .
265  strtoupper( $this->db->getDBname() ) .
266  '\' AND constraint_name = \'' .
267  $this->db->tablePrefix() .
268  'RECENTCHANGES_FK2\' AND delete_rule = \'CASCADE\''
269  );
270  $row = $meta->fetchRow();
271  if ( $row ) {
272  return;
273  }
274 
275  $this->applyPatch( 'patch_recentchanges_fk2_cascade.sql', false, "Altering RECENTCHANGES_FK2" );
276  }
277 
281  protected function doPageRestrictionsPKUKFix() {
282  $this->output( "Altering PAGE_RESTRICTIONS keys ... " );
283 
284  $meta = $this->db->query( 'SELECT column_name FROM all_cons_columns WHERE owner = \'' .
285  strtoupper( $this->db->getDBname() ) .
286  '\' AND constraint_name = \'' .
287  $this->db->tablePrefix() .
288  'PAGE_RESTRICTIONS_PK\' AND rownum = 1'
289  );
290  $row = $meta->fetchRow();
291  if ( $row['column_name'] == 'PR_ID' ) {
292  $this->output( "seems to be up to date.\n" );
293 
294  return;
295  }
296 
297  $this->applyPatch( 'patch-page_restrictions_pkuk_fix.sql', false );
298  $this->output( "ok\n" );
299  }
300 
304  protected function doAutoIncrementTriggers() {
305  $this->output( "Adding auto-increment triggers ... " );
306 
307  $meta = $this->db->query( 'SELECT trigger_name FROM user_triggers WHERE table_owner = \'' .
308  strtoupper( $this->db->getDBname() ) .
309  '\' AND trigger_name = \'' .
310  $this->db->tablePrefix() .
311  'PAGE_DEFAULT_PAGE_ID\''
312  );
313  $row = $meta->fetchRow();
314  if ( $row['column_name'] ) {
315  $this->output( "seems to be up to date.\n" );
316 
317  return;
318  }
319 
320  $this->applyPatch( 'patch-auto_increment_triggers.sql', false );
321 
322  $this->output( "ok\n" );
323  }
324 
328  protected function doRebuildDuplicateFunction() {
329  $this->applyPatch( 'patch_rebuild_dupfunc.sql', false, "Rebuilding duplicate function" );
330  }
331 
337  public function doUpdates( array $what = [ 'core', 'extensions', 'purge', 'stats' ] ) {
338  parent::doUpdates( $what );
339 
340  $this->db->query( 'BEGIN fill_wiki_info; END;' );
341  }
342 
346  public function purgeCache() {
347  # We can't guarantee that the user will be able to use TRUNCATE,
348  # but we know that DELETE is available to us
349  $this->output( "Purging caches..." );
350  $this->db->delete( '/*Q*/' . $this->db->tableName( 'objectcache' ), '*', __METHOD__ );
351  $this->output( "done.\n" );
352  }
353 }
DatabaseUpdater\output
output( $str)
Output some text.
Definition: DatabaseUpdater.php:212
OracleUpdater\doFunctions17
doFunctions17()
Recreate functions to 17 schema layout.
Definition: OracleUpdater.php:195
OracleUpdater\purgeCache
purgeCache()
Overload: because of the DDL_MODE tablename escaping is a bit dodgy.
Definition: OracleUpdater.php:346
DatabaseUpdater\applyPatch
applyPatch( $path, $isFullPath=false, $msg=null)
Applies a SQL patch.
Definition: DatabaseUpdater.php:665
OracleUpdater\doFKRenameDeferr
doFKRenameDeferr()
Uniform FK names + deferrable state.
Definition: OracleUpdater.php:178
array
the array() calling protocol came about after MediaWiki 1.4rc1.
DatabaseUpdater
Class for handling database updates.
Definition: DatabaseUpdater.php:36
OracleUpdater\doPageRestrictionsPKUKFix
doPageRestrictionsPKUKFix()
Fixed wrong PK, UK definition.
Definition: OracleUpdater.php:281
OracleUpdater\doRecentchangesFK2Cascade
doRecentchangesFK2Cascade()
Removed forcing of invalid state on recentchanges_fk2.
Definition: OracleUpdater.php:263
php
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:37
OracleUpdater\doAutoIncrementTriggers
doAutoIncrementTriggers()
Add auto-increment triggers.
Definition: OracleUpdater.php:304
OracleUpdater
Class for handling updates to Oracle databases.
Definition: OracleUpdater.php:30
DatabaseOracle
Definition: DatabaseOracle.php:33
OracleUpdater\doInsertPage0
doInsertPage0()
Insert page (page_id = 0) to prevent FK constraint violation.
Definition: OracleUpdater.php:214
OracleUpdater\doRemoveNotNullEmptyDefaults
doRemoveNotNullEmptyDefaults()
Remove DEFAULT '' NOT NULL constraints from fields as '' is internally converted to NULL in Oracle.
Definition: OracleUpdater.php:235
OracleUpdater\doSchemaUpgrade17
doSchemaUpgrade17()
Schema upgrade 16->17 there are no incremental patches prior to this.
Definition: OracleUpdater.php:203
OracleUpdater\doRemoveNotNullEmptyDefaults2
doRemoveNotNullEmptyDefaults2()
Definition: OracleUpdater.php:247
OracleUpdater\$db
DatabaseOracle $db
Handle to the database subclass.
Definition: OracleUpdater.php:37
OracleUpdater\getCoreUpdateList
getCoreUpdateList()
Get an array of updates to perform on the database.
Definition: OracleUpdater.php:39
OracleUpdater\doNamespaceDefaults
doNamespaceDefaults()
MySQL uses datatype defaults for NULL inserted into NOT NULL fields In namespace case that results in...
Definition: OracleUpdater.php:162
OracleUpdater\doRebuildDuplicateFunction
doRebuildDuplicateFunction()
rebuilding of the function that duplicates tables for tests
Definition: OracleUpdater.php:328
OracleUpdater\doUpdates
doUpdates(array $what=[ 'core', 'extensions', 'purge', 'stats'])
Overload: after this action field info table has to be rebuilt.
Definition: OracleUpdater.php:337