@Test public void testEscapeSql() { Assert.assertEquals(StringEscapes.escapeSql("I've never been to Brooklyn"), "I''ve never been to Brooklyn"); }
private void initializeNewDatabase() { String createUserCommand = String.format( "\"CREATE USER %s WITH PASSWORD '%s'; \"", StringEscapes.escapeSql(getUsername()), StringEscapes.escapeSql(getUserPassword()) ); String createDatabaseCommand = String.format( "\"CREATE DATABASE %s OWNER %s\"", StringEscapes.escapeSql(getDatabaseName()), StringEscapes.escapeSql(getUsername())); String createRolesAdditionalCommand = ""; if (entity.getConfig(PostgreSqlNode.ROLES) != null && !entity.getConfig(PostgreSqlNode.ROLES).isEmpty()) { String createRolesQuery = buildCreateRolesQuery(); createRolesAdditionalCommand = sudoAsUser("postgres", getInstallDir() + "/bin/psql -p " + entity.getAttribute(PostgreSqlNode.POSTGRESQL_PORT) + " --command="+ createRolesQuery); } newScript("initializing user and database") .body.append( "cd " + getInstallDir(), callPgctl("start", true), sudoAsUser("postgres", getInstallDir() + "/bin/psql -p " + entity.getAttribute(PostgreSqlNode.POSTGRESQL_PORT) + " --command="+ createUserCommand), sudoAsUser("postgres", getInstallDir() + "/bin/psql -p " + entity.getAttribute(PostgreSqlNode.POSTGRESQL_PORT) + " --command="+ createDatabaseCommand), createRolesAdditionalCommand, callPgctl("stop", true)) .failOnNonZeroResultCode().execute(); }