public async Task TestMySql() // Warning!!! This test creates a database on your database server.
{
IUserDatabaseProvider plugin = new MySqlDatabaseProvider();
Assert.IsTrue(await plugin.Connect(ConnectString));
//await plugin.DeleteUserAsync("testuser");
var secStr = new SecureString();
secStr.AppendChar('t');
secStr.AppendChar('e');
secStr.AppendChar('s');
secStr.AppendChar('t');
Assert.AreEqual(LoginCheckResult.InvalidUser, await plugin.CheckLoginAsync("test", secStr));
Assert.IsTrue(await plugin.AddUserAsync("testuser1", secStr));
Assert.IsTrue(await plugin.AddUserAsync("testuser2", new SecureString()));
Assert.AreEqual(LoginCheckResult.InvalidPassword, await plugin.CheckLoginAsync("testuser1", new SecureString()));
Assert.AreEqual(LoginCheckResult.LoginOK, await plugin.CheckLoginAsync("testuser1", secStr));
Assert.IsTrue(await plugin.DeleteUserAsync("testuser1"));
Assert.IsTrue(await plugin.DeleteUserAsync("testuser2"));
plugin.Disconnect();
}
private DapperSqlGenerator MockGenerator()
{
var dbProvider = new MySqlDatabaseProvider();
Mock <IOptions <DapperDatabaseOptions> > optionsMock = new Mock <IOptions <DapperDatabaseOptions> >();
optionsMock.Setup(o => o.Value).Returns(new DapperDatabaseOptions
{
DefaultConnectionName = "default",
ConnectionStrings = new Dictionary <string, string>
{
{ "default", MySqlConnectionString.Value }
}
});
DapperRuntime rt = new DapperRuntime(optionsMock.Object, new IDapperMetadataProvider[] { new DapperMetadataProviderInstance() });
return(new DapperSqlGenerator(rt));
}
private CrudSqlSegments MockCrudSqlSegments()
{
var dbProvider = new MySqlDatabaseProvider();
Mock <IOptions <DapperDatabaseOptions> > optionsMock = new Mock <IOptions <DapperDatabaseOptions> >();
optionsMock.Setup(o => o.Value).Returns(new DapperDatabaseOptions
{
DefaultConnectionName = "default",
ConnectionStrings = new Dictionary <string, string>
{
{ "default", MySqlConnectionString.Value }
}
});
DapperRuntime rt = new DapperRuntime(optionsMock.Object, new IDapperMetadataProvider[] { new TestEntityMetadataProvider() });
CrudSqlSegments seg = new CrudSqlSegments(typeof(TestEntity), rt);
return(seg);
}
private DapperRepository <DapperAllTest> MockGenerator()
{
var dbProvider = new MySqlDatabaseProvider();
Mock <IOptions <DapperDatabaseOptions> > optionsMock = new Mock <IOptions <DapperDatabaseOptions> >();
optionsMock.Setup(o => o.Value).Returns(new DapperDatabaseOptions
{
DefaultConnectionName = "default",
ConnectionStrings = new Dictionary <string, string>
{
{ "default", helper.ConnectionString }
}
});
LoggerFactory loggerFactory = new LoggerFactory();
loggerFactory.AddDebug(LogLevel.Trace);
DapperRuntime rt = new DapperRuntime(optionsMock.Object, new IDapperMetadataProvider[] { new DapperMetadataProviderInstance() });
_testContext = new DapperContext(rt, loggerFactory);
return(new DapperRepository <DapperAllTest>(_testContext));
}
