private DatabaseError CheckVersion()
{
VersionCollection ver = new VersionCollection();
IDBCollection icol = ver as IDBCollection;
icol.SetConstraint((long)Version.QueryValues.TableName,
new DBConstraint(DBConstraint.QueryConstraints.Equal, "Version"));
DatabaseError err = ReadRecord(icol);
if (DatabaseError.NoRecordsFound == err || DatabaseError.ExceptionSQL == err)
{
return(m_ErrorCode = DatabaseError.CheckFailed_Unidentifiable);
}
IDBCollectionContents icolcon = ver as IDBCollectionContents;
VersionObject vobj = icolcon.GetRecordInterface(0).GetDataObject() as VersionObject;
if (vobj.VersionNumber != Version.VersionNumber)
{
return(m_ErrorCode = DatabaseError.CheckFailed_IncorrectVersion);
}
return(m_ErrorCode = DatabaseError.NoError);
}
private void MarkTableVersion(IDBCollection col)
{
VersionCollection vcol = new VersionCollection();
IDBCollection ivcol = vcol as IDBCollection;
ivcol.SetConstraint((long)Version.QueryValues.TableName,
new DBConstraint(DBConstraint.QueryConstraints.Equal, col.GetTableName()));
if (Database.DatabaseError.NoError == this.ReadRecord(ivcol))
{
IDBCollectionContents icont = vcol as IDBCollectionContents;
(icont.GetRecordInterface(0).GetDataObject() as VersionObjectInternal).VersionNumber = col.GetVersionNumber();
InsertOrUpdateRecord(vcol);
}
else
{
IDBRecord irec = ivcol.CreateBlankRecord();
VersionObjectInternal obj = irec.GetDataObject() as VersionObjectInternal;
obj.TableName = col.GetTableName();
obj.VersionNumber = col.GetVersionNumber();
InsertOrUpdateRecord(irec);
}
}
private DatabaseError RepairDatabaseVersion()
{
DatabaseError err = m_ErrorCode;
if (err != DatabaseError.CheckFailed_IncorrectVersion &&
err != DatabaseError.CheckFailed_Unidentifiable
)
{
return(m_ErrorCode = DatabaseError.Unexpected);
}
DialogResult ret = DialogResult.No;
if (err == DatabaseError.CheckFailed_Unidentifiable)
{
ret = MessageBox.Show(String.Format(DBUpgradeWarning, "Your database version was not reconized.\r\n"),
"Upgrade Database Version?", MessageBoxButtons.YesNo);
}
else
{
ret = MessageBox.Show(String.Format(DBUpgradeWarning, "Your database version is out-of-date."),
"Upgrade Database Version?", MessageBoxButtons.YesNo);
}
if (ret != DialogResult.Yes)
{
return(m_ErrorCode = DatabaseError.UserAborted);
}
if (err == DatabaseError.CheckFailed_Unidentifiable)
{
this.ExecuteCommand("DROP TABLE " + Version.TableName);
Version v = new Version();
CreateTable(v);
ExecuteCommand(String.Format(
"INSERT INTO Version (TableName) SELECT name FROM sqlite_master; " +
"UPDATE Version SET VersionNumber=0; " +
"UPDATE Version SET VersionNumber={0} WHERE TableName='{1}'",
Version.VersionNumber, Version.TableName));
}
foreach (IDBCollection col in m_Tables)
{
VersionCollection vercol = new VersionCollection();
IDBCollection ivercol = vercol as IDBCollection;
ivercol.SetConstraint((long)Version.QueryValues.TableName,
new DBConstraint(DBConstraint.QueryConstraints.Equal, col.GetTableName()));
DatabaseError colErr = ReadRecord(vercol);
if (DatabaseError.NoError == colErr)
{
IDBCollectionContents iconVercol = vercol as IDBCollectionContents;
IDBRecord rec = iconVercol.GetRecordInterface(0);
VersionObjectInternal obj = rec.GetDataObject() as VersionObjectInternal;
if (obj.VersionNumber == col.GetVersionNumber())
{
Logger.ReportNotice(String.Format("Table '{0}' version is up to date.", col.GetTableName()));
}
else
{
Logger.ReportNotice(String.Format("Table '{0}' version mismatch ({1}!={2}). Recreating",
col.GetTableName(), obj.VersionNumber, col.GetVersionNumber()));
IDBUpgrade icolUpgrade = col as IDBUpgrade;
colErr = icolUpgrade.Upgrade(this, obj.VersionNumber);
if (colErr != DatabaseError.NoError)
{
return(m_ErrorCode = DatabaseError.Unexpected);
}
obj.VersionNumber = col.GetVersionNumber();
this.UpdateRecord(rec);
}
}
else if (DatabaseError.NoRecordsFound == colErr)
{
Logger.ReportNotice(String.Format("Table '{0}' missing. Creating new", col.GetTableName()));
colErr = this.CreateTable(col.CreateBlankRecord());
if (colErr != DatabaseError.NoError)
{
return(m_ErrorCode = DatabaseError.Unexpected);
}
IDBRecord rec = ivercol.CreateBlankRecord();
VersionObjectInternal obj = rec.GetDataObject() as VersionObjectInternal;
obj.TableName = col.GetTableName();
obj.VersionNumber = col.GetVersionNumber();
InsertRecord(rec);
}
else
{
return(m_ErrorCode = DatabaseError.Unexpected);
}
}
return(m_ErrorCode = DatabaseError.NoError);
}
