import web
import eventsDB2kml
import harvestDataFromEvents
import urllib
urls = (
    '/xpath/(.*)', 'xpath',
    '/species', 'species',
    '/applicants', 'applicants',
    '/locations','locations'
)
app = web.application(urls, globals())

E4D_URL="http://localhost:8180/e4D/"
BASE_URL="http://localhost:8080/"
class locations:
    
    def GET(self):
        
        ret=""
        
        url1=urllib.quote_plus("http://localhost/outApplicants.xml")
        ret+="""
            
            <a href="
            %s?kml1=%s&source1=1"  
            target="e4D">applicants</a><br/>
            """%(E4D_URL,url1)
            
            
        url2=urllib.quote_plus("http://localhost/outResearch.xml")
        ret+="""
            
            <a href="
            %s?kml1=%s&source1=1"  
            target="e4D">research</a><br/>
            """%(E4D_URL,url2)
            
        ret+= """
        <a href="
           %s?kml1=%s&source1=1&kml2=%s&source2=1"  
            target="e4D">both</a><br/>
            """%(E4D_URL,url1,url2)
            
        return ret
        
        
       
class xpath:
 
    def GET(self, path):
        
        if not path: 
            return ""
        
        x = web.input()
        q= x.get("q")
        
        db = eventsDB2kml.DBQuery()
        res= "<events>"+db.searchXPath(path, q)+"</events>"
    
    
       
        hv=harvestDataFromEvents.EventKMLTransformer()
    
    
        #x,cnt=hv.readString(res, ".//research_location/place_information", 0)
        x,cnt=hv.readString(res, ".//place_information", 0)
    
        
    
        s = hv.toKML(x)
        
        return s

class applicants:
    
     def GET(self):
        db = eventsDB2kml.DBQuery()
        q="""
          select 
            cast(xpath('//applicant/name/text()', data) as text[]) AS name 
            from locations
            """
            
        res=db.query(q)
        #hole alle species
        spec=set()
       
        for r in res:
           
            l=r[0] 
            for x in l:
                spec.add(x)
                
        ret=""
        spList=[x for x in spec]
        
        spList.sort()
        for x in spList:
            print x
            ret+="""<a href="/xpath///applicant/name/text()?q=%s">%s</a>"""%(x,x)
            
            url=urllib.quote_plus("%sxpath///applicant/name/text()?q=%s"%(BASE_URL,x))
            ret+="""
            
            <a href="
            %s?kml1=%s&source1=1"  
            target="e4D">e4D</a><br/>
            """%(E4D_URL,url)
        
        return ret
class species:
    
    def GET(self):
        db = eventsDB2kml.DBQuery()
        q="""
          select 
            cast(xpath('//species/text()', data) as text[]) AS name 
            from locations
            """
            
        res=db.query(q)
        #hole alle species
        spec=set()
       
        for r in res:
           
            l=r[0] 
            for x in l:
                spec.add(x)
                
        ret=""
        spList=[x for x in spec]
        
        spList.sort()
        for x in spList:
            print x
            ret+="""<a href="/xpath///species/text()?q=%s">%s</a>"""%(x,x)
            
            url=urllib.quote_plus("%sxpath///species/text()?q=%s"%(BASE_URL,x))
            ret+="""
            
            <a href="
            %s?kml1=%s&source1=1"  
            target="e4D">e4D</a><br/>
            """%(E4D_URL,url)
        
        return ret
          
if __name__ == "__main__":
    app.run()