|
第二個問題是 配置=簡單嗎？
有了配置化系統(tǒng)之后，開發(fā)日常的工作就變成了寫配置，然而在mysql里通過SQL寫配置并不一定比寫代碼輕松愉快。。。
文章前面的例子模型可以抽象成一個形如鏈表的pipline，這樣看起來還比較簡單，但是現(xiàn)實中很多業(yè)務(wù)比這個要復(fù)雜多了，很多業(yè)務(wù)抽象出來是個好幾層的樹型結(jié)構(gòu)，這種東西靠人寫SQL描述執(zhí)行計劃并不一定比寫代碼簡單多少。稍微拓展一下上面的例子：
“用戶每次完單后統(tǒng)計其總完單量，完單量達到不同閾值后給用戶下發(fā)不同的成就。
這個API的模型如下圖所示，它采用所謂的lambda架構(gòu)，在離線中計算用戶T+1的總單量，同時根據(jù)離線總單量產(chǎn)出日期dt 補充在線單量，最終把兩部分數(shù)據(jù)加起來返回給業(yè)務(wù)方結(jié)果。
為啥要采用這樣的架構(gòu)呢。由于離線數(shù)據(jù)的產(chǎn)出時間不固定，所以需要一個dt字段做標識。
舉個例子，現(xiàn)在是3月20號凌晨1點整，此時19號的離線任務(wù)沒有跑完，此時單量計算規(guī)則為：
“用戶總完單量 = 18號總單量（離線）+19號當(dāng)天單量（在線） + 20號當(dāng)天單量（在線）。
若現(xiàn)在8點鐘，離線任務(wù)跑完了，此時單量計算規(guī)則為：
“用戶總完單量 = 19號總單量（離線） + 20號當(dāng)天單量（在線）。
上面這套流程已經(jīng)比較復(fù)雜了，你可以想一下這塊該如何配置，再想想如何通過SQL去描述配置。如果業(yè)務(wù)方還想在API中增加判定邏輯，比如 單量超過500單就通知下游給用戶發(fā)個章，那配置起來就更復(fù)雜了。所以把配置存到管理平臺后，還需要在平臺上搞一個牛逼的前端頁面，讓開發(fā)同學(xué)可以在界面上勾勾選，拖拖拽拽，把配置描述出來，而且支持REPL讓用戶可以debug。
MR-J3-40A MRJ340A
BROWNING 415SMT15 13.9792 RATIO SPEED REDUCER
KEY TECHNOLOGY INC. 12836 GEAR BOX, BELIEVED
LAB-LINE ENVIRONEERS 3597 ENVIRON-SHAKER, USED
WILFLEY AG6253 9-2381 A20 PUMP
ALLEN BRADLEY 1336 3PH 5HP MOTOR CONTROL USED
MANN & HUMMEL AF-A085 COOLANT SYSTEM w/ 3-PH MOTOR
SUMITOMO CQT63 125FV S1307J A PUMP
2 pcs. ALLEN BRADLEY 1764-LRPC MICROLOGIX 1500 PROCESSO
PARKER PVP23 HYDRAULIC PUMP, NEW OLD STOCK
CONE DRIVE 120:1 RU60-3 SPEED REDUCER, REBUILT
2 pcs. ALLEN BRADLEY 2711-NM13B MEMORY CARDS, NIB
4 pcs. ALLEN BRADLEY 1799-DNETCONA 5 POS OPEN DEVICENET
VICKERS 25V21A-11C22R HYDRAULIC PUMP, NEW OLD STOCK
2 pcs. TELEMECANIQUE XCSB13 LIMIT SWITCHES, NIB
RACINE PSV-PNCF-100-FR?M-50 SILENT VANE HYDRAULIC PUMP
ALLEN BRADLEY SLC 500 1746-0G16C OUTPUT MODULE, NIB
8 pcs. SQUARE-D 9007C54E LIMIT SWITCHES
RACINE PVR-PSS040ER-01?-40GPM HYDRAULIC PUMP, REBUILT
VICKERS 35V HYDRAULIC PUMP, REBUILT
ALLEN BRADLEY 1746-0A16D SLC 500 OUTPUT MODULE, NIB
AUTOMATION DIRECT T1K-08TAS AC OUTPUT MODULE, NIB
VICKERS 4520V HYDRAULIC PUMP, REBUILT
VICKERS 35V HYDRAULIC PUMP, REBUILT
CASHCO 1" 988 CONTROL VALVE, NEW w/ SCRATCHES
ALLEN BRADLEY 1746IA16C SLC 500 INPUT MODULE, NIB (BD)
VICKERS 45V HYDRAULIC PUMP, REBUILT
VICKERS VC138 COMBINATION HYDRAULIC PUMP, REBUILT
EATON 1000.8PG PANELMATE, USED
ALLEN BRADLEY 1761-L32BWBEA MICRO CONTROLLER, NIB
VICKERS PVB20 HYDRAULIC PUMP, REBUILT
VICKERS PVB29 " NO TAG INFORMATION" HYDRAULIC PUMP,
LOT OF 2 pcs. MISC ALLEN BRADLEY CONTROLLERS, USED
ALLEN BRADLEY 1769-1Q16A2 SINK/SOURCE INPUT MODULE
ALLEN BRADLEY 1769-ECRA1 RIGHT END CAP TERMINATOR, FACT
MICRO MOTION 3700A1A03DUEZBZ FLOW TRANSMITTER, USED
VICKERS PVQ13 HYDRAULIC PUMP, REBUILT
VERIMATION TECHNOLOGY INC. HIS-ML17 PANELVIEW, USED
VICKERS PVQ32 HYDRAULIC PUMP, REBUILT
ALLEN BRADLEY 1790DTN0V2A ANALOG BASE TB, FACTORY SEALE
VICKERS PVQ40 HYDRAULIC PISTON PUMP, REBUILT
ALLEN BRADLEY 194R-NJ060P3B FUSED DISCONNECT SWITCH
LOT OF 6 pcs.ALLEN BRADLEY MISC 855T PARTS, NIB (BD)
SCIENTIFIC TECHNOLOGIES INC. SR12E01 POWER SUPPLY, NIB
TELEMECANIQUE/ SQUARE D LD4LD.30. MOTOR CONTROL
2pcs. JOHNSTONE JPC-1001 BARREL PUMPS ,USED
2 ALLEN BRADLEY 1746-C16 50" RACK INTERCONNECT CABLE
200pc. ALLEN BRADLEY 1492-J4 TERMINAL BLOCKS, NIB
ALLEN BRADLEY 1746-BAS SLC 500 BASIC MODULE ,NIB
ALLEN BRADLEY 140M-H8R-D10 100A 3P CIRCUIT BREAKER, UIB
ALLEN BRADLEY 1746-IB32 SLC 500 INPUT MODULE, UIB
ALLEN BRADLEY 1746-IV16 SLC 500 INPUT MODULE , NIB
ALLEN BRADLEY 1761-NET-AIC ADVANCED INTERFACE CONVERTER
ALLEN BRADLEY 14OU-H2C3-C40 40A 3P CIRCUIT BREAKER,USED
ALLEN BRADLEY 1769-OW16 16.PT VAC/VDC RELAY OUTPUT
ALLEN BRADLEY 1769-L32E COMPACT LOGIX PROCESSOR UNIT
ALLEN BRADLEY 1761-NET-AIC ADVANCED INTERFACE CONVERTER
ALLEN BRADLEY 194R-NJ060P3 FUSED DISCONNECT SWITCH, NIB
ALLEN BRADLEY 2711-T9C1 PANELVEIW TERMINAL, USED
ALLEN BRADLEY 1769-PB2 COMPACT I/O POWER SUPPLY ,NIB
ALLEN BRADLEY 2711-B5A2 PANELVIEW 550 TERMINAL, REFURB.
ALLEN BRADLEY 2711P-RDT12C PANELVIEW PLUS1250 TERMINAL
ALLEN BRADLEY 2711-T5A16L1 PANELVIEW 550 TERMINAL
ALLEN BRADLEY 1769-SDN COMPACT I/O DEVICE NET SCANNER
ALLEN BRADLEY 2711B6C10 PANELVIEW 600
ALLEN BRADLEY 2711-T6C2L1 PANELVIEW 600, USED
ALLEN BRADLEY 802M-AY12 PRE-WIRED LIMIT SWITCH, NIB
ESKRIDGE INC. 90B3A4G107 HYDRAULIC PUMP
ALLEN BRADLEY 509-COD SIZE 2 STARTER, USED
ALLEN BRADLEY 509-TAD SIZE 00 STARTER IN ENCLOSURE ,NIB
AUTOMATION DIRECT D2-04BDC1-1 4SLOT BASE, FACT. SEALED
ELECTRO CAM CORP. PL-1746-C01-R1 PROCESSOR ,USED
SQUARE D 9012 GAW-1 PRESSURE SWITCH, NIB(BD)
WESTINGHOUSE HMCP150U4C 150A 3P 600VAC CIRCUIT BREAKER
HONEYWELL M7285C1009 MODUTROL IV MOTOR
AUTOMATION DIRECT E-SW05U INDUSTRIAL ETHERNET SWITCH
AUTOMATION DIRECT E-SW05U INDUSTRIAL ETHERNET SWITCH
LOT OF 5pcs. ALLEN BRADLEY 1747 MISC. MEMORY MODULES
HOPE IND. HISWL15 12" PANEL MOUNT INDUSTRIAL MONITOR
MITUTOYO 7011 BN MAGNETIC STAND
MKS 179A53CS3BM---S MASS FLOW METER, SEALED
SIEMENS FXD3B250 250 AMP CIRCUIT BREAKER ,NIB
TELEMECANIQUE ATV16U18N4U 1 HP AC SPEED DRIVE ,NIB
STAR PANEL M310411274 CONTROL PANEL, NIB
TELEMECANIQUE LD5LB130FC REVERSING CONTACTOR BREAKER
TELEMECANIQUE/S?QUARE D LC1F265 CONTACTOR, NIB
TELEMECANIQUE VW3A16103 PORT FOR DISPLAY OPTION ,NIB
CYCLO INDEX 50.1 INDEXING GEAR DRIVE, NEW
BOSCH 0513R18C3VPV16 SM21HYB03 HYDRAULIC PUMP
BOSCH 0513R18C3VPV63SM21HYB05 HYDRAULIC PUMP
EATON PVH098R13AJ30A0700000/AD1AB0110A HYDRAULIC PUMP
PARKER DENISON PD075PC02SR HYDRAULIC PUMP
PARKER PVP-60202R11 HYDRAULIC PUMP
SAFTRONICS GP10E9ST34125B1 OPEN LOOP AC DRIVE ,NIB
MICON DC10L PUMP UNIT w/MEASURING CONTROL, USED
SOUTHEASTERN HEATER & CONTROLS STAINLESS THERMAL HEATIN
VACTORR 69151 PUMP W/GE 3/4HP 1PH AC MOTOR USED
FERGUSON FD300 INDEX DRIVE
MANNESMANN REXROTH A2V-SL1000HS 0R5 GP PUMP ,USED
SMC CDLSG180-800-F5?PL-DM9PL PNEUMATIC CYLINDER
EURO JOHNSON 21-385 FLUID PUMP w/ 5 HP MOTOR , USED
PRICE 2MS50SS-412-212?11-PEO PUMP w/ 1-1/2 HP MOTOR
TOSHIBA HOUSTON VT130G1-4015B0E 1HP TRANSISTOR INVERTER
ROPER 20002 PUMP
PARKER / ZENITH PUMPS 3100-1365 CONTROL , USED
DEMAG 5.6 HP 3-PH 1795 RPM 3992427 MOTOR, USED
GENERAL ELECTRIC 12PVD21A1A HIGH IMPEDANCE DIFFERENTIAL
BECKER DVTLF250 VACUUM PUMP, USED
BUSCH SV1025B0001KXX VACUUM PUMP, USED
CUTLER HAMMER 5 HP SV9015AC-SMOB30 DRIVE, USED
MILTON ROY MBP1018KPDCBM4SENN11 PUMP, REPAIRED
SUMITOMO SM-CYCLO 43:1 CWVS-6225Y-43 GEAR BOX
VIKING " NO TAG INFORMATION" PUMP, USED
AMERICAN 436-083608-005 HYDRAULIC TANK w/ WILDEN M4
AMERICAN FAN CO. ( NO TAG) BLOWER , USED
AXIFAN 1125B7E. TWIN CITY FAN & BLOWER
LIGHTNIN N33G-33-1/3HP 230/460V 1725 RPM MIXER
GUSHER MS561000FJCDM PUMP W/MOTOR, REBUILT
ANDRITZ SPROUT ROTARY S/S FEEDER VALVE
GUSHER MS56CDM1000FJ PUMP W/ MOTOR HOUSING
|
在線咨詢 
