Package com.google.api.ads.dfp.lib.utils.v201211

Examples of com.google.api.ads.dfp.lib.utils.v201211.StatementBuilder

60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
      int resultSetSize = 0;
      List<Row> allRows = new ArrayList<Row>();
      ResultSet resultSet;
     
      do {
        StatementBuilder statementBuilder =
            new StatementBuilder(selectStatement + " OFFSET " + offset);
       
        // Get all cities.
        resultSet = pqlService.select(statementBuilder.toStatement());

        // Collect all cities from each page.
        allRows.addAll(Arrays.asList(resultSet.getRows()));
       
        // Display results.
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
      // haven't ended and aren't archived.
      String statementText =
          "WHERE status IN ('" + OrderStatus.DRAFT + "','" + OrderStatus.PENDING_APPROVAL
              + "') AND endDateTime >= :today AND isArchived = FALSE LIMIT 500";
      Statement filterStatement =
          new StatementBuilder(statementText).putValue("today",
              DATE_TIME_FORMAT.format(new Date())).toStatement();

      // Set defaults for page and offset.
      OrderPage page = new OrderPage();
      int offset = 0;
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
      // Set the ID of the advertiser (company) to get orders for.
      Long advertiserId = Long.parseLong("INSERT_ADVERTISER_COMPANY_ID_HERE");

      // Create a statement to only select orders for a given advertiser.
      Statement filterStatement =
        new StatementBuilder("WHERE advertiserId = :advertiserId LIMIT 500")
            .putValue("advertiserId", advertiserId).toStatement();

      // Get orders by statement.
      OrderPage page = orderService.getOrdersByStatement(filterStatement);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
          user.getService(DfpService.V201211.COMPANY_SERVICE);

      // Create a statement to only select companies that are advertisers sorted
      // by name.
      Statement filterStatement =
          new StatementBuilder("WHERE type = :type ORDER BY name LIMIT 500")
              .putValue("type", CompanyType.ADVERTISER.toString()).toStatement();

      // Get companies by statement.
      CompanyPage page = companyService.getCompaniesByStatement(filterStatement);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
      LabelServiceInterface labelService = user.getService(DfpService.V201211.LABEL_SERVICE);

      // Create statement text to select active labels.
      String statementText = "WHERE isActive = :isActive LIMIT 500";
      Statement filterStatement =
          new StatementBuilder("").putValue("isActive", true).toStatement();

      // Set defaults for page and offset.
      LabelPage page = new LabelPage();
      int offset = 0;
      List<Long> labelIds = new ArrayList<Long>();
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
      CompanyServiceInterface companyService =
          user.getService(DfpService.V201211.COMPANY_SERVICE);

      // Create a statement to only select companies that are advertisers.
      Statement filterStatement =
          new StatementBuilder("WHERE type = :type LIMIT 500")
              .putValue("type", CompanyType.ADVERTISER.toString()).toStatement();

      // Get the companies by statement.
      CompanyPage page =
          companyService.getCompaniesByStatement(filterStatement);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
      CreativeTemplateServiceInterface creativeTemplateService =
          user.getService(DfpService.V201211.CREATIVE_TEMPLATE_SERVICE);

      // Create a statement to only select system defined creative templates.
      Statement filterStatement =
          new StatementBuilder("WHERE type = :creativeTemplateType LIMIT 500").putValue(
              "creativeTemplateType", CreativeTemplateType.SYSTEM_DEFINED.toString()).toStatement();

      // Get creative templates by statement.
      CreativeTemplatePage page =
          creativeTemplateService.getCreativeTemplatesByStatement(filterStatement);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
      // Set the line item to get LICAs by.
      Long lineItemId = Long.parseLong("INSERT_LINE_ITEM_ID_HERE");

      // Create a statement to only select LICAs for the given lineItem ID.
      Statement filterStatement =
          new StatementBuilder("WHERE lineItemId = :lineItemId LIMIT 500")
              .putValue("lineItemId", lineItemId).toStatement();

      // Get LICAs by statement.
      LineItemCreativeAssociationPage page =
         licaService.getLineItemCreativeAssociationsByStatement(filterStatement);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
      // Get the LabelService.
      LabelServiceInterface labelService = user.getService(DfpService.V201211.LABEL_SERVICE);

      // Create statement text to select active labels.
      Statement filterStatement = new StatementBuilder("WHERE isActive = :isActive LIMIT 500")
          .putValue("isActive", true).toStatement();

      // Get the labels by statement.
      LabelPage page =
          labelService.getLabelsByStatement(filterStatement);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
      // Get the TeamService.
      TeamServiceInterface teamService = user.getService(DfpService.V201211.TEAM_SERVICE);

      // Create a statement to order teams by name.
      Statement filterStatement =
          new StatementBuilder("ORDER BY name LIMIT 500")
              .toStatement();

      // Get teams by statement.
      TeamPage page = teamService.getTeamsByStatement(filterStatement);
View Full Code Here
TOP

Related Classes of com.google.api.ads.dfp.lib.utils.v201211.StatementBuilder

  • com.google.api.ads.dfp.axis.v201208.Statement
  • com.google.api.ads.dfp.axis.v201211.Statement
  • com.google.api.ads.dfp.axis.v201306.Statement
  • com.google.api.ads.dfp.axis.v201308.Statement
  • com.google.api.ads.dfp.axis.v201311.Statement
  • com.google.api.ads.dfp.v201211.DateTime
  • com.google.api.ads.dfp.v201211.ReportJobStatus
  • dfp.axis.v201211.creativewrapperservice.DeactivateCreativeWrappers
  • dfp.axis.v201211.creativewrapperservice.GetActiveCreativeWrappers
  • dfp.axis.v201211.creativewrapperservice.GetAllCreativeWrappers
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.