public bool VersionChanged(DbVersionInfo old)
{
if (old == null)
return true;
if (Version != old.Version)
return true;
foreach (var mi in this.Modules) {
var oldM = old.GetModule(mi.Schema, mi.ModuleName);
if (oldM != null && oldM.Version != mi.Version)
return true;
}
return false;
}
// We cannot use regular access thru EntitySession - db info/version loads at the very start of connecting to db;
// the entity app is not ready yet (schema not updated, etc).
public DbVersionInfo LoadDbInfo(DbSettings settings, string appName, Vita.Data.Driver.DbModelLoader loader)
{
var thisSchema = settings.ModelConfig.GetSchema(this.Area);
if (!loader.TableExists(thisSchema, "DbInfo"))
return null;
var dbInfoTableName = settings.Driver.GetFullName(thisSchema, "DbInfo");
var dbModuleInfoTableName = settings.Driver.GetFullName(thisSchema, "DbModuleInfo");
try {
var dbInfo = new DbVersionInfo();
var sql = string.Format("SELECT * FROM {0};", dbInfoTableName);
var dt = loader.ExecuteSelect(sql);
var appRow = dt.Rows.FindRow("AppName", appName);
if (appRow != null) {
dbInfo.InstanceType = (DbInstanceType)appRow.GetAsInt("InstanceType");
var strVersion = appRow.GetAsString("Version");
Version dbVersion;
if (Version.TryParse(strVersion, out dbVersion))
dbInfo.Version = dbVersion;
// 'Values' column appears in v 1.1
if (dt.Columns.Contains("Values")) {
var strValues = appRow.GetAsString("Values");
DeserializeValues(dbInfo, strValues);
}
} //if appRow
//Read modules
sql = string.Format("SELECT * FROM {0};", dbModuleInfoTableName);
dt = loader.ExecuteSelect(sql);
foreach(DataRow row in dt.Rows) {
var moduleName = row.GetAsString("ModuleName");
var schema = row.GetAsString("Schema");
var strModuleVersion = row.GetAsString("Version");
Version v;
if (!Version.TryParse(strModuleVersion, out v))
v = null;
dbInfo.Modules.Add(new ModuleDbVersionInfo(schema, moduleName, v));
}
return dbInfo;
} catch (Exception ex) {
Trace.WriteLine("Failed to load DbInfo record: " + ex.ToLogString());
//Debugger.Break();
return null;
}
}
public bool VersionChanged(DbVersionInfo old)
{
if (old == null)
{
return(true);
}
if (Version != old.Version)
{
return(true);
}
foreach (var mi in this.Modules)
{
var oldM = old.GetModule(mi.Schema, mi.ModuleName);
if (oldM != null && oldM.Version != mi.Version)
{
return(true);
}
}
return(false);
}
private string SerializeValues(DbVersionInfo version)
{
if (version.Values == null || version.Values.Count == 0)
return null;
return string.Join(Environment.NewLine, version.Values.Select(de => de.Key + "=" + de.Value));
}
private void SaveModulesInfo(IEntitySession session, DbVersionInfo dbVersion)
{
var moduleRecs = session.GetEntities<IDbModuleInfo>(take: 1000);
foreach (var mi in dbVersion.Modules) {
var mrec = moduleRecs.FirstOrDefault(r => r.ModuleName == mi.ModuleName && r.Schema == mi.Schema);
if (mrec == null) {
mrec = session.NewEntity<IDbModuleInfo>();
mrec.ModuleName = mi.ModuleName;
mrec.Schema = mi.Schema;
}
mrec.Version = mi.Version.ToString();
}
}
private void DeserializeValues(DbVersionInfo version, string str)
{
version.Values.Clear();
if (string.IsNullOrWhiteSpace(str))
return;
var lines = str.Split(new [] {Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries);
foreach (var line in lines) {
var arr = line.Split('=');
if (arr.Length < 2)
continue;
version.Values[arr[0]] = arr[1];
}
}