{"id":47661,"date":"2023-07-04T05:46:50","date_gmt":"2023-04-02T06:54:02","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/"},"modified":"2024-04-30T11:54:05","modified_gmt":"2024-04-30T03:54:05","slug":"%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/","title":{"rendered":"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e"},"content":{"rendered":"

\u9996\u5148<\/h1>\n

\u6211\u662fYN\uff0c\u4e00\u4e2a\u4ece30\u4ee3\u6ca1\u6709\u7ecf\u9a8c\u5f00\u59cb\u5b66\u4e60\u6210\u4e3a\u5de5\u7a0b\u5e08\u7684\u4eba\u3002\u8fd9\u7bc7\u6587\u7ae0\u662f\u5173\u4e8eBen Awad\u5148\u751f\u7684\u300aFullstack React GraphQL TypeScript Tutorial\u300b\uff0c \u65e8\u5728\u5e2e\u52a9\u521d\u5b66\u8005\u8fdb\u884c\u5b66\u4e60\u3002Ben\u5148\u751f\u7684\u89c6\u9891\u771f\u7684\u975e\u5e38\u9ad8\u8d28\u91cf\uff0c\u8ba9\u6211\u5b66\u5230\u4e86\u5f88\u591a\u77e5\u8bc6\uff0c\u4f46\u50cf\u6211\u8fd9\u6837\u7684\u521d\u5b66\u8005\u5374\u7ecf\u5e38\u9047\u5230\u56f0\u96be\uff0c\u96be\u4ee5\u524d\u8fdb\u3002\u6240\u4ee5\uff0c\u6211\u5199\u4e0b\u8fd9\u7bc7\u56de\u987e\u6027\u7684\u7b14\u8bb0\u3002<\/p>\n

\u8fd9\u6b21\u7684\u4e8b\u7269\u76ee\u6807<\/h1>\n

0:39:50 \u963f\u6ce2\u7f57\u670d\u52a1\u5668\u5feb\u901f\u8bbe\u7f6e
\n0:47:32 MikroORM TypeGraphQL Crud<\/p>\n

\u4e0a\u6b21 => https:\/\/qiita.com\/theFirstPenguin\/private\/9139c0b2f9e56c9a1e49<\/p>\n

\u5f00\u59cb\u4e4b\u524d<\/h1>\n

\u590d\u5236\u5206\u652f<\/h3>\n

\u611f\u8c22\u4f60\u6839\u636e\u89c6\u9891\u5185\u5bb9\u7ec6\u5206\u4e86\u4e0d\u540c\u7684\u5206\u652f\u7ed9\u6211\u3002\u9996\u5148\u5c06\u5206\u652f\u590d\u5236\u5230\u672c\u5730\uff0c\u7136\u540e\u5207\u6362\u5230\u8be5\u5206\u652f\u3002<\/p>\n

git pull origin 3_mikroORM-type-graphql-crud:3_mikroORM-type-graphql-crud\r\ngit checkout 3_mikroORM-type-graphql-crud\r\n<\/code><\/pre>\n
\u9996\u5148\uff0c\u8981\u5168\u9762\u4e86\u89e3\u6574\u4f53\u60c5\u51b5\u3002<\/h3>\n
\u76ee\u524d\u6559\u7a0b\u4ecd\u5904\u4e8e\u521d\u671f\u9636\u6bb5\uff0c\u4eceType-GraphQL\u5f00\u59cb\uff0c\u5bf9\u4e8e\u521d\u5b66\u8005\u6765\u8bf4\u4f1a\u53d8\u5f97\u7a0d\u5fae\u590d\u6742\u3002\u56e0\u6b64\uff0c\u9996\u5148\u6211\u6574\u7406\u4e86\u6574\u4f53\u67b6\u6784\u5982\u4e0b\u56fe\u6240\u793a\u3002\u4e4b\u524d\u7684\u5185\u5bb9\u4f7f\u7528\u4e86MikroORM\uff0c\u7ed3\u5408\u4e86TypeScript\u3002<\/p>\n
    \n
  • \n
      PSQL\u30c6\u30fc\u30d6\u30eb\u306eSQL\u30b9\u30ad\u30fc\u30de\u3092\u5b9a\u7fa9<\/ul>\n<\/li>\n<\/ul>\n
       <\/p>\n
        \n
      • \n
          migration\u3092\u5b9f\u884c\u3057\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210<\/ul>\n<\/li>\n<\/ul>\n
           <\/p>\n
            insert \u306a\u3069\u306eSQL\u30af\u30a8\u30ea\u3092\u5b9f\u884c<\/ul>\n
            \u6211\u6210\u529f\u5730\u505a\u5230\u4e86\u3002<\/p>\n
            \"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/div>\n
            \"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/div>\n
            \u4f7f\u7528MikroORM\u548cTypeGraphQL\u6765\u5b9e\u73b0GraphQL\u7684\u67e5\u8be2\u529f\u80fd\u3002<\/h1>\n
            \u52d5\u753b\u548c\u9019\u7bc7\u6587\u7ae0\u7684\u89e3\u8aaa\u9806\u5e8f\u6709\u4e9b\u524d\u5f8c\u985b\u5012\uff0c\u4f46\u5728\u9019\u6b21\u7684\u76ee\u6a19\u4e2d\uff0c\u6211\u5011\u5c07\u89e3\u91cb\u5982\u4f55\u9054\u5230\u5206\u652f\u7684\u7a0b\u5f0f\u78bc\uff0c\u8acb\u7406\u89e3\u3002
            \n\u9996\u5148\uff0c\u6211\u5011\u5c07\u5f9eGraphQL\u7684\u67e5\u8a62\uff08\u5373\u5728RestAPI\u4e2d\u7684GET\u65b9\u6cd5\uff09\u958b\u59cb\u89e3\u91cb\u3002<\/p>\n
            \u5c06ApolloServer\u4f5c\u4e3aExpress\u7684\u4e2d\u95f4\u4ef6\u8fdb\u884c\u8bbe\u7f6e\u3002<\/h3>\n
            \u9996\u5148\u6211\u4eec\u9700\u8981\u8fdb\u884cApolloServer\u7684\u914d\u7f6e\u3002<\/p>\n
            const<\/span> main<\/span> =<\/span> async<\/span> ()<\/span> =><\/span> {<\/span>\r\n  const<\/span> orm<\/span> =<\/span> await<\/span> MikroORM<\/span>.<\/span>init<\/span>(<\/span>microConfig<\/span>);<\/span> \/\/ MikroORM\u306e\u521d\u671f\u5316<\/span>\r\n  await<\/span> orm<\/span>.<\/span>getMigrator<\/span>().<\/span>up<\/span>();<\/span> \/\/ \u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30ad\u30fc\u30de\u3092\u4f5c\u6210\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210<\/span>\r\n  \/\/ \u3053\u3053\u307e\u3067\u524d\u56de\u306e\u5185\u5bb9\u3002<\/span>\r\n\r\n  const<\/span> app<\/span> =<\/span> express<\/span>();<\/span> \/\/ API\u30b5\u30fc\u30d0\u30fc\u3068\u3057\u3066express\u3092\u4f7f\u3046<\/span>\r\n\r\n  const<\/span> apolloServer<\/span> =<\/span> new<\/span> ApolloServer<\/span>({<\/span>\r\n    schema<\/span>:<\/span> await<\/span> buildSchema<\/span>({<\/span> \r\n    \/\/ \u3053\u3053\u3067GraphQL\u306e\u30b9\u30ad\u30fc\u30de\u3092\u5b9a\u7fa9\u3059\u308b<\/span>\r\n    }),<\/span>\r\n  });<\/span>\r\n\r\n  apolloServer<\/span>.<\/span>applyMiddleware<\/span>({<\/span> app<\/span> });<\/span> \/\/ ApolloServer\u3092express\u306e\u30df\u30c9\u30eb\u30a6\u30a7\u30a2\u3068\u3057\u3066\u4f7f\u3046\u3002<\/span>\r\n\r\n  app<\/span>.<\/span>listen<\/span>(<\/span>4000<\/span>,<\/span> ()<\/span> =><\/span> {<\/span>\r\n    console<\/span>.<\/span>log<\/span>(<\/span>\"<\/span>server started on localhost:4000<\/span>\"<\/span>);<\/span>\r\n  });<\/span>\r\n};<\/span>\r\n\r\nmain<\/span>()<\/span>\r\n<\/code><\/pre>\n
            \u8bbe\u7f6eresolver\u7684\u914d\u7f6e<\/h3>\n
            \u6b63\u5982\u4e0a\u6587\u6240\u793a\uff0cApolloServer\u5728\u63a5\u6536\u5230\u5ba2\u6237\u7aef\u8bf7\u6c42\u540e\uff0c\u9700\u8981\u8bbe\u7f6e\u89e3\u6790\u5668\u624d\u80fd\u4f7f\u7528GraphQL API\u6267\u884c\u5bf9PQSL\u8868\u7684SQL\u67e5\u8be2\u3002<\/p>\n
            \u8bbe\u7f6econtext\u5c5e\u6027<\/h4>\n
            \u9996\u5148\uff0c\u6211\u4eec\u8bbe\u7f6econtext\u5c5e\u6027\u3002
            \n\u5728context\u5c5e\u6027\u4e2d\uff0c\u6211\u4eec\u6307\u5b9a\u4e00\u4e2a\u51fd\u6570\uff0c\u8be5\u51fd\u6570\u7684\u8fd4\u56de\u503c\u53ef\u4ee5\u662f\u4e00\u4e2a\u5bf9\u8c61\u3002
            \n\u8be5\u5bf9\u8c61\uff08\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\u4e3a{em: orm.em}\uff09\u53ef\u4ee5\u5728\u6240\u6709\u89e3\u6790\u5668\u4e2d\u5171\u4eab\u3002
            \n\u901a\u8fc7\u8fd9\u4e00\u70b9\uff0c\u6211\u4eec\u53ef\u4ee5\u5728\u89e3\u6790\u5668\u4e2d\u4f7f\u7528MicroORM\u7684\u65b9\u6cd5\uff0c\u5b9e\u73b0\u901a\u8fc7TypeScript\u4e0ePSQL\u8868\u8fdb\u884c\u6570\u636e\u4ea4\u4e92\u3002<\/p>\n
            const<\/span> main<\/span> =<\/span> async<\/span> ()<\/span> =><\/span> {<\/span>\r\n  const<\/span> orm<\/span> =<\/span> await<\/span> MikroORM<\/span>.<\/span>init<\/span>(<\/span>microConfig<\/span>);<\/span> \/\/ MikroORM\u306e\u521d\u671f\u5316<\/span>\r\n  ...<\/span>\r\n\r\n  const<\/span> apolloServer<\/span> =<\/span> new<\/span> ApolloServer<\/span>({<\/span>\r\n    schema<\/span>:<\/span> await<\/span> buildSchema<\/span>({<\/span>\r\n      resolvers<\/span>:<\/span> [<\/span>PostResolver<\/span>],<\/span> \/\/ resolver\u3092\u5b9a\u7fa9\u3002\u4e00\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u4e00\u3064\u306eresolver\u304c\u5bfe\u5fdc\u3059\u308b\u3002<\/span>\r\n      context<\/span>:<\/span> ()<\/span> =><\/span> ({<\/span> em<\/span>:<\/span> orm<\/span>.<\/span>em<\/span> }),<\/span> \/\/ context\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/span>\r\n    }),<\/span>\r\n  });<\/span>\r\n\r\n...<\/span>\r\n<\/code><\/pre>\n
            \u5199\u4e00\u4e2a\u89e3\u6790\u5668\u7684\u63cf\u8ff0<\/h4>\n
            \u8fd9\u91cc\u975e\u5e38\u91cd\u8981\u3002\u6211\u8bfb\u4e86\u597d\u51e0\u6b21\u5b98\u65b9\u6587\u4ef6\uff0c\u4f46\u662f\u7406\u89e3\u8d77\u6765\u82b1\u4e86\u5f88\u957f\u65f6\u95f4\u3002<\/p>\n
            import<\/span> {<\/span> Resolver<\/span>,<\/span> Query<\/span>,<\/span> Ctx<\/span>,<\/span> Arg<\/span>,<\/span> Mutation<\/span> }<\/span> from<\/span> \"<\/span>type-graphql<\/span>\"<\/span>;<\/span>\r\nimport<\/span> {<\/span> Post<\/span> }<\/span> from<\/span> \"<\/span>..\/entities\/Post<\/span>\"<\/span>;<\/span>\r\nimport<\/span> {<\/span> MyContext<\/span> }<\/span> from<\/span> \"<\/span>..\/types<\/span>\"<\/span>;<\/span>\r\n\r\n@<\/span>Resolver<\/span>()<\/span>\r\nexport<\/span> class<\/span> PostResolver<\/span> {<\/span>\r\n  @<\/span>Query<\/span>(()<\/span> =><\/span> [<\/span>Post<\/span>])<\/span>\r\n  posts<\/span>(@<\/span>Ctx<\/span>()<\/span> {<\/span> em<\/span> }:<\/span> MyContext<\/span>):<\/span> Promise<\/span><<\/span>Post<\/span>[]<\/span>><\/span> {<\/span>\r\n    return<\/span> em<\/span>.<\/span>find<\/span>(<\/span>Post<\/span>,<\/span> {});<\/span>\r\n  }<\/span>\r\n...<\/span>\r\n<\/code><\/pre>\n
            import<\/span> {<\/span> EntityManager<\/span>,<\/span> IDatabaseDriver<\/span>,<\/span> Connection<\/span> }<\/span> from<\/span> \"<\/span>@mikro-orm\/core<\/span>\"<\/span>;<\/span>\r\n\r\nexport<\/span> type<\/span> MyContext<\/span> {<\/span>\r\n  em<\/span>:<\/span> EntityManager<\/span><<\/span>any<\/span>><\/span> &<\/span> EntityManager<\/span><<\/span>IDatabaseDriver<\/span><<\/span>Connection<\/span>>><\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
            \u5728\u88c5\u9970\u5668\u7684\u76db\u5927\u5c55\u793a\u4e2d\uff0c\u5bf9\u4e8e\u521d\u5b66\u8005\u6765\u8bf4\u76f8\u5f53\u56f0\u96be\u3002
            \n\u9996\u5148\uff0c\u5982\u679c\u8981\u68b3\u7406\u8fd9\u91cc\u89e3\u51b3\u5668\u7684\u4f5c\u7528\uff0c<\/p>\n
              \n
            • \n
                1) \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u304a\u3088\u3073\u305d\u308c\u306b\u5fdc\u3058\u308b\u30ec\u30b9\u30dd\u30f3\u30b9\u3092\u3001GraphQL\u306eAPI\u3067\u5b9a\u7fa9<\/ul>\n<\/li>\n<\/ul>\n
                 <\/p>\n
                  2) \u30ea\u30af\u30a8\u30b9\u30c8\u306b\u5fdc\u3058\u3066PSQL\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066SQL\u30af\u30a8\u30ea\u3092\u5b9f\u884c<\/ul>\n
                  \u6240\u4ee5\uff0c\u91cd\u65b0\u67e5\u770b\u4ee3\u7801\u540e\uff0c\u6211\u4eec\u53ef\u4ee5\u786e\u8ba4\u4e0a\u8ff01\uff09\u548c2\uff09\u5df2\u7ecf\u5b9e\u73b0\u4e86\u3002<\/p>\n
                  @<\/span>Resolver<\/span>()<\/span> \/\/ \u2460<\/span>\r\nexport<\/span> class<\/span> PostResolver<\/span> {<\/span>\r\n  @<\/span>Query<\/span>(()<\/span> =><\/span> [<\/span>Post<\/span>])<\/span> \/\/ \u2461<\/span>\r\n  posts<\/span>(@<\/span>Ctx<\/span>()<\/span> {<\/span> em<\/span> }:<\/span> MyContext<\/span>):<\/span> Promise<\/span><<\/span>Post<\/span>[]<\/span>><\/span> {<\/span> \/\/ \u2462<\/span>\r\n    return<\/span> em<\/span>.<\/span>find<\/span>(<\/span>Post<\/span>,<\/span> {});<\/span>\r\n  }<\/span>\r\n...<\/span>\r\n<\/code><\/pre>\n
                  \u2460 \u6700\u521d\u7684@Resolver\u662f\u4e00\u4e2a\u7c7b\u88c5\u9970\u5668\uff0c\u5b83\u8868\u660e\u8fd9\u4e2a\u7c7b\u662f\u4e00\u4e2aresolver\u3002
                  \n\u2461 @Query(() => [Post])\u662f\u4e00\u4e2a\u65b9\u6cd5\u88c5\u9970\u5668\uff0c\u5b83\u6307\u793aGraphQL\u6a21\u5f0f\u4e2d\u8fd4\u56de\u503c\u7684\u7c7b\u578b\u3002
                  \n\u5728GraphQL\u4e2d\uff0c\u8bf7\u6c42\u6709Query(Get)\u548cMutaiton(Get\u4ee5\u5916)\u4e24\u79cd\u7c7b\u578b\uff0c\u6240\u4ee5@Query\u8868\u793a\u8fd9\u662f\u4e00\u4e2a(Get\u8bf7\u6c42)\u3002\u53e6\u5916\uff0cGraphQL\u9700\u8981\u4e25\u683c\u5b9a\u4e49\u8bf7\u6c42\u7684\u8fd4\u56de\u503c\u7c7b\u578b\uff0c\u5728\u8fd9\u91cc\u6211\u4eec\u6307\u793a\u8fd4\u56de\u503c\u662f\u4e00\u4e2a\u5e16\u5b50\u7c7b\u578b\u7684\u6570\u7ec4\u3002\uff08\u5728\u8fd9\u91cc\uff0c\u6211\u4eec\u9700\u8981\u5728GraphQL\u6a21\u5f0f\u4e2d\u5355\u72ec\u5b9a\u4e49\u5e16\u5b50\u7c7b\u578b\uff0c\u53e6\u884c\u8bf4\u660e\uff09
                  \n\u2462 \u6211\u4eec\u5b9a\u4e49\u4e86\u4e00\u4e2a\u540d\u4e3aposts\u7684\u65b9\u6cd5\u3002\u5f53\u5728PostResolver\u4e2d\u6307\u5b9aposts\u67e5\u8be2\u65f6\uff0c\u8be5\u65b9\u6cd5\u4f1a\u8fd4\u56deem.find(Post,{})\uff0c\u4e5f\u5c31\u662f\u8fd4\u56dePost\u8868\u4e2d\u7684\u6240\u6709\u5143\u7d20\u3002\u8be5\u65b9\u6cd5\u7684\u8fd4\u56de\u503c\u7531TypeScript\u89c4\u5b9a\u4e3aPromise<Post[]>\uff0c\u770b\u8d77\u6765\u4e0e\u2461\u91cd\u590d\uff0c\u4f46\u662f\u2461\u8868\u793aGraphQL\u6a21\u5f0f\uff0c\u2462\u8868\u793aTypeScript\u7c7b\u578b\uff0c\u4e24\u8005\u90fd\u9700\u8981\u8fdb\u884c\u5b9a\u4e49\u3002\u53e6\u5916\uff0c@Ctx()\u662f\u4e00\u4e2a\u5c5e\u6027\u88c5\u9970\u5668\uff0c\u5b83\u53ef\u4ee5\u5f15\u7528\u524d\u9762\u63d0\u5230\u7684context\u5c5e\u6027\u5e76\u4f7f\u7528\u5b83\uff0c\u4ece\u800c\u53ef\u4ee5\u4f7f\u7528MikroORM\u7684em.find\u65b9\u6cd5\u3002\u540c\u65f6\uff0c\u6211\u4eec\u660e\u786e\u4e86\u8fd4\u56de\u503c\u7c7b\u578b\u4e3aMyContext\u3002<\/p>\n
                  \u4f60\u89c9\u5f97\u600e\u4e48\u6837\uff1f\u8fd9\u662f\u4e0d\u662f\u76f8\u5f53\u56f0\u96be\uff1f\u4e00\u65e6\u719f\u6089\u4e86\u5c31\u4f1a\u5f88\u7b80\u5355\u5417\uff1f
                  \n\u7279\u522b\u662f\uff0c\u5728Post\u4e2d\u4f7f\u7528\u4e86”TypeScript\u7684\u7c7b\u578b”\u548c”GraphQL\u7684\u67b6\u6784\u7c7b\u578b”\u8fd9\u4e24\u4e2a\u610f\u601d\uff0c\u5bb9\u6613\u5f15\u8d77\u6df7\u6dc6\uff0c\u6211\u60f3\u63a5\u4e0b\u6765\u89e3\u91ca\u4e00\u4e0b\u8fd9\u4e2a\u95ee\u9898\u3002<\/p>\n
                  \u5728\u5b9e\u4f53\uff08\u8868\uff09\u4e2d\u6dfb\u52a0GraphQL\u6a21\u5f0f\u7684\u7c7b\u578b<\/h3>\n
                  \"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/div>\n
                  import<\/span> {<\/span> Entity<\/span>,<\/span> PrimaryKey<\/span>,<\/span> Property<\/span> }<\/span> from<\/span> \"<\/span>@mikro-orm\/core<\/span>\"<\/span>;<\/span>\r\n\r\n@<\/span>Entity<\/span>()<\/span>\r\nexport<\/span> class<\/span> Post<\/span> {<\/span>\r\n  @<\/span>PrimaryKey<\/span>()<\/span>\r\n  id<\/span>!<\/span>:<\/span> number<\/span>;<\/span>\r\n\r\n  @<\/span>Property<\/span>({<\/span> type<\/span>:<\/span> \"<\/span>date<\/span>\"<\/span> })<\/span>\r\n  createdAt<\/span> =<\/span> new<\/span> Date<\/span>();<\/span>\r\n\r\n  @<\/span>Property<\/span>({<\/span> type<\/span>:<\/span> \"<\/span>date<\/span>\"<\/span>,<\/span> onUpdate<\/span>:<\/span> ()<\/span> =><\/span> new<\/span> Date<\/span>()<\/span> })<\/span>\r\n  updatedAt<\/span> =<\/span> new<\/span> Date<\/span>();<\/span>\r\n\r\n  @<\/span>Property<\/span>({<\/span> type<\/span>:<\/span> \"<\/span>text<\/span>\"<\/span> })<\/span>\r\n  title<\/span>!<\/span>:<\/span> string<\/span>;<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
                  \u56e0\u6b64\uff0c\u5728entities\/Post.ts\u6587\u4ef6\u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528\u4ecetype-graphql\u5bfc\u5165\u7684\u88c5\u9970\u5668\uff0c\u5e76\u8fdb\u884c\u4ee5\u4e0b\u8ffd\u52a0\uff1a<\/p>\n
                  import<\/span> {<\/span> Entity<\/span>,<\/span> PrimaryKey<\/span>,<\/span> Property<\/span> }<\/span> from<\/span> \"<\/span>@mikro-orm\/core<\/span>\"<\/span>;<\/span>\r\nimport<\/span> {<\/span> ObjectType<\/span>,<\/span> Field<\/span> }<\/span> from<\/span> \"<\/span>type-graphql<\/span>\"<\/span>;<\/span>\r\n\r\n@<\/span>ObjectType<\/span>()<\/span> \/\/ GraphQL\u306e\u30b9\u30ad\u30fc\u30de\u306e\u578b\u3068\u3057\u3066\u5b9a\u7fa9\u3059\u308b\u3002\u3053\u308c\u3067Post\u30af\u30e9\u30b9\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30ad\u30fc\u30de\u30fbTypScript\u306e\u578b\u30fbGraphQL\u306e\u578b\u3092\u517c\u306d\u308b\u3002<\/span>\r\n@<\/span>Entity<\/span>()<\/span>\r\nexport<\/span> class<\/span> Post<\/span> {<\/span>\r\n  @<\/span>Field<\/span>()<\/span> \/\/ API\u30ec\u30b9\u30dd\u30f3\u30b9\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b\u305f\u3081\u306b\u306f\u3001GraphQL\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u3067\u3042\u308b\u3053\u3068\u3092\u660e\u793a\u3059\u308b\u3002<\/span>\r\n  @<\/span>PrimaryKey<\/span>()<\/span>\r\n  id<\/span>!<\/span>:<\/span> number<\/span>;<\/span>\r\n\r\n  @<\/span>Field<\/span>(()<\/span> =><\/span> String<\/span>)<\/span> \/\/ GraphQL\u306bDate\u3068\u3044\u3046\u578b\u306f\u306a\u3044\u306e\u3067\u3001String\u3067\u3042\u308b\u3053\u3068\u3092\u660e\u793a\u3059\u308b<\/span>\r\n  @<\/span>Property<\/span>({<\/span> type<\/span>:<\/span> \"<\/span>date<\/span>\"<\/span> })<\/span>\r\n  createdAt<\/span> =<\/span> new<\/span> Date<\/span>();<\/span>\r\n\r\n  @<\/span>Field<\/span>(()<\/span> =><\/span> String<\/span>)<\/span>\r\n  @<\/span>Property<\/span>({<\/span> type<\/span>:<\/span> \"<\/span>date<\/span>\"<\/span>,<\/span> onUpdate<\/span>:<\/span> ()<\/span> =><\/span> new<\/span> Date<\/span>()<\/span> })<\/span>\r\n  updatedAt<\/span> =<\/span> new<\/span> Date<\/span>();<\/span>\r\n\r\n  @<\/span>Field<\/span>()<\/span>\r\n  @<\/span>Property<\/span>({<\/span> type<\/span>:<\/span> \"<\/span>text<\/span>\"<\/span> })<\/span>\r\n  title<\/span>!<\/span>:<\/span> string<\/span>;<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
                  \"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/div>\n
                  \u901a\u8fc7\u4f7f\u7528MikroORM\u548cTypeGraphQL\u6765\u5b9e\u73b0GraphQL Mutation\u3002<\/h1>\n
                  \u63a5\u4e0b\u6765\u6211\u5c06\u4ecb\u7ecdGraphQL\u7684Mutation\uff08\u5373Get\u4ee5\u5916\u7684RestAPI\uff09\u3002\u7136\u800c\uff0c\u4e0e\u524d\u9762\u7684Query\u6ca1\u6709\u592a\u5927\u7684\u533a\u522b\u3002
                  \n\u4e0e\u4e4b\u524d\u4e00\u6837\uff0c\u6211\u4eec\u901a\u8fc7\u4f7f\u7528\u540d\u4e3aMutation()\u7684\u65b9\u6cd5\u88c5\u9970\u5668\u6765\u5b9a\u4e49Mutation\u3002
                  \n\u7531\u4e8e\u8fd9\u662f\u4e00\u4e2aMutation\uff0c\u6240\u4ee5\u8bf7\u6c42\u4e2d\u9700\u8981\u8f93\u5165\u503c\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528@Arg()\u5c5e\u6027\u88c5\u9970\u5668\u6765\u5b9a\u4e49\u5b83\u3002<\/p>\n
                  import<\/span> {<\/span> Resolver<\/span>,<\/span> Query<\/span>,<\/span> Ctx<\/span>,<\/span> Arg<\/span>,<\/span> Mutation<\/span> }<\/span> from<\/span> \"<\/span>type-graphql<\/span>\"<\/span>;<\/span>\r\nimport<\/span> {<\/span> Post<\/span> }<\/span> from<\/span> \"<\/span>..\/entities\/Post<\/span>\"<\/span>;<\/span>\r\nimport<\/span> {<\/span> MyContext<\/span> }<\/span> from<\/span> \"<\/span>..\/types<\/span>\"<\/span>;<\/span>\r\n\r\n@<\/span>Resolver<\/span>()<\/span>\r\nexport<\/span> class<\/span> PostResolver<\/span> {<\/span>\r\n...<\/span>\r\n  @<\/span>Mutation<\/span>(()<\/span> =><\/span> Post<\/span>,<\/span> {<\/span> nullable<\/span>:<\/span> true<\/span> })<\/span> \/\/ \u2460<\/span>\r\n  async<\/span> updatePost<\/span>(<\/span>\r\n    @<\/span>Arg<\/span>(<\/span>\"<\/span>id<\/span>\"<\/span>)<\/span> id<\/span>:<\/span> number<\/span>,<\/span> \r\n    @<\/span>Arg<\/span>(<\/span>\"<\/span>title<\/span>\"<\/span>,<\/span> ()<\/span> =><\/span> String<\/span>,<\/span> {<\/span> nullable<\/span>:<\/span> true<\/span> })<\/span> title<\/span>:<\/span> string<\/span>,<\/span> \/\/ \u2461<\/span>\r\n    @<\/span>Ctx<\/span>()<\/span> {<\/span> em<\/span> }:<\/span> MyContext<\/span> \/\/ \u2462<\/span>\r\n  ):<\/span> Promise<\/span><<\/span>Post<\/span> |<\/span> null<\/span>><\/span> {<\/span>\r\n    const<\/span> post<\/span> =<\/span> await<\/span> em<\/span>.<\/span>findOne<\/span>(<\/span>Post<\/span>,<\/span> {<\/span> id<\/span> });<\/span> \/\/ \u2462<\/span>\r\n    if<\/span> (<\/span>!<\/span>post<\/span>)<\/span> {<\/span>\r\n      return<\/span> null<\/span>;<\/span>\r\n    }<\/span>\r\n    if<\/span> (<\/span>typeof<\/span> title<\/span> !==<\/span> \"<\/span>undefined<\/span>\"<\/span>)<\/span> {<\/span>\r\n      post<\/span>.<\/span>title<\/span> =<\/span> title<\/span>;<\/span>\r\n      await<\/span> em<\/span>.<\/span>persistAndFlush<\/span>(<\/span>post<\/span>);<\/span>\r\n    }<\/span>\r\n    return<\/span> post<\/span>;<\/span>\r\n  }<\/span>\r\n...<\/span>\r\n<\/code><\/pre>\n
                  \u2460 @Mutation(() => Post, { nullable: true })\u662f\u4e00\u4e2a\u65b9\u6cd5\u88c5\u9970\u5668\uff0c\u7528\u4e8e\u6307\u793aGraphQL\u6a21\u5f0f\u4e2d\u8fd4\u56de\u503c\u7684\u7c7b\u578b\u3002\u5728GraphQL\u4e2d\uff0c\u6709\u67e5\u8be2\uff08Get\uff09\u548c\u53d8\u66f4\uff08Get\u4ee5\u5916\uff09\u4e24\u79cd\u8bf7\u6c42\uff0c\u6240\u4ee5@Mutation\u8868\u793a\u5b83\u662f\u4e00\u4e2a\u4e0d\u540c\u4e8e\u83b7\u53d6\u8bf7\u6c42\u7684\u53d8\u66f4\u8bf7\u6c42\uff08\u76f8\u5f53\u4e8eRestAPI\u4e2d\u7684Get\u8bf7\u6c42\u4ee5\u5916\u7684\u8bf7\u6c42\uff09\u3002\u6b64\u5916\uff0cGraphQL\u9700\u8981\u4e25\u683c\u89c4\u5b9a\u8bf7\u6c42\u7684\u8fd4\u56de\u503c\u7c7b\u578b\uff0c\u5728\u8fd9\u91cc\u6211\u4eec\u6307\u5b9a\u8fd4\u56de\u503c\u4e3aPost\u7c7b\u578b\u3002type-graphql\u7684\u6a21\u5f0f\u9ed8\u8ba4\u4e0d\u5141\u8bb8\u4e3a\u7a7a\uff0c\u6240\u4ee5\u5982\u679c\u53ef\u80fd\u8fd4\u56de\u7a7a\u503c\u7684\u8bdd\u9700\u8981\u6307\u5b9a{ nullable: true }\u3002<\/p>\n
                  \u2461 \u4f7f\u7528@Arg(“title”, () => String, { nullable: true })\u5c5e\u6027\u88c5\u9970\u5668\uff0c\u7528\u4e8e\u89c4\u5b9aGraphQL\u7684Mutaion\uff08\u6216Query\uff09\u7684\u8f93\u5165\u503c\u3002TypeScript\u7684\u7c7b\u578b\u548cGraphQL\u7684\u7c7b\u578b\u4e0d\u4e00\u5b9a\u76f8\u5339\u914d\uff0c\u5982\u679c\u4e0d\u5339\u914d\u7684\u8bdd\u9700\u8981\u8fdb\u884c\u660e\u786e\u8bf4\u660e\uff0c\u4f8b\u5982() => String\u3002\uff08\u4f46\u5728\u8fd9\u91cc\u4e24\u8005\u90fd\u662fString\u7c7b\u578b\uff0c\u6240\u4ee5\u4e0d\u9700\u8981\u8fd9\u6837\u505a\u3002\uff09\u7136\u800c\uff0c\u9ed8\u8ba4\u8bbe\u7f6e\u4e0d\u5141\u8bb8\u4e3a\u7a7a\uff0c\u6240\u4ee5\u5982\u679c\u53ef\u80fd\u4e3a\u7a7a\u503c\u7684\u8bdd\uff0c\u9700\u8981\u6307\u5b9a{ nullable: true }\u3002\u53e6\u5916\uff0c@Arg(“title”\u4e2d\u7684title\u662f\u7528\u4e8eGraphQL\u6a21\u5f0f\u4e2d\u7684\u8f93\u5165\u503c\u7684\u540d\u79f0\uff0c\u53ef\u4ee5\u4e0eTypeScript\u4e2d\u7684\u53c2\u6570\u540d\u79f0\u533a\u5206\u5f00\u6765\u3002<\/p>\n
                  \u2462 \u4f7f\u7528@Ctx() { em }: MyContext\u5c5e\u6027\u88c5\u9970\u5668\uff0c\u53ef\u4ee5\u5f15\u7528\u5e76\u4f7f\u7528\u5728src\/index.ts\u4e2d\u5b9a\u4e49\u7684context\u5c5e\u6027\uff0c\u901a\u8fc7\u8fd9\u6837\u7684\u65b9\u5f0f\u53ef\u4ee5\u4f7f\u7528em.findOne\u8fd9\u4e2aMikroORM\u7684\u65b9\u6cd5\u3002\u540c\u65f6\uff0c\u660e\u786e\u6307\u5b9a\u4e86\u8fd4\u56de\u503c\u7684\u7c7b\u578b\u4e3aMyContext\u3002<\/p>\n
                  \u6700\u5f8c, \u7ec8\u7a76<\/h1>\n
                  \u8fd9\u6b21\u6211\u4eec\u628aMikroORM TypeGraphQL Crud\u5199\u5b8c\u4e86\u3002
                  \n\u5982\u679c\u80fd\u591f\u5b9e\u73b0\u4e0a\u8ff0\u6240\u63cf\u8ff0\u7684Query\u548cMutation\uff0c\u5c31\u53ef\u4ee5\u5b9e\u73b0CRUD\u3002<\/p>\n
                  \u572814\u5c0f\u65f6\u7684\u6559\u7a0b\u4e2d\uff0c\u6211\u5df2\u7ecf\u5b66\u4e60\u4e86\u5dee\u4e0d\u591a\u4e00\u4e2a\u5c0f\u65f6\u3002
                  \n\u524d\u65b9\u8fd8\u6709\u5f88\u957f\u7684\u8def\u8981\u8d70…<\/p>\n
                  \u4e0b\u4e00\u6b21 => https:\/\/qiita.com\/theFirstPenguin\/items\/6dde647c01dad4e96e22<\/p>\n","protected":false},"excerpt":{"rendered":"
                  \u9996\u5148 \u6211\u662fYN\uff0c\u4e00\u4e2a\u4ece30\u4ee3\u6ca1\u6709\u7ecf\u9a8c\u5f00\u59cb\u5b66\u4e60\u6210\u4e3a\u5de5\u7a0b\u5e08\u7684\u4eba\u3002\u8fd9\u7bc7\u6587\u7ae0\u662f\u5173\u4e8eBen Awad\u5148\u751f\u7684\u300aFullst […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-47661","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684-fullstack-react-graphql-typescript-\u6559\u7a0b2\uff5e\u4f7f\u7528-mikroorm-\u548c-typegraphql-\u7ed3\u5408\u8fdb\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u6211\u662fYN\uff0c\u4e00\u4e2a\u4ece30\u4ee3\u6ca1\u6709\u7ecf\u9a8c\u5f00\u59cb\u5b66\u4e60\u6210\u4e3a\u5de5\u7a0b\u5e08\u7684\u4eba\u3002\u8fd9\u7bc7\u6587\u7ae0\u662f\u5173\u4e8eBen Awad\u5148\u751f\u7684\u300aFullst […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684-fullstack-react-graphql-typescript-\u6559\u7a0b2\uff5e\u4f7f\u7528-mikroorm-\u548c-typegraphql-\u7ed3\u5408\u8fdb\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-02T06:54:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-30T03:54:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8036913a08637a6a9289\/13-0.png\" \/>\n<meta name=\"author\" content=\"\u79d1, \u96c5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u96c5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/\",\"name\":\"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-02T06:54:02+00:00\",\"dateModified\":\"2024-04-30T03:54:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a\",\"name\":\"\u79d1, \u96c5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u96c5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684-fullstack-react-graphql-typescript-\u6559\u7a0b2\uff5e\u4f7f\u7528-mikroorm-\u548c-typegraphql-\u7ed3\u5408\u8fdb\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e","og_description":"\u9996\u5148 \u6211\u662fYN\uff0c\u4e00\u4e2a\u4ece30\u4ee3\u6ca1\u6709\u7ecf\u9a8c\u5f00\u59cb\u5b66\u4e60\u6210\u4e3a\u5de5\u7a0b\u5e08\u7684\u4eba\u3002\u8fd9\u7bc7\u6587\u7ae0\u662f\u5173\u4e8eBen Awad\u5148\u751f\u7684\u300aFullst […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684-fullstack-react-graphql-typescript-\u6559\u7a0b2\uff5e\u4f7f\u7528-mikroorm-\u548c-typegraphql-\u7ed3\u5408\u8fdb\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-02T06:54:02+00:00","article_modified_time":"2024-04-30T03:54:05+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8036913a08637a6a9289\/13-0.png"}],"author":"\u79d1, \u96c5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u96c5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/","name":"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-02T06:54:02+00:00","dateModified":"2024-04-30T03:54:05+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c1d\u8bd5\u505a\u5b8c\u6574\u7684 Fullstack React GraphQL TypeScript \u6559\u7a0b#2\uff5e\u4f7f\u7528 MikroORM \u548c TypeGraphQL \u7ed3\u5408\u8fdb\u884c PostgreSQL CRUD \u5b9e\u73b0\uff5e"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/41e222757cdd2a3365361328bd79970a","name":"\u79d1, \u96c5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1b2d3e00a7df03689797ebd4af8c5827ba5af936849a71050ec331f4cf902c5d?s=96&d=mm&r=g","caption":"\u79d1, \u96c5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keya\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%81%9a%e5%ae%8c%e6%95%b4%e7%9a%84-fullstack-react-graphql-typescript-%e6%95%99%e7%a8%8b2%ef%bd%9e%e4%bd%bf%e7%94%a8-mikroorm-%e5%92%8c-typegraphql-%e7%bb%93%e5%90%88%e8%bf%9b\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/47661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=47661"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/47661\/revisions"}],"predecessor-version":[{"id":91756,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/47661\/revisions\/91756"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=47661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=47661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=47661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}