WantStyleAssertionTest_Database.java

package org.test4j.module.database.utility;

import org.junit.Test;
import org.test4j.database.table.ITable;
import org.test4j.database.table.TddUserTable;
import org.test4j.junit.Test4J;
import org.test4j.tools.commons.ListHelper;

@SuppressWarnings({ "serial", "unchecked" })
public class WantStyleAssertionTest_Database extends Test4J {

    @Test
    public void testDatabase() {
        db.table(ITable.t_tdd_user).clean().insert(2, new TddUserTable() {
            {
                this.put(IColumn.f_id, "1", "2");
                this.put(IColumn.f_first_name, "darui", "jobs");
                this.put(IColumn.f_last_name, "wu", "he");
            }
        });

        db.query("select id,first_name,last_name from tdd_user").reflectionEqMap(ListHelper.toList(new TddUserTable() {
            {
                this.put(IColumn.f_id, 1);
                this.put(IColumn.f_first_name, "darui");
            }
        }, new TddUserTable() {
            {
                this.put(IColumn.f_id, 2);
                this.put(IColumn.f_last_name, "he");
            }
        }));
    }
}