public void TestFormatBody_DontAddDilimiter()
{
var service = new SqlQueryService();
var result = service.FormatBody("select * from users;");
Assert.AreEqual("select * from users;", result);
}
public void CreateEmptyTable()
{
var service = new SqlQueryService();
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);
}
public SqlQueryService GetService()
{
var service = new SqlQueryService();
return(service);
}
