Changeset 2424 for TI01-discovery


Ignore:
Timestamp:
20/04/07 17:25:44 (12 years ago)
Author:
selatham
Message:

fixed bug in spatiotemp ingest where no dates

File:
1 edited

Legend:

Unmodified
Added
Removed
  • TI01-discovery/trunk/ingestAutomation/OAIBatch/SpaceTimeIngestFromMOLES.py

    r2423 r2424  
    3333        sql = "INSERT INTO spatiotemp (id, coordinates, startdate, enddate) VALUES ( '"+Mid+ "', sbox'(("+west+"d , "+south+"d), ("+east+"d , "+north+"d))', '"+startdate+"', '"+enddate+"');" 
    3434        if str(startdate)=='nostartdate': 
    35             sql=sql.replace("startdate,"," ") 
     35            sql=sql.replace(", startdate,"," ") 
     36            sql=sql.replace(",   'no '"," ") 
    3637            sql=sql.replace("'"+startdate+"',"," ") 
    3738        if str(enddate)=='noenddate': 
    3839            sql=sql.replace("enddate"," ") 
    39             sql=sql.replace("'no '"," ") 
     40            sql=sql.replace(",   'no '"," ") 
    4041            sql=sql.replace("'"+enddate+"',"," ") 
    4142        if str(west)=='null' or str(south)=='null' or str(east)=='null' or str(north)=='null': 
Note: See TracChangeset for help on using the changeset viewer.