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 TestFind()
{
Support.ExecSql(@"insert into time_entries (id, project_id, user_id, date, hours)
values (2346, 22, 12, now(), 8);");
var gateway = new TimeEntryDataGateway(new TimeEntryContext(DbContextOptions));
var list = gateway.FindBy(12);
// todo...
var actual = list.First();
Assert.Equal(2346, actual.Id);
Assert.Equal(22, actual.ProjectId);
Assert.Equal(12, actual.UserId);
}
public void TestFind()
{
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');
insert into time_entries (id, project_id, user_id, date, hours) values (2346, 22, 12, now(), 8);
");
var gateway = new TimeEntryDataGateway(new DatabaseTemplate(_dataSourceConfig));
var list = gateway.FindBy(12);
// todo...
var actual = list.First();
Assert.Equal(2346, actual.Id);
Assert.Equal(22, actual.ProjectId);
Assert.Equal(12, actual.UserId);
}
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 TimeEntryDataGateway(new DatabaseTemplate(_dataSourceConfig));
gateway.Create(22, 12, DateTime.Now, 8);
// todo...
var template = new DatabaseTemplate(_dataSourceConfig);
var projectIds = template.Query("select project_id from time_entries", reader => reader.GetInt64(0),
new List <DbParameter>());
Assert.Equal(22, projectIds.First());
}
