# Common utility functions and variables for working with the local system

# Install dependencies: sudo easy_install psycopg2 pyyaml
import subprocess	# for making system calls
import psycopg2     # for communicating with postgres 
import psycopg2.extras
import yaml, json
import os.path

# Local settings
import settings

# Database settings
db = {'name' : 'wikimaps_atlas', 'host' : settings.host, 'port' : settings.port, 'user' : settings.user, 'password' : settings.password };

# Database shorthand variables
psql_user = "psql -U {}".format(db['user'])
psycopg_connect_atlas= "dbname={} host={} user={} password={}".format(db['name'], db['host'], db['user'], db['password'])
atlas_connect_ogr2ogr= "'host="+db['host']+" user="+db['user']+" dbname="+db['name']+"'"


def bash(command):
    "Runs shell command"
    print "bash: ",command
    subprocess.call(command, shell=True)
    return


def psql_bash(command):
    "Runs a postgres command in the shell"
    psql_command = psql_user + " -c \""+command+";\""
    bash(psql_command)
    return

def psql_atlas_sql(sql_file):
    "Runs a postgres SQL file"
    psql_sql = psql_user + " -d "+atlas_db+" -f "+sql_file
    bash(psql_sql)
    return

def psycopg_atlas(query):
    "Executes a query on the atlas database"
    
    # Connect to atlas
    atlas = psycopg2.connect(psycopg_connect_atlas)
    atlas_cur = atlas.cursor()
    atlas_cur.execute(query)
    atlas.commit()
    
    # Close the connection
    atlas_cur.close()
    atlas.close()
    return

def atlas2json(query):
    "Query the atlas and return the JSON"
    
    # Create a database connection to wikimaps_atlas
    db = psycopg2.connect(psycopg_connect_atlas)
    
    # Create a DictCursor
    cursor = db.cursor(cursor_factory=psycopg2.extras.DictCursor)
    cursor.execute(query)
    
    # Fetch the results of the query
    results = cursor.fetchall()
    
    # Close the connection
    cursor.close()
    db.close()
    
    # Return the results as a json string
    return json.dumps(results)

# Run a postgis2geojson command
# using https://github.com/jczaplew/postgis2geojson
def postgis2geojson(table,output,options=""):
    bash("python ../postgis2geojson/postgis2geojson.py -d {} -u {} -p {} -g geom --topojson -t {} -o {} {}".format(db['name'],db['user'],db['password'],table, output, options) )
    
# Common utility functions and variables for working with the local system

# Install dependencies: sudo easy_install psycopg2 pyyaml
import subprocess	# for making system calls
import psycopg2     # for communicating with postgres 
import psycopg2.extras
import yaml, json
import os.path

# Local settings
import settings

# Database settings
db = {'name' : 'wikimaps_atlas', 'host' : settings.host, 'port' : settings.port, 'user' : settings.user, 'password' : settings.password };

# Database shorthand variables
psql_user = "psql -U {}".format(db['user'])
psycopg_connect_atlas= "dbname={} host={} user={} password={}".format(db['name'], db['host'], db['user'], db['password'])
atlas_connect_ogr2ogr= "'host="+db['host']+" user="+db['user']+" dbname="+db['name']+"'"


def bash(command):
    "Runs shell command"
    print "bash: ",command
    subprocess.call(command, shell=True)
    return


def psql_bash(command):
    "Runs a postgres command in the shell"
    psql_command = psql_user + " -c \""+command+";\""
    bash(psql_command)
    return

def psql_atlas_sql(sql_file):
    "Runs a postgres SQL file"
    psql_sql = psql_user + " -d "+atlas_db+" -f "+sql_file
    bash(psql_sql)
    return

def psycopg_atlas(query):
    "Executes a query on the atlas database"
    
    # Connect to atlas
    atlas = psycopg2.connect(psycopg_connect_atlas)
    atlas_cur = atlas.cursor()
    atlas_cur.execute(query)
    atlas.commit()
    
    # Close the connection
    atlas_cur.close()
    atlas.close()
    return

def atlas2json(query):
    "Query the atlas and return the JSON"
    
    # Create a database connection to wikimaps_atlas
    db = psycopg2.connect(psycopg_connect_atlas)
    
    # Create a DictCursor
    cursor = db.cursor(cursor_factory=psycopg2.extras.DictCursor)
    cursor.execute(query)
    
    # Fetch the results of the query
    results = cursor.fetchall()
    
    # Close the connection
    cursor.close()
    db.close()
    
    # Return the results as a json string
    return json.dumps(results)

# Run a postgis2geojson command
# using https://github.com/jczaplew/postgis2geojson
def postgis2geojson(table,output,options=""):
    bash("python ../postgis2geojson/postgis2geojson.py -H {} -d {} -u {} -p {} -g geom --topojson -t {} -o {} {}".format(db['host'],db['name'],db['user'],db['password'],table, output, options) )
    
Add host