public static InsertValue newInserValue(String columnName, ParamValue<?> paramValue) { return new InsertValue(columnName, paramValue); }
public String toEscapedColumnName() { return escapedColumnName(); }
private EntityMapping addValue(String colName, ParamValue<?> val) { InsertValue inserValue = InsertValue.newInserValue(colName, val); insertValueList.add(inserValue); return this; }
@Override public String toString() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); List<String> paramValueList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toEscapedColumnName()); ParamValue<?> paramValue = insertValue.paramValue(); paramValueList.add(paramValue.toEscapedString()); } String columnNames = columnNameList.stream().collect(Collectors.joining(",")); String escapedArgs = paramValueList.stream().collect(Collectors.joining(",")); return String.format("insert into %s (%s) values (%s);", tableName, columnNames, escapedArgs); }
@Override public AbstractUpdate<?> getUpdate() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); List<ParamValue<?>> paramValueList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.columnName()); paramValueList.add(insertValue.paramValue()); } String params = columnNameList.stream().collect(Collectors.joining("= ?, ")); AbstractUpdate<?> update = newUpdate() .add("update %s", table) .add("set") .add(params + "= ?"); update.getParams().addAll(paramValueList); id.bind(update); return update; } };
public String toUpdate(PrimaryKey primaryKey) { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toUpdate()); } String columns = columnNameList.stream().collect(Collectors.joining(",")); String keyColumn = primaryKey.columnName(); Object val = primaryKey.value(); addValue(keyColumn, paramValue(next(), val)); return String.format("update %s set %s where `%s`=?", table, columns, primaryKey.columnName()); }
public SqlDump toSqlDump(PrimaryKey pk) { boolean contained = false; for (InsertValue insertValue : insertValueList) { if (insertValue.isColumnNameEqual(pk.columnName())) { contained = true; break; } } return contained ? toSqlDump() : SqlDump.newSqlDump(table, insertValueList, pk); }
public void prepare(Stmt stmt) { for (InsertValue insertValue : insertValueList) { insertValue.set(stmt); } }
@Override public List<ParamValue<?>> getParams() { Builder<ParamValue<?>> list = ImmutableList.<ParamValue<?>> builder(); for (InsertValue insertValue : insertValueList) { list.add(insertValue.paramValue()); } return list.build(); }
@Override public String toString() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = newArrayListWithCapacity(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toEscapedColumnName()); } String columns = Joiner.on(",").join(columnNameList); Object[] argArr = new Object[insertValueListSize]; Arrays.fill(argArr, "?"); String args = Joiner.on(",").join(argArr); return String.format("insert into %s (%s) values (%s)", table, columns, args); }
@Override public String toString() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); List<String> paramValueList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toEscapedColumnName()); ParamValue<?> paramValue = insertValue.paramValue(); paramValueList.add(paramValue.toEscapedString()); } String columnNames = columnNameList.stream().collect(Collectors.joining(",")); String escapedArgs = paramValueList.stream().collect(Collectors.joining(",")); return String.format("insert into %s (%s) values (%s);", tableName, columnNames, escapedArgs); }
@Override public AbstractUpdate<?> getUpdate() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); List<ParamValue<?>> paramValueList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.columnName()); paramValueList.add(insertValue.paramValue()); } String params = columnNameList.stream().collect(Collectors.joining("= ?, ")); AbstractUpdate<?> update = newUpdate() .add("update %s", table) .add("set") .add(params + "= ?"); update.getParams().addAll(paramValueList); id.bind(update); return update; } };
public String toUpdate(PrimaryKey primaryKey) { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toUpdate()); } String columns = columnNameList.stream().collect(Collectors.joining(",")); String keyColumn = primaryKey.columnName(); Object val = primaryKey.value(); addValue(keyColumn, paramValue(next(), val)); return String.format("update %s set %s where `%s`=?", table, columns, primaryKey.columnName()); }
public SqlDump toSqlDump(PrimaryKey pk) { boolean contained = false; for (InsertValue insertValue : insertValueList) { if (insertValue.isColumnNameEqual(pk.columnName())) { contained = true; break; } } return contained ? toSqlDump() : SqlDump.newSqlDump(table, insertValueList, pk, paramValueFactory()); }
public void prepare(Stmt stmt) { for (InsertValue insertValue : insertValueList) { insertValue.set(stmt); } }
@Override public List<ParamValue<?>> getParams() { Builder<ParamValue<?>> list = ImmutableList.<ParamValue<?>> builder(); for (InsertValue insertValue : insertValueList) { list.add(insertValue.paramValue()); } return list.build(); }
@Override public String toString() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = new ArrayList<>(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toEscapedColumnName()); } String columns = columnNameList.stream().collect(Collectors.joining(",")); Object[] argArr = new Object[insertValueListSize]; Arrays.fill(argArr, "?"); String args = Stream.of(argArr).map(Object::toString).collect(Collectors.joining(",")); return String.format("insert into %s (%s) values (%s)", table, columns, args); }
@Override public String toString() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = newArrayListWithCapacity(insertValueListSize); List<String> paramValueList = newArrayListWithCapacity(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.toEscapedColumnName()); ParamValue<?> paramValue = insertValue.paramValue(); paramValueList.add(paramValue.toEscapedString()); } String columnNames = Joiner.on(",").join(columnNameList); String escapedArgs = Joiner.on(",").join(paramValueList); return String.format("insert into %s (%s) values (%s);", tableName, columnNames, escapedArgs); }
private Insert addValue(String colName, ParamValue<?> val) { InsertValue insertValue = InsertValue.newInserValue(colName, val); insertValueList.add(insertValue); return this; }
@Override public Update getUpdate() { int insertValueListSize = insertValueList.size(); List<String> columnNameList = newArrayListWithCapacity(insertValueListSize); List<ParamValue<?>> paramValueList = newArrayListWithCapacity(insertValueListSize); for (InsertValue insertValue : insertValueList) { columnNameList.add(insertValue.columnName()); paramValueList.add(insertValue.paramValue()); } String params = Joiner.on("= ?, ").join(columnNameList); Update update = Update.get() .add("update %s", table) .add("set") .add(params + "= ?"); update.getParams().addAll(paramValueList); id.bind(update); return update; } };