public MySQLObjectDatabase(string ConnectionString)
: base(ConnectionString)
{
Config = new DbConfig(ConnectionString);
Config.AddDefaultOption("Treat Tiny As Boolean", "False");
Config.AddDefaultOption("Allow User Variables", "True");
Config.AddDefaultOption("Convert Zero Datetime", "True");
Config.AddDefaultOption("SslMode", "None");
this.ConnectionString = Config.ConnectionString;
}
public void ConnectionString_DefaultOptionWithoutSpaces_DefaultOptionWithSpace()
{
var dbConfig = new DbConfig("DefaultOption=");
dbConfig.AddDefaultOption("Default Option", "");
var actual = dbConfig.ConnectionString;
var expected = "Default Option=";
Assert.AreEqual(expected, actual);
}
public void ConnectionString_SetDefaultOptionToAnotherValue_DefaultOptionHasAnotherValue()
{
var dbConfig = new DbConfig("Default Option=Another Value");
dbConfig.AddDefaultOption("Default Option", "Value");
var actual = dbConfig.ConnectionString;
var expected = "Default Option=Another Value";
Assert.AreEqual(expected, actual);
}
public void ConnectionString_AddDefaultOptionWithValue_DefaultOptionsEqualValue()
{
var dbConfig = new DbConfig("");
dbConfig.AddDefaultOption("Default Option", "Value");
var actual = dbConfig.ConnectionString;
var expected = "Default Option=Value";
Assert.AreEqual(expected, actual);
}
public void GetValueOf_DEFAULTOPTION_DefaultOptionSetToValue_Value()
{
var dbConfig = new DbConfig("");
dbConfig.AddDefaultOption("Default Option", "Value");
var actual = dbConfig.GetValueOf("DEFAULTOPTION");
var expected = "Value";
Assert.AreEqual(expected, actual);
}
public void ConnectionString_NonDefaultOption_DefaultOptionAtTheEnd()
{
var dbConfig = new DbConfig("NonDefaultOption=");
dbConfig.AddDefaultOption("Default Option", "");
var actual = dbConfig.ConnectionString;
var expected = "NonDefaultOption=;Default Option=";
Assert.AreEqual(expected, actual);
}
public void ConnectionString_DefaultOptionWhichIsAddedToSuppressed_DefaultOptionIsNotShown()
{
var dbConfig = new DbConfig("");
dbConfig.AddDefaultOption("Default Option", "");
dbConfig.SuppressFromConnectionString("Default Option");
var actual = dbConfig.ConnectionString;
var expected = "";
Assert.AreEqual(expected, actual);
}
public SQLiteObjectDatabase(string ConnectionString)
: base(ConnectionString)
{
Config = new DbConfig(ConnectionString);
Config.AddDefaultOption("Version", "3");
Config.AddDefaultOption("Pooling", "False");
Config.AddDefaultOption("Cache Size", "1073741824");
Config.AddDefaultOption("Journal Mode", "Memory");
Config.AddDefaultOption("Synchronous", "Off");
Config.AddDefaultOption("Foreign Keys", "True");
Config.AddDefaultOption("Default Timeout", "60");
Config.SuppressFromConnectionString("Version", "Pooling", "Cache Size", "Journal Mode", "Synchronous", "Default Timeout");
this.ConnectionString = Config.ConnectionString;
}
