@Override protected String getSqlToDropUniqueConstraint(String contraintName, String table) { return StringUtil.concat("ALTER TABLE ", table, " DROP CONSTRAINT ", contraintName, " DROP INDEX"); }
public String toString(boolean verbose) { boolean bo = (verbose || conf == null || conf.length() < 301); return StringUtil.concatObjectsCap(200, "id: ", ident.getId(), "\nname: ", ident.getName(), "\nfaulty: ", faulty, "\ntype: ", type, "\nconf: ", (bo ? conf : StringUtil.concat(conf.substring(0, 297), "..."))); }
@Override protected String getSqlToAddForeignKeyConstraint(String constraintName, String baseTable, String baseColumn, String referencedTable, String referencedColumn, String onDeleteAction, String onUpdateAction) { return StringUtil.concat("ALTER TABLE ", baseTable, " ADD CONSTRAINT ", constraintName, " FOREIGN KEY (", baseColumn, ")", " REFERENCES ", referencedTable, " (", referencedColumn, ")", " ON DELETE ", onDeleteAction); }
@Override protected String buildNextSeqValueSql(String sequenceName) { return StringUtil.concat("UPDATE SEQ_TBL SET SEQ_VALUE=(@cur_value:=SEQ_VALUE)+1 " + "WHERE SEQ_NAME='", sequenceName, "'"); }
@Override protected String buildCreateSequenceSql(String sequenceName, long startValue) { return StringUtil.concat("INSERT INTO SEQ_TBL (SEQ_NAME,SEQ_VALUE) VALUES('", sequenceName, "', ", Long.toString(startValue), ")"); }
@Override protected String buildCreateSequenceSql(String sequenceName, long startValue) { return StringUtil.concat("CREATE SEQUENCE ", sequenceName, " AS BIGINT START WITH ", Long.toString(startValue), " INCREMENT BY 1 NO CYCLE NO CACHE"); }
@Override protected String buildCreateSequenceSql(String sequenceName, long startValue) { return StringUtil.concat("CREATE SEQUENCE ", sequenceName, " START WITH ", Long.toString(startValue), " INCREMENT BY 1 NO CYCLE"); }
@Override protected String buildCreateSequenceSql(String sequenceName, long startValue) { return StringUtil.concat("CREATE SEQUENCE ", sequenceName, " AS BIGINT START WITH ", Long.toString(startValue), " INCREMENT BY 1"); }
@Override protected String buildCreateSequenceSql(String sequenceName, long startValue) { return StringUtil.concat("CREATE SEQUENCE ", sequenceName, " START WITH ", Long.toString(startValue), " INCREMENT BY 1 NO CYCLE NO CACHE"); }
private static void writeSerialNumberLine(BufferedWriter writer, BigInteger serialNumber) throws IOException { String msg = StringUtil.concat(serialNumber.toString(16), "\n"); synchronized (writer) { writer.write(msg); } }
@Override public String buildSelectFirstSql(int rows, String orderBy, String coreSql) { if (StringUtil.isBlank(orderBy)) { return StringUtil.concat("SELECT ", coreSql, (coreSql.contains(" WHERE") ? " AND" : " WHERE"), " ROWNUM<", Integer.toString(rows + 1)); } else { return StringUtil.concat("SELECT * FROM (SELECT ", coreSql, " ORDER BY ", orderBy, " ) WHERE ROWNUM<", Integer.toString(rows + 1)); } }
public static String cutText(String text, int maxLen) { Args.notNull(text, "text"); if (text.length() <= maxLen) { return text; } return StringUtil.concat(text.substring(0, maxLen - 13), "...skipped..."); }
@Override public String buildSelectFirstSql(int rows, String orderBy, String coreSql) { return StringUtil.concat("SELECT ", coreSql, (StringUtil.isBlank(orderBy) ? "" : " ORDER BY " + orderBy), " LIMIT ", Integer.toString(rows)); }
@Override public String buildSelectFirstSql(int rows, String orderBy, String coreSql) { return StringUtil.concat("SELECT ", coreSql, (StringUtil.isBlank(orderBy) ? "" : " ORDER BY " + orderBy), " LIMIT ", Integer.toString(rows)); }
public void addError(String errorMessage) throws IOException { ParamUtil.requireNonNull("errorMessage", errorMessage); numError.incrementAndGet(); String msg = StringUtil.concat(errorMessage, "\n"); synchronized (errorWriter) { errorWriter.write(msg); } }
@Override public String buildSelectFirstSql(int rows, String orderBy, String coreSql) { return StringUtil.concat("SELECT ", coreSql, (StringUtil.isBlank(orderBy) ? "" : " ORDER BY " + orderBy), " FETCH FIRST ", Integer.toString(rows), " ROWS ONLY"); }
static String signerConfToString(String signerConf, boolean verbose, boolean ignoreSensitiveInfo) { Args.notBlank(signerConf, "signerConf"); if (ignoreSensitiveInfo) { signerConf = SignerConf.eraseSensitiveData(signerConf); } if (verbose || signerConf.length() < 101) { return signerConf; } else { return StringUtil.concat(signerConf.substring(0, 97), "..."); } }
public static String toPemCert(X509Certificate cert) throws CertificateException { Args.notNull(cert, "cert"); return StringUtil.concat("-----BEGIN CERTIFICATE-----\n", Base64.encodeToString(cert.getEncoded(), true), "\n-----END CERTIFICATE-----"); }
protected String getSqlToDropPrimaryKey(String primaryKeyName, String table) { Args.notBlank(primaryKeyName, "primaryKeyName"); Args.notBlank(table, "table"); return StringUtil.concat("ALTER TABLE ", table, " DROP PRIMARY KEY "); }
protected String getSqlToDropUniqueConstraint(String constraintName, String table) { Args.notBlank(table, "table"); Args.notBlank(constraintName, "constraintName"); return StringUtil.concat("ALTER TABLE ", table, " DROP CONSTRAINT ", constraintName); }