@Override public JobFeedbackQueue getJobFeedbackQueue(Config config) { return new MysqlJobFeedbackQueue(config); }
@Override public boolean createQueue(String jobClientNodeGroup) { createTable(readSqlFile("sql/mysql/lts_job_feedback_queue.sql", getTableName(jobClientNodeGroup))); return true; }
@Override public long getCount(String jobClientNodeGroup) { return ((Long) new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(jobClientNodeGroup)) .single()).intValue(); }
@Override public boolean removeQueue(String jobClientNodeGroup) { return new DropTableSql(getSqlTemplate()) .drop(JobQueueUtils.getFeedbackQueueName(jobClientNodeGroup)) .doDrop(); }
@Override public long getCount(String jobClientNodeGroup) { return ((Long) new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(jobClientNodeGroup)) .single()).intValue(); }
@Override public boolean removeQueue(String jobClientNodeGroup) { return new DropTableSql(getSqlTemplate()) .drop(JobQueueUtils.getFeedbackQueueName(jobClientNodeGroup)) .doDrop(); }
@Override public boolean remove(String jobClientNodeGroup, String id) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(jobClientNodeGroup)) .where("id = ?", id) .doDelete() == 1; }
@Override public boolean createQueue(String jobClientNodeGroup) { createTable(readSqlFile("sql/mysql/lts_job_feedback_queue.sql", getTableName(jobClientNodeGroup))); return true; }
@Override public boolean removeQueue(String jobClientNodeGroup) { return new DropTableSql(getSqlTemplate()) .drop(JobQueueUtils.getFeedbackQueueName(jobClientNodeGroup)) .doDrop(); }
@Override public JobFeedbackQueue getJobFeedbackQueue(Config config) { return new MysqlJobFeedbackQueue(config); }
@Override public boolean remove(String jobClientNodeGroup, String id) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(jobClientNodeGroup)) .where("id = ?", id) .doDelete() == 1; }
@Override public boolean createQueue(String jobClientNodeGroup) { createTable(readSqlFile("sql/mysql/lts_job_feedback_queue.sql", getTableName(jobClientNodeGroup))); return true; }
@Override public JobFeedbackQueue getJobFeedbackQueue(Config config) { return new MysqlJobFeedbackQueue(config); }
@Override public List<JobFeedbackPo> fetchTop(String jobClientNodeGroup, int top) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(jobClientNodeGroup)) .orderBy() .column("gmt_created", OrderByType.ASC) .limit(0, top) .list(RshHolder.JOB_FEED_BACK_LIST_RSH); }
@Override public List<JobFeedbackPo> fetchTop(String jobClientNodeGroup, int top) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(jobClientNodeGroup)) .orderBy() .column("gmt_created", OrderByType.ASC) .limit(0, top) .list(RshHolder.JOB_FEED_BACK_LIST_RSH); }
@Override public boolean add(List<JobFeedbackPo> jobFeedbackPos) { if (CollectionUtils.isEmpty(jobFeedbackPos)) { return true; } // insert ignore duplicate record for (JobFeedbackPo jobFeedbackPo : jobFeedbackPos) { String jobClientNodeGroup = jobFeedbackPo.getJobRunResult().getJobMeta().getJob().getSubmitNodeGroup(); new InsertSql(getSqlTemplate()) .insertIgnore(getTableName(jobClientNodeGroup)) .columns("gmt_created", "job_result") .values(jobFeedbackPo.getGmtCreated(), JSON.toJSONString(jobFeedbackPo.getJobRunResult())) .doInsert(); } return true; }
@Override public boolean add(List<JobFeedbackPo> jobFeedbackPos) { if (CollectionUtils.isEmpty(jobFeedbackPos)) { return true; } // insert ignore duplicate record for (JobFeedbackPo jobFeedbackPo : jobFeedbackPos) { String jobClientNodeGroup = jobFeedbackPo.getJobRunResult().getJobMeta().getJob().getSubmitNodeGroup(); new InsertSql(getSqlTemplate()) .insertIgnore(getTableName(jobClientNodeGroup)) .columns("gmt_created", "job_result") .values(jobFeedbackPo.getGmtCreated(), JSON.toJSONString(jobFeedbackPo.getJobRunResult())) .doInsert(); } return true; }
@Override public long getCount(String jobClientNodeGroup) { return ((Long) new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(jobClientNodeGroup)) .single()).intValue(); }
@Override public boolean remove(String jobClientNodeGroup, String id) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(jobClientNodeGroup)) .where("id = ?", id) .doDelete() == 1; }
@Override public List<JobFeedbackPo> fetchTop(String jobClientNodeGroup, int top) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(jobClientNodeGroup)) .orderBy() .column("gmt_created", OrderByType.ASC) .limit(0, top) .list(RshHolder.JOB_FEED_BACK_LIST_RSH); }