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