public CleanupDisabledUsers(Database db, System2 system2) { super(db); this.falseValue = db.getDialect().getFalseSqlValue(); this.system2 = system2; }
private void appendDefaultValue(StringBuilder sql, ColumnDef columnDef) { Object defaultValue = columnDef.getDefaultValue(); if (defaultValue != null) { sql.append(" DEFAULT "); if (defaultValue instanceof String) { sql.append(format("'%s'", defaultValue)); } else if (defaultValue instanceof Boolean) { sql.append((boolean) defaultValue ? dialect.getTrueSqlValue() : dialect.getFalseSqlValue()); } else { sql.append(defaultValue); } } }
private void addColumn(StringBuilder sql, ColumnDef columnDef) { sql.append(columnDef.getName()).append(" ").append(columnDef.generateSqlType(dialect)); Object defaultValue = columnDef.getDefaultValue(); if (defaultValue != null) { sql.append(" DEFAULT "); // TODO remove duplication with CreateTableBuilder if (defaultValue instanceof String) { sql.append(format("'%s'", defaultValue)); } else if (defaultValue instanceof Boolean) { sql.append((boolean) defaultValue ? dialect.getTrueSqlValue() : dialect.getFalseSqlValue()); } else { sql.append(defaultValue); } } sql.append(columnDef.isNullable() ? " NULL" : " NOT NULL"); }
MyBatisConfBuilder(Database database) { this.conf = new Configuration(); this.conf.setEnvironment(new Environment("production", createTransactionFactory(), database.getDataSource())); this.conf.setUseGeneratedKeys(true); this.conf.setLazyLoadingEnabled(false); this.conf.setJdbcTypeForNull(JdbcType.NULL); Dialect dialect = database.getDialect(); this.conf.setDatabaseId(dialect.getId()); this.conf.getVariables().setProperty("_true", dialect.getTrueSqlValue()); this.conf.getVariables().setProperty("_false", dialect.getFalseSqlValue()); this.conf.getVariables().setProperty("_from_dual", dialect.getSqlFromDual()); this.conf.getVariables().setProperty("_scrollFetchSize", String.valueOf(dialect.getScrollDefaultFetchSize())); this.conf.setLocalCacheScope(LocalCacheScope.STATEMENT); }
public CleanupDisabledUsers(Database db, System2 system2) { super(db); this.falseValue = db.getDialect().getFalseSqlValue(); this.system2 = system2; }
private void appendDefaultValue(StringBuilder sql, ColumnDef columnDef) { Object defaultValue = columnDef.getDefaultValue(); if (defaultValue != null) { sql.append(" DEFAULT "); if (defaultValue instanceof String) { sql.append(format("'%s'", defaultValue)); } else if (defaultValue instanceof Boolean) { sql.append((boolean) defaultValue ? dialect.getTrueSqlValue() : dialect.getFalseSqlValue()); } else { sql.append(defaultValue); } } }
private void addColumn(StringBuilder sql, ColumnDef columnDef) { sql.append(columnDef.getName()).append(" ").append(columnDef.generateSqlType(dialect)); Object defaultValue = columnDef.getDefaultValue(); if (defaultValue != null) { sql.append(" DEFAULT "); // TODO remove duplication with CreateTableBuilder if (defaultValue instanceof String) { sql.append(format("'%s'", defaultValue)); } else if (defaultValue instanceof Boolean) { sql.append((boolean) defaultValue ? dialect.getTrueSqlValue() : dialect.getFalseSqlValue()); } else { sql.append(defaultValue); } } sql.append(columnDef.isNullable() ? " NULL" : " NOT NULL"); }
public MyBatisConfBuilder(Database database) { this.conf = new Configuration(); this.conf.setEnvironment(new Environment("production", createTransactionFactory(), database.getDataSource())); this.conf.setUseGeneratedKeys(true); this.conf.setLazyLoadingEnabled(false); this.conf.setJdbcTypeForNull(JdbcType.NULL); Dialect dialect = database.getDialect(); this.conf.setDatabaseId(dialect.getId()); this.conf.getVariables().setProperty("_true", dialect.getTrueSqlValue()); this.conf.getVariables().setProperty("_false", dialect.getFalseSqlValue()); this.conf.getVariables().setProperty("_scrollFetchSize", String.valueOf(dialect.getScrollDefaultFetchSize())); this.conf.setLocalCacheScope(LocalCacheScope.STATEMENT); }