generate-sqlquery

#!/usr/bin/env python

"""
Usage:
  generate-sqlquery <layer-definition> <zoom-level>
  generate-sqlquery --help
  generate-sqlquery --version
Options:
  --help               Show this screen.
  --version            Show version.
"""
import re

from docopt import docopt

import openmaptiles
from openmaptiles.tileset import Layer


def main(args):
    bbox = "ST_SetSRID('BOX3D(-20037508.34 -20037508.34, 20037508.34 20037508.34)'::box3d, 3857)"
    zoom = args['<zoom-level>']
    layer = Layer.parse(args['<layer-definition>'])

    sql = (layer.query
           .replace('!bbox!', bbox)
           .replace('z(!scale_denominator!)', zoom)
           .replace('!pixel_width!', '1'))

    match = re.search(r'\((.*)\) AS *', sql)
    print(match.group(1))


if __name__ == '__main__':
    main(docopt(__doc__, version=openmaptiles.__version__))