Examples with ParamsNamed com.github.fabriciofx.cactoos.jdbc.params.ParamsNamed used on opensource projects

Example 1 with ParamsNamed

use of com.github.fabriciofx.cactoos.jdbc.params.ParamsNamed in project cactoos-jdbc by fabriciofx.

the class StatementSelectTest method any.

@Test
public void any() throws Exception {
    try (Servers servers = new Servers(new ServerH2(), new ServerMysql(), new ServerPgsql())) {
        for (final Session session : servers.sessions()) {
            new StatementUpdate(session, new QuerySimple(new Joined(" ", "CREATE TABLE person (id INT, name VARCHAR(30),", "created_at DATE, city VARCHAR(20),", "working BOOLEAN, height DECIMAL(20,2),", "PRIMARY KEY (id))"))).result();
            new StatementBatch(session, new QueryBatch(new Joined(" ", "INSERT INTO person", "(id, name, created_at, city, working, height)", "VALUES (:id, :name, :created_at, :city,", ":working, :height)"), new ParamsNamed(new ParamInt("id", 1), new ParamText("name", "Rob Pike"), new ParamDate("created_at", LocalDate.now()), new ParamText("city", "San Francisco"), new ParamBool("working", true), new ParamDecimal("height", "1.86")), new ParamsNamed(new ParamInt("id", 2), new ParamText("name", "Ana Pivot"), new ParamDate("created_at", LocalDate.now()), new ParamText("city", "Washington"), new ParamBool("working", false), new ParamDecimal("height", "1.62")))).result();
            MatcherAssert.assertThat("Can't select a person name", new ResultSetAsValue<>(new StatementSelect(session, new QuerySimple("SELECT name FROM person"))), new HasValue<>("Rob Pike"));
        }
    }
}

Example 2 with ParamsNamed

use of com.github.fabriciofx.cactoos.jdbc.params.ParamsNamed in project cactoos-jdbc by fabriciofx.

the class StatementBatchTest method batch.

@Test
public void batch() throws Exception {
    try (Servers servers = new Servers(new ServerH2(), new ServerMysql(), new ServerPgsql())) {
        for (final Session session : servers.sessions()) {
            new StatementUpdate(session, new QuerySimple(new Joined(" ", "CREATE TABLE client (id INT,", "name VARCHAR(50), age INT, PRIMARY KEY (id))"))).result();
            new StatementBatch(session, new QueryBatch(new Joined(" ", "INSERT INTO client (id, name, age)", "VALUES (:id, :name, :age)"), new ParamsNamed(new ParamInt("id", 1), new ParamText("name", "Jeff Bridges"), // @checkstyle MagicNumber (1 line)
            new ParamInt("age", 34)), new ParamsNamed(new ParamInt("id", 2), new ParamText("name", "Anna Miller"), // @checkstyle MagicNumber (1 line)
            new ParamInt("age", 26)), new ParamsNamed(// @checkstyle MagicNumber (3 lines)
            new ParamInt("id", 3), new ParamText("name", "Michal Douglas"), new ParamInt("age", 32)))).result();
        }
    }
}

Example 3 with ParamsNamed

use of com.github.fabriciofx.cactoos.jdbc.params.ParamsNamed in project cactoos-jdbc by fabriciofx.

the class StatementSelectTest method select.

@Test
public void select() throws Exception {
    try (Servers servers = new Servers(new ServerH2(), new ServerMysql(), new ServerPgsql())) {
        for (final Session session : servers.sessions()) {
            new StatementUpdate(session, new QuerySimple(new Joined(" ", "CREATE TABLE employee (id INT,", "name VARCHAR(50), birthday DATE,", "address VARCHAR(100),", "married BOOLEAN, salary DECIMAL(20,2),", "PRIMARY KEY (id))"))).result();
            new StatementBatch(session, new QueryBatch(new Joined(" ", "INSERT INTO employee", "(id, name, birthday, address, married, salary)", "VALUES (:id, :name, :birthday, :address,", ":married, :salary)"), new ParamsNamed(new ParamInt("id", 1), new ParamText("name", "John Wick"), new ParamDate("birthday", "1980-08-15"), new ParamText("address", "Boulevard Street, 34"), new ParamBool("married", false), new ParamDecimal("salary", "13456.00")), new ParamsNamed(new ParamInt("id", 2), new ParamText("name", "Adam Park"), new ParamDate("birthday", "1985-07-09"), new ParamText("address", "Sunset Place, 14"), new ParamBool("married", true), new ParamDecimal("salary", "12345.00")))).result();
            MatcherAssert.assertThat(XhtmlMatchers.xhtml(new ResultSetAsXml(new StatementSelect(session, new QuerySimple("SELECT * FROM employee")), "employees", "employee").value()), XhtmlMatchers.hasXPaths("/employees/employee/id[text()='1']", "/employees/employee/name[text()='John Wick']", String.join("", "/employees/employee/address[text()=", "'Boulevard Street, 34']"), "/employees/employee/married[text()='false']", "/employees/employee/salary[text()='13456.00']", "/employees/employee/id[text()='2']", "/employees/employee/name[text()='Adam Park']", String.join("", "/employees/employee/address[text()=", "'Sunset Place, 14']"), "/employees/employee/married[text()='true']", "/employees/employee/salary[text()='12345.00']"));
        }
    }
}