SqlSetTest.java

package org.test4j.testng.database.dbop;

import java.io.File;

import org.test4j.database.table.ITable;
import org.test4j.module.database.IDatabase;
import org.test4j.module.database.dbop.SqlSet;
import org.test4j.testng.Test4J;
import org.testng.annotations.Test;

@Test(groups = { "test4j", "database" })
public class SqlSetTest extends Test4J implements IDatabase {

    @Test
    public void testReadFrom() {
        final String file = System.getProperty("user.dir")
                + "/src/test/resources/org/test4j/module/database/dbop/sql-demo.sql";
        db.cleanTable(ITable.t_tdd_user).execute(new SqlSet() {
            {
                this.readFrom(new File(file));
            }
        });

        db.table(ITable.t_tdd_user).count().isEqualTo(2);
    }
}