涓嶆槗鍐欙紝鏈粡浣滆€呰鍙紝绂佹浠ヤ换浣曞舰寮忚浆杞斤紒濡傛灉瑙夊緱鏂囩珷涓嶉敊锛屾杩庡叧娉ㄣ€佺偣璧炪€佸垎浜紒缁х画鍒嗕韩鎶€鏈崥鏂囷紝鍏虫敞寰俊鍏紬鍙佛煈夝煆诲墠绔疞eBron鍘熷垱閾炬帴浠€涔堟槸ORM瀵硅薄鍏崇郴鏄犲皠锛圤bjectRelationalMapping锛岀畝绉癘RM锛夛紝鏄竴绉嶅湪鍐呭瓨涓疄鐜板唴瀛樺璞″拰鍏崇郴鏁版嵁搴撶殑缂栫▼鎶€鏈潰鍚戝璞＄紪绋嬭瑷€涓笟鍔″疄浣撲箣闂寸殑鍏崇郴鏄犲皠銆傝繖鏍凤紝鎴戜滑鍦ㄦ搷浣滄暟鎹簱鐨勬椂鍊欙紝灏变笉闇€瑕佸啀鍘诲鐞嗗鏉傜殑SQL璇彞浜嗐€傛垜浠彧闇€瑕佺畝鍗曠殑鎿嶄綔瀵硅薄鐨勫睘鎬у拰鏂规硶锛屽氨鍙互鐩存帴瀹炵幇瀵规暟鎹簱涓搴斿疄浣撹〃鐨凜RUD锛堝鍒犳敼鏌ワ級鎿嶄綔銆傚父瑙佺殑ORM妗嗘灦鍖呮嫭Node.js鐨凾ypeOrm鍜孲equlize锛孞ava鐨凥ibernate鍜孧ybatis锛孏o鐨凣orm鍜孏oRose绛夈€侽RM鏂规硶璁哄熀浜庝笁涓牳蹇冨師鍒欙細绠€鍗曪細浠ユ渶鍩烘湰鐨勫舰寮忓鏁版嵁杩涜寤烘ā鍙€氫俊鎬э細鏁版嵁搴撶粨鏋勬槸鐢ㄤ换浣曚汉閮借兘鐞嗚В鐨勮瑷€璁板綍鍑嗙‘鎬э細鍩轰簬鏁版嵁妯″瀷鍒涘缓姝ｇ‘鐨勩€佹爣鍑嗗寲鐨勭粨鏋勫璞＄紪绋嬭瑷€鍜屽叧绯绘暟鎹簱鏄渶娴佽鐨勬妧鏈紝浣嗗畠浠殑妯″瀷涓嶅悓銆傚湪鍑犱箮鎵€鏈夌殑绋嬪簭涓紝閮芥湁瀵硅薄鏁版嵁搴撳拰鍏崇郴鏁版嵁搴撱€傚湪涓氬姟閫昏緫灞傚拰鐢ㄦ埛鐣岄潰灞傛垜浠槸闈㈠悜瀵硅薄鐨勩€傚綋瀵硅薄淇℃伅鍙戠敓鍙樺寲鏃讹紝鎴戜滑闇€瑕佸皢瀵硅薄淇℃伅淇濆瓨鍦ㄥ叧绯绘暟鎹簱涓€備互MVC鍒嗗眰妯″紡涓轰緥銆侻odel浣滀负鏁版嵁鎵胯浇瀹炰綋锛屼互闈㈠悜瀵硅薄鐨勬柟寮忓湪鐢ㄦ埛鐣岄潰鍜屼笟鍔￠€昏緫灞備箣闂翠紶閫掞紱鑰屽綋鎴戜滑闇€瑕侀€氳繃Controller鍒嗗彂璇锋眰鏉ユ寔涔呭寲鏁版嵁鏃讹紝鎴戜滑浼氶亣鍒板唴瀛樹腑鐨勫璞″浣曟寔涔呭寲鍒板叧绯诲瀷鏁版嵁搴撲腑鐨勫疄闄呮暟鎹褰曠殑闂銆傞潰鍚戝璞℃槸鍦ㄨ蒋浠跺伐绋嬬殑鍩烘湰鍘熺悊锛屽嵆灏佽銆佺户鎵裤€佸鎬佺殑鍩虹涓婂彂灞曡捣鏉ョ殑锛涜€屽叧绯绘暟鎹簱鏄湪鏁板鐞嗚鐨勫熀纭€涓婂彂灞曡捣鏉ョ殑锛屼袱鑰呬箣闂村瓨鍦ㄤ笉鍖归厤銆傚洜姝わ紝ORM搴旇繍鑰岀敓锛屼互椤圭洰涓棿浠剁殑褰㈠紡瀹炵幇鏁版嵁鍦ㄤ笉鍚屽満鏅笅鐨勬暟鎹叧绯绘槧灏勩€?瀵硅薄-鍏崇郴鏄犲皠灏辨槸杩欐牱涓€绉嶈В鍐抽潰鍚戝璞″拰鍏崇郴鏁版嵁搴撲笉鍖归厤鐨勬妧鏈€傚湪瀹冪殑鍩虹涓婏紝璇炵敓浜嗗緢澶氬璞″拰鍏崇郴涔嬮棿鐨勬槧灏勬鏋讹紝涔熷氨鏄疧RM鎶€鏈€侽RM鐨勪娇鐢ㄤ互Sequelize涓轰緥銆傛洿澶氭搷浣滆鍙傝€僑equelize涓枃鏂囨。RobinBuschmann/sequelize-typescriptSequelize鏄竴涓熀浜嶱romise鐨凬ode.jsORM锛岀洰鍓嶆敮鎸丳ostgres銆丮ySQL銆丮ariaDB銆丼QLite鍜孧icrosoftSQLServer銆傚畠鍏锋湁寮哄ぇ鐨勬敮鎸佷簨鍔°€佸叧鑱斻€侀璇诲拰寤惰繜鍔犺浇浠ュ強璇诲彇澶嶅埗銆係equelize閬靛惊璇箟鐗堟湰鎺у埗銆傛敮鎸丯odev10鍙婁互涓婄増鏈娇鐢‥S6鐗规€с€傝繛鎺ユ暟鎹簱锛屼娇鐢╯equlize鎻掍欢锛岄厤缃杩炴帴鐨勬暟鎹簱銆傚畾涔塎odel锛岄€氳繃涓€涓潰鍚戝璞＄殑Class鍜屼竴涓叧绯绘暟鎹簱琛ㄥ缓绔嬭繛鎺ャ€侤Column浠ｈ〃鏁版嵁搴撶殑涓€鍒椼€侤PrimaryKey琛ㄧず涓婚敭import{Column,Model,PrimaryKey,Table,}from'@gulu/sequelize/typescript';enumGameType{micro_game='micro_game',mobile_game='mobile_game',micro_app='micro_app',}@Table({modelName:'game',timestamps:false})exportdefaultclassGameModelextendsModel{@PrimaryKey@ColumngameId!:string;@鍒楀悕锛侊細瀛楃涓诧紱@鍒楁弿杩帮紵锛氬瓧绗︿覆锛汙鍒楃被鍨嬶紒锛氭父鎴忕被鍨嬶紱@鍒楀浘鏍囷紵锛氬瓧绗︿覆锛汙ColumnisDelete!:number;}Operation鏁版嵁搴撻€氳繃Model鐨勬柟娉曟搷浣滄暟鎹簱importGameModelfrom'../model/game';//娓告垙鍒楄〃鏌ヨ鏈嶅姟asyncquery(){returnGameModel.findAll({//removesoftdeletefieldsattributes:{exclude:['isDelete'],},//鏌ヨ娌℃湁琚蒋鍒犻櫎鐨勬父鎴弚here:{isDelete:0,},});}鐩稿綋浜庝笅闈㈢殑SQL璇彞selectgameId锛屽悕绉帮紝鎻忚堪锛岀被鍨嬶紝鏉ヨ嚜娓告垙鐨勫浘鏍囷紝鍏朵腑isDelete=0锛涘綋鐒讹紝Sequlize涔熸敮鎸丼QL璇彞鏌ヨimportGameModelfrom'../model/game';//娓告垙鍒楄〃鏌ヨ鏈嶅姟asyncquery(){returnGameModel.sequelize.query('selectgameId,name,description,type,iconfromgamewhereisDelete=0',);}ORM鐨勪紭缂虹偣闅愯棌浜嗘暟鎹闂殑缁嗚妭锛屸€滃皝闂€濈殑閫氱敤鏁版嵁搴撲氦浜掓槸ORM鐨勬牳蹇冿紝璁╂垜浠父瑙佺殑鏁版嵁搴撲氦浜掑彉寰楃畝鍗曟槗琛岋紝鏍规湰涓嶉渶瑕佽€冭檻SQL璇彞銆傚紑鍙戞晥鐜囨洿楂樸€侽RM璁╂垜浠緢瀹规槗鏋勯€犲浐鍖栨暟鎹€傚湪ORM璇炵敓涔嬪墠锛屾垜浠渶瑕佺湅鍒版垜浠殑瀵硅薄妯″瀷涓€涓竴涓殑杞寲涓轰竴鏉QL璇彞锛岄€氳繃鐩磋繛鎴栬€匘Bhelper鏉ユ瀯寤烘垜浠殑鍏崇郴鍨嬫暟鎹簱銆傛暟鎹簱绯荤粺銆傜幇鍦ㄥ熀鏈笂鎵€鏈夌殑ORM妗嗘灦閮芥彁渚涗簡閫氳繃瀵硅薄妯″瀷鏋勫缓鍏崇郴鏁版嵁搴撶粨鏋勭殑鍔熻兘銆傛暟鎹闂洿鍔犳娊璞″拰鍙Щ妞嶏紝鏀寔闈㈠悜瀵硅薄鐨勫皝瑁呫€傛暟鎹ā鍨嬪叏閮ㄥ畾涔夊湪涓€澶勶紝鏇存槗浜庢洿鏂板拰缁存姢锛屼篃鏈夊埄浜庝唬鐮佸鐢ㄣ€侽RM鏈夌幇鎴愮殑宸ュ叿锛屽緢澶氬姛鑳介兘鍙互鑷姩瀹屾垚锛屾瘮濡傛暟鎹潃姣掋€侀澶勭悊銆佷簨鍔＄瓑绛夈€傞€肩潃浣犵敤MVC鏋舵瀯锛孫RM鏄ぉ鐢熺殑Model锛屾渶鍚庤浠ｇ爜鏇存竻鏅般€傚熀浜嶰RM鐨勪笟鍔′唬鐮佹瘮杈冪畝鍗曪紝浠ｇ爜閲忓皬锛岃涔夊ソ锛屽鏄撶悊瑙ｃ€傞槻姝QL娉ㄥ叆鏀诲嚮涓嶄竴瀹氳缂栧啓鎬ц兘涓嶄匠鐨凷QL銆傜己鐐规槸涓嶅彲閬垮厤鐨勶紝鑷姩鍖栨剰鍛崇潃鏄犲皠鍜屽叧鑱旂鐞嗭紝浠ョ壓鐗叉€ц兘涓轰唬浠枫€傚悇绉峅RM妗嗘灦閮藉湪灏濊瘯浣跨敤鍚勭鏂规硶鏉ュ噺灏戞€ц兘鎹熷け锛屾瘮濡傚欢杩熷姞杞芥妧鏈€佺紦瀛樻妧鏈瓑銆傞潰鍚戝璞＄殑鏌ヨ璇█鏄暟鎹簱鍜屽璞′箣闂寸殑杩囨浮銆傝櫧鐒跺畠闅愯棌浜嗘暟鎹眰闈㈢殑涓氬姟鎶借薄锛屼絾骞朵笉鑳藉畬鍏ㄥ睆钄芥暟鎹簱灞傜殑璁捐銆侽RM搴撲笉鏄竴涓交閲忕骇鐨勫伐鍏凤紝瀛︿範鍜岃缃兘闇€瑕佽姳璐瑰緢澶х殑鍔熷か锛岃繖鏃犵枒浼氬鍔犲涔犳垚鏈€侽RM寰堥毦瀹炵幇杩囦簬澶嶆潅鐨勬煡璇€傝櫧鐒跺彲浠ュ疄鐜帮紝浣嗘槸浠ｄ环寰堝ぇ锛堟€ц兘涓嶅鍘熺敓SQL锛夈€傛寔涔呭眰缂轰箯鐏垫椿鎬с€備竴鏃︿笟鍔￠渶姹傚彂鐢熷彉鍖栵紝灏卞繀椤讳慨鏀规寔涔呭眰鐨勬帴鍙ｃ€傛寔涔呭眰鍚屾椂缁戝畾棰嗗煙妯″瀷鍜屽叧绯绘暟鎹簱妯″瀷銆傛棤璁洪鍩熸ā鍨嬭繕鏄叧绯绘暟鎹簱妯″瀷鍙戠敓鍙樺寲锛岄兘蹇呴』淇敼鎸佷箙灞傜浉鍏崇▼搴忎唬鐮侊紝澧炲姞浜嗚蒋浠剁淮鎶ょ殑闅惧害銆備粈涔堟槸鈥滄寔涔呭寲鈥濆眰鎸佷箙鍖栵紙Persistence锛夛紝鍗冲皢鏁版嵁锛堝鍐呭瓨涓殑瀵硅薄锛変繚瀛樺埌鍙互姘镐箙淇濆瓨鐨勫瓨鍌ㄨ澶囷紙濡傜鐩橈級涓€傛寔涔呭寲鐨勪富瑕佸簲鐢ㄦ槸灏嗗唴瀛樹腑鐨勬暟鎹瓨鍌ㄥ湪鍏崇郴鍨嬫暟鎹簱涓紝褰撶劧涔熷彲浠ュ瓨鍌ㄥ湪纾佺洏鏂囦欢銆乆ML鏁版嵁鏂囦欢绛夈€傛€荤粨锛氱洰鍓峅RM寮€鍙戞ā鍨嬫槸涓绘祦锛屾彁楂樹簡浠ｇ爜鐨勫皝瑁呮€у拰鍙鎬э紝闃叉SQL娉ㄥ叆鏀诲嚮銆傚皯閲忕殑鎬ц兘鎹熷け鎹㈡潵浜嗗紑鍙戞晥鐜囩殑鏄庢樉鎻愬崌銆傛槑鏄剧殑鎬ц兘鎹熷け寰€寰€瀛樺湪浜庡鏉傜殑鏌ヨ涓€傝繖绉嶆儏鍐典笅锛屽彲浠ラ€夋嫨浣跨敤ORM鎻愪緵鐨凷QL璇彞鎺ュ彛鏉ヤ紭鍖栨€ц兘銆傚師鏂囬摼鎺ユ帢閲戯細鍓嶇鍕掑竷鏈楃煡涔庯細鍓嶇鍕掑竷鏈楁妧鏈崥鏂囨寔缁垎浜紝鍏虫敞寰俊鍏紬鍙佛煈夝煆诲墠绔嫆甯冩湕
