private static void test() { DateTime startDate = new DateTime(2014, 1, 1); DateTime endDate = DateTime.Now.AddDays(-1.0).Date; SampleMarketDataETL sample_etl = new SampleMarketDataETL(); HDAT_MARKETDATA_TB marketdata_tb = new HDAT_MARKETDATA_TB(); clsHDAT_MARKETDATA_TB.TableClear(); HDAT_CURVEDATA_TB curvedata_tb = new HDAT_CURVEDATA_TB(); clsHDAT_CURVEDATA_TB.TableClear(); sample_etl.build_historyData(startDate, endDate, true); { //HDAT_MARKETDATA_TB marketdata_tb = new HDAT_MARKETDATA_TB(); //clsHDAT_MARKETDATA_TB.TableClear(); //marketdata_tb.buildTestData(); clsHITM_TRADEINFO_TB trade_tb = new clsHITM_TRADEINFO_TB(); clsHITM_TRADEINFO_TB.TableClear(); clsMAST_FP_INSTRUMENT_TB mast_tb = new clsMAST_FP_INSTRUMENT_TB(); clsMAST_FP_INSTRUMENT_TB.TableClear(); clsHITM_FP_POSITION_TB position_tb = new clsHITM_FP_POSITION_TB(); clsHITM_FP_POSITION_TB.TableClear(); curvedata_tb.buildTestData(); SET_DISCOUNTCURVE_TB discount_tb = new SET_DISCOUNTCURVE_TB(); clsSET_DISCOUNTCURVE_TB.TableClear(); discount_tb.buildTestData(); HITM_CALENDAR_TB calendar_tb = new HITM_CALENDAR_TB(); clsHITM_CALENDAR_TB.TableClear(); calendar_tb.buildTestData(); } }
private static void install_db_initialize() { HITM_CALENDAR_TB calendar_tb = new HITM_CALENDAR_TB(); clsHITM_CALENDAR_TB.TableClear(); calendar_tb.buildTestData(); clsMAST_BOOKINFO_TB book_tb = new clsMAST_BOOKINFO_TB(); book_tb.BOOK_CD = "ROOTBOOK"; book_tb.BOOK_NM = "RootBook"; book_tb.PARENT_BOOK_CD = "ANCESTOR"; book_tb.OPEN_DT = DateTime.Now.ToString("yyyyMMdd"); book_tb.CLOSE_DT = "20991231"; book_tb.DESCRIPTION = ""; book_tb.Insert(); // ---------------------------------------------------- clsSET_SCENARIO_TB clstb_scenrio = new clsSET_SCENARIO_TB(); clstb_scenrio.FP_MASTER_TYP = 9999; clstb_scenrio.SCENARIO_CD = "DEFAULT_PARALLEL"; clstb_scenrio.CURVE_CD = "ALL"; clstb_scenrio.PARALLEL_SHIFT_UNIT = 1.0; clstb_scenrio.HUMP_SHIFT_UNIT = 0.0; clstb_scenrio.HUMP_CENTER_T = 0.0; clstb_scenrio.STEEPEN_SHIFT_UNIT = 0.0; clstb_scenrio.STEEPEN_CENTER_T = 0.0; clstb_scenrio.Insert(); clstb_scenrio.FP_MASTER_TYP = 2800; clstb_scenrio.SCENARIO_CD = "TEST_SC01"; clstb_scenrio.CURVE_CD = "IRSKRW"; clstb_scenrio.PARALLEL_SHIFT_UNIT = 1.0; clstb_scenrio.HUMP_SHIFT_UNIT = 0.0; clstb_scenrio.HUMP_CENTER_T = 0.0; clstb_scenrio.STEEPEN_SHIFT_UNIT = 0.1; clstb_scenrio.STEEPEN_CENTER_T = 3; clstb_scenrio.Insert(); clstb_scenrio.FP_MASTER_TYP = 2800; clstb_scenrio.SCENARIO_CD = "TEST_SC02"; clstb_scenrio.CURVE_CD = "IRSKRW"; clstb_scenrio.PARALLEL_SHIFT_UNIT = 0.5; clstb_scenrio.HUMP_SHIFT_UNIT = 0.0; clstb_scenrio.HUMP_CENTER_T = 0.0; clstb_scenrio.STEEPEN_SHIFT_UNIT = 0.3; clstb_scenrio.STEEPEN_CENTER_T = 3; clstb_scenrio.Insert(); }