int CountRowsInTable(IDnaDataReader reader, string tableName)
{
var counts = reader.ExecuteGetInts("c", "select count(*) c from " + tableName);
return counts[0];
}
int GetUserIdForSearchTests(IDnaDataReader reader)
{
string sql = @"select top 1 u.userid" + NL +
"FROM Users u WITH(NOLOCK)" + NL +
"INNER JOIN Preferences p WITH(NOLOCK) ON p.UserID = u.UserID" + NL +
"INNER JOIN Mastheads m WITH(NOLOCK) ON m.UserID = u.UserID AND m.SiteID = p.SiteID" + NL +
"INNER JOIN Sites s WITH(NOLOCK) ON s.SiteID = p.SiteID" + NL +
"INNER JOIN Userstatuses us WITH(NOLOCK) ON us.UserStatusID = p.PrefStatus" + NL +
"INNER JOIN SignInUserIdMapping sm WITH(NOLOCK) ON sm.DnaUserID = u.UserID" + NL +
"WHERE s.siteid=1";
return reader.ExecuteGetInts("userid", sql)[0];
}
