{"id":48053,"date":"2023-02-08T04:31:15","date_gmt":"2024-02-09T03:55:33","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/"},"modified":"2024-04-29T13:37:18","modified_gmt":"2024-04-29T05:37:18","slug":"%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/","title":{"rendered":"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL"},"content":{"rendered":"<p>\u7528Rust\u6765\u6784\u5efaGraphQL API\u8fdb\u884c\u4e86\u4e00\u9879\u7b80\u8981\u8c03\u67e5\u7684\u7b14\u8bb0\u3002<\/p>\n<h1>\u73af\u5883<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Rust: 1.39<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Juniper: 0.14.1<\/ul>\n<\/li>\n<\/ul>\n<p>graphql-rust\/juniper: GraphQL server library for Rust<\/p>\n<p>PostgreSQL: 11<br \/>\nhttps:\/\/github.com\/yagince\/graphql-sample-rs<\/p>\n<pre class=\"post-pre\"><code><span class=\"nn\">[package]<\/span>\r\n<span class=\"py\">name<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"graphql_example\"<\/span>\r\n<span class=\"py\">version<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.0.1\"<\/span>\r\n<span class=\"py\">authors<\/span> <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"s\">\"yagince &lt;straitwalk@gmail.com&gt;\"<\/span><span class=\"p\">]<\/span>\r\n<span class=\"py\">edition<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"2018\"<\/span>\r\n\r\n<span class=\"nn\">[dependencies]<\/span>\r\n<span class=\"py\">actix-web<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"1.0.9\"<\/span>\r\n<span class=\"py\">actix-cors<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.1.0\"<\/span>\r\n<span class=\"py\">juniper<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.14.1\"<\/span>\r\n<span class=\"py\">juniper-from-schema<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.5.1\"<\/span>\r\n<span class=\"py\">juniper-eager-loading<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.5.0\"<\/span>\r\n<span class=\"nn\">diesel<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span> <span class=\"py\">version<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"1.4.3\"<\/span><span class=\"p\">,<\/span> <span class=\"py\">features<\/span> <span class=\"p\">=<\/span> <span class=\"p\">[<\/span><span class=\"s\">\"postgres\"<\/span><span class=\"p\">,<\/span> <span class=\"s\">\"r2d2\"<\/span><span class=\"p\">]<\/span> <span class=\"p\">}<\/span>\r\n<span class=\"py\">r2d2<\/span> <span class=\"p\">=<\/span> <span class=\"s\">\"0.8.7\"<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"na\">version<\/span><span class=\"pi\">:<\/span> <span class=\"s1\">'<\/span><span class=\"s\">3.1'<\/span>\r\n\r\n<span class=\"na\">services<\/span><span class=\"pi\">:<\/span>\r\n  <span class=\"na\">postgres<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">container_name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgres<\/span>\r\n    <span class=\"na\">image<\/span><span class=\"pi\">:<\/span> <span class=\"s\">postgres:11<\/span>\r\n    <span class=\"na\">restart<\/span><span class=\"pi\">:<\/span> <span class=\"s\">always<\/span>\r\n    <span class=\"na\">environment<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"na\">POSTGRES_DB<\/span><span class=\"pi\">:<\/span> <span class=\"s\">app<\/span>\r\n      <span class=\"na\">POSTGRES_USER<\/span><span class=\"pi\">:<\/span> <span class=\"s\">dbuser<\/span>\r\n      <span class=\"na\">POSTGRES_PASSWORD<\/span><span class=\"pi\">:<\/span> <span class=\"s\">password<\/span>\r\n    <span class=\"na\">ports<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s2\">\"<\/span><span class=\"s\">5432:5432\"<\/span>\r\n    <span class=\"na\">volumes<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">.\/tmp\/pgdata:\/var\/lib\/postgresql\/data<\/span>\r\n  <span class=\"na\">app<\/span><span class=\"pi\">:<\/span>\r\n    <span class=\"na\">container_name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">app<\/span>\r\n    <span class=\"na\">build<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"na\">context<\/span><span class=\"pi\">:<\/span> <span class=\"s\">.<\/span>\r\n    <span class=\"na\">command<\/span><span class=\"pi\">:<\/span> <span class=\"s\">cargo run<\/span>\r\n    <span class=\"na\">volumes<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">.:\/app<\/span>\r\n    <span class=\"na\">environment<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">DATABASE_URL=postgres:\/\/dbuser:password@postgres:5432\/app<\/span>\r\n    <span class=\"na\">depends_on<\/span><span class=\"pi\">:<\/span>\r\n      <span class=\"pi\">-<\/span> <span class=\"s\">postgres<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">FROM<\/span><span class=\"s\"> rust:1.39.0-stretch<\/span>\r\n\r\n<span class=\"k\">MAINTAINER<\/span><span class=\"s\"> yagince &lt;straitwalk@gmail.com&gt;<\/span>\r\n\r\n<span class=\"k\">RUN <\/span>apt-get <span class=\"nt\">-y<\/span> <span class=\"nt\">-q<\/span> update <span class=\"se\">\\\r\n<\/span>  <span class=\"o\">&amp;&amp;<\/span> apt-get <span class=\"nb\">install<\/span> <span class=\"nt\">-y<\/span> <span class=\"nt\">-q<\/span> <span class=\"se\">\\\r\n<\/span>     libpq-dev <span class=\"se\">\\\r\n<\/span>  <span class=\"o\">&amp;&amp;<\/span> cargo <span class=\"nb\">install <\/span>diesel_cli <span class=\"nt\">--no-default-features<\/span> <span class=\"nt\">--features<\/span> postgres\r\n\r\n<span class=\"k\">ENV<\/span><span class=\"s\"> CARGO_BUILD_TARGET_DIR=\/tmp\/target<\/span>\r\n\r\n<span class=\"k\">RUN <\/span><span class=\"nv\">USER<\/span><span class=\"o\">=<\/span>root cargo new <span class=\"nt\">--bin<\/span> app\r\n<span class=\"k\">WORKDIR<\/span><span class=\"s\"> \/app<\/span>\r\n<span class=\"k\">COPY<\/span><span class=\"s\"> .\/Cargo.* .\/<\/span>\r\n\r\n<span class=\"k\">RUN <\/span>cargo build <span class=\"nt\">--color<\/span> never <span class=\"o\">&amp;&amp;<\/span> <span class=\"se\">\\\r\n<\/span>    <span class=\"nb\">rm <\/span>src\/<span class=\"k\">*<\/span>.rs\r\n<\/code><\/pre>\n<h1>\u8bf7\u63d0\u4f9b\u66f4\u591a\u4e0a\u4e0b\u6587\uff0c\u4ee5\u4fbf\u6211\u80fd\u591f\u66f4\u597d\u5730\u56de\u7b54\u60a8\u7684\u95ee\u9898\u3002<\/h1>\n<p>juniper-from-schema\/juniper-from-schema\u5728davidpdrsn\/juniper-from-schema\u7684\u4e3b\u5206\u652f\u4e0a<br \/>\nhusseinraoouf\/graphql-actix-example: \u4f7f\u7528actix + juniper + diesel\u6784\u5efa\u7684GraphQL API\u7684\u5b8c\u6574\u793a\u4f8b<\/p>\n<p>\u6211\u6240\u60f3\u505a\u7684\u4e8b\u60c5\u57fa\u672c\u4e0a\u5c31\u662f\u8fd9\u6837\u4e86\u3002\u56e0\u4e3a\u6211\u5bf9Juniper\u7684\u5b8f\u4e0d\u592a\u7406\u89e3\uff0c\u6240\u4ee5\u6211\u5b9a\u4e49\u4e86\u4e00\u4e2a\u6a21\u5f0f\u6765\u52a0\u8f7d\u5b8f\uff0c\u7136\u540e\u5c31\u4e0d\u518d\u7528\u5230\u5b8f\u4e86\uff0c\u8fd9\u6837\u5c31\u53d8\u5f97\u5bb9\u6613\u7406\u89e3\u4e86\uff08\u81f3\u5c11\u6211\u611f\u89c9\u662f\u8fd9\u6837\u7684\uff09\u3002<\/p>\n<h1>\u9996\u5148\uff0c\u6211\u5011\u8a66\u8457\u50c5\u8fd4\u56de\u4e00\u500b\u8868\u683c\u7684\u7c21\u55ae\u8cc7\u6599\u3002<\/h1>\n<h2>\u521b\u5efa\u8868\u683c<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">User<\/ul>\n<\/li>\n<\/ul>\n<p>id<br \/>\nname<\/p>\n<p>\u6211\u5c1d\u8bd5\u521b\u5efa\u4e00\u4e2a\u7b80\u5355\u7684\u8868\u683c\u6765\u5b58\u50a8\u7528\u6237\u6570\u636e\uff0c\u6211\u5c06\u4f7f\u7528diesel-rs\/diesel\u7684migration\u5de5\u5177\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>diesel setup\r\nCreating migrations directory at: \/app\/migrations\r\nCreating database: app\r\n\r\n<span class=\"nv\">$ <\/span>diesel migration generate create_users\r\nCreating migrations\/2019-11-27-001836_create_users\/up.sql\r\nCreating migrations\/2019-11-27-001836_create_users\/down.sql\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>CREATE TABLE users (\r\n  id   SERIAL  PRIMARY KEY,\r\n  name VARCHAR NOT NULL\r\n);\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>diesel migration run\r\nRunning migration 2019-11-27-001836_create_users\r\n<\/code><\/pre>\n<h2>\u6211\u8bd5\u7740\u5199API\u3002<\/h2>\n<pre class=\"post-pre\"><code><span class=\"nd\">table!<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nf\">users<\/span> <span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">id<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Int4<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">name<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Varchar<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">use<\/span> <span class=\"nn\">super<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::<\/span><span class=\"n\">users<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"nd\">#[derive(Queryable)]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">User<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">pub<\/span> <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"nb\">i32<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"k\">pub<\/span> <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">#[derive(Insertable)]<\/span>\r\n<span class=\"nd\">#[table_name<\/span> <span class=\"nd\">=<\/span> <span class=\"s\">\"users\"<\/span><span class=\"nd\">]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">NewUser<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">pub<\/span> <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">schema<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">query<\/span><span class=\"p\">:<\/span> <span class=\"n\">Query<\/span>\r\n  <span class=\"n\">mutation<\/span><span class=\"p\">:<\/span> <span class=\"n\">Mutation<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">type<\/span> <span class=\"n\">Query<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">users<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"n\">User<\/span><span class=\"p\">!]!<\/span> <span class=\"err\">@<\/span><span class=\"n\">juniper<\/span><span class=\"p\">(<\/span><span class=\"n\">ownership<\/span><span class=\"p\">:<\/span> <span class=\"err\">\"<\/span><span class=\"n\">owned<\/span><span class=\"err\">\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">type<\/span> <span class=\"n\">Mutation<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">createUser<\/span><span class=\"p\">(<\/span>\r\n    <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">!,<\/span>\r\n  <span class=\"p\">):<\/span> <span class=\"n\">User<\/span><span class=\"p\">!<\/span> <span class=\"err\">@<\/span><span class=\"n\">juniper<\/span><span class=\"p\">(<\/span><span class=\"n\">ownership<\/span><span class=\"p\">:<\/span> <span class=\"err\">\"<\/span><span class=\"n\">owned<\/span><span class=\"err\">\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">type<\/span> <span class=\"n\">User<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"nb\">ID<\/span><span class=\"p\">!<\/span> <span class=\"err\">@<\/span><span class=\"n\">juniper<\/span><span class=\"p\">(<\/span><span class=\"n\">ownership<\/span><span class=\"p\">:<\/span> <span class=\"err\">\"<\/span><span class=\"n\">owned<\/span><span class=\"err\">\"<\/span><span class=\"p\">)<\/span>\r\n  <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">!<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">use<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">convert<\/span><span class=\"p\">::<\/span><span class=\"n\">From<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">sync<\/span><span class=\"p\">::<\/span><span class=\"nb\">Arc<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">actix_web<\/span><span class=\"p\">::{<\/span><span class=\"n\">web<\/span><span class=\"p\">,<\/span> <span class=\"n\">Error<\/span><span class=\"p\">,<\/span> <span class=\"n\">HttpResponse<\/span><span class=\"p\">};<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">futures01<\/span><span class=\"p\">::<\/span><span class=\"nn\">future<\/span><span class=\"p\">::<\/span><span class=\"n\">Future<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"nn\">http<\/span><span class=\"p\">::<\/span><span class=\"nn\">playground<\/span><span class=\"p\">::<\/span><span class=\"n\">playground_source<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">juniper<\/span><span class=\"p\">::{<\/span><span class=\"nn\">http<\/span><span class=\"p\">::<\/span><span class=\"n\">GraphQLRequest<\/span><span class=\"p\">,<\/span> <span class=\"n\">Executor<\/span><span class=\"p\">,<\/span> <span class=\"n\">FieldResult<\/span><span class=\"p\">};<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">juniper_from_schema<\/span><span class=\"p\">::<\/span><span class=\"n\">graphql_schema_from_file<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nn\">prelude<\/span><span class=\"p\">::<\/span><span class=\"o\">*<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">itertools<\/span><span class=\"p\">::<\/span><span class=\"n\">Itertools<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::{<\/span><span class=\"n\">DbCon<\/span><span class=\"p\">,<\/span> <span class=\"n\">DbPool<\/span><span class=\"p\">};<\/span>\r\n\r\n<span class=\"nd\">graphql_schema_from_file!<\/span><span class=\"p\">(<\/span><span class=\"s\">\"src\/schema.graphql\"<\/span><span class=\"p\">);<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Context<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">db_con<\/span><span class=\"p\">:<\/span> <span class=\"n\">DbCon<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n<span class=\"k\">impl<\/span> <span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"n\">Context<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Context<\/span> <span class=\"p\">{}<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Query<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Mutation<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">QueryFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Query<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_users<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">executor<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"n\">trail<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">QueryTrail<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">User<\/span><span class=\"p\">,<\/span> <span class=\"n\">Walked<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::<\/span><span class=\"n\">users<\/span><span class=\"p\">;<\/span>\r\n\r\n        <span class=\"nn\">users<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span>\r\n            <span class=\"py\">.load<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">()<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.and_then<\/span><span class=\"p\">(|<\/span><span class=\"n\">users<\/span><span class=\"p\">|<\/span> <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"n\">users<\/span><span class=\"nf\">.into_iter<\/span><span class=\"p\">()<\/span><span class=\"nf\">.map_into<\/span><span class=\"p\">()<\/span><span class=\"nf\">.collect<\/span><span class=\"p\">()))<\/span>\r\n            <span class=\"nf\">.map_err<\/span><span class=\"p\">(<\/span><span class=\"nn\">Into<\/span><span class=\"p\">::<\/span><span class=\"n\">into<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">MutationFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Mutation<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_create_user<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">executor<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"n\">trail<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">QueryTrail<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">User<\/span><span class=\"p\">,<\/span> <span class=\"n\">Walked<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::<\/span><span class=\"n\">users<\/span><span class=\"p\">;<\/span>\r\n\r\n        <span class=\"k\">let<\/span> <span class=\"n\">new_user<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">NewUser<\/span> <span class=\"p\">{<\/span> <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"n\">name<\/span> <span class=\"p\">};<\/span>\r\n\r\n        <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nf\">insert_into<\/span><span class=\"p\">(<\/span><span class=\"nn\">users<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.values<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">new_user<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"py\">.get_result<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">()<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.map<\/span><span class=\"p\">(<\/span><span class=\"nn\">Into<\/span><span class=\"p\">::<\/span><span class=\"n\">into<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.map_err<\/span><span class=\"p\">(<\/span><span class=\"nn\">Into<\/span><span class=\"p\">::<\/span><span class=\"n\">into<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">User<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"nb\">i32<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">UserFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">User<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_id<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"n\">ID<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"nn\">ID<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"k\">self<\/span><span class=\"py\">.id<\/span><span class=\"nf\">.to_string<\/span><span class=\"p\">()))<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_name<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;&amp;<\/span><span class=\"nb\">String<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"py\">.name<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">From<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span> <span class=\"k\">for<\/span> <span class=\"n\">User<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">from<\/span><span class=\"p\">(<\/span><span class=\"n\">user<\/span><span class=\"p\">:<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Self<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">Self<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"n\">id<\/span><span class=\"p\">:<\/span> <span class=\"n\">user<\/span><span class=\"py\">.id<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"n\">user<\/span><span class=\"py\">.name<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"p\">}<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">fn<\/span> <span class=\"nf\">playground<\/span><span class=\"p\">()<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">HttpResponse<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">html<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">playground_source<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\"<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"nn\">HttpResponse<\/span><span class=\"p\">::<\/span><span class=\"nf\">Ok<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"nf\">.content_type<\/span><span class=\"p\">(<\/span><span class=\"s\">\"text\/html; charset=utf-8\"<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">.body<\/span><span class=\"p\">(<\/span><span class=\"n\">html<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">fn<\/span> <span class=\"nf\">graphql<\/span><span class=\"p\">(<\/span>\r\n    <span class=\"n\">schema<\/span><span class=\"p\">:<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">Data<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">Arc<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Schema<\/span><span class=\"o\">&gt;&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">data<\/span><span class=\"p\">:<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">Json<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">GraphQLRequest<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">db_pool<\/span><span class=\"p\">:<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">Data<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">DbPool<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"k\">impl<\/span> <span class=\"n\">Future<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Item<\/span> <span class=\"o\">=<\/span> <span class=\"n\">HttpResponse<\/span><span class=\"p\">,<\/span> <span class=\"n\">Error<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Error<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">ctx<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Context<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">db_con<\/span><span class=\"p\">:<\/span> <span class=\"n\">db_pool<\/span><span class=\"nf\">.get<\/span><span class=\"p\">()<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">(),<\/span>\r\n    <span class=\"p\">};<\/span>\r\n\r\n    <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"nf\">block<\/span><span class=\"p\">(<\/span><span class=\"k\">move<\/span> <span class=\"p\">||<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">let<\/span> <span class=\"n\">res<\/span> <span class=\"o\">=<\/span> <span class=\"n\">data<\/span><span class=\"nf\">.execute<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">schema<\/span><span class=\"p\">,<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">ctx<\/span><span class=\"p\">);<\/span>\r\n        <span class=\"nn\">Ok<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">_<\/span><span class=\"p\">,<\/span> <span class=\"nn\">serde_json<\/span><span class=\"p\">::<\/span><span class=\"nn\">error<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"nn\">serde_json<\/span><span class=\"p\">::<\/span><span class=\"nf\">to_string<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">res<\/span><span class=\"p\">)<\/span><span class=\"o\">?<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">})<\/span>\r\n    <span class=\"nf\">.map_err<\/span><span class=\"p\">(<\/span><span class=\"nn\">Error<\/span><span class=\"p\">::<\/span><span class=\"n\">from<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"nf\">.and_then<\/span><span class=\"p\">(|<\/span><span class=\"n\">user<\/span><span class=\"p\">|<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"nn\">HttpResponse<\/span><span class=\"p\">::<\/span><span class=\"nf\">Ok<\/span><span class=\"p\">()<\/span>\r\n            <span class=\"nf\">.content_type<\/span><span class=\"p\">(<\/span><span class=\"s\">\"application\/json\"<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.body<\/span><span class=\"p\">(<\/span><span class=\"n\">user<\/span><span class=\"p\">))<\/span>\r\n    <span class=\"p\">})<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">fn<\/span> <span class=\"nf\">register<\/span><span class=\"p\">(<\/span><span class=\"n\">config<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"k\">mut<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">ServiceConfig<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">schema<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">sync<\/span><span class=\"p\">::<\/span><span class=\"nn\">Arc<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"nn\">Schema<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"n\">Query<\/span><span class=\"p\">,<\/span> <span class=\"n\">Mutation<\/span><span class=\"p\">));<\/span>\r\n\r\n    <span class=\"n\">config<\/span>\r\n        <span class=\"nf\">.data<\/span><span class=\"p\">(<\/span><span class=\"n\">schema<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">.route<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\/\"<\/span><span class=\"p\">,<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"nf\">post<\/span><span class=\"p\">()<\/span><span class=\"nf\">.to_async<\/span><span class=\"p\">(<\/span><span class=\"n\">graphql<\/span><span class=\"p\">))<\/span>\r\n        <span class=\"nf\">.route<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\/\"<\/span><span class=\"p\">,<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"nf\">get<\/span><span class=\"p\">()<\/span><span class=\"nf\">.to<\/span><span class=\"p\">(<\/span><span class=\"n\">playground<\/span><span class=\"p\">));<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"nd\">#[macro_use]<\/span>\r\n<span class=\"k\">extern<\/span> <span class=\"n\">crate<\/span> <span class=\"n\">diesel<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">actix_cors<\/span><span class=\"p\">::<\/span><span class=\"n\">Cors<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">actix_web<\/span><span class=\"p\">::{<\/span><span class=\"n\">web<\/span><span class=\"p\">,<\/span> <span class=\"n\">App<\/span><span class=\"p\">,<\/span> <span class=\"n\">HttpServer<\/span><span class=\"p\">};<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">diesel<\/span><span class=\"p\">::{<\/span>\r\n    <span class=\"nn\">prelude<\/span><span class=\"p\">::<\/span><span class=\"o\">*<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"nn\">r2d2<\/span><span class=\"p\">::{<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"n\">ConnectionManager<\/span><span class=\"p\">},<\/span>\r\n<span class=\"p\">};<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">mod<\/span> <span class=\"n\">graphql<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">mod<\/span> <span class=\"n\">models<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">mod<\/span> <span class=\"n\">schema<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">type<\/span> <span class=\"n\">DbPool<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">r2d2<\/span><span class=\"p\">::<\/span><span class=\"n\">Pool<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">ConnectionManager<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">PgConnection<\/span><span class=\"o\">&gt;&gt;<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">type<\/span> <span class=\"n\">DbCon<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">r2d2<\/span><span class=\"p\">::<\/span><span class=\"n\">PooledConnection<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">ConnectionManager<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">PgConnection<\/span><span class=\"o\">&gt;&gt;<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">fn<\/span> <span class=\"nf\">main<\/span><span class=\"p\">()<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">db_pool<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">create_db_pool<\/span><span class=\"p\">();<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">port<\/span><span class=\"p\">:<\/span> <span class=\"nb\">u16<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">env<\/span><span class=\"p\">::<\/span><span class=\"nf\">var<\/span><span class=\"p\">(<\/span><span class=\"s\">\"PORT\"<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">.ok<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"nf\">.and_then<\/span><span class=\"p\">(|<\/span><span class=\"n\">p<\/span><span class=\"p\">|<\/span> <span class=\"n\">p<\/span><span class=\"nf\">.parse<\/span><span class=\"p\">()<\/span><span class=\"nf\">.ok<\/span><span class=\"p\">())<\/span>\r\n        <span class=\"nf\">.unwrap_or<\/span><span class=\"p\">(<\/span><span class=\"mi\">3000<\/span><span class=\"p\">);<\/span>\r\n\r\n    <span class=\"k\">let<\/span> <span class=\"n\">addr<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">net<\/span><span class=\"p\">::<\/span><span class=\"nn\">SocketAddr<\/span><span class=\"p\">::<\/span><span class=\"nf\">from<\/span><span class=\"p\">(([<\/span><span class=\"mi\">0<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">,<\/span> <span class=\"mi\">0<\/span><span class=\"p\">],<\/span> <span class=\"n\">port<\/span><span class=\"p\">));<\/span>\r\n\r\n    <span class=\"nn\">HttpServer<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"k\">move<\/span> <span class=\"p\">||<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nn\">App<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">()<\/span>\r\n            <span class=\"nf\">.data<\/span><span class=\"p\">(<\/span><span class=\"n\">db_pool<\/span><span class=\"nf\">.clone<\/span><span class=\"p\">())<\/span>\r\n            <span class=\"nf\">.wrap<\/span><span class=\"p\">(<\/span><span class=\"nn\">Cors<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">())<\/span>\r\n            <span class=\"nf\">.configure<\/span><span class=\"p\">(<\/span><span class=\"nn\">graphql<\/span><span class=\"p\">::<\/span><span class=\"n\">register<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.default_service<\/span><span class=\"p\">(<\/span><span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"nf\">to<\/span><span class=\"p\">(||<\/span> <span class=\"s\">\"404\"<\/span><span class=\"p\">))<\/span>\r\n    <span class=\"p\">})<\/span>\r\n    <span class=\"nf\">.bind<\/span><span class=\"p\">(<\/span><span class=\"n\">addr<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"nf\">.unwrap<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"nf\">.run<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"nf\">.unwrap<\/span><span class=\"p\">();<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">fn<\/span> <span class=\"nf\">create_db_pool<\/span><span class=\"p\">()<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">DbPool<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">database_url<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">env<\/span><span class=\"p\">::<\/span><span class=\"nf\">var<\/span><span class=\"p\">(<\/span><span class=\"s\">\"DATABASE_URL\"<\/span><span class=\"p\">)<\/span><span class=\"nf\">.expect<\/span><span class=\"p\">(<\/span><span class=\"s\">\"DATABASE_URL must be set\"<\/span><span class=\"p\">);<\/span>\r\n\r\n    <span class=\"nn\">r2d2<\/span><span class=\"p\">::<\/span><span class=\"nn\">Pool<\/span><span class=\"p\">::<\/span><span class=\"nf\">builder<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"nf\">.max_size<\/span><span class=\"p\">(<\/span><span class=\"mi\">3<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">.build<\/span><span class=\"p\">(<\/span><span class=\"nn\">ConnectionManager<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">PgConnection<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"n\">database_url<\/span><span class=\"p\">))<\/span>\r\n        <span class=\"nf\">.expect<\/span><span class=\"p\">(<\/span><span class=\"s\">\"failed to create db connection pool\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u6211\u4f1a\u5148\u8bd5\u8bd5\u901a\u8fc7\u53d8\u5f02(mutations)\u7684\u65b9\u5f0f\u63d2\u5165\u6570\u636e\uff0c\u5c31\u8fd9\u6837\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">mutation<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">createUser<\/span><span class=\"p\">(<\/span><span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge\"<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">query<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">users<\/span><span class=\"p\">{<\/span><span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code>\r\n<span class=\"p\">{<\/span>\r\n  <span class=\"nl\">\"data\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nl\">\"users\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"1\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"test\"<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"2\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"test\"<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"3\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"test\"<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"4\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"test\"<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"5\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge\"<\/span>\r\n      <span class=\"p\">}<\/span>\r\n    <span class=\"p\">]<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u6211\u4ee5\u9002\u5f53\u7684\u65b9\u5f0f\u8f93\u5165\u6570\u636e\uff0c\u5c31\u53d6\u5230\u4e86\u8fd9\u6837\u7684\u6570\u636e\u3002<\/p>\n<h1>\u8bd5\u7740\u6dfb\u52a0\u4e00\u4e2a\u4f7f\u5f97\u5173\u7cfb\u8868\u53d8\u4e3aN\u7684\u9009\u9879\u3002<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u95a2\u9023\u5148\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u307f\u305f\u3044\u306e\u3067, 1:N \u306a\u95a2\u4fc2\u306b\u306a\u308b\u30c6\u30fc\u30d6\u30eb\u3092\u8ffd\u52a0\u3057\u3066\u307f\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>\u3053\u3053\u3067\u6c17\u306b\u306a\u308b\u306e\u306f\u3001\u30b7\u30f3\u30d7\u30eb\u306agraphql\u306e\u5b9f\u88c5\u3060\u3068N+1\u554f\u984c\u306b\u3076\u3064\u304b\u308b\u4e8b\u3067\u3059<br \/>\ndataloader\u7684\u306a\u3082\u306e\u306e\u4f7f\u3044\u65b9\u3092\u8abf\u67fb\u3057\u307e\u3059<\/p>\n<h2>\u684c\u5b50<\/h2>\n<p>\u6211\u4f1a\u50cf\u7ed9\u7528\u6237\u6253\u6807\u7b7e\u4e00\u6837\uff0c\u5c1d\u8bd5\u6dfb\u52a0\u4e00\u4e2a tags \u8868\u683c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nv\">$ <\/span>diesel migration generate create_tags\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">tags<\/span> <span class=\"p\">(<\/span>\r\n  <span class=\"n\">id<\/span>   <span class=\"nb\">SERIAL<\/span>  <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"n\">user_id<\/span> <span class=\"nb\">INT<\/span>  <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"k\">references<\/span> <span class=\"n\">users<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">),<\/span>\r\n  <span class=\"n\">name<\/span> <span class=\"nb\">VARCHAR<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span>\r\n<span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">DROP<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">tags<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"nd\">table!<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nf\">tags<\/span> <span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">id<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Int4<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">user_id<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Int4<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">name<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Varchar<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">table!<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nf\">users<\/span> <span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">id<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Int4<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">name<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Varchar<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">joinable!<\/span><span class=\"p\">(<\/span><span class=\"n\">tags<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"nf\">users<\/span> <span class=\"p\">(<\/span><span class=\"n\">user_id<\/span><span class=\"p\">));<\/span>\r\n\r\n<span class=\"nd\">allow_tables_to_appear_in_same_query!<\/span><span class=\"p\">(<\/span>\r\n    <span class=\"n\">tags<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">users<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<h2>\u6dfb\u52a0GraphQL\u7684\u6a21\u5f0f\u5b9a\u4e49<\/h2>\n<pre class=\"post-pre\"><code><span class=\"gd\">--- a\/src\/schema.graphql\r\n<\/span><span class=\"gi\">+++ b\/src\/schema.graphql\r\n<\/span><span class=\"p\">@@ -16,4 +16,11 @@<\/span> type Mutation {\r\n type User {\r\n   id: ID! @juniper(ownership: \"owned\")\r\n   name: String!\r\n<span class=\"gi\">+  tags: [Tag!]! @juniper(ownership: \"owned\")\r\n+}\r\n+\r\n+type Tag {\r\n+  id: ID! @juniper(ownership: \"owned\")\r\n+  userId: ID! @juniper(ownership: \"owned\")\r\n+  name: String!\r\n<\/span> }\r\n<\/code><\/pre>\n<h2>\u6dfb\u52a0GraphQL\u7684\u5b9e\u73b0\u548c\u6a21\u578b<\/h2>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/graphql.rs b\/src\/graphql.rs\r\nindex c080860..9586231 100644\r\n<\/span><span class=\"gd\">--- a\/src\/graphql.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/graphql.rs\r\n<\/span><span class=\"p\">@@ -71,6 +71,19 @@<\/span> impl UserFields for User {\r\n     fn field_name(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;&amp;String&gt; {\r\n         Ok(&amp;self.name)\r\n     }\r\n<span class=\"gi\">+\r\n+    fn field_tags(\r\n+        &amp;self,\r\n+        executor: &amp;Executor&lt;'_, Context&gt;,\r\n+        _trail: &amp;QueryTrail&lt;'_, Tag, Walked&gt;,\r\n+    ) -&gt; FieldResult&lt;Vec&lt;Tag&gt;&gt; {\r\n+        use crate::schema::tags;\r\n+        tags::table\r\n+            .filter(tags::user_id.eq(&amp;self.id))\r\n+            .load::&lt;crate::models::Tag&gt;(&amp;executor.context().db_con)\r\n+            .and_then(|tags| Ok(tags.into_iter().map_into().collect()))\r\n+            .map_err(Into::into)\r\n+    }\r\n<\/span> }\r\n\r\n impl From&lt;crate::models::User&gt; for User {\r\n<span class=\"p\">@@ -82,6 +95,36 @@<\/span> impl From&lt;crate::models::User&gt; for User {\r\n     }\r\n }\r\n\r\n+pub struct Tag {\r\n<span class=\"gi\">+    id: i32,\r\n+    user_id: i32,\r\n+    name: String,\r\n+}\r\n+\r\n+impl TagFields for Tag {\r\n+    fn field_id(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;juniper::ID&gt; {\r\n+        Ok(juniper::ID::new(self.id.to_string()))\r\n+    }\r\n+\r\n+    fn field_user_id(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;juniper::ID&gt; {\r\n+        Ok(juniper::ID::new(self.user_id.to_string()))\r\n+    }\r\n+\r\n+    fn field_name(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;&amp;String&gt; {\r\n+        Ok(&amp;self.name)\r\n+    }\r\n+}\r\n+\r\n+impl From&lt;crate::models::Tag&gt; for Tag {\r\n+    fn from(tag: crate::models::Tag) -&gt; Self {\r\n+        Self {\r\n+            id: tag.id,\r\n+            user_id: tag.user_id,\r\n+            name: tag.name,\r\n+        }\r\n+    }\r\n+}\r\n+\r\n<\/span> fn playground() -&gt; HttpResponse {\r\n     let html = playground_source(\"\");\r\n     HttpResponse::Ok()\r\n<span class=\"gh\">diff --git a\/src\/models.rs b\/src\/models.rs\r\nindex 91b8447..bc7ea32 100644\r\n<\/span><span class=\"gd\">--- a\/src\/models.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/models.rs\r\n<\/span><span class=\"p\">@@ -11,3 +11,10 @@<\/span> pub struct User {\r\n pub struct NewUser {\r\n     pub name: String,\r\n }\r\n<span class=\"gi\">+\r\n+#[derive(Queryable)]\r\n+pub struct Tag {\r\n+    pub id: i32,\r\n+    pub user_id: i32,\r\n+    pub name: String,\r\n+}\r\n<\/span><\/code><\/pre>\n<h2>\u5728\u7528\u6237\u521b\u5efa\u65f6\u5141\u8bb8\u6dfb\u52a0\u6807\u7b7e\u3002<\/h2>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/graphql.rs b\/src\/graphql.rs\r\nindex 9586231..5aca150 100644\r\n<\/span><span class=\"gd\">--- a\/src\/graphql.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/graphql.rs\r\n<\/span><span class=\"p\">@@ -45,14 +45,26 @@<\/span> impl MutationFields for Mutation {\r\n         executor: &amp;Executor&lt;'_, Context&gt;,\r\n         _trail: &amp;QueryTrail&lt;'_, User, Walked&gt;,\r\n         name: String,\r\n<span class=\"gi\">+        tags: Vec&lt;String&gt;,\r\n<\/span>     ) -&gt; FieldResult&lt;User&gt; {\r\n<span class=\"gd\">-        use crate::schema::users;\r\n<\/span><span class=\"gi\">+        use crate::schema::{tags, users};\r\n<\/span>\r\n         let new_user = crate::models::NewUser { name: name };\r\n\r\n         diesel::insert_into(users::table)\r\n             .values(&amp;new_user)\r\n             .get_result::&lt;crate::models::User&gt;(&amp;executor.context().db_con)\r\n<span class=\"gi\">+            .and_then(|user| {\r\n+                let values = tags\r\n+                    .into_iter()\r\n+                    .map(|tag| (tags::user_id.eq(&amp;user.id), tags::name.eq(tag)))\r\n+                    .collect_vec();\r\n+\r\n+                diesel::insert_into(tags::table)\r\n+                    .values(&amp;values)\r\n+                    .execute(&amp;executor.context().db_con)?;\r\n+                Ok(user)\r\n+            })\r\n<\/span>             .map(Into::into)\r\n             .map_err(Into::into)\r\n     }\r\n<span class=\"gh\">diff --git a\/src\/schema.graphql b\/src\/schema.graphql\r\nindex b809a73..769e00a 100644\r\n<\/span><span class=\"gd\">--- a\/src\/schema.graphql\r\n<\/span><span class=\"gi\">+++ b\/src\/schema.graphql\r\n<\/span><span class=\"p\">@@ -9,7 +9,8 @@<\/span> type Query {\r\n\r\n type Mutation {\r\n   createUser(\r\n<span class=\"gd\">-    name: String!,\r\n<\/span><span class=\"gi\">+    name: String!\r\n+    tags: [String!]!\r\n<\/span>   ): User! @juniper(ownership: \"owned\")\r\n }\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">schema\u306ecreateUser\u306btags\u3092\u8ffd\u52a0<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">graphql.rs\u306ecreateUser\u6642\u306btags\u3082\u767b\u9332\u3059\u308b\u3088\u3046\u306b\u5909\u66f4<\/ul>\n<h2>\u786e\u5b9a<\/h2>\n<pre class=\"post-pre\"><code><span class=\"k\">mutation<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">createUser<\/span><span class=\"p\">(<\/span><span class=\"n\">name<\/span><span class=\"p\">:<\/span><span class=\"s2\">\"hoge2\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">tags<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"tag2\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"tag3\"<\/span><span class=\"p\">])<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">tags<\/span> <span class=\"p\">{<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">}<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u4ee5\u8fd9\u4e2a\u6837\u5b50\u6ce8\u518c\u51e0\u4e2a\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">query<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">users<\/span><span class=\"p\">{<\/span><span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">tags<\/span> <span class=\"p\">{<\/span><span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">}}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"p\">{<\/span>\r\n  <span class=\"nl\">\"data\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nl\">\"users\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"1\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"tags\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"1\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag1\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">]<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"2\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge2\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"tags\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"2\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag2\"<\/span>\r\n          <span class=\"p\">},<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"3\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag3\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">]<\/span>\r\n      <span class=\"p\">}<\/span>\r\n    <span class=\"p\">]<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u770b\u8d77\u6765\u597d\u50cf\u7b26\u5408\u9884\u671f\u4e86\u3002<\/p>\n<h2>\u8bf7\u786e\u8ba4\u662f\u5426\u5df2\u7ecf\u5230\u4e86N+1\u3002<\/h2>\n<h3>\u5728PostgreSQL\u7684\u914d\u7f6e\u4e2d\u542f\u7528\u65e5\u5fd7\u8bb0\u5f55<\/h3>\n<pre class=\"post-pre\"><code>docker-compose <span class=\"nb\">exec <\/span>postgres bash\r\nroot@9f006c0ac3da:\/# psql app dbuser\r\npsql <span class=\"o\">(<\/span>11.4 <span class=\"o\">(<\/span>Debian 11.4-1.pgdg90+1<span class=\"o\">))<\/span>\r\nType <span class=\"s2\">\"help\"<\/span> <span class=\"k\">for <\/span>help.\r\n<span class=\"nv\">app<\/span><span class=\"o\">=<\/span><span class=\"c\">#  ALTER DATABASE app SET log_statement = 'all';<\/span>\r\nALTER DATABASE\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30b3\u30f3\u30c6\u30ca\u306b\u5165\u3063\u3066psql\u3067\u30a2\u30af\u30bb\u30b9<\/ul>\n<\/li>\n<\/ul>\n<p>ALTER DATABASE app SET log_statement = &#8216;all&#8217;; \u3067app\u30c6\u30fc\u30d6\u30eb\u306e\u30ed\u30b0\u3092\u51fa\u529b\u3059\u308b\u8a2d\u5b9a\u306b\u3059\u308b<br \/>\n\u30b3\u30f3\u30c6\u30ca\u3092\u518d\u8d77\u52d5\u3059\u308b<\/p>\n<h3>\u6211\u6765\u770b\u770b\u65e5\u5fd7<\/h3>\n<pre class=\"post-pre\"><code>postgres    | 2019-11-27 14:20:40.779 UTC [32] LOG:  execute __diesel_stmt_0: SELECT \"users\".\"id\", \"users\".\"name\" FROM \"users\"\r\npostgres    | 2019-11-27 14:20:40.815 UTC [32] LOG:  execute __diesel_stmt_1: SELECT \"tags\".\"id\", \"tags\".\"user_id\", \"tags\".\"name\" FROM \"tags\" WHERE \"tags\".\"user_id\" = $1\r\npostgres    | 2019-11-27 14:20:40.815 UTC [32] DETAIL:  parameters: $1 = '1'\r\npostgres    | 2019-11-27 14:20:40.819 UTC [32] LOG:  execute __diesel_stmt_1: SELECT \"tags\".\"id\", \"tags\".\"user_id\", \"tags\".\"name\" FROM \"tags\" WHERE \"tags\".\"user_id\" = $1\r\npostgres    | 2019-11-27 14:20:40.819 UTC [32] DETAIL:  parameters: $1 = '2'\r\n<\/code><\/pre>\n<p>\u6839\u636e\u7528\u6237\u5355\u4f4d\uff0c\u4f3c\u4e4e\u6b63\u5728\u8bbf\u95ee\u6807\u7b7e\u3002<\/p>\n<h1>\u89e3\u51b3N+1\u7684\u95ee\u9898<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Rust\u306b\u3082dataloader\u5b9f\u88c5\u306f\u3042\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>cksac\/dataloader-rs: Rust implementation of Facebook&#8217;s DataLoader using futures.<\/p>\n<p>juniper\u5c02\u7528\u306edataloader\u7684\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u3082\u3042\u308b<\/p>\n<p>davidpdrsn\/juniper-eager-loading: Library for avoiding N+1 query bugs with Juniper<br \/>\njuniper\u7e1b\u308a\u3067\u3044\u3044\u306a\u3089\u3053\u3063\u3061\u306e\u65b9\u304c\u697d\u305d\u3046\u3067\u306f\u3042\u308b\u306e\u3067\u3001 \u4eca\u56de\u306f\u3053\u3063\u3061\u3092\u4f7f\u3044\u307e\u3059<\/p>\n<h2>\u8ba9\u6211\u4eec\u5c1d\u8bd5\u4f7f\u7528juniper-eagar-loading\u8fdb\u884c\u6539\u5199\u3002<\/h2>\n<p>juniper-eager-loading\/has_many.rs | davidpdrsn\/juniper-eager-loading<\/p>\n<p>\u6211\u5c06\u53c2\u8003\u8fd9\u4e2a\u4f8b\u5b50\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/graphql.rs b\/src\/graphql.rs\r\nindex 9586231..5dd9d34 100644\r\n<\/span><span class=\"gd\">--- a\/src\/graphql.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/graphql.rs\r\n<\/span><span class=\"p\">@@ -6,13 +6,14 @@<\/span> use futures01::future::Future;\r\n\r\n use juniper::http::playground::playground_source;\r\n use juniper::{http::GraphQLRequest, Executor, FieldResult};\r\n<span class=\"gi\">+use juniper_eager_loading::{prelude::*, EagerLoading, HasMany};\r\n<\/span> use juniper_from_schema::graphql_schema_from_file;\r\n\r\n use diesel::prelude::*;\r\n\r\n use itertools::Itertools;\r\n\r\n-use crate::{DbCon, DbPool};\r\n<span class=\"gi\">+use crate::{models, DbCon, DbPool};\r\n<\/span>\r\n graphql_schema_from_file!(\"src\/schema.graphql\");\r\n\r\n@@ -28,14 +29,23 @@ impl QueryFields for Query {\r\n     fn field_users(\r\n         &amp;self,\r\n         executor: &amp;Executor&lt;'_, Context&gt;,\r\n<span class=\"gd\">-        _trail: &amp;QueryTrail&lt;'_, User, Walked&gt;,\r\n<\/span><span class=\"gi\">+        trail: &amp;QueryTrail&lt;'_, User, Walked&gt;,\r\n<\/span>     ) -&gt; FieldResult&lt;Vec&lt;User&gt;&gt; {\r\n         use crate::schema::users;\r\n\r\n-        users::table\r\n<span class=\"gd\">-            .load::&lt;crate::models::User&gt;(&amp;executor.context().db_con)\r\n-            .and_then(|users| Ok(users.into_iter().map_into().collect()))\r\n-            .map_err(Into::into)\r\n<\/span><span class=\"gi\">+        let model_users = users::table\r\n+            .load::&lt;models::User&gt;(&amp;executor.context().db_con)\r\n+            .and_then(|users| Ok(users.into_iter().map_into().collect_vec()))?;\r\n+\r\n+        let mut users = User::from_db_models(&amp;model_users);\r\n+        User::eager_load_all_children_for_each(\r\n+            &amp;mut users,\r\n+            &amp;model_users,\r\n+            executor.context(),\r\n+            trail,\r\n+        )?;\r\n+\r\n+        Ok(users)\r\n<\/span>     }\r\n }\r\n\r\n@@ -43,85 +53,95 @@ impl MutationFields for Mutation {\r\n     fn field_create_user(\r\n         &amp;self,\r\n         executor: &amp;Executor&lt;'_, Context&gt;,\r\n<span class=\"gd\">-        _trail: &amp;QueryTrail&lt;'_, User, Walked&gt;,\r\n<\/span><span class=\"gi\">+        trail: &amp;QueryTrail&lt;'_, User, Walked&gt;,\r\n<\/span>         name: String,\r\n<span class=\"gi\">+        tags: Vec&lt;String&gt;,\r\n<\/span>     ) -&gt; FieldResult&lt;User&gt; {\r\n<span class=\"gd\">-        use crate::schema::users;\r\n<\/span><span class=\"gi\">+        use crate::schema::{tags, users};\r\n<\/span>\r\n-        let new_user = crate::models::NewUser { name: name };\r\n<span class=\"gi\">+        let new_user = models::NewUser { name: name };\r\n<\/span>\r\n-        diesel::insert_into(users::table)\r\n<span class=\"gi\">+        let model_user = diesel::insert_into(users::table)\r\n<\/span>             .values(&amp;new_user)\r\n<span class=\"gd\">-            .get_result::&lt;crate::models::User&gt;(&amp;executor.context().db_con)\r\n-            .map(Into::into)\r\n<\/span><span class=\"gi\">+            .get_result::&lt;models::User&gt;(&amp;executor.context().db_con)\r\n+            .and_then(|user| {\r\n+                let values = tags\r\n+                    .into_iter()\r\n+                    .map(|tag| (tags::user_id.eq(&amp;user.id), tags::name.eq(tag)))\r\n+                    .collect_vec();\r\n+\r\n+                diesel::insert_into(tags::table)\r\n+                    .values(&amp;values)\r\n+                    .execute(&amp;executor.context().db_con)?;\r\n+                Ok(user)\r\n+            })?;\r\n+\r\n+        let user = User::new_from_model(&amp;model_user);\r\n+        User::eager_load_all_children(user, &amp;[model_user], &amp;executor.context(), trail)\r\n<\/span>             .map_err(Into::into)\r\n     }\r\n }\r\n\r\n+#[derive(Debug, Clone, PartialEq, EagerLoading)]\r\n<span class=\"gi\">+#[eager_loading(context = Context, error = diesel::result::Error)]\r\n<\/span> pub struct User {\r\n<span class=\"gd\">-    id: i32,\r\n-    name: String,\r\n<\/span><span class=\"gi\">+    user: models::User,\r\n+\r\n+    #[has_many(root_model_field = tag)]\r\n+    tags: HasMany&lt;Tag&gt;,\r\n<\/span> }\r\n\r\n impl UserFields for User {\r\n     fn field_id(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;juniper::ID&gt; {\r\n<span class=\"gd\">-        Ok(juniper::ID::new(self.id.to_string()))\r\n<\/span><span class=\"gi\">+        Ok(juniper::ID::new(self.user.id.to_string()))\r\n<\/span>     }\r\n\r\n     fn field_name(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;&amp;String&gt; {\r\n<span class=\"gd\">-        Ok(&amp;self.name)\r\n<\/span><span class=\"gi\">+        Ok(&amp;self.user.name)\r\n<\/span>     }\r\n\r\n     fn field_tags(\r\n         &amp;self,\r\n<span class=\"gd\">-        executor: &amp;Executor&lt;'_, Context&gt;,\r\n-        _trail: &amp;QueryTrail&lt;'_, Tag, Walked&gt;,\r\n-    ) -&gt; FieldResult&lt;Vec&lt;Tag&gt;&gt; {\r\n-        use crate::schema::tags;\r\n-        tags::table\r\n-            .filter(tags::user_id.eq(&amp;self.id))\r\n-            .load::&lt;crate::models::Tag&gt;(&amp;executor.context().db_con)\r\n-            .and_then(|tags| Ok(tags.into_iter().map_into().collect()))\r\n-            .map_err(Into::into)\r\n<\/span><span class=\"gi\">+        _: &amp;Executor&lt;'_, Context&gt;,\r\n+        _: &amp;QueryTrail&lt;'_, Tag, Walked&gt;,\r\n+    ) -&gt; FieldResult&lt;&amp;Vec&lt;Tag&gt;&gt; {\r\n+        self.tags.try_unwrap().map_err(Into::into)\r\n<\/span>     }\r\n }\r\n\r\n-impl From&lt;crate::models::User&gt; for User {\r\n<span class=\"gd\">-    fn from(user: crate::models::User) -&gt; Self {\r\n-        Self {\r\n-            id: user.id,\r\n-            name: user.name,\r\n-        }\r\n<\/span><span class=\"gi\">+impl juniper_eager_loading::LoadFrom&lt;models::User&gt; for models::Tag {\r\n+    type Error = diesel::result::Error;\r\n+    type Context = Context;\r\n+\r\n+    fn load(\r\n+        users: &amp;[models::User],\r\n+        _field_args: &amp;(),\r\n+        context: &amp;Self::Context,\r\n+    ) -&gt; Result&lt;Vec&lt;models::Tag&gt;, Self::Error&gt; {\r\n+        use crate::schema::tags;\r\n+        tags::table\r\n+            .filter(tags::user_id.eq_any(users.iter().map(|x| x.id).collect_vec()))\r\n+            .load::&lt;models::Tag&gt;(&amp;context.db_con)\r\n<\/span>     }\r\n }\r\n\r\n+#[derive(Debug, Clone, PartialEq, EagerLoading)]\r\n<span class=\"gi\">+#[eager_loading(context = Context, error = diesel::result::Error)]\r\n<\/span> pub struct Tag {\r\n<span class=\"gd\">-    id: i32,\r\n-    user_id: i32,\r\n-    name: String,\r\n<\/span><span class=\"gi\">+    tag: models::Tag,\r\n<\/span> }\r\n\r\n impl TagFields for Tag {\r\n     fn field_id(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;juniper::ID&gt; {\r\n<span class=\"gd\">-        Ok(juniper::ID::new(self.id.to_string()))\r\n<\/span><span class=\"gi\">+        Ok(juniper::ID::new(self.tag.id.to_string()))\r\n<\/span>     }\r\n\r\n     fn field_user_id(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;juniper::ID&gt; {\r\n<span class=\"gd\">-        Ok(juniper::ID::new(self.user_id.to_string()))\r\n<\/span><span class=\"gi\">+        Ok(juniper::ID::new(self.tag.user_id.to_string()))\r\n<\/span>     }\r\n\r\n     fn field_name(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;&amp;String&gt; {\r\n<span class=\"gd\">-        Ok(&amp;self.name)\r\n-    }\r\n-}\r\n-\r\n-impl From&lt;crate::models::Tag&gt; for Tag {\r\n-    fn from(tag: crate::models::Tag) -&gt; Self {\r\n-        Self {\r\n-            id: tag.id,\r\n-            user_id: tag.user_id,\r\n-            name: tag.name,\r\n-        }\r\n<\/span><span class=\"gi\">+        Ok(&amp;self.tag.name)\r\n<\/span>     }\r\n }\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/models.rs b\/src\/models.rs\r\nindex bc7ea32..9fe73f0 100644\r\n<\/span><span class=\"gd\">--- a\/src\/models.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/models.rs\r\n<\/span><span class=\"p\">@@ -1,6 +1,6 @@<\/span>\r\n use super::schema::users;\r\n\r\n-#[derive(Queryable)]\r\n<span class=\"gi\">+#[derive(Queryable, Clone, PartialEq, Debug)]\r\n<\/span> pub struct User {\r\n     pub id: i32,\r\n     pub name: String,\r\n<span class=\"p\">@@ -12,7 +12,7 @@<\/span> pub struct NewUser {\r\n     pub name: String,\r\n }\r\n\r\n-#[derive(Queryable)]\r\n<span class=\"gi\">+#[derive(Queryable, Clone, PartialEq, Debug)]\r\n<\/span> pub struct Tag {\r\n     pub id: i32,\r\n     pub user_id: i32,\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/schema.graphql b\/src\/schema.graphql\r\nindex b809a73..a27a7fb 100644\r\n<\/span><span class=\"gd\">--- a\/src\/schema.graphql\r\n<\/span><span class=\"gi\">+++ b\/src\/schema.graphql\r\n<\/span><span class=\"p\">@@ -9,14 +9,15 @@<\/span> type Query {\r\n\r\n type Mutation {\r\n   createUser(\r\n<span class=\"gd\">-    name: String!,\r\n<\/span><span class=\"gi\">+    name: String!\r\n+    tags: [String!]!\r\n<\/span>   ): User! @juniper(ownership: \"owned\")\r\n }\r\n\r\n type User {\r\n   id: ID! @juniper(ownership: \"owned\")\r\n   name: String!\r\n<span class=\"gd\">-  tags: [Tag!]! @juniper(ownership: \"owned\")\r\n<\/span><span class=\"gi\">+  tags: [Tag!]!\r\n<\/span> }\r\n\r\n type Tag {\r\n<\/code><\/pre>\n<h2>\u67e5\u770bPostgreSQL\u65e5\u5fd7<\/h2>\n<pre class=\"post-pre\"><code>postgres    | 2019-11-27 15:02:52.472 UTC [81] LOG:  execute __diesel_stmt_0: SELECT \"users\".\"id\", \"users\".\"name\" FROM \"users\"\r\npostgres    | 2019-11-27 15:02:52.490 UTC [81] LOG:  execute &lt;unnamed&gt;: SELECT \"tags\".\"id\", \"tags\".\"user_id\", \"tags\".\"name\" FROM \"tags\" WHERE \"tags\".\"user_id\" IN ($1, $2)\r\npostgres    | 2019-11-27 15:02:52.490 UTC [81] DETAIL:  parameters: $1 = '1', $2 = '2'\r\n<\/code><\/pre>\n<h1>\u5c1d\u8bd5\u4f7f\u7528HasManyThrough\u3002<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u4e2d\u9593\u306brelation\u30c6\u30fc\u30d6\u30eb\u3092\u6301\u3064\u3088\u3046\u306aN:M\u95a2\u4fc2\u306b\u306a\u308b\u72b6\u6cc1\u3092\u4f5c\u3063\u3066\u307f\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>juniper-eager-loading\/has_many_through.rs \u00b7 davidpdrsn\/juniper-eager-loading<\/p>\n<p>\u3053\u3053\u306bexamples\u306f\u3042\u308b\u3051\u3069\u3001\u30b3\u30fc\u30c9\u3092\u898b\u308b\u9650\u308a\u3001\uff13\u56de\u30af\u30a8\u30ea\u304c\u8d70\u308a\u305d\u3046\u306b\u307f\u3048\u308b<\/p>\n<h2>\u684c\u5b50<\/h2>\n<pre class=\"post-pre\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">companies<\/span> <span class=\"p\">(<\/span>\r\n  <span class=\"n\">id<\/span>   <span class=\"nb\">SERIAL<\/span>  <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"n\">name<\/span> <span class=\"nb\">VARCHAR<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span>\r\n<span class=\"p\">);<\/span>\r\n\r\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">employments<\/span> <span class=\"p\">(<\/span>\r\n  <span class=\"n\">id<\/span>         <span class=\"nb\">SERIAL<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"n\">user_id<\/span>    <span class=\"nb\">INT<\/span>    <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"k\">references<\/span> <span class=\"n\">users<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">),<\/span>\r\n  <span class=\"n\">company_id<\/span> <span class=\"nb\">INT<\/span>    <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"k\">references<\/span> <span class=\"n\">companies<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">);<\/span>\r\n<\/code><\/pre>\n<h2>\u6a21\u7279\u513f<\/h2>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/models.rs b\/src\/models.rs\r\nindex 9fe73f0..bec0a13 100644\r\n<\/span><span class=\"gd\">--- a\/src\/models.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/models.rs\r\n<\/span><span class=\"p\">@@ -18,3 +18,16 @@<\/span> pub struct Tag {\r\n     pub user_id: i32,\r\n     pub name: String,\r\n }\r\n<span class=\"gi\">+\r\n+#[derive(Queryable, Clone, PartialEq, Debug)]\r\n+pub struct Company {\r\n+    pub id: i32,\r\n+    pub name: String,\r\n+}\r\n+\r\n+#[derive(Queryable, Clone, PartialEq, Debug)]\r\n+pub struct Employment {\r\n+    pub id: i32,\r\n+    pub user_id: i32,\r\n+    pub company_id: i32,\r\n+}\r\n<\/span><\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/schema.rs b\/src\/schema.rs\r\nindex 72fd8f6..2c7cdea 100644\r\n<\/span><span class=\"gd\">--- a\/src\/schema.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/schema.rs\r\n<\/span><span class=\"p\">@@ -1,3 +1,18 @@<\/span>\r\n<span class=\"gi\">+table! {\r\n+    companies (id) {\r\n+        id -&gt; Int4,\r\n+        name -&gt; Varchar,\r\n+    }\r\n+}\r\n+\r\n+table! {\r\n+    employments (id) {\r\n+        id -&gt; Int4,\r\n+        user_id -&gt; Int4,\r\n+        company_id -&gt; Int4,\r\n+    }\r\n+}\r\n+\r\n<\/span> table! {\r\n     tags (id) {\r\n         id -&gt; Int4,\r\n<span class=\"p\">@@ -13,9 +28,13 @@<\/span> table! {\r\n     }\r\n }\r\n\r\n+joinable!(employments -&gt; companies (company_id));\r\n<span class=\"gi\">+joinable!(employments -&gt; users (user_id));\r\n<\/span> joinable!(tags -&gt; users (user_id));\r\n\r\n allow_tables_to_appear_in_same_query!(\r\n<span class=\"gi\">+    companies,\r\n+    employments,\r\n<\/span>     tags,\r\n     users,\r\n );\r\n<\/code><\/pre>\n<h2>\u56fe\u7075\u673a\u67e5\u8be2\u8bed\u8a00 (GraphQL)<\/h2>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/schema.graphql b\/src\/schema.graphql\r\nindex a27a7fb..fbd22cf 100644\r\n<\/span><span class=\"gd\">--- a\/src\/schema.graphql\r\n<\/span><span class=\"gi\">+++ b\/src\/schema.graphql\r\n<\/span><span class=\"p\">@@ -18,6 +18,7 @@<\/span> type User {\r\n   id: ID! @juniper(ownership: \"owned\")\r\n   name: String!\r\n   tags: [Tag!]!\r\n<span class=\"gi\">+  companies: [Company!]!\r\n<\/span> }\r\n\r\n type Tag {\r\n<span class=\"p\">@@ -25,3 +26,8 @@<\/span> type Tag {\r\n   userId: ID! @juniper(ownership: \"owned\")\r\n   name: String!\r\n }\r\n<span class=\"gi\">+\r\n+type Company {\r\n+  id: ID! @juniper(ownership: \"owned\")\r\n+  name: String!\r\n+}\r\n<\/span><\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">use<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">convert<\/span><span class=\"p\">::<\/span><span class=\"n\">From<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">sync<\/span><span class=\"p\">::<\/span><span class=\"nb\">Arc<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">actix_web<\/span><span class=\"p\">::{<\/span><span class=\"n\">web<\/span><span class=\"p\">,<\/span> <span class=\"n\">Error<\/span><span class=\"p\">,<\/span> <span class=\"n\">HttpResponse<\/span><span class=\"p\">};<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">futures01<\/span><span class=\"p\">::<\/span><span class=\"nn\">future<\/span><span class=\"p\">::<\/span><span class=\"n\">Future<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"nn\">http<\/span><span class=\"p\">::<\/span><span class=\"nn\">playground<\/span><span class=\"p\">::<\/span><span class=\"n\">playground_source<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">juniper<\/span><span class=\"p\">::{<\/span><span class=\"nn\">http<\/span><span class=\"p\">::<\/span><span class=\"n\">GraphQLRequest<\/span><span class=\"p\">,<\/span> <span class=\"n\">Executor<\/span><span class=\"p\">,<\/span> <span class=\"n\">FieldResult<\/span><span class=\"p\">};<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">juniper_eager_loading<\/span><span class=\"p\">::{<\/span><span class=\"nn\">prelude<\/span><span class=\"p\">::<\/span><span class=\"o\">*<\/span><span class=\"p\">,<\/span> <span class=\"n\">EagerLoading<\/span><span class=\"p\">,<\/span> <span class=\"n\">HasMany<\/span><span class=\"p\">,<\/span> <span class=\"n\">HasManyThrough<\/span><span class=\"p\">};<\/span>\r\n<span class=\"k\">use<\/span> <span class=\"nn\">juniper_from_schema<\/span><span class=\"p\">::<\/span><span class=\"n\">graphql_schema_from_file<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nn\">prelude<\/span><span class=\"p\">::<\/span><span class=\"o\">*<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">itertools<\/span><span class=\"p\">::<\/span><span class=\"n\">Itertools<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::{<\/span><span class=\"n\">models<\/span><span class=\"p\">,<\/span> <span class=\"n\">DbCon<\/span><span class=\"p\">,<\/span> <span class=\"n\">DbPool<\/span><span class=\"p\">};<\/span>\r\n\r\n<span class=\"nd\">graphql_schema_from_file!<\/span><span class=\"p\">(<\/span><span class=\"s\">\"src\/schema.graphql\"<\/span><span class=\"p\">);<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Context<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">db_con<\/span><span class=\"p\">:<\/span> <span class=\"n\">DbCon<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n<span class=\"k\">impl<\/span> <span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"n\">Context<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Context<\/span> <span class=\"p\">{}<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Query<\/span><span class=\"p\">;<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Mutation<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">QueryFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Query<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_users<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">executor<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">trail<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">QueryTrail<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">User<\/span><span class=\"p\">,<\/span> <span class=\"n\">Walked<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::<\/span><span class=\"n\">users<\/span><span class=\"p\">;<\/span>\r\n\r\n        <span class=\"k\">let<\/span> <span class=\"n\">model_users<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">users<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span>\r\n            <span class=\"py\">.load<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">()<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.and_then<\/span><span class=\"p\">(|<\/span><span class=\"n\">users<\/span><span class=\"p\">|<\/span> <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"n\">users<\/span><span class=\"nf\">.into_iter<\/span><span class=\"p\">()<\/span><span class=\"nf\">.map_into<\/span><span class=\"p\">()<\/span><span class=\"nf\">.collect_vec<\/span><span class=\"p\">()))<\/span><span class=\"o\">?<\/span><span class=\"p\">;<\/span>\r\n\r\n        <span class=\"k\">let<\/span> <span class=\"k\">mut<\/span> <span class=\"n\">users<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">User<\/span><span class=\"p\">::<\/span><span class=\"nf\">from_db_models<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">model_users<\/span><span class=\"p\">);<\/span>\r\n        <span class=\"nn\">User<\/span><span class=\"p\">::<\/span><span class=\"nf\">eager_load_all_children_for_each<\/span><span class=\"p\">(<\/span>\r\n            <span class=\"o\">&amp;<\/span><span class=\"k\">mut<\/span> <span class=\"n\">users<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"o\">&amp;<\/span><span class=\"n\">model_users<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">(),<\/span>\r\n            <span class=\"n\">trail<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"p\">)<\/span><span class=\"o\">?<\/span><span class=\"p\">;<\/span>\r\n\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"n\">users<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">MutationFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Mutation<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_create_user<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">executor<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">trail<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">QueryTrail<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">User<\/span><span class=\"p\">,<\/span> <span class=\"n\">Walked<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"nb\">String<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"n\">tags<\/span><span class=\"p\">:<\/span> <span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">String<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::{<\/span><span class=\"n\">tags<\/span><span class=\"p\">,<\/span> <span class=\"n\">users<\/span><span class=\"p\">};<\/span>\r\n\r\n        <span class=\"k\">let<\/span> <span class=\"n\">new_user<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">NewUser<\/span> <span class=\"p\">{<\/span> <span class=\"n\">name<\/span><span class=\"p\">:<\/span> <span class=\"n\">name<\/span> <span class=\"p\">};<\/span>\r\n\r\n        <span class=\"k\">let<\/span> <span class=\"n\">model_user<\/span> <span class=\"o\">=<\/span> <span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">()<\/span><span class=\"py\">.db_con<\/span><span class=\"nf\">.transaction<\/span><span class=\"p\">(||<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nf\">insert_into<\/span><span class=\"p\">(<\/span><span class=\"nn\">users<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span><span class=\"p\">)<\/span>\r\n                <span class=\"nf\">.values<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">new_user<\/span><span class=\"p\">)<\/span>\r\n                <span class=\"py\">.get_result<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">()<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span>\r\n                <span class=\"nf\">.and_then<\/span><span class=\"p\">(|<\/span><span class=\"n\">user<\/span><span class=\"p\">|<\/span> <span class=\"p\">{<\/span>\r\n                    <span class=\"k\">let<\/span> <span class=\"n\">values<\/span> <span class=\"o\">=<\/span> <span class=\"n\">tags<\/span>\r\n                        <span class=\"nf\">.into_iter<\/span><span class=\"p\">()<\/span>\r\n                        <span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">tag<\/span><span class=\"p\">|<\/span> <span class=\"p\">(<\/span><span class=\"nn\">tags<\/span><span class=\"p\">::<\/span><span class=\"n\">user_id<\/span><span class=\"nf\">.eq<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">user<\/span><span class=\"py\">.id<\/span><span class=\"p\">),<\/span> <span class=\"nn\">tags<\/span><span class=\"p\">::<\/span><span class=\"n\">name<\/span><span class=\"nf\">.eq<\/span><span class=\"p\">(<\/span><span class=\"n\">tag<\/span><span class=\"p\">)))<\/span>\r\n                        <span class=\"nf\">.collect_vec<\/span><span class=\"p\">();<\/span>\r\n\r\n                    <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nf\">insert_into<\/span><span class=\"p\">(<\/span><span class=\"nn\">tags<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span><span class=\"p\">)<\/span>\r\n                        <span class=\"nf\">.values<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">values<\/span><span class=\"p\">)<\/span>\r\n                        <span class=\"nf\">.execute<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">()<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span><span class=\"o\">?<\/span><span class=\"p\">;<\/span>\r\n                    <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"n\">user<\/span><span class=\"p\">)<\/span>\r\n                <span class=\"p\">})<\/span>\r\n        <span class=\"p\">})<\/span><span class=\"o\">?<\/span><span class=\"p\">;<\/span>\r\n\r\n        <span class=\"k\">let<\/span> <span class=\"n\">user<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">User<\/span><span class=\"p\">::<\/span><span class=\"nf\">new_from_model<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">model_user<\/span><span class=\"p\">);<\/span>\r\n        <span class=\"nn\">User<\/span><span class=\"p\">::<\/span><span class=\"nf\">eager_load_all_children<\/span><span class=\"p\">(<\/span><span class=\"n\">user<\/span><span class=\"p\">,<\/span> <span class=\"o\">&amp;<\/span><span class=\"p\">[<\/span><span class=\"n\">model_user<\/span><span class=\"p\">],<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">executor<\/span><span class=\"nf\">.context<\/span><span class=\"p\">(),<\/span> <span class=\"n\">trail<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.map_err<\/span><span class=\"p\">(<\/span><span class=\"nn\">Into<\/span><span class=\"p\">::<\/span><span class=\"n\">into<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">#[derive(Debug,<\/span> <span class=\"nd\">Clone,<\/span> <span class=\"nd\">PartialEq,<\/span> <span class=\"nd\">EagerLoading)]<\/span>\r\n<span class=\"nd\">#[eager_loading(context<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">Context,<\/span> <span class=\"nd\">error<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">diesel::result::Error)]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">User<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">user<\/span><span class=\"p\">:<\/span> <span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"p\">,<\/span>\r\n\r\n    <span class=\"nd\">#[has_many(root_model_field<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">tag)]<\/span>\r\n    <span class=\"n\">tags<\/span><span class=\"p\">:<\/span> <span class=\"n\">HasMany<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Tag<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n\r\n    <span class=\"nd\">#[has_many_through(join_model<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">models::Employment)]<\/span>\r\n    <span class=\"n\">companies<\/span><span class=\"p\">:<\/span> <span class=\"n\">HasManyThrough<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Company<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">UserFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">User<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_id<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"n\">ID<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"nn\">ID<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"k\">self<\/span><span class=\"py\">.user.id<\/span><span class=\"nf\">.to_string<\/span><span class=\"p\">()))<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_name<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;&amp;<\/span><span class=\"nb\">String<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"py\">.user.name<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_tags<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">QueryTrail<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Tag<\/span><span class=\"p\">,<\/span> <span class=\"n\">Walked<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;&amp;<\/span><span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Tag<\/span><span class=\"o\">&gt;&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">self<\/span><span class=\"py\">.tags<\/span><span class=\"nf\">.try_unwrap<\/span><span class=\"p\">()<\/span><span class=\"nf\">.map_err<\/span><span class=\"p\">(<\/span><span class=\"nn\">Into<\/span><span class=\"p\">::<\/span><span class=\"n\">into<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_companies<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">QueryTrail<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Company<\/span><span class=\"p\">,<\/span> <span class=\"n\">Walked<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;&amp;<\/span><span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Company<\/span><span class=\"o\">&gt;&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">self<\/span><span class=\"py\">.companies<\/span><span class=\"nf\">.try_unwrap<\/span><span class=\"p\">()<\/span><span class=\"nf\">.map_err<\/span><span class=\"p\">(<\/span><span class=\"nn\">Into<\/span><span class=\"p\">::<\/span><span class=\"n\">into<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">#[derive(Debug,<\/span> <span class=\"nd\">Clone,<\/span> <span class=\"nd\">PartialEq,<\/span> <span class=\"nd\">EagerLoading)]<\/span>\r\n<span class=\"nd\">#[eager_loading(context<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">Context,<\/span> <span class=\"nd\">error<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">diesel::result::Error)]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Tag<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">tag<\/span><span class=\"p\">:<\/span> <span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Tag<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">TagFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Tag<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_id<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"n\">ID<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"nn\">ID<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"k\">self<\/span><span class=\"py\">.tag.id<\/span><span class=\"nf\">.to_string<\/span><span class=\"p\">()))<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_user_id<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"n\">ID<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"nn\">ID<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"k\">self<\/span><span class=\"py\">.tag.user_id<\/span><span class=\"nf\">.to_string<\/span><span class=\"p\">()))<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_name<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;&amp;<\/span><span class=\"nb\">String<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"py\">.tag.name<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nd\">#[derive(Debug,<\/span> <span class=\"nd\">Clone,<\/span> <span class=\"nd\">PartialEq,<\/span> <span class=\"nd\">EagerLoading)]<\/span>\r\n<span class=\"nd\">#[eager_loading(context<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">Context,<\/span> <span class=\"nd\">error<\/span> <span class=\"nd\">=<\/span> <span class=\"nd\">diesel::result::Error)]<\/span>\r\n<span class=\"k\">pub<\/span> <span class=\"k\">struct<\/span> <span class=\"n\">Company<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">company<\/span><span class=\"p\">:<\/span> <span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Company<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"n\">CompanyFields<\/span> <span class=\"k\">for<\/span> <span class=\"n\">Company<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_id<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"n\">ID<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"nn\">juniper<\/span><span class=\"p\">::<\/span><span class=\"nn\">ID<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"k\">self<\/span><span class=\"py\">.company.id<\/span><span class=\"nf\">.to_string<\/span><span class=\"p\">()))<\/span>\r\n    <span class=\"p\">}<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">field_name<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"p\">,<\/span> <span class=\"mi\">_<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">Executor<\/span><span class=\"o\">&lt;<\/span><span class=\"nv\">'_<\/span><span class=\"p\">,<\/span> <span class=\"n\">Context<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">FieldResult<\/span><span class=\"o\">&lt;&amp;<\/span><span class=\"nb\">String<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"k\">self<\/span><span class=\"py\">.company.name<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"nn\">juniper_eager_loading<\/span><span class=\"p\">::<\/span><span class=\"n\">LoadFrom<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span> <span class=\"k\">for<\/span> <span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Tag<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">type<\/span> <span class=\"n\">Error<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nn\">result<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"k\">type<\/span> <span class=\"n\">Context<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Context<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">load<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"n\">users<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"p\">[<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"p\">],<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"n\">field_args<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"p\">(),<\/span>\r\n        <span class=\"n\">context<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"nn\">Self<\/span><span class=\"p\">::<\/span><span class=\"n\">Context<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Result<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Tag<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span> <span class=\"nn\">Self<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::<\/span><span class=\"n\">tags<\/span><span class=\"p\">;<\/span>\r\n        <span class=\"nn\">tags<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span>\r\n            <span class=\"nf\">.filter<\/span><span class=\"p\">(<\/span><span class=\"nn\">tags<\/span><span class=\"p\">::<\/span><span class=\"n\">user_id<\/span><span class=\"nf\">.eq_any<\/span><span class=\"p\">(<\/span><span class=\"n\">users<\/span><span class=\"nf\">.iter<\/span><span class=\"p\">()<\/span><span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">x<\/span><span class=\"p\">|<\/span> <span class=\"n\">x<\/span><span class=\"py\">.id<\/span><span class=\"p\">)<\/span><span class=\"nf\">.collect_vec<\/span><span class=\"p\">()))<\/span>\r\n            <span class=\"py\">.load<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Tag<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">context<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"nn\">juniper_eager_loading<\/span><span class=\"p\">::<\/span><span class=\"n\">LoadFrom<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Employment<\/span><span class=\"o\">&gt;<\/span> <span class=\"k\">for<\/span> <span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Company<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">type<\/span> <span class=\"n\">Error<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nn\">result<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"k\">type<\/span> <span class=\"n\">Context<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Context<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">load<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"n\">employments<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"p\">[<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Employment<\/span><span class=\"p\">],<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"n\">field_args<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"p\">(),<\/span>\r\n        <span class=\"n\">context<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"nn\">Self<\/span><span class=\"p\">::<\/span><span class=\"n\">Context<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Result<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Company<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span> <span class=\"nn\">Self<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::<\/span><span class=\"n\">companies<\/span><span class=\"p\">;<\/span>\r\n        <span class=\"nn\">companies<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span>\r\n            <span class=\"nf\">.filter<\/span><span class=\"p\">(<\/span><span class=\"nn\">companies<\/span><span class=\"p\">::<\/span><span class=\"n\">id<\/span><span class=\"nf\">.eq_any<\/span><span class=\"p\">(<\/span><span class=\"n\">employments<\/span><span class=\"nf\">.iter<\/span><span class=\"p\">()<\/span><span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">x<\/span><span class=\"p\">|<\/span> <span class=\"n\">x<\/span><span class=\"py\">.company_id<\/span><span class=\"p\">)<\/span><span class=\"nf\">.collect_vec<\/span><span class=\"p\">()))<\/span>\r\n            <span class=\"py\">.load<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Company<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">context<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">impl<\/span> <span class=\"nn\">juniper_eager_loading<\/span><span class=\"p\">::<\/span><span class=\"n\">LoadFrom<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"o\">&gt;<\/span> <span class=\"k\">for<\/span> <span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Employment<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">type<\/span> <span class=\"n\">Error<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">diesel<\/span><span class=\"p\">::<\/span><span class=\"nn\">result<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"p\">;<\/span>\r\n    <span class=\"k\">type<\/span> <span class=\"n\">Context<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Context<\/span><span class=\"p\">;<\/span>\r\n\r\n    <span class=\"k\">fn<\/span> <span class=\"nf\">load<\/span><span class=\"p\">(<\/span>\r\n        <span class=\"n\">users<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"p\">[<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">User<\/span><span class=\"p\">],<\/span>\r\n        <span class=\"mi\">_<\/span><span class=\"n\">field_args<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"p\">(),<\/span>\r\n        <span class=\"n\">context<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"nn\">Self<\/span><span class=\"p\">::<\/span><span class=\"n\">Context<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">Result<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">Vec<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Employment<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span> <span class=\"nn\">Self<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">use<\/span> <span class=\"nn\">crate<\/span><span class=\"p\">::<\/span><span class=\"nn\">schema<\/span><span class=\"p\">::<\/span><span class=\"n\">employments<\/span><span class=\"p\">;<\/span>\r\n        <span class=\"nn\">employments<\/span><span class=\"p\">::<\/span><span class=\"n\">table<\/span>\r\n            <span class=\"nf\">.filter<\/span><span class=\"p\">(<\/span><span class=\"nn\">employments<\/span><span class=\"p\">::<\/span><span class=\"n\">user_id<\/span><span class=\"nf\">.eq_any<\/span><span class=\"p\">(<\/span><span class=\"n\">users<\/span><span class=\"nf\">.iter<\/span><span class=\"p\">()<\/span><span class=\"nf\">.map<\/span><span class=\"p\">(|<\/span><span class=\"n\">x<\/span><span class=\"p\">|<\/span> <span class=\"n\">x<\/span><span class=\"py\">.id<\/span><span class=\"p\">)<\/span><span class=\"nf\">.collect_vec<\/span><span class=\"p\">()))<\/span>\r\n            <span class=\"py\">.load<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"nn\">models<\/span><span class=\"p\">::<\/span><span class=\"n\">Employment<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">context<\/span><span class=\"py\">.db_con<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">fn<\/span> <span class=\"nf\">playground<\/span><span class=\"p\">()<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"n\">HttpResponse<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">html<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">playground_source<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\"<\/span><span class=\"p\">);<\/span>\r\n    <span class=\"nn\">HttpResponse<\/span><span class=\"p\">::<\/span><span class=\"nf\">Ok<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"nf\">.content_type<\/span><span class=\"p\">(<\/span><span class=\"s\">\"text\/html; charset=utf-8\"<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">.body<\/span><span class=\"p\">(<\/span><span class=\"n\">html<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">fn<\/span> <span class=\"nf\">graphql<\/span><span class=\"p\">(<\/span>\r\n    <span class=\"n\">schema<\/span><span class=\"p\">:<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">Data<\/span><span class=\"o\">&lt;<\/span><span class=\"nb\">Arc<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Schema<\/span><span class=\"o\">&gt;&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">data<\/span><span class=\"p\">:<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">Json<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">GraphQLRequest<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">db_pool<\/span><span class=\"p\">:<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">Data<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">DbPool<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">,<\/span>\r\n<span class=\"p\">)<\/span> <span class=\"k\">-&gt;<\/span> <span class=\"k\">impl<\/span> <span class=\"n\">Future<\/span><span class=\"o\">&lt;<\/span><span class=\"n\">Item<\/span> <span class=\"o\">=<\/span> <span class=\"n\">HttpResponse<\/span><span class=\"p\">,<\/span> <span class=\"n\">Error<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Error<\/span><span class=\"o\">&gt;<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">ctx<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Context<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"n\">db_con<\/span><span class=\"p\">:<\/span> <span class=\"n\">db_pool<\/span><span class=\"nf\">.get<\/span><span class=\"p\">()<\/span><span class=\"nf\">.unwrap<\/span><span class=\"p\">(),<\/span>\r\n    <span class=\"p\">};<\/span>\r\n\r\n    <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"nf\">block<\/span><span class=\"p\">(<\/span><span class=\"k\">move<\/span> <span class=\"p\">||<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">let<\/span> <span class=\"n\">res<\/span> <span class=\"o\">=<\/span> <span class=\"n\">data<\/span><span class=\"nf\">.execute<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">schema<\/span><span class=\"p\">,<\/span> <span class=\"o\">&amp;<\/span><span class=\"n\">ctx<\/span><span class=\"p\">);<\/span>\r\n        <span class=\"nn\">Ok<\/span><span class=\"p\">::<\/span><span class=\"o\">&lt;<\/span><span class=\"mi\">_<\/span><span class=\"p\">,<\/span> <span class=\"nn\">serde_json<\/span><span class=\"p\">::<\/span><span class=\"nn\">error<\/span><span class=\"p\">::<\/span><span class=\"n\">Error<\/span><span class=\"o\">&gt;<\/span><span class=\"p\">(<\/span><span class=\"nn\">serde_json<\/span><span class=\"p\">::<\/span><span class=\"nf\">to_string<\/span><span class=\"p\">(<\/span><span class=\"o\">&amp;<\/span><span class=\"n\">res<\/span><span class=\"p\">)<\/span><span class=\"o\">?<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"p\">})<\/span>\r\n    <span class=\"nf\">.map_err<\/span><span class=\"p\">(<\/span><span class=\"nn\">Error<\/span><span class=\"p\">::<\/span><span class=\"n\">from<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"nf\">.and_then<\/span><span class=\"p\">(|<\/span><span class=\"n\">user<\/span><span class=\"p\">|<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nf\">Ok<\/span><span class=\"p\">(<\/span><span class=\"nn\">HttpResponse<\/span><span class=\"p\">::<\/span><span class=\"nf\">Ok<\/span><span class=\"p\">()<\/span>\r\n            <span class=\"nf\">.content_type<\/span><span class=\"p\">(<\/span><span class=\"s\">\"application\/json\"<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">.body<\/span><span class=\"p\">(<\/span><span class=\"n\">user<\/span><span class=\"p\">))<\/span>\r\n    <span class=\"p\">})<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">pub<\/span> <span class=\"k\">fn<\/span> <span class=\"nf\">register<\/span><span class=\"p\">(<\/span><span class=\"n\">config<\/span><span class=\"p\">:<\/span> <span class=\"o\">&amp;<\/span><span class=\"k\">mut<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"n\">ServiceConfig<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">let<\/span> <span class=\"n\">schema<\/span> <span class=\"o\">=<\/span> <span class=\"nn\">std<\/span><span class=\"p\">::<\/span><span class=\"nn\">sync<\/span><span class=\"p\">::<\/span><span class=\"nn\">Arc<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"nn\">Schema<\/span><span class=\"p\">::<\/span><span class=\"nf\">new<\/span><span class=\"p\">(<\/span><span class=\"n\">Query<\/span><span class=\"p\">,<\/span> <span class=\"n\">Mutation<\/span><span class=\"p\">));<\/span>\r\n\r\n    <span class=\"n\">config<\/span>\r\n        <span class=\"nf\">.data<\/span><span class=\"p\">(<\/span><span class=\"n\">schema<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">.route<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\/\"<\/span><span class=\"p\">,<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"nf\">post<\/span><span class=\"p\">()<\/span><span class=\"nf\">.to_async<\/span><span class=\"p\">(<\/span><span class=\"n\">graphql<\/span><span class=\"p\">))<\/span>\r\n        <span class=\"nf\">.route<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\/\"<\/span><span class=\"p\">,<\/span> <span class=\"nn\">web<\/span><span class=\"p\">::<\/span><span class=\"nf\">get<\/span><span class=\"p\">()<\/span><span class=\"nf\">.to<\/span><span class=\"p\">(<\/span><span class=\"n\">playground<\/span><span class=\"p\">));<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<h2>\u4f7f\u6211\u80fd\u591f\u6ce8\u518c<\/h2>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/graphql.rs b\/src\/graphql.rs\r\nindex 8283c78..b1aab68 100644\r\n<\/span><span class=\"gd\">--- a\/src\/graphql.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/graphql.rs\r\n<\/span><span class=\"p\">@@ -56,8 +56,9 @@<\/span> impl MutationFields for Mutation {\r\n         trail: &amp;QueryTrail&lt;'_, User, Walked&gt;,\r\n         name: String,\r\n         tags: Vec&lt;String&gt;,\r\n<span class=\"gi\">+        companies: Vec&lt;String&gt;,\r\n<\/span>     ) -&gt; FieldResult&lt;User&gt; {\r\n<span class=\"gd\">-        use crate::schema::{tags, users};\r\n<\/span><span class=\"gi\">+        use crate::schema::{companies, employments, tags, users};\r\n<\/span>\r\n         let new_user = models::NewUser { name: name };\r\n\r\n@@ -74,6 +75,32 @@ impl MutationFields for Mutation {\r\n                     diesel::insert_into(tags::table)\r\n                         .values(&amp;values)\r\n                         .execute(&amp;executor.context().db_con)?;\r\n<span class=\"gi\">+\r\n+                    companies\r\n+                        .into_iter()\r\n+                        .map(|company_name| {\r\n+                            let company = companies::table\r\n+                                .filter(companies::name.eq(&amp;company_name))\r\n+                                .first::&lt;models::Company&gt;(&amp;executor.context().db_con)\r\n+                                .optional()?;\r\n+\r\n+                            let company = match company {\r\n+                                Some(x) =&gt; x,\r\n+                                _ =&gt; diesel::insert_into(companies::table)\r\n+                                    .values(companies::name.eq(&amp;company_name))\r\n+                                    .get_result::&lt;models::Company&gt;(&amp;executor.context().db_con)?,\r\n+                            };\r\n+\r\n+                            diesel::insert_into(employments::table)\r\n+                                .values((\r\n+                                    employments::user_id.eq(&amp;user.id),\r\n+                                    employments::company_id.eq(&amp;company.id),\r\n+                                ))\r\n+                                .execute(&amp;executor.context().db_con)?;\r\n+\r\n+                            Ok(company)\r\n+                        })\r\n+                        .collect::&lt;Result&lt;Vec&lt;_&gt;, diesel::result::Error&gt;&gt;()?;\r\n<\/span>                     Ok(user)\r\n                 })\r\n         })?;\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/schema.graphql b\/src\/schema.graphql\r\nindex fbd22cf..7b3df25 100644\r\n<\/span><span class=\"gd\">--- a\/src\/schema.graphql\r\n<\/span><span class=\"gi\">+++ b\/src\/schema.graphql\r\n<\/span><span class=\"p\">@@ -11,6 +11,7 @@<\/span> type Mutation {\r\n   createUser(\r\n     name: String!\r\n     tags: [String!]!\r\n<span class=\"gi\">+    companies: [String!]!\r\n<\/span>   ): User! @juniper(ownership: \"owned\")\r\n }\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">mutation<\/span> <span class=\"p\">{<\/span>\r\n  <span class=\"n\">createUser<\/span><span class=\"p\">(<\/span><span class=\"n\">name<\/span><span class=\"p\">:<\/span><span class=\"s2\">\"hoge3\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">tags<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"tag4\"<\/span><span class=\"p\">],<\/span> <span class=\"n\">companies<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span><span class=\"s2\">\"Apple\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"Amazon\"<\/span><span class=\"p\">])<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">tags<\/span> <span class=\"p\">{<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">},<\/span> <span class=\"n\">companies<\/span> <span class=\"p\">{<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span><span class=\"p\">}<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u4e00\u4e9b\u6ce8\u518c<\/p>\n<pre class=\"post-pre\"><code><span class=\"p\">{<\/span>\r\n  <span class=\"nl\">\"data\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nl\">\"users\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"1\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"tags\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"1\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag1\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">],<\/span>\r\n        <span class=\"nl\">\"companies\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[]<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"2\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge2\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"tags\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"2\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag2\"<\/span>\r\n          <span class=\"p\">},<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"3\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag3\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">],<\/span>\r\n        <span class=\"nl\">\"companies\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[]<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"3\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge2\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"tags\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"4\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag2\"<\/span>\r\n          <span class=\"p\">},<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"5\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag3\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">],<\/span>\r\n        <span class=\"nl\">\"companies\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"1\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"Google\"<\/span>\r\n          <span class=\"p\">},<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"2\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"Amazon\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">]<\/span>\r\n      <span class=\"p\">},<\/span>\r\n      <span class=\"p\">{<\/span>\r\n        <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"4\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"hoge3\"<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"nl\">\"tags\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"6\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"tag4\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">],<\/span>\r\n        <span class=\"nl\">\"companies\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"3\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"Apple\"<\/span>\r\n          <span class=\"p\">},<\/span>\r\n          <span class=\"p\">{<\/span>\r\n            <span class=\"nl\">\"id\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"2\"<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"nl\">\"name\"<\/span><span class=\"p\">:<\/span> <span class=\"s2\">\"Amazon\"<\/span>\r\n          <span class=\"p\">}<\/span>\r\n        <span class=\"p\">]<\/span>\r\n      <span class=\"p\">}<\/span>\r\n    <span class=\"p\">]<\/span>\r\n  <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u770b\u8d77\u6765\u53ef\u4ee5\u62ff\u8d70<\/p>\n<h2>\u67e5\u770bPostgreSQL\u65e5\u5fd7<\/h2>\n<pre class=\"post-pre\"><code>postgres    | 2019-11-27 15:53:32.015 UTC [161] LOG:  execute __diesel_stmt_1: SELECT \"users\".\"id\", \"users\".\"name\" FROM \"users\"\r\npostgres    | 2019-11-27 15:53:32.017 UTC [161] LOG:  execute &lt;unnamed&gt;: SELECT \"tags\".\"id\", \"tags\".\"user_id\", \"tags\".\"name\" FROM \"tags\" WHERE \"tags\".\"user_id\" IN ($1, $2, $3, $4)\r\npostgres    | 2019-11-27 15:53:32.017 UTC [161] DETAIL:  parameters: $1 = '1', $2 = '2', $3 = '3', $4 = '4'\r\npostgres    | 2019-11-27 15:53:32.019 UTC [161] LOG:  execute &lt;unnamed&gt;: SELECT \"employments\".\"id\", \"employments\".\"user_id\", \"employments\".\"company_id\" FROM \"employments\" WHERE \"employments\".\"user_id\" IN ($1, $2, $3, $4)\r\npostgres    | 2019-11-27 15:53:32.019 UTC [161] DETAIL:  parameters: $1 = '1', $2 = '2', $3 = '3', $4 = '4'\r\npostgres    | 2019-11-27 15:53:32.021 UTC [161] LOG:  execute &lt;unnamed&gt;: SELECT \"companies\".\"id\", \"companies\".\"name\" FROM \"companies\" WHERE \"companies\".\"id\" IN ($1, $2, $3, $4)\r\npostgres    | 2019-11-27 15:53:32.021 UTC [161] DETAIL:  parameters: $1 = '1', $2 = '2', $3 = '3', $4 = '2'\r\n<\/code><\/pre>\n<p>\u6211\u4eec\u53ef\u4ee5\u770b\u51fa\uff0c\u7528\u6237\u5206\u522b\u67e5\u8be2\u4e86\u5c31\u4e1a\u548c\u516c\u53f8\u76f8\u5173\u7684\u4fe1\u606f\u3002<\/p>\n<h1>\u4f7f\u7528HasManyThrough\u5173\u7cfb\u8fde\u63a5\u5e76\u901a\u8fc7HasMany\u8fdb\u884c\u83b7\u53d6<\/h1>\n<p>\u7531\u4e8eHasManyThrough\u65e0\u6cd5\u8fdb\u884cjoin\u53d6\u503c\uff0c\u6240\u4ee5\u9700\u8981\u591a\u8fdb\u884c\u4e00\u6b21\u65e0\u6548\u7684\u67e5\u8be2\u3002<br \/>\n\u5728\u672c\u4f8b\u4e2d\uff0cEmployment\u6ca1\u6709\u6709\u610f\u4e49\u7684\u6570\u636e\uff0c\u56e0\u6b64\u5728GraphQL\u4e2d\u4e0d\u4f1a\u51fa\u73b0Employment\u3002<br \/>\n\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6211\u4eec\u5e0c\u671b\u901a\u8fc7join\u4e00\u6b21\u6027\u53d6\u503c\uff0c\u6240\u4ee5\u5c1d\u8bd5\u8fdb\u884c\u4e86\u64cd\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/graphql.rs b\/src\/graphql.rs\r\nindex b1aab68..c9decf7 100644\r\n<\/span><span class=\"gd\">--- a\/src\/graphql.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/graphql.rs\r\n<\/span><span class=\"p\">@@ -6,7 +6,7 @@<\/span> use futures01::future::Future;\r\n\r\n use juniper::http::playground::playground_source;\r\n use juniper::{http::GraphQLRequest, Executor, FieldResult};\r\n<span class=\"gd\">-use juniper_eager_loading::{prelude::*, EagerLoading, HasMany, HasManyThrough};\r\n<\/span><span class=\"gi\">+use juniper_eager_loading::{prelude::*, EagerLoading, HasMany};\r\n<\/span> use juniper_from_schema::graphql_schema_from_file;\r\n\r\n use diesel::prelude::*;\r\n<span class=\"p\">@@ -119,8 +119,8 @@<\/span> pub struct User {\r\n     #[has_many(root_model_field = tag)]\r\n     tags: HasMany&lt;Tag&gt;,\r\n\r\n-    #[has_many_through(join_model = models::Employment)]\r\n<span class=\"gd\">-    companies: HasManyThrough&lt;Company&gt;,\r\n<\/span><span class=\"gi\">+    #[has_many(root_model_field = company)]\r\n+    companies: HasMany&lt;CompanyWithUser&gt;,\r\n<\/span> }\r\n\r\n impl UserFields for User {\r\n<span class=\"p\">@@ -143,8 +143,8 @@<\/span> impl UserFields for User {\r\n     fn field_companies(\r\n         &amp;self,\r\n         _: &amp;Executor&lt;'_, Context&gt;,\r\n<span class=\"gd\">-        _: &amp;QueryTrail&lt;'_, Company, Walked&gt;,\r\n-    ) -&gt; FieldResult&lt;&amp;Vec&lt;Company&gt;&gt; {\r\n<\/span><span class=\"gi\">+        _: &amp;QueryTrail&lt;'_, CompanyWithUser, Walked&gt;,\r\n+    ) -&gt; FieldResult&lt;&amp;Vec&lt;CompanyWithUser&gt;&gt; {\r\n<\/span>         self.companies.try_unwrap().map_err(Into::into)\r\n     }\r\n }\r\n<span class=\"p\">@@ -171,11 +171,11 @@<\/span> impl TagFields for Tag {\r\n\r\n #[derive(Debug, Clone, PartialEq, EagerLoading)]\r\n #[eager_loading(context = Context, error = diesel::result::Error)]\r\n<span class=\"gd\">-pub struct Company {\r\n-    company: models::Company,\r\n<\/span><span class=\"gi\">+pub struct CompanyWithUser {\r\n+    company: models::CompanyWithUser,\r\n<\/span> }\r\n\r\n-impl CompanyFields for Company {\r\n<span class=\"gi\">+impl CompanyWithUserFields for CompanyWithUser {\r\n<\/span>     fn field_id(&amp;self, _: &amp;Executor&lt;'_, Context&gt;) -&gt; FieldResult&lt;juniper::ID&gt; {\r\n         Ok(juniper::ID::new(self.company.id.to_string()))\r\n     }\r\n<span class=\"p\">@@ -201,23 +201,7 @@<\/span> impl juniper_eager_loading::LoadFrom&lt;models::User&gt; for models::Tag {\r\n     }\r\n }\r\n\r\n-impl juniper_eager_loading::LoadFrom&lt;models::Employment&gt; for models::Company {\r\n<span class=\"gd\">-    type Error = diesel::result::Error;\r\n-    type Context = Context;\r\n-\r\n-    fn load(\r\n-        employments: &amp;[models::Employment],\r\n-        _field_args: &amp;(),\r\n-        context: &amp;Self::Context,\r\n-    ) -&gt; Result&lt;Vec&lt;models::Company&gt;, Self::Error&gt; {\r\n-        use crate::schema::companies;\r\n-        companies::table\r\n-            .filter(companies::id.eq_any(employments.iter().map(|x| x.company_id).collect_vec()))\r\n-            .load::&lt;models::Company&gt;(&amp;context.db_con)\r\n-    }\r\n-}\r\n-\r\n-impl juniper_eager_loading::LoadFrom&lt;models::User&gt; for models::Employment {\r\n<\/span><span class=\"gi\">+impl juniper_eager_loading::LoadFrom&lt;models::User&gt; for models::CompanyWithUser {\r\n<\/span>     type Error = diesel::result::Error;\r\n     type Context = Context;\r\n\r\n@@ -225,11 +209,21 @@ impl juniper_eager_loading::LoadFrom&lt;models::User&gt; for models::Employment {\r\n         users: &amp;[models::User],\r\n         _field_args: &amp;(),\r\n         context: &amp;Self::Context,\r\n<span class=\"gd\">-    ) -&gt; Result&lt;Vec&lt;models::Employment&gt;, Self::Error&gt; {\r\n-        use crate::schema::employments;\r\n-        employments::table\r\n-            .filter(employments::user_id.eq_any(users.iter().map(|x| x.id).collect_vec()))\r\n-            .load::&lt;models::Employment&gt;(&amp;context.db_con)\r\n<\/span><span class=\"gi\">+    ) -&gt; Result&lt;Vec&lt;models::CompanyWithUser&gt;, Self::Error&gt; {\r\n+        use crate::schema::{companies, employments, users};\r\n+        companies::table\r\n+            .inner_join(employments::table.inner_join(users::table))\r\n+            .filter(users::id.eq_any(users.iter().map(|x| x.id).collect_vec()))\r\n+            .load::&lt;(models::Company, (models::Employment, models::User))&gt;(&amp;context.db_con)\r\n+            .map(|data| {\r\n+                data.into_iter()\r\n+                    .map(|(company, (_, user))| models::CompanyWithUser {\r\n+                        id: company.id,\r\n+                        user_id: user.id,\r\n+                        name: company.name,\r\n+                    })\r\n+                    .collect_vec()\r\n+            })\r\n<\/span>     }\r\n }\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/models.rs b\/src\/models.rs\r\nindex bec0a13..43e2077 100644\r\n<\/span><span class=\"gd\">--- a\/src\/models.rs\r\n<\/span><span class=\"gi\">+++ b\/src\/models.rs\r\n<\/span><span class=\"p\">@@ -25,6 +25,13 @@<\/span> pub struct Company {\r\n     pub name: String,\r\n }\r\n\r\n+#[derive(Queryable, Clone, PartialEq, Debug)]\r\n<span class=\"gi\">+pub struct CompanyWithUser {\r\n+    pub id: i32,\r\n+    pub user_id: i32,\r\n+    pub name: String,\r\n+}\r\n+\r\n<\/span> #[derive(Queryable, Clone, PartialEq, Debug)]\r\n pub struct Employment {\r\n     pub id: i32,\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"gh\">diff --git a\/src\/schema.graphql b\/src\/schema.graphql\r\nindex 7b3df25..0700cdd 100644\r\n<\/span><span class=\"gd\">--- a\/src\/schema.graphql\r\n<\/span><span class=\"gi\">+++ b\/src\/schema.graphql\r\n<\/span><span class=\"p\">@@ -19,7 +19,7 @@<\/span> type User {\r\n   id: ID! @juniper(ownership: \"owned\")\r\n   name: String!\r\n   tags: [Tag!]!\r\n<span class=\"gd\">-  companies: [Company!]!\r\n<\/span><span class=\"gi\">+  companies: [CompanyWithUser!]!\r\n<\/span> }\r\n\r\n type Tag {\r\n<span class=\"p\">@@ -28,7 +28,7 @@<\/span> type Tag {\r\n   name: String!\r\n }\r\n\r\n-type Company {\r\n<span class=\"gi\">+type CompanyWithUser {\r\n<\/span>   id: ID! @juniper(ownership: \"owned\")\r\n   name: String!\r\n }\r\n<\/code><\/pre>\n<p>\u6211\u505a\u8fc7\u7684\u4e8b\u5927\u81f4\u5982\u4e0b\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">LoadFrom\u3067User-&gt;Company\u3092\u5f15\u3051\u308b\u3088\u3046\u306b\u3057\u305f<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Company\u3092eager_laod\u3057\u305f\u5f8c\u306buser\u306b\u632f\u308a\u5206\u3051\u308b\u305f\u3081\u306b\u3001Company\u306buser_id\u3092\u6301\u3063\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308b\u3088\u3046\u3060\u3063\u305f\u306e\u3067\u3001CompanyWithUser\u3068\u3044\u3046\u65b0\u3057\u3044\u5165\u308c\u7269\u3092\u4f5c\u3063\u305f<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">juniper_eager_load\u3067\u306fGraphQL\u306etype\u540d\u3068\u30e2\u30c7\u30eb\u306e\u540d\u524d\u304c\u4e00\u81f4\u3057\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308b\u3088\u3046\u306a\u306e\u3067\u3001GraphQL\u306e\u5b9a\u7fa9\u3092\u5909\u66f4\u3057\u305f<\/ul>\n<h2>\u67e5\u770bPostgreSQL\u7684\u65e5\u5fd7<\/h2>\n<pre class=\"post-pre\"><code>postgres    | 2019-11-27 16:22:39.223 UTC [198] LOG:  execute __diesel_stmt_0: SELECT \"users\".\"id\", \"users\".\"name\" FROM \"users\"\r\npostgres    | 2019-11-27 16:22:39.228 UTC [198] LOG:  execute &lt;unnamed&gt;: SELECT \"tags\".\"id\", \"tags\".\"user_id\", \"tags\".\"name\" FROM \"tags\" WHERE \"tags\".\"user_id\" IN ($1, $2, $3, $4)\r\npostgres    | 2019-11-27 16:22:39.228 UTC [198] DETAIL:  parameters: $1 = '1', $2 = '2', $3 = '3', $4 = '4'\r\npostgres    | 2019-11-27 16:22:39.237 UTC [198] LOG:  execute &lt;unnamed&gt;: SELECT \"companies\".\"id\", \"companies\".\"name\", \"employments\".\"id\", \"employments\".\"user_id\", \"employments\".\"company_id\", \"users\".\"id\", \"users\".\"name\" FROM (\"companies\" INNER JOIN (\"employments\" INNER JOIN \"users\" ON \"employments\".\"user_id\" = \"users\".\"id\") ON \"employments\".\"company_id\" = \"companies\".\"id\") WHERE \"users\".\"id\" IN ($1, $2, $3, $4)\r\npostgres    | 2019-11-27 16:22:39.237 UTC [198] DETAIL:  parameters: $1 = '1', $2 = '2', $3 = '3', $4 = '4'\r\n<\/code><\/pre>\n<p>\u51cf\u5c11\u4e86\u4e00\u4e2a\u67e5\u8be2\u3002<\/p>\n<h1>\u603b\u7ed3<\/h1>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">GraphQL\u4fbf\u5229<\/ul>\n<\/li>\n<\/ul>\n<p>\u5358\u4e00\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306b\u306a\u308b\u306e\u3067\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u306a\u3069\u3001\u3084\u308a\u306b\u304f\u3044\u90e8\u5206\u306f\u3042\u308a\u305d\u3046<\/p>\n<p>eager_load\u306f\u3067\u304d\u308b<\/p>\n<p>juniper_eager_load\u306f\u3044\u308d\u3044\u308d\u5236\u7d04\u304c\u3042\u308b<br \/>\n\u30e2\u30c7\u30eb\u306fmodels\u3068\u3044\u3046module\u306b\u3057\u306a\u304d\u3083\u3044\u3051\u306a\u3044<br \/>\n\u30e2\u30c7\u30eb\u540d\u3068GraphQL\u306etype\u540d\u306f\u540c\u3058\u3067\u3042\u308b\u5fc5\u8981\u304c\u3042\u308b<\/p>\n<p>\u30d9\u30f3\u30c1\u30de\u30fc\u30af\u3068\u3063\u3066\u307f\u305f\u3044<br \/>\n\u8a8d\u8a3c\u5468\u308a\u306factix-web\u306a\u3069\u3001web\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u5c64\u3067\u3084\u308c\u305d\u3046<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7528Rust\u6765\u6784\u5efaGraphQL API\u8fdb\u884c\u4e86\u4e00\u9879\u7b80\u8981\u8c03\u67e5\u7684\u7b14\u8bb0\u3002 \u73af\u5883 Rust: 1.39 &nbsp; J [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-48053","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL - 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\u4f7f\u7528rust-juniper-diesel-actix-web\u8fdb\u884cgraphql\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL\" \/>\n<meta property=\"og:description\" content=\"\u7528Rust\u6765\u6784\u5efaGraphQL API\u8fdb\u884c\u4e86\u4e00\u9879\u7b80\u8981\u8c03\u67e5\u7684\u7b14\u8bb0\u3002 \u73af\u5883 Rust: 1.39 &nbsp; J [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u4f7f\u7528rust-juniper-diesel-actix-web\u8fdb\u884cgraphql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-09T03:55:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T05:37:18+00:00\" \/>\n<meta name=\"author\" content=\"\u96c5, \u609f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u96c5, \u609f\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"26 \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%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/\",\"name\":\"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2024-02-09T03:55:33+00:00\",\"dateModified\":\"2024-04-29T05:37:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL\"}]},{\"@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\/f044a4b7fa4ee2701702942002419ca6\",\"name\":\"\u96c5, \u609f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"caption\":\"\u96c5, \u609f\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL - 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\u4f7f\u7528rust-juniper-diesel-actix-web\u8fdb\u884cgraphql\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL","og_description":"\u7528Rust\u6765\u6784\u5efaGraphQL API\u8fdb\u884c\u4e86\u4e00\u9879\u7b80\u8981\u8c03\u67e5\u7684\u7b14\u8bb0\u3002 \u73af\u5883 Rust: 1.39 &nbsp; J [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u4f7f\u7528rust-juniper-diesel-actix-web\u8fdb\u884cgraphql\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2024-02-09T03:55:33+00:00","article_modified_time":"2024-04-29T05:37:18+00:00","author":"\u96c5, \u609f","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u96c5, \u609f","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"26 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/","name":"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2024-02-09T03:55:33+00:00","dateModified":"2024-04-29T05:37:18+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c1d\u8bd5\u4f7f\u7528[Rust] juniper + diesel + actix-web\u8fdb\u884cGraphQL"}]},{"@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\/f044a4b7fa4ee2701702942002419ca6","name":"\u96c5, \u609f","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","caption":"\u96c5, \u609f"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8rust-juniper-diesel-actix-web%e8%bf%9b%e8%a1%8cgraphql\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/48053","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=48053"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/48053\/revisions"}],"predecessor-version":[{"id":85592,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/48053\/revisions\/85592"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=48053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=48053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=48053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}