public TrackableContainerTest(IDbConnectionProvider dbConnectionProvider, ISqlProvider sqlProvider)
: base(useList: false, useSet: true, useDuplicateCheck: true)
{
_db = dbConnectionProvider;
_mapper = new TrackableContainerSqlMapper <ITestContainer>(
sqlProvider,
new[]
{
Tuple.Create("Person", new object[]
{
"TrackableContainerPerson",
new[] { new ColumnDefinition("ContainerId", typeof(int)) }
}),
Tuple.Create("Missions", new object[]
{
"TrackableContainerMission",
new ColumnDefinition("MissionId"),
new[] { new ColumnDefinition("ContainerId", typeof(int)) },
}),
Tuple.Create("Aliases", new object[]
{
"TrackableContainerAlias",
new ColumnDefinition("Value", typeof(string), 64),
new[] { new ColumnDefinition("ContainerId", typeof(int)) }
}),
});
_mapper.ResetTableAsync(_db.Connection, true).Wait();
}
public TrackableContainerIgnoreTest(IDbConnectionProvider dbConnectionProvider, ISqlProvider sqlProvider)
{
_db = dbConnectionProvider;
_mapper = new TrackableContainerSqlMapper<ITestContainerWithIgnore>(
sqlProvider,
new[]
{
Tuple.Create("Person", new object[]
{
"TrackableContainerIgnoreTestPerson",
new[] { new ColumnDefinition("ContainerId", typeof(int)) }
}),
});
_mapper.ResetTableAsync(_db.Connection, true).Wait();
}
public TrackableContainerIgnoreTest(IDbConnectionProvider dbConnectionProvider, ISqlProvider sqlProvider)
{
_db = dbConnectionProvider;
_mapper = new TrackableContainerSqlMapper <ITestContainerWithIgnore>(
sqlProvider,
new[]
{
Tuple.Create("Person", new object[]
{
"TrackableContainerIgnoreTestPerson",
new[] { new ColumnDefinition("ContainerId", typeof(int)) }
}),
});
_mapper.ResetTableAsync(_db.Connection, true).Wait();
}
public SqlDriver(ISqlProvider sqlProvider, DbConnection connection)
{
var HeadKeyColumnDefs = new[] { new ColumnDefinition("Uid", typeof(int)) };
_userMapper = new TrackableContainerSqlMapper <IUser>(
MsSqlProvider.Instance,
new[]
{
Tuple.Create("Data", new object[]
{
"tblUser",
HeadKeyColumnDefs
}),
Tuple.Create("Items", new object[]
{
"tblItem",
new ColumnDefinition("ItemId"),
HeadKeyColumnDefs
}),
Tuple.Create("Teams", new object[]
{
"tblTeam",
new ColumnDefinition("TeamId"),
HeadKeyColumnDefs
}),
Tuple.Create("Tanks", new object[]
{
"tblTank",
new ColumnDefinition("TankId"),
HeadKeyColumnDefs
}),
Tuple.Create("Cards", new object[]
{
"tblCard",
new ColumnDefinition("GroupNo"),
new ColumnDefinition("States"),
HeadKeyColumnDefs
}),
Tuple.Create("Friends", new object[]
{
"tblFriend",
new ColumnDefinition("FriendUid"),
HeadKeyColumnDefs
}),
Tuple.Create("Missions", new object[]
{
"tblMission",
new ColumnDefinition("MissionId"),
HeadKeyColumnDefs
}),
Tuple.Create("StageGrades", new object[]
{
"tblStageGrade",
new ColumnDefinition("GroupNo"),
new ColumnDefinition("Grades"),
HeadKeyColumnDefs
}),
Tuple.Create("Posts", new object[]
{
"tblPost",
new ColumnDefinition("PostId"),
HeadKeyColumnDefs
}),
});
_connection = connection;
}
public SqlDriver(ISqlProvider sqlProvider, DbConnection connection)
{
var HeadKeyColumnDefs = new[] { new ColumnDefinition("Uid", typeof(int)) };
_userMapper = new TrackableContainerSqlMapper<IUser>(
MsSqlProvider.Instance,
new[]
{
Tuple.Create("Data", new object[]
{
"tblUser",
HeadKeyColumnDefs
}),
Tuple.Create("Items", new object[]
{
"tblItem",
new ColumnDefinition("ItemId"),
HeadKeyColumnDefs
}),
Tuple.Create("Teams", new object[]
{
"tblTeam",
new ColumnDefinition("TeamId"),
HeadKeyColumnDefs
}),
Tuple.Create("Tanks", new object[]
{
"tblTank",
new ColumnDefinition("TankId"),
HeadKeyColumnDefs
}),
Tuple.Create("Cards", new object[]
{
"tblCard",
new ColumnDefinition("GroupNo"),
new ColumnDefinition("States"),
HeadKeyColumnDefs
}),
Tuple.Create("Friends", new object[]
{
"tblFriend",
new ColumnDefinition("FriendUid"),
HeadKeyColumnDefs
}),
Tuple.Create("Missions", new object[]
{
"tblMission",
new ColumnDefinition("MissionId"),
HeadKeyColumnDefs
}),
Tuple.Create("StageGrades", new object[]
{
"tblStageGrade",
new ColumnDefinition("GroupNo"),
new ColumnDefinition("Grades"),
HeadKeyColumnDefs
}),
Tuple.Create("Posts", new object[]
{
"tblPost",
new ColumnDefinition("PostId"),
HeadKeyColumnDefs
}),
});
_connection = connection;
}
