public BaseAggregationDslFixture(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
rows = new List <Row>();
AddRow("milk", 15);
AddRow("milk", 15);
AddRow("sugar", 10);
AddRow("sugar", 15);
AddRow("coffee", 6);
AddRow("sugar", 3);
}
public BaseUserToPeopleDslTest(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
Use.Transaction(TestDatabase.ConnectionString, cmd =>
{
cmd.CommandText =
@"
if object_id('User2Role') is not null
drop table User2Role;
if object_id('Roles') is not null
drop table Roles;
if object_id('Users') is not null
drop table Users;
create table Users ( id int identity primary key, name nvarchar(255) not null, email nvarchar(255) not null, roles nvarchar(255), testMsg nvarchar(255) );
create table Roles( id int identity, name nvarchar(255) );
create table User2Role( userid int, roleid int);
insert into users (name,email) values('ayende rahien', '*****@*****.**')
insert into users (name,email) values('foo bar', '*****@*****.**')
insert into users (name,email) values('nice naughty', '*****@*****.**')
insert into users (name,email) values('gold silver', '*****@*****.**')
insert into roles values('admin')
insert into roles values('janitor')
insert into roles values('employee')
insert into roles values('customer')
insert into User2Role values(1,1)
insert into User2Role values(1,2)
insert into User2Role values(1,3)
insert into User2Role values(1,4)
insert into User2Role values(2,2)
insert into User2Role values(4,2)
insert into User2Role values(4,3)
if object_id('People') is not null
drop table People;
create table People ( id int identity, userid int not null, firstname nvarchar(255) not null, lastname nvarchar(255) not null, email nvarchar(255) not null);
";
cmd.ExecuteNonQuery();
});
}
public SqlBulkInsertFixture(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
}
public DatabaseToDatabaseWithTransformFixture(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
}
public WireEtlProcessEventsFixture(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
}
public BaseDslTest(DslTestDatabaseFixture testDatabase)
{
this.TestDatabase = testDatabase;
}
public HashJoinFixture(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
}
public AggregationFixture(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
}
public InputTimeoutFixture(DslTestDatabaseFixture testDatabase)
: base(testDatabase)
{
}
