@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 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(); }
@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(); }
.columns("count(1)") .from() .table(getTableName()) .whereSql( new WhereSql() .all() .from() .table(getTableName()) .whereSql( new WhereSql()
.columns("count(1)") .from() .table(getTableName()) .whereSql( new WhereSql() .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(); }
.columns("count(1)") .from() .table(getTableName()) .whereSql( new WhereSql() .all() .from() .table(getTableName()) .whereSql( new WhereSql()