public static void verify_using_NoSql_objfuscator_and_quoted_string_in_sql_that_GetObfuscatedSql_returns_null()
{
SqlObfuscator ob = SqlObfuscator.GetSqlObfuscator(true, "off");
string sql = "Select * from users where name = 'dude'";
Assert.IsNull(ob.GetObfuscatedSql(sql));
}
public static void verify_using_NoSql_objfuscator_that_GetObfuscatedSql_returns_null()
{
SqlObfuscator ob = SqlObfuscator.GetSqlObfuscator(true, "off");
string sql = "Select * from users where ssn = 433871122";
Assert.IsNull(ob.GetObfuscatedSql(sql));
}
public static void verify_using_raw_obfuscator_and_quoted_string_in_sql_that_GetObfuscatedSql_returns_sql_passed_in()
{
SqlObfuscator ob = SqlObfuscator.GetSqlObfuscator(true, "raw");
string sql = "Select * from users where name = 'dude'";
Assert.AreEqual(sql, ob.GetObfuscatedSql(sql));
}
public static void verify_using_raw_obfuscator_that_GetObfuscatedSql_returns_sql_passed_in()
{
SqlObfuscator ob = SqlObfuscator.GetSqlObfuscator(true, "raw");
string sql = "Select * from users where ssn = 433871122";
Assert.AreEqual(sql, ob.GetObfuscatedSql(sql));
}
public void verify_GetObfuscatedSql_replaces_id_with_questionmark()
{
Assert.AreEqual("Select * from users where ssn = ?",
obfuscator.GetObfuscatedSql("Select * from users where ssn = 433871122"));
}
/// <summary>
/// If the SQL obfuscation settings are set to obfuscate, this will return the obfuscated SQL using the cache. Otherwise, it just returns
/// the value returned from the SQL obfuscator defined by the configuration because there is no need to cache the value of the no sql and raw sql obfuscators.
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public string GetObfuscatedSql(string sql, DatastoreVendor vendor)
{
return(_sqlObfuscator != SqlObfuscator.GetObfuscatingSqlObfuscator()
? _sqlObfuscator.GetObfuscatedSql(sql, vendor)
: GetObfuscatedSqlFromCache(sql, vendor));
}
