public void GetDataAdapter_WithTableMappings_TableMappingsCreated()
{
IDbDataAdapter adapter;
IDbCommand command;
string[] tableNames;
command = CreateCommand(TestDataTestHelper.GetString(), CommandType.StoredProcedure);
tableNames = TestDataTestHelper.GetStrings(arraySize: 3);
adapter = GetHelperInstance().CreateDataAdapter(command, tableNames);
Assert.IsNotNull(adapter);
Assert.IsNotNull(adapter.TableMappings);
Assert.AreEqual(tableNames.Length, adapter.TableMappings.Count);
for (int i = 0; i < tableNames.Length; i++)
{
DataTableMapping tableMapping;
Assert.IsNotNull(adapter.TableMappings[i]);
Assert.IsInstanceOfType(adapter.TableMappings[i], typeof(DataTableMapping));
tableMapping = (DataTableMapping)adapter.TableMappings[i];
Assert.AreEqual(tableNames[i], tableMapping.DataSetTable);
if (i > 0)
{
Assert.AreEqual($"Table{i}", tableMapping.SourceTable);
}
else
{
// Table0 is named Table
Assert.AreEqual("Table", tableMapping.SourceTable);
}
}
}
public void InsertAt_InsertItemInMiddle_ItemIsInserted()
{
string newValueA;
string newValueB;
string[] result;
string[] values;
values = TestDataTestHelper.GetStrings(arraySize: 5);
newValueA = TestDataTestHelper.GetString();
newValueB = TestDataTestHelper.GetString();
Assert.AreEqual(5, values.Length);
result = values.InsertAt(2, newValueA);
Assert.AreEqual(values[0], result[0]);
Assert.AreEqual(values[1], result[1]);
Assert.AreEqual(newValueA, result[2]);
Assert.AreEqual(values[2], result[3]);
Assert.AreEqual(values[3], result[4]);
Assert.AreEqual(values[4], result[5]);
result = result.InsertAt(4, newValueB);
Assert.AreEqual(values[0], result[0]);
Assert.AreEqual(values[1], result[1]);
Assert.AreEqual(newValueA, result[2]);
Assert.AreEqual(values[2], result[3]);
Assert.AreEqual(newValueB, result[4]);
Assert.AreEqual(values[3], result[5]);
Assert.AreEqual(values[4], result[6]);
}
public void List_StandardOperation_IsValid()
{
ConcurrentList <string> theList;
theList = new ConcurrentList <string>();
Assert.IsTrue(ListTestHelper <string> .TestAll(theList, () => { return(TestDataTestHelper.GetString()); }));
}
private void ExecuteCommandTest(CommandType commandType)
{
IDbCommand command;
string commandName;
commandName = TestDataTestHelper.GetString();
command = CreateCommand(commandName, commandType);
TestCommand(command, commandName, commandType);
}
public void CreateCommand_DefaultParameters_CommandCreatedCorrectly()
{
IDbCommand command;
string commandName;
commandName = TestDataTestHelper.GetString();
command = CreateCommand(commandName, CommandType.StoredProcedure);
TestCommand(command, commandName, CommandType.StoredProcedure);
}
public void CreateConnection_WithConnectionString_ConnectionCreatedCorrectly()
{
IDbConnection connection;
string connectionString;
connectionString = $"Server={TestDataTestHelper.GetString()}";
connection = GetHelperInstance().CreateConnection(connectionString);
TestConnention(connection, connectionString);
}
public void TryGetDynamicCodeOutput_InvalidCode_IsValidResult()
{
bool result;
result = DynamicCodeExecutor.TryGetDynamicCodeOutput($"{TestDataTestHelper.GetString()}", out object returnedObject, out string warningText);
Assert.IsFalse(result);
Assert.IsNull(returnedObject);
Assert.IsNotNull(warningText);
}
private void ExecuteParameterTest(DbType specifiedDbType, TDbTypeEnum expectedDbType, object value, ParameterDirection parameterDirection = ParameterDirection.Input, int parameterSize = 0)
{
IDbDataParameter parameter;
string parameterName;
parameterName = TestDataTestHelper.GetString();
parameter = GetHelperInstance().CreateParameter(parameterName, specifiedDbType, parameterSize, parameterDirection, value);
TestParameter(parameter, parameterName, value, expectedDbType, parameterDirection, parameterSize);
}
public void InsertAt_InsertItemIndexTooHigh_ArgumentExceptionIsThrown()
{
string[] values;
values = TestDataTestHelper.GetStrings(arraySize: 5);
Assert.AreEqual(5, values.Length);
values = values.InsertAt(6, TestDataTestHelper.GetString());
}
private void TestPrefixedParameter(string prefix, ParameterDirection parameterDirection)
{
MySqlParameter parameter;
string parameterName;
_UseParameterPrefix = true;
parameterName = TestDataTestHelper.GetString();
parameter = (MySqlParameter)GetHelperInstance().CreateParameter(parameterName, DbType.String, 20, parameterDirection, null);
TestParameter(parameter, $"{prefix}_{parameterName}", null, MySqlDbType.String, parameterDirection, 20);
}
public void ValidateInput_InvalidNonEnumValues_AreInvalid()
{
NonZeroEnumValidationAttribute attribute;
attribute = new NonZeroEnumValidationAttribute();
Assert.IsFalse(attribute.IsValid(0));
Assert.IsFalse(attribute.IsValid(TestDataTestHelper.GetInt(1)));
Assert.IsFalse(attribute.IsValid(TestDataTestHelper.GetString()));
Assert.IsFalse(attribute.IsValid(new object()));
}
public void GetDisplayName_InvalidResourceName_ReturnsNull()
{
LocalizedDisplayNameAttribute attribute;
attribute = new LocalizedDisplayNameAttribute
{
Name = TestDataTestHelper.GetString(),
ResourceType = typeof(LocalizedDisplayNameAttributeTestsResourceProvider)
};
Assert.IsNull(attribute.DisplayName);
}
public void GetDataAdapter_ValidIDbCommand_DataAdapterCreatedCorrectly()
{
IDbDataAdapter adapter;
IDbCommand command;
command = CreateCommand(TestDataTestHelper.GetString(), CommandType.StoredProcedure);
adapter = GetHelperInstance().CreateDataAdapter(command);
Assert.IsNotNull(adapter);
Assert.IsNotNull(adapter.SelectCommand);
Assert.AreEqual(command, adapter.SelectCommand);
}
public void ObjectCreation_CreateWithValues_ValuesExist()
{
ConcurrentList <string> theList;
theList = new ConcurrentList <string>();
for (int i = 0; i < 6; i++)
{
theList.Add(TestDataTestHelper.GetString());
}
Assert.AreEqual(6, theList.Count);
}
public void TryGetDynamicCodeOutput_ValidCode_IsValidResult()
{
bool result;
string testText;
testText = TestDataTestHelper.GetString();
result = DynamicCodeExecutor.TryGetDynamicCodeOutput($"\"{testText}\"", out object returnedObject, out string warningText);
Assert.IsTrue(result);
Assert.IsNotNull(returnedObject);
Assert.IsNull(warningText);
Assert.IsInstanceOfType(returnedObject, typeof(string));
Assert.AreEqual(returnedObject.ToString(), testText);
}
public void IDatbaseInterface_SetConnectionParameters_AreStoredAndRetrieved()
{
IDatabaseBase <ParameterEnum, TableEnum> database;
string connectionParameter;
database = GetDatabaseInstance();
connectionParameter = TestDataTestHelper.GetString();
database.ConnectionParameters = connectionParameter;
Assert.AreEqual(connectionParameter, database.ConnectionParameters);
connectionParameter = TestDataTestHelper.GetString();
database.ConnectionParameters = connectionParameter;
Assert.AreEqual(connectionParameter, database.ConnectionParameters);
}
public void ExtensionMethod_ToArray_FunctionsWithData()
{
StringCollection collection;
collection = new StringCollection
{
TestDataTestHelper.GetString(),
TestDataTestHelper.GetString(),
TestDataTestHelper.GetString(),
TestDataTestHelper.GetString(),
TestDataTestHelper.GetString()
};
Assert.AreEqual(5, collection.Count);
Assert.AreEqual(5, collection.ToArray().Length);
}
public void GetDisplayName_UpdateResourceValueAfterDisplayName_CheckDisplayNameDoesntChange()
{
LocalizedDisplayNameAttribute attribute;
string oldResourceValue;
attribute = new LocalizedDisplayNameAttribute
{
Name = nameof(LocalizedDisplayNameAttributeTestsResourceProvider.ResourceName),
ResourceType = typeof(LocalizedDisplayNameAttributeTestsResourceProvider)
};
oldResourceValue = LocalizedDisplayNameAttributeTestsResourceProvider.ResourceName;
Assert.AreEqual(attribute.DisplayName, oldResourceValue);
LocalizedDisplayNameAttributeTestsResourceProvider.ResourceName = TestDataTestHelper.GetString();
Assert.AreEqual(attribute.DisplayName, oldResourceValue);
Assert.AreNotEqual(attribute.DisplayName, LocalizedDisplayNameAttributeTestsResourceProvider.ResourceName);
}
public void ListOperation_AddRemoveItems_IsValidCount()
{
ConcurrentList <string> theList;
theList = new ConcurrentList <string>();
Assert.AreEqual(0, theList.Count);
for (int i = 0; i < 3; i++)
{
theList.Add(TestDataTestHelper.GetString());
Assert.AreEqual(i + 1, theList.Count);
}
for (int i = theList.Count; i > 0; i--)
{
theList.Remove(theList[i - 1]);
Assert.AreEqual(i - 1, theList.Count);
}
}
public void InsertAt_InsertItemAtStart_ItemIsInserted()
{
string newValue;
string[] result;
string[] values;
values = TestDataTestHelper.GetStrings(arraySize: 5);
newValue = TestDataTestHelper.GetString();
Assert.AreEqual(5, values.Length);
result = values.InsertAt(0, newValue);
Assert.AreEqual(5, values.Length);
Assert.AreEqual(6, result.Length);
Assert.AreEqual(newValue, result[0]);
for (int i = 0; i < 5; i++)
{
Assert.AreEqual(result[i + 1], values[i]);
}
}
public void Append_AppendItem_ItemIsAppended()
{
string newValueA;
string newValueB;
string[] result;
string[] values;
values = TestDataTestHelper.GetStrings(arraySize: 5);
newValueA = TestDataTestHelper.GetString();
newValueB = TestDataTestHelper.GetString();
Assert.AreEqual(5, values.Length);
result = values.Append(newValueA);
Assert.AreEqual(5, values.Length);
Assert.AreEqual(6, result.Length);
Assert.AreEqual(newValueA, result[5]);
result = result.Append(newValueB);
Assert.AreEqual(7, result.Length);
Assert.AreEqual(newValueB, result[6]);
}
public void GetDataAdapter_InvalidIDbCommandType_ExceptionThrown()
{
GetHelperInstance().CreateDataAdapter(new System.Data.OleDb.OleDbCommand(TestDataTestHelper.GetString()));
}
static LocalizedDisplayNameAttributeTestsResourceProvider()
{
ResourceName = TestDataTestHelper.GetString();
}
public void CreateParameter_UsingDbTypeString_ParameterCreatedCorrectly()
{
ExecuteParameterTest(DbType.String, GetDbTypeString(), TestDataTestHelper.GetString(), ParameterDirection.Input, 20);
}