private void UpgradeTo0920(int dbVersion)
{
const string upgradeVersion1String = "0.9.2";
if (dbVersion < Application.ParseVersion(upgradeVersion1String))
{
// delete duplicates
_logger.InfoFormat("Performing WU History database upgrade to v{0}...", upgradeVersion1String);
var duplicateDeleter = new DuplicateDeleter(this, _logger);
OnUpgradeExecuting(duplicateDeleter);
// add columns to WuHistory table
AddProteinColumns();
// update the WuHistory table with protein info
var proteinDataUpdater = new ProteinDataUpdater(this, _proteinService);
OnUpgradeExecuting(proteinDataUpdater);
// set database version
SetDatabaseVersion(upgradeVersion1String);
}
}
public Task UpdateProteinDataAsync(ProteinUpdateType type, long updateArg, CancellationToken cancellationToken, IProgress<ProgressChangedEventArgs> progress)
{
// update the WuHistory table with protein info
var proteinDataUpdater = new ProteinDataUpdater(this, _proteinService);
proteinDataUpdater.UpdateType = type;
proteinDataUpdater.UpdateArg = updateArg;
return proteinDataUpdater.ExecuteAsync(cancellationToken, progress);
}
public void Upgrade()
{
string dbVersionString = "0.0.0.0";
if (TableExists(SqlTable.Version))
{
string versionFromTable = GetDatabaseVersion();
if (!String.IsNullOrEmpty(versionFromTable))
{
dbVersionString = versionFromTable;
}
}
else
{
CreateTable(SqlTable.Version);
}
int dbVersion = Application.ParseVersion(dbVersionString);
_logger.Info("WU History database v{0}", dbVersionString);
bool upgraded = false;
const string upgradeVersion1String = "0.9.2.0";
if (dbVersion < Application.ParseVersion(upgradeVersion1String))
{
using (var trans = Connection.BeginTransaction())
{
_logger.Info("Performing WU History database upgrade to v{0}...", upgradeVersion1String);
var duplicateDeleter = new DuplicateDeleter(this, _logger);
OnUpgradeExecuting(duplicateDeleter);
UpgradeWuHistory1();
var proteinDataUpdater = new ProteinDataUpdater(this, _proteinDictionary);
OnUpgradeExecuting(proteinDataUpdater);
upgraded = true;
trans.Commit();
}
}
if (upgraded)
{
SetDatabaseVersion(Application.VersionWithRevision);
}
}