@Test public void testStatement() { Db2AddTablePartition atp = new Db2AddTablePartition(schemaName, tableName, partitionId, tablespaceName); String ddl = atp.buildSqlString(); assertEquals(ddl, "ALTER TABLE " + schemaName + "." + tableName + " ADD PARTITION TENANT" + partitionId + " STARTING FROM " + partitionId + " INCLUSIVE " + " ENDING AT " + partitionId + " INCLUSIVE" + " IN " + tablespaceName); }
protected String buildSqlString() { final String partitionName = "TENANT" + partitionId; final String lowValueStr = Integer.toString(partitionId); final String highValueStr = Integer.toString(partitionId); return "ALTER TABLE " + schemaName + "." + tableName + " ADD PARTITION " + partitionName + " STARTING FROM " + lowValueStr + " INCLUSIVE ENDING AT " + highValueStr + " INCLUSIVE" + " IN " + this.tablespaceName; }
Db2AddTablePartition implements IDatabaseStatement { protected String buildSqlString() { final String partitionName = "TENANT" + partitionId; final String lowValueStr = Integer.toString(partitionId); final String highValueStr = Integer.toString(partitionId); return "ALTER TABLE " + schemaName + "." + tableName + " ADD PARTITION " + partitionName + " STARTING FROM " + lowValueStr + " INCLUSIVE ENDING AT " + highValueStr + " INCLUSIVE" + " IN " + this.tablespaceName; } }
Db2AddTablePartition implements IDatabaseStatement { protected String buildSqlString() { final String partitionName = "TENANT" + partitionId; final String lowValueStr = Integer.toString(partitionId); final String highValueStr = Integer.toString(partitionId); return "ALTER TABLE " + schemaName + "." + tableName + " ADD PARTITION " + partitionName + " STARTING FROM " + lowValueStr + " INCLUSIVE ENDING AT " + highValueStr + " INCLUSIVE" + " IN " + this.tablespaceName; } Db2AddTablePartition(String schemaName, String tableName, int partitionId, String tablespaceName); }
Db2AddTablePartition implements IDatabaseStatement { protected String buildSqlString() { final String partitionName = "TENANT" + partitionId; final String lowValueStr = Integer.toString(partitionId); final String highValueStr = Integer.toString(partitionId); return "ALTER TABLE " + schemaName + "." + tableName + " ADD PARTITION " + partitionName + " STARTING FROM " + lowValueStr + " INCLUSIVE ENDING AT " + highValueStr + " INCLUSIVE" + " IN " + this.tablespaceName; } Db2AddTablePartition(String schemaName, String tableName, int partitionId, String tablespaceName); @Override void run(IDatabaseTranslator translator, Connection c); }
Db2AddTablePartition implements IDatabaseStatement { protected String buildSqlString() { final String partitionName = "TENANT" + partitionId; final String lowValueStr = Integer.toString(partitionId); final String highValueStr = Integer.toString(partitionId); return "ALTER TABLE " + schemaName + "." + tableName + " ADD PARTITION " + partitionName + " STARTING FROM " + lowValueStr + " INCLUSIVE ENDING AT " + highValueStr + " INCLUSIVE" + " IN " + this.tablespaceName; } Db2AddTablePartition(String schemaName, String tableName, int partitionId, String tablespaceName); @Override void run(IDatabaseTranslator translator, Connection c);  }