public void ExecuteNonQuery()
{
var sut = DbOperatorFactory.GetOperator(ConnectionString);
var one = new Tuple <string, string>("GoldFox", "Saint Louis");
var two = new Tuple <string, string>("MangeCat", "New York");
var three = new Tuple <string, string>("KingKong", "Rotunda");
string insert =
"INSERT INTO CCS " +
"VALUES " +
$"('{one.Item1}', '{one.Item2}'), " +
$"('{two.Item1}', '{two.Item2}'), " +
$"('{three.Item1}', '{three.Item2}')";
sut.ExecuteNonQuery(insert).Should().Be(3);
sut.SelectScalar("Data", "CCS", "ID", one.Item1).Should().Be(one.Item2);
sut.SelectScalar("Data", "CCS", "ID", two.Item1).Should().Be(two.Item2);
sut.SelectScalar("Data", "CCS", "ID", three.Item1).Should().Be(three.Item2);
string delete = $"DELETE FROM CCS WHERE ID IN('{one.Item1}', '{two.Item1}', '{three.Item1}')";
sut.ExecuteNonQuery(delete).Should().Be(3);
}
public DbJudger(JudgeContext context) : base(context)
{
MainOperator = DbOperatorFactory.CreateMainOperatorByName(context.Task.Language);
_dbName = Path.GetFileName(context.TempDirectory).ToLower() + "db";
_dbUser = Path.GetFileName(context.TempDirectory).ToLower() + "user";
_dbPassword = Path.GetFileName(context.TempDirectory).ToLower() + "pwd";
_dbType = DbManager.GetDatabaseType(context.Task.Language);
}
public void ConnectionTest()
{
var sut = DbOperatorFactory.GetOperator(ConnectionString);
var odbc = DbOperatorFactory.GetOperator(Odbc);
var ole = DbOperatorFactory.GetOperator(Ole);
sut.GetConnection().Should().BeOfType <SqlConnection>();
ole.GetConnection().Should().BeOfType <OleDbConnection>();
odbc.GetConnection().Should().BeOfType <OdbcConnection>();
}
public void CommandTest()
{
var sut = DbOperatorFactory.GetOperator(ConnectionString);
var odbc = DbOperatorFactory.GetOperator(Odbc);
var ole = DbOperatorFactory.GetOperator(Ole);
sut.Command("").Should()
.BeOfType <SqlCommand>("An SQL Operator should provide an SQL connection");
ole.Command("").Should()
.BeOfType <OleDbCommand>("An OLE Operator should provide an OLE connection");
odbc.Command("").Should()
.BeOfType <OdbcCommand>("An ODBC Operator should provide an ODBC connection");
}
public void SanityCheckTest()
{
var sut = DbOperatorFactory.GetOperator(ConnectionString);
string goodSql = "DELETE FROM CCS WHERE ID = 'KingKrab'";
Action good = () => sut.SanityCheck(goodSql);
string badSql = "DELETE FROM CCS";
Action bad = () => sut.SanityCheck(badSql);
string irrelevantSql = "SELECT * FROM CCS";
Action irrelevant = () => sut.SanityCheck(irrelevantSql);
good.Should().NotThrow("This has a where clause and is safe.");
bad.Should().Throw <Exception>("This is missing the WHERE clause and is not safe.");
irrelevant.Should().NotThrow("This only retrieves records and does not modify the database.");
}
private BaseDbOperator CreateJudgeEnv(string input)
{
MainOperator.CreateDatabase(_dbName);
MainOperator.CreateUser(_dbUser, _dbPassword);
MainOperator.GeneratePrivileges(_dbName, _dbUser);
DbLangConfig dbConfig = DbManager.GetDbConfiguration(JudgeTask.Language);
dbConfig.Database = _dbName;
dbConfig.User = _dbUser;
dbConfig.Password = _dbPassword;
BaseDbOperator userOper = DbOperatorFactory.Create(dbConfig);
userOper.InitDatabase(input);
return(userOper);
}
public void SelectLikeTest()
{
var sut = DbOperatorFactory.GetOperator(ConnectionString);
var results = sut.SelectLike("DATA", "CCS", "ID", "BROWN%");
// results.Count.Should().Be(3);
int counter = 0;
foreach (var result in results)
{
counter++;
Console.WriteLine($"Record {counter}");
foreach (KeyValuePair <string, object> keyValuePair in result)
{
Console.WriteLine($" {keyValuePair.Key} - {keyValuePair.Value}\n");
}
}
}
public void SelectTest()
{
var sut = DbOperatorFactory.GetOperator(ConnectionString);
string sql = "SELECT TOP 3 * FROM CCS WHERE ID LIKE 'Brown%'";
var blah = sut.Query(sql);
var counter = 0;
Console.WriteLine("Results");
foreach (var dict in blah)
{
counter++;
Console.WriteLine($"Record {counter}:");
foreach (var kvp in dict)
{
Console.WriteLine($"{kvp.Key} - {kvp.Value}");
}
}
}
public void SelectScalarTest()
{
var sut = DbOperatorFactory.GetOperator(ConnectionString);
var result = sut.SelectScalar("Data", "CCS", "ID", "CustomerName").Should().Be("Ray Palmer");
}