Examples with Movie io.vertigo.database.sql.data.Movie used on opensource projects

Example 6 with Movie

use of io.vertigo.database.sql.data.Movie in project vertigo by KleeGroup.

the class AbstractSqlDataBaseManagerTest method testInsert.

@Test
public final void testInsert() throws Exception {
    final String insertWithgeneratedKey = obtainMainConnection().getDataBase().getSqlDialect().createInsertQuery("ID", Arrays.asList("TITLE"), "seq_", "movie");
    final GenerationMode generationMode = obtainMainConnection().getDataBase().getSqlDialect().getGenerationMode();
    // We check that we have the right expected mode
    Assert.assertEquals(getExpectedGenerationMode(), generationMode);
    // ---
    final SqlConnection connection = obtainMainConnection();
    long generatedKey;
    try {
        final Movie movie = new Movie();
        movie.setTitle("frankenstein");
        generatedKey = dataBaseManager.executeUpdateWithGeneratedKey(SqlStatement.builder(insertWithgeneratedKey).bind("DTO", Movie.class, movie).build(), generationMode, "ID", Long.class, connection).getVal2();
        connection.commit();
    } finally {
        connection.release();
    }
    final List<Integer> result = executeQuery(Integer.class, "select count(*) from movie", null);
    Assert.assertEquals(1, result.size());
    Assert.assertEquals(1, result.get(0).intValue());
    final List<Integer> keys = executeQuery(Integer.class, "select id from movie", null);
    Assert.assertEquals(1, keys.size());
    Assert.assertEquals(generatedKey, keys.get(0).intValue());
}