Passed
Push — master ( edcd19...7b8e38 )
by Felipe
05:02
created

DeadlockTest   A

Complexity

Total Complexity 6

Size/Duplication

Total Lines 378
Duplicated Lines 0 %

Importance

Changes 0
Metric Value
dl 0
loc 378
rs 10
c 0
b 0
f 0
wmc 6
1
<?php
2
 /**
3
  * Function area:       Table
4
  * Subfunction area:    Exception
5
  * @author     Augmentum SpikeSource Team 
6
  * @copyright  2005 by Augmentum, Inc.
7
  */
8
9
// Import the precondition class.
10
if(is_dir('../Public')) 
11
{
12
    require_once('../Public/SetPrecondition.php');
13
}
14
15
16
/**
17
 * A test case suite for testing exceptional scenarios in phpPgAdmin
18
 */
19
class DeadlockTest extends PreconditionSet{
20
    
21
    /**
22
     * Set up the preconditon. 
23
     */
24
    function setUp()
25
    {       
26
        return TRUE;
27
    }
28
    
29
    /**
30
     * Clean up all the result. 
31
     */ 
32
    function tearDown()
33
    {
34
        $this->logout(); 
35
        
36
        return TRUE;
37
    }
38
    
39
        
40
    /**
41
     * TestCaseID: TET03
42
     * 
43
     * Scenario:
44
     * 1. Open the first session, login as power user. Try to add a check 
45
     *    constraint: id_check (id > 0), without commit
46
     * 2. Open the second session, login as super user. Change the password 
47
     *    of the power user and commit the alteration.
48
     * 3. Turn to the first session and commit the add check operation.
49
     * 4. Rollback the changes, that's, change back the password for the 
50
     *    power user.
51
     * 
52
     * Expected result:  Login failed.
53
     */
54
    function testAddCheckScenario()
55
    {
56
        global $webUrl;
57
        global $lang, $SERVER, $DATABASE;
58
        global $POWER_USER_PASSWORD;
59
        global $SUPER_USER_PASSWORD;
60
        global $SUPER_USER_NAME;
61
        global $POWER_USER_NAME;
62
        
63
64
        $this->login($POWER_USER_NAME, $POWER_USER_PASSWORD, 
65
                     "$webUrl/login.php");
66
        
67
        // Try to add a check constraint to the table student
68
        // Go to the constraints page
69
		$this->assertTrue($this->get("$webUrl/constraints.php", array(
70
			'server' => $SERVER,
71
			'action' => 'add_check',
72
			'database' => $DATABASE,
73
			'schema' => 'public',
74
			'table' => 'student'))
75
		);
76
        
77
        // Set properties for the new constraint    
78
        $this->assertTrue($this->setField('name', 'id_check'));
79
        $this->assertTrue($this->setField('definition', 'id > 0'));
80
        
81
        
82
        // Open the second session, login as superuser
83
        $newBrowser = $this->createBrowser();
84
        $newBrowser->get("$webUrl/login.php"); 
85
        $this->assertTrue($newBrowser->setField('formUsername', $SUPER_USER_NAME));
86
        $this->assertTrue($newBrowser->setField('formPassword', $SUPER_USER_PASSWORD));
87
        $this->assertTrue($newBrowser->setField('formLanguage', $lang['applang']));
88
        $this->assertTrue($newBrowser->clickSubmit('Login'));
89
                     
90
        // Alter the user's password
91
        $this->assertTrue($newBrowser->get("$webUrl/users.php"));
92
		$this->assertTrue($newBrowser->get("$webUrl/users.php", array(
93
			'server' => $SERVER,
94
			'action' => 'edit',
95
			'username' => $POWER_USER_NAME))
96
		);       
97
        // Enter the information for altering the user's properties.
98
        $this->assertTrue($newBrowser->setField('newname', $POWER_USER_NAME));
99
        $this->assertTrue($newBrowser->setField('formPassword', '56789'));
100
        $this->assertTrue($newBrowser->setField('formConfirm', '56789'));
101
        $this->assertTrue($newBrowser->setField('formSuper', FALSE));
102
        $this->assertTrue($newBrowser->setField('formCreateDB', TRUE));
103
        $this->assertTrue($newBrowser->clickSubmit($lang['stralter']));
104
        
105
106
        // Now turn to the first session, submit the "add check" operation
107
        $this->assertTrue($this->clickSubmit($lang['stradd']));      
108
        // Verify if the constraint is created correctly.
109
        $this->assertTrue($this->assertWantedText($lang['strloginfailed']));
110
        
111
        
112
        // Rollback the changes to return to the original state
113
        $this->assertTrue($newBrowser->get("$webUrl/users.php"));
114
		$this->assertTrue($newBrowser->get("$webUrl/users.php", array(
115
			'server' => $SERVER,
116
			'action' => 'edit',
117
			'username' => $POWER_USER_NAME))
118
		);
119
       
120
        // Change back the user's password
121
        $this->assertTrue($newBrowser->setField('newname', $POWER_USER_NAME));
122
        $this->assertTrue($newBrowser->setField('formPassword', $POWER_USER_PASSWORD));
123
        $this->assertTrue($newBrowser->setField('formConfirm', $POWER_USER_PASSWORD));
124
        $this->assertTrue($newBrowser->setField('formSuper', FALSE));
125
        $this->assertTrue($newBrowser->setField('formCreateDB', TRUE));      
126
        $this->assertTrue($newBrowser->clickSubmit($lang['stralter']));
127
        
128
        return TRUE; 
129
    }
130
    
131
    
132
    /**
133
     * TestCaseID: TET01
134
     * 
135
     * Scenario:
136
     * 1. Open the first session, login as power user. Try to create a 
137
     *    database, don't commit;
138
     * 2. Open the second session, login as super user. Revoke the power
139
     *    user's createdb privilege
140
     * 3. Turn to the first session and commit the create database operation.
141
     * 4. Rollback the changes, that's, grant the createdb privilege to the
142
     *    power user.
143
     * 
144
     * Expected result:  Failed to add database. Permission denied.
145
     */
146
    function testCreateDatabaseScenario()
147
    {
148
        global $webUrl;
149
        global $lang, $SERVER;
150
        global $POWER_USER_PASSWORD;
151
        global $SUPER_USER_PASSWORD;
152
        global $SUPER_USER_NAME;
153
        global $POWER_USER_NAME;
154
        
155
        $this->login($POWER_USER_NAME, $POWER_USER_PASSWORD, 
156
                     "$webUrl/login.php");
157
        
158
        // Try to create a database 'newdb', without commit the operation                 
159
        $this->assertTrue ($this->get ("$webUrl/all_db.php"));              
160
		$this->assertTrue ($this->get ("$webUrl/all_db.php", array(
161
			'server' => $SERVER,
162
			'action' => 'create'))
163
		);       
164
        $this->assertTrue ($this->setfield('formName', 'newdb'));
165
        $this->assertTrue ($this->setfield('formEncoding', 'UNICODE'));                      
166
        
167
        
168
        // Open another session, login as superuser
169
        $newBrowser = $this->createBrowser();
170
        $newBrowser->get("$webUrl/login.php");
171
        $this->assertTrue($newBrowser->setField('formUsername', $SUPER_USER_NAME));
172
        $this->assertTrue($newBrowser->setField('formPassword', $SUPER_USER_PASSWORD));
173
        $this->assertTrue($newBrowser->setField('formLanguage', $lang['applang']));
174
        $this->assertTrue($newBrowser->clickSubmit('Login'));
175
                     
176
        // Revoke the user's createdb privilege
177
        $this->assertTrue($newBrowser->get("$webUrl/users.php"));
178
		$this->assertTrue($newBrowser->get("$webUrl/users.php", array(
179
			'server' => $SERVER,
180
			'action' => 'edit',
181
			'username' => $POWER_USER_NAME))
182
		);
183
        $this->assertTrue($newBrowser->setField('newname', $POWER_USER_NAME));
184
        $this->assertTrue($newBrowser->setField('formPassword', 'tester'));
185
        $this->assertTrue($newBrowser->setField('formConfirm', 'tester'));
186
        $this->assertTrue($newBrowser->setField('formSuper', FALSE));
187
        $this->assertTrue($newBrowser->setField('formCreateDB', FALSE));     
188
        $this->assertTrue($newBrowser->clickSubmit($lang['stralter']));
189
        
190
        
191
        // Now turn to the first session, submit the "create DB" operation
192
        $this->assertTrue ($this->clickSubmit($lang['strcreate']));       
193
        // Verify weather the database has been created.
194
        $this->assertTrue ($this->assertWantedText($lang['strdatabasecreatedbad']));
195
          
196
        // Rollback the changes to return to the original state
197
        $this->assertTrue($newBrowser->get("$webUrl/users.php"));
198
		$this->assertTrue($newBrowser->get("$webUrl/users.php", array(
199
			'server' => $SERVER,
200
			'action' => 'edit',
201
			'username' => $POWER_USER_NAME))
202
		);
203
204
        $this->assertTrue($newBrowser->setField('newname', $POWER_USER_NAME));
205
        $this->assertTrue($newBrowser->setField('formPassword', $POWER_USER_PASSWORD));
206
        $this->assertTrue($newBrowser->setField('formConfirm', $POWER_USER_PASSWORD));
207
        $this->assertTrue($newBrowser->setField('formSuper', FALSE));
208
        $this->assertTrue($newBrowser->setField('formCreateDB', TRUE));      
209
        $this->assertTrue($newBrowser->clickSubmit($lang['stralter']));
210
        
211
        return TRUE;
212
    }
213
    
214
    /**
215
     * TestCaseID: TET02
216
     * 
217
     * Scenario:
218
     * 1. Open the first session, login as power user. Create a column named 
219
     *    "sid". Then try to rename it as "ssid", don't commit;
220
     * 2. Open the second session, login as power user. Drop the column "sid";
221
     * 3. Turn to the first session and commit the alter column operation.
222
     * 
223
     * Expected result:  Failed to alter the column.
224
     */
225
    function testDropColumnScenario()
226
    {
227
        global $webUrl;
228
        global $lang, $SERVER, $DATABASE;
229
        global $POWER_USER_PASSWORD;
230
        global $SUPER_USER_PASSWORD;
231
        global $SUPER_USER_NAME;
232
        global $POWER_USER_NAME;
233
        
234
        $this->login($POWER_USER_NAME, $POWER_USER_PASSWORD, 
235
                     "$webUrl/login.php");
236
        
237
        // Add a column "sid"
238
		$this->assertTrue($this->get("$webUrl/tblproperties.php", array(
239
			'server' => $SERVER,
240
			'action' => 'add_column',
241
			'database' => $DATABASE,
242
			'schema' => 'public',
243
			'table' => 'student'))
244
		);
245
        // Set properties for the new column    
246
        $this->assertTrue($this->setField('field', 'sid'));        
247
        $this->assertTrue($this->setField('type', 'integer'));                
248
        $this->assertTrue($this->clickSubmit($lang['stradd']));
249
        // Verify if the column is created correctly.
250
        $this->assertTrue($this->assertWantedText($lang['strcolumnadded']));
251
        
252
        
253
        // Try to alter the column as "ssid"
254
		$this->assertTrue($this->get("$webUrl/tblproperties.php", array(
255
			'server' => $SERVER,
256
			'action' => 'properties',
257
			'database' => $DATABASE,
258
			'schema' => 'public',
259
			'table' => 'student',
260
			'column' => 'sid'))
261
		);
262
        // Set properties for the new column    
263
        $this->assertTrue($this->setField('field', 'ssid'));        
264
        $this->assertTrue($this->setField('type', 'character')); 
265
        $this->assertTrue($this->setField('length', '18')); 
266
267
        
268
        // Open the second session, login as power user
269
        $newBrowser = $this->createBrowser();
270
        $newBrowser->get("$webUrl/login.php"); 
271
        $this->assertTrue($newBrowser->setField('formUsername', $POWER_USER_NAME));
272
        $this->assertTrue($newBrowser->setField('formPassword', $POWER_USER_PASSWORD));
273
        $this->assertTrue($newBrowser->setField('formLanguage', $lang['applang']));
274
        $this->assertTrue($newBrowser->clickSubmit('Login'));
275
276
        // Drop the column
277
		$this->assertTrue($newBrowser->get("$webUrl/tblproperties.php", array(
278
		    'server' => $SERVER,
279
			'action' => 'confirm_drop',
280
			'database' => $DATABASE,
281
			'schema' => 'public',
282
			'table' => 'student',
283
			'column' => 'sid'))
284
		);
285
        $this->assertTrue($newBrowser->clickSubmit($lang['strdrop']));
286
        
287
        
288
        // Now turn to the first session, submit the "create DB" operation
289
         $this->assertTrue($this->clickSubmit($lang['stralter']));
290
        // Verify if the column is altered correctly.
291
        $this->assertTrue($this->assertWantedText($lang['strcolumnalteredbad']));
292
        
293
        return TRUE;          
294
    }
295
    
296
    
297
    /**
298
     * TestCaseID: TET05
299
     * 
300
     * Scenario:
301
     * 1. Open the first session, login as power user. Create a table 
302
     *    named "newtable". Then issue a SELECT query without commit. 
303
     * 2. Open another session, login as power user. Drop the table "newtable";
304
     * 3. Turn to the first session and commit the SELECT query.
305
     * 
306
     * Expected result:  ERROR:  relation "public.newtable" does not exist.
307
     */
308
    function testQueryDroppedTable()
309
    {
310
        global $webUrl;
311
        global $lang, $SERVER, $DATABASE;
312
        global $POWER_USER_PASSWORD;
313
        global $SUPER_USER_PASSWORD;
314
        global $SUPER_USER_NAME;
315
        global $POWER_USER_NAME;
316
317
        $this->login($SUPER_USER_NAME, $SUPER_USER_PASSWORD, 
318
                     "$webUrl/login.php");
319
        // Create a table.
320
		$this->assertTrue($this->get("$webUrl/tables.php", array(
321
			'server' => $SERVER,
322
			'action' => 'create',
323
			'database' => $DATABASE,
324
			'schema' => 'public'))
325
		);
326
        
327
        // Enter the table name and field number.
328
        $this->assertTrue($this->setField('name', 'newtable'));        
329
        $this->assertTrue($this->setField('fields', '2'));
330
        $this->assertTrue($this->setField('spcname', 'pg_default'));
331
        $this->assertTrue($this->setField('tblcomment', 'Create from SimpleTest!'));
332
                        
333
        // Click the button "next >" for inputing the detail information.                  
334
        //$this->assertTrue($this->clickSubmit($lang['strnext']));
335
        // If we do not hardcoded it here, it will cause fail. Encoding issue.
336
        $this->assertTrue($this->clickSubmit('Next >'));
337
          
338
        // Enter the detail information of the table. 
339
        $this->assertTrue($this->setField('field[0]', 'firstfield'));    
340
        $this->assertTrue($this->setField('type[0]', 'text'));
341
        $this->assertTrue($this->setField('array[0]', ''));
342
         
343
        $this->assertTrue($this->setField('field[1]', 'secondfield'));    
344
        $this->assertTrue($this->setField('type[1]', 'text'));
345
        $this->assertTrue($this->setField('array[1]', ''));
346
        
347
        // Click the button "Create" to create the table
348
        $this->assertTrue($this->clickSubmit($lang['strcreate']));
349
        // Verify if the table create correctly.
350
        $this->assertTrue($this->assertWantedText($lang['strtablecreated']));
351
        
352
        
353
        // Issue a SELECT query
354
        
355
        // Turn to the "tables" page.
356
		$this->assertTrue($this->get("$webUrl/tables.php", array(
357
		    'server' => $SERVER,
358
			'action' => 'confselectrows',
359
			'database' => $DATABASE,
360
			'schema' => 'public',
361
			'table' => 'newtable'))
362
		);
363
        
364
        // Select all the rows.
365
        $this->assertTrue($this->setField('show[firstfield]', TRUE));
366
        $this->assertTrue($this->setField('show[secondfield]', TRUE));
367
  
368
        
369
        // Open another session, login as super user, drop the table "newtable"
370
        $newBrowser = $this->createBrowser();
371
        $newBrowser->get("$webUrl/login.php");
372
        $this->assertTrue($newBrowser->setField('formUsername', $SUPER_USER_NAME));
373
        $this->assertTrue($newBrowser->setField('formPassword', $SUPER_USER_PASSWORD));
374
        $this->assertTrue($newBrowser->setField('formLanguage', $lang['applang']));
375
        $this->assertTrue($newBrowser->clickSubmit('Login'));
376
                     
377
        // Drop the table
378
		$newBrowser->get("$webUrl/tables.php", array(
379
			'server' => $SERVER,
380
			'action' => 'confirm_drop',
381
			'database' => $DATABASE,
382
			'schema' => 'public',
383
			'table' => 'newtable')
384
		); 
385
        $this->assertTrue($newBrowser->clickSubmit($lang['strdrop']));
386
        
387
        
388
        // Now turn to the first session, submit the SELECT query
389
        // Display all the rows.        
390
        $this->assertTrue($this->clickSubmit($lang['strselect']));
391
        // Verify whether select successful.       
392
        $this->assertTrue($this->assertWantedText($lang['strsqlerror']));
393
        $this->assertTrue($this->assertWantedText('public.newtable'));
394
        $this->assertTrue($this->assertWantedText('does not exist'));
395
        
396
        return TRUE;
397
    }
398
}
399
?>
400