public void Can_Save_To_Repository()
{
DatabaseSchema databaseSchema = new DatabaseSchema();
databaseSchema.Name = "TestDB";
databaseSchema.Version = new DatabaseVersion(0,0,0,1);
var schemaMetadata = new DatabaseUtility.Metadata.SchemaMetadata();
databaseSchema.StoredProcedures = schemaMetadata.GetStoredProcedures();
var repository = new DatabaseUtility.Schema.Repository.XmlDatabaseSchemaRepository();
repository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository.xml";
repository.SaveDatabaseSchema(databaseSchema);
}
public void Saved_DatabaseSchema_Equivalent_To_Loaded()
{
DatabaseSchema original = new DatabaseSchema();
original.Name = "TestDB";
original.Version = new DatabaseVersion(0, 0, 0, 1);
var schemaMetadata = new DatabaseUtility.Metadata.SchemaMetadata();
original.StoredProcedures = schemaMetadata.GetStoredProcedures();
var saveRepository = new DatabaseUtility.Schema.Repository.XmlDatabaseSchemaRepository();
saveRepository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository.xml";
saveRepository.SaveDatabaseSchema(original);
var loadRepository = new DatabaseUtility.Schema.Repository.XmlDatabaseSchemaRepository();
loadRepository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository.xml";
var loaded = loadRepository.LoadDatabaseSchema("TestDB", new DatabaseVersion(0, 0, 0, 1));
DatabaseSchemaAssertions.DatabaseSchemasAreEquivalent(original, loaded);
}
public void Can_Load_From_Repository()
{
var repository = new DatabaseUtility.Schema.Repository.XmlDatabaseSchemaRepository();
repository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository.xml";
var databaseSchema = repository.LoadDatabaseSchema("TestDB", new DatabaseVersion(0, 0, 0, 1));
}
