-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestCreateDatabase.java
More file actions
35 lines (29 loc) · 1.65 KB
/
Copy pathtestCreateDatabase.java
File metadata and controls
35 lines (29 loc) · 1.65 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
package mssql;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.ESqlStatementType;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.stmt.TCreateDatabaseSqlStatement;
import gudusoft.gsqlparser.stmt.mssql.TMssqlIfElse;
import junit.framework.TestCase;
public class testCreateDatabase extends TestCase {
public void test1(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvmssql);
sqlparser.sqltext = "CREATE DATABASE xml";
int result = sqlparser.parse();
assertTrue(result==0);
assertTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstcreatedatabase);
TCreateDatabaseSqlStatement createDatabaseSqlStatement = (TCreateDatabaseSqlStatement)sqlparser.sqlstatements.get(0);
assertTrue(createDatabaseSqlStatement.getDatabaseName().toString().equalsIgnoreCase("xml"));
}
public void test2(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvmssql);
sqlparser.sqltext = "if db_id('AutoSchemaDB') is null create database AutoSchemaDB";
int result = sqlparser.parse();
assertTrue(result==0);
assertTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstmssqlif);
TMssqlIfElse ifElse = (TMssqlIfElse )sqlparser.sqlstatements.get(0);
assertTrue(ifElse.getStmt().sqlstatementtype == ESqlStatementType.sstcreatedatabase);
TCreateDatabaseSqlStatement createDatabaseSqlStatement = (TCreateDatabaseSqlStatement)ifElse.getStmt();
assertTrue(createDatabaseSqlStatement.getDatabaseName().toString().equalsIgnoreCase("AutoSchemaDB"));
}
}