Caught: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "Phrancis"
org.postgresql.util.PSQLException: FATAL: password authentication failed for user "Phrancis"

- (id) init __attribute__((unavailable("Must use initWithFoo: instead.")));

def sql = Sql.newInstance(dbUrl, dbUser, dbPassword, dbDriver)

print sql
print "\n"

def map = [message:'Hello, World!']

sql.execute("DROP TABLE IF EXISTS test CASCADE;\n" +
    "CREATE TABLE test (\n"
        +"id SERIAL,\n"
        +"message TEXT\n"
    +");")

sql.execute("INSERT INTO test (message)\n" +
        "    VALUES ($map.message);")

sql.close()

sql.execute("INSERT INTO test (message)\n" +
        "    VALUES ('$map.message');")

INSERT INTO test (message) VALUES (''); DROP TABLE USERS; --')

 def newUrl = 'http://grails.org'
 def project = 'Grails'
 sql.executeUpdate "update PROJECT set url=$newUrl where name=$project"

 def params = [10, 'Groovy', 'http://groovy.codehaus.org']
 sql.execute 'insert into PROJECT (id, name, url) values (?, ?, ?)', params

import groovy.sql.Sql

def dbUrl      = "jdbc:postgresql://localhost/GroovyTest"
def dbUser     = "Phrancis"
def dbPassword = "test"
def dbDriver   = "org.postgresql.Driver"

def sql = Sql.newInstance(dbUrl, dbUser, dbPassword, dbDriver)

println sql

sql.execute("DROP TABLE IF EXISTS test CASCADE;\n" +
    "CREATE TABLE test (\n"
        +"id SERIAL,\n"
        +"message TEXT\n"
    +");")

def params = ['Hello, World!']

sql.execute("INSERT INTO test (message)\n" +
        "    VALUES (?);", params)

        public override void EnterSubStmt(VBAParser.SubStmtContext context)
        {
            SetCurrentScope(context.ambiguousIdentifier().GetText());
        }

        public override void ExitSubStmt(VBAParser.SubStmtContext context)
        {
            SetCurrentScope();
        }

    public override void EnterArgDefaultValue(VBAParser.ArgDefaultValueContext context)
    {
        Foo(context.ambiguousIdentifier());
    }

    public override void EnterFieldLength(VBAParser.FieldLengthContext context)
    {
        Foo(context.ambiguousIdentifier());
    }

    private void Foo(VBAParser.AmbiguousIdentifierContext context)
    {
        if (context == null)
        {
            return;
        }

        var identifier = Resolve(context, _currentScope);
        identifier.AddReference(CreateReference(context, identifier));

typedef struct TaskControlBlock
{
    int		type:1;
    int		state:7;
    int		priority;
    }

println sql

sql.execute("DROP TABLE IF EXISTS test CASCADE;")

sql.execute(
        "CREATE TABLE test ("
        + "id SERIAL,"
        + "word TEXT,"
        + "number INTEGER,"
        + "decimal NUMERIC,"
        + "datetime TIMESTAMP"
        + ");"
 )

def params = ['Hello, World!', 42, 3.14159, null]

sql.execute("INSERT INTO test (word, number, decimal, datetime)"
            + "VALUES (?,?,?,?);", params)

sql.eachRow('SELECT * FROM test;') { row ->
    println "${row.id}"
        + "${row.word}"

sql.eachRow('SELECT * FROM test;') { row ->
    println "${row.id}"

def sql = Sql.newInstance(dbUrl, dbUser, dbPassword, dbDriver)

println "Sql Instance: " + sql

sql.execute """
        DROP TABLE IF EXISTS test;
        CREATE TABLE test (
            id SERIAL,
            word TEXT,
            number INTEGER,
            decimal NUMERIC,
            datetime TIMESTAMP
            );"""

def params = ['Hello, World!', 42, 3.14159, 'NOW()']

sql.execute """INSERT INTO test (word, number, decimal, datetime)
            VALUES (?,?,?,CAST(? AS TIMESTAMP));""", params

Sql Instance: groovy.sql.Sql@5aa9e4eb

        The row Id is: 1
        The string is: );drop table test;--
        The number is: 42
        The decimal is: 3.14159
        The date-time is: 2015-06-25 04:59:53.546777


Process finished with exit code 0