public void GetDatabaseColumnsForTable_UnitTest_HandlesType_ExpectedReturnsGetDatabaseColumnsForTableService()
{
var esb = new GetDatabaseColumnsForTable();
var result = esb.HandlesType();
Assert.AreEqual("GetDatabaseColumnsForTableService", result);
}
public void GetDatabaseColumnsForTable_UnitTest_ExecuteWithNullValues_ExpectedInvalidDataContractException()
{
var esb = new GetDatabaseColumnsForTable();
var actual = esb.Execute(null, null);
Assert.AreEqual(string.Empty, actual);
}
public void GetDatabaseColumnsForTable_Execute_ValidDatabaseSource_WithSchema_OnlyReturnsForThatSchema()
{
var parser = new Mock <IActivityParser>();
parser.Setup(a => a.Parse(It.IsAny <DynamicActivity>())).Returns(new Mock <IDev2Activity>().Object);
CustomContainer.Register(parser.Object);
//------------Setup for test--------------------------
var dbSource = CreateDev2TestingDbSource();
ResourceCatalog.Instance.ResourceSaved = resource => { };
ResourceCatalog.Instance.SaveResource(Guid.Empty, dbSource, "");
var someJsonData = JsonConvert.SerializeObject(dbSource, new JsonSerializerSettings
{
TypeNameHandling = TypeNameHandling.Objects,
TypeNameAssemblyFormatHandling = TypeNameAssemblyFormatHandling.Simple
});
var esb = new GetDatabaseColumnsForTable();
var mockWorkspace = new Mock <IWorkspace>();
mockWorkspace.Setup(workspace => workspace.ID).Returns(Guid.Empty);
//------------Execute Test---------------------------
var actual = esb.Execute(new Dictionary <string, StringBuilder> {
{ "Database", new StringBuilder(someJsonData) }, { "TableName", new StringBuilder("City") }, { "Schema", new StringBuilder("Warewolf") }
}, mockWorkspace.Object);
//------------Assert Results-------------------------
var value = actual.ToString();
Assert.IsFalse(string.IsNullOrEmpty(value));
var result = JsonConvert.DeserializeObject <DbColumnList>(actual.ToString(), new JsonSerializerSettings
{
TypeNameHandling = TypeNameHandling.Objects,
TypeNameAssemblyFormatHandling = TypeNameAssemblyFormatHandling.Simple
});
Assert.IsFalse(result.HasErrors, $"error executing sql query: {result.Errors}");
Assert.AreEqual(4, result.Items.Count);
// Check Columns Returned ;)
Assert.IsFalse(result.Items[0].IsNullable);
Assert.IsTrue(result.Items[0].IsAutoIncrement);
StringAssert.Contains(result.Items[0].ColumnName, "CityID");
StringAssert.Contains(result.Items[0].SqlDataType.ToString(), "Int");
Assert.IsFalse(result.Items[1].IsNullable);
Assert.IsFalse(result.Items[1].IsAutoIncrement);
StringAssert.Contains(result.Items[1].ColumnName, "Description");
StringAssert.Contains(result.Items[1].SqlDataType.ToString(), "VarChar");
Assert.IsFalse(result.Items[2].IsNullable);
Assert.IsFalse(result.Items[2].IsAutoIncrement);
StringAssert.Contains(result.Items[2].ColumnName, "CountryID");
StringAssert.Contains(result.Items[2].SqlDataType.ToString(), "Int");
Assert.IsTrue(result.Items[3].IsNullable);
Assert.IsFalse(result.Items[3].IsAutoIncrement);
StringAssert.Contains(result.Items[3].ColumnName, "TestCol");
StringAssert.Contains(result.Items[3].SqlDataType.ToString(), "NChar");
}
public void GetAuthorizationContextForService_ShouldReturnContext()
{
//------------Setup for test--------------------------
var getDatabaseColumnsForTable = new GetDatabaseColumnsForTable();
//------------Execute Test---------------------------
var resId = getDatabaseColumnsForTable.GetAuthorizationContextForService();
//------------Assert Results-------------------------
Assert.AreEqual(AuthorizationContext.Any, resId);
}
public void GetResourceID_ShouldReturnEmptyGuid()
{
//------------Setup for test--------------------------
var getDatabaseColumnsForTable = new GetDatabaseColumnsForTable();
//------------Execute Test---------------------------
var resId = getDatabaseColumnsForTable.GetResourceID(new Dictionary <string, StringBuilder>());
//------------Assert Results-------------------------
Assert.AreEqual(Guid.Empty, resId);
}
public void GetDatabaseColumnsForTable_Execute_ValidDatabaseSource_WithSchema_OnlyReturnsForThatSchema()
{
//------------Setup for test--------------------------
var dbSource = CreateDev2TestingDbSource();
ResourceCatalog.Instance.SaveResource(Guid.Empty, dbSource);
string someJsonData = JsonConvert.SerializeObject(dbSource, new JsonSerializerSettings
{
TypeNameHandling = TypeNameHandling.Objects,
TypeNameAssemblyFormat = System.Runtime.Serialization.Formatters.FormatterAssemblyStyle.Simple
});
var esb = new GetDatabaseColumnsForTable();
var mockWorkspace = new Mock <IWorkspace>();
mockWorkspace.Setup(workspace => workspace.ID).Returns(Guid.Empty);
//------------Execute Test---------------------------
var actual = esb.Execute(new Dictionary <string, StringBuilder> {
{ "Database", new StringBuilder(someJsonData) }, { "TableName", new StringBuilder("City") }, { "Schema", new StringBuilder("Warewolf") }
}, mockWorkspace.Object);
//------------Assert Results-------------------------
var value = actual.ToString();
Assert.IsFalse(string.IsNullOrEmpty(value));
var result = JsonConvert.DeserializeObject <DbColumnList>(actual.ToString(), new JsonSerializerSettings
{
TypeNameHandling = TypeNameHandling.Objects,
TypeNameAssemblyFormat = System.Runtime.Serialization.Formatters.FormatterAssemblyStyle.Simple
});
Assert.AreEqual(4, result.Items.Count);
// Check Columns Returned ;)
Assert.IsFalse(result.Items[0].IsNullable);
Assert.IsTrue(result.Items[0].IsAutoIncrement);
StringAssert.Contains(result.Items[0].ColumnName, "CityID");
StringAssert.Contains(result.Items[0].SqlDataType.ToString(), "Int");
Assert.IsFalse(result.Items[1].IsNullable);
Assert.IsFalse(result.Items[1].IsAutoIncrement);
StringAssert.Contains(result.Items[1].ColumnName, "Description");
StringAssert.Contains(result.Items[1].SqlDataType.ToString(), "VarChar");
Assert.IsFalse(result.Items[2].IsNullable);
Assert.IsFalse(result.Items[2].IsAutoIncrement);
StringAssert.Contains(result.Items[2].ColumnName, "CountryID");
StringAssert.Contains(result.Items[2].SqlDataType.ToString(), "Int");
Assert.IsTrue(result.Items[3].IsNullable);
Assert.IsFalse(result.Items[3].IsAutoIncrement);
StringAssert.Contains(result.Items[3].ColumnName, "TestCol");
StringAssert.Contains(result.Items[3].SqlDataType.ToString(), "NChar");
}
public void GetDatabaseColumnsForTable_UnitTest_ExecuteWithNoDatabaseInValues_ExpectedHasErrors()
{
var esb = new GetDatabaseColumnsForTable();
var actual = esb.Execute(new Dictionary <string, StringBuilder> {
{ "Database", null }
}, null);
Assert.IsNotNull(actual);
var result = JsonConvert.DeserializeObject <DbColumnList>(actual.ToString());
Assert.IsTrue(result.HasErrors);
Assert.AreEqual("No database set.", result.Errors);
}
public void GetDatabaseColumnsForTable_UnitTest_CreateServiceEntry_ExpectedReturnsDynamicService()
{
var esb = new GetDatabaseColumnsForTable();
var result = esb.CreateServiceEntry();
Assert.AreEqual(esb.HandlesType(), result.Name);
Assert.AreEqual("<DataList><Database ColumnIODirection=\"Input\"/><TableName ColumnIODirection=\"Input\"/><Dev2System.ManagmentServicePayload ColumnIODirection=\"Both\"></Dev2System.ManagmentServicePayload></DataList>", result.DataListSpecification.ToString());
Assert.AreEqual(1, result.Actions.Count);
var serviceAction = result.Actions[0];
Assert.AreEqual(esb.HandlesType(), serviceAction.Name);
Assert.AreEqual(enActionType.InvokeManagementDynamicService, serviceAction.ActionType);
Assert.AreEqual(esb.HandlesType(), serviceAction.SourceMethod);
}
