Example 11 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_lob method test_oracle2pg_long.
public void test_oracle2pg_long() throws Exception {
String sql = "long";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("TEXT", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 12 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_lob method test_oracle2pg_long_raw.
public void test_oracle2pg_long_raw() throws Exception {
String sql = "long raw";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("BYTEA", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 13 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_chars method test_oracle2pg_varchar.
public void test_oracle2pg_varchar() throws Exception {
String sql = "varchar(10)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("VARCHAR(10)", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 14 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_chars method test_oracle2pg_varchar2_10000.
public void test_oracle2pg_varchar2_10000() throws Exception {
String sql = "varchar2(10000)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("TEXT", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Example 15 with SQLDataType
use of com.alibaba.druid.sql.ast.SQLDataType in project druid by alibaba.
the class Oracle2PG_DataTypeTest_chars method test_oracle2pg_nchar.
public void test_oracle2pg_nchar() throws Exception {
String sql = "nchar(10)";
SQLDataType dataType = SQLParserUtils.createExprParser(sql, JdbcConstants.ORACLE).parseDataType();
SQLDataType pgDataType = SQLTransformUtils.transformOracleToPostgresql(dataType);
assertEquals("NCHAR(10)", pgDataType.toString());
}
Also used :
SQLDataType(com.alibaba.druid.sql.ast.SQLDataType)
Aggregations
SQLDataType (com.alibaba.druid.sql.ast.SQLDataType)93
SQLDataTypeImpl (com.alibaba.druid.sql.ast.SQLDataTypeImpl)7
SQLExpr (com.alibaba.druid.sql.ast.SQLExpr)7
SQLCharacterDataType (com.alibaba.druid.sql.ast.statement.SQLCharacterDataType)5
SQLAllColumnExpr (com.alibaba.druid.sql.ast.expr.SQLAllColumnExpr)4
SQLIntegerExpr (com.alibaba.druid.sql.ast.expr.SQLIntegerExpr)4
SQLNumericLiteralExpr (com.alibaba.druid.sql.ast.expr.SQLNumericLiteralExpr)3
SQLColumnDefinition (com.alibaba.druid.sql.ast.statement.SQLColumnDefinition)3
SQLVariantRefExpr (com.alibaba.druid.sql.ast.expr.SQLVariantRefExpr)2
SQLName (com.alibaba.druid.sql.ast.SQLName)1
SQLStatement (com.alibaba.druid.sql.ast.SQLStatement)1
SQLCharExpr (com.alibaba.druid.sql.ast.expr.SQLCharExpr)1
SQLIdentifierExpr (com.alibaba.druid.sql.ast.expr.SQLIdentifierExpr)1
SQLIntervalExpr (com.alibaba.druid.sql.ast.expr.SQLIntervalExpr)1
SQLMethodInvokeExpr (com.alibaba.druid.sql.ast.expr.SQLMethodInvokeExpr)1
SQLNullExpr (com.alibaba.druid.sql.ast.expr.SQLNullExpr)1
SQLAlterTableAlterColumn (com.alibaba.druid.sql.ast.statement.SQLAlterTableAlterColumn)1
SQLColumnConstraint (com.alibaba.druid.sql.ast.statement.SQLColumnConstraint)1
SQLColumnPrimaryKey (com.alibaba.druid.sql.ast.statement.SQLColumnPrimaryKey)1
SQLColumnUniqueKey (com.alibaba.druid.sql.ast.statement.SQLColumnUniqueKey)1
