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); }
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 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 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); }); }