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();
}
}
