gaql-builder 1.0.1

Generating GAQL tool

GAQL Builder

Generating GAQL (Google Ads Query Language) tool, it is not official library. Would you like to build GAQL string more easier, you can use this tool, but it would not be validated entirely for all of posible pairing.

Please follow official documentation.

Requirements

• Python 2.7.13+ / 3.5.3+
• pip

Installation

  $ pip instal gaql-builder

Usage

If you want to generate the following query string,

SELECT
 campaign.id,
 campaign.name
FROM
 campaign
WHERE
 campaign.resource_name = 'customers/1234567/campaigns/987654'

you can use functional call to make it out.

    builder = GAQLBuilder()
    builder.select(['campaign.id', 'campaign.name'])
    builder.resource_from('campaign')
    builder.where("campaign.resource_name = 'customers/1234567/campaigns/987654'")
    builder.to_string()

also, you can use add_where function to add condition.

    builder = GAQLBuilder()
    builder.select(['campaign.id', 'campaign.name'])
    builder.resource_from('campaign')
    builder.add_where(
        field='campaign.resource_name',
        operator='=',
        value="'customers/1234567/campaigns/987654'"
    )

License

MIT