public TableMetaData getTableMetaData(String tableName) { TableMetaData result = new TableMetaData(); ResultSet resultSet = null; result.setTableName(tableName); DatabaseMetaData metaData = getDbSqlSession() .getSqlSession() String name = resultSet.getString("COLUMN_NAME").toUpperCase(); String type = resultSet.getString("TYPE_NAME").toUpperCase(); result.addColumnMetaData(name, type); if(result.getColumnNames().size() == 0) {
public void testGetTableMetaData() { TableMetaData tableMetaData = managementService.getTableMetaData("ACT_RU_TASK"); assertEquals(tableMetaData.getColumnNames().size(), tableMetaData.getColumnTypes().size()); assertEquals(21, tableMetaData.getColumnNames().size()); int assigneeIndex = tableMetaData.getColumnNames().indexOf("ASSIGNEE_"); int createTimeIndex = tableMetaData.getColumnNames().indexOf("CREATE_TIME_"); assertTrue(assigneeIndex >= 0); assertTrue(createTimeIndex >= 0); assertOneOf(new String[]{"VARCHAR", "NVARCHAR2", "nvarchar", "NVARCHAR"}, tableMetaData.getColumnTypes().get(assigneeIndex)); assertOneOf(new String[]{"TIMESTAMP", "TIMESTAMP(6)", "datetime", "DATETIME", "DATETIME2"}, tableMetaData.getColumnTypes().get(createTimeIndex)); }
public TableMetaData getTableMetaData(String tableName) { TableMetaData result = new TableMetaData(); ResultSet resultSet = null; result.setTableName(tableName); DatabaseMetaData metaData = getDbSqlSession() .getSqlSession() String name = resultSet.getString("COLUMN_NAME").toUpperCase(); String type = resultSet.getString("TYPE_NAME").toUpperCase(); result.addColumnMetaData(name, type); if(result.getColumnNames().size() == 0) {
public void testGetTableMetaData() { TableMetaData tableMetaData = managementService.getTableMetaData("ACT_RU_TASK"); assertEquals(tableMetaData.getColumnNames().size(), tableMetaData.getColumnTypes().size()); assertEquals(21, tableMetaData.getColumnNames().size()); int assigneeIndex = tableMetaData.getColumnNames().indexOf("ASSIGNEE_"); int createTimeIndex = tableMetaData.getColumnNames().indexOf("CREATE_TIME_"); assertTrue(assigneeIndex >= 0); assertTrue(createTimeIndex >= 0); assertOneOf(new String[]{"VARCHAR", "NVARCHAR2", "nvarchar", "NVARCHAR"}, tableMetaData.getColumnTypes().get(assigneeIndex)); assertOneOf(new String[]{"TIMESTAMP", "TIMESTAMP(6)", "datetime", "DATETIME", "DATETIME2"}, tableMetaData.getColumnTypes().get(createTimeIndex)); }
public TableMetaData getTableMetaData(String tableName) { TableMetaData result = new TableMetaData(); ResultSet resultSet = null; result.setTableName(tableName); DatabaseMetaData metaData = getDbSqlSession() .getSqlSession() String name = resultSet.getString("COLUMN_NAME").toUpperCase(); String type = resultSet.getString("TYPE_NAME").toUpperCase(); result.addColumnMetaData(name, type); if(result.getColumnNames().size() == 0) {