public void Restore_DrawingsWithSimpleKeyToDatabaseWithRemovedAndModifiedEntities_RestoreAllDependencies()
{
// Arrange
var productionStorageProvider = new SqlServerStorageProvider(productionConnectionString);
var backupStorageProvider = new SqlServerStorageProvider(backupConnectionString);
var metadataProvider = new XmlMetadataProvider(drawingsXmlMetadataLocation);
var metadataWorkspace = metadataProvider.GetMetadataWorkspace();
var entities = SetUpSourceEntities();
EnsureInDatabase(backupConnectionString, metadataWorkspace, entities);
var defectiveEntities = SetUpDefectiveEntities();
EnsureInDatabase(productionConnectionString, metadataWorkspace, defectiveEntities);
var entityName = "Drawings";
var keys = new List <string>()
{
"1"
};
var api = new Api(metadataProvider, productionStorageProvider, backupStorageProvider);
// Act
api.Restore(entityName, keys);
// Assert
foreach (var entity in entities)
{
string message = string.Format("Entity '{0}' could not be backed up.", entity.Name);
Assert.IsTrue(CheckEntityExistsInSqlServerDb(productionConnectionString, metadataWorkspace, entity), message);
}
}
public void Backup_SubDrawingsWithCompositeKeyIsDependent_BackupAllDependencies()
{
// Arrange
var productionStorageProvider = new SqlServerStorageProvider(productionConnectionString);
var backupStorageProvider = new SqlServerStorageProvider(backupConnectionString);
var metadataProvider = new XmlMetadataProvider(drawingsXmlMetadataLocation);
var metadataWorkspace = metadataProvider.GetMetadataWorkspace();
var entities = SetUpSourceEntities();
EnsureInDatabase(productionConnectionString, metadataWorkspace, entities);
var entityName = "SubDrawings";
var keys = new List <string>()
{
"1",
"2",
"300",
"400",
"1"
};
var api = new Api(metadataProvider, productionStorageProvider, backupStorageProvider);
// Act
api.Backup(entityName, keys);
// Assert
foreach (var entity in entities)
{
string message = string.Format("Entity '{0}' could not be backed up.", entity.Name);
Assert.IsTrue(CheckEntityExistsInSqlServerDb(backupConnectionString, metadataWorkspace, entity), message);
}
}
public void Create_Returns_CSDL_WhichValidatesAgainstXSD()
{
TestHelper.EnsureEDM();
var schemas = new XmlSchemaSet();
schemas.Add(null, Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Metadata", "Schemas", "v4.0", "edmx.xsd"));
schemas.Add(null, Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Metadata", "Schemas", "v4.0", "edm.xsd"));
XDocument csdlDocument = XmlMetadataProvider.Create(EntityDataModel.Current, TestHelper.ODataServiceOptions);
csdlDocument.Validate(schemas, (s, a) => Assert.Null(a.Message));
}
public void SerializeMetadataWorkspace_Drawings_SubDrawings_Serialized()
{
// Arrange
MetadataWorkspace metadataWorkspace = CreateDrawingsAndSubdrawingsXmlMetadata();
string xmlMetadataPath = TestSettings.Storage.XmlMetadataGeneratedLocation + @"\Drawings_SubDrawings_Metadata_Generated.xml";
XmlMetadataProvider metadataProvider = new XmlMetadataProvider(xmlMetadataPath);
// Act
metadataProvider.SaveMetadataWorkspace(metadataWorkspace);
// Assert
Assert.IsTrue(File.Exists(xmlMetadataPath), "Drawings_SubDrawings XML metadata is not serialized.");
}
public void Backup_EntityDoesNotExist_ThrowsException()
{
// Arrange
var productionStorageProvider = new SqlServerStorageProvider(productionConnectionString);
var backupStorageProvider = new SqlServerStorageProvider(backupConnectionString);
var metadataProvider = new XmlMetadataProvider(drawingsXmlMetadataLocation);
var entityName = "NotExistingEntity";
var keys = new List <string>();
var api = new Api(metadataProvider, productionStorageProvider, backupStorageProvider);
// Act
api.Backup(entityName, keys);
// Assert
}
public void GetDrawingEntityWithSimpleKeyFromDatabase_EntityExists_AssertsTrue()
{
// Arrange
var productionConnectionString = ConfigurationManager.ConnectionStrings["DrawingsProductionContext"].ConnectionString;
var sqlServerStorageProvider = new SqlServerStorageProvider(productionConnectionString);
var drawingsXmlMetadataLocation = TestSettings.Storage.XmlMetadataManualLocation + @"\Drawings.xml";
var metadataProvider = new XmlMetadataProvider(drawingsXmlMetadataLocation);
var sqlServerRepository = sqlServerStorageProvider.GetRepository(metadataProvider);
var keys = new EntityKey[1];
keys[0] = new EntityKey()
{
Name = "Id",
Value = 30
};
// Act
sqlServerRepository.Read("Drawings", keys);
// Assert
}
public void Backup_SubDrawingsMissingKey_ThrowsException()
{
// Arrange
var productionStorageProvider = new SqlServerStorageProvider(productionConnectionString);
var backupStorageProvider = new SqlServerStorageProvider(backupConnectionString);
var metadataProvider = new XmlMetadataProvider(drawingsXmlMetadataLocation);
var metadataWorkspace = metadataProvider.GetMetadataWorkspace();
var entities = SetUpSourceEntities();
EnsureInDatabase(productionConnectionString, metadataWorkspace, entities);
var entityName = "SubDrawings";
var keys = new List <string>()
{
"1",
"2"
};
var api = new Api(metadataProvider, productionStorageProvider, backupStorageProvider);
// Act
api.Backup(entityName, keys);
}
public void Create_Throws_ArgumentNullException_For_Null_ODataServiceOptions() => Assert.Throws <ArgumentNullException>(() => XmlMetadataProvider.Create(EntityDataModel.Current, null));
public void Create_Throws_ArgumentNullException_For_Null_EntityDataModel() => Assert.Throws <ArgumentNullException>(() => XmlMetadataProvider.Create(null, TestHelper.ODataServiceOptions));
public void Create_Returns_CSDL()
{
TestHelper.EnsureEDM();
ODataServiceOptions serviceOptions = TestHelper.ODataServiceOptions;
var expected = XDocument.Parse($@"<edmx:Edmx xmlns:edmx=""http://docs.oasis-open.org/odata/ns/edmx"" Version=""{serviceOptions.MaxVersion}"">
<edmx:DataServices>
<Schema xmlns=""http://docs.oasis-open.org/odata/ns/edm"" Namespace=""Sample.Model"">
<EnumType Name=""AccessLevel"" UnderlyingType=""Edm.Int32"" IsFlags=""true"">
<Member Name=""None"" Value=""0"" />
<Member Name=""Read"" Value=""1"" />
<Member Name=""Write"" Value=""2"" />
<Member Name=""Delete"" Value=""4"" />
</EnumType>
<EnumType Name=""Colour"" UnderlyingType=""Edm.Int32"" IsFlags=""false"">
<Member Name=""Green"" Value=""1"" />
<Member Name=""Blue"" Value=""2"" />
<Member Name=""Red"" Value=""3"" />
</EnumType>
<ComplexType Name=""OrderDetail"">
<Property Name=""Discount"" Type=""Edm.Decimal"" Nullable=""false"" />
<Property Name=""Quantity"" Type=""Edm.Int16"" Nullable=""false"" />
<Property Name=""UnitPrice"" Type=""Edm.Decimal"" Nullable=""false"" />
<NavigationProperty Name=""Order"" Type=""Sample.Model.Order"" />
<NavigationProperty Name=""Product"" Type=""Sample.Model.Product"" />
</ComplexType>
<EntityType Name=""Categories"">
<Key>
<PropertyRef Name=""Name"" />
</Key>
<Property Name=""Description"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""Name"" Type=""Edm.String"" Nullable=""false"" />
</EntityType>
<EntityType Name=""Customers"">
<Key>
<PropertyRef Name=""CompanyName"" />
</Key>
<Property Name=""Address"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""City"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""CompanyName"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""ContactName"" Type=""Edm.String"" />
<Property Name=""Country"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""LegacyId"" Type=""Edm.Int32"" Nullable=""false"" />
<Property Name=""Phone"" Type=""Edm.String"" />
<Property Name=""PostalCode"" Type=""Edm.String"" Nullable=""false"" />
<NavigationProperty Name=""AccountManager"" Type=""Sample.Model.Employee"" />
<NavigationProperty Name=""Orders"" Type=""Collection(Sample.Model.Order)"" />
</EntityType>
<EntityType Name=""Employees"">
<Key>
<PropertyRef Name=""Id"" />
</Key>
<Property Name=""AccessLevel"" Type=""Sample.Model.AccessLevel"" Nullable=""false"" />
<Property Name=""BirthDate"" Type=""Edm.Date"" Nullable=""false"" />
<Property Name=""EmailAddress"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""Forename"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""Id"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""ImageData"" Type=""Edm.String"" />
<Property Name=""JoiningDate"" Type=""Edm.Date"" Nullable=""false"" />
<Property Name=""LeavingDate"" Type=""Edm.Date"" />
<Property Name=""Surname"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""Title"" Type=""Edm.String"" Nullable=""false"" />
<NavigationProperty Name=""Manager"" Type=""Sample.Model.Manager"" />
</EntityType>
<EntityType Name=""Managers"" BaseType=""Sample.Model.Employee"">
<Property Name=""AnnualBudget"" Type=""Edm.Decimal"" Nullable=""false"" />
<NavigationProperty Name=""Employees"" Type=""Collection(Sample.Model.Employee)"" />
</EntityType>
<EntityType Name=""Orders"">
<Key>
<PropertyRef Name=""OrderId"" />
</Key>
<Property Name=""Date"" Type=""Edm.DateTimeOffset"" Nullable=""false"" />
<Property Name=""Freight"" Type=""Edm.Decimal"" Nullable=""false"" />
<Property Name=""OrderDetails"" Type=""Collection(Sample.Model.OrderDetail)"" />
<Property Name=""OrderId"" Type=""Edm.Int64"" Nullable=""false"" />
<Property Name=""ShipCountry"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""TransactionId"" Type=""Edm.Guid"" Nullable=""false"" />
<NavigationProperty Name=""Customer"" Type=""Sample.Model.Customer"" />
</EntityType>
<EntityType Name=""Products"">
<Key>
<PropertyRef Name=""ProductId"" />
</Key>
<Property Name=""Colour"" Type=""Sample.Model.Colour"" Nullable=""false"" />
<Property Name=""Description"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""Discontinued"" Type=""Edm.Boolean"" Nullable=""false"" />
<Property Name=""Name"" Type=""Edm.String"" Nullable=""false"" />
<Property Name=""Price"" Type=""Edm.Decimal"" Nullable=""false"" />
<Property Name=""ProductId"" Type=""Edm.Int32"" Nullable=""false"" />
<Property Name=""Rating"" Type=""Edm.Single"" Nullable=""false"" />
<Property Name=""ReleaseDate"" Type=""Edm.Date"" Nullable=""false"" />
<NavigationProperty Name=""Category"" Type=""Sample.Model.Category"" />
</EntityType>
<EntityContainer Name=""DefaultContainer"">
<EntitySet Name=""Categories"" EntityType=""Sample.Model.Category"">
<Annotation Term=""Org.OData.Core.V1.ResourcePath"" String=""Categories"" />
<Annotation Term=""Org.OData.Capabilities.V1.InsertRestrictions"">
<Record>
<PropertyValue Property=""Insertable"" Bool=""true"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.UpdateRestrictions"">
<Record>
<PropertyValue Property=""Updatable"" Bool=""true"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.DeleteRestrictions"">
<Record>
<PropertyValue Property=""Deletable"" Bool=""true"" />
</Record>
</Annotation>
</EntitySet>
<EntitySet Name=""Customers"" EntityType=""Sample.Model.Customer"">
<Annotation Term=""Org.OData.Core.V1.ResourcePath"" String=""Customers"" />
<Annotation Term=""Org.OData.Capabilities.V1.InsertRestrictions"">
<Record>
<PropertyValue Property=""Insertable"" Bool=""false"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.UpdateRestrictions"">
<Record>
<PropertyValue Property=""Updatable"" Bool=""true"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.DeleteRestrictions"">
<Record>
<PropertyValue Property=""Deletable"" Bool=""false"" />
</Record>
</Annotation>
</EntitySet>
<EntitySet Name=""Employees"" EntityType=""Sample.Model.Employee"">
<Annotation Term=""Org.OData.Core.V1.ResourcePath"" String=""Employees"" />
<Annotation Term=""Org.OData.Capabilities.V1.InsertRestrictions"">
<Record>
<PropertyValue Property=""Insertable"" Bool=""false"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.UpdateRestrictions"">
<Record>
<PropertyValue Property=""Updatable"" Bool=""false"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.DeleteRestrictions"">
<Record>
<PropertyValue Property=""Deletable"" Bool=""false"" />
</Record>
</Annotation>
</EntitySet>
<EntitySet Name=""Managers"" EntityType=""Sample.Model.Manager"">
<Annotation Term=""Org.OData.Core.V1.ResourcePath"" String=""Managers"" />
<Annotation Term=""Org.OData.Capabilities.V1.InsertRestrictions"">
<Record>
<PropertyValue Property=""Insertable"" Bool=""false"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.UpdateRestrictions"">
<Record>
<PropertyValue Property=""Updatable"" Bool=""false"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.DeleteRestrictions"">
<Record>
<PropertyValue Property=""Deletable"" Bool=""false"" />
</Record>
</Annotation>
</EntitySet>
<EntitySet Name=""Orders"" EntityType=""Sample.Model.Order"">
<Annotation Term=""Org.OData.Core.V1.ResourcePath"" String=""Orders"" />
<Annotation Term=""Org.OData.Capabilities.V1.InsertRestrictions"">
<Record>
<PropertyValue Property=""Insertable"" Bool=""true"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.UpdateRestrictions"">
<Record>
<PropertyValue Property=""Updatable"" Bool=""true"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.DeleteRestrictions"">
<Record>
<PropertyValue Property=""Deletable"" Bool=""true"" />
</Record>
</Annotation>
</EntitySet>
<EntitySet Name=""Products"" EntityType=""Sample.Model.Product"">
<Annotation Term=""Org.OData.Core.V1.ResourcePath"" String=""Products"" />
<Annotation Term=""Org.OData.Capabilities.V1.InsertRestrictions"">
<Record>
<PropertyValue Property=""Insertable"" Bool=""true"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.UpdateRestrictions"">
<Record>
<PropertyValue Property=""Updatable"" Bool=""true"" />
</Record>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.DeleteRestrictions"">
<Record>
<PropertyValue Property=""Deletable"" Bool=""true"" />
</Record>
</Annotation>
</EntitySet>
</EntityContainer>
<Annotations Target=""Sample.Model.DefaultContainer"">
<Annotation Term=""Org.OData.Capabilities.V1.ConformanceLevel"">
<EnumMember>Org.OData.Capabilities.V1.ConformanceLevelType/Minimal</EnumMember>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.SupportedFormats"">
<Collection>
<String>application/json;odata.metadata=none</String>
<String>application/json;odata.metadata=minimal</String>
</Collection>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.SupportedMetadataFormats"">
<Collection>
<String>application/json</String>
<String>text/plain</String>
</Collection>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.AsynchronousRequestsSupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.BatchContinueOnErrorSupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.CrossJoinSupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.IndexableByKey"" Bool=""true"" />
<Annotation Term=""Org.OData.Capabilities.V1.TopSupported"" Bool=""true"" />
<Annotation Term=""Org.OData.Capabilities.V1.SkipSupported"" Bool=""true"" />
<Annotation Term=""Org.OData.Capabilities.V1.ComputeSupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.BatchSupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.FilterFunctions"">
<Collection>
<String>concat</String>
<String>contains</String>
<String>endswith</String>
<String>indexof</String>
<String>length</String>
<String>startswith</String>
<String>substring</String>
<String>tolower</String>
<String>toupper</String>
<String>trim</String>
<String>date</String>
<String>day</String>
<String>fractionalseconds</String>
<String>hour</String>
<String>maxdatetime</String>
<String>mindatetime</String>
<String>minute</String>
<String>month</String>
<String>now</String>
<String>second</String>
<String>totaloffsetminutes</String>
<String>year</String>
<String>ceiling</String>
<String>floor</String>
<String>round</String>
<String>cast</String>
<String>isof</String>
</Collection>
</Annotation>
<Annotation Term=""Org.OData.Capabilities.V1.KeyAsSegmentSupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.QuerySegmentSupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.AnnotationValuesInQuerySupported"" Bool=""false"" />
<Annotation Term=""Org.OData.Capabilities.V1.MediaLocationUpdateSupported"" Bool=""false"" />
</Annotations>
</Schema>
</edmx:DataServices>
</edmx:Edmx>");
XDocument csdlDocument = XmlMetadataProvider.Create(EntityDataModel.Current, serviceOptions);
Assert.Equal(expected.ToString(), csdlDocument.ToString());
}