private void BuildStandardData(DbTestData testData, out string inputData, out DbData outputData, out DbQueryData queryData) { inputData = testData.Input; outputData = null; queryData = null; string stdOperCmd = testData.Operation; string stdQueryCmd = testData.Query; BaseDbOperator stdOperator = CreateJudgeEnv(inputData); try { DbDataReader reader = stdOperator.ExecuteReader(stdOperCmd ?? stdQueryCmd); if (stdOperCmd != null) { outputData = stdOperator.ReadDbData(); } if (stdQueryCmd != null) { queryData = BaseDbOperator.ReadQueryData(reader); } } catch (Exception ex) { throw new JudgeException("Build Db test data failed!" + ex); } finally { ClearJudgeEnv(stdOperator); } }
public void CanAdd() { using (var data = new DbTestData()) { var user = new User( Guid.Empty, "AddedUser", "8ee2027983915ec78acc45027d874316", "Added", "User", "*****@*****.**" ); var newUser = dal.Add(user); newUser.Should().NotBeNull(); newUser.ID.Should().NotBe(Guid.Empty); newUser.Username.Should().Be("AddedUser"); newUser.FirstName.Should().Be("Added"); newUser.LastName.Should().Be("User"); newUser.PasswordHash.Should().Be("8ee2027983915ec78acc45027d874316"); newUser.Email.Should().Be("*****@*****.**"); dal.DeleteById(newUser.ID); } }
public void CanAdd() { using (var data = new DbTestData()) { var userId = data.user1.ID; var project = new Project( Guid.Empty, userId, "Test project", "no description", data.language1, new List <Language> { data.language2 } ); var newProject = dal.Add(project); newProject.Should().NotBeNull(); newProject.ID.Should().NotBe(Guid.Empty); newProject.Name.Should().Be("Test project"); newProject.Description.Should().Be("no description"); newProject.SourceLanguage.Should().BeEquivalentTo(data.language1); newProject.TargetLanguages.Should().NotBeNullOrEmpty(); newProject.TargetLanguages.Should().HaveCount(1); newProject.TargetLanguages[0].Should().BeEquivalentTo(data.language2); dal.DeleteById(newProject.ID); } }
public FilmEntityTest(DbFixture fixture) { _context = fixture.Context; _filmRepo = new FilmRepo(_context); DbTestData.SeedData(_context); }
public void CanReadAll() { using (var data = new DbTestData()) { var phrases = dal.ReadAll(); phrases.Should().NotBeNullOrEmpty(); phrases.Should().HaveCountGreaterOrEqualTo(2); } }
public void CanReadAll() { using (var data = new DbTestData()) { var votes = _context.Votes.GetAll(); votes.Should().NotBeNullOrEmpty(); votes.Should().HaveCountGreaterOrEqualTo(2); } }
public void CanReadByName() { using (var data = new DbTestData()) { var language = dal.ReadByName("English"); language.Should().NotBeNull(); language.Name.Should().Be("English"); language.Abbreviation.Should().Be("en"); } }
public void CanReadByUserId() { using (var data = new DbTestData()) { var userId = data.user1.ID; var translations = _context.Translations.GetAllByUserId(userId); translations.Should().NotBeNullOrEmpty(); translations.Should().HaveCount(1); } }
public void CanReadByUserId() { using (var data = new DbTestData()) { var userId = data.user1.ID; var votes = dal.ReadAllByUserId(userId); votes.Should().NotBeNullOrEmpty(); votes.Should().HaveCount(1); } }
public void CanReadByPhraseId() { using (var data = new DbTestData()) { var phraseId = data.phrase1.ID; var translations = dal.ReadAllByPhraseId(phraseId); translations.Should().NotBeNullOrEmpty(); translations.Should().HaveCount(1); } }
public void CanReadByUserId() { using (var data = new DbTestData()) { var userId = data.user1.ID; var projects = dal.ReadAllByUserId(userId); projects.Should().NotBeNullOrEmpty(); projects.Should().HaveCountGreaterOrEqualTo(1); } }
public void CanReadByProjectId() { using (var data = new DbTestData()) { var projectId = data.project1.ID; var phrases = dal.ReadAllByProjectId(projectId); phrases.Should().NotBeNullOrEmpty(); phrases.Should().HaveCount(1); } }
public void CanReadByTranslationId() { using (var data = new DbTestData()) { var translationId = data.translation1.ID; var votes = dal.ReadAllByTranslationId(translationId); votes.Should().NotBeNullOrEmpty(); votes.Should().HaveCount(1); } }
public void CanReadById() { using (var data = new DbTestData()) { var id = data.phrase1.ID; var phrase = dal.ReadById(id); phrase.Should().NotBeNull(); phrase.Text.Should().Be(data.phrase1.Text); phrase.ProjectID.Should().Be(data.phrase1.ProjectID); } }
public void CanReadById() { using (var data = new DbTestData()) { var id = data.language2.ID; var language = dal.ReadById(id); language.Should().NotBeNull(); language.Name.Should().Be("German"); language.Abbreviation.Should().Be("de"); } }
public void CanReadById() { using (var data = new DbTestData()) { var userId = data.user1.ID; var translationId = data.translation2.ID; var vote = dal.ReadById(userId, translationId); vote.Should().NotBeNull(); vote.IsUpvote.Should().BeTrue(); } }
public void CanReadById() { using (var data = new DbTestData()) { var id = data.user1.ID; var user = dal.ReadById(id); user.Should().NotBeNull(); user.Username.Should().Be(data.user1.Username); user.FirstName.Should().Be(data.user1.FirstName); user.LastName.Should().Be(data.user1.LastName); } }
public void CanReadByPhraseIdAndLanguageId() { using (var data = new DbTestData()) { var phraseId = data.phrase1.ID; var languageId = data.language2.ID; var translations = _context.Translations .GetAllByPhraseIdAndLanguageId(phraseId, languageId); translations.Should().NotBeNullOrEmpty(); translations.Should().HaveCount(1); } }
public void CanReadById() { using (var data = new DbTestData()) { var id = data.translation1.ID; var translation = dal.ReadById(id); translation.Should().NotBeNull(); translation.Text.Should().Be(data.translation1.Text); translation.PhraseID.Should().Be(data.translation1.PhraseID); translation.LanguageID.Should().Be(data.translation1.LanguageID); translation.UserID.Should().Be(data.translation1.UserID); } }
public void CanReadById() { using (var data = new DbTestData()) { var projectId = data.project1.ID; var project = dal.ReadById(projectId); project.Should().NotBeNull(); project.Name.Should().Be(data.project1.Name); project.SourceLanguage.Name.Should().Be(data.language1.Name); project.TargetLanguages.Should().HaveCount(1); project.TargetLanguages[0].Should().BeEquivalentTo(data.language2); } }
// Runs once per all tests public DbFixture() { const string connectionString = "server=localhost;database=testwithxunit;uid=Agonire;pwd=1111"; Options = new DbContextOptionsBuilder <FilmContext>() .UseMySql(connectionString) .Options; Context = new FilmContext(Options); // Context.Database.EnsureDeleted(); Context.Database.EnsureCreated(); DbTestData.CleanDb(Context); }
public void CanUpdate() { using (var data = new DbTestData()) { var translationId = data.translation1.ID; var translation = dal.ReadById(translationId); translation.Text = "updated"; var updatedTranslation = dal.UpdateById(translationId, translation); updatedTranslation.Should().NotBeNull(); updatedTranslation.ID.Should().Be(translationId); updatedTranslation.Text.Should().Be("updated"); } }
public void CanDelete() { using (var data = new DbTestData()) { Guid userId = data.user1.ID; Guid translationId = data.translation2.ID; var deletedVote = dal.ReadById(userId, translationId); deletedVote.Should().NotBeNull(); dal.DeleteById(deletedVote.UserID, deletedVote.TranslationID); dal.ReadById(userId, translationId).Should().BeNull(); } }
public void CanDelete() { using (var data = new DbTestData()) { var translationId = data.translation1.ID; _context.Translations.GetById(translationId).Should().NotBeNull(); _context.Votes.GetAllByTranslationId(translationId).Should().NotBeEmpty(); _context.Translations.DeleteById(translationId); _context.Translations.GetById(translationId).Should().BeNull(); _context.Votes.GetAllByTranslationId(translationId).Should().BeEmpty(); } }
private SingleJudgeResult JudgeOneCase(string dataName) { DbTestData testData = TestDataManager.GetDbTestData(JudgeTask.ProblemId, _dbType, dataName); BuildStandardData(testData, out string inputData, out DbData outputData, out DbQueryData queryData); BaseDbOperator userOper = CreateJudgeEnv(inputData); SingleCaseJudger singleCaseJudger = new SingleCaseJudger(Context, userOper); SingleJudgeResult result = singleCaseJudger.Judge(inputData, outputData, queryData); ClearJudgeEnv(userOper); return(result); }
public void CanDelete() { using (var data = new DbTestData()) { var phraseId = data.phrase1.ID; _context.Phrases.GetById(phraseId).Should().NotBeNull(); _context.Translations.GetAllByPhraseId(phraseId).Should().NotBeEmpty(); _context.Phrases.DeleteById(phraseId); _context.Phrases.GetById(phraseId).Should().BeNull(); _context.Translations.GetAllByPhraseId(phraseId).Should().BeEmpty(); } }
public void CanDelete() { using (var data = new DbTestData()) { var project = data.project1; _context.Projects.GetById(project.ID).Should().NotBeNull(); _context.Phrases.GetAllByProjectId(project.ID).Should().NotBeEmpty(); _context.Projects.DeleteById(project.ID); _context.Projects.GetById(project.ID).Should().BeNull(); _context.Phrases.GetAllByProjectId(project.ID).Should().BeEmpty(); } }
public void CanUpdate() { using (var data = new DbTestData()) { var phrase = data.phrase1; phrase.Text = "updated"; var updatedPhrase = dal.UpdateById(phrase.ID, phrase); updatedPhrase.Should().NotBeNull(); updatedPhrase.ID.Should().Be(phrase.ID); updatedPhrase.Text.Should().Be("updated"); updatedPhrase.ProjectID.Should().Be(phrase.ProjectID); } }
public void CanDelete() { using (var data = new DbTestData()) { var translationsDAL = new TranslationsDAL(DbTestData.ConnectionString); var phraseId = data.phrase1.ID; dal.ReadById(phraseId).Should().NotBeNull(); translationsDAL.ReadAllByPhraseId(phraseId).Should().NotBeEmpty(); dal.DeleteById(phraseId); dal.ReadById(phraseId).Should().BeNull(); translationsDAL.ReadAllByPhraseId(phraseId).Should().BeEmpty(); } }
public void CanDelete() { using (var data = new DbTestData()) { var phrasesDAL = new PhrasesDAL(DbTestData.ConnectionString); var project = data.project1; dal.ReadById(project.ID).Should().NotBeNull(); phrasesDAL.ReadAllByProjectId(project.ID).Should().NotBeEmpty(); dal.DeleteById(project.ID); dal.ReadById(project.ID).Should().BeNull(); phrasesDAL.ReadAllByProjectId(project.ID).Should().BeEmpty(); } }