public void LoadValidInternalTypesAndEnableSwitch(string method1, string method2)
{
bool switchValue = true;
RetryLogicConfigs cnnCfg = RetryLogicConfigHelper.CreateRandomConfig(method1);
RetryLogicConfigs cmdCfg = RetryLogicConfigHelper.CreateRandomConfig(method2,
// Doesn't accept DML statements
@"^\b(?!UPDATE|DELETE|TRUNCATE|INSERT( +INTO){0,1})\b");
// for sake of reducing the retry time in total
cnnCfg.NumberOfTries = 1;
cmdCfg.NumberOfTries = 1;
object loaderObj = RetryLogicConfigHelper.ReturnLoaderAndProviders(cnnCfg, cmdCfg, switchValue, out SqlRetryLogicBaseProvider cnnProvider, out SqlRetryLogicBaseProvider cmdProvider);
Assert.NotNull(loaderObj);
RetryLogicConfigHelper.AssessProvider(cnnProvider, cnnCfg, switchValue);
RetryLogicConfigHelper.AssessProvider(cmdProvider, cmdCfg, switchValue);
// check the retry in action
RetryLogicTestHelper.CleanRetryEnabledCache();
s_connectionCRLTest.ConnectionRetryOpenInvalidCatalogFailed(TcpCnnString, cnnProvider);
s_commandCRLTest.RetryExecuteFail(TcpCnnString, cmdProvider);
if (DataTestUtility.IsNotAzureSynapse())
{
s_commandCRLTest.RetryExecuteUnauthorizedSqlStatementDML(TcpCnnString, cmdProvider);
}
}
public static IEnumerable <object[]> GetNoneRetriableCondition()
{
RetryLogicTestHelper.SetRetrySwitch(true);
yield return(new object[] { DataTestUtility.TCPConnectionString, null });
yield return(new object[] { DataTestUtility.TCPConnectionString, SqlConfigurableRetryFactory.CreateNoneRetryProvider() });
RetryLogicTestHelper.SetRetrySwitch(false);
yield return(new object[] { DataTestUtility.TCPConnectionString, null });
yield return(new object[] { DataTestUtility.TCPConnectionString, SqlConfigurableRetryFactory.CreateNoneRetryProvider() });
var option = new SqlRetryLogicOption()
{
NumberOfTries = 2,
DeltaTime = TimeSpan.FromMilliseconds(10),
MaxTimeInterval = TimeSpan.FromSeconds(2)
};
foreach (var provider in GetRetryStrategies(option))
{
yield return new object[] { DataTestUtility.TCPConnectionString, provider[0] }
}
;
}
public void InvalidRetryMethodName(string methodName)
{
RetryLogicConfigs cnnCfg = RetryLogicConfigHelper.CreateRandomConfig(methodName);
RetryLogicConfigs cmdCfg = RetryLogicConfigHelper.CreateRandomConfig(methodName, @"Don't care!");
bool switchValue = true;
object loaderObj = RetryLogicConfigHelper.ReturnLoaderAndProviders(cnnCfg, cmdCfg, switchValue, out SqlRetryLogicBaseProvider cnnProvider, out SqlRetryLogicBaseProvider cmdProvider);
Assert.NotNull(loaderObj);
// none retriable logic applies.
RetryLogicTestHelper.CleanRetryEnabledCache();
s_connectionCRLTest.DefaultOpenWithoutRetry(TcpCnnString, cnnProvider);
s_commandCRLTest.NoneRetriableExecuteFail(TcpCnnString, cmdProvider);
}
public void LoadValidInternalTypesWithoutEnablingSwitch(string method1, string method2)
{
bool switchValue = false;
RetryLogicConfigs cnnCfg = RetryLogicConfigHelper.CreateRandomConfig(method1);
RetryLogicConfigs cmdCfg = RetryLogicConfigHelper.CreateRandomConfig(method2, @"Don't care!");
object loaderObj = RetryLogicConfigHelper.ReturnLoaderAndProviders(cnnCfg, cmdCfg, switchValue, out SqlRetryLogicBaseProvider cnnProvider, out SqlRetryLogicBaseProvider cmdProvider);
Assert.NotNull(loaderObj);
RetryLogicConfigHelper.AssessProvider(cnnProvider, cnnCfg, switchValue);
RetryLogicConfigHelper.AssessProvider(cmdProvider, cmdCfg, switchValue);
RetryLogicTestHelper.CleanRetryEnabledCache();
s_connectionCRLTest.DefaultOpenWithoutRetry(TcpCnnString, cnnProvider);
s_commandCRLTest.NoneRetriableExecuteFail(TcpCnnString, cmdProvider);
}
public void LoadInvalidCustomRetryLogicType(string typeName, string methodName)
{
bool switchValue = true;
RetryLogicConfigs cnnCfg = RetryLogicConfigHelper.CreateRandomConfig(methodName);
RetryLogicConfigs cmdCfg = RetryLogicConfigHelper.CreateRandomConfig(methodName);
// for sake of reducing the retry time in total
cnnCfg.RetryLogicType = typeName;
cmdCfg.RetryLogicType = typeName;
// for sake of reducing the retry time in total
cnnCfg.NumberOfTries = 1;
cmdCfg.NumberOfTries = 3;
object loaderObj = RetryLogicConfigHelper.ReturnLoaderAndProviders(cnnCfg, cmdCfg, switchValue, out SqlRetryLogicBaseProvider cnnProvider, out SqlRetryLogicBaseProvider cmdProvider);
Assert.NotNull(loaderObj);
RetryLogicTestHelper.CleanRetryEnabledCache();
s_connectionCRLTest.DefaultOpenWithoutRetry(TcpCnnString, cnnProvider);
s_commandCRLTest.NoneRetriableExecuteFail(TcpCnnString, cmdProvider);
}
public void LoadCustomMethod(string typeName, string methodName)
{
bool switchValue = true;
RetryLogicConfigs cnnCfg = RetryLogicConfigHelper.CreateRandomConfig(methodName);
RetryLogicConfigs cmdCfg = RetryLogicConfigHelper.CreateRandomConfig(methodName);
// for sake of reducing the retry time in total
cnnCfg.RetryLogicType = typeName;
cmdCfg.RetryLogicType = typeName;
// for sake of reducing the retry time in total
cnnCfg.NumberOfTries = 1;
cmdCfg.NumberOfTries = 3;
object loaderObj = RetryLogicConfigHelper.ReturnLoaderAndProviders(cnnCfg, cmdCfg, switchValue, out SqlRetryLogicBaseProvider cnnProvider, out SqlRetryLogicBaseProvider cmdProvider);
Assert.NotNull(loaderObj);
RetryLogicTestHelper.CleanRetryEnabledCache();
TestConnection(cnnProvider, cnnCfg);
TestCommandExecute(cmdProvider, cmdCfg);
TestCommandExecuteAsync(cmdProvider, cmdCfg).Wait();
}
public void InvalidRetryLogicTypeWithValidInternalMethodName(string typeName)
{
RetryLogicConfigs cnnCfg = RetryLogicConfigHelper.CreateRandomConfig(RetryLogicConfigHelper.RetryMethodName_Fix);
cnnCfg.RetryLogicType = typeName;
RetryLogicConfigs cmdCfg = RetryLogicConfigHelper.CreateRandomConfig(RetryLogicConfigHelper.RetryMethodName_Fix);
// for sake of reducing the retry time in total
cnnCfg.NumberOfTries = 1;
cmdCfg.NumberOfTries = 1;
bool switchValue = true;
object loaderObj = RetryLogicConfigHelper.ReturnLoaderAndProviders(cnnCfg, cmdCfg, switchValue, out SqlRetryLogicBaseProvider cnnProvider, out SqlRetryLogicBaseProvider cmdProvider);
Assert.NotNull(loaderObj);
RetryLogicConfigHelper.AssessProvider(cnnProvider, cnnCfg, switchValue);
RetryLogicConfigHelper.AssessProvider(cmdProvider, cmdCfg, switchValue);
// internal type used to resolve the specified method
RetryLogicTestHelper.CleanRetryEnabledCache();
s_connectionCRLTest.ConnectionRetryOpenInvalidCatalogFailed(TcpCnnString, cnnProvider);
s_commandCRLTest.RetryExecuteFail(TcpCnnString, cmdProvider);
}
