|
21 | 21 | suite("load") { |
22 | 22 | def tables = |
23 | 23 | [ |
24 | | - "dwm_air_theme_loading_port_test" |
| 24 | + "dwm_air_theme_loading_port_test", |
| 25 | + "dws_railway_revenue", |
| 26 | + "dws_railway_xnop" |
25 | 27 | ] |
26 | 28 | for (String table in tables) { |
27 | 29 | sql """DROP TABLE IF EXISTS ${table}""" |
28 | 30 | sql new File("""${context.file.parent}/ddl/${table}.sql""").text |
29 | 31 | } |
30 | 32 | sql new File("""${context.file.parent}/ddl/data1.sql""").text |
31 | 33 | sql new File("""${context.file.parent}/ddl/data2.sql""").text |
| 34 | + |
| 35 | + sql """ |
| 36 | + INSERT INTO dws_railway_revenue (docaindex,checkdate,orderno,referenceno,orderdate,exportsendtime,soano,internalsettlementlinkid,feeno,feename,creditdebit,redbilltype,ordertypeid,ordertypename,smallordertypeid,smallordertypename,is_lcl,currencyno,cnyrate,sponsoropid,sponsoropname,ramount,rntaxamount,rcamount,rcntaxamount,pamount,pcontainerfee,prailwayfee,pother,pntaxamount,pncontainerfee,pnrailwayfee,pnother,pcamount,pccontainerfee,pcrailwayfee,pcother,pcntaxamount,pcncontainerfee,pcnrailwayfee,pcnother,customerno,customername,salesno,salesname,saleareaname,salecompanyname,saledeptname,saleid,salev1_name,salev2_name,salev3_name,salev4_name,salev5_name,salev6_name,opno,opname,operatorareaname,operatorcompanyname,operatordeptname,operatorid,oplev1_name,oplev2_name,oplev3_name,oplev4_name,oplev5_name,oplev6_name,splev1_name,splev2_name,splev3_name,splev4_name,splev5_name,splev6_name,platform,trainname,productcode,startstation,sstation_namecn,sprovince,endstation,estation_namecn,eprovince,exportportcode,entrusttypecode,entrusttypename,industrytypecode,industrytypename,isadd,iscancel,canceldate,isinvoive,invoicedate,sourcesys,op_datetime) VALUES |
| 37 | + ('b','2022-07-17','a','d','2022-07-16','d','a','e','b','e','c','d','70','a','70','a','e','e','b','a','e',3.0,4.0,1.0,1.0,6.0,8.0,4.0,2.0,8.0,1.0,2.0,2.0,1.0,9.0,9.0,4.0,8.0,5.0,4.0,1.0,'c','b','d','e','c','成都供应链','b','b','c','c','c','e','d','a','b','c','c','b','c','d','铁运事业部','北区','a','b','c','d','e','b','c','b','c','b','d','b','d','b','d','d','a','a','c','b','b','d','c','d','e','b','2022-07-16','b','2022-07-17','c','2022-07-16 00:00:00'), |
| 38 | + ('c','2022-07-17','a','c','2022-07-16','b','b','d','a','c','d','a','70','a','70','a','c','e','b','e','a',8.0,5.0,7.0,5.0,2.0,6.0,7.0,6.0,1.0,4.0,9.0,6.0,5.0,6.0,9.0,8.0,2.0,3.0,4.0,3.0,'b','b','c','c','c','成都供应链','e','b','d','d','d','e','a','e','b','e','b','c','e','d','铁运事业部','北区','d','e','e','e','e','e','b','e','e','b','c','e','c','b','a','e','e','b','a','b','b','c','e','c','d','e','2022-07-17','d','2022-07-16','c','2022-07-16 00:00:00'), |
| 39 | + ('e','2022-07-17','a','e','2022-07-16','d','b','a','b','e','b','d','70','b','70','a','a','a','c','a','d',5.0,3.0,2.0,1.0,6.0,6.0,5.0,9.0,2.0,5.0,5.0,4.0,9.0,7.0,9.0,8.0,6.0,6.0,7.0,6.0,'c','c','a','a','b','成都供应链','c','d','c','d','a','d','c','e','d','a','d','d','d','c','铁运事业部','北区','e','b','b','d','b','a','d','d','a','d','a','c','e','d','b','c','b','a','c','e','a','c','c','d','b','c','2022-07-17','b','2022-07-16','d','2022-07-17 00:00:00'), |
| 40 | + ('a','2022-07-16','e','b','2022-07-16','e','d','e','a','c','b','b','70','b','70','c','b','b','d','a','b',9.0,1.0,2.0,4.0,4.0,6.0,3.0,1.0,9.0,3.0,1.0,7.0,4.0,4.0,6.0,7.0,7.0,8.0,7.0,6.0,'b','a','c','b','d','成都供应链','a','e','c','e','d','c','c','b','a','e','e','b','a','a','铁运事业部','北区','c','e','d','d','c','a','d','a','b','c','a','e','e','c','b','a','e','e','d','d','e','a','a','e','d','b','2022-07-17','d','2022-07-16','b','2022-07-16 00:00:00'), |
| 41 | + ('c','2022-07-16','b','c','2022-07-16','a','a','e','b','c','d','d','70','b','70','d','e','a','d','d','b',3.0,4.0,5.0,2.0,9.0,9.0,9.0,7.0,1.0,4.0,6.0,7.0,1.0,9.0,9.0,9.0,2.0,6.0,7.0,9.0,'d','e','e','e','d','成都供应链','a','b','e','d','c','b','d','e','d','c','c','e','c','b','铁运事业部','北区','c','e','e','c','a','d','e','b','e','e','d','b','e','a','e','b','a','e','e','c','a','a','c','d','a','c','2022-07-16','c','2022-07-17','e','2022-07-17 00:00:00'), |
| 42 | + ('d','2022-07-16','a','b','2022-07-16','c','d','b','a','c','b','a','70','a','70','c','b','c','b','b','c',1.0,6.0,4.0,5.0,4.0,7.0,1.0,7.0,2.0,5.0,9.0,4.0,1.0,7.0,8.0,9.0,3.0,7.0,8.0,8.0,'a','e','e','c','d','成都供应链','b','e','a','a','a','e','a','c','b','b','c','d','e','a','铁运事业部','北区','d','a','b','d','c','b','d','d','b','d','c','a','d','b','e','b','b','e','d','d','a','a','b','e','b','b','2022-07-17','c','2022-07-17','c','2022-07-16 00:00:00'); |
| 43 | + """ |
| 44 | + |
| 45 | + sql """ |
| 46 | + INSERT INTO dws_railway_xnop (checkmonth,referenceno,ordertypename,checkdate,is_railway,customername,salesno,salesname,salesareaname,salescompany,salescompanyname,salesdeptno,salesdeptname,opno,opname,areaname,opcompany,opcompanyname,opdeptno,opdeptname,pxn_fee,rxn_fee,pop_fee,rop_fee,total_fee,orderdate) VALUES |
| 47 | + ('b','d','b','2022-07-17','d','d','e','a','a','d','e','c','e','c','e','b','c','d','c','b',6.0,7.0,4.0,4.0,8.0,'2022-07-17'), |
| 48 | + ('b','b','e','2022-07-17','e','e','d','c','d','d','b','a','e','d','b','d','e','a','b','e',9.0,7.0,6.0,8.0,8.0,'2022-07-16'), |
| 49 | + ('d','c','b','2022-07-16','a','c','a','d','a','c','e','c','e','a','a','b','e','d','a','a',1.0,3.0,5.0,8.0,7.0,'2022-07-16'), |
| 50 | + ('a','e','a','2022-07-17','b','b','c','a','d','d','a','e','b','a','a','e','c','a','c','a',9.0,2.0,6.0,2.0,7.0,'2022-07-17'), |
| 51 | + ('a','b','d','2022-07-16','b','c','c','c','e','b','a','c','b','d','d','e','b','e','e','d',2.0,1.0,6.0,1.0,5.0,'2022-07-17'), |
| 52 | + ('a','a','c','2022-07-17','c','b','c','b','b','b','d','b','c','b','d','a','d','c','a','e',9.0,5.0,5.0,8.0,8.0,'2022-07-16'), |
| 53 | + ('a','b','b','2022-07-17','e','d','d','a','e','d','b','e','d','c','e','d','b','a','a','c',8.0,2.0,2.0,3.0,2.0,'2022-07-17'), |
| 54 | + ('a','b','c','2022-07-16','b','c','b','b','a','e','e','a','d','b','d','e','a','d','d','e',2.0,5.0,7.0,1.0,5.0,'2022-07-16'), |
| 55 | + ('a','d','e','2022-07-17','d','e','a','c','b','e','d','a','c','b','b','b','d','a','e','e',9.0,7.0,1.0,6.0,6.0,'2022-07-17'), |
| 56 | + ('e','d','a','2022-07-17','d','d','b','e','b','b','c','e','a','b','d','b','b','c','e','b',3.0,6.0,4.0,6.0,8.0,'2022-07-17'); |
| 57 | + """ |
32 | 58 | } |
0 commit comments