period, 1442", "region" : "Yamaguchi, Yamaguchi", "position" : "34.190181,131.472917" }, { "name" : "Founder's Hall", "temple" : "Eih¯o-ji", "founded" : "early Muromachi period", "region" : "Tajimi, Kamakura period", "region" : "K¯oya, Wakayama", "position" : "34.213103,135.580397" }, { "name" : "Goeid¯o", "temple" : "Nishi Honganji", "founded" : "Edo period, 1636", "region" : "Kyoto", "position" 751689" }, { "name" : "Golden Hall", "temple" : "Mur¯o-ji", "founded" : "early Heian period", "region" : "Uda, Nara", "position" : "34.536586819357986,136.0395548452301" }, (continues on next page)

per-product sales totals in only the top sales regions. Our model looks like this: class Order(Model): region = TextField() amount = FloatField() product = TextField() quantity = IntegerField() Here th.html]. WITH regional_sales AS ( SELECT region, SUM(amount) AS total_sales FROM orders GROUP BY region ), top_regions AS ( SELECT region FROM regional_sales WHERE total_sales > (SELECT regional_sales) ) SELECT region, product, SUM(quantity) AS product_units, SUM(amount) AS product_sales FROM orders WHERE region IN (SELECT region FROM top_regions) GROUP BY region, product; With

per-product sales totals in only the top sales regions. Our model looks like this: class Order(Model): region = TextField() amount = FloatField() product = TextField() quantity = IntegerField() Here is how postgresql documentation. WITH regional_sales AS ( SELECT region, SUM(amount) AS total_sales FROM orders GROUP BY region ), top_regions AS ( SELECT region FROM regional_sales WHERE total_sales > (SELECT SUM(total_sales) regional_sales) ) SELECT region, product, SUM(quantity) AS product_units, SUM(amount) AS product_sales FROM orders WHERE region IN (SELECT region FROM top_regions) GROUP BY region, product; With Peewee

below to view your application in AWS console: https://console.aws.amazon.com/serverlessrepo/home?region=us-east-1#/published-applications/arn:aws:serverlessrepo:us-east- 1:0123456789:my-serverless-app custom runtime Lambda layers arn:aws:lambda:region:accountId:layer:shared-lib :1 arn:aws:lambda:region:accountId:layer:shared-lib:2 arn:aws:lambda:region:accountId:layer:shared-lib:3 Using Lambda Layers

amazonaws.com FunctionName: Ref: GetHtmlFunction SourceArn: Fn::Sub: arn:aws:execute-api:${AWS::Region}:${AWS::AccountId}:${ServerlessRestApi}/Prod/ANY/* ServerlessRestApiProdStage: Type: AWS::ApiGateway::Stage amazonaws.com FunctionName: Ref: GetHtmlFunction SourceArn: Fn::Sub: arn:aws:execute-api:${AWS::Region}:${AWS::AccountId}:${ServerlessRestApi}/*/ANY/* ServerlessRestApi: Type: AWS::ApiGateway::RestApi x-amazon-apigateway-integration: httpMethod: ANY type: aws_proxy uri: Fn::Sub: arn:aws:apigateway:${AWS::Region}:lambda:path/2015-03- 31/functions/${GetHtmlFunction.Arn}/invocations responses: {} swagger: '2

ModelAdmin.change_form_tem plate]. Your templates can extend the default templates. Let’s say you have “region” as an additional grouping field. For the change list template this might look like this: For the _list.html" %} {% block language_tabs %} {# Here goes the region mark-up #} {% if region_dropdown %} {% endif %} {{ html" %} {% block search %} {# Here goes the region mark-up #} {% if "region" in cl.model_admin.extra_grouping_fields %}

change_list_template and change_form_template. Your templates can extend the default templates. Let’s say you have “region” as an addi- tional grouping field. For the change list template this might look like this: {% extends "admin/cms/grouper/change_list.html" %} {% block language_tabs %} {# Here goes the region mark-up #} {% if region_dropdown %} {% endif %} {{ block.super }} {% endblock %} e_form.html" %} {% block search %} {# Here goes the region mark-up #} {% if "region" in cl.model_admin.extra_grouping_fields %} {% endif %} {{ block.super }}

change_list_template and change_form_template. Your templates can extend the default templates. Let’s say you have “region” as an addi- tional grouping field. For the change list template this might look like this: {% extends "admin/cms/grouper/change_list.html" %} {% block language_tabs %} {# Here goes the region mark-up #} {% if region_dropdown %} {% endif %} {{ block.super }} {% endblock %} e_form.html" %} {% block search %} {# Here goes the region mark-up #} {% if "region" in cl.model_admin.extra_grouping_fields %} {% endif %} {{ block.super }}

ModelAdmin.change_form_tem plate]. Your templates can extend the default templates. Let’s say you have “region” as an additional grouping field. For the change list template this might look like this: For the _list.html" %} {% block language_tabs %} {# Here goes the region mark-up #} {% if region_dropdown %} {% endif %} {{ html" %} {% block search %} {# Here goes the region mark-up #} {% if "region" in cl.model_admin.extra_grouping_fields %}

from • re (str or Pattern) – a regular expression to use for extracting data from the selected CSS region Examples: # HTML snippet:

Color TV

loader.get_css('p.product-name') • re (str or Pattern) – a regular expression to use for extracting data from the selected XPath region Examples: # HTML snippet:

Color TV

loader.get_xpath('//p[@class="product-name"]') also define a custom ACL, custom endpoint, and region name for exported feeds using these settings: • FEED_STORAGE_S3_ACL • AWS_ENDPOINT_URL • AWS_REGION_NAME The default value for the overwrite key