public void TestCreate()
{
var gateway = new UserDataGateway(new UserContext(DbContextOptions));
gateway.Create("aUser");
var names = Support.QuerySql("select name from users");
Assert.Equal("aUser", names[0]["name"]);
}
public void TestCreate()
{
var gateway = new TimeEntryDataGateway(new TimeEntryContext(DbContextOptions));
gateway.Create(22, 12, DateTime.Now, 8);
// todo...
var projectIds = Support.QuerySql("select project_id from time_entries");
Assert.Equal(22L, projectIds[0]["project_id"]);
}
public void TestCreate()
{
var gateway = new AllocationDataGateway(new AllocationContext(DbContextOptions));
gateway.Create(22, 12, DateTime.Now, DateTime.Now);
// todo...
var projectIds = Support.QuerySql("select project_id from allocations");
Assert.Equal(22L, projectIds[0]["project_id"]);
}
public void TestCreate()
{
var gateway = new StoryDataGateway(new StoryContext(DbContextOptions));
gateway.Create(22, "aStory");
// todo...
var projectIds = Support.QuerySql("select project_id from stories");
Assert.Equal(22L, projectIds[0]["project_id"]);
}
public void TestCreate()
{
Support.ExecSql("insert into users (id, name) values (12, 'Jack');");
var gateway = new AccountDataGateway(new AccountContext(DbContextOptions));
gateway.Create(12, "anAccount");
var names = Support.QuerySql("select name from accounts");
Assert.Equal("anAccount", names[0]["name"]);
}
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"]);
}