/*
* Copyright (c) MuleSoft, Inc. All rights reserved. http://www.mulesoft.com
* The software in this package is published under the terms of the CPAL v1.0
* license, a copy of which has been included with this distribution in the
* LICENSE.txt file.
*/
package org.mule.module.db.integration.select;
import static org.mule.module.db.integration.TestRecordUtil.assertMessageContains;
import org.mule.api.MuleMessage;
import org.mule.api.client.LocalMuleClient;
import org.mule.module.db.integration.AbstractDbIntegrationTestCase;
import org.mule.module.db.integration.model.AbstractTestDatabase;
import org.mule.module.db.integration.TestDbConfig;
import org.mule.module.db.integration.TestRecordUtil;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.junit.Test;
import org.junit.runners.Parameterized;
public class InlineParameterizedQueryTestCase extends AbstractDbIntegrationTestCase
{
public InlineParameterizedQueryTestCase(String dataSourceConfigResource, AbstractTestDatabase testDatabase)
{
super(dataSourceConfigResource, testDatabase);
}
@Parameterized.Parameters
public static List<Object[]> parameters()
{
return TestDbConfig.getResources();
}
@Override
protected String[] getFlowConfigurationResources()
{
return new String[] {"integration/select/inline-parameterized-query-config.xml"};
}
@Test
public void usesParamsInInlineQuery() throws Exception
{
LocalMuleClient client = muleContext.getClient();
MuleMessage response = client.send("vm://inlineQuery", TEST_MESSAGE, null);
assertMessageContains(response, TestRecordUtil.getMarsRecord());
}
@Test
public void usesExpressionParam() throws Exception
{
LocalMuleClient client = muleContext.getClient();
Map<String, Object> props = new HashMap<String, Object>();
props.put("type", 3);
MuleMessage response = client.send("vm://expressionParam", TEST_MESSAGE, props);
assertMessageContains(response, TestRecordUtil.getEarthRecord());
}
}