@echo off
@echo This cmd file creates a Data API Builder configuration based on the chosen database objects.
@echo To run the cmd, create an .env file with the following contents:
@echo dab-connection-string=your connection string
@echo ** Make sure to exclude the .env file from source control **
@echo **
dotnet tool install -g Microsoft.DataApiBuilder
dab init -c dab-config.json --database-type mssql --connection-string "@env('dab-connection-string')" --host-mode Development
@echo Adding tables
dab add "UMtrldef" --source "[dbo].[u_mtrldef]" --fields.include "mtrlid,mtrlcode,mtrlname,mtrltype,mtrlsectype,mtrlmode,Mtrlorigin,unit,lspacklimit,planprice,LMsaleprice,lmbuyprice,dscrp,MaxQTY,MinQTY,isuse,packqty,prdpackcode,opdate,opemp,Popdate,Popemp,Auditflag,Audit_emp,Audit_date,mtrltypeid,handtype,barcode,mtrlkind,net_weight,gross_weight,cubage,mtrlengname,wpmtrlid,wprate,zxmtrlmode,unit_scll,unit_buy,rate_buy,rate_scll,rate_sale,unit_sale,scllflag,orderdays,buydays,wfjgdays,ifselforder,minbuyqty,aheaddays,mprice,dftsptid,scid,ifscid,modemp,moddate,mtrlprp,dftwrkGrpid,ordertype,uprate,upqty,statusflag,statustype,woodcodeflag,woodcodetype,pcodeflag,pcodetype,mtrlarea,mtrlarea1,mtrlarea2,iflimitprice,sptmode,scidprice,configcode,configname,autoinstall,ifpack,ifpackpro,subid,subid_sale,subid_cost,subid_tsale,mtrlcolor,configcodetype,ifautodd,iflljg,ifunit,ifpackpz,ifpacktype,scllrate,cmpqty,usermtrlmode,storagetype,ifmtrlcuscode,mrptype,mrparg,updownprice,outtype,ifpricepack,gydscrp,downrate,ifcustom,buyunit,wfjgunit,scllunit,saleunit,buydec,wfjgdec,sclldec,saledec,issuliao,latest_pdcost,ifenough,capacity,expday,capaparm,sctaskqty,minarg,maxarg,ifmrppackpf,status_check,woodcode_check,pcode_check,maxdays,mindays,cusnarrate,configtext,fauditflag,areaqty,techqty,iffp,maxzjday,eoq,splitrate,fjcnt,mrp_unit,rebuytype,rebuylot,ifsendlot,upddrate,upddqty,upsalerate,upsaleqty,ifusedeliqty,status_config,woodcode_config,pcode_config,pricepztype,useday,equiptype,ifpackpro2,price_ifpz,ifkl,ifturn,scllqty,price_ifpz_buy,piccode,dftscllwkpid,if_hourpay,mergeday,GYAuditflag,GYAuditemp,GYAuditdate,sys_changetime,ifmrp,if_inherit,groupstr,groupday,aps_capacity_type,checkrate,scllplan_mode,chkpassrate,flag,auditdate,secauditdate,auditemp,secauditemp,dftcusid,simplename,sendtype,mb_mtrlid,buy_ceiling,scll_ceiling,wfjg_ceiling,sale_ceiling,material,jgdscrp,adddec,ifbarcodefp,stoppqty,stopsaleqty,buy_autoday,upbuyrate,upbuyqty,ifrebuypack,NodeID,ProductID,protype,ifcheck,mtrlmode_ifchg,mtrlmode_chgdate,buydays_bx,wfjgdays_bx,multqty,buyer,multtype,bantype,midu,BalcCmplNotUpdate,status_spc,woodcode_spc,pcode_spc,buydec_w2u,wfjgdec_w2u,sclldec_w2u,saledec_w2u,sec_mtrlorigin,ifcore,iftongyong,ifbiaozhun,ifyisun,ifmozhi,areaprice,ifcust,pfklmode,midbarcode,plancode,ifcheckjj,xninoutflag,ifscllplan_hz,scllwkptype,uprate_sptcheck,upqty_sptcheck,ifwkpmtrlware,locatype,sclldownrate,saletype,iforder_buy,ifcheckpt,planprice_edit,fjcb_cmpstr,ifautogetbar,bantasktype,updownprice_rate,fxSyncTime,ifsalebom,ifModelPro,ifunit_buy,area_formula,advancetime,senddays,ifmt,discount,if_inherit_sale,if_inherit_orderdft,subid_hsale,model,saleprice_formula,ifbjapp,maxzjdayorg,ck_packqty,subid_scll,subid_py,subid_pk,band,saletasktype_fx,sub_model,ifrequestbuybj,ifcheck_cp,subid_sale2,subid_pz,ifexpiring,expiringremindday,expiringday,expireduseableday,if_spt_plancode,applystprice,aql,plancode_rule_buy,cusmtrlcode_str,cusmtrlname_str,chg_bom_type,plancode_rule_scll,if_inherit_order_own,subid_rsjy,subid_rsly,subid_rsbf,no_inrate,pic_errflag,pic_errdscrp,bom_errflag,bom_errdscrp,subid_cost2,aqljudge1,aqljudge2,aqljudge3,mtrlcuscode,status,woodcode,pcode,confignew_dft,if_share_mrp_info,ifmpclimit,oned_range,seqoption" --permissions "anonymous:*" 
@echo Adding views and tables without primary key
@echo Adding relationships
@echo Adding stored procedures
dab add "CmplMtrlsortBatchId" --source "[dbo].[cmpl_mtrlsort_batchID]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "CmplMtrlsortTable" --source "[dbo].[cmpl_mtrlsort_table]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "CmplMtrlsortTableGlobal" --source "[dbo].[cmpl_mtrlsort_table_global]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DbaGetTraceBatch" --source "[dbo].[dba_get_trace_batch]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DbaTrace" --source "[dbo].[dba_trace]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DicBuyTaskMxScc" --source "[dbo].[DIC_buyTaskMx_scc]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DicDateConfirmFlag" --source "[dbo].[DIC_date_confirm_flag]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DtSelectBarcodeMx" --source "[dbo].[dt_select_barcode_mx]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DtSysAddApsMtrlWill" --source "[dbo].[dt_sys_add_aps_mtrl_will]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DtSysScidentity" --source "[dbo].[dt_sys_scidentity]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DtSysScidentity2" --source "[dbo].[dt_sys_scidentity2]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "DtSysUpdateApsMtrlWill" --source "[dbo].[dt_sys_update_aps_mtrl_will]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PBuytaskmxScc" --source "[dbo].[p_buytaskmx_scc]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PInwareUpdateMtrlware" --source "[dbo].[p_inware_update_mtrlware]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxAdd" --source "[dbo].[p_mtrlware_inmx_add]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxCancel" --source "[dbo].[p_mtrlware_inmx_cancel]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxInwareCancelTh" --source "[dbo].[p_mtrlware_inmx_inware_cancel_th]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxInwareTh" --source "[dbo].[p_mtrlware_inmx_inware_th]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxOutware" --source "[dbo].[p_mtrlware_inmx_outware]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxOutwareCancel" --source "[dbo].[p_mtrlware_inmx_outware_cancel]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxOutwareTh" --source "[dbo].[p_mtrlware_inmx_outware_th]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PMtrlwareInmxOutwareThCancel" --source "[dbo].[p_mtrlware_inmx_outware_th_cancel]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "POrderrqwpAddFtaskqty" --source "[dbo].[p_orderrqwp_add_ftaskqty]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "POutwareUpdateMtrlware" --source "[dbo].[p_outware_update_mtrlware]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PQueryCusnewpro" --source "[dbo].[p_query_cusnewpro]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PRebuilOrderTaskAssign" --source "[dbo].[p_rebuil_order_task_assign]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PStorageSetIfFifo" --source "[dbo].[p_storage_set_if_fifo]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PSysGetBillcode" --source "[dbo].[p_sys_get_billcode]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PUpdateAccessory" --source "[dbo].[p_update_accessory]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PUpdateOutwareScllplanEnoughRate" --source "[dbo].[p_update_outware_scllplan_EnoughRate]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PUpdateWrkgrpPro" --source "[dbo].[p_update_wrkgrp_pro]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PUpdateWrkgrpProWkpname" --source "[dbo].[p_update_wrkgrp_pro_wkpname]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PYsBuildUMtrlWkpTech" --source "[dbo].[p_ys_build_u_mtrl_wkp_tech]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "PYsGrowUMtrlWkpTech" --source "[dbo].[p_ys_grow_u_mtrl_wkp_tech]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "SpMtrlwareStorageidChScll" --source "[dbo].[sp_mtrlware_storageid_ch_scll]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "SpOrderMlMrpQty" --source "[dbo].[sp_order_ml_mrp_qty]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "SpOrderMlMrpQtyNew" --source "[dbo].[sp_order_ml_mrp_qty_new]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "SpOrderMlMrpQtyNew2" --source "[dbo].[sp_order_ml_mrp_qty_new2]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "SpOrderMlMrpQtyPdscrp" --source "[dbo].[Sp_order_ml_mrp_qty_pdscrp]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "SpRpOrdermtrlWorkgroupBarcode" --source "[dbo].[sp_rp_ordermtrl_workgroup_barcode]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "SpWarebalcCmpl" --source "[dbo].[sp_warebalc_cmpl]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "V22pPrepareApsdatum" --source "[dbo].[v2_2p_prepare_apsdata]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "V26pApplyWkpdate" --source "[dbo].[v2_6p_apply_wkpdate]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "V32pPrepareApsdatum" --source "[dbo].[v3_2p_prepare_apsdata]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
dab add "V36pApplyWkpdate" --source "[dbo].[v3_6p_apply_wkpdate]" --source.type "stored-procedure" --permissions "anonymous:execute" --rest.methods "get" --graphql.operation "query" 
@echo **
@echo ** run 'dab validate' to validate your configuration **
@echo ** run 'dab start' to start the development API host **