public void testPostSQL() throws Exception {
final Schema tupleSchema1 = new Schema("schema1", Fields.parse("a:string, b:int"));
String[] afterInsertSQL = new String[] { "afterinsert1", "afterinsert2" };
String[] finalSQL = new String[] { "DROP INDEX idx_schema1_ab", "CREATE INDEX blablabla" };
TableSpec tableSpec = new TableSpec(tupleSchema1, new Field[] { tupleSchema1.getField(0) },
new FieldIndex[] { new FieldIndex(tupleSchema1.getField(0), tupleSchema1.getField(1)) }, null,
null, afterInsertSQL, finalSQL, null);
String[] createIndex = SploutSQLOutputFormat.getCreateIndexes(tableSpec);
assertEquals("afterinsert1", createIndex[0]);
assertEquals("afterinsert2", createIndex[1]);
assertEquals("CREATE INDEX idx_schema1_ab ON schema1(`a`, `b`);", createIndex[2]);