public DbEntitySql(final DbOom dbOom) { this.entityManager = dbOom.entityManager(); this.dbOomConfig = dbOom.config(); }
protected TemplateData(final DbOom dbOom) { this.entityManager = dbOom.entityManager(); this.columnAliasType = defaultColumnAliasType = dbOom.config().getDefaultColumnAliasType(); }
public UpdateSetChunk(final DbOom dbOom, final String tableRef, final Object data, final int includeColumns) { super(dbOom.entityManager(), CHUNK_UPDATE); this.tableRef = tableRef; this.data = data; this.includeColumns = includeColumns; this.isUpdateablePrimaryKey = dbOom.config().isUpdateablePrimaryKey(); }
public void printEntities(final int width) { if (!databaseEnabled) { return; } final List<DbEntityDescriptor> list = new ArrayList<>(); dbOom.entityManager().forEachEntity(list::add); if (list.isEmpty()) { return; } final Print print = new Print(); print.line("Entities", width); list.stream() .sorted(Comparator.comparing(DbEntityDescriptor::getEntityName)) .forEach(ded -> print.outLeftRightNewLine( Chalk256.chalk().yellow(), ded.getTableName(), Chalk256.chalk().blue(), ClassUtil.getShortClassName(ded.getType(), 2), width)); print.line(width); } }
/** * 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); } } }
/** * Populates entity with generated column values from executed query. */ public void populateGeneratedKeys(final Object entity) { final String[] generatedColumns = getGeneratedColumnNames(); if (generatedColumns == null) { return; } DbEntityDescriptor ded = dbOom.entityManager().lookupType(entity.getClass()); // prepare key types Class[] keyTypes = new Class[generatedColumns.length]; String[] properties = new String[generatedColumns.length]; for (int i = 0; i < generatedColumns.length; i++) { String column = generatedColumns[i]; DbEntityColumnDescriptor decd = ded.findByColumnName(column); if (decd != null) { keyTypes[i] = decd.getPropertyType(); properties[i] = decd.getPropertyName(); } } final Object keyValues = findGeneratedColumns(keyTypes); if (!keyValues.getClass().isArray()) { BeanUtil.declared.setProperty(entity, properties[0], keyValues); } else { for (int i = 0; i < properties.length; i++) { BeanUtil.declared.setProperty(entity, properties[i], ((Object[]) keyValues)[i]); } } }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); final DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Group.class); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); final DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Bean1.class); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Enumerator.class); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Girl.class); dbEntityManager.registerEntity(Boy.class); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Girl.class); dbEntityManager.registerEntity(BadBoy.class); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Boy4.class); dbEntityManager.registerEntity(Girl4.class); dbEntityManager.registerEntity(Room.class); }
@BeforeEach void setUp() { dbOom = DbOom.create().get(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerType(Boy.class); dbEntityManager.registerType(BadBoy.class); dbEntityManager.registerType(BadGirl.class); dbEntityManager.registerType(Girl.class); }
@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); }
@BeforeEach void setUp() { DbOom.create().get(); final DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerType(Boy.class); dbEntityManager.registerType(BadBoy.class); dbEntityManager.registerType(BadGirl.class); dbEntityManager.registerType(Girl.class); }
DbOom dbOom = DbOom.create().get(); DbEntityManager dbEntityManager = dbOom.entityManager();
@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); }
@Override @BeforeEach public void setUp() throws Exception { super.setUp(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(Boy2.class); dbEntityManager.registerEntity(Girl.class); q1 = sql("select $C{boy.*}, $C{girl.*} from $T{Boy2 boy} join $T{Girl girl} on $boy.id=$girl.id").parse(); q2 = sql("select $C{boy.*}, $C{boy.girl.*} from $T{Boy2 boy} join $T{Girl girl} on $boy.id=$girl.id").parse(); q3 = sql("select $C{boy.*}, $C{girl.*}, (select count (1) from $T{Girl girl2}) as totalGirlsCount from $T{Boy2 boy} join $T{Girl girl} on $boy.id=$girl.id").parse(); q4 = sql("select $C{boy.*}, $C{boy.girlAlt:girl.*} from $T{Boy2 boy} join $T{Girl girl} on $boy.id=$girl.id").parse(); q5 = sql("select $C{boy.*}, $C{boy.girlAlt:girl.*}, (select count (1) from $T{Girl girl2}) as $C{boy.totalGirls:.totalGirlsCount} from $T{Boy2 boy} join $T{Girl girl} on $boy.id=$girl.id").parse(); q6 = sql("select $C{boy.*}, $C{boy.girlAlt:girl.[id,name]} from $T{Boy2 boy} join $T{Girl girl} on $boy.id=$girl.id").parse(); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(User.class); dbEntityManager.registerEntity(Wizard.class); session = new DbThreadSession(cp); executeUpdate("drop table WIZARD if exists"); executeUpdate("drop table USER if exists"); DbQuery query = DbQuery.query( "create table USER (" + "USER_ID IDENTITY," + "NAME varchar(20) not null" + ')'); query.executeUpdate(); query = DbQuery.query("insert into USER values(1, 'Gandalf')"); query.executeUpdate(); query = DbQuery.query( "create table WIZARD (" + "WIZARD_ID IDENTITY," + "LEVEL INT not null" + ')'); query.executeUpdate(); query = DbQuery.query("insert into WIZARD values(1, 7);"); query.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()); }