public void ExecuteSql_LoginError()
{
string userId = "U" + Guid.NewGuid().ToString().Replace("-", "");
string password = "******" + Guid.NewGuid().ToString().Replace("-", "");
string dataSource = "localhost:1521/xe";
string connectionString = @"User Id=" + userId + ";Password="******";Data Source=" + dataSource + ";";
OracleSqlExecuter sqlExecuter = new OracleSqlExecuter(connectionString, new ConsoleLogProvider(), new NullUserInfo());
var ex = TestUtility.ShouldFail(() => sqlExecuter.ExecuteSql(new[] { "SELECT 123 FROM DUAL" }), userId, dataSource);
Assert.IsFalse(ex.ToString().Contains(password));
}
public void ExecuteSql_SaveLoadTest()
{
OracleSqlExecuter sqlExecuter = GetSqlExecuter();
string table = GetRandomTableName();
sqlExecuter.ExecuteSql(new[]
{
"CREATE TABLE " + table + " ( A INTEGER )",
"INSERT INTO " + table + " VALUES (123)"
});
int actual = 0;
sqlExecuter.ExecuteReader("SELECT * FROM " + table, dr => actual = dr.GetInt32(0));
Assert.AreEqual(123, actual);
}
public void SendUserInfoInSqlContext_WriteWithUser()
{
var testUser = new TestUserInfo
{
IsUserRecognized = true,
UserName = "******",
Workstation = "HAL9000"
};
var sqlExecuter = new OracleSqlExecuter(SqlUtility.ConnectionString, new ConsoleLogProvider(), testUser);
string table = GetRandomTableName();
var result = new List <string>();
sqlExecuter.ExecuteSql(new [] { @"CREATE TABLE " + table + " AS SELECT SYS_CONTEXT('USERENV','CLIENT_INFO') ClientInfo FROM DUAL" });
sqlExecuter.ExecuteReader(@"SELECT * FROM " + table, reader => result.Add(reader[0].ToString()));
var clientInfo = result.Single();
TestUtility.AssertContains(clientInfo, testUser.UserName, "CLIENT_INFO should contain username.");
TestUtility.AssertContains(clientInfo, testUser.Workstation, "CLIENT_INFO should contain client workstation.");
Assert.AreEqual(SqlUtility.UserContextInfoText(testUser), clientInfo);
}
public void SendUserInfoInSqlContext_WriteWithUser()
{
var testUser = new TestUserInfo
{
IsUserRecognized = true,
UserName = "******",
Workstation = "HAL9000"
};
var sqlExecuter = new OracleSqlExecuter(SqlUtility.ConnectionString, new ConsoleLogProvider(), testUser);
string table = GetRandomTableName();
var result = new List<string>();
sqlExecuter.ExecuteSql(new [] { @"CREATE TABLE " + table + " AS SELECT SYS_CONTEXT('USERENV','CLIENT_INFO') ClientInfo FROM DUAL" });
sqlExecuter.ExecuteReader(@"SELECT * FROM " + table, reader => result.Add(reader[0].ToString()));
var clientInfo = result.Single();
TestUtility.AssertContains(clientInfo, testUser.UserName, "CLIENT_INFO should contain username.");
TestUtility.AssertContains(clientInfo, testUser.Workstation, "CLIENT_INFO should contain client workstation.");
Assert.AreEqual(SqlUtility.UserContextInfoText(testUser), clientInfo);
}
public void ExecuteSql_LoginError()
{
string userId = "U" + Guid.NewGuid().ToString().Replace("-", "");
string password = "******" + Guid.NewGuid().ToString().Replace("-", "");
string dataSource = "localhost:1521/xe";
string connectionString = @"User Id=" + userId + ";Password="******";Data Source=" + dataSource + ";";
OracleSqlExecuter sqlExecuter = new OracleSqlExecuter(connectionString, new ConsoleLogProvider(), new NullUserInfo());
var ex = TestUtility.ShouldFail(() => sqlExecuter.ExecuteSql(new[] { "SELECT 123 FROM DUAL" }), userId, dataSource);
Assert.IsFalse(ex.ToString().Contains(password));
}