public void TestCreate() { Support.ExecSql(@" insert into users (id, name) values (12, 'Jack'); insert into accounts (id, owner_id, name) values (1, 12, 'anAccount');"); var gateway = new ProjectDataGateway(new ProjectContext(DbContextOptions)); gateway.Create(1, "aProject"); // todo... var projects = Support.QuerySql("select name from projects where account_id = 1"); Assert.Equal("aProject", projects[0]["name"]); }
public void TestFindObject() { Support.ExecSql(@" insert into users (id, name) values (12, 'Jack'); insert into accounts (id, owner_id, name) values (1, 12, 'anAccount'); insert into projects (id, account_id, name, active) values (22, 1, 'aProject', true);"); var gateway = new ProjectDataGateway(new ProjectContext(DbContextOptions)); var actual = gateway.FindObject(22); // todo... Assert.Equal(22, actual.Id); Assert.Equal(1, actual.AccountId); Assert.Equal("aProject", actual.Name); Assert.True(actual.Active); Assert.Null(gateway.FindObject(23)); }
public void TestFind() { Support.ExecSql(@" insert into users (id, name) values (12, 'Jack'); insert into accounts (id, owner_id, name) values (1, 12, 'anAccount'); insert into projects (id, account_id, name) values (22, 1, 'aProject');"); var gateway = new ProjectDataGateway(new ProjectContext(DbContextOptions)); var list = gateway.FindBy(1); // todo... var actual = list.First(); Assert.Equal(22, actual.Id); Assert.Equal(1, actual.AccountId); Assert.Equal("aProject", actual.Name); Assert.Equal(true, actual.Active); }
public void TestFindObject() { var support = new TestDatabaseSupport(_dataSourceConfig); support.ExecSql(@" insert into users (id, name) values (12, 'Jack'); insert into accounts (id, owner_id, name) values (1, 12, 'anAccount'); insert into projects (id, account_id, name, active) values (22, 1, 'aProject', true); "); var gateway = new ProjectDataGateway(new DatabaseTemplate(_dataSourceConfig)); var actual = gateway.FindObject(22); // todo... Assert.Equal(22, actual.Id); Assert.Equal(1, actual.AccountId); Assert.Equal("aProject", actual.Name); Assert.Equal(true, actual.Active); }
public void TestCreate() { var support = new TestDatabaseSupport(_dataSourceConfig); support.ExecSql(@" insert into users (id, name) values (12, 'Jack'); insert into accounts (id, owner_id, name) values (1, 12, 'anAccount'); "); var gateway = new ProjectDataGateway(new DatabaseTemplate(_dataSourceConfig)); gateway.Create(1, "aProject"); // todo... var template = new DatabaseTemplate(_dataSourceConfig); var projects = template.Query("select name from projects where account_id = 1", reader => reader.GetString(0), new List <DbParameter>()); Assert.Equal("aProject", projects.First()); }