private static void RunTestMySql()
{
var stopwatch = Stopwatch.StartNew();
var mysqltester = new SimpleCrudTest(SimpleCRUD.Dialect.MySQL);
foreach (var method in typeof(SimpleCrudTest).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))
{
//skip schema tests
if (method.Name.Contains("Schema"))
{
continue;
}
if (method.Name.Contains("Guid"))
{
continue;
}
if (method.Name.Contains("KeyMaster"))
{
continue;
}
if (method.Name.Contains("Ignore"))
{
continue;
}
var testwatch = Stopwatch.StartNew();
Console.Write("Running " + method.Name + " in MySQL");
method.Invoke(mysqltester, null);
Console.WriteLine(" - OK! {0}ms", testwatch.ElapsedMilliseconds);
}
stopwatch.Stop();
Console.WriteLine("Time elapsed: {0}", stopwatch.Elapsed);
Console.Write("MySQL testing complete.");
}
/// <summary>
/// test sql server
/// </summary>
private static void RunTestSqlServer()
{
var stopwatch = Stopwatch.StartNew();
var sqltester = new SimpleCrudTest(SimpleCRUD.Dialect.SQLServer);
foreach (var method in typeof(SimpleCrudTest).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))
{
var testwatch = Stopwatch.StartNew();
Console.Write($"Running {method.Name} in sql server");
method.Invoke(sqltester, null);
testwatch.Stop();
Console.WriteLine($" -√ {testwatch.ElapsedMilliseconds}'ms ");
}
stopwatch.Stop();
//write result
Console.WriteLine($"Time elapsed :{stopwatch.Elapsed}");
using (var connection = SqlConnectionHelper.GetOpenConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Master;Integrated Security=True"))
{
try
{
connection.Execute(@" alter database DapperSimpleCrudTestDb set single_user with rollback immediate; DROP DATABASE DapperSimpleCrudTestDb; ");
}
catch (Exception)
{
}
}
Console.Write("SQL Server testing complete.");
}
/// <summary>
/// test pg server
/// </summary>
private static void RunTestPg()
{
var stopwatch = Stopwatch.StartNew();
var pgtester = new SimpleCrudTest(SimpleCRUD.Dialect.PostgreSQL);
foreach (var method in typeof(SimpleCrudTest).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))
{
var testwatch = Stopwatch.StartNew();
Console.Write("Running " + method.Name + " in PostgreSQL");
method.Invoke(pgtester, null);
Console.WriteLine(" - OK! {0}ms", testwatch.ElapsedMilliseconds);
}
stopwatch.Stop();
Console.WriteLine("Time elapsed: {0}", stopwatch.Elapsed);
Console.Write("PostgreSQL testing complete.");
Console.ReadKey();
}
/// <summary>
/// test sqlite
/// </summary>
private void RunTestsSqLite()
{
var stopwatch = Stopwatch.StartNew();
var pgtester = new SimpleCrudTest(SimpleCRUD.Dialect.SQLite);
foreach (var method in typeof(SimpleCrudTest).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))
{
//skip schema tests
if (method.Name.Contains("Schema"))
{
continue;
}
var testwatch = Stopwatch.StartNew();
Console.Write("Running\t" + method.Name + "\tin SQLite");
method.Invoke(pgtester, null);
Console.WriteLine("\t- OK! \t{0}ms", testwatch.ElapsedMilliseconds);
}
stopwatch.Stop();
Console.WriteLine("Time elapsed: {0}", stopwatch.Elapsed);
Console.Write("SQLite testing complete.");
Console.ReadKey();
}
