Examples with Statement com.google.api.ads.admanager.jaxws.v202108.Statement used on opensource projects

Example 21 with Statement

use of com.google.api.ads.admanager.jaxws.v202108.Statement in project googleads-java-lib by googleads.

the class StatementBuilderTest method testWhere_stripsWhere.

@Test
public void testWhere_stripsWhere() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement statement = statementBuilder.where("WHERE id = 12345").toStatement();
    assertEquals("WHERE id = 12345", statement.getQuery());
}

Example 22 with Statement

use of com.google.api.ads.admanager.jaxws.v202108.Statement in project googleads-java-lib by googleads.

the class StatementBuilderTest method testBindVariables_number.

@Test
public void testBindVariables_number() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement statement = statementBuilder.where("number = :number").withBindVariableValue("number", 1).toStatement();
    String_ValueMapEntry entry = statement.getValues(0);
    assertEquals("number", entry.getKey());
    assertEquals(NumberValue.class, entry.getValue().getClass());
    assertEquals("1", ((NumberValue) entry.getValue()).getValue());
}

Example 23 with Statement

use of com.google.api.ads.admanager.jaxws.v202108.Statement in project googleads-java-lib by googleads.

the class StatementBuilderTest method testSelect.

@Test
public void testSelect() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement statement = statementBuilder.select("id, name").toStatement();
    assertEquals("SELECT id, name", statement.getQuery());
}

Example 24 with Statement

use of com.google.api.ads.admanager.jaxws.v202108.Statement in project googleads-java-lib by googleads.

the class StatementBuilderTest method testOrderBy.

@Test
public void testOrderBy() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement statement = statementBuilder.orderBy("id ASC").toStatement();
    assertEquals("ORDER BY id ASC", statement.getQuery());
}

Example 25 with Statement

use of com.google.api.ads.admanager.jaxws.v202108.Statement in project googleads-java-lib by googleads.

the class StatementBuilderTest method testSelect_stripsSelect.

@Test
public void testSelect_stripsSelect() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement statement = statementBuilder.select("SELECT id, name").toStatement();
    assertEquals("SELECT id, name", statement.getQuery());
}