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

Example 21 with Statement

use of com.google.api.ads.admanager.jaxws.v202205.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());
}

Example 22 with Statement

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

the class StatementBuilderTest method testLimitOffsetDefaults.

@Test
public void testLimitOffsetDefaults() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement initialOffset = statementBuilder.limit(100).toStatement();
    assertEquals("LIMIT 100", initialOffset.getQuery());
    Statement increasedOffset = statementBuilder.increaseOffsetBy(100).toStatement();
    assertEquals("LIMIT 100 OFFSET 100", increasedOffset.getQuery());
}

Example 23 with Statement

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

the class StatementBuilderTest method testFrom_stripsFrom.

@Test
public void testFrom_stripsFrom() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement statement = statementBuilder.from("FROM line_item").toStatement();
    assertEquals("FROM line_item", statement.getQuery());
}

Example 24 with Statement

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

the class StatementBuilderTest method testOrderBy_stripsOrderBy.

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

Example 25 with Statement

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

the class StatementBuilderTest method testLimit.

@Test
public void testLimit() {
    StatementBuilder statementBuilder = new StatementBuilder();
    Statement statement = statementBuilder.limit(500).toStatement();
    assertEquals("LIMIT 500", statement.getQuery());
}