package com.sql.util;
|
|
import java.sql.SQLException;
|
import java.util.Date;
|
|
import com.base.Com;
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class Db_Abe_TestData {
|
public static void init(MysqlConnPool pool) {
|
System.out.println("Db_Abe_TestData init Start " + Com.getDateTimeFormat(new Date(),Com.DTF_YMDhms));
|
|
createDb_Abe_TestData(pool);
|
|
createAbe_TestData_Inf_Table(pool);
|
|
System.out.println("Db_Abe_TestData init End " + Com.getDateTimeFormat(new Date(),Com.DTF_YMDhms));
|
}
|
|
|
public static void createDb_Abe_TestData(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE SCHEMA IF NOT EXISTS " + Sql_Mysql.DB_ABE_TESTDATA + " AUTHORIZATION sysdba");
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
|
/**
|
* ´´½¨ batt_alarm Êý¾Ý¿â±í
|
* @param conn
|
*/
|
public static void createAbe_TestData_Inf_Table(MysqlConnPool pool)
|
{
|
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
String sql_str_auto = "CREATE SEQUENCE IF NOT EXISTS " + Sql_Mysql.Abe_TestData_Inf_Table + "_auto" +
|
" INCREMENT 1" +
|
" MINVALUE 1" +
|
" MAXVALUE 9223372036854775807" +
|
" START 1" +
|
" CACHE 1;";
|
//´´½¨×ÔÔöÐòÁÐ
|
sql.sqlMysqlExecute(sql_str_auto);
|
|
String sql_str = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Abe_TestData_Inf_Table + " "
|
+ "(num integer NOT NULL DEFAULT nextval('" + Sql_Mysql.Abe_TestData_Inf_Table + "_auto'::regclass)," +
|
" mon_id integer NOT NULL DEFAULT 1," +
|
" test_record_count integer NOT NULL DEFAULT 1," +
|
" record_time timestamp without time zone NOT NULL DEFAULT '2000-01-01 00:00:00'::timestamp without time zone," +
|
" record_num integer NOT NULL DEFAULT 1," +
|
" test_starttime timestamp without time zone NOT NULL DEFAULT '2000-01-01 00:00:00'::timestamp without time zone," +
|
" test_type integer NOT NULL DEFAULT 2," +
|
" test_timelong integer NOT NULL DEFAULT 0," +
|
" test_stoptype integer NOT NULL DEFAULT 0," +
|
" group_vol double precision NOT NULL DEFAULT 0," +
|
" test_curr double precision NOT NULL DEFAULT 0," +
|
" test_cap double precision NOT NULL DEFAULT 0," +
|
" task_no character varying(255) NOT NULL COLLATE pg_catalog.\"default\" DEFAULT ''::character varying," +
|
" PRIMARY KEY (num)" +
|
")";
|
sql.sqlMysqlExecute(sql_str);
|
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Abe_TestData_Inf_Table + " OWNER TO sysdba;");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".num IS '×ÔÔöÖ÷¼ü';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".mon_id IS 'µ¥ÌåID';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".test_record_count IS '²âÊÔ±ÊÊý';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".record_time IS '¼Ç¼ʱ¼ä';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".record_num IS '¼Ç¼±ÊÊý';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".test_starttime IS '²âÊÔ¿ªÊ¼Ê±¼ä';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".test_type IS '²âÊÔÀàÐÍ[2-³äµç 3-·Åµç 4-»î»¯]';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".test_timelong IS ' ²âÊÔʱ³¤';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".test_stoptype IS 'Í£Ö¹ÔÒò';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".group_vol IS '×é¶Ëµçѹ';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".test_curr IS '²âÊÔµçÁ÷';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".test_cap IS '²âÊÔÈÝÁ¿';");
|
sql.sqlMysqlExecute("COMMENT ON COLUMN " + Sql_Mysql.Abe_TestData_Inf_Table + ".task_no IS '²Ö´¢ÈÎÎñ±àºÅ';");
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
}
|
