public static void SinglePrivilege_WithNoGrantOption()
{
var statement = new GrantPrivilegesStatement("user1", Privileges.Select, ObjectName.Parse("t1"));
var sql = statement.ToString();
var expected = "GRANT SELECT TO user1 ON t1";
Assert.AreEqual(expected, sql);
}
public static void SinglePrivilege_WithNoGrantOption()
{
var statement = new GrantPrivilegesStatement("user1", Privileges.Select, ObjectName.Parse("t1"));
var sql = statement.ToString();
var expected = "GRANT SELECT TO user1 ON t1";
Assert.AreEqual(expected, sql);
}
public static void MultiplePrivileges_WithGrantOption()
{
var privs = Privileges.Update | Privileges.Insert;
var statement = new GrantPrivilegesStatement("admin", privs, true, ObjectName.Parse("APP.test1"));
var sql = statement.ToString();
var expected = "GRANT UPDATE, INSERT TO admin ON APP.test1 WITH GRANT OPTION";
Assert.AreEqual(expected, sql);
}
public static void MultiplePrivileges_WithGrantOption()
{
var privs = Privileges.Update | Privileges.Insert;
var statement = new GrantPrivilegesStatement("admin", privs, true, ObjectName.Parse("APP.test1"));
var sql = statement.ToString();
var expected = "GRANT UPDATE, INSERT TO admin ON APP.test1 WITH GRANT OPTION";
Assert.AreEqual(expected, sql);
}
protected virtual SqlStatement VisitGrantPrivilege(GrantPrivilegesStatement statement)
{
return new GrantPrivilegesStatement(statement.Grantee, statement.Privilege, statement.WithGrant, statement.ObjectName,
statement.Columns);
}
public void GrantPrivilegesNoOption()
{
var privs = Privileges.Insert | Privileges.Update;
var objName = ObjectName.Parse("APP.test_table1");
var statement = new GrantPrivilegesStatement("user1", privs, objName);
SerializeAndAssert(statement, (serialized, deserialized) => {
Assert.IsNotNull(deserialized);
Assert.IsNotNull(deserialized.ObjectName);
Assert.IsNotNull(deserialized.Grantee);
Assert.AreEqual(objName, deserialized.ObjectName);
Assert.AreEqual("user1", deserialized.Grantee);
Assert.AreEqual(privs, deserialized.Privilege);
Assert.IsFalse(deserialized.WithGrant);
Assert.IsNull(deserialized.Columns);
});
}
protected virtual SqlStatement VisitGrantPrivilege(GrantPrivilegesStatement statement)
{
return(new GrantPrivilegesStatement(statement.Grantee, statement.Privilege, statement.WithGrant, statement.ObjectName,
statement.Columns));
}