decodes.cwms.CwmsPlatformListIO Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of opendcs Show documentation
A collection of software for aggregatting and processing environmental data such as from NOAA GOES satellites.
The newest version!
/*
 * $Id$
 * 
 * $Log$
 * 
 * This software was written by Cove Software, LLC ("COVE") under contract 
 * to the United States Government. 
 * 
 * No warranty is provided or implied other than specific contractual terms
 * between COVE and the U.S. Government
 * 
 * Copyright 2016 U.S. Army Corps of Engineers, Hydrologic Engineering Center.
 * All rights reserved.
 */
package decodes.cwms;

import ilex.util.Logger;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import decodes.db.DatabaseException;
import decodes.db.Platform;
import decodes.db.PlatformConfig;
import decodes.db.PlatformList;
import decodes.sql.ConfigListIO;
import decodes.sql.DbKey;
import decodes.sql.DecodesDatabaseVersion;
import decodes.sql.EquipmentModelListIO;
import decodes.sql.PlatformListIO;

public class CwmsPlatformListIO extends PlatformListIO
{

	public CwmsPlatformListIO(CwmsSqlDatabaseIO dbio, ConfigListIO configListIO,
		EquipmentModelListIO emlIO)
	{
		super(dbio, configListIO, emlIO);
	}

	public void writePlatform(Platform p)
		throws SQLException, DatabaseException
	{
		if (p.getSite() == null)
			throw new DatabaseException("Cannot save CWMS Platform without Site association.");
		if (p.getConfig() == null)
			throw new DatabaseException("Cannot save CWMS Platform without Config association.");
		super.writePlatform(p);
	}
	
	public void read(PlatformList platformList)
		throws SQLException, DatabaseException
	{
		debug1("Reading CWMS PlatformList...");

		_pList = platformList;
		
		CwmsSqlDatabaseIO cwmsDbIo = (CwmsSqlDatabaseIO)getDbio();

		Statement stmt = createStatement();
		
		// When we read platform list, have to joine it with config so that
		// we implicitely get the predicate to filter on db_office_code.
		String q = "SELECT a.ID, a.Agency, a.IsProduction, " +
			 "a.SiteId, a.ConfigId, a.Description, a.LastModifyTime, " +
			 "a.Expiration, a.platformDesignator " +
			 "FROM Platform a, PlatformConfig b " +
			 "WHERE a.ConfigId = b.id";

		debug3(q);
		ResultSet rs = stmt.executeQuery(q);

		if (rs != null) {
			while (rs.next()) 
			{
				DbKey platformId = DbKey.createDbKey(rs, 1);

				// MJM 20041027 Check to see if this ID is already in the
				// cached platform list and ignore if so. That way, I can
				// periodically refresh the platform list to get any newly
				// created platforms after the start of the routing spec.
				// Refreshing will not affect previously read/used platforms.
				Platform p = _pList.getById(platformId);
				if (p != null)
					continue;

				p = new Platform(platformId);
				_pList.add(p);

				p.agency = rs.getString(2);

				DbKey siteId = DbKey.createDbKey(rs, 4);
				if (!rs.wasNull()) {
					p.setSite(p.getDatabase().siteList.getSiteById(siteId));
				}

				DbKey configId = DbKey.createDbKey(rs, 5);
				if (!rs.wasNull()) 
				{
					PlatformConfig pc = 
						platformList.getDatabase().platformConfigList.getById(
							configId);
					if (pc == null)
					{
						Logger.instance().warning("Platform(" + platformId 
							+ ") references config(" + configId + ")" +
							", which is not in list, will attempt read...");
						try { pc = _configListIO.getConfig(configId); }
						catch(Exception ex)
						{
							Logger.instance().warning("Error reading config("
								+ configId + "): " + ex);
						}
					}
					if (pc != null)
						p.setConfigName(pc.configName);
					p.setConfig(pc);
				}

				String desc = rs.getString(6);
				if (!rs.wasNull()) 
					p.setDescription(desc);

				p.lastModifyTime = getTimeStamp(rs, 7, null);

				p.expiration = getTimeStamp(rs, 8, p.expiration);

				if (getDatabaseVersion() >= DecodesDatabaseVersion.DECODES_DB_7)
					p.setPlatformDesignator(rs.getString(9));

				// Now get the TransportMediums for this platform
//				readTransportMediaPartial(p);
			}
		}
		stmt.close();
		readAllTransportMedia(platformList);
	}

}