public async Task Should_Return_TaskComplete_When_Inserting_Values_In_BoalfIndexPath()
{
await Task.Run(() =>
{
var writer = new ProjectionWriter(mockApplicationBuilder.Object);
List <BoalfIndexTable> boalfIndexTable = new List <BoalfIndexTable>()
{
new BoalfIndexTable
{
PartitionKey = "1",
RowKey = "2",
BmuName = "TimeFromAndTimeTo",
BidOfferAcceptanceNumber = "1",
AcceptanceTime = new DateTime(2018, 04, 09, 14, 50, 00),
DeemedBidOfferFlag = "FALSE",
SoFlag = "FALSE",
AmendmentFlag = "ORI",
StorFlag = "TRUE"
}
};
var result = writer.InsertBoalfIndex(boalfIndexTable);
Assert.True(result.IsCompleted);
});
}
public async Task Should_Return_TaskComplete_When_UpLoadingFile_For_Boalf()
{
await Task.Run(() =>
{
var writer = new ProjectionWriter(mockApplicationBuilder.Object);
List <Boalf> boalfs = new List <Boalf>
{
new Boalf
{
BmuName = "TimeFromAndTimeTo",
BidOfferAcceptanceNumber = 1,
AcceptanceTime = new DateTime(2018, 04, 09, 14, 50, 00),
DeemedBidOfferFlag = "FALSE",
SoFlag = "FALSE",
TimeFrom = new DateTime(2018, 04, 09, 14, 00, 00),
TimeTo = new DateTime(2018, 04, 09, 14, 30, 00),
BidOfferLevelFrom = 150,
BidOfferLevelTo = 150,
AmendmentFlag = "ORI",
StorFlag = "TRUE"
}
};
var result = writer.UpLoadFileBoalf(boalfs, "path");
Assert.True(result.IsCompleted);
});
}
public void Guid_Cast_Test()
{
Expression <Func <Entity, Guid> > expression = x => (Guid)x.Values["Count"];
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CAST([count] AS uniqueidentifier)");
}
public void Entity_Property_Table_Alias_Test()
{
Expression <Func <Entity, int> > expression = x => x.Age;
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body, "T"), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("[T].[age]");
}
public void Bool_Cast_Test()
{
Expression <Func <Entity, bool> > expression = x => (bool)x.Values["OptOut"];
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CAST([optout] AS bit)");
}
public void Int_Cast_Test()
{
Expression <Func <Entity, int> > expression = x => (int)x.Values["PubCode"];
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CAST([pubcode] AS int)");
}
public void DateTime_Cast_Test()
{
Expression <Func <Entity, DateTime> > expression = x => (DateTime)x.Values["CreateDate"];
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CAST([createdate] AS datetime)");
}
public void String_Cast_Test()
{
Expression <Func <Entity, string> > expression = x => (string)x.Values["Company"];
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CAST([company] AS nvarchar (MAX))");
}
public void Null_Test()
{
Expression <Func <Entity, object> > expression = x => null;
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("NULL");
}
public void Entity_Dictionary_Property_Test()
{
Expression <Func <Entity, object> > expression = x => x.Values["Company"];
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("[company]");
}
public void Float_Cast_Test()
{
Expression <Func <Entity, float> > expression = x => (float)x.Values["Count"];
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CAST([count] AS real)");
}
public void Coalesce_Test()
{
Expression <Func <Entity, string> > expression = x => x.Name ?? x.NickName;
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("COALESCE([name], [nickname])");
}
public void Fields_Length_Test()
{
Expression <Func <Entity, int> > expression = x => ((string)x.Values["CompanyName"]).Length;
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("LEN(CAST([companyname] AS nvarchar (MAX)))");
}
public void Hash_Sha1_Test()
{
Expression <Func <Entity, byte[]> > expression = x => x.Name.Hash(EntityExtensions.HashAlgorithim.Sha1);
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("HASHBYTES('Sha1', [name])");
}
public void To_Hex_Test()
{
Expression <Func <Entity, string> > expression = x => x.Name.Hash(EntityExtensions.HashAlgorithim.Md5).ToHex();
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CONVERT(nvarchar (MAX), HASHBYTES('Md5', [name]), 1)");
}
public void Guid_ToString_Test()
{
Expression <Func <Entity, string> > expression = x => x.Id.ToString();
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("CAST([id] AS nvarchar (MAX))");
}
public void Trim_Right_Test()
{
Expression <Func <Entity, string> > expression = x => x.Name.TrimEnd();
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("RTRIM([name])");
}
public void Entity_Nullable_Property_Test()
{
Expression <Func <Entity, DateTime?> > expression = x => x.Created;
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("[created]");
}
public void Property_Length_Test()
{
Expression <Func <Entity, int> > expression = x => x.Name.Length;
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(0);
statement.Text.ShouldEqual("LEN([name])");
}
public async Task ProjectionWriter_UpLoadFile_Should_Return_TaskComplete_When_There_Is_No_Exception()
{
await Task.Run(() =>
{
var writer = new ProjectionWriter(mockApplicationBuilder.Object);
var result = writer.UpLoadFile("", "");
Assert.True(result.IsCompleted);
});
}
public void Substring_Test()
{
Expression <Func <Entity, string> > expression = x => x.Name.Substring(10);
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(1);
statement.Parameters.First().Value.ShouldEqual(10);
statement.Text.ShouldEqual(string.Format("RIGHT([name], LEN([name]) - @{0})", statement.Parameters.First().Key));
}
public void Index_Of_Test()
{
Expression <Func <Entity, int> > expression = x => x.Name.IndexOf("hi");
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(1);
statement.Parameters.First().Value.ShouldEqual("hi");
statement.Text.ShouldEqual(string.Format("CHARINDEX(@{0}, [name])", statement.Parameters.First().Key));
}
public void Substring_Fixed_Length_Test()
{
Expression <Func <Entity, string> > expression = x => x.Name.Substring(10, 5);
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(2);
statement.Parameters.First().Value.ShouldEqual(10);
statement.Parameters.Skip(1).First().Value.ShouldEqual(5);
statement.Text.ShouldEqual(string.Format("SUBSTRING([name], @{0}, @{1})", statement.Parameters.First().Key, statement.Parameters.Skip(1).First().Key));
}
public async Task Should_Delete_Blob_On_Passing_BlobName()
{
await Task.Run(() =>
{
var writer = new ProjectionWriter(mockApplicationBuilder.Object);
var result = writer.DeleteBlob("Boalf");
Assert.True(result.IsCompleted);
});
}
public async Task ProjectionWriter_UpdateFileStatus_Should_Return_TaskComplete_When_There_Is_No_Exception()
{
await Task.Run(() =>
{
var writer = new ProjectionWriter(mockApplicationBuilder.Object);
StatusTableEntity statusTableEntity = new StatusTableEntity();
var result = writer.UpdateFileStatus(statusTableEntity);
Assert.True(result.IsCompleted);
});
}
public void Replace_Test()
{
Expression <Func <Entity, string> > expression = x => x.Name.Replace("this", "that");
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(2);
statement.Parameters.First().Value.ShouldEqual("this");
statement.Parameters.Skip(1).First().Value.ShouldEqual("that");
statement.Text.ShouldEqual(string.Format("REPLACE([name], @{0}, @{1})", statement.Parameters.First().Key,
statement.Parameters.Skip(1).First().Key));
}
public void Insert_Test()
{
Expression <Func <Entity, string> > expression = x => x.Name.Insert(10, "that");
var statement = ProjectionWriter <Entity> .CreateStatement(ProjectionVisitor <Entity> .CreateModel(expression.Body), Map);
statement.Parameters.Count().ShouldEqual(2);
statement.Parameters.First().Value.ShouldEqual(10);
statement.Parameters.Skip(1).First().Value.ShouldEqual("that");
statement.Text.ShouldEqual(string.Format("STUFF([name], @{0}, LEN([name]) - @{0}, @{1})", statement.Parameters.First().Key,
statement.Parameters.Skip(1).First().Key));
}
