public void TestDBService_CompareTableList_NotSamePlurial_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
ContactModel contactModel = contactModelListGood[0];
IPrincipal user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
TestDBService testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, "", "");
string TableName1 = "aaa";
string TableName2 = "aaa";
string Plurial1 = "s";
string Plurial2 = "es";
List <DBTable> AllTables = new List <DBTable>();
FillAllTables(testDBService, AllTables);
AllTables[0].TableName = TableName1;
AllTables[0].Plurial = Plurial1;
List <DBTable> AllTablesToDelete = new List <DBTable>();
FillAllTablesToDelete(testDBService, AllTablesToDelete);
AllTablesToDelete[0].TableName = TableName2;
AllTablesToDelete[0].Plurial = Plurial2;
string retStr = testDBService.CompareTableList(AllTables, AllTablesToDelete);
Assert.AreEqual(string.Format(ServiceRes.CompareTablePlurialNotEqual_And_, AllTables[0].TableName, AllTablesToDelete[0].TableName), retStr);
break; // only do one language
}
}
public void TestDBService_CompareTableList_NotSameCount_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
ContactModel contactModel = contactModelListGood[0];
IPrincipal user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
TestDBService testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, "", "");
List <DBTable> AllTables = new List <DBTable>();
FillAllTables(testDBService, AllTables);
AllTables.Add(new DBTable()
{
TableName = "NotSameCount", Plurial = "s"
});
List <DBTable> AllTablesToDelete = new List <DBTable>();
FillAllTablesToDelete(testDBService, AllTablesToDelete);
string retStr = testDBService.CompareTableList(AllTables, AllTablesToDelete);
Assert.AreEqual(string.Format(ServiceRes._CountAnd_CountNotEqual, "AllTables", "AllTablesToDelete"), retStr);
break; // only do one language
}
}
private static void GetQueryInfo()
{
var conneMySql = ConfigurationManager.AppSettings["mysqlTest"].ToString();
var conneMS = ConfigurationManager.AppSettings["msTest"].ToString();
TestDBService service = new TestDBService(conneMS);
MService mService = new MService();
//service.GetDBContext();
mService.GetDBContext();
}
private void FillAllTablesToDelete(TestDBService testDBService, List <DBTable> AllTablesToDelete)
{
PrivateObject privateObject = new PrivateObject(testDBService);
privateObject.Invoke("FillTableNameToDeleteList", AllTablesToDelete);
Assert.AreEqual(70, AllTablesToDelete.Count);
Assert.AreEqual("Log", AllTablesToDelete[0].TableName);
Assert.AreEqual("s", AllTablesToDelete[0].Plurial);
}
private void FillAllTables(TestDBService testDBService, List <DBTable> AllTables)
{
testDBService.FillTableNameList(AllTables);
Assert.AreEqual(70, AllTables.Count);
Assert.AreEqual("Address", AllTables[0].TableName);
Assert.AreEqual("es", AllTables[0].Plurial);
Assert.AreEqual("AppErrLog", AllTables[1].TableName);
Assert.AreEqual("s", AllTables[1].Plurial);
}
public void SetupTest(ContactModel contactModelToDo, CultureInfo culture)
{
Thread.CurrentThread.CurrentCulture = culture;
Thread.CurrentThread.CurrentUICulture = culture;
contactModel = contactModelToDo;
user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
appErrLogService = new AppErrLogService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, TableName, Plurial);
randomService = new RandomService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
appErrLogModelNew = new AppErrLogModel();
appErrLog = new AppErrLog();
}
public void TestDBService_CSSPWebToolsDBIsOK_Good_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
ContactModel contactModel = contactModelListGood[0];
IPrincipal user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
TestDBService testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, "", "");
string retStr = testDBService.CSSPWebToolsDBIsOK();
Assert.AreEqual("", retStr);
break; // only do one language
}
}
public void SetupTest(ContactModel contactModelToDo, CultureInfo culture)
{
Thread.CurrentThread.CurrentCulture = culture;
Thread.CurrentThread.CurrentUICulture = culture;
contactModel = contactModelToDo;
user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
labContractSubsectorService = new MWQMPlanSubsectorService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, TableName, Plurial);
randomService = new RandomService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
labContractSubsectorModelNew = new MWQMPlanSubsectorModel();
labContractSubsector = new MWQMPlanSubsector();
labContractServiceTest = new MWQMPlanServiceTest();
labContractServiceTest.SetupTest(contactModelToDo, culture);
}
public void TestDBService_Constructor_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
ContactModel contactModel = contactModelListGood[0];
IPrincipal user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
string TableName = "";
string Plurial = "";
TestDBService testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, TableName, Plurial);
Assert.AreEqual(0, testDBService.Count);
Assert.AreEqual(TableName, testDBService.dbTable.TableName);
Assert.AreEqual(Plurial, testDBService.dbTable.Plurial);
}
}
public void TestDBService_FillTableNameToDeleteList_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
ContactModel contactModel = contactModelListGood[0];
IPrincipal user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
TestDBService testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, "", "");
List <DBTable> AllTablesToDelete = new List <DBTable>();
FillAllTablesToDelete(testDBService, AllTablesToDelete);
break; // only do one language
}
}
public void TestDBService_FillDBTablesName_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
ContactModel contactModel = contactModelListGood[0];
IPrincipal user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
TestDBService testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, "", "");
List <string> AllTableNames = new List <string>();
testDBService.FillDBTablesName(AllTableNames);
Assert.IsTrue(AllTableNames.Count > 0);
break; // only do one language
}
}
public void TestDBService_CompareDBAndList_Good_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
ContactModel contactModel = contactModelListGood[0];
IPrincipal user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
TestDBService testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, "", "");
List <DBTable> AllTables = new List <DBTable>();
FillAllTables(testDBService, AllTables);
// already in function
List <string> TablesNameInDB = new List <string>();
testDBService.FillDBTablesName(TablesNameInDB);
string retStr = testDBService.CompareDBAndList(TablesNameInDB, AllTables);
Assert.AreEqual("", retStr);
break; // only do one language
}
}
