public MySQLWrapper(MySqlConnection connectionObject, WrapperAdditionalConfig config) : this()
{
Connection = connectionObject;
if (!string.IsNullOrWhiteSpace(config.ParameterBindingStartValue))
{
BindingStartValue = config.ParameterBindingStartValue;
if (!string.IsNullOrWhiteSpace(config.DatabaseVersion))
{
ParameterProcessor = new MySQLParameterProcessor(InternalDatabaseBinding, config.DatabaseVersion, config.ParameterBindingStartValue);
}
else
{
ParameterProcessor = new MySQLParameterProcessor(InternalDatabaseBinding, null, config.ParameterBindingStartValue);
}
}
else
{
if (!string.IsNullOrWhiteSpace(config.DatabaseVersion))
{
ParameterProcessor = new MySQLParameterProcessor(InternalDatabaseBinding, config.DatabaseVersion);
}
}
MaxDeadlockRetry = config?.MaxDeadlockRetry ?? 0;
MaxDeadlockMSDelay = config?.MaxDeadlockMSDelay ?? 0;
ConnectionTimeout = config?.ConnectionTimeout ?? 30;
}
public void FailureMissingParameter()
{
var pms = new { you = "test123" };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
Assert.Throws(Is.TypeOf <Exception>().And.Message.EqualTo("The number of parameter binding indexs in the SQL does not match the parameters suplied."), delegate { mProcessor.GetParameters(query, pms); });
}
public void FailureWrongParameterName()
{
var pms = new { you = "test123", AGEE = 11 };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
Assert.Throws(Is.TypeOf <Exception>().And.Message.EqualTo("The number of binding indexs in your SQL matches the supplied parameters but one or more of them does not have the correct matching name."), delegate { mProcessor.GetParameters(query, pms); });
}
public void FailureWrongTypeName()
{
var pms = new { you = "test123", AGE = 11 };
var typs = new { you = MySqlDbType.Text, AGEE = MySqlDbType.Int32 };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
Assert.Throws(Is.TypeOf <Exception>().And.Message.EqualTo("One or more of the databaseTypes does not have a matching binding name to the other parameters."), delegate { mProcessor.GetParameters(query, pms, typs); });
}
public void FailureMissingType()
{
var pms = new { you = "test123", AGE = 11 };
var typs = new { you = MySqlDbType.Text };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
Assert.Throws(Is.TypeOf <Exception>().And.Message.EqualTo("The number of parameters does not match the supplied databaseTypes."), delegate { mProcessor.GetParameters(query, pms, typs); });
}
public void Success()
{
var pms = new { you = "test123", AGE = 11 };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
var parameters = mProcessor.GetParameters(query, pms);
Assert.IsTrue(parameters != null && parameters.Count == 2);
}
public void SuccessWithTypes()
{
var pms = new { you = "test123", AGE = 11 };
var typs = new { you = MySqlDbType.Text, AGE = MySqlDbType.Int32 };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
var parameters = mProcessor.GetParameters(query, pms, typs);
Assert.IsTrue(parameters != null && parameters.Count == 2);
}
public void SuccessWithTypesCheck()
{
var pms = new { you = "test123", AGE = 11 };
var typs = new { you = MySqlDbType.Text, AGE = MySqlDbType.Int32 };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
var parameters = mProcessor.GetParameters(query, pms, typs);
Assert.IsTrue(parameters != null && parameters.Count == 2);
MySQLDatabaseType youType = parameters.Where(p => p.BindingName == "you").First().DatabaseType as MySQLDatabaseType;
MySQLDatabaseType AGEType = parameters.Where(p => p.BindingName == "AGE").First().DatabaseType as MySQLDatabaseType;
Assert.IsTrue(youType.MySQLDBType == MySqlDbType.Text && AGEType.MySQLDBType == MySqlDbType.Int32);
}
public void SuccessfulBindingParameterTypes()
{
var pms = new { you = "test123", AGE = 11 };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
var results = mProcessor.GetParameters(pms);
var dbCommand = new MySqlCommand();
mProcessor.BindParameters(dbCommand, results);
Assert.IsTrue(dbCommand.Parameters != null && dbCommand.Parameters.Count == 2);
Assert.IsTrue(dbCommand.Parameters["@you"].MySqlDbType == MySqlDbType.VarChar);
Assert.IsTrue(dbCommand.Parameters["@AGE"].MySqlDbType == MySqlDbType.Int32);
}
public void SuccessfulBindingParameter()
{
var pms = new { you = "test123", AGE = 11 };
MySQLParameterProcessor mProcessor = new MySQLParameterProcessor("@");
var results = mProcessor.GetParameters(pms);
var dbCommand = new MySqlCommand();
mProcessor.BindParameters(dbCommand, results);
Assert.IsTrue(dbCommand.Parameters != null && dbCommand.Parameters.Count == 2);
Assert.IsTrue(dbCommand.Parameters["@you"]?.Value?.ToString() == "test123");
Assert.IsTrue(Convert.ToInt32(dbCommand.Parameters["@AGE"]?.Value?.ToString()) == 11);
}
protected MySQLWrapper() : base()
{
SQLCommand = new MySqlCommand();
ParameterProcessor = new MySQLParameterProcessor(InternalDatabaseBinding);
}
