package cn.ksource.test;

import java.util.ArrayList;
import java.util.List;

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 org.springframework.transaction.annotation.Transactional;

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

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

	@Autowired
	private BaseDao baseDao;
	
	@Test
	public void testInput() throws Exception {
		String sql = "insert into REPORT_DATE_CONFIG (ID,YEAR,MONTH,END_TIME) values(:ID,:YEAR,:MONTH,:END_TIME)";
		List<SqlParameter> paramList = new ArrayList<SqlParameter>();
		
		for (int year = 2014; year < 2025; year++) {
			for (int month = 1; month < 13; month++) {
				paramList.add(new SqlParameter("ID",StringUtil.getUUID()).addValue("YEAR", year).addValue("MONTH", month)
						.addValue("END_TIME", 10));
			}
		}
		
		baseDao.executeBatch(sql, paramList);
	}
}