public DataSource getDefaultShardDataSource() { if (StringUtils.isNullOrEmpty(defaultShardName)) { return null; } return shardMaping.get(defaultShardName); }
@Override public String getSQL() { if (table == null) { return "*"; } return StringUtils.quoteIdentifier(table) + ".*"; }
private List<String> collectItems(String items) { List<String> result = New.arrayList(); if (StringUtils.isNullOrEmpty(items)) { return result; } else if (items.indexOf("-") != -1) { String[] list = StringUtils.arraySplit(items, '-', true); if (list.length != 2) { throw new ParsingException("Invalid conjunction item'" + items + "'"); } throw new ParsingException("Not support - now"); } else { String[] array = StringUtils.arraySplit(items, ',', true); result = Arrays.asList(array); if (result.size() != new HashSet<String>(result).size()) { throw new ParsingException("Duplicate item " + items); } } return result; }
private String convertColumnName(String columnName) { if ((storesMixedCase || storesLowerCase) && columnName.equals(StringUtils.toLowerEnglish(columnName))) { columnName = StringUtils.toUpperEnglish(columnName); } else if (storesMixedCase && !supportsMixedCaseIdentifiers) { // TeraData columnName = StringUtils.toUpperEnglish(columnName); } else if (storesMixedCase && storesMixedCaseQuoted) { // MS SQL Server (identifiers are case insensitive even if quoted) columnName = StringUtils.toUpperEnglish(columnName); } return columnName; }
@Override public String getSQL() { String s; if (type == Value.CLOB) { s = getString(); return StringUtils.quoteStringSQL(s); } byte[] buff = getBytes(); s = StringUtils.convertBytesToHex(buff); return "X'" + s + "'"; }
/** * String to database identifier against dbSettings * * @param identifier * @return */ public String identifier(String identifier) { identifier = dbSettings.databaseToUpper ? StringUtils.toUpperEnglish(identifier) : identifier; return identifier; }
break; case LTRIM: result = ValueString.get(StringUtils.trim(v0.getString(), true, false, v1 == null ? " " : v1.getString()), database.getMode().treatEmptyStringsAsNull); break; case TRIM: result = ValueString.get(StringUtils.trim(v0.getString(), true, true, v1 == null ? " " : v1.getString()), database.getMode().treatEmptyStringsAsNull); break; case RTRIM: result = ValueString.get(StringUtils.trim(v0.getString(), false, true, v1 == null ? " " : v1.getString()), database.getMode().treatEmptyStringsAsNull); case XMLATTR: result = ValueString.get( StringUtils.xmlAttr(v0.getString(), v1.getString()), database.getMode().treatEmptyStringsAsNull); break; boolean indent = v3 == null ? true : v3.getBoolean(); result = ValueString.get(StringUtils.xmlNode( v0.getString(), attr, content, indent), database.getMode().treatEmptyStringsAsNull); result = ValueString.get(StringUtils.pad(v0.getString(),
/** * Indents a string with 4 spaces. * * @param s the string * @return the indented string */ public static String indent(String s) { return indent(s, 4, true); }
buff.append("(\n"); buff.append(StringUtils.indent(nested, 4, false)); if (enclose) { buff.append(')'); buff.append(StringUtils.unEnclose(joinCondition.getSQL())); buff.append(StringUtils.unEnclose(joinCondition.getSQL())); String condition = StringUtils.unEnclose(filterCondition.getSQL()); condition = "/* WHERE " + StringUtils.quoteRemarkSQL(condition) + "\n*/"; buff.append(StringUtils.indent(condition, 4, false));
/** * Get the alias name of a column or SQL expression * if it is not an aliased expression. * * @return the alias name */ public String getAlias() { return StringUtils.unEnclose(getSQL()); }
/** * Format a string as a Java string literal. * * @param s the string to convert * @return the Java string literal */ protected static String quote(String s) { return StringUtils.quoteJavaString(s); }
buff.append(identifier(forTable)).append(" ADD CONSTRAINT "); String constraintName = prepared.getConstraintName(); if (!StringUtils.isNullOrEmpty(constraintName)) { buff.append(constraintName); String enclose = StringUtils.enclose(prepared.getCheckExpression().getSQL()); buff.append(" CHECK").append(enclose).append(" NOCHECK"); return SQLTranslated.build().sql(buff.toString()); buff.append(identifier(forTable)).append(" ADD CONSTRAINT "); String constraintName = prepared.getConstraintName(); if (!StringUtils.isNullOrEmpty(constraintName)) { buff.append(constraintName);
String enclose = StringUtils.enclose(stmt.getCheckExpression().getSQL()); buff.append(" CHECK").append(enclose); break; for (String parameter : tableEngineParams) { buff.appendExceptFirst(", "); buff.append(StringUtils.quoteIdentifier(parameter));
protected static int[] toIntArray(String string) { String[] split = StringUtils.arraySplit(string, ',', true); int[] ints = new int[split.length]; for (int i = 0; i < split.length; ++i) { ints[i] = Integer.parseInt(split[i]); } return ints; }
String settings = url.substring(idx + 1); url = url.substring(0, idx); String[] list = StringUtils.arraySplit(settings, ';', false); for (String setting : list) { if (setting.length() == 0) { key = StringUtils.toUpperEnglish(key); if (!defaultSettings.containsKey(key)) { throw DbException.get(ErrorCode.UNSUPPORTED_SETTING_1, key);
@Override public String getSQL() { return "CAST(" + StringUtils.quoteStringSQL(value) + " AS VARCHAR_IGNORECASE)"; }
@Override public SQLTranslated translate(Column[] searchColumns, TableFilter filter, GroupObjectNode node) { ObjectNode[] items = node.getItems(); List<Value> params = New.arrayList(10 * items.length); StatementBuilder sql = new StatementBuilder(100 * items.length); for (ObjectNode objectNode : items) { SQLTranslated translated = translate(searchColumns, filter, objectNode); sql.appendExceptFirst(" UNION ALL "); sql.append(StringUtils.enclose(translated.sql)); params.addAll(translated.params); } return SQLTranslated.build().sql(sql.toString()).sqlParams(params); }
StringUtils.escapeMetaDataPattern(schemaName), StringUtils.escapeMetaDataPattern(tableName), new String[]{"TABLE"}); if (!rs.next()) { key = New.arrayList(); rs = meta.getPrimaryKeys(null, StringUtils.escapeMetaDataPattern(schemaName), tableName); while (rs.next()) { String c = rs.getString("COLUMN_NAME"); key.add(toUpper ? StringUtils.toUpperEnglish(c) : c); StringUtils.escapeMetaDataPattern(schemaName), tableName, true, true); while (rs.next()) { key.add(toUpper ? StringUtils.toUpperEnglish(c) : c);
String[] keyValuePairs = StringUtils.arraySplit(options, ' ', false); for (String pair : keyValuePairs) { if (pair.length() == 0) { String key = StringUtils.trim(pair.substring(0, index), true, true, " "); String value = pair.substring(index + 1); char ch = value.length() == 0 ? 0 : value.charAt(0);