public DbFactory(CycleAnalysisContext context)
{
_context = context;
}
public SessionRepository(CycleAnalysisContext context)
{
_context = context;
}
public RoleRepository(CycleAnalysisContext context)
{
_context = context;
}
/// <summary>
/// Constructor creates a mock context class with a mocked DbSet, which is passed into the SessionRepository.
/// </summary>
public SessionRepositoryTests()
{
// create connection string so we're not reliant on Web.config connection strings
var connectionString = new SqlConnectionStringBuilder() { DataSource = ".", IntegratedSecurity = true, InitialCatalog = "RandomDbName" }.ConnectionString;
// pass connection string to context class
_context = new CycleAnalysisContext(connectionString);
_sessionDataList = new List<SessionData>
{
new SessionData(){ Id = 0, HeartRate = 125, Speed = 214, Cadence = 55, Altitude = 33, Power = 19, Row = 1, SessionId = 1 },
new SessionData(){ Id = 1, HeartRate = 129, Speed = 259, Cadence = 60, Altitude = 32, Power = 477, Row = 2, SessionId = 1 },
new SessionData(){ Id = 2, HeartRate = 132, Speed = 308, Cadence = 70, Altitude = 32, Power = 837, Row = 3, SessionId = 1 },
new SessionData(){ Id = 3, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 799, Row = 4, SessionId = 1 },
new SessionData(){ Id = 4, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 735, Row = 5, SessionId = 1 },
new SessionData(){ Id = 5, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 740, Row = 6, SessionId = 1 },
// session used for interval detection
// first interval to detect
new SessionData(){ Id = 1, HeartRate = 125, Speed = 214, Cadence = 55, Altitude = 33, Power = 19, Row = 1, SessionId = 2},
new SessionData(){ Id = 2, HeartRate = 129, Speed = 259, Cadence = 60, Altitude = 32, Power = 20, Row = 2, SessionId = 2 },
new SessionData(){ Id = 3, HeartRate = 132, Speed = 308, Cadence = 70, Altitude = 32, Power = 18, Row = 3, SessionId = 2 },
new SessionData(){ Id = 4, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 20, Row = 4, SessionId = 2 }, // potential interval
new SessionData(){ Id = 5, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 23, Row = 5, SessionId = 2 },
new SessionData(){ Id = 6, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 27, Row = 6, SessionId = 2 },
new SessionData(){ Id = 7, HeartRate = 125, Speed = 214, Cadence = 55, Altitude = 33, Power = 30, Row = 7, SessionId = 2 },
new SessionData(){ Id = 8, HeartRate = 129, Speed = 259, Cadence = 60, Altitude = 32, Power = 35, Row = 8, SessionId = 2 },
new SessionData(){ Id = 9, HeartRate = 132, Speed = 308, Cadence = 70, Altitude = 32, Power = 40, Row = 9, SessionId = 2 }, // potential interval start
new SessionData(){ Id = 10, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 10, SessionId = 2 },
new SessionData(){ Id = 11, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 11, SessionId = 2 },
new SessionData(){ Id = 12, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 12, SessionId = 2 },
new SessionData(){ Id = 13, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 13, SessionId = 2 },
new SessionData(){ Id = 14, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 14, SessionId = 2 },
new SessionData(){ Id = 15, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 15, SessionId = 2 },
new SessionData(){ Id = 16, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 16, SessionId = 2 },
new SessionData(){ Id = 17, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 17, SessionId = 2 },
new SessionData(){ Id = 18, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 18, SessionId = 2 },
new SessionData(){ Id = 19, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 19, SessionId = 2 },
new SessionData(){ Id = 20, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 20, SessionId = 2 },
new SessionData(){ Id = 21, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 21, SessionId = 2 },
new SessionData(){ Id = 22, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 22, SessionId = 2 },
new SessionData(){ Id = 23, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 23, SessionId = 2 },
new SessionData(){ Id = 24, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 24, SessionId = 2 },
new SessionData(){ Id = 25, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 25, SessionId = 2 },
new SessionData(){ Id = 26, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 26, SessionId = 2 },
new SessionData(){ Id = 27, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 27, SessionId = 2 },
new SessionData(){ Id = 28, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 28, SessionId = 2 },
new SessionData(){ Id = 29, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 29, SessionId = 2 },
new SessionData(){ Id = 30, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 30, SessionId = 2 },
new SessionData(){ Id = 31, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 31, SessionId = 2 },
new SessionData(){ Id = 32, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 32, SessionId = 2 },
new SessionData(){ Id = 33, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 33, SessionId = 2 },
new SessionData(){ Id = 34, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 34, SessionId = 2 },
new SessionData(){ Id = 35, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 35, SessionId = 2 },
new SessionData(){ Id = 36, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 36, SessionId = 2 },
new SessionData(){ Id = 37, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 37, SessionId = 2 },
new SessionData(){ Id = 38, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 38, SessionId = 2 },
new SessionData(){ Id = 39, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 39, SessionId = 2 },
new SessionData(){ Id = 40, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 6, Row = 40, SessionId = 2 }, // interval end
new SessionData(){ Id = 41, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 3, Row = 41, SessionId = 2 },
new SessionData(){ Id = 42, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 0, Row = 42, SessionId = 2 },
// second interval to detect
new SessionData(){ Id = 43, HeartRate = 125, Speed = 214, Cadence = 55, Altitude = 33, Power = 19, Row = 43, SessionId = 2}, // potential interval
new SessionData(){ Id = 44, HeartRate = 129, Speed = 259, Cadence = 60, Altitude = 32, Power = 20, Row = 44, SessionId = 2 },
new SessionData(){ Id = 45, HeartRate = 132, Speed = 308, Cadence = 70, Altitude = 32, Power = 18, Row = 45, SessionId = 2 },
new SessionData(){ Id = 46, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 20, Row = 46, SessionId = 2 },
new SessionData(){ Id = 47, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 23, Row = 47, SessionId = 2 },
new SessionData(){ Id = 48, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 27, Row = 48, SessionId = 2 },
new SessionData(){ Id = 49, HeartRate = 125, Speed = 214, Cadence = 55, Altitude = 33, Power = 30, Row = 49, SessionId = 2 },
new SessionData(){ Id = 50, HeartRate = 129, Speed = 259, Cadence = 60, Altitude = 32, Power = 35, Row = 50, SessionId = 2 },
new SessionData(){ Id = 51, HeartRate = 132, Speed = 308, Cadence = 70, Altitude = 32, Power = 40, Row = 51, SessionId = 2 }, // potential interval start
new SessionData(){ Id = 52, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 52, SessionId = 2 },
new SessionData(){ Id = 53, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 53, SessionId = 2 },
new SessionData(){ Id = 54, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 54, SessionId = 2 },
new SessionData(){ Id = 55, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 55, SessionId = 2 },
new SessionData(){ Id = 56, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 56, SessionId = 2 },
new SessionData(){ Id = 57, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 57, SessionId = 2 },
new SessionData(){ Id = 58, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 58, SessionId = 2 },
new SessionData(){ Id = 59, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 59, SessionId = 2 },
new SessionData(){ Id = 60, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 60, SessionId = 2 },
new SessionData(){ Id = 61, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 61, SessionId = 2 },
new SessionData(){ Id = 62, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 62, SessionId = 2 },
new SessionData(){ Id = 63, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 39, Row = 63, SessionId = 2 },
new SessionData(){ Id = 64, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 64, SessionId = 2 },
new SessionData(){ Id = 65, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 65, SessionId = 2 },
new SessionData(){ Id = 66, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 66, SessionId = 2 },
new SessionData(){ Id = 67, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 67, SessionId = 2 },
new SessionData(){ Id = 68, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 68, SessionId = 2 },
new SessionData(){ Id = 69, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 69, SessionId = 2 },
new SessionData(){ Id = 70, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 70, SessionId = 2 },
new SessionData(){ Id = 71, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 71, SessionId = 2 },
new SessionData(){ Id = 72, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 72, SessionId = 2 },
new SessionData(){ Id = 73, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 73, SessionId = 2 },
new SessionData(){ Id = 74, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 74, SessionId = 2 },
new SessionData(){ Id = 75, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 75, SessionId = 2 },
new SessionData(){ Id = 76, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 76, SessionId = 2 },
new SessionData(){ Id = 77, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 39, Row = 77, SessionId = 2 },
new SessionData(){ Id = 78, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 40, Row = 78, SessionId = 2 },
new SessionData(){ Id = 79, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 79, SessionId = 2 },
new SessionData(){ Id = 80, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 80, SessionId = 2 },
new SessionData(){ Id = 81, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 39, Row = 81, SessionId = 2 },
new SessionData(){ Id = 82, HeartRate = 135, Speed = 322, Cadence = 79, Altitude = 32, Power = 6, Row = 82, SessionId = 2 }, // interval end
new SessionData(){ Id = 83, HeartRate = 139, Speed = 334, Cadence = 90, Altitude = 32, Power = 3, Row = 83, SessionId = 2 },
new SessionData(){ Id = 84, HeartRate = 145, Speed = 338, Cadence = 92, Altitude = 32, Power = 0, Row = 84, SessionId = 2 }
};
_sessionList = new List<Session>()
{
new Session(){ Id = 1, Date = new DateTime(2009, 07, 25, 14 ,26, 18, 0), Length = new DateTime(2009, 07, 25, 1, 14, 21, 100), Interval = 1, SMode = 000000000, SessionData = _sessionDataList, AthleteId = 1},
new Session(){ Id = 2, Date = new DateTime(2010, 07, 25, 14 ,26, 18, 0), Length = new DateTime(2009, 07, 25, 1, 14, 21, 100), Interval = 1, SMode = 000000010, SessionData = _sessionDataList, AthleteId = 1 }
};
_athleteList = new List<Athlete>()
{
new Athlete(){ Id = 1, FunctionalThresholdPower = 320}
};
// convert the IEnumerable _sessionList to an IQueryable list
IQueryable<Session> queryableListSession = _sessionList.AsQueryable();
// convert the IEnumerable _sessionDataList to an IQueryable list
IQueryable<SessionData> queryableListSessionData = _sessionDataList.AsQueryable();
// convert the IEnumerable _athleteList to an IQueryable list
IQueryable<Athlete> queryableListAthlete = _athleteList.AsQueryable();
// force DbSet to return the IQueryable members of converted list object as its data source
var mockSetSession = new Mock<DbSet<Session>>();
mockSetSession.As<IQueryable<Session>>().Setup(m => m.Provider).Returns(queryableListSession.Provider);
mockSetSession.As<IQueryable<Session>>().Setup(m => m.Expression).Returns(queryableListSession.Expression);
mockSetSession.As<IQueryable<Session>>().Setup(m => m.ElementType).Returns(queryableListSession.ElementType);
mockSetSession.As<IQueryable<Session>>().Setup(m => m.GetEnumerator()).Returns(queryableListSession.GetEnumerator());
// force DbSet to return the IQueryable members of converted list object as its data source
var mockSetSessionData = new Mock<DbSet<SessionData>>();
mockSetSessionData.As<IQueryable<SessionData>>().Setup(m => m.Provider).Returns(queryableListSessionData.Provider);
mockSetSessionData.As<IQueryable<SessionData>>().Setup(m => m.Expression).Returns(queryableListSessionData.Expression);
mockSetSessionData.As<IQueryable<SessionData>>().Setup(m => m.ElementType).Returns(queryableListSessionData.ElementType);
mockSetSessionData.As<IQueryable<SessionData>>().Setup(m => m.GetEnumerator()).Returns(queryableListSessionData.GetEnumerator());
// force DbSet to return the IQueryable members of converted list object as its data source
var mockSetAthlete = new Mock<DbSet<Athlete>>();
mockSetAthlete.As<IQueryable<Athlete>>().Setup(m => m.Provider).Returns(queryableListAthlete.Provider);
mockSetAthlete.As<IQueryable<Athlete>>().Setup(m => m.Expression).Returns(queryableListAthlete.Expression);
mockSetAthlete.As<IQueryable<Athlete>>().Setup(m => m.ElementType).Returns(queryableListAthlete.ElementType);
mockSetAthlete.As<IQueryable<Athlete>>().Setup(m => m.GetEnumerator()).Returns(queryableListAthlete.GetEnumerator());
// context class will return mocked DbSets
_context.Sessions = mockSetSession.Object;
_context.SessionData = mockSetSessionData.Object;
_context.Athletes = mockSetAthlete.Object;
// pass context to repository
_sessionRepository = new SessionRepository(_context);
}
public UserRepository(CycleAnalysisContext context)
{
_context = context;
}
public AthleteRepository(CycleAnalysisContext context)
{
_context = context;
}
