1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
<?php
/**
* Oracle-specific updater.
*
* @file
* @ingroup Deployment
*/
/**
* Class for handling updates to Oracle databases.
*
* @ingroup Deployment
* @since 1.17
*/
class OracleUpdater extends DatabaseUpdater {
protected function getCoreUpdateList() {
return array(
// 1.16
array( 'doNamespaceDefaults' ),
array( 'doFKRenameDeferr' ),
array( 'doFunctions17' ),
array( 'doSchemaUpgrade17' ),
array( 'doInsertPage0' ),
);
}
/**
* MySQL uses datatype defaults for NULL inserted into NOT NULL fields
* In namespace case that results into insert of 0 which is default namespace
* Oracle inserts NULL, so namespace fields should have a default value
*/
protected function doNamespaceDefaults() {
$this->output( "Altering namespace fields with default value ... " );
$meta = $this->db->fieldInfo( 'page', 'page_namespace' );
if ( $meta->defaultValue() != null ) {
$this->output( "defaults seem to present on namespace fields\n" );
return;
}
$this->applyPatch( 'patch_namespace_defaults.sql', false );
$this->output( "ok\n" );
}
/**
* Uniform FK names + deferrable state
*/
protected function doFKRenameDeferr() {
$this->output( "Altering foreign keys ... " );
$meta = $this->db->query( 'SELECT COUNT(*) cnt FROM user_constraints WHERE constraint_type = \'R\' AND deferrable = \'DEFERRABLE\'' );
$row = $meta->fetchRow();
if ( $row && $row['cnt'] > 0 ) {
$this->output( "at least one FK is deferrable, considering up to date\n" );
return;
}
$this->applyPatch( 'patch_fk_rename_deferred.sql', false );
$this->output( "ok\n" );
}
/**
* Recreate functions to 17 schema layout
*/
protected function doFunctions17() {
$this->output( "Recreating functions ... " );
$this->applyPatch( 'patch_create_17_functions.sql', false );
$this->output( "ok\n" );
}
/**
* Schema upgrade 16->17
* there are no incremental patches prior to this
*/
protected function doSchemaUpgrade17() {
$this->output( "Updating schema to 17 ... " );
// check if iwlinks table exists which was added in 1.17
if ( $this->db->tableExists( $this->db->tableName( 'iwlinks' ) ) ) {
$this->output( "schema seem to be up to date.\n" );
return;
}
$this->applyPatch( 'patch_16_17_schema_changes.sql', false );
$this->output( "ok\n" );
}
/**
* Insert page (page_id = 0) to prevent FK constraint violation
*/
protected function doInsertPage0() {
$this->output( "Inserting page 0 if missing ... " );
$row = array(
'page_id' => 0,
'page_namespace' => 0,
'page_title' => ' ',
'page_counter' => 0,
'page_is_redirect' => 0,
'page_is_new' => 0,
'page_random' => 0,
'page_touched' => $this->db->timestamp(),
'page_latest' => 0,
'page_len' => 0
);
$this->db->insert( 'page', $row, 'OracleUpdater:doInserPage0', array( 'IGNORE' ) );
$this->output( "ok\n" );
}
/**
* Overload: after this action field info table has to be rebuilt
*/
public function doUpdates( $what = array( 'core', 'extensions', 'purge' ) ) {
parent::doUpdates( $what );
$this->db->query( 'BEGIN fill_wiki_info; END;' );
}
}
|
