#!/usr/bin/python
#
# Copyright 2012 Google Inc. All Rights Reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

"""This code example gets suggested ad units that have more than 50 requests
using a filter statement. This feature is only available to DFP premium solution
networks."""

__author__ = 'api.shamjeff@gmail.com (Jeff Sham)'

# Locate the client library. If module was installed via "setup.py" script, then
# the following two lines are not needed.
import os
import sys
sys.path.insert(0, os.path.join('..', '..', '..', '..'))

# Import appropriate classes from the client library.
from adspygoogle import DfpClient


# Initialize client object.
client = DfpClient(path=os.path.join('..', '..', '..', '..'))

# Initialize appropriate service.
suggested_ad_unit_service = client.GetService(
    'SuggestedAdUnitService', version='v201206')

values = [{
    'key': 'numRequests',
    'value': {
        'xsi_type': 'NumberValue',
        'value': '50'
    }
}]

filter_statement = {'query': 'WHERE numRequests > :numRequests LIMIT 500',
                    'values': values}

# Get suggested ad units by statement.
response = suggested_ad_unit_service.GetSuggestedAdUnitsByStatement(
    filter_statement)[0]
suggested_ad_units = []
if 'results' in response:
  suggested_ad_units = response['results']

# Display results.
for suggested_ad_unit in suggested_ad_units:
  print ('Ad unit with id \'%s\', and number of requests \'%s\' was found.'
         % (suggested_ad_unit['id'], suggested_ad_unit['numRequests']))

print
print 'Number of results found: %s' % len(suggested_ad_units)
