public void Can_Save_To_Repository() { DatabaseSchema databaseSchema = new DatabaseSchema(); databaseSchema.Name = "Compass"; databaseSchema.Version = new DatabaseVersion(0,0,0,1); var schemaMetadata = new DatabaseUtility.Metadata.SchemaMetadata(); databaseSchema.StoredProcedures = schemaMetadata.GetStoredProcedures(new System.String[] { "p_AppointmentType_Select", "p_AppointmentType_Insert", "p_AppointmentType_Update" }); var repository = new DatabaseUtility.Schema.Repository.DirectoryDatabaseSchemaRepository(); repository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository"; 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.DirectoryDatabaseSchemaRepository(); saveRepository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository"; saveRepository.SaveDatabaseSchema(original); var loadRepository = new DatabaseUtility.Schema.Repository.DirectoryDatabaseSchemaRepository(); loadRepository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository"; 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.DirectoryDatabaseSchemaRepository(); repository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository"; var databaseSchema = repository.LoadDatabaseSchema("TestDB", new DatabaseVersion(0, 0, 0, 1)); }