class DBCrowddata: DBConnection = None def __init__(self, database): if self.DBConnection is None: self.DBConnection = DBConnection(database) def import_data(self, table, json_data ): try: for row in json_data: # check if lat and lon are in the file if ( 'lat' in row and 'lon' in row ) : row['geo'] = "POINT ("+ str(row['lat']) +" "+ str(row['lon']) +")"; insert_keys = "" insert_values = "" for key in row.keys(): insert_keys += key + "," if( key == 'geo'): insert_values += 'ST_GeomFromText(%s, 4326),' else: insert_values += "%s," #remove last comma insert_keys = insert_keys[:-1] insert_values = insert_values[:-1] return self.DBConnection.insert(table, insert_keys, insert_values, row.values()) except Exception, e: print "DBCrowddata.import_data Error: ", e return False
def __init__(self, database): if self.DBConnection is None: self.DBConnection = DBConnection(database)