StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFixes for problems with SubSonic 3's TestRepository
primarykey
Id
2454889
data
AcceptedAnswerId
2457141
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-03-16T13:59:29.970
FavoriteCount
0
LastActivityDate
2011-02-28T04:26:24.420
LastEditDate
2017-05-23T11:55:20
LastEditorUserId
-1
OwnerUserId
77002
ParentId
0
PostTypeId
1
Score
2
ViewCount
142
LastEditorDisplayName
text
Body
<p>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:</p> <h2>Auto-Increment Columns Don't Work</h2> <p>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:</p> <p>(This is a copy from <a href="https://stackoverflow.com/questions/1508706/subsonic-3-active-record-testrepository-identity-column-not-icremented/2452170#2452170">here</a>, included for completeness)</p> <p>In ActiveRecord.tt:</p> <p>1: In the top of the function public void Add(IDataProvider provider){</p> <pre><code> public void Add(IDataProvider provider){ <#if(tbl.PK.SysType=="long" || tbl.PK.SysType=="int") {#> if (TestMode) { this.<#=tbl.PK.CleanName#>=++next_test_autoid; } <#}#> </code></pre> <p>2: Under the line public bool TestMode = false, add:</p> <pre><code> public bool TestMode = false; <#if(tbl.PK.SysType=="long" || tbl.PK.SysType=="int") {#> private static <#=tbl.PK.SysType#> next_test_autoid = 0; <#}#> </code></pre> <h2>Object Equality Comparison is Broken</h2> <p>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()")</p> <p>In ActiveRecord.tt:</p> <pre><code> 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); } } </code></pre> <h2>DeleteMany is Not Implemented in the Test Repository</h2> <p>Operations like this <code>records.Delete(x => x.whatever == whatever)</code> 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:</p> <p>In TestRepository.cs:</p> <pre><code> public int DeleteMany(Expression<Func<T, bool>> expression) { foreach (var x in _items.AsQueryable().Where(expression).ToList()) { _items.Remove(x); } return 0; } </code></pre>
Tags
<subsonic><subsonic3><subsonic-active-record>
Title
Fixes for problems with SubSonic 3's TestRepository
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USBrad Robinson
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostLinksRelatedPostIdPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POFixes for problems with SubSonic 3's TestRepository
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POFixes for problems with SubSonic 3's TestRepository
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.