@Override public NodeGroupStore getNodeGroupStore(Config config) { return new MysqlNodeGroupStore(config); }
public MysqlNodeGroupStore(Config config) { super(config); createTable(readSqlFile("sql/mysql/lts_node_group_store.sql", JobQueueUtils.NODE_GROUP_STORE)); }
@Override public List<NodeGroupPo> getNodeGroup(NodeType nodeType) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .list(RshHolder.NODE_GROUP_LIST_RSH); }
@Override public List<NodeGroupPo> getNodeGroup(NodeType nodeType) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .list(RshHolder.NODE_GROUP_LIST_RSH); }
@Override public void removeNodeGroup(NodeType nodeType, String name) { new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .doDelete(); }
public MysqlNodeGroupStore(Config config) { super(config); createTable(readSqlFile("sql/mysql/lts_node_group_store.sql", JobQueueUtils.NODE_GROUP_STORE)); }
@Override public NodeGroupStore getNodeGroupStore(Config config) { return new MysqlNodeGroupStore(config); }
@Override public void removeNodeGroup(NodeType nodeType, String name) { new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .doDelete(); }
public MysqlNodeGroupStore(Config config) { super(config); createTable(readSqlFile("sql/mysql/lts_node_group_store.sql", JobQueueUtils.NODE_GROUP_STORE)); }
@Override public NodeGroupStore getNodeGroupStore(Config config) { return new MysqlNodeGroupStore(config); }
@Override public void addNodeGroup(NodeType nodeType, String name) { Long count = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .single(); if (count > 0) { // already exist return; } new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("node_type", "name", "gmt_created") .values(nodeType.name(), name, SystemClock.now()) .doInsert(); }
@Override public void addNodeGroup(NodeType nodeType, String name) { Long count = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .single(); if (count > 0) { // already exist return; } new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("node_type", "name", "gmt_created") .values(nodeType.name(), name, SystemClock.now()) .doInsert(); }
public PaginationRsp<NodeGroupPo> getNodeGroup(NodeGroupGetReq request) { PaginationRsp<NodeGroupPo> response = new PaginationRsp<NodeGroupPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql( new WhereSql() List<NodeGroupPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql( new WhereSql()
public PaginationRsp<NodeGroupPo> getNodeGroup(NodeGroupGetReq request) { PaginationRsp<NodeGroupPo> response = new PaginationRsp<NodeGroupPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql( new WhereSql() List<NodeGroupPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql( new WhereSql()
@Override public void removeNodeGroup(NodeType nodeType, String name) { new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .doDelete(); }
@Override public List<NodeGroupPo> getNodeGroup(NodeType nodeType) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .list(RshHolder.NODE_GROUP_LIST_RSH); }
@Override public void addNodeGroup(NodeType nodeType, String name) { Long count = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .single(); if (count > 0) { // already exist return; } new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("node_type", "name", "gmt_created") .values(nodeType.name(), name, SystemClock.now()) .doInsert(); }
public PaginationRsp<NodeGroupPo> getNodeGroup(NodeGroupGetReq request) { PaginationRsp<NodeGroupPo> response = new PaginationRsp<NodeGroupPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql( new WhereSql() List<NodeGroupPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql( new WhereSql()