如何在 Massive 中测试没有结果

Question

我在 Massive 类上创建了 Find 方法。问题是我刚刚意识到它总是返回 true，因为结果永远不为空。这是我的代码：

    public dynamic Find(string email)
    {
        dynamic result = new ExpandoObject();
        dynamic experience = new ExpandoObject();
        result.Success = false;
        experience = this.Query(@"SELECT we.* FROM WorkExperience we
            LEFT JOIN Members m ON m.Id = we.MemberId 
            WHERE m.Email = @0", email);
        if (experience != null)
        {
            result.Experience = experience;
            result.Success = true;
        }
        return result;
    }

在这种情况下，经验永远不会为空，因此 result.Success 总是返回 false。如何测试 this.Query() 是否返回一条或多条记录？

Answer 1

我这样做是为了测试我的查询是否返回记录。

控制器：

 public ActionResult Index() {
        _logger.LogInfo("In home");
        //var data = _tricksTable.All(orderBy: "DateCreated");
        dynamic viewModel = new ExpandoObject();
        var data = _tricksTable.Query("SELECT TOP(10) * FROM Tricks ORDER BY DateCreated DESC");
        viewModel.TenTricksNewestFirst = data;

        var data2 = _tricksTable.Query("SELECT TOP(10) * FROM Tricks ORDER BY Votes DESC");
        viewModel.TenTricksMostPopularFirst = data2;
        return View(viewModel);
    }

和测试：

[Test]
    public void a_user_should_be_able_to_view_10_newest_tricks_in_latest_videos_tab() {
        var result = _controller.Index() as ViewResult;
        dynamic viewModelExpando = result.ViewData.Model;
        var queryFromMassiveDynamic = viewModelExpando.TenTricksNewestFirst;

        var i = Enumerable.Count(queryFromMassiveDynamic);
        Assert.AreNotEqual(0, i, "TenTricksNewestFirst returned 0 records");
        Assert.LessOrEqual(i,10, "Ten Tricks Newest First returned more than 10 tricks");
    }

Answer 2

供以后寻求答案的人参考，这样做实际上更简单。不要使用 DynamicModel 的 Query 方法，而是调用 Scalar 方法并确保您选择 a) 仅一个值，然后测试结果是否为 null 或 b) 匹配项计数，您可以从中将结果转换为整数并根据返回的数字进行测试。