/// <summary>
/// Updates database if the original source file still exists and has
/// been modified.
/// </summary>
protected override void UpdateCore(DateTime t1, DateTime t2, bool minimal)
{
Logger.WriteLine("Checking Excel series " + Name + " (" + ID + ") for updates");
string dir = Path.GetDirectoryName(m_db.DataSource);
if (TextSeries.CanUpdateFromFile(ConnectionString, dir))
{
Logger.WriteLine("Update: File has changed");
ExcelDataReaderSeries g = ExcelDataReaderSeries.CreateFromConnectionString(ConnectionString, dir);
g.Read();
//m_db.Truncate(ID);
ConnectionString = g.ConnectionString;
ConnectionString = ConnectionStringUtility.MakeFileNameRelative(ConnectionString, m_db.DataSource);
m_db.SaveProperties(this);// LastWriteTime proabably changed
m_db.SaveTimeSeriesTable(ID, g, DatabaseSaveOptions.DeleteAllExisting);
}
}
public static ExcelDataReaderSeries CreateFromConnectionString(string connectionString,
string dataPath)
{
string fileName = ConnectionStringUtility.GetToken(connectionString, "FileName", "");
if (!Path.IsPathRooted(fileName))
{
fileName = Path.Combine(dataPath, fileName);
}
ExcelDataReaderSeries rval = new ExcelDataReaderSeries(
fileName,
ConnectionStringUtility.GetToken(connectionString, "SheetName", ""),
ConnectionStringUtility.GetToken(connectionString, "DateColumn", ""),
ConnectionStringUtility.GetToken(connectionString, "ValueColumn", "")
);
return(rval);
}