use of doitincloud.commons.exceptions.ServerErrorException in project rdbcache by rdbcache.
the class Query method executeSelect.
public boolean executeSelect() {
KeyInfo keyInfo = anyKey.getKeyInfo();
String table = keyInfo.getTable();
LOGGER.trace("sql: " + sql);
LOGGER.trace("params: " + (params != null ? params.toString() : "null"));
List<Map<String, Object>> list = null;
StopWatch stopWatch = context.startStopWatch("dbase", "jdbcTemplate.queryForList");
try {
if (params != null) {
list = jdbcTemplate.queryForList(sql, params.toArray());
} else {
list = jdbcTemplate.queryForList(sql);
}
if (stopWatch != null)
stopWatch.stopNow();
if (list != null && list.size() > 0) {
for (int i = 0; i < list.size(); i++) {
KvPair pair = pairs.getAny(i);
if (pair.getType().equals("data")) {
pair.setType(table);
}
pair.setData(list.get(i));
keyInfo = anyKey.getAny(i);
//
if (!Parser.prepareStandardClauseParams(context, pair, keyInfo)) {
String msg = "executeSelect failed when prepareStandardClauseParams for " + pair.getId();
LOGGER.error(msg);
context.logTraceMessage(msg);
if (context.isSync()) {
throw new ServerErrorException(context, msg);
}
}
LOGGER.trace("found " + pair.getId() + " from " + table);
}
return true;
}
} catch (Exception e) {
if (stopWatch != null)
stopWatch.stopNow();
e.printStackTrace();
String msg = e.getCause().getMessage();
LOGGER.error(msg);
context.logTraceMessage(msg);
if (context.isSync()) {
throw new ServerErrorException(context, msg);
}
}
return false;
}
use of doitincloud.commons.exceptions.ServerErrorException in project rdbcache by rdbcache.
the class Query method executeDelete.
public boolean executeDelete() {
boolean allOk = true;
for (int i = 0; i < pairs.size(); i++) {
KvPair pair = pairs.get(i);
KeyInfo keyInfo = anyKey.getAny(i);
String table = keyInfo.getTable();
if (!keyInfo.getIsNew() && !keyInfo.hasParams() && keyInfo.ifJustCreated()) {
waitForParamsUpdate(pair.getIdType(), keyInfo);
}
if (!Parser.prepareStandardClauseParams(context, pair, keyInfo)) {
String msg = "executeDelete failed when calling prepareStandardClauseParams for " + pair.getId();
LOGGER.error(msg);
context.logTraceMessage(msg);
if (context.isSync()) {
throw new ServerErrorException(context, msg);
}
continue;
}
params = keyInfo.getParams();
String clause = keyInfo.getClause();
sql = "delete from " + table + " where " + clause + " limit 1";
LOGGER.trace("sql: " + sql);
LOGGER.trace("params: " + params.toString());
StopWatch stopWatch = context.startStopWatch("dbase", "jdbcTemplate.delete");
try {
if (jdbcTemplate.update(sql, params.toArray()) > 0) {
if (stopWatch != null)
stopWatch.stopNow();
LOGGER.trace("delete " + pair.getId() + " from " + table);
continue;
} else {
if (stopWatch != null)
stopWatch.stopNow();
allOk = false;
}
} catch (Exception e) {
if (stopWatch != null)
stopWatch.stopNow();
allOk = false;
String msg = e.getCause().getMessage();
LOGGER.error(msg);
context.logTraceMessage(msg);
e.printStackTrace();
if (context.isSync()) {
throw new ServerErrorException(context, msg);
}
}
keyInfo.setQueryKey(null);
}
return allOk;
}
use of doitincloud.commons.exceptions.ServerErrorException in project rdbcache by rdbcache.
the class Query method executeUpdate.
public boolean executeUpdate() {
params = new ArrayList<>();
boolean allOk = true;
for (int i = 0; i < pairs.size(); i++) {
KvPair pair = pairs.get(i);
KeyInfo keyInfo = anyKey.getAny(i);
String table = keyInfo.getTable();
if (!keyInfo.getIsNew() && !keyInfo.hasParams() && keyInfo.ifJustCreated()) {
waitForParamsUpdate(pair.getIdType(), keyInfo);
}
//
if (!Parser.prepareStandardClauseParams(context, pair, keyInfo)) {
allOk = false;
String msg = "executeUpdate failed when calling prepareStandardClauseParams for " + pair.getId();
LOGGER.error(msg);
context.logTraceMessage(msg);
if (context.isSync()) {
throw new ServerErrorException(context, msg);
}
continue;
}
Map<String, Object> map = pair.getData();
params.clear();
String updates = "";
for (Map.Entry<String, Object> entry : map.entrySet()) {
params.add(entry.getValue());
if (updates.length() != 0)
updates += ", ";
updates += entry.getKey() + " = ?";
}
params.addAll(keyInfo.getParams());
String clause = keyInfo.getClause();
sql = "update " + table + " set " + updates + " where " + clause + " limit 1";
LOGGER.trace("sql: " + sql);
LOGGER.trace("params: " + params.toString());
StopWatch stopWatch = context.startStopWatch("dbase", "jdbcTemplate.update");
try {
if (jdbcTemplate.update(sql, params.toArray()) > 0) {
if (stopWatch != null)
stopWatch.stopNow();
LOGGER.trace("update " + pair.getId() + " from " + table);
continue;
} else {
if (stopWatch != null)
stopWatch.stopNow();
allOk = false;
}
} catch (Exception e) {
if (stopWatch != null)
stopWatch.stopNow();
allOk = false;
String msg = e.getCause().getMessage();
LOGGER.error(msg);
context.logTraceMessage(msg);
e.printStackTrace();
if (context.isSync()) {
throw new ServerErrorException(context, msg);
}
}
keyInfo.setQueryKey(null);
}
return allOk;
}
use of doitincloud.commons.exceptions.ServerErrorException in project rdbcache by rdbcache.
the class AnyKey method getAny.
public KeyInfo getAny(int index) {
int size = size();
if (index > size) {
throw new ServerErrorException("getAny index out of range");
}
if (size == 0 || index == size) {
KeyInfo keyInfo = null;
if (size == 0) {
keyInfo = new KeyInfo();
keyInfo.setIsNew(true);
} else {
keyInfo = get(0).clone();
keyInfo.setIsNew(true);
keyInfo.clearParams();
}
add(keyInfo);
}
return get(index);
}
Aggregations