public void TestCreate()
{
var template = new DatabaseTemplate(_dataSourceConfig);
var gateway = new UserDataGateway(template);
gateway.Create("aUser");
var names = template.Query("select name from users", reader => reader.GetString(0),
new List <DbParameter>());
Assert.Equal("aUser", names.First());
}
public void TestCreate()
{
var support = new TestDatabaseSupport(_dataSourceConfig);
support.ExecSql(@"
insert into users (id, name) values (12, 'Jack');
");
var template = new DatabaseTemplate(_dataSourceConfig);
var gateway = new AccountDataGateway(template);
gateway.Create(12, "anAccount");
var names = template.Query("select name from accounts", reader => reader.GetString(0),
new List <DbParameter>());
Assert.Equal("anAccount", names.First());
}
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');
insert into projects (id, account_id, name) values (22, 1, 'aProject');
");
var gateway = new AllocationDataGateway(new DatabaseTemplate(_dataSourceConfig));
gateway.Create(22, 12, DateTime.Now, DateTime.Now);
// todo...
var template = new DatabaseTemplate(_dataSourceConfig);
var projectIds = template.Query("select project_id from allocations", reader => reader.GetInt64(0),
new List <DbParameter>());
Assert.Equal(22, projectIds.First());
}
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());
}