#!/usr/bin/env python

"""
Simple script to convert the nscli region list to RST for use in documentation.

Output example::

        AMS
            Amsterdam, Netherlands
        ATL
            Atlanta, Georgia, United States
        AUS
            Austin, Texas, United States
        BCB
            Blacksburg, Virginia, United States
        CVG
            Cincinnati, Ohio, United States
        DEN
            Denver, Colorado, United States
        DFW
            Dallas-Fort Worth, Texas, United States
        FRA
            Frankfurt-am-Main, Germany
        HKG
            Hong Kong Data Center
        HKO
            Hong Kong Office
        IAD
            Dulles, Virginia, United States
        LON
            London, United Kingdom
        ORD
            Chicago, Illinois, United States
        SAT
            San Antonio, Texas, United States
        SFO
            San Francisco, California, United States
        SIN
            Singapore
        SJC
            San Jose, California, United States
        STL
            St Louis, Missouri, United States
        SYD
            Sydney, Australia
        YYZ
            Toronto, Canada
        ZRH
            Zurich, Switzerland
"""

import sqlite3


def main():
    regions = sqlite3.connect("nscli/data/config.db").execute("select name, description from region").fetchall()

    for name, description in regions:
        print(
            "{0}{1}\n"
            "{2}{3}"
            "".format(" " * 8, name, " " * 12, description)
        )


if __name__ == '__main__':
    main()