public static DataTable ExecuteDataTable(UmbracoDatabase db, string query)
{
db.OpenSharedConnection();
var command = db.Connection.CreateCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = query;
return(ExecuteDataTable(db, command));
}
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();
}
}
private void TestDB(DatabaseContext.DatabaseType dbType, string connectionString, string providerName)
{
//Let's try....
try
{
//Try and create & connect to the Database
//If Advanced provider name etc all in the connection string
if (dbType == DatabaseContext.DatabaseType.Advanced)
{
var db = new UmbracoDatabase(connectionString);
}
else
{
//Providing both connection string & provider name
var db = new UmbracoDatabase(connectionString, providerName);
//Now open the connection to test it out...
//Exception will fire if it can connect
db.OpenSharedConnection();
}
//Show a Success Message Box
MessageBox.Show("Database Connection Sucessful", "Database Connection Test", MessageBoxButton.OK, MessageBoxImage.Information);
//Enable Button
CreateProjectBtn.IsEnabled = true;
}
catch (Exception ex)
{
var error = string.Format("Database Connection Error: {0}", ex.Message);
//Show an Error Message Box
MessageBox.Show(error, "Database Connection Test", MessageBoxButton.OK, MessageBoxImage.Error);
//Disable Button
CreateProjectBtn.IsEnabled = false;
}
}
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();
}
}