public void TestMethodUpdateOuputSqlAndListOfParameter()
{
var created = DateTime.Now.AddDays(-1);
SqlBuilder raw = new SqlBuilder();
SqlBuilderUpdate updateSqlServer = raw.UpdateFrom("People", SqlServerProvider);
SqlBuilderUpdate updateMysqlServer = raw.UpdateFrom("People", MysqlServerProvider);
SqlBuilderUpdate updatePostgresServer = raw.UpdateFrom("People", PostgresServerProvider);
(string Sql, List <object> Values, object ClassObject)SqlSqlServer = updateSqlServer.AddColumns("Name", "Created").AddValues("Name 1", created).Where("Id", 1).ToSqlBinding();
(string Sql, List <object> Values, object ClassObject)SqlMySqlServer = updateMysqlServer.AddColumns("Name", "Created").AddValues("Name 1", created).Where("Id", 1).ToSqlBinding();
(string Sql, List <object> Values, object ClassObject)SqlPostgresServer = updatePostgresServer.AddColumns("Name", "Created").AddValues("Name 1", created).Where("Id", 1).ToSqlBinding();
Assert.AreEqual($"UPDATE [People] SET [Name]=@p0,[Created]=@p1 WHERE [Id]=@p2", SqlSqlServer.Sql);
Assert.AreEqual($"UPDATE `People` SET `Name`=@p0,`Created`=@p1 WHERE `Id`=@p2", SqlMySqlServer.Sql);
Assert.AreEqual($"UPDATE \"People\" SET \"Name\"=@p0,\"Created\"=@p1 WHERE \"Id\"=@p2", SqlPostgresServer.Sql);
Assert.AreEqual("Name 1", SqlSqlServer.Values[0]);
Assert.AreEqual(created, SqlSqlServer.Values[1]);
Assert.AreEqual(1, SqlSqlServer.Values[2]);
Assert.AreEqual("Name 1", SqlMySqlServer.Values[0]);
Assert.AreEqual(created, SqlMySqlServer.Values[1]);
Assert.AreEqual(1, SqlMySqlServer.Values[2]);
Assert.AreEqual("Name 1", SqlPostgresServer.Values[0]);
Assert.AreEqual(created, SqlPostgresServer.Values[1]);
Assert.AreEqual(1, SqlPostgresServer.Values[2]);
}
public void TestMethodUpdateOuputRawSqlNullValue()
{
SqlBuilder raw = new SqlBuilder();
SqlBuilderUpdate updateSqlServer = raw.UpdateFrom("People", SqlServerProvider);
string strSqlSqlServer = updateSqlServer.AddColumns("Name", "Created")
.AddValues("Name 1", SqlBuilder.NullValue <DateTime>())
.Where("Id", 1).ToRawSql();
Assert.AreEqual($"UPDATE [People] SET [Name]='Name 1',[Created]=NULL WHERE [Id]=1", strSqlSqlServer);
}
public void TestMethodUpdateOuputSqlAndListOfParameterWithNull()
{
SqlBuilder raw = new SqlBuilder();
SqlBuilderUpdate updateSqlServer = raw.UpdateFrom("People", SqlServerProvider);
(string Sql, List <object> Values, object ClassObject)SqlSqlServer = updateSqlServer
.AddColumns("Name", "Created")
.AddValues("Name 1", SqlBuilder.NullValue <DateTime>())
.Where("Id", 1)
.ToSqlBinding();
Assert.AreEqual($"UPDATE [People] SET [Name]=@p0,[Created]=@p1 WHERE [Id]=@p2", SqlSqlServer.Sql);
PropertyInfo[] infoClassObject = SqlSqlServer.ClassObject.GetType().GetProperties();
Assert.AreEqual("Name 1", infoClassObject[0].GetValue(SqlSqlServer.ClassObject));
Assert.AreEqual(null, infoClassObject[1].GetValue(SqlSqlServer.ClassObject));
}
public void TestMethodUpdateOuputRawSql()
{
var created = DateTime.Now.AddDays(-1);
SqlBuilder raw = new SqlBuilder();
SqlBuilderUpdate updateSqlServer = raw.UpdateFrom("People", SqlServerProvider);
SqlBuilderUpdate updateMysqlServer = raw.UpdateFrom("People", MysqlServerProvider);
SqlBuilderUpdate updatePostgresServer = raw.UpdateFrom("People", PostgresServerProvider);
string strSqlSqlServer = updateSqlServer.AddColumns("Name", "Created").AddValues("Name 1", created).Where("Id", 1).ToRawSql();
string strSqlMySqlServer = updateMysqlServer.AddColumns("Name", "Created").AddValues("Name 1", created).Where("Id", 1).ToRawSql();
string strSqlPostgresServer = updatePostgresServer.AddColumns("Name", "Created").AddValues("Name 1", created).Where("Id", 1).ToRawSql();
Assert.AreEqual($"UPDATE [People] SET [Name]='Name 1',[Created]='{created}' WHERE [Id]=1", strSqlSqlServer);
Assert.AreEqual($"UPDATE `People` SET `Name`='Name 1',`Created`='{created}' WHERE `Id`=1", strSqlMySqlServer);
Assert.AreEqual($"UPDATE \"People\" SET \"Name\"='Name 1',\"Created\"='{created}' WHERE \"Id\"=1", strSqlPostgresServer);
}
