@Before public void setUp() throws Exception { DbSetup dbSetup = new DbSetup( new DataSourceDestination(dataSource), sequenceOf( DataTest.DELETE_ALL, DataTest.INSERT_MEMBER, insertInto("ARTICLE") .withGeneratedValue("id", ValueGenerators.sequence()) .columns( "AUTHOR_ID", "CONTENT", "POSTEDAT", "TITLE", "HEADLINE", "VALID", "NBCONSULTS") .values(1, "Content *markdown*", new Date(), "title", "intro", true, 1) .build(), insertInto("ARTICLECOMMENT") .withGeneratedValue("id", ValueGenerators.sequence()) .columns("MEMBER_ID", "CONTENT", "POSTEDAT", "ARTICLE_ID") .values(1, "Comment *markdown*", new Date(), 1) .build())); dbSetup.launch(); }
@BeforeClass public void initData() { Operation operations = sequenceOf( insertInto("item") .columns("id", "name", "status", "date") .values(1, "test", true, new Date()) .values(2, "test", true, new Date()) .values(3, "test", true, new Date()) .values(4, "test1", false, new Date()) .build()); DbSetup dbSetup = new DbSetup(new DataSourceDestination(dataSource), operations); dbSetup.launch(); }