本文整理了Java中com.google.api.ads.admanager.lib.utils.QueryBuilder类的一些代码示例，展示了QueryBuilder类的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。QueryBuilder类的具体详情如下：
包路径：com.google.api.ads.admanager.lib.utils.QueryBuilder
类名称：QueryBuilder

QueryBuilder介绍

[英]QueryBuilder allows for queries to be constructed in parts.
[中]QueryBuilder允许部分构造查询。

代码示例

代码示例来源：origin: googleads/googleads-java-lib

/**
 * Constructs a statement builder.
 */
public StatementBuilder() {
 this(new QueryBuilder<Value>());
}

代码示例来源：origin: googleads/googleads-java-lib

/**
 * Sets the statement WHERE clause in the form of<br><br>
 * <code>"WHERE &lt;condition&gt; {[AND | OR] &lt;condition&gt; ...}"</code>
 * <br><br>
 * e.g. "a = b OR b = c". The "WHERE " keyword will be ignored.
 * @param conditions the statement query without "WHERE"
 * @return a reference to this object
 */
@Override
public QueryBuilder<V> where(String conditions) {
 Preconditions.checkNotNull(conditions, "WHERE clause cannot be null");
 conditions = removeKeyword(conditions, WHERE);
 this.where = conditions;
 return this;
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_notPqlTable() {
 String expectedQuery =
   "WHERE a = b AND b = c ORDER BY a ASC, b DESC LIMIT 200 OFFSET 0";
 String query = new QueryBuilder<Object>()
   .where("a = b AND b = c")
   .orderBy("a ASC, b DESC")
   .limit(200)
   .offset(0)
   .buildQuery();
 assertEquals(expectedQuery, query);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_pqlTable() {
 String expectedQuery =
   "SELECT * FROM table WHERE a = b AND b = c ORDER BY a ASC, b DESC LIMIT 200 OFFSET 0";
 String query = new QueryBuilder<Object>()
   .select("*")
   .from("table")
   .where("a = b AND b = c")
   .orderBy("a ASC, b DESC")
   .limit(200)
   .offset(0)
   .buildQuery();
 assertEquals(expectedQuery, query);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_limitAndOffset() {
 String expectedQuery = "LIMIT 500 OFFSET 0";
 String query = new QueryBuilder<Object>()
   .limit(500)
   .offset(0)
   .buildQuery();
 assertEquals(expectedQuery, query);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_justLimit() {
 String expectedQuery = "LIMIT 500";
 String query = new QueryBuilder<Object>()
   .limit(500)
   .buildQuery();
 assertEquals(expectedQuery, query);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_withBindingVariable() {
 String key = "key";
 String value = "value";
 QueryBuilder<Object> builder = new QueryBuilder<Object>();
 builder.withBindVariableValue(key, value);
 assertEquals(value, builder.getBindVariableMap().get(key));
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_OffsetWithoutLimit() {
 QueryBuilder<Object> builder = new QueryBuilder<Object>().offset(500);
 thrown.expect(IllegalStateException.class);
 thrown.expectMessage("OFFSET cannot be set if LIMIT is not set.");
 builder.buildQuery();
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
 public void testBuildQuery_withBindVariableValues() {
  String key = "key";
  String value = "value";
  String key2 = "key2";
  String value2 = "value2";

  Map<String, Object> valueMap = Maps.newHashMap();
  valueMap.put(key, value);
  valueMap.put(key2, value2);

  QueryBuilder<Object> builder = new QueryBuilder<Object>();
  builder.withBindVariableValues(valueMap);

  assertEquals(value, builder.getBindVariableMap().get(key));
  assertEquals(value2, builder.getBindVariableMap().get(key2));
 }
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_empty() {
 String expectedQuery = "";
 String query = new QueryBuilder<Object>()
   .buildQuery();
 assertEquals(expectedQuery, query);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testSelect_null() {
 QueryBuilder<Object> builder = new QueryBuilder<Object>();
 thrown.expect(NullPointerException.class);
 thrown.expectMessage(Matchers.equalTo("SELECT clause cannot be null"));
 builder.select(null);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testWhere_null() {
 QueryBuilder<Object> builder = new QueryBuilder<Object>();
 thrown.expect(NullPointerException.class);
 thrown.expectMessage("WHERE clause cannot be null");
 builder.where(null);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testFrom_null() {
 QueryBuilder<Object> builder = new QueryBuilder<Object>();
 thrown.expect(NullPointerException.class);
 thrown.expectMessage("FROM clause cannot be null");
 builder.from(null);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testOrderBy_null() {
 QueryBuilder<Object> builder = new QueryBuilder<Object>();
 thrown.expect(NullPointerException.class);
 thrown.expectMessage("ORDER BY clause cannot be null");
 builder.orderBy(null);
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_removeLimitAndOffset() {
 String expectedQueryBefore = "WHERE a = b ORDER BY a LIMIT 500 OFFSET 0";
 String expectedQueryAfter = "WHERE a = b ORDER BY a";
 QueryBuilder<Object> queryBuilder = new QueryBuilder<Object>()
   .limit(500)
   .offset(0)
   .where("a = b")
   .orderBy("a");
 assertEquals(expectedQueryBefore, queryBuilder.buildQuery());
 queryBuilder.removeLimitAndOffset();
 assertEquals(expectedQueryAfter, queryBuilder.buildQuery());
}

代码示例来源：origin: googleads/googleads-java-lib

@Test
public void testBuildQuery_noOffset() {
 String expectedQuery =
   "WHERE a = b AND b = c ORDER BY a ASC, b DESC LIMIT 200";
 String query = new QueryBuilder<Object>()
   .where("a = b AND b = c")
   .orderBy("a ASC, b DESC")
   .limit(200)
   .buildQuery();
 assertEquals(expectedQuery, query);
}

代码示例来源：origin: googleads/googleads-java-lib

/**
 * Constructs a statement builder.
 */
public StatementBuilder() {
 this(new QueryBuilder<Value>());
}

代码示例来源：origin: com.google.api-ads/ads-lib

/**
 * Sets the statement SELECT clause in the form of "a,b" or "*".
 * Only necessary for statements being sent to the
 * {@code PublisherQueryLanguageService}. The "SELECT " keyword will be
 * ignored.
 *
 * @param columns the statement select clause without "SELECT"
 * @return a reference to this object
 */
@Override
public QueryBuilder<V> select(String columns) {
 Preconditions.checkNotNull(columns, "SELECT clause cannot be null");
 columns = removeKeyword(columns, SELECT);
 this.select = columns;
 return this;
}

代码示例来源：origin: googleads/googleads-java-lib

/**
 * Constructs a statement builder.
 */
public StatementBuilder() {
 this(new QueryBuilder<Value>());
}

代码示例来源：origin: com.google.api-ads/ads-lib

/**
 * Sets the statement FROM clause in the form of "table".
 * Only necessary for statements being sent to the
 * {@code PublisherQueryLanguageService}. The "FROM " keyword will be
 * ignored.
 *
 * @param table the statement from clause without "FROM"
 * @return a reference to this object
 */
@Override
public QueryBuilder<V> from(String table) {
 Preconditions.checkNotNull(table, "FROM clause cannot be null");
 table = removeKeyword(table, FROM);
 this.from = table;
 return this;
}