stdout.
"""
-from optparse import OptionParser
import os
import pgdb
import site
# Needed for the imports that follow.
site.addsitedir(os.path.dirname(os.path.abspath(sys.argv[0])) + '/../src')
+import CLI
import Configuration.Defaults
import ExitCodes
import GPS
are provided for the database information and the output is written
to stdout.
"""
-# -h (help) Conflicts with -h HOSTNAME
-parser = OptionParser(add_help_option = False)
-# Use this module's docstring as the description.
-parser.description = __doc__
-
-parser.add_option('-h',
- '--host',
- help='The hostname/address where the database is located.',
- default=Configuration.Defaults.DATABASE_HOST)
-
-parser.add_option('-d',
- '--database',
- help='The database in which the population data are stored.',
- default=Configuration.Defaults.DATABASE_NAME)
-
-parser.add_option('-U',
- '--username',
- help='The username who has access to the database.',
- default=Configuration.Defaults.DATABASE_USERNAME)
+parser = CLI.default_option_parser()
+# Use this module's docstring as the description.
+parser.description = __doc__.strip()
(options, args) = parser.parse_args()
-
def GenerateRedStyles(alpha='7f'):
"""
Generate 256 styles (0-255), each corresponding to a shade of red.
query = """
-SELECT tiger.blkidfp00, population_density, AsKML(the_geom) as geom
- FROM (sf1_blocks INNER JOIN tiger
- ON sf1_blocks.tiger_blkidfp00=tiger.blkidfp00);
+SELECT tiger_blocks.blkidfp00, population_density, AsKML(the_geom) as geom
+ FROM (sf1_blocks INNER JOIN tiger_blocks
+ ON sf1_blocks.blkidfp00 = tiger_blocks.blkidfp00);
"""
cursor.execute(query)
doc.children.append(placemark)
-print doc.to_kml()
+doc.print_kml()
conn.close()