public void TestGetSql_5()
{
var sql = "VALUES (@p1111,@p111,@p1,@p11,@p1)";
var sqlParams = "@p111='c',@p11='b',@p1='a' ";
var result = EfLog.GetSql(sql, sqlParams);
Assert.Equal("VALUES (@p1111,'c','a','b','a')", result);
}
public void TestGetSql_6()
{
var sql = "VALUES (@p1)";
var sqlParams = "@p1='' (DbType = Guid)";
var result = EfLog.GetSql(sql, sqlParams);
Assert.Equal("VALUES (null)", result);
}
public void TestGetSql_2()
{
var sql = "VALUES (@p0, @p1)";
var sqlParams = "@p0='c4a42939-3569-4915-bb53-14edad2323cf', @p1='18.52'";
var result = EfLog.GetSql(sql, sqlParams);
Assert.Equal("VALUES ('c4a42939-3569-4915-bb53-14edad2323cf', '18.52')", result);
}
public void TestGetSql_4()
{
var sql = "VALUES (@p0,@p1,@p12)";
var sqlParams = "@p0='a', @p1='1.5',@p12='b'";
var result = EfLog.GetSql(sql, sqlParams);
Assert.Equal("VALUES ('a','1.5','b')", result);
}
public void TestGetSql_10()
{
var sql = "VALUES (@__orderQuery_memberId_0,@__orderQuery_memberId_1)";
var sqlParams = "@__orderQuery_memberId_0='{'a':'a','b':'b','c':'888'}' (Size = 500), @__orderQuery_memberId_1='18.52'";
var result = EfLog.GetSql(sql, sqlParams);
Assert.Equal("VALUES ('{'a':'a','b':'b','c':'888'}','18.52')", result);
}
public void TestGetSql_9()
{
var sql = "VALUES (@p0,@p1)";
var sqlParams = "@p0='{'a':'a','b':'b','c':'888'}' (Size = 500), @p1='18.52'";
var result = EfLog.GetSql(sql, sqlParams);
Assert.Equal("VALUES ('{'a':'a','b':'b','c':'888'}','18.52')", result);
}
public void TestGetSql_8()
{
var sql = "VALUES (@p0)";
var sqlParams = "@p0='{'a':1}'";
var result = EfLog.GetSql(sql, sqlParams);
Assert.Equal("VALUES ('{'a':1}')", result);
}
public void TestGetSqlParameters_9()
{
var sqlParams = "@__a_b_0='70eac351-1eb0-45d1-b431-431646df7ab1' (Nullable = false)";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(1, list.Count);
Assert.Equal("@__a_b_0", list.Keys.FirstOrDefault());
Assert.Equal("'70eac351-1eb0-45d1-b431-431646df7ab1'", list.Values.FirstOrDefault());
}
public void TestGetSql_3()
{
var sql = "VALUES (1)";
var result = EfLog.GetSql(sql, null);
Assert.Equal(sql, result);
result = EfLog.GetSql(sql, "");
Assert.Equal(sql, result);
}
public void TestGetSqlParameters_1()
{
var sqlParams = "@p0='c4a42939-3569-4915-bb53-14edad2323cf'";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(1, list.Count);
Assert.Equal("@p0", list.Keys.FirstOrDefault());
Assert.Equal("'c4a42939-3569-4915-bb53-14edad2323cf'", list.Values.FirstOrDefault());
}
public void TestGetSqlParameters_7()
{
var sqlParams = "@p0='{'a':'a','b':'b','c':'888'}' (Size = 500)";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(1, list.Count);
Assert.Equal("@p0", list.Keys.FirstOrDefault());
Assert.Equal("'{'a':'a','b':'b','c':'888'}'", list.Values.FirstOrDefault());
}
public void TestGetSqlParameters_6()
{
var sqlParams = "@p0='' (DbType = Guid)";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(1, list.Count);
Assert.Equal("@p0", list.Keys.FirstOrDefault());
Assert.Equal("null", list.Values.FirstOrDefault());
}
public void TestGetSqlParameters_4()
{
var sqlParams = "@p0='' (Nullable = false) (Size = 450)";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(1, list.Count);
Assert.Equal("@p0", list.Keys.FirstOrDefault());
Assert.Equal("''", list.Values.FirstOrDefault());
}
public void TestGetSqlParameters_5()
{
var sqlParams = "@p0='70eac351-1eb0-45d1-b431-431646df7ab1' (Nullable = false) (Size = 450), @p1='18.52', @p2='11/15/2017 00:00:41' (Nullable = true), @p3='' (DbType = Guid), @p4='' (Size = 100) (DbType = String), @p5='' (DbType = Int32), @p6='11/15/2017 00:00:41' (Nullable = true), @p7='' (DbType = Guid), @p8='' (Size = 20) (DbType = String), @p9='5a0b1329ab89e01250' (Nullable = false) (Size = 20), @p10='' (Size = 30) (DbType = String), @p11='' (Size = 20) (DbType = String), @p12='c4f1ba98-dab6-451f-8257-3c35ab06a304', @p13='code' (Nullable = false) (Size = 30), @p14='a' (Nullable = false) (Size = 200)";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(15, list.Count);
Assert.Equal("@p0", list.Keys.FirstOrDefault());
Assert.Equal("'70eac351-1eb0-45d1-b431-431646df7ab1'", list.Values.FirstOrDefault());
Assert.Equal("@p14", list.Keys.LastOrDefault());
Assert.Equal("'a'", list.Values.LastOrDefault());
}
public void TestGetSqlParameters_3()
{
var sqlParams = "@p0='70eac351-1eb0-45d1-b431-431646df7ab1' (Nullable = false) (Size = 450), @p1='18.52'";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(2, list.Count);
Assert.Equal("@p0", list.Keys.FirstOrDefault());
Assert.Equal("'70eac351-1eb0-45d1-b431-431646df7ab1'", list.Values.FirstOrDefault());
Assert.Equal("@p1", list.Keys.LastOrDefault());
Assert.Equal("'18.52'", list.Values.LastOrDefault());
}
public void TestGetSqlParameters_10()
{
var sqlParams = "@__a_b_0='a' (Nullable = false),@__a_c='b' (Nullable = false)";
var list = EfLog.GetSqlParameters(sqlParams);
Assert.Equal(2, list.Count);
Assert.Equal("@__a_b_0", list.Keys.FirstOrDefault());
Assert.Equal("'a'", list.Values.FirstOrDefault());
Assert.Equal("@__a_c", list.Keys.LastOrDefault());
Assert.Equal("'b'", list.Values.LastOrDefault());
}
/// <summary>
/// 获取日志记录器
/// </summary>
/// <returns></returns>
protected virtual EfLog GetLog()
{
return(_log ?? (_log = new EfLog(TraceId, Log.GetLog("SqlTraceLog", null))));
}
public void TestGetSqlParameters_2()
{
Assert.Empty(EfLog.GetSqlParameters(null));
Assert.Empty(EfLog.GetSqlParameters(""));
Assert.Empty(EfLog.GetSqlParameters(" "));
}
