package cn.ksource.test.test;

import java.util.List;
import java.util.Map;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.util.DbPolicyUtil;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("/applicationContext_core.xml")
public class ClearReportData {

	@Autowired
	private BaseDao baseDao;
	
	
	@Test
	public void clear() {
		baseDao.execute("delete from  REPORT_MAIN_TEMP", new SqlParameter());
		for (int i = 0; i < 30; i++) {
			baseDao.execute("delete from REPORT_INFO_ITEM"+ i +"", new SqlParameter());
			baseDao.execute("delete from REPORT_INFO_PRODUCT_TOTAL"+ i +"", new SqlParameter());
			baseDao.execute("delete from REPORT_INFO_PRODUCT"+ i +"", new SqlParameter());
		}
		baseDao.execute("delete from REPORT_EXCEPTION_INFO", new SqlParameter());
		baseDao.execute("delete from REPORT_EXCEPTION_LIST", new SqlParameter());
	}
}