修复了 SubSonic 3 的 TestRepository 的问题 [英] Fixes for problems with SubSonic 3's TestRepository

问题描述

我一直在尝试使用 SubSonic 3.0 的测试存储库支持进行单元测试，但遇到了一些问题，所以我想我记录了它们以及我提出的修复:

I've been trying to use SubSonic 3.0's test repository support for unit testing but encountered a few issues, so I thought I document them, and the fixes I've come up with:

显然没有数据库，自动递增列不会自动工作，但如果像我一样，你对所有标识列使用简单的整数或长整数，这个修复工作得很好:

Obviously with no DB, auto-increment columns don't work automatically, but if like me you're using simple ints or longs for all identity columns, this fix works well:

(这是此处的副本)，包括在内)

在 ActiveRecord.tt 中:

In ActiveRecord.tt:

1:在函数顶部public void Add(IDataProvider provider){

1: In the top of the function public void Add(IDataProvider provider){

        public void Add(IDataProvider provider){

<#if(tbl.PK.SysType=="long" || tbl.PK.SysType=="int") {#>
            if (TestMode)
            {
                this.<#=tbl.PK.CleanName#>=++next_test_autoid;
            }

<#}#>

2:在 public bool TestMode = false 行下，添加:

2: Under the line public bool TestMode = false, add:

        public bool TestMode = false;
<#if(tbl.PK.SysType=="long" || tbl.PK.SysType=="int") {#>
        private static <#=tbl.PK.SysType#> next_test_autoid = 0;
<#}#>

对象相等比较被破坏

使用默认的 ActiveRecord 模板，对象相等不起作用.因此从数据库中删除项目不起作用，因为 TestRepository 中使用的 List<>.Remove() 无法匹配被删除的项目.这可以在 tt 模板中使用以下内容修复:(即:将=="替换为Equals()")

Object Equality Comparison is Broken

Using the default ActiveRecord template, object equality doesn't work. So removing items from the DB doesn't work since the List<>.Remove() used in the TestRepository fails to match the item being removed. This can be fixed in the tt templates with the following: (ie: replacing "==" with "Equals()")

在 ActiveRecord.tt 中:

In ActiveRecord.tt:

    public override bool Equals(object obj){
        if(obj.GetType()==typeof(<#=tbl.ClassName#>)){
            <#=tbl.ClassName#> compare=(<#=tbl.ClassName#>)obj;
            return compare.KeyValue().Equals(this.KeyValue());
        }else{
            return base.Equals(obj);
        }
    }

DeleteMany 未在测试存储库中实现

像这样的操作 records.Delete(x => x.whatever ==whatever) 对测试仓库失败，因为 DeleteMany 没有实现.解决这个问题需要获取源代码并自行构建，但这里有一个似乎有效的实现:

DeleteMany is Not Implemented in the Test Repository

Operations like this records.Delete(x => x.whatever == whatever) fail against the test repo because DeleteMany is not implemented. Fixing this requires getting the source and building yourself, but here's an implementation that seems to work:

在 TestRepository.cs 中:

In TestRepository.cs:

    public int DeleteMany(Expression<Func<T, bool>> expression)
    {
        foreach (var x in _items.AsQueryable().Where(expression).ToList())
        {
            _items.Remove(x);
        }
        return 0;
    }

推荐答案

感谢您的帮助 - 但最好的办法是告诉我们您的问题 :).StackOverflow 更适合回答问题——我可能建议前往 Github 并检查最新的源代码(我们已经修复了其中的一些).如果您发现某些问题可以修复 - 非常欢迎使用补丁.

Thanks for this - but the best thing to do is to tell us about your issues :). StackOverflow is more for answering questions - I might suggest heading over to Github and checking the latest source (we've fixed a number of these). If you see that some things can be fixed - patches are very welcome.

这篇关于修复了 SubSonic 3 的 TestRepository 的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！