public static DataTable ExecuteDataTable(UmbracoDatabase db, IDbCommand command)
{
var reader = command.ExecuteReader();
var table = new DataTable();
table.Load(reader);
db.CloseSharedConnection();
return(table);
}
public bool PreviousMigrationsHaveFinishedCleanly()
{
try
{
UmbracoDatabase.OpenSharedConnection();
using (var transaction = GetTransaction())
{
var result = UmbracoDatabase.FirstOrDefault <MigrationHistory>("WHERE Completed = 0");
var previousMigrationsHaveFinishedCleanly = result == null;
transaction.Complete();
return(previousMigrationsHaveFinishedCleanly);
}
}
finally
{
UmbracoDatabase.CloseSharedConnection();
}
}
public bool HasMigrationExecuted(IUmbracoMigration migration)
{
var migrationName = migration.GetType().Name;
try
{
UmbracoDatabase.OpenSharedConnection();
using (var transaction = GetTransaction())
{
var migrationHistory = UmbracoDatabase.FirstOrDefault <MigrationHistory>("WHERE Name = @Name", new { Name = migrationName });
var hasMigrationExecuted = migrationHistory != null;
Log.Debug(string.Format("HasMigrationExecuted for {0} is {1}", migrationName, hasMigrationExecuted));
transaction.Complete();
return(hasMigrationExecuted);
}
}
finally
{
UmbracoDatabase.CloseSharedConnection();
}
}
public void FlagMigrationAsStarted(IUmbracoMigration migration)
{
try
{
UmbracoDatabase.OpenSharedConnection();
using (var transaction = GetTransaction())
{
var row = new MigrationHistory
{
Completed = false,
Name = migration.GetType().Name,
Timestamp = DateTime.UtcNow
};
UmbracoDatabase.Insert(row);
transaction.Complete();
}
}
finally
{
UmbracoDatabase.CloseSharedConnection();
}
}