public DbEntitySql(final DbOom dbOom) { this.entityManager = dbOom.entityManager(); this.dbOomConfig = dbOom.config(); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); final DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Bean1.class); }
protected DbQueryBase(final DbOom dbOom) { this.dbOom = dbOom; this.forcePreparedStatement = dbOom.queryConfig().isForcePreparedStatement(); this.type = dbOom.queryConfig().getType(); this.concurrencyType = dbOom.queryConfig().getConcurrencyType(); this.holdability = dbOom.queryConfig().getHoldability(); this.debug = dbOom.queryConfig().isDebug(); this.fetchSize = dbOom.queryConfig().getFetchSize(); this.maxRows = dbOom.queryConfig().getMaxRows(); }
/** * Creates new database session with default transaction mode and in autocommit mode. */ public DbSession(ConnectionProvider connectionProvider) { log.debug("Creating new db session"); if (connectionProvider == null) { connectionProvider = DbOom.get().connectionProvider(); if (connectionProvider == null) { throw new DbSqlException("Connection provider is not available"); } } this.connectionProvider = connectionProvider; this.txActive = false; this.txMode = DbTransactionMode.READ_ONLY_TX; this.queries = new HashSet<>(); }
dbOom = DbOom.create() .withConnectionProvider(connectionProvider) .withSessionProvider(sessionProvider) .get(); dbOom.connect(); final DbEntityManager dbEntityManager = dbOom.entityManager(); dbEntityManager.reset(); petiteContainer.addBean(beanNamePrefix() + "query", dbOom.queryConfig()); petiteContainer.addBean(beanNamePrefix() + "oom", dbOom.config());
@Test void testTableNameDefault() { DbOom dbOom = DbOom.create().get(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); DbOom.get().config().getTableNames().setLowercase(true); dbEntityManager.registerEntity(Tester.class); DbOom.get().config().getTableNames().setChangeCase(false); DbOom.get().config().getTableNames().setSplitCamelCase(false); dbEntityManager.registerEntity(Tester.class); assertNotNull(ded.findByColumnName("iD")); dbOom.shutdown();
@BeforeEach void setUp() { final DbOom dbOom = DbOom.create().get(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerType(Girl.class); dbEntityManager.registerType(BadGirl.class); dbEntityManager.registerType(Boy.class); dbEntityManager.registerType(BadBoy.class); }
final DbEntityDescriptor ded = dbOom.entityManager().lookupType(type); if (dbOom.config().isKeysGeneratedByDatabase()) { q = query(dbOom.entities().insert(entity)); q.setGeneratedKey(); q.executeUpdate(); final Object nextId = generateNextId(ded); setEntityId(ded, entity, nextId); q = query(dbOom.entities().insert(entity)); q.executeUpdate(); query(dbOom.entities().updateAll(entity)).autoClose().executeUpdate();
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); final DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Girl2.class); dbEntityManager.registerEntity(Boy.class); dbSession = new DbThreadSession(cp); final DbEntitySql dbEntitySql = dbOom.entities(); assertEquals(1, dbEntitySql.insert(new Girl2(1, "Anna", "swim")).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Girl2(2, "Sandra", "piano")).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Girl2(3, "Emma", "nothing")).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Boy(1, "Johny", 2)).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Boy(2, "Marco", 2)).query().executeUpdate()); assertEquals(1, dbEntitySql.insert(new Boy(3, "Hugo", 1)).query().executeUpdate()); }
@BeforeEach void setUp() { DbOom dbOom = DbOom.create().get(); DbEntityManager dbEntityManager = dbOom.entityManager(); dbOom.config().getTableNames().setPrefix("PRE_"); dbOom.config().getTableNames().setSuffix("_SUF"); dbEntityManager.registerType(Boy.class); dbEntityManager.registerType(BadBoy.class); dbEntityManager.registerType(BadGirl.class); dbEntityManager.registerType(Girl.class); }
/** * Finds list of entities matching given criteria. */ @SuppressWarnings({"unchecked"}) public <E> List<E> find(final Object criteria) { return query(dbOom.entities().find(criteria)).autoClose().list(criteria.getClass()); }
executeUpdate(session, sql); final DbEntityManager dbEntityManager = DbOom.get().entityManager(); SqlTypeManager.get().register(FooWeight.class, FooWeigthSqlType.class); List<Foo> foos = dbOom.query("select * from FOO").list(Foo.class); assertEquals(1, foos.size()); Foo foo = foos.get(0); foo.decimal = new Double("34.12"); foo.decimal2 = new BigDecimal("1.099"); DbOomQuery doq = dbOom.entities().update(foo).query(); doq = dbOom.query(dbOom.entities().updateColumn(foo, "timestamp2", LocalDateTime.parse("2010-02-02T20:20:20.222"))); foos = dbOom.query("select * from FOO").list(Foo.class); assertEquals(1, foos.size()); foo = foos.get(0);
@Test void testEqualEntities() { DbOom dbOom = DbOom.create().get(); DbEntityManager dbEntityManager = dbOom.entityManager(); dbOom.shutdown();
/** * Creates new SQL builder. */ public DbSqlBuilder() { this(DbOom.get()); }
/** * Delete single object by its id. Resets ID value. */ public void deleteById(final Object entity) { if (entity != null) { int result = query(dbOom.entities().deleteById(entity)).autoClose().executeUpdate(); if (result != 0) { // now reset the ID value Class type = entity.getClass(); DbEntityDescriptor ded = dbOom.entityManager().lookupType(type); setEntityId(ded, entity, 0); } } }
@Test void testEnums() { DbSession session = new DbThreadSession(cp); String sql = "create table ENUMERATOR(ID int, NAME varchar(20), STATUS int)"; DbQuery query = new DbQuery(DbOom.get(), sql); query.executeUpdate(); Enumerator e = new Enumerator(); e.id = 2; e.name = "Ikigami"; e.status = Enumerator.STATUS.ONE; query = DbOomQuery.query(dbOom.entities().insert(e)); query.executeUpdate(); session.closeSession(); }