Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
io.vertx.ext.sql.assist.SQLCommandImpl Maven / Gradle / Ivy
package io.vertx.ext.sql.assist;
import java.util.ArrayList;
import java.util.List;
import io.vertx.core.AsyncResult;
import io.vertx.core.Future;
import io.vertx.core.Handler;
import io.vertx.core.json.JsonArray;
import io.vertx.core.json.JsonObject;
/**
* 数据库命令执行器的默认实现
*
* @author Mirren
*
*/
public class SQLCommandImpl implements SQLCommand {
/** 语句 */
private SQLStatement statement;
/** 执行器 */
private SQLExecute execute;
/**
* 初始化
*
* @param statement
* @param execute
*/
public SQLCommandImpl(SQLStatement statement, SQLExecute execute) {
super();
this.statement = statement;
this.execute = execute;
}
@Override
public void getCount(SqlAssist assist, Handler> handler) {
SqlAndParams qp = statement.getCountSQL(assist);
execute.queryAsListArray(qp, set -> {
if (set.succeeded()) {
List rows = set.result();
if (rows != null && rows.size() >= 0) {
Object value = rows.get(0).getValue(0);
if (value instanceof Number) {
handler.handle(Future.succeededFuture(((Number) value).longValue()));
} else {
handler.handle(Future.succeededFuture(0L));
}
} else {
handler.handle(Future.succeededFuture(0L));
}
} else {
handler.handle(Future.failedFuture(set.cause()));
}
});
}
@Override
public void selectAll(SqlAssist assist, Handler>> handler) {
SqlAndParams qp = statement.selectAllSQL(assist);
execute.queryAsListObj(qp, handler);
}
@Override
public void selectById(S primaryValue, String resultColumns, String joinOrReference, Handler> handler) {
SqlAndParams qp = statement.selectByIdSQL(primaryValue, resultColumns, joinOrReference);
execute.queryAsObj(qp, handler);
}
@Override
public void selectSingleByObj(T obj, String resultColumns, String joinOrReference, Handler> handler) {
SqlAndParams qp = statement.selectByObjSQL(obj, resultColumns, joinOrReference, true);
execute.queryAsObj(qp, handler);
}
@Override
public void selectByObj(T obj, String resultColumns, String joinOrReference, Handler>> handler) {
SqlAndParams qp = statement.selectByObjSQL(obj, resultColumns, joinOrReference, false);
execute.queryAsListObj(qp, handler);
}
@Override
public void insertAll(T obj, Handler> handler) {
SqlAndParams qp = statement.insertAllSQL(obj);
execute.update(qp, handler);
}
@Override
public void insertNonEmpty(T obj, Handler> handler) {
SqlAndParams qp = statement.insertNonEmptySQL(obj);
execute.update(qp, handler);
}
@Override
public void insertBatch(List list, Handler> handler) {
SqlAndParams qp = statement.insertBatchSQL(list);
if (qp.succeeded()) {
execute.batch(qp, res -> {
if (res.succeeded()) {
List result = res.result() == null ? new ArrayList<>() : res.result();
long count = result.stream().count();
handler.handle(Future.succeededFuture(count));
} else {
handler.handle(Future.failedFuture(res.cause()));
}
});
} else {
handler.handle(Future.succeededFuture(0L));
}
}
@Override
public void insertBatch(List columns, List params, Handler> handler) {
SqlAndParams qp = statement.insertBatchSQL(columns, params);
if (qp.succeeded()) {
execute.batch(qp, res -> {
if (res.succeeded()) {
List result = res.result() == null ? new ArrayList<>() : res.result();
long count = result.stream().count();
handler.handle(Future.succeededFuture(count));
} else {
handler.handle(Future.failedFuture(res.cause()));
}
});
} else {
handler.handle(Future.succeededFuture(0L));
}
}
@Override
public void replace(T obj, Handler> handler) {
SqlAndParams qp = statement.replaceSQL(obj);
execute.update(qp, handler);
}
@Override
public void updateAllById(T obj, Handler> handler) {
SqlAndParams qp = statement.updateAllByIdSQL(obj);
execute.update(qp, handler);
}
@Override
public void updateAllByAssist(T obj, SqlAssist assist, Handler> handler) {
SqlAndParams qp = statement.updateAllByAssistSQL(obj, assist);
execute.update(qp, handler);
}
@Override
public void updateNonEmptyById(T obj, Handler> handler) {
SqlAndParams qp = statement.updateNonEmptyByIdSQL(obj);
execute.update(qp, handler);
}
@Override
public void updateNonEmptyByAssist(T obj, SqlAssist assist, Handler> handler) {
SqlAndParams qp = statement.updateNonEmptyByAssistSQL(obj, assist);
execute.update(qp, handler);
}
@Override
public void updateSetNullById(S primaryValue, List columns, Handler> handler) {
SqlAndParams qp = statement.updateSetNullByIdSQL(primaryValue, columns);
execute.update(qp, handler);
}
@Override
public void updateSetNullByAssist(SqlAssist assist, List columns, Handler> handler) {
SqlAndParams qp = statement.updateSetNullByAssistSQL(assist, columns);
execute.update(qp, handler);
}
@Override
public void deleteById(S primaryValue, Handler> handler) {
SqlAndParams qp = statement.deleteByIdSQL(primaryValue);
execute.update(qp, handler);
}
@Override
public void deleteByAssist(SqlAssist assist, Handler> handler) {
SqlAndParams qp = statement.deleteByAssistSQL(assist);
execute.update(qp, handler);
}
}
