package org.googlecode.jef.spring;

import java.sql.SQLException;
import java.sql.Types;

import jef.common.log.LogUtil;
import jef.database.dialect.ColumnType;
import jef.database.dialect.TypeDefImpl;
import jef.database.meta.TupleMetadata;
import jef.orm.custom.HstoreMapMapping;

import org.easyframe.enterprise.spring.CommonDao;
import org.junit.Ignore;
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;

@Ignore
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:spring/common-ef-orm.xml" })
public class CommonSpringTest {
	
	@Autowired
	private CommonDao dao;
	

	/**
	 * 数据库连接测试
	 * @throws SQLException
	 */
	@Test
	public void test1() throws SQLException{
		LogUtil.show(dao.getNoTransactionSession().getMetaData(null).getDbVersion());
	}
	
	/**
	 * 试用Postgres的 hstore jsonb等功能
	 * @throws SQLException
	 */
	@Test
	public void test2() throws SQLException{
		TupleMetadata table=new TupleMetadata("h_test");
		table.addColumn("id", new ColumnType.AutoIncrement(8));
		table.addColumn("data", new TypeDefImpl("hstore", Types.OTHER).javaType(String.class).mapping(HstoreMapMapping.class));
		dao.getNoTransactionSession().createTable(table);
		
		
	}

}