private static void ResetFromFixtureSheet(SqlConnectionAdapter conn, IExcelDataReader excelReader)
{
var schemas = ReadSchemas(excelReader);
PopulateAll(conn, schemas);
}
private static void PopulateAll(SqlConnectionAdapter conn, List<Schema> schemas)
{
foreach (var sql in schemas.Select(s => "disable trigger all on " + s.TableName))
{
conn.ExecuteNonQuery(sql);
}
foreach (var sql in from s in schemas where s.HasIdentityKey() select "set identity_insert " + s.TableName + " on")
{
conn.ExecuteNonQuery(sql);
}
schemas.Reverse();
foreach (var s in schemas)
{
var dt = s.DataTable;
if (dt == null)
{
var sql = s.AsDeleteAllSql();
conn.ExecuteNonQuery(sql);
continue;
}
foreach (DataRow dr in dt.Rows)
{
var sql = s.AsDeleteRowSql(dr);
conn.ExecuteNonQuery(sql);
}
}
schemas.Reverse();
foreach (var s in schemas)
{
var dt = s.DataTable;
if(dt == null)
{
continue;
}
foreach (var sql in from DataRow dr in dt.Rows select s.AsInsertSql(dr))
{
conn.ExecuteNonQuery(sql);
}
}
foreach (var sql in from s in schemas where s.HasIdentityKey() select "set identity_insert " + s.TableName + " off")
{
conn.ExecuteNonQuery(sql);
}
foreach (var sql in schemas.Select(s => "enable trigger all on " + s.TableName))
{
conn.ExecuteNonQuery(sql);
}
}
private static void PopulateAll(SqlConnectionAdapter conn, List <Schema> schemas)
{
foreach (var sql in schemas.Select(s => "disable trigger all on " + s.TableName))
{
conn.ExecuteNonQuery(sql);
}
foreach (var sql in from s in schemas where s.HasIdentityKey() select "set identity_insert " + s.TableName + " on")
{
conn.ExecuteNonQuery(sql);
}
schemas.Reverse();
foreach (var s in schemas)
{
var dt = s.DataTable;
if (dt == null)
{
var sql = s.AsDeleteAllSql();
conn.ExecuteNonQuery(sql);
continue;
}
foreach (DataRow dr in dt.Rows)
{
var sql = s.AsDeleteRowSql(dr);
conn.ExecuteNonQuery(sql);
}
}
schemas.Reverse();
foreach (var s in schemas)
{
var dt = s.DataTable;
if (dt == null)
{
continue;
}
foreach (var sql in from DataRow dr in dt.Rows select s.AsInsertSql(dr))
{
conn.ExecuteNonQuery(sql);
}
}
foreach (var sql in from s in schemas where s.HasIdentityKey() select "set identity_insert " + s.TableName + " off")
{
conn.ExecuteNonQuery(sql);
}
foreach (var sql in schemas.Select(s => "enable trigger all on " + s.TableName))
{
conn.ExecuteNonQuery(sql);
}
}
public ResetDatabase(SqlConnectionAdapter conn)
{
_conn = conn;
}
private static void ResetFromFixtureSheet(SqlConnectionAdapter conn, IExcelDataReader excelReader)
{
var schemas = ReadSchemas(excelReader);
PopulateAll(conn, schemas);
}
public ResetDatabase(SqlConnectionAdapter conn)
{
_conn = conn;
}