diff options
| author | William Desportes <williamdes@wdes.fr> | 2019-12-31 12:22:24 +0100 |
|---|---|---|
| committer | William Desportes <williamdes@wdes.fr> | 2019-12-31 12:23:12 +0100 |
| commit | 997dd4a5e7648199b4e3624791d68a4af619a718 (patch) | |
| tree | 2a194616a4c54d402ed8f8aae766e8ee9054dbc1 /tests/Builder/CreateStatementTest.php | |
| parent | a1cf6c68a2b3ef052ae22b1bb0b8a99942a24e2f (diff) | |
| parent | 48233536e320c1874c547bf820017b9a5e0f164c (diff) | |
| download | sql-parser-997dd4a5e7648199b4e3624791d68a4af619a718.zip sql-parser-997dd4a5e7648199b4e3624791d68a4af619a718.tar.gz sql-parser-997dd4a5e7648199b4e3624791d68a4af619a718.tar.bz2 | |
Merge #277 - allow SCHEMA to be used in CREATE Database statement
Pull-request: #277
Fixes: #231
Signed-off-by: William Desportes <williamdes@wdes.fr>
Diffstat (limited to 'tests/Builder/CreateStatementTest.php')
| -rw-r--r-- | tests/Builder/CreateStatementTest.php | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/tests/Builder/CreateStatementTest.php b/tests/Builder/CreateStatementTest.php index 19989cb..87c5a9b 100644 --- a/tests/Builder/CreateStatementTest.php +++ b/tests/Builder/CreateStatementTest.php @@ -27,6 +27,7 @@ class CreateStatementTest extends TestCase public function testBuilderDatabase() { + // CREATE DATABASE ... $parser = new Parser( 'CREATE DATABASE `mydb` ' . 'DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_general_ci' @@ -38,6 +39,20 @@ class CreateStatementTest extends TestCase 'DEFAULT CHARACTER SET=utf8 DEFAULT COLLATE=utf8_general_ci', $stmt->build() ); + + + // CREATE SCHEMA ... + $parser = new Parser( + 'CREATE SCHEMA `mydb` ' . + 'DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_general_ci' + ); + $stmt = $parser->statements[0]; + + $this->assertEquals( + 'CREATE SCHEMA `mydb` ' . + 'DEFAULT CHARACTER SET=utf8 DEFAULT COLLATE=utf8_general_ci', + $stmt->build() + ); } public function testBuilderDefaultInt() |