Examples with TableHelper org.apache.cayenne.test.jdbc.TableHelper used on opensource projects

Example 71 with TableHelper

use of org.apache.cayenne.test.jdbc.TableHelper in project cayenne by apache.

the class DataContextEJBQLIsNullIT method setUp.

@Before
public void setUp() throws Exception {
    tArtist = new TableHelper(dbHelper, "ARTIST");
    tArtist.setColumns("ARTIST_ID", "ARTIST_NAME");
    tPainting = new TableHelper(dbHelper, "PAINTING");
    tPainting.setColumns("PAINTING_ID", "ARTIST_ID", "PAINTING_TITLE", "ESTIMATED_PRICE").setColumnTypes(Types.INTEGER, Types.BIGINT, Types.VARCHAR, Types.DECIMAL);
}

Example 72 with TableHelper

use of org.apache.cayenne.test.jdbc.TableHelper in project cayenne by apache.

the class DataContextEJBQLNumericalFunctionalIT method setUp.

@Before
public void setUp() throws Exception {
    tBigIntegerEntity = new TableHelper(dbHelper, "BIGINTEGER_ENTITY");
    tBigIntegerEntity.setColumns("ID", "BIG_INTEGER_FIELD");
}

Example 73 with TableHelper

use of org.apache.cayenne.test.jdbc.TableHelper in project cayenne by apache.

the class DataContextEJBQLOrderByIT method setUp.

@Before
public void setUp() throws Exception {
    tArtist = new TableHelper(dbHelper, "ARTIST");
    tArtist.setColumns("ARTIST_ID", "ARTIST_NAME");
    tPainting = new TableHelper(dbHelper, "PAINTING");
    tPainting.setColumns("PAINTING_ID", "ARTIST_ID", "PAINTING_TITLE", "ESTIMATED_PRICE").setColumnTypes(Types.INTEGER, Types.BIGINT, Types.VARCHAR, Types.DECIMAL);
}

Example 74 with TableHelper

use of org.apache.cayenne.test.jdbc.TableHelper in project cayenne by apache.

the class Cay2412IT method prepareData.

@Before
public void prepareData() throws Exception {
    TableHelper tArtist = new TableHelper(dbHelper, "ARTIST");
    tArtist.setColumns("ARTIST_ID", "ARTIST_NAME", "DATE_OF_BIRTH");
    tArtist.setColumnTypes(Types.INTEGER, Types.VARCHAR, Types.DATE);
    tArtist.insert(1, "artist1", new java.sql.Date(System.currentTimeMillis()));
    TableHelper tGallery = new TableHelper(dbHelper, "GALLERY");
    tGallery.setColumns("GALLERY_ID", "GALLERY_NAME");
    tGallery.insert(1, "tate modern");
    TableHelper tPaintings = new TableHelper(dbHelper, "PAINTING");
    tPaintings.setColumns("PAINTING_ID", "PAINTING_TITLE", "ARTIST_ID", "GALLERY_ID", "ESTIMATED_PRICE");
    for (int i = 1; i <= 3; i++) {
        tPaintings.insert(i, "painting" + i, 1, 1, 22 - i);
    }
}

Example 75 with TableHelper

use of org.apache.cayenne.test.jdbc.TableHelper in project cayenne by apache.

the class CayenneCompoundIT method setUp.

@Before
public void setUp() throws Exception {
    tCompoundPKTest = new TableHelper(dbHelper, "COMPOUND_PK_TEST");
    tCompoundPKTest.setColumns("KEY1", "KEY2", "NAME");
    tCharPKTest = new TableHelper(dbHelper, "CHAR_PK_TEST");
    tCharPKTest.setColumns("PK_COL", "OTHER_COL");
    tCompoundIntPKTest = new TableHelper(dbHelper, "COMPOUND_INT_PK");
    tCompoundIntPKTest.setColumns("id1", "id2", "name");
}