generators.add(new MockSqlGenerator(2, "B1", "B2"));
generators.add(new MockSqlGenerator(1, "A1", "A2"));
generators.add(new MockSqlGenerator(3, "C1", "C2"));
SqlGeneratorChain chain = new SqlGeneratorChain(generators);
Sql[] sql = chain.generateSql(new MockSqlStatement(), new MockDatabase());
assertEquals(6, sql.length);
assertEquals("C1", sql[0].toSql());
assertEquals("C2", sql[1].toSql());
assertEquals("B1", sql[2].toSql());
assertEquals("B2", sql[3].toSql());