package com.jiuqi.mobile.core.service.db;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Date;
import java.util.UUID;
import org.junit.Assert;
import org.junit.Test;
import com.jqmobile.core.orm.ORM;
import com.jqmobile.core.orm.TableUtil;
import com.jqmobile.core.orm.exception.ORMException;
import com.jqmobile.core.orm.exception.ORMNotDBTableException;
import com.jqmobile.core.server.db.DBPool;
import com.jqmobile.core.server.db.orm.ORMFactory;
import com.jqmobile.core.server.db.orm.TableUtilFactory;
public class TableTest extends Assert{
public void createTable() throws SQLException, ORMException{
test1();
// test2();
}
private void test2() throws SQLException, ORMNotDBTableException, ORMException {
Connection conn=DBPool.getInstance().getConnection();
ORM<Toy> orm=ORMFactory.instance(conn, Toy.class);
// Toy t=new Toy(UUID.randomUUID().toString(), "张三",new Date().getTime());
for (int i = 0; i < 1000; i++) {
Toy t=new Toy(UUID.randomUUID().toString(), "张三",new Date().getTime(),new Date().getTime());
orm.insert(t);
}
conn.commit();
}
@Test
public void test1() throws SQLException, ORMException {
Connection connection = DBPool.getInstance().getConnection();
TableUtil tu = TableUtilFactory.instance(connection);
tu.createTable(TableCreatTest.class);
//assertTrue(tu.valiTableExist("T_DateTest"));
connection.commit();
connection.close();
}
public static void main(String[] args) throws SQLException, ORMException {
Connection connection = DBPool.getInstance().getConnection();
TableUtil tu = TableUtilFactory.instance(connection);
tu.createTable(TableCreatTest.class);
//assertTrue(tu.valiTableExist("T_DateTest"));
connection.commit();
connection.close();
}
}