Database database = new Database(new SQL("host", "port","database", "username","password")); List<tStd_M_lt> bases = database.select(tStd_M_lt.class, new Where(tStd_M_lt.FIELDS.ITEM_ID.getDatabaseFieldName(), OPERATOR.LIKE, "?"), "%Base%"); for (tStd_M_lt base : bases) { List<tShower_Base_Kit> kits = database.selectByForiegnKey(tShower_Base_Kit.class, base); }
Observable<Post> findAll() { return this.db.select("select * from posts") .get( rs -> new Post(rs.getLong("id"), rs.getString("title"), rs.getString("content") ) ) .asObservable(); }
Single<Post> findById(Long id) { return this.db.select("select * from posts where id=?") .parameter(id) .get( rs -> new Post(rs.getLong("id"), rs.getString("title"), rs.getString("content") ) ) .first() .toSingle(); }
@Override public ResultBuilder query(String sql) { return new Results(getDatabase().select(sql).get(resultSet -> new RowImpl(resultSet))); }
@Override public ResultBuilder query(String sql, Object... parameters) { return new Results(getDatabase().select(sql).parameters(parameters).get(resultSet -> new RowImpl(resultSet))); }