@TraceCall @Override public Record getPageNoThrow(Context ctx, long pageId) { String sql = new SQLBuilder.Select() .select(StringUtils2.splitArray(BASIC_COLS, ",", true)) .from(pageTable) .where("destroyed_time=0 AND page_id = ${v(page_id)}", "page_id", pageId) .toString(); SQLExecutor se = getSqlExecutor(); Record pageRec = se.executeRecord(sql, null); if (MapUtils.isEmpty(pageRec)) return null; attachBasicInfo(ctx, pageRec); attachDetailInfo(ctx, pageRec); return pageRec; }
@TraceCall @Override public RecordSet getPages(Context ctx, long[] pageIds) { RecordSet pageRecs = new RecordSet(); if (ArrayUtils.isNotEmpty(pageIds)) { String sql = new SQLBuilder.Select() .select(StringUtils2.splitArray(BASIC_COLS, ",", true)) .from(pageTable) .where( "destroyed_time=0 AND page_id IN (${page_ids})", "page_ids", StringUtils2.join(pageIds, ",")) .toString(); SQLExecutor se = getSqlExecutor(); se.executeRecordSet(sql, pageRecs); attachBasicInfo(ctx, pageRecs); } return pageRecs; }