public void LinqSelectTest() { IDatabase fakeDb = DatabaseFactory.CreateDatabase("", "System.Data.SqlClient"); TestEntityRepository repository = new TestEntityRepository(fakeDb); SelectCommand expectedCommand = fakeDb.CreateSelectCommand(repository.TableName) .Querys("TestColumn1", "TestColumn2", "TestColumn5", "TestColumn8") .Query("TestColumn3", "TTTT") .Query(SqlAggregateFunction.Max, "TestColumn4", "MMMM") .Where(c => c.GreaterThanOrEqual("TestColumn2", 123) | (c.GreaterThan("TestColumn4", DateTime.Now) & c.LessThan("TestColumn7", DateTime.Now.AddDays(7)))) .GroupBy("TestColumn3") .InnerJoin("TestColumn2", "TestTable", "TestColumn2") .OrderBy("TestTable", "TestColumn6", SqlOrderType.Asc); SelectCommand actualCommand = fakeDb.CreateSelectCommand(repository.TableName) .Querys<TestEntity>(c => new { c.Test1, c.Test2, c.Test5, c.Test8 }) .Query<TestEntity>(c => c.Test3, "TTTT") .Query<TestEntity>(c => c.Test4, SqlAggregateFunction.Max, "MMMM") .Where<TestEntity>(c => c.Test2 >= 123 || (c.Test4 > DateTime.Now && c.Test7 < DateTime.Now.AddDays(7))) .GroupBy<TestEntity>(c => c.Test3) .InnerJoin<TestEntity, TestEntity>(c => c.Test2, d => d.Test2) .OrderBy<TestEntity>(c => c.Test6, SqlOrderType.Asc); Assert.AreEqual(expectedCommand, actualCommand); }
public void EntityUpdateTest() { AbstractDatabase fakeDb = DatabaseFactory.CreateDatabase("", "System.Data.SqlClient") as AbstractDatabase; TestEntityRepository repository = new TestEntityRepository(fakeDb); TestEntity entity = new TestEntity() { Test1 = "1", Test2 = 2, Test3 = 3.0, Test4 = DateTime.Now, Test8 = 8 }; String expectedSql = "UPDATE TestTable SET TestColumn1=@PN_IDX_0,TestColumn2=@PN_IDX_1,TestColumn3=@PN_IDX_2,TestColumn4=@PN_IDX_3,TestColumn5=@PN_IDX_4,TestColumn6=@PN_IDX_5,TestColumn7=@PN_IDX_6,TestColumn8=@PN_IDX_7"; DataParameter[] expectedParameter = new DataParameter[8] { DataParameter.InternalCreate(fakeDb, "TestColumn1", "0", entity.Test1), DataParameter.InternalCreate(fakeDb, "TestColumn2", "1", entity.Test2), DataParameter.InternalCreate(fakeDb, "TestColumn3", "2", entity.Test3), DataParameter.InternalCreate(fakeDb, "TestColumn4", "3", entity.Test4), DataParameter.InternalCreate(fakeDb, "TestColumn5", "4", DataType.Int32, entity.Test5), DataParameter.InternalCreate(fakeDb, "TestColumn6", "5", DataType.Double, entity.Test6), DataParameter.InternalCreate(fakeDb, "TestColumn7", "6", DataType.DateTime, entity.Test7), DataParameter.InternalCreate(fakeDb, "TestColumn8", "7", DataType.Int16, entity.Test8) }; UpdateCommand cmd = fakeDb.CreateUpdateCommand(repository.TableName).Set(entity); String actualSql = cmd.GetCommandText().Trim(); DataParameter[] actualParameter = cmd.GetAllParameters(); Assert.AreEqual(expectedSql, actualSql); for (Int32 i = 0; i < actualParameter.Length; i++) { Assert.AreEqual(expectedParameter[i], actualParameter[i]); } }
public void Setup() { var options = new DbContextOptionsBuilder <TestContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; _context = new TestContext(options); _repository = new TestEntityRepository(_context); DateTime now = DateTime.UtcNow; _entity = new TestEntity { Created = now, Id = Guid.NewGuid(), Updated = now, Property = string.Empty }; _context.Table.Add(_entity); _listEntities = GetTestList(); _context.Table.AddRange(_listEntities); _context.SaveChanges(); _repository = new TestEntityRepository(_context); }
public IActionResult GetById(long entityId) { var entity = TestEntityRepository.GetById(entityId); if (entity == null) { throw new Exception($"Nincs ilyen rekord! id: {entityId}"); } return(Json(new { entity })); }
public IActionResult StepOne(long entityId) { var entity = TestEntityRepository.GetById(entityId); var change = StateChangeFactory.CreateChange(typeof(OneToTwoChange)) as OneToTwoChange; change.SetEntity(entity); StateManagger.ManageTransition(change, TestEntityStates.SecondPlace); TestEntityRepository.SaveChanges(); return(Json(new { })); }
public IActionResult Create([FromBody] string message) { var entity = new TestEntityModel { Message = message }; TestEntityRepository.Add(entity); TestEntityRepository.SaveChanges(); return(Json(new { entity.Id })); }
public IActionResult StepFour(long entityId, [FromBody] FourToFiveVM fourToFiveVM) { var entity = TestEntityRepository.GetById(entityId); var change = StateChangeFactory.CreateChange(typeof(FourToFiveChange)) as FourToFiveChange; change.SetEntity(entity); StateManagger.ManageTransition(change, TestEntityStates.FifthPlace, fourToFiveVM); TestEntityRepository.SaveChanges(); return(Json(new { })); }
public IActionResult StepThree(long entityId) { var entity = TestEntityRepository.GetById(entityId); var change = StateChangeFactory.CreateChange(typeof(ThreeToFourChange)) as ThreeToFourChange; change.SetEntity(entity); change.SetPreviousStep(typeof(TwoToThreeChange).FullName); StateManagger.ManageTransition <TestEntityModel, TestEntityStates, BasicTask, BasicTaskAcl>(change, TestEntityStates.FourthPlace, secureBasicTaskRepository); TestEntityRepository.SaveChanges(); return(Json(new { })); }
public IActionResult StepTwo(long entityId) { var entity = TestEntityRepository.GetById(entityId); var change = StateChangeFactory.CreateChange(typeof(TwoToThreeChange)) as TwoToThreeChange; change.SetEntity(entity); var tasks = StateManagger.ManageTransition <TestEntityModel, TestEntityStates, BasicTask, BasicTaskAcl>(change, TestEntityStates.ThirdPlace, secureBasicTaskRepository); //TestEntityRepository.SaveChanges(); return(Json(new { ids = tasks.Select(x => x.Id) })); }
public void Initialise() { this.repository = new TestEntityRepository(base.DataContext); this.unitOfWork = base.Services.GetService <IUnitOfWork>(); var entities = new TestEntity[] { new TestEntity { Name = "Update Me", CreatedDate = DateTime.Now.Date }, new TestEntity { Name = "Delete Me", CreatedDate = DateTime.Now.Date } }; this.repository.Insert(entities); unitOfWork.Commit(); }
public void LinqInsertTest() { AbstractDatabase fakeDb = DatabaseFactory.CreateDatabase("", "System.Data.SqlClient") as AbstractDatabase; TestEntityRepository repository = new TestEntityRepository(fakeDb); TestEntity entity = new TestEntity() { Test1 = "1", Test2 = 2, Test3 = 3.0, Test4 = DateTime.Now, Test8 = 8 }; String expectedSql = "INSERT INTO TestTable ( TestColumn1,TestColumn2,TestColumn3,TestColumn4,TestColumn5,TestColumn6,TestColumn7,TestColumn8 ) " + "VALUES ( @PN_IDX_0,@PN_IDX_1,@PN_IDX_2,@PN_IDX_3,@PN_IDX_4,@PN_IDX_5,@PN_IDX_6,@PN_IDX_7 )"; DataParameter[] expectedParameter = new DataParameter[8] { DataParameter.InternalCreate(fakeDb, "TestColumn1", "0", entity.Test1), DataParameter.InternalCreate(fakeDb, "TestColumn2", "1", entity.Test2), DataParameter.InternalCreate(fakeDb, "TestColumn3", "2", entity.Test3), DataParameter.InternalCreate(fakeDb, "TestColumn4", "3", entity.Test4), DataParameter.InternalCreate(fakeDb, "TestColumn5", "4", DataType.Int32, entity.Test5), DataParameter.InternalCreate(fakeDb, "TestColumn6", "5", DataType.Double, entity.Test6), DataParameter.InternalCreate(fakeDb, "TestColumn7", "6", DataType.DateTime, entity.Test7), DataParameter.InternalCreate(fakeDb, "TestColumn8", "7", DataType.Int16, entity.Test8) }; InsertCommand cmd = fakeDb.CreateInsertCommand(repository.TableName) .Set<TestEntity>(c => c.Test1, entity.Test1) .Set<TestEntity>(c => c.Test2, entity.Test2) .Set<TestEntity>(c => c.Test3, entity.Test3) .Set<TestEntity>(c => c.Test4, entity.Test4) .Set<TestEntity>(c => c.Test5, entity.Test5) .Set<TestEntity>(c => c.Test6, entity.Test6) .Set<TestEntity>(c => c.Test7, entity.Test7) .Set<TestEntity>(c => c.Test8, entity.Test8); String actualSql = cmd.GetCommandText().Trim(); DataParameter[] actualParameter = cmd.GetAllParameters(); Assert.AreEqual(expectedSql, actualSql); for (Int32 i = 0; i < actualParameter.Length; i++) { Assert.AreEqual(expectedParameter[i], actualParameter[i]); } }
public TestComponent() { _testEntityRepository = new TestEntityRepository(); }
public void Setup() { this.repository = Kernel.Get <TestEntityRepository>(); }
public void LinqIncreaseTest() { AbstractDatabase fakeDb = DatabaseFactory.CreateDatabase("", "System.Data.SqlClient") as AbstractDatabase; TestEntityRepository repository = new TestEntityRepository(fakeDb); TestEntity entity = new TestEntity() { Test1 = "1", Test2 = 2, Test3 = 3.0, Test4 = DateTime.Now, Test8 = 8 }; String expectedSql = "UPDATE TestTable SET TestColumn2=(TestColumn2+1)"; DataParameter[] expectedParameter = new DataParameter[0]; UpdateCommand cmd = fakeDb.CreateUpdateCommand(repository.TableName).Increase<TestEntity>(c => c.Test2); String actualSql = cmd.GetCommandText().Trim(); DataParameter[] actualParameter = cmd.GetAllParameters(); Assert.AreEqual(expectedSql, actualSql); Assert.AreEqual(expectedParameter.Length, actualParameter.Length); }
static SelectCommandCreateTest() { _repository = new TestEntityRepository(); }
static InsertCommandCreateTest() { _repository = new TestEntityRepository(); _entity = new TestEntity() { Test1 = "1", Test2 = 2, Test3 = 3.0, Test4 = DateTime.Now, Test8 = 8 }; }