/*
 * ============LICENxSE_START==========================================
 * ONAP Portal SDK
 * ===================================================================
 * Copyright © 2018 AT&T Intellectual Property. All rights reserved.
 * ===================================================================
 *
 * Unless otherwise specified, all software contained herein is licensed
 * under the Apache License, Version 2.0 (the "License");
 * you may not use this software except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *             http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Unless otherwise specified, all documentation contained herein is licensed
 * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
 * you may not use this documentation except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *             https://creativecommons.org/licenses/by/4.0/
 *
 * Unless required by applicable law or agreed to in writing, documentation
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * ============LICENSE_END============================================
 *
 * 
 */

package org.onap.portalsdk.analytics.model.base;

import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.mockito.Mockito;
import org.onap.portalsdk.analytics.system.ConnectionUtils;
import org.onap.portalsdk.analytics.system.Globals;
import org.onap.portalsdk.analytics.util.DataSet;
import org.onap.portalsdk.analytics.util.RemDbInfo;
import org.powermock.api.mockito.PowerMockito;
import org.powermock.core.classloader.annotations.PrepareForTest;
import org.powermock.modules.junit4.PowerMockRunner;

@RunWith(PowerMockRunner.class)
@PrepareForTest({Globals.class, IdNameSql.class, ConnectionUtils.class})
public class IdNameSqlTest {

	IdNameSql idNameSql;
	
	@Before
	public void init() {
		idNameSql = new IdNameSql("select * from test", "select * from test");
	}
	
	@Test
	public void testLoadData() throws Exception {
		PowerMockito.mockStatic(Globals.class);
		PowerMockito.mockStatic(ConnectionUtils.class);
		Mockito.when(Globals.getDBType()).thenReturn("test");
		RemDbInfo remDbInfo = Mockito.mock(RemDbInfo.class);
		PowerMockito.whenNew(RemDbInfo.class).withNoArguments().thenReturn(remDbInfo);
		Mockito.when(remDbInfo.getDBType(Mockito.anyString())).thenReturn("test");
		Mockito.when(Globals.getReportSqlForFormfield()).thenReturn("test");
		DataSet ds = Mockito.mock(DataSet.class);
		Mockito.when(ConnectionUtils.getDataSet(Mockito.anyString(), Mockito.anyString())).thenReturn(ds);
		Mockito.when(ds.getRowCount()).thenReturn(1);
		Mockito.when(ds.getString(Mockito.anyInt(), Mockito.anyInt())).thenReturn("test");
		idNameSql.loadData("select", 10, "testDB");
	}
}