public void Data_Read_Session() { var repository = new SessionRepository(_dataConnectionString, 1); var data = repository.Get(1); Assert.IsTrue(data.SessionID == 1); Assert.IsTrue(data.Key == "USER1SESSION"); }
public void Data_Read_Other_User_Session() { var repository = new SessionRepository(_dataConnectionString, 1); var data = repository.Get(4); Assert.IsTrue(data == null); }
public void Data_Delete_Session_By_Key() { var repository = new SessionRepository(_dataConnectionString, 1); var result = repository.DeleteByKey("USER1SESSION"); var session = repository.Get(1); Assert.IsTrue(session == null); Assert.IsTrue(result.Deleted == true); Assert.IsTrue(result.DeletedBy == 1); Assert.IsTrue(result.DeletedDate.Value.Date == DateTime.Now.Date); }
public void Data_Delete_Session_Expired() { var repository = new SessionRepository(_dataConnectionString, 1); repository.DeleteExpired(); var session = repository.Get(2); Assert.IsTrue(session == null); // Read the database directly and check the expired session is now marked as deleted using (var conn = new SqlConnection(_dataConnectionString)) { conn.Open(); var expiredSession = conn.Query<Session>("SELECT * FROM [dbo].[Sessions] WHERE [Key] = 'USER1SESSIONEXPIRED'").Single(); Assert.IsTrue(expiredSession.Deleted == true); Assert.IsTrue(expiredSession.DeletedBy == 1); Assert.IsTrue(expiredSession.DeletedDate.Value.Date == DateTime.Now.Date); } }
public void Data_Update_Session() { var repository = new SessionRepository(_dataConnectionString, 1); var session = repository.Get(1); session.Key = "UPDATED"; session.Expiry = new DateTime(2020, 2, 2); var result = repository.Update(session); Assert.IsTrue(result.Key == "UPDATED"); Assert.IsTrue(result.Expiry.Date == new DateTime(2020, 2, 2).Date); Assert.IsTrue(result.LastModifiedBy == 1); Assert.IsTrue(result.LastModifiedDate.Date == DateTime.Now.Date); }