{"id":2992,"date":"2016-03-19T13:11:19","date_gmt":"2016-03-19T05:11:19","guid":{"rendered":"http:\/\/blog.turn.tw\/?p=2992"},"modified":"2016-03-19T14:03:37","modified_gmt":"2016-03-19T06:03:37","slug":"%e6%89%b9%e8%a9%95-active-record-%e7%9a%8413%e5%80%8b%e8%ab%96%e9%bb%9e%ef%bc%9a%e6%9c%80%e5%a5%bd%e7%94%a8%e4%b9%9f%e6%9c%80%e5%8d%b1%e9%9a%aa%e7%9a%84-anti-pattern","status":"publish","type":"post","link":"https:\/\/blog.turn.tw\/?p=2992","title":{"rendered":"\u6279\u8a55 Active Record \u768413\u500b\u8ad6\u9ede\uff1a\u6700\u597d\u7528\u4e5f\u6700\u5371\u96aa\u7684 Anti-pattern"},"content":{"rendered":"<p>\u73fe\u5728\u5f88\u591a\u6846\u67b6\u90fd\u5167\u5efaactive record pattern\u4f86\u5e6b\u52a9\u958b\u767c\u8005\u5efa\u7acbapplication\u3002<\/p>\n<p>\u4e4d\u770b\u4e4b\u4e0b\u5f88\u81ea\u7136\uff0c\u5be6\u969b\u4e0a\u5b83\u537b\u9055\u53cd\u4e86\u4e00\u5927\u5806\u50b3\u7d71\u7684\u8edf\u9ad4\u958b\u767c\u77e5\u8b58\u3002<\/p>\n<p>\u9019\u6703\u8b93\u5de5\u7a0b\u5e2b\u5728\u5b78\u7fd2\u6642\u9677\u5165\u4e0b\u5217\u56f0\u60d1\uff1a<\/p>\n<blockquote><p>\u70ba\u751a\u9ebc\u4e00\u5806\u66f8\u4e0a\u7684\u539f\u5247\uff08principles\uff09\u3001\u6a21\u5f0f\uff08patterns\uff09\u3001\u624b\u6cd5\uff08practices\uff09\uff0c\u90fd\u7121\u6cd5\u5728\u5be6\u52d9\u4e0a\u61c9\u7528\uff1f<\/p><\/blockquote>\n<p>\u63a5\u8457\u5c0e\u81f4\u4e00\u500b\u66f4\u56b4\u91cd\u7684\u8a8d\u77e5\u5931\u8abf\uff1a<\/p>\n<blockquote><p>\u662f\u6211\u7684\u958b\u767c\u65b9\u6cd5\u4e0d\u5c0d\u55ce\uff1f\u9084\u662f\u9019\u4e9b\u50b3\u7d71\u77e5\u8b58\u5168\u90e8\u904e\u6642\u4e86\uff1f<\/p><\/blockquote>\n<p>\u4e8b\u5be6\u4e0a\uff0cactive record pattern\u9084\u771f\u7684\u8ddf\u50b3\u7d71\u958b\u767c\u77e5\u8b58\u5145\u6eff\u885d\u7a81\u3002<\/p>\n<p>\u70ba\u4e86\u9ede\u51fa\u90a3\u4e9b\u885d\u7a81\uff0c\u9019\u7bc7\u6587\u7ae0\u6703\u5f9e\u50b3\u7d71\u958b\u767c\u77e5\u8b58\u7684\u89d2\u5ea6\uff0c\u5c0dactive record pattern\u63d0\u51fa\u591a\u9805\u6279\u8a55\u3002<\/p>\n<h1>\u4ec0\u9ebc\u662fActive record pattern\uff1f<\/h1>\n<p>\u5f9eRails\u7684ActiveRecord\uff0c\u5230Laravel\u7684Eloquent\uff0c\u8a31\u591a\u6846\u67b6\u90fd\u5167\u5efaactive record pattern\u3002<\/p>\n<p>\u5404\u6846\u67b6\u5c0dactive record pattern\u7684\u5be6\u4f5c\u90fd\u5f88\u83ef\u9e97\u3002\u9664\u4e86\u76f4\u63a5\u64cd\u4f5c\u8cc7\u6599\u5eab\u3001\u5145\u7576domain object\u7684\u529f\u80fd\u4e4b\u5916\uff0c\u9084\u63d0\u4f9brelationships\u3001\u81ea\u52d5\u66f4\u65b0created_at\/updated_at\u6b04\u4f4d\u7b49\u7b49\u591a\u7a2e\u529f\u80fd\u3002<\/p>\n<p>\u4e00\u822c\u8a8d\u70baactive record pattern\u9019\u500b\u540d\u5b57\u7531Martin Fowler\u6240\u767c\u660e\u3002<\/p>\n<p>\u6839\u64da<a href='http:\/\/www.martinfowler.com\/eaaCatalog\/activeRecord.html'>\u4ed6\u7684\u5b9a\u7fa9<\/a>\uff0c\u4e00\u65e6\u985e\u5225\u540c\u6642\u8655\u7406\u5169\u4ef6\u4e8b\u60c5\uff1a<\/p>\n<p>* data access logic\uff08\u8655\u7406\u8cc7\u6599\u5eab\u76f8\u95dc\u64cd\u4f5c\uff09<br \/>\n* domain logic\uff08\u8655\u7406app\u7684\u5546\u696d\u908f\u8f2f\uff09<\/p>\n<p>\u5c31\u7b97\u662f\u5be6\u4f5c\u4e86active record pattern\uff08\u4e0b\u6587\u7c21\u7a31AR\uff09\u3002\u5176\u4ed6\u83ef\u9e97\u7684\u529f\u80fd\u90fd\u662f\u6846\u67b6\u984d\u5916\u63d0\u4f9b\u7684\u3002<\/p>\n<p>AR\u6703\u8b93\u7269\u4ef6\u540c\u6642\u300c\u63d0\u4f9b\u8cc7\u6599\u7d66\u5225\u4eba\u7528\u300d\u8207\u300c\u63d0\u4f9b\u884c\u70ba\u7d66\u5225\u4eba\u547c\u53eb\u300d\u3002<\/p>\n<p>\u6b63\u662f\u56e0\u70ba\u9019\u9ede\uff0c\u5c31\u50b3\u7d71\u958b\u767c\u77e5\u8b58\u4f86\u770b\uff0c\u81f3\u5c11\u53ef\u4ee5\u5c0dAR\u505a\u51fa13\u7a2e\u6279\u8a55\u3002<\/p>\n<p>\u4e0b\u9762\u6703\u5c07\u9019\u4e9b\u6279\u8a55\u5206\u62103\u7a2e\u5c64\u9762\u4f86\u770b\uff0c\u7136\u5f8c\u4e00\u4e00\u5217\u8209\u5b83\u5011\uff1a<\/p>\n<p>* \u539f\u5247\u5c64\u9762\uff08Principles\uff09<br \/>\n* \u6a21\u5f0f\u5c64\u9762\uff08Patterns\uff09<br \/>\n* \u624b\u6cd5\u5c64\u9762\uff08Practices\uff09<\/p>\n<p>\uff08\u6ce8\u610f\uff1a\u8a31\u591a\u6279\u8a55\u5176\u5be6\u662f\u6307\u540c\u4e00\u4ef6\u4e8b\uff0c\u53ea\u662f\u63db\u500b\u5c64\u9762\uff0c\u6216\u662f\u63db\u500b\u65b9\u6cd5\u63cf\u8ff0\u800c\u5df2\u3002\uff09<\/p>\n<hr \/>\n<h1>\u539f\u5247\u5c64\u9762 \uff08Principles\uff09<\/h1>\n<h2>1. \u9055\u53cd\u7269\u4ef6\u5c0e\u5411\uff08OOP\uff09\u7cbe\u795e<\/h2>\n<p>\u7269\u4ef6\u61c9\u8a72\u5c07\u8cc7\u6599\u5c0d\u5916\u96b1\u85cf\uff0c\u5c07\u884c\u70ba\u5c0d\u5916\u958b\u653e\uff08hidden data, expose behavior\uff09\u3002<\/p>\n<p>\u800c\u627f\u8f09\u8cc7\u6599\u7684\u8cc7\u6599\u7d50\u69cb\u6703\u5c07\u8cc7\u6599\u5c0d\u5916\u958b\u653e\uff0c\u4e26\u4e14\u4e0d\u5177\u6709\u884c\u70ba\uff08expose data, no behavior\uff09\u3002<\/p>\n<p>AR\u7269\u4ef6\u56e0\u70ba\u540c\u6642\u8eab\u517c\u5169\u8005\uff0c\u5c0e\u81f4\u4f60\u5f9e\u6839\u672c\u4e0a\u9762\u81e8\u77db\u76fe\u3002<\/p>\n<p>\u4f60\u6c38\u9060\u6293\u4e0d\u6e05\u5206\u969b\u4f55\u5728\uff1a\u8a72\u8b93\u5b83\u6240\u6709properties\u90fd\u5c0d\u5916\u96b1\u85cf\u55ce\uff1f\u9084\u662f\u8b93\u5b83\u4e00\u500bmethod\u90fd\u6c92\u6709\uff1f\u5206\u5225\u8a72\u505a\u5230\u4ec0\u9ebc\u7a0b\u5ea6\u5462\uff1f<\/p>\n<pre>\r\n\/\/ Should I do it this way?\r\n$totalPrice = $order->price + $order->tax;\r\n\r\n\/\/ Should I do it this way?\r\n$totalPrice = $order->getTotalPrice();\r\n<\/pre>\n<h2>2. \u9055\u53cdSingle Responsibility Principle <\/h2>\n<p>AR\u8ca0\u8cac\u4e86data access logic\uff0c\u5c0e\u81f4\u8cc7\u6599\u5eabschema\u4e00\u6539\uff0c\u7a0b\u5f0f\u78bc\u5fc5\u9808\u8ddf\u8457\u4fee\u6539\u3002<\/p>\n<p>AR\u8ca0\u8cac\u4e86domain logic\uff0c\u5c0e\u81f4app\u7684\u5546\u696d\u908f\u8f2f\u4e00\u6539\uff0c\u7a0b\u5f0f\u78bc\u5fc5\u9808\u8ddf\u8457\u4fee\u6539\u3002<\/p>\n<p>OOP\u77e5\u540d\u4e94\u5927\u539f\u5247SOLID\u4e2d\u7684SRP\u88abAR\u76f4\u63a5\u6253\u7834\uff1a\u4e00\u500b\u985e\u5225\u61c9\u8a72\u56e0\u70ba\u4e14\u53ea\u56e0\u70ba\u4e00\u500b\u7406\u7531\u800c\u4fee\u6539\u3002<\/p>\n<h2>3. \u9055\u53cd\u300cTell, don&#8217;t ask.\u300d\u539f\u5247<\/h2>\n<p>\u300cTell, don&#8217;t ask.\u300d\u539f\u5247\u6307\u5f15\u5927\u5bb6OOP\u958b\u767c\u61c9\u8a72\u300c\u544a\u8a34\u7269\u4ef6\u53bb\u505a\u4ec0\u9ebc\u300d\u800c\u4e0d\u61c9\u8a72\u300c\u8ddf\u7269\u4ef6\u62ff\u8cc7\u6599\u51fa\u4f86\u64cd\u4f5c\u300d\u3002<\/p>\n<p>\u504f\u504fAR\u7269\u4ef6\u662f\u5982\u6b64\u65b9\u4fbf\u6613\u7528\uff0c\u4f60\u5e7e\u4e4e\u4e00\u5b9a\u6703\u5f9e\u5916\u90e8\u76f4\u63a5\u53d6\u7528\u5b83\u7684\u8cc7\u6599\u3002<\/p>\n<pre>\r\n\/\/ This may appear in controllers or service objects.\r\n$totalPrice = $oder->price + $order->tax;\r\n\r\nif ($totalPrice > 1000) {\r\n    \/\/...\r\n}\r\n<\/pre>\n<h2>4. \u5c0e\u81f4Database Oriented Development<\/h2>\n<p>\u61c9\u8a72\u570d\u7e5e\u8457\u7522\u54c1\u672c\u8eab\u9818\u57df\u77e5\u8b58\u53bb\u958b\u767c\u7684domain driven\/business oriented\u958b\u767c\u65b9\u6cd5\uff0c\u8b8a\u6210\u4ee5database\u70ba\u4e2d\u5fc3\u5728\u958b\u767c\u3002<\/p>\n<p>\u958b\u767c\u8005\u5728\u958b\u767c\u904e\u7a0b\u4e2d\uff0c\u4e0d\u518d\u5c0d\u9818\u57df\u77e5\u8b58\u5ff5\u8332\u5728\u8332\uff0c\u800c\u662f\u6eff\u8166\u5b50\u60f3\u8457database schema\u3002<\/p>\n<p>\u5982\u679c\u4f7f\u7528\u7684Active Record Pattern\u751a\u81f3\u5be6\u4f5c\u4e86toJson\u9019\u985e\u7684\u51fd\u5f0f\u4f86\u5e6b\u4f60\u628aentity\u5167\u5bb9\u8f49\u6210JSON\u683c\u5f0f\u7684\u8a71\uff0c\u4e0b\u5834\u5c31\u66f4\u8a87\u5f35\u4e86\uff1a\u9023front-end\u7684\u958b\u767c\u4eba\u54e1\u90fd\u5f97\u8ddf\u8457\u6eff\u8166\u5b50database schema\u3002\u524d\u5f8c\u7aef\u5206\u96e2\u7a0b\u5ea6\u66f4\u4f4e\u3002<\/p>\n<h2>5. \u5c0e\u81f4\u6e2c\u8a66\u6642\u78b0\u5230\u8cc7\u6599\u5eab<\/h2>\n<p>\u50b3\u7d71\u4e0a\u6703\u8aaa\u6e2c\u8a66\u6642\u61c9\u8a72\u53ea\u6e2c\u5546\u696d\u908f\u8f2f\uff0c\u5225\u78b0\u8cc7\u6599\u5eab\uff0c\u56e0\u70ba\u78b0\u5230\u8cc7\u6599\u5eab\u6703\u8dd1\u5f88\u6162\u3002\u800c\u4e14\u5169\u8005\u61c9\u8a72\u5206\u958b\u4f86\u6e2c\u3002<\/p>\n<p>\u4f46\u662f\u7528\u4e86AR\u6703\u8b93\u6e2c\u8a66\u5f88\u96e3\u4e0d\u78b0\u5230\u8cc7\u6599\u5eab\u3002<\/p>\n<p>\u6846\u67b6\u751a\u81f3\u76f4\u63a5\u63d0\u4f9b<a href='http:\/\/api.rubyonrails.org\/classes\/ActiveRecord\/FixtureSet.html'>fixtures<\/a>\u3001<a href='https:\/\/laravel.com\/docs\/5.2\/seeding#using-model-factories'>Model Factories<\/a>\u4f86\u5354\u52a9\u9019\u4ef6\u4e8b\uff0c\u6beb\u4e0d\u907f\u8af1\u3002<\/p>\n<hr \/>\n<h1>\u6a21\u5f0f\u5c64\u9762\uff08Patterns\uff09<\/h1>\n<h2>6. \u7121\u6cd5\u7528Constructor Injection <\/h2>\n<p>\u4f60\u7121\u6cd5\u5be6\u4f5c\u9019\u500bdependency injection\u6a21\u5f0f\u4f86\u8a2d\u8a08\u985e\u5225\uff1a<\/p>\n<pre>\r\n\/\/ You can't do this with AR.\r\n$order= new Order(new ComponentA(), new ComponentB());\r\n<\/pre>\n<p>\u56e0\u70ba\u4f60\u7684\u5efa\u69cb\u5f0f\u88ab\u62ff\u4f86\u8655\u7406data access logic\uff0c\u56e0\u800c\u653e\u68c4domain logic\u4e86\u3002<\/p>\n<h2>7. \u5c0e\u81f4God object <\/h2>\n<p>\u5efa\u51fa\u4f86\u7684entity\uff0c\u6703\u5f88\u5bb9\u6613\u628acode\u4e00\u76f4\u5f80\u88e1\u9762\u653e\uff0c\u6700\u5f8c\u8b8a\u6210\u4e0a\u5343\u884c\u3001\u8ca0\u8cac\u4e00\u5806\u529f\u80fd\u7684God object\uff1a<\/p>\n<pre>\r\n$order->iCanDoThis();\r\n$order->iCanDoThat();\r\n$order->iCanDoEverything();\r\n<\/pre>\n<p>\u4e5f\u5c31\u662fRails\u793e\u7fa4\u6d41\u50b3\u7684\u300cFat model, skinny controller\u300d\u3002<\/p>\n<h2>8. \u5c0e\u81f4\u300c\u8ca7\u8840\u7684\u9818\u57df\u6a21\u578b\u300d\uff08Anemic Domain Model \uff09<\/h2>\n<p>\u5982\u679c\u4f60\u70ba\u4e86\u907f\u514dentity\u5167\u542b\u904e\u591a\u5546\u696d\u908f\u8f2f\u800c\u5c07code\u62bd\u96e2\u5230\u5225\u7684\u5730\u65b9\uff08\u4f8b\u5982\uff1a\u505a\u4e86\u4e00\u5806service objects\uff09\uff0c\u90a3\u5f88\u5bb9\u6613\u8b8a\u6210\u76f8\u53cd\u7684\u72c0\u6cc1\uff1aentity\u672c\u8eab\u5e7e\u4e4e\u4e0d\u542b\u4ec0\u9ebccode\u3002<\/p>\n<p>\u4f8b\u5982\u9019\u6a23\uff1a<\/p>\n<pre>\r\n\/\/ The entity now can't do anything.\r\n\/\/ So anemic, so poor.\r\n\/* \r\n$order->iCanDoThis();\r\n$order->iCanDoThat();\r\n$order->iCanDoEverything();\r\n*\/\r\n\r\n\/\/ They are all in the services instead.\r\n$service = new DoThisService();\r\n\r\n$service->handle($order);\r\n<\/pre>\n<h2>9. \u505a\u4e0d\u51faRich Domain Model <\/h2>\n<p>\u7406\u60f3\u72c0\u6cc1\u662f\u96a8\u8457app\u7684\u5546\u696d\u908f\u8f2f\u8d8a\u8b8a\u8d8a\u8907\u96dc\uff0c\u4f60\u7684domain model\u6703\u56e0\u70ba\u5404\u7a2e\u5206\u5de5\uff08\u7531\u591a\u500b\u7269\u4ef6\u4f86\u5c0d\u5916\u8ca0\u8cac\u5404\u7a2ebehavior\uff09\u800c\u8d8a\u8b8a\u8d8a\u8c50\u5bcc\uff0c\u6700\u5f8c\u6210\u70ba\u6f02\u4eae\u7684rich domain model\u3002<\/p>\n<p>\u975e\u5e38\u907a\u61be\u7684\uff0c\u56e0\u70ba\u4f7f\u7528\u4e86AR\u7684\u95dc\u4fc2\uff0c\u985e\u5225\u7684\u8a2d\u8a08\u88ab\u7d81\u6b7b\u5728schema\u4e0a\uff0c\u56e0\u6b64\u4f60\u5f88\u96e3\u505a\u51farich domain model\u3002<\/p>\n<p>\u4f60\u8981\u561b\u6703\u505a\u51faGod object\uff0c\u8981\u561b\u6703\u505a\u51faAnemic domain model\u3002<\/p>\n<p>\u4e5f\u8a31\u6703\u6709\u4eba<a href='http:\/\/victorsavkin.com\/post\/41016739721\/building-rich-domain-models-in-rails-separating'>\u5617\u8a66\u5c07data access logic\u8207domain logic\u5206\u96e2<\/a>\u4f86\u514b\u670d&#8230;<\/p>\n<p>\u5949\u52f8\u5343\u842c\u5225\u9019\u9ebc\u505a\uff1a\u6839\u672c\u662f\u653e\u68c4AR\u7684\u512a\u9ede\u53bb\u786c\u641e\uff0c\u6700\u5f8c\u8b8a\u6210\u56db\u4e0d\u50cf\u3002<\/p>\n<h2>10. \u8cea\u8b8a\u7684Repository Pattern <\/h2>\n<p>\u5c07CRUD\u64cd\u4f5c\uff08persistence logic\u3001query logic\uff09\u5c01\u88dd\u7684\u7d93\u5178\u6a21\u5f0frepository pattern\uff0c\u56e0\u70baAR\u800c\u7522\u751f\u8cea\u8b8a\u3002<\/p>\n<p>\u8209\u4f8b\u4f86\u8aaa\uff0c\u4f60\u53ef\u80fd\u770b\u904e\u6709\u4eba\u9019\u6a23\u8a2d\u8a08repository class\uff1a<\/p>\n<pre>\r\nclass OrderRepository\r\n{\r\n    public function save($order)\r\n    {\r\n        $order->save();\r\n    }\r\n\r\n    \/\/ blah blah\r\n}\r\n<\/pre>\n<p>\u63a5\u8457\u5c07repository\u7528dependency injection\u653e\u9032controller\u6216\u662fservice object\u5167\u3002<\/p>\n<p>\u4e4d\u770b\u4e4b\u4e0b\u6c92\u554f\u984c\uff1a\u78ba\u5be6\u56e0\u6b64\u53ef\u4ee5\u5728\u6e2c\u8a66\u6642\u62bd\u63dbrepository object\u6210\u6e2c\u8a66\u5c08\u7528\u7684object\u3002<\/p>\n<p>\u4f46\u61c9\u8a72\u300c\u8ca0\u8cacpersistence logic\u300d\u7684repository\uff0c\u5be6\u969b\u4e0a\u5c45\u7136\u53ea\u662f\u53eb\u53c3\u6578\u7269\u4ef6\u81ea\u5df1save\u81ea\u5df1\u3002<\/p>\n<p>\u9019\u53ef\u7a31\u4e0d\u4e0a\u512a\u96c5\u3002<\/p>\n<p>\u8cea\u8b8a\u5f8c\u7684repository\u9000\u5316\u6210\u53ea\u8ca0\u8cac\u67e5\u8a62\u529f\u80fd\u7684query object\u3002<\/p>\n<h2>11. \u8cea\u8b8a\u7684Domain Driven Design <\/h2>\n<p>Eric Evans\u5beb\u7684Domain-Driven Design\u4e00\u66f8\u6559\u5c0e\u4e86\u4e00\u7a2e\u570d\u7e5e\u9818\u57df\u77e5\u8b58\u7684\u8edf\u9ad4\u958b\u767c\u65b9\u6cd5\u3002<\/p>\n<p>\u5f88\u60b2\u6158\u7684\uff0c\u5982\u679c\u4f60\u7528\u4e86AR\uff0c\u9019\u672c\u66f8\u4f60\u5c07\u5f88\u96e3\u770b\u5f97\u61c2\uff0c\u4e5f\u5f88\u96e3\u61c9\u7528\u3002<\/p>\n<p>DDD\u5f9e\u6700\u57fa\u672c\u7684Repository Pattern\u5c31\u5df2\u56e0AR\u5c0e\u81f4\u8cea\u8b8a\uff08\u53c3\u800310.\uff09\uff0c\u518d\u52a0\u4e0aentity\u9593\u7684\u95dc\u4fc2\u901a\u5e38\u6703\u88abAR\u76f4\u63a5\u6839\u64daschema\u5efa\u597d\uff0cAggregate\u4e5f\u8b8a\u5f97\u7121\u6cd5\u5c01\u4f4f\u5167\u90e8\u7269\u4ef6\uff0c\u66f4\u4e0d\u7528\u8aaadomain model\u6839\u672c\u5efa\u4e0d\u597d\u4e86\uff08\u53c3\u80039.\uff09\u3002<\/p>\n<hr \/>\n<h1>\u624b\u6cd5\u5c64\u9762\uff08Practices\uff09<\/h1>\n<h2>12. \u6feb\u7528public properties <\/h2>\n<p>OOP\u8ab2\u672c\u7ffb\u6c92\u5e7e\u9801\u5c31\u6703\u63d0\u5230getter\/setter\u7684\u89c0\u5ff5\uff0c\u4e26\u4e14\u53cd\u5c0d\u76f4\u63a5\u628aproperties\u8a2d\u6210public\u3002<\/p>\n<p>AR\u56e0\u70ba\u540c\u6642\u8ca0\u8cacdata access logic\uff0c\u5f88\u81ea\u7136\u6703\u8b93\u4eba\u76f4\u63a5\u5c0dproperties\u64cd\u4f5c\uff1a<\/p>\n<pre>\r\n$order->price = 1000;\r\n$order->is_sold = true;\r\n<\/pre>\n<h2>13. Atomic operation\u56f0\u5883<\/h2>\n<p>\u70ba\u4e86\u78ba\u4fddDatabase\u5167\u7684\u8cc7\u6599\u6b63\u78ba\u6027\uff0c\u6709\u6642\u4f60\u9700\u8981\u7528\u5230lock\u6a5f\u5236\u6216\u662ftransaction\u6a5f\u5236\u3002<\/p>\n<p>\u8a66\u554f\u4e0b\u5217\u9019\u5169\u884ccode\u8a72\u653e\u54ea\u5462\uff1f<\/p>\n<pre>\r\nLOCK TABLES orders WRITE, items WRITE, users WRITE\r\n<\/pre>\n<p>\u8207<\/p>\n<pre>\r\nUNLOCK TABLES\r\n<\/pre>\n<p>\u653e\u5728entity\u7684\u8a71\uff0c\u4ee3\u8868Order\/Item\/User\u5176\u4e2d\u4e00\u500b\u985e\u5225\u6703\u76f4\u63a5\u64cd\u4f5c\u5176\u9918\u5169\u500b\u985e\u5225 => \u5bb9\u6613\u5c0e\u81f4god object\u3002<\/p>\n<p>\u4e0d\u653e\u5728entity\u7684\u8a71\uff0c\u5c31\u5fc5\u9808\u653e\u5728\u5916\u90e8\uff08\u4f8b\u5982service object\u6216controller\uff09 => SQL\u8a9e\u6cd5\u4e0d\u518d\u88ab\u5c01\u88dd\u5728\u5e95\u5c64\uff0c\u4e5f\u4e0d\u88ab\u5c01\u88dd\u5728entity\u5167\uff0c\u800c\u5916\u6d29\u5230\u66f4\u4e0a\u5c64\u4e86\u3002<\/p>\n<h1>\u7d50\u8ad6<\/h1>\n<p>Active Record Pattern\u65b9\u4fbf\u3001\u5feb\u901f\u958b\u767c\u7684\u7279\u6027\uff0c\u8b93\u5b83\u5177\u6709\u975e\u5e38\u9ad8\u7684\u5546\u696d\u50f9\u503c\u3002<\/p>\n<p>\u9019\u4e5f\u662fRails\u4e4b\u5f8c\u4e00\u76f4\u5230Laravel\u7b49\u7b49\u5404\u5927\u6846\u67b6\u90fd\u5be6\u4f5c\u5b83\u7684\u539f\u56e0\u3002<\/p>\n<p>\u611b\u7528Active record pattern\u8ddf\u53cd\u5c0dactive record pattern\u7684\u4eba\u5e38\u5e38\u6709\u6240\u722d\u8ad6\uff0c\u5e7e\u4e4e\u6210\u4e86\u73fe\u4ee3\u958b\u767cvs\u50b3\u7d71\u958b\u767c\u65b9\u6cd5\u7684\u6230\u722d\uff08<a href='http:\/\/david.heinemeierhansson.com\/2014\/test-induced-design-damage.html'>\u4f8b\u4e00<\/a>\u3001<a href='https:\/\/sites.google.com\/site\/unclebobconsultingllc\/active-record-vs-objects'>\u4f8b\u4e8c<\/a>\uff09\u3002<\/p>\n<p>\u4f7f\u7528\u5b83\u4f86\u958b\u767c\u6c92\u4ec0\u9ebc\u554f\u984c\uff0c\u4f46\u5343\u842c\u8981\u7559\u5fc3\u5b83\u8207\u54ea\u4e9b\u50b3\u7d71\u958b\u767c\u77e5\u8b58\u6709\u885d\u7a81\u3002<\/p>\n<p>\u4eab\u53d7\u5b83\u7684\u512a\u9ede\uff0c\u7406\u89e3\u5b83\u7684\u7f3a\u9ede\uff0c\u624d\u80fd\u5728\u73fe\u4ee3\u548c\u50b3\u7d71\u958b\u767c\u77e5\u8b58\u7684\u885d\u7a81\u4e0a\uff0c\u627e\u5230\u5c6c\u65bc\u81ea\u5df1\u7684\u5e73\u8861\u9ede\u3002<\/p>\n<p>\uff08\u5b8c\uff09<\/p>\n<hr \/>\n<p><em><br \/>\n\u4e0b\u9762\u662f\u6211\u5728\u516c\u53f8\u65b0\u958b\u767c\u7684\u4e00\u500b\u8a0e\u8ad6plugin\u3002\u6b61\u8fce\u7528\u5b83\u4f86\u53cd\u6620\u60a8\u5c0dAR\u7684\u770b\u6cd5\u3002<\/p>\n<p>\u9806\u5e36\u4e00\u63d0\uff0cserver-side\u662f\u7528Laravel 5\u6240\u5beb\u6210\uff1a\u80cc\u5f8c\u7684Eloquent\uff0c\u6b63\u662f\u5be6\u4f5cactive record pattern\u3002<br \/>\n<\/em><\/p>\n<div id=\"projectx_thread\"><\/div>\n<p><script>\n    var projectx_config = {\n        page: {\n            url: 'https:\/\/blog.turn.tw\/?p=2992',\n            id: 4\n        }\n    };\n    (function() {\n        var d = document, s = d.createElement('script');\n        s.src = '\/\/bcuz.wordcorp.net\/embed.js?ts=' + new Date().getTime();\n        (d.head || d.body).appendChild(s);\n    })();\n<\/script><\/p>\n<p>(Photo via Don McCullough, CC licensed.)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u73fe\u5728\u5f88\u591a\u6846\u67b6\u90fd\u5167\u5efaactive record pattern\u4f86\u5e6b\u52a9\u958b\u767c\u8005\u5efa\u7acbapplication\u3002 \u4e4d\u770b\u4e4b\u4e0b &hellip; <a href=\"https:\/\/blog.turn.tw\/?p=2992\" class=\"more-link\">\u7e7c\u7e8c\u95b1\u8b80 <span class=\"screen-reader-text\">\u6279\u8a55 Active Record \u768413\u500b\u8ad6\u9ede\uff1a\u6700\u597d\u7528\u4e5f\u6700\u5371\u96aa\u7684 Anti-pattern<\/span> <span class=\"meta-nav\">&rarr;<\/span> <\/a><\/p>\n","protected":false},"author":1,"featured_media":3075,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.turn.tw\/index.php?rest_route=\/wp\/v2\/posts\/2992"}],"collection":[{"href":"https:\/\/blog.turn.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.turn.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.turn.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.turn.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2992"}],"version-history":[{"count":82,"href":"https:\/\/blog.turn.tw\/index.php?rest_route=\/wp\/v2\/posts\/2992\/revisions"}],"predecessor-version":[{"id":3076,"href":"https:\/\/blog.turn.tw\/index.php?rest_route=\/wp\/v2\/posts\/2992\/revisions\/3076"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.turn.tw\/index.php?rest_route=\/wp\/v2\/media\/3075"}],"wp:attachment":[{"href":"https:\/\/blog.turn.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.turn.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.turn.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}