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());
}
