import os
import requests
from config import StagingConfig as conf

from flask import Flask
from flask import request

from ctls import Db
from pub.utils import Coords
from pub.extactJSON import ParserMOI as moiParser
from pub.queryMoi import QueryElevation as moiEvApi
from pub.postgis import Dbconnect as gis3d

#from parser import FeatureTableParser

app = Flask(__name__)
#app.config.from_envvar('YOURAPPLICATION_SETTINGS')
#app.config.from_object(os.environ['APP_SETTINGS'])
app.config.from_object(conf)

dbConf={"host": os.environ.get("PG_HOST", '192.168.11.42'),
            "port": os.environ.get("PG_PORT", '5115'),
            "database": os.environ.get("PG_DATABASE",'pgDMMSNS'),
            "user": os.environ.get("PG_USER",'postgres'),
            "password": os.environ.get("PG_PASS",'simple000'),
            "default97": os.environ.get("DB_SRS",'3826')
    }

dbSRS=os.environ.get("DB_SRS",'3826')

#dbConf= { "host":"192.168.11.42" ,
#    "port":"5115",
#    "database":"pgDMMSNS",
#    "user":"postgres",
#    "password":"simple000"
#}

def printcol(col):
    print(col)


@app.route('/')
def hello():
    return '?1/2/' 

@app.route('/testPostgis')
def testdb():
    gis3d.testSelect();
    return 'done'

@app.route('/resetEv/<string:tablename>')
def resetTableEv(tablename):
    print('running resetEv')
    colgeom= request.args.get('geom',default='geom')

    #poi=  Updateev0 (self.updDB)
    #gis3d.fetchTable(dbConf,
    #      poi.sql_sel() ,
    #      poi)
    procSetTableEv= Db(dbConf)
    procSetTableEv.resetTabelEv(tablename,dbSRS=dbSRS,srcgeom=colgeom,desgeom=colgeom)

    return 'done'
          
@app.route('/getEv/<string:tablename>')
def featureEvby84(tablename):
   
    limit= request.args.get('limit',default=100,type=int)
    colgeom= request.args.get('geom',default='geom')
    print('running getEv')
    print(request.query_string) 
    procGetTableEv=Db(dbConf)
    procGetTableEv.getTableEv(tablename,limit=limit,dbSRS=dbSRS,srcgeom=colgeom,desgeom=colgeom)

    return 'table={}({}-{}),limit={}'.format(tablename,colgeom,dbSRS,(limit))


@app.route('/test') #/<string:name>')
def hello_name():
    proj= request.args.get('proj', default =3857 , type = int)
    
    print( "proj={}".format(proj))
    moiApi= moiEvApi()
    (result, urltext)= moiApi.test()
    if(result.status_code == requests.codes.ok):
         resultjs=moiParser.toJSON(result.text)


    return "testmoi={},\n url={}".format(resultjs,urltext)

@app.route('/transform')
def transformCoord():
    src_proj= request.args.get('src',default=3826,type=int)
    des_proj= request.args.get('des',default=4326,type=int)
    dx = request.args.get('x',default=0,type=float)
    dy = request.args.get('y',default=0,type=float) 
    result=[]
    ret_json ={'message':'input format GET/POST ','src':3826,'des':4326,'x':0,'y':0}
    #print( src_proj,des_proj,dx,dy)
    trans=Coords()
    if(src_proj == 3826 and des_proj==4326):
         result= trans.crs_t97tow84(dx,dy) 
         ret_json= {'x':result[0],'y':result[1],'srid':4326}
    if(src_proj == 4326 and des_proj==3826):
         result= trans.crs_w84tot97(dx,dy)  
         ret_json= {'x':result[0],'y':result[1],'srid':3826} 
    if(src_proj == des_proj):
         ret_json= {'x':dx,'y':dy,'srid':src_proj}
    return ret_json


if __name__ == '__main__':
    print (dbConf)
    moiapi=os.environ.get("MOI_API","TW_DLA_2001084_20061226_20M_3826_DEM")
    moikey=os.environ.get("MOI_KEY","43da4f4a-e2e0-43b0-a432-8b7975f43d9e")

    print('moikey=',moikey)
    print('moiapi=',moiapi)
    app.run(host='0.0.0.0',port=5000)