public void Execute_SecurablePermission_CorrectlyRendered()
{
var databases = new List <Database>()
{
new Database("db-001", "sql-001", new List <Securable>()
{
new Securable("dbo", "SCHEMA", new List <Permission>()
{
new Permission("SELECT")
})
, new Securable("admin.Log", "OBJECT", new List <Permission>()
{
new Permission("INSERT")
})
}, null)
};
var principals = Enumerable.Repeat(new Principal("MyUser", databases), 1);
var engine = new TestableStringTemplateEngine();
var templateInfo = new TemplateInfo()
{
Content = "$securables:{securable|$securable.permission$ on $securable.type$::$securable.name$ for $principal$\r\n}$",
Attributes = new[] { "principal", "database", "securables" }
};
var result = engine.Execute(templateInfo, principals);
Assert.That(result, Is.EqualTo("SELECT on SCHEMA::dbo for MyUser\r\nINSERT on OBJECT::admin.Log for MyUser\r\n"));
}
public void Execute_Principals_CorrectlyRendered()
{
var principals = new List <Principal>()
{
new Principal("MyUser", new List <Database>()
{
new Database("db-001", "sql-001", null, null)
}),
new Principal("MyCopy", new List <Database>()
{
new Database("db-001", "sql-001", null, null)
}),
};
var engine = new TestableStringTemplateEngine();
var templateInfo = new TemplateInfo()
{
Content = "$principal$#$database.name$#$database.server$§",
Attributes = new[] { "principal", "database", "securables" }
};
var result = engine.Execute(templateInfo, principals);
Assert.That(result, Is.EqualTo("MyUser#db-001#sql-001§MyCopy#db-001#sql-001§"));
}
public void Execute_Principals_CorrectlyRendered()
{
var principals = new List <Principal>()
{
new Principal("MyUser", new List <Database>()
{
new Database("db-001", "sql-001", null, null)
}),
new Principal("MyCopy", new List <Database>()
{
new Database("db-001", "sql-001", null, null)
})
};
var engine = new TestableStringTemplateEngine();
var templateInfo = new TemplateInfo()
{
Content = "$principals:{principal |Principal = $principal.Name$#}$"
,
Attributes = new[] { "principals" }
};
var result = engine.Execute(templateInfo, principals);
Assert.That(result, Is.EqualTo("Principal = MyUser#Principal = MyCopy#"));
}
public void Execute_Database_CorrectlyRendered()
{
var databases = new List <Database>()
{
new Database("db-001", "sql-001", null, null)
, new Database("db-002", "sql-001", null, null)
};
var principals = Enumerable.Repeat(new Principal("MyUser", databases), 1);
var engine = new TestableStringTemplateEngine();
var templateInfo = new TemplateInfo()
{
Content = "$principals:{principal | $principal.databases:{database |Database = $database.server$/$database.name$#}$}$"
,
Attributes = new[] { "principals" }
};
var result = engine.Execute(templateInfo, principals);
Assert.That(result, Is.EqualTo("Database = sql-001/db-001#Database = sql-001/db-002#"));
}