public void TestOdbcQueryAuthenticationUsernamePassword()
{
string MQueryExpression = File.ReadAllText("QueryPqFiles/CustomQuery.query.pq");
var(error, grid) = testFixture.Test(MQueryExpression);
Assert.True(String.IsNullOrWhiteSpace(error), $@"Errormessage: {error}");
Assert.True(grid.RowCount == 5 + 1, $@"actual rowCount is {grid.RowCount}");
}
public void OdbcQueryAW()
{
string MQueryExpression = File.ReadAllText("QueryPqFiles/CustomQuery.query.pq");
var(error, grid) = testFixture.Test(MQueryExpression, UIAutomationTestFixture.AuthenticationMethod.KeyOIDCToken);
Assert.True(String.IsNullOrWhiteSpace(error), $@"Errormessage: {error}");
Assert.True(grid.RowCount == 5 + 1, $@"actual rowCount is {grid.RowCount}");
}
public void LogPathArgumentFilledIn()
{
var startTestTimeStamp = DateTime.Now;
string MQueryExpression = File.ReadAllText("QueryPqFiles/LogPathArgument.query.pq");
MQueryExpression = FillInLogFilePath(MQueryExpression);
var(error, grid) = testFixture.Test(MQueryExpression);
Assert.True(String.IsNullOrWhiteSpace(error), $@"Errormessage: {error}");
AssertLogActivityAfterTs(startTestTimeStamp);
}
public void TestWindowsKerberosAuthenticationConnectionStringRecord()
{
var(sbPqFileStr, dnsRecord) = CreateKerberosConnectionStringPqTestFile();
var(error, grid) = testFixture.Test(sbPqFileStr, UIAutomationTestFixture.AuthenticationMethod.None);
Assert.True(String.IsNullOrWhiteSpace(error), $@"Errormessage: {error}");
string connectionStrKerberosServicenameField = "KERBEROSSERVICENAME";
//assert there's a row with a Kerberos service record field
int?kerberosServiceNameRecordRow = Utilities.FindRow(grid, 0, connectionStrKerberosServicenameField);
Assert.True(kerberosServiceNameRecordRow.HasValue, "KERBEROSSERVICENAME is missing from the Connection String Record.");
Assert.True(grid.Rows[kerberosServiceNameRecordRow.Value].Cells[1].Value == "exasol/" + dnsRecord);
}
public void TestDsn1()
{
string MQueryExpression = File.ReadAllText("QueryPqFiles/DSN/DSN1.query.pq");
string changedDSNStr = MQueryExpression.Replace("{DSN}", dsnName);
var(error, grid) = testFixture.Test(changedDSNStr);
Assert.True(String.IsNullOrWhiteSpace(error), $@"Errormessage: {error}");
}
public void OdbcDatasourceOverview()
{
string MQueryExpression = File.ReadAllText("QueryPqFiles/ExasolODBCDatasourceOverview.query.pq");
var(error, grid) = testFixture.Test(MQueryExpression);
Assert.True(String.IsNullOrWhiteSpace(error), $@"Errormessage: {error}");
Assert.True(grid.RowCount > 1, $@"actual rowCount is {grid.RowCount}");
var firstRow = grid.Rows[0];
var kindCell = firstRow.Cells[3];
Assert.True(kindCell.Value == "Schema");
}
