public void TestFormatBody_DontAddDilimiter()
{
var service = new MySqlQueryService();
var result = service.FormatBody("select * from users;");
Assert.AreEqual("select * from users;", result);
}
public void TestChangeEngine()
{
var service = new MySqlQueryService("MyISAM");
var table = new CreateTableSchema("table1")
.AddColumn("column1");
var result = service.GetCreateTable(table);
var expected = "CREATE TABLE `table1` (\r\t`column1` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL\r) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r";
Assert.AreEqual(expected, result);
}
public void CreateEmptyTable_WithMySql()
{
var service = new MySqlQueryService();
var result = DbHelper.TryCreateEmptyTable <User>(service.DefaultPrimaryKeyName);
Assert.AreEqual("User", result.TableName);
Assert.AreEqual(typeof(User), result.ModelType);
Assert.AreEqual(1, result.MappingByColumnName.Count);
Assert.AreEqual(1, result.PrimaryKeys.Count());
Assert.AreEqual("id", result.PrimaryKeys[0].ColumnName); // <=
Assert.AreEqual("User", result.PrimaryKeys[0].TableName);
Assert.AreEqual(typeof(User), result.PrimaryKeys[0].ModelType);
Assert.AreEqual("Id", result.PrimaryKeys[0].PropertyName);
Assert.AreEqual(true, result.PrimaryKeys[0].IsDatabaseGenerated);
Assert.AreEqual(false, result.PrimaryKeys[0].IsIgnored);
}
