Python GoogleAds.convert_schema_into_query Examples

Example #1

File: test_google_ads.py Project: charity1475/airbyte

def test_convert_schema_into_query():
    report_name = "ad_group_ad_report"
    query = "SELECT segment.date FROM ad_group_ad WHERE segments.date >= '2020-01-01' AND segments.date <= '2020-03-01' ORDER BY segments.date ASC"
    response = GoogleAds.convert_schema_into_query(SAMPLE_SCHEMA, report_name,
                                                   "2020-01-01", "2020-03-01",
                                                   "segments.date")
    assert response == query

Example #2

def test_convert_schema_into_query():
    report_name = "ad_group_ad_report"
    query = Template("""
          SELECT
            segment.date
          FROM ad_group_ad
          WHERE segments.date > '2020-01-01'
            AND segments.date < '2020-03-01'
          ORDER BY segments.date
      """)
    response = GoogleAds.convert_schema_into_query(SAMPLE_SCHEMA, report_name,
                                                   "2020-01-01", "2020-03-01")
    assert response == query.substitute()