test_sqlfile.php
1.04 KB
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
<?php
require_once(dirname(__FILE__) . "/../test.php");
require_once(KT_DIR . "/lib/database/sqlfile.inc.php");
class SQLFileTestCase extends KTUnitTestCase {
function testSQLFile() {
$aExpected = array(
"SELECT \"as;\";",
"SELECT \"as\\\";\";",
"SELECT \"as\\\\\";",
"SELECT \"as\\\\\";",
"SELECT \"as\\\\\";",
"SELECT \"as\\\\\";",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\';';",
"SELECT \"'as\\'\"';';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT 'as\\\\';",
"SELECT '
asdf; \"\\\" \\'
asdf; ';",
);
$aReceived = SQLFile::sqlFromFile(dirname(__FILE__) . "/test_sqlfile.sql");
$this->assertExpectedResults($aExpected, $aReceived);
}
}
?>