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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Selenium TestCase for table related tests
*
* @package PhpMyAdmin-test
* @subpackage Selenium
*/
require_once 'TestBase.php';
/**
* PmaSeleniumTableInsertTest class
*
* @package PhpMyAdmin-test
* @subpackage Selenium
* @group selenium
*/
class PMA_SeleniumTableInsertTest extends PMA_SeleniumBase
{
/**
* Setup the browser environment to run the selenium t
* est case
*
* @return void
*/
public function setUp()
{
parent::setUp();
$this->dbQuery(
"CREATE TABLE `test_table` ("
. " `id` int(11) NOT NULL AUTO_INCREMENT,"
. " `name` varchar(20) NOT NULL,"
. " `datetimefield` datetime NOT NULL,"
. " PRIMARY KEY (`id`)"
. ")"
);
}
/**
* setUp function that can use the selenium session (called before each test)
*
* @return void
*/
public function setUpPage()
{
$this->login();
$this->navigateTable('test_table');
}
/**
* Insert data into table
*
* @return void
*
* @group large
*/
public function testAddData()
{
if ($GLOBALS['PMA_String']->strtolower($this->getBrowser()) == 'safari') {
/* TODO: this should be fixed, but the cause is unclear to me */
$this->markTestIncomplete('Fails with Safari');
}
$this->expandMore();
$this->byLinkText("Insert")->click();
$this->waitForElement("byId", "insertForm");
$this->byId("field_1_3")->value("1");
$this->byId("field_2_3")->value("abcd");
$this->byId("field_3_3")->value("2011-01-20 02:00:02");
$this->byId("field_5_3")->value("foo");
$this->byId("field_6_3")->value("2010-01-20 02:00:02");
$select = $this->select($this->byName("after_insert"));
$select->selectOptionByLabel("Insert another new row");
// post
$this->byId("buttonYes")->click();
$ele = $this->waitForElement("byClassName", "success");
$this->assertContains("2 rows inserted", $ele->text());
$this->byId("field_2_3")->value("Abcd");
$this->byId("field_3_3")->value("2012-01-20 02:00:02");
// post
$this->byCssSelector(
"input[value=Go]"
)->click();
$this->waitForElementNotPresent("byId", "loading_parent");
$ele = $this->waitForElement("byClassName", "success");
$this->assertContains("1 row inserted", $ele->text());
$this->_assertDataPresent();
}
/**
* Assert various data present in results table
*
* @return void
*/
private function _assertDataPresent()
{
$this->byLinkText("Browse")->click();
$this->waitForElement("byId", "table_results");
$this->assertEquals(
"1",
$this->getTable('table_results', 1, 5)
);
$this->assertEquals(
"abcd",
$this->getTable('table_results', 1, 6)
);
$this->assertEquals(
"2011-01-20 02:00:02",
$this->getTable('table_results', 1, 7)
);
$this->assertEquals(
"2",
$this->getTable('table_results', 2, 5)
);
$this->assertEquals(
"foo",
$this->getTable('table_results', 2, 6)
);
$this->assertEquals(
"2010-01-20 02:00:02",
$this->getTable('table_results', 2, 7)
);
$this->assertEquals(
"4",
$this->getTable('table_results', 3, 5)
);
$this->assertEquals(
"Abcd",
$this->getTable('table_results', 3, 6)
);
$this->assertEquals(
"2012-01-20 02:00:02",
$this->getTable('table_results', 3, 7)
);
}
}
|
