public void TestSeed()
{
var tableName = "sqlfile_users";
EasyMig.SeedTable(tableName)
.Insert(SeedData.New.Set("username", "user1").Set("age", 20));
EasyMig.ToSqlServer.DoSeedFromMemory(connectionString);
var tableRows = EasyMig.Information.SqlServerAttachedDbFile.GetTableRows(tableName, connectionString);
Assert.AreEqual(1, tableRows.Count);
Assert.AreEqual(1, ((int)tableRows[0]["id"]));
Assert.AreEqual("user1", (string)tableRows[0]["username"]);
Assert.AreEqual(20, ((int)tableRows[0]["age"]));
}
public void TestSeed()
{
this.BeforeEach();
var dbName = "db1";
var tableName = "users";
EasyMig.SeedTable(tableName)
.Insert(SeedData.New.Set("username", "user1").Set("age", 20));
var query = EasyMig.ToMySql.GetSeedQuery();
EasyMig.ToMySql.ExecuteQuery(query, completeConnectionString);
var tableRows = EasyMig.Information.MySql.GetTableRows(tableName, completeConnectionString);
Assert.AreEqual(1, tableRows.Count);
Assert.AreEqual((uint)1, ((uint)tableRows[0]["id"]));
Assert.AreEqual("user1", (string)tableRows[0]["username"]);
Assert.AreEqual(20, ((int)tableRows[0]["age"]));
}
public void TestSeed_WithSeedShortCut()
{
var tableName = "sql_users";
EasyMig.SeedTable(tableName)
.Insert(SeedData.New.Set("username", "user2").Set("age", 30));
EasyMig.ToSqlServer.DoSeedFromMemory(connectionString);
var tableRows = EasyMig.Information.SqlServer.GetTableRows(tableName, connectionString);
Assert.AreEqual(2, tableRows.Count);
Assert.AreEqual(1, ((int)tableRows[0]["id"]));
Assert.AreEqual("user1", (string)tableRows[0]["username"]);
Assert.AreEqual(20, ((int)tableRows[0]["age"]));
Assert.AreEqual(2, ((int)tableRows[1]["id"]));
Assert.AreEqual("user2", (string)tableRows[1]["username"]);
Assert.AreEqual(30, ((int)tableRows[1]["age"]));
}
public void TestSeed_WithSeedShortCut()
{
this.BeforeEach();
var tableName = "users";
EasyMig.SeedTable(tableName)
.Insert(SeedData.New.Set("username", "user2").Set("age", 30));
EasyMig.ToMySql.DoSeedFromMemory(completeConnectionString);
var tableRows = EasyMig.Information.MySql.GetTableRows(tableName, completeConnectionString);
Assert.AreEqual(2, tableRows.Count);
Assert.AreEqual((uint)1, ((uint)tableRows[0]["id"]));
Assert.AreEqual("user1", (string)tableRows[0]["username"]);
Assert.AreEqual(20, ((int)tableRows[0]["age"]));
Assert.AreEqual((uint)2, ((uint)tableRows[1]["id"]));
Assert.AreEqual("user2", (string)tableRows[1]["username"]);
Assert.AreEqual(30, ((int)tableRows[1]["age"]));
}
