public void GetConnectionString_InvalidFile_FileNotFoundException()
{
var fullPath = DiskOnFile.CreatePhysicalFile(ODC_FILE, "NBi.Testing.Integration.Core.Resources." + ODC_FILE);
var parser = new OfficeDataConnectionFileParser(Path.GetDirectoryName(fullPath) + Path.DirectorySeparatorChar);
Assert.Throws <FileNotFoundException>(delegate { parser.GetConnectionString("NonExisting.odc"); });
}
public void GetConnectionString_ValidAbsoluteFile_CorrectConnectionString()
{
var fullPath = DiskOnFile.CreatePhysicalFile(ODC_FILE, "NBi.Testing.Integration.Core.Resources." + ODC_FILE);
var parser = new OfficeDataConnectionFileParser(Path.GetDirectoryName(fullPath));
var connectionString = parser.GetConnectionString(fullPath);
Assert.That(connectionString, Is.EqualTo("Provider=MSOLAP.7;Integrated Security=ClaimsToken;Identity Provider=AAD;Data Source=https://analysis.windows.net/powerbi/api;;Initial Catalog=sobe_wowvirtualserver-ccdf3d76-59d9-4e10-83e8-82eb0d27d1e9;Location=https://wabi-north-europe-redirect.analysis.windows.net/xmla?vs=sobe_wowvirtualserver&db=ccdf3d76-59d9-4e10-83e8-82eb0d27d1e9;MDX Compatibility= 1; MDX Missing Member Mode= Error; Safety Options= 2; Update Isolation Level= 2"));
}
public void GetConnectionStringFromText_ValidText_CorrectConnectionString()
{
var text = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"xmlns=\"http://www.w3.org/TR/REC-html40\"><head>";
text += " <odc:ConnectionString>Data Source=foo;initial catalog=bar</odc:ConnectionString> ";
text += "</head></html>";
var parser = new OfficeDataConnectionFileParser();
var connectionString = parser.GetConnectionStringFromText(text);
Assert.That(connectionString, Is.EqualTo("Data Source=foo;initial catalog=bar"));
}