{"id":94148,"date":"2020-04-26T03:01:28","date_gmt":"2020-04-25T19:01:28","guid":{"rendered":"http:\/\/4563.org\/?p=94148"},"modified":"2020-04-26T03:01:28","modified_gmt":"2020-04-25T19:01:28","slug":"%e5%90%8e%e7%ab%af%e8%a6%81%e6%b1%82%e5%89%8d%e7%ab%af%e4%bc%a0%e7%9a%84%e6%9f%a5%e8%af%a2%e5%8f%82%e6%95%b0","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=94148","title":{"rendered":"\u540e\u7aef\u8981\u6c42\u524d\u7aef\u4f20\u7684\u67e5\u8be2\u53c2\u6570"},"content":{"rendered":"
\n
\n
\n

\u540e\u7aef\u8981\u6c42\u524d\u7aef\u4f20\u7684\u67e5\u8be2\u53c2\u6570 <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : zycojamie <\/span> <\/i> 92<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u6bd4\u5982\uff0c\u4f60\u8f93\u5165\u4e00\u4e2a\u624b\u673a\u53f7\uff0c\u8fdb\u884c\u67e5\u8be2\uff0c\u8981\u628a\u4f60\u624b\u673a\u53f7\u7684\u503c\uff0c\u67e5\u8be2\u662f like \u8fd8\u662f=\uff0c\u6570\u636e\u662f string \u8fd8\u662f int\uff0c\u6a21\u7cca\u8fd8\u662f\u7cbe\u51c6\u67e5\u8be2\uff0c\u5168\u90e8\u524d\u7aef\u62fc\u7ed9\u540e\u7aef\u3002\u3002\u3002<\/p>\n

\u8fd9\u79cd\u65b9\u6848\u53ef\u884c\u5417\u3002\u3002\u3002<\/p>\n<\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (77<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : onepunch <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6a21\u7cca\u67e5\u8be2\u524d\u7aef\u505a <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : racecoder00 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e0d\u6015\u524d\u7aef\u4f20\u4e2a drop table? <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : dremy <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    SQL \u6ce8\u5165\u4e86\u89e3\u4e00\u4e0b\uff0c\u516c\u53f8\u5206\u5206\u949f\u5012\u95ed <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : opengps <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5173\u952e\u8bcd\uff0c\u548c\u662f\u5426 like\uff0c\u53ef\u4ee5\u4f20
    \u81f3\u4e8e string \u8fd8\u662f int \u5565\u610f\u601d\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Jooooooooo <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ef\u884c<\/p>\n

    \u5173\u6ce8\u4e00\u4e0b\u9632\u6ce8\u5165\u5c31\u884c<\/p>\n

    \u4e0d\u8fc7\u867d\u7136\u662f\u53ef\u884c, \u65b9\u6848\u4e0d\u5408\u7406\u554a, \u524d\u7aef\u5173\u5fc3\u7684\u662f”\u6a21\u7cca\u67e5\u8be2”\u800c\u4e0d\u662f”\u6a21\u7cca\u67e5\u8be2\u7528 like” <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : hedamao9999 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4f20\u4e00\u4e32\u5b57\u7b26\u4e32\uff0c\u5982\u679c\u672c\u8eab\u5176\u5b9e\u662f\u53ef\u4ee5\u7cbe\u786e\u5339\u914d\u5230\u7684\uff0c\u4f46\u662f\u67e5\u8be2\u4eba\u4ee5\u4e3a\u662f\u6a21\u7cca\u5339\u914d\u7684\uff0c\u56e0\u800c\u4f20\u7684\u662f like\uff0c\u540e\u7aef\u600e\u4e48\u5904\u7406\u5462\uff1f\u4e00\u4e32\u975e\u5e38\u957f\u7684\u6570\u5b57\uff0c\u672c\u6765\u5e94\u8be5\u662f\u5b57\u7b26\u4e32\u5f62\u5f0f\u5b58\u653e\u7684\uff0c\u67e5\u8be2\u4eba\u4ee5\u4e3a\u662f\u6570\u5b57\uff0c\u4f20\u7684\u662f int\uff0c\u6b64\u65f6\u53c8\u8be5\u600e\u4e48\u5904\u7406\u5462 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jatesun <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7b97\u4e86\uff0c\u8fd9\u79cd\u4e8b\u524d\u7aef\u5c31\u522b\u63fd\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : zycojamie <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \uff3b\uff07 tempMatchType \uff02: \uff02 5\uff0c4 \uff02\uff0c \uff02 propertyName \uff02: \uff02 name\uff0cmobile\uff0c \uff02 propertyvaluel \uff02: \uff02\uff0c13541218876 \uff02\uff09\uff0c
    \uff5b\uff02 tempMatchType \uff02: \uff02 7 \uff02\uff0c \uff02 propertyName \uff02: \uff02 age \uff02 \uff02 propertyvaluel \uff02: \uff02 12 \uff02\uff0c \uff02 tempType \uff02: \uff02 Integer \uff02\uff5d\uff0c
    tempMatchType \uff02: \uff02 11 \uff02\uff0c \uff02 propertyName \uff02: \uff02 role.id \uff02\uff0c \uff02 prepertyvalue1 \uff02: \uff02 1\uff0c2\uff0c3\uff0c4 \uff02\uff0c \uff02 tempType \uff02: \uff02 List \uff1c Long \uff1e\uff02\uff5d\uff3d
    \u7ffb\u8bd1\u6210 hql \uff1d where \uff08 name like \uff05\u5f20\u4e09\uff05\uff07 or mobile \uff1d 13541218876 and age \uff1e 12 and role.idin \uff08 1.2.3.4 \uff09<\/p>\n

    \u524d\u7aef\u5c31\u8981\u628a\u67e5\u8be2\u53c2\u6570\u5c01\u88c5\u6210\u4e0a\u9762\u90a3\u79cd\u6570\u7ec4 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : zycojamie <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @jatesun \u540e\u7aef\u67b6\u6784\u5e08\u8bf4\uff0c\u4e3a\u4e86\u4ed6\u4eec\u62dc\u6258\u5927\u91cf if else\uff0c\u6240\u4ee5\u8981\u6c42\u524d\u7aef\u6309\u7167\u4ed6\u4eec\u8ba2\u7684\u67e5\u8be2\u89c4\u5219\u5c01\u88c5\u8bf7\u6c42\u53c2\u6570\u3002\u3002\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : littleylv <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u89c9\u5f97\u4e3b\u7684\u610f\u601d\u5e76\u4e0d\u662f\u8bf4\u524d\u7aef\u8981\u62fc\u63a5\u597d \u2018mobile like ‘%123%’\u2019\u8fd9\u6837\u63d0\u4ea4\u7ed9\u540e\u7aef\uff0c\u800c\u662f\u4f7f\u7528
    {‘field’: ‘mobile’, ‘value’: ‘123’, ‘is_fuzzy’: true} \u8fd9\u6837\u4f20\u7ed9\u540e\u7aef\uff0c\u8ba9\u540e\u7aef\u53bb\u62fc\u63a5\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : loading <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5148\u5728\u624b\u673a\u53f7\u524d\u540e\u62fc\u63a5%\uff0c\u7136\u540e\u53c2\u6570\u67e5\u8be2\uff0c\u7528 like \u3002<\/p>\n

    \u5982\u679c\u6709\u6ce8\u5165\u98ce\u9669\uff0c\u8bf7\u5927\u4f6c\u4eec\u9a6c\u4e0a\u63d0\u9192\u6211\u3002 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : loading <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    sql \u53c2\u6570\u62fc\u63a5\u8fd8\u662f\u4e0d\u96be\u7684\uff0c\u6ca1\u51e0\u884c\u3002
    \u8c01\u90fd\u662f crud boy \u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : zycojamie <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @littleylv \u7c7b\u4f3c\uff0c\u4f46\u8981\u6c42\u66f4\u590d\u6742\u4e9b\uff08\u628a\u5927\u4e8e\u7b49\u4e8e\uff0c\u5c0f\u4e8e\uff0c\u5c0f\u4e8e\u7b49\u4e8e\uff0c\u7b49\u4e8e\uff09\u90fd\u7ea6\u5b9a\u597d\u662f\u4ec0\u4e48\u7279\u5b9a\u503c\uff0c\u7136\u540e\u524d\u7aef\u4f20\u53c2\u7684\u65f6\u5019\uff0c\u5c31\u8981\u4f20\uff08\u5927\u4e8e\u7b49\u4e8e\uff0c\u5c0f\u4e8e\uff0c\u5c0f\u4e8e\u7b49\u4e8e\uff0c\u7b49\u4e8e\uff09 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : littleylv <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @loading #11
    @loading #12 \u6ca1\u770b\u61c2\u4f60\u60f3\u8868\u8fbe\u4ec0\u4e48<\/p>\n

    @zycojamie #13 \u6211\u89c9\u5f97\u8fd9\u4e48\u505a\u633a\u597d\u7684\uff0c\u6ca1\u95ee\u9898 <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Rwing <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    GraphQL \u6b22\u8fce\u4f60 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : yukiloh <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u79cd\u63a5\u53e3\u522b\u88ab\u6211\u902e\u5230\uff0c\u4e0d\u7136\u5c31\u76f4\u63a5\u9001\u4f60\u51fa\u540d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : ZSeptember <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u4e0d\u662f\u5f88\u6b63\u5e38\u7684\u5417\uff0c\u96be\u9053\u4e0d\u540c\u7684\u67e5\u8be2\u5c31\u8981\u65b0\u589e\u52a0\u4e00\u4e2a\u63a5\u53e3\uff1f
    RESTful \u4e00\u822c\u53ea\u63d0\u4f9b\u4e00\u4e2a\u67e5\u8be2\u63a5\u53e3\uff0c\u53c2\u8003
    https:\/\/github.com\/Microsoft\/api-guidelines\/blob\/master\/Guidelines.md#971-filter-operations <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lancerly <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @zycojamie \u8fd9\u592a\u641e\u7b11\u4e86\u5427\uff0c\u524d\u7aef\u7684\u4ee3\u7801\u5c31\u4e0d\u9700\u8981\u6574\u6d01\u6027\u4e86\uff1f\u5c31\u53ef\u4ee5\u968f\u4fbf\u5199\u4e00\u5927\u5806 if else \u4e86\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wangxiaoaer <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @yukiloh #16 \u8fd9\u79cd\u63a5\u53e3\u6709\u4ec0\u4e48\u95ee\u9898\u5417\uff1f<\/p>\n

    \u5047\u5982\u4e00\u4e9b\u4e1a\u52a1\u7cfb\u7edf\u5c31\u662f\u5f88\u9700\u8981\u5f88\u7cbe\u786e\u7684\u67e5\u8be2\uff1a\u6bd4\u8f83\u3001\u7c7b\u522b\u3001\u6a21\u7cca \/\u7cbe\u786e\u5207\u6362\u7b49\u4f60\u600e\u4e48\u505a\uff1f\uff1f\uff1f <\/p>\n

    \u73b0\u5728\u540e\u7aef\u8981\u6c42\u662f\u524d\u7aef\u628a\u8fd9\u4e9b\u975e\u5e38\u7cbe\u7ec6\u7684\u6761\u4ef6\u4f20\u8fc7\u53bb\uff0c\u540e\u7aef\u7ffb\u8bd1\u6210 sql\uff0c\u53c8\u6ca1\u8ba9\u524d\u7aef\u76f4\u63a5\u62fc\u3001\u4f20 sql\uff0c\u53ea\u8981\u540e\u7aef\u5728\u751f\u6210 sql \u7684\u65f6\u5019\u505a\u597d\u9632\u6ce8\u5165\uff0c\u6709\u4ec0\u4e48\u95ee\u9898\uff1f <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : pap3r <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u524d\u7aef\u7238\u7238\u4e0d\u5e2e\u540e\u7aef\u513f\u5b50\u64e6\u5c41\u80a1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jziwenchen <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    graphql \u53ef\u4ee5\u4e86\u89e3\u770b\u770b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : sun1991 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8981\u533a\u5206\u5177\u4f53\u9700\u6c42\u662f\u4ec0\u4e48\u518d\u8c08\u5b9e\u73b0, \u4e0d\u8981\u4e00\u4e0a\u6765\u5c31\u4e00\u987f\u55b7…
    \u66fe\u7ecf\u505a\u8fc7\u7684\u7075\u6d3b\u53ef\u5b9a\u5236\u67e5\u8be2\u754c\u9762\u5927\u6982\u5c31\u662f\u8fd9\u6837\u7684\u5b9e\u73b0. <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lneoi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u6837\u5904\u7406\u592a\u7e41\u7410\u4e86\u5427 \u6709\u70b9\u50cf\u662f\u505a\u540e\u53f0\u7684\u5927\u91cf\u67e5\u8be2\u7684\u9700\u6c42 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : fumichael <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u50cf\u8fd9\u4e2a\u4e00\u6837\uff1f\u524d\u7aef\u53ef\u4ee5\u7ec4\u88c5\u67e5\u8be2\u6761\u4ef6\u5440
    \u4f46\u4e0d\u80fd\u540e\u7aef\u76f4\u63a5\u63a5\u6536\u524d\u7aef\u53c2\u6570\u4f5c\u4e3a sql \u8bed\u53e5
    \u6211\u60f3\u5230\u7684\u662f\uff0c\u53ef\u4ee5\u4f7f\u7528\u679a\u4e3e\u8fdb\u884c\u5904\u7406
    https:\/\/i.loli.net\/2020\/04\/17\/AfIQ4U7weZtDdSB.png <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : purensong <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    graphQL \u4e0d\u9519 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : cedoo22 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6ca1\u5b89\u5168\u89c4\u5219\u5417\uff1f\uff1f\uff1f\u8ba9\u524d\u7aef\u62fc\u3002\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : z1154505909 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u524d\u7aef\u62fc\u63a5????\u5934\u4e00\u6b21\u542c\u8bf4 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : CismonX <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7a81\u7136\u60f3\u8d77\u6765\u4e4b\u524d\u6211\u4eec\u5b66\u6821\u6709\u4e2a\u82f1\u8bed\u8bfe\u5728\u7ebf\u7b54\u9898\u7cfb\u7edf\uff0c\u524d\u7aef\u4f20\u7ed9\u540e\u7aef\u7684\u53c2\u6570\u662f\u4e00\u6761\u6761\u5b8c\u6574\u7684 SQL \u3002<\/p>\n

    \u6709\u597d\u4e8b\u8005\u8bd5\u7740\u4f20\u4e86\u4e2a DROP TABLE xxx\uff0c\u7136\u540e\u5c31\u6ca1\u6709\u7136\u540e\u4e86 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : zycojamie <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5b89\u5168\u7684\u8bdd\uff0c\u540e\u7aef\u8bf4\u4ed6\u4eec\u901a\u8fc7\u6846\u67b6\u5c42\u53bb\u6821\u9a8c\u548c\u62e6\u622a\uff0c\u524d\u7aef\u9700\u8981\u628a\u4f20\u7edf\u7684\u67e5\u8be2\u53c2\u6570\u7531\uff5b user\uff1a”\u5f20\u4e09”\uff5d\u53d8\u6210\uff5b user\uff1a\uff5b
    matchType\uff1a”1″\uff0c
    propertyName\uff1a”user”\uff0c
    propertyValue\uff1a”\u5f20\u4e09”\uff0c
    dataType\uff1a”string”
    \uff5d\uff5d
    matchType \u4e3a 1 \u4ee3\u8868\u201c\u5305\u542b\u201d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Erroad <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u524d\u7aef\u628a ui\u201c\u7ffb\u8bd1\u201d\u6210\u53c2\u6570\u8fd8\u662f\u5f88\u6b63\u5e38\u7684\uff0c\u62fc sql \u662f\u80af\u5b9a\u4e0d\u884c\u7684\uff0c\u8ba9\u524d\u7aef\u62fc sql \u7ed9\u540e\u7aef\u7684\u540e\u7aef\u90fd\u662f xx <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : littleylv <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @cedoo22 #26
    @z1154505909 #27
    \u4f60\u4eec\u5230\u5e95\u6709\u6ca1\u770b\u4ed4\u7ec6\u770b\u4e3b\u8bf4\u7684\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u65e0\u529b\u5410\u69fd <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wyz123723 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u73b0\u5728\u540e\u7aef\u771f\u662f\u8d8a\u6765\u8d8a\u70c2 \/\u61d2\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wellsc <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    graphql + 1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : 1et <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    string \u548c int \u786e\u5b9e\u6709\u70b9\u8ff7\uff0c\u4f20 like \u3001=\u6ca1\u4ec0\u4e48\u95ee\u9898\uff0c\u6bd4\u5982 name:3 \u9ed8\u8ba4\u7b49\u503c\u67e5\u8be2\uff0cname_like:3 \u662f\u6a21\u7cca\u67e5\u8be2 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : javapythongo <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u89c9\u5f97\u53ef\u4ee5 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : buffzty <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u5c31\u662f\u8fd9\u6837\u505a\u7684.\u5df2\u7ecf\u7528\u4e86\u4e00\u5e74\u591a\u4e86.\u5982\u679c\u9879\u76ee\u5f88\u5c0f,\u5f00\u53d1\u901f\u5ea6\u7b2c\u4e00\u53ef\u4ee5\u8bd5\u8bd5.\u7f3a\u70b9\u5c31\u662f\u53ea\u80fd\u666e\u901a\u67e5\u8be2,\u5982\u679c\u67e5\u8be2\u6709 join \u7684\u9700\u8981\u624b\u52a8\u5199\u89c4\u5219
    \u4e0b\u9762\u8fd9\u4e2a\u662f\u6211\u67e5\u8be2\u5217\u8868\u7684\u4e00\u4e2a\u901a\u7528\u65b9\u6cd5.\u65b0\u52a0\u4e00\u4e2a\u6a21\u578b\u53ea\u9700\u8981\u8bbe\u7f6e\u4e00\u4e0b model \u7c7b\u578b \u548c filter \u6620\u5c04\u548c order \u6620\u5c04
    \u7528\u8fd9\u5957\u63a5\u53e3\u901f\u5ea6\u8d77\u98de,\u4f46\u6709\u5c40\u9650\u6027
    “`php
    \/\/ Base controller
    public function lists(): Json
    {
    $json = new JsonRes();
    [$page, $limit, $filter, $order, $extra] = $this->getListParam();
    $scene = $extra[‘scene’] ?? $this->model::SCENE[‘default’];
    $where = $this->model::buildWhereMap($filter);
    $fmtOrder = $this->model::buildFmtOrder($order);
    if ( $scene === $this->model::SCENE[‘admin’] && !$this->isAdminUser() ) {
    return $this->noAuth();
    }
    [$list, $count] = $this->model::getListNotThrowEmptyEx($page, $limit,
    $this->model::NEED_COUNT, $where, [], $order);
    $fmtList = [];
    \/** @var appmodelBase $model *\/
    foreach ($list as $model) {
    $fmtList[] = $model->getFmtDetail($scene);
    }
    $json->setData([
    ‘list’ => $fmtList,
    ]);
    $json->setPage($page);
    $json->setLimit($limit);
    $json->setCount($count);
    return json($json);
    }<\/p>\n

    \/\/ Base Model
    \/**
    * \u6839\u636e filter \u6784\u5efa\u67e5\u8be2\u6761\u4ef6.
    *
    * @param array|null $filterList
    * @param array $filterFieldMapDbField
    * @return array
    *\/
    public static function buildWhereMap($filterList, array $filterFieldMapDbField =
    []): array
    {<\/p>\n

    $filterFieldMapDbField = empty($filterFieldMapDbField) ? static::FILTER_FIELD_MAP_DB_FIELD : $filterFieldMapDbField;
    $map = [];
    if ( !is_array($filterList) ) {
    return [];
    }
    foreach ($filterList as $filterField => $item) {
    if ( $item instanceof Closure ) {
    $map[] = $item;
    continue;
    }
    if ( !is_array($item) || !array_key_exists(‘condition’, $item)
    || !array_key_exists(‘val’, $item) ) {
    continue;
    }
    if ( $item[‘val’] === ” || $item[‘condition’] === Condition::TYPE[‘undefined’] ||
    !in_array($item[‘condition’], Condition::TYPE, true)
    ) {
    continue;
    }
    if ( !array_key_exists($filterField, $filterFieldMapDbField) ) {
    continue;
    }
    $dbField = $filterFieldMapDbField[$filterField];
    $condition = Condition::DB_CONDITION[$item[‘condition’]];
    $map[] = [
    $dbField, $condition, Condition::formatVal($item[‘condition’], $item[‘val’]),
    ];
    }<\/p>\n

    return $map;
    }
    “`
    \u524d\u7aef\u4ee3\u7801:
    “`typescript
    \/\/ \u4e00\u4e2a\u6a21\u578b\u53ea\u9700\u8981\u5b9a\u4e49\u4e0b\u9762\u8fd9\u4e9b \u5c31\u53ef\u4ee5\u4f7f\u7528\u901a\u7528\u589e\u5220\u6539\u67e5 5 \u4e2a\u63a5\u53e3\u4e86
    type Model = Expert
    const route = ‘\/expert’
    type FilterKeys =
    | ‘id’
    | ‘ctime’
    | ‘expertCode’
    | ‘name’
    | ‘userName’
    | ‘departmentId’
    | ‘orgCode’
    | ‘orgName’
    | ‘provCode’
    | ‘cityCode’
    | ‘countyCode’
    | ‘provName’
    | ‘cityName’
    | ‘countyName’
    | ‘level’
    | ‘intro’
    | ‘type’
    | ‘mobile’
    | ‘phone’
    | ’email’
    | ‘qq’
    | ‘wx’
    | ‘remark’
    | ‘serviceType’
    type OrderKeys = ‘id’ | ‘ctime’
    type Scene = ‘admin’ | ‘default’
    interface QueryExtra extends BaseExtra<Scene> {}
    type ActGetListParam = GetListParam<FilterKeys, OrderKeys, QueryExtra>
    type AddData = Omit<Model, ‘adeptLabelList’ | ‘department’ | ‘id’>
    type EditData = AddData & Pick<Model, ‘id’><\/p>\n

    export async function lists<T = Model>(data: ActGetListParam) {
    return bpost<{ list: T[] }>({
    url: route + ‘\/list’,
    data,
    })
    }
    “` <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : buffzty <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8c01\u80fd\u544a\u8bc9\u6211\u8fd9\u7834\u7ad9\u5230\u5e95\u600e\u4e48\u53d1\u4ee3\u7801? <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : baiyi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    GraphQL +10086 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : xgfan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u4e0d\u5c31\u662f\u90a3\u4e2a\u7537\u4eba\u7ecf\u5e38\u63a8\u5e7f\u7684\u573a\u666f\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : masker <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @pap3r \u4f60\u8fd9\u79cd\u4f18\u8d8a <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : vitoliu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u9632 sql \u6ce8\u5165\u7684\u5de5\u5177\u5f88\u591a\uff0c\u540e\u7aef\u968f\u4fbf\u5f15\u4e00\u4e0b\u5c31\u89e3\u51b3\u4e86\uff0c\u800c\u4e14\u7684\u786e\u80fd\u6446\u8131\u5927\u91cf\u7684\u5224\u7a7a\u548c if else \u3002
    \u53c2\u6570\u6df7\u6dc6\u5565\u7684\u4e5f\u90fd\u6ca1\u505a\uff0c\u800c\u4e14\u770b\u53c2\u6570\u540d\u5e94\u8be5\u662f B \u7aef\u7cfb\u7edf\u5427\uff0c\u7528\u6237\u91cf\u5c11\u8fd9\u4e48\u5e72\u7684\u786e\u4e5f\u6ca1\u5565\u95ee\u9898\u3002
    \u4e0d\u8fc7\u524d\u7aef\u4f20\u9a7c\u5cf0\u4e0d\u4f20\u4e0b\u5212\u7ebf\u7684\u786e\u8ba9\u6211\u611f\u89c9\u633a\u4e0d\u5f97\u52b2\u7684\u54c8\u54c8\u54c8\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : areless <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ef\u884c\uff0c\u5199\u4e86\u4e00\u5957\u8fd9\u6837\u7684\u524d\u540e\u7aef\uff0c\u672c\u6765\u60f3\u7528\u3002\u611f\u89c9\u90a3\u5c31\u6bcf\u5929\u6ca1\u4e8b\u5e72\uff0c\u76ef\u7740\u524d\u7aef\u5199 SQL \u5c31\u53ef\u4ee5\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : IGJacklove <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @ZSeptember \u611f\u89c9\u4e00\u4e2a\u63a5\u53e3\u548c\u8fd9\u4e2a\u4e5f\u6ca1\u5565\u5173\u7cfb\u5427\uff0c\u6362\u4e2a\u65b9\u5f0f\uff0c\u52a0\u4e2a\u679a\u4e3e\u4ec0\u4e48\u7684\u90fd\u6bd4\u524d\u7aef\u4f20 like \u5f3a\u5427 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Deffi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u662f\u79fb\u52a8\u7aef\uff0c\u8981\u662f\u8003\u8651\u7248\u672c\u8fed\u4ee3\uff0c\u903b\u8f91\u53d8\u66f4\uff0c\u6211\u4e0d\u4f1a\u7528\u8fd9\u79cd\u63a5\u53e3\u3002\u524d\u7aef\u5e94\u8be5\u5c3d\u91cf\u5c11\u505a\u903b\u8f91\u5904\u7406 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : red2dog <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    graphql ++ <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : guyeu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5728\u6709\u5f88\u591a\u590d\u6742\u67e5\u8be2\u7684\u573a\u666f\u4f7f\u7528\u81ea\u5df1\u7684 DSL \u4ee3\u66ff\u82e5\u5e72\u4e2a\u63a5\u53e3\u662f\u6709\u610f\u4e49\u7684\uff0c\u4f46\u9700\u8981\u6ce8\u610f\u7684\u662f\u4e0d\u5e94\u8be5\u8ba9\u524d\u7aef\u62fc SQL\uff0c\u800c\u4e14\u9700\u8981\u5bf9 DSL \u7684\u5e94\u7528\u8303\u56f4\u8fdb\u884c\u9650\u5236\uff0c\u6700\u597d\u662f\u4ece\u8bbe\u8ba1\u4e0a\u907f\u514d\u5371\u9669\u64cd\u4f5c\u7684\u53ef\u80fd\u6027\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : guyeu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e0d\u62fc SQL \u7684\u4e3b\u8981\u539f\u56e0\u662f\u8ba9\u6570\u636e\u5e93\u548c\u5ba2\u6237\u7aef\u89e3\u8026\uff0c\u56e0\u4e3a\u5728\u4e0d\u901a\u7684\u67b6\u6784\u6a21\u5f0f\u4e0b SQL \u7684\u5199\u6cd5\u53ef\u80fd\u6709\u8f83\u5927\u5dee\u5f02\uff0c\u8fd9\u4e0d\u5e94\u8be5\u5f71\u54cd\u5ba2\u6237\u7aef\u5b9e\u73b0\uff0c\u800c\u8868\u7ed3\u6784\u4e5f\u4e0d\u5e94\u8be5\u5bf9\u5ba2\u6237\u7aef\u900f\u660e\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : k9990009 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ef\u4ee5\u7684\uff0c\u4f46\u662f\u4e0d\u8981\u524d\u7aef\u62fc SQL \u3002\u4ee5\u524d\u6211\u4eec\u524d\u7aef\u4eba\u624b\u4e0d\u591f\uff0c\u524d\u7aef\u4e5f\u662f\u540e\u7aef\u5199\u7684\u3002\u81ea\u5b9a\u4e49\u53c2\u6570\u89e3\u6790\u3002\u7136\u540e\u540e\u7aef\u8c03\u7528\u6839\u636e\u5173\u952e\u5b57\uff0c\u8fd9\u4e2a\u5173\u952e\u5b57\u6b63\u597d\u662f mybatis plus \u7684\u65b9\u6cd5\u540d\uff0c\u901a\u8fc7\u53cd\u5c04\u8c03\u7528\u81ea\u52a8\u62fc\u3002\u540e\u7aef\u53ea\u8981\u7ee7\u627f\u9ed8\u8ba4\u5b9e\u73b0 CRUD \u5c31\u597d\u4e86\u3002\u6bd4\u5982\u524d\u7aef\u4f20 name_leftlike\uff0c\u53ea\u8981\u5199\u524d\u7aef\u5c31\u597d\u4e86\uff0c\u8d85\u723d\u3002\u540e\u7aef\u505a\u53c2\u6570\u8fc7\u6ee4\u5c31\u597d\u4e86\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : oatw <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @zycojamie \u4e0d\u8003\u8651\u540e\u7aef\u7684\u524d\u7aef\u548c\u4e0d\u8003\u8651\u524d\u7aef\u7684\u540e\u7aef\uff0c\u90fd\u662f\u4e1a\u4f59\u9009\u624b\u3002\u5c31\u50cf\u8fd9\u4e2a\u67b6\u6784\u5e08\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : randyo <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6d41\u91cf\u4e0d\u8981\u94b1\u5417\uff0c\u524d\u7aef\u4e3a\u4e86\u6446\u8131\u590d\u6742\u6570\u636e\u679c\u65ad\u629b\u56de\u53bb\u8ba9\u540e\u7aef\u81ea\u5df1\u5199 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : rioshikelong121 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u6837\u524d\u7aef\u4e5f\u5f97\u61c2\u8868\u7ed3\u6784\u4e86 \u800c\u4e14\u590d\u6742\u7684 sql \u600e\u4e48\u5904\u7406\u3002\u8fd8\u5f97\u5355\u72ec\u5199\u63a5\u53e3\u5427\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : kohos <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u79cd\u5982\u679c\u662f where \u540e\u9762\u5168\u90e8\u9760\u524d\u7aef\u63d0\u4f9b\u7684\u53c2\u6570\u751f\u6210\u7684\u8bdd\uff0c\u5f88\u4e0d\u5b89\u5168\uff0c\u4f8b\u5982\u4e3b\u7684\u63a5\u53e3\uff0c\u6539\u4e00\u4e0b roleId \u5c31\u80fd\u64cd\u4f5c\u5176\u4ed6\u89d2\u8272\u7684\u6570\u636e\u4e86\uff0c\u540e\u7aef\u60f3\u5077\u61d2\u4e5f\u4e0d\u662f\u8fd9\u6837\u505a\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : component <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    GraphQL \u4e86\u89e3\u4e00\u4e0b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jugelizi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ef\u884c
    \u4f46\u4e0d\u662f\u62fc\u63a5\u3002
    \u5e94\u8be5\u662f\u4f20 json k v \u6307\u5b9a\u67e5\u8be2\u7c7b\u578b \u4ee5\u53ca\u67e5\u8be2\u5185\u5bb9 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : MilletChili <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e00\u822c\u7684\u67e5\u8be2\uff0c\u6211\u90fd\u662f\u53eb\u524d\u7aef\u53bb\u62fc\u7684\uff0c\u867d\u7136\u6211\u5c31\u662f\u90a3\u4e2a\u524d\u7aef
    start_num = int(request.GET.get(‘start_num’) or 0) # \u8d77\u59cb\u6570
    get_num = int(request.GET.get(‘get_num’) or 10) # \u9700\u6c42\u6570
    filters = request.GET.get(‘filters’) # \u7b5b\u9009\u6761\u4ef6
    sorts = request.GET.get(‘sorts’) # \u6392\u5e8f\u6761\u4ef6
    want_fileds = request.GET.get(‘want_fileds’) # \u6307\u5b9a\u9700\u8981\u7684\u5b57\u6bb5
    is_distinct = request.GET.get(‘is_distinct’) # \u662f\u5426\u53bb\u91cd<\/p>\n

    qset = model.objects.using(using_database).all()<\/p>\n

    if filters:
    # print(‘\u7b5b\u9009\u6761\u4ef6\uff1a’,filters)
    qset = filterHelper(filters, qset)
    if sorts:
    # print(‘\u6392\u5e8f\u6761\u4ef6\uff1a’,sorts)
    qset = qset.order_by(*sorts.split(‘,’))
    if is_distinct == ‘yes’:
    qset = qset.distinct()<\/p>\n

    all_num = qset.count() # \u603b\u4e2a\u6570
    qset = qset[start_num: start_num + get_num]<\/p>\n

    if want_fileds:
    data_list = createSerializers(model, want_fileds.split(‘,’))(qset, many=True).data
    else:
    data_list = Ser_L(qset, many=True).data
    data = {‘all_num’: all_num, ‘data_list’: data_list} <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : CEBBCAT <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @buffzty #36 \/t\/663565 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wushigejiajia01 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e3b\u5927\u81f4\u610f\u601d: \u524d\u7aef\u4f20\u53c2\uff0c\u8981\u628a\u53c2\u6570\u7c7b\u578b\uff0c\u4ee5\u53ca\u67e5\u8be2\u8303\u56f4\u90fd\u4f20\u7ed9\u540e\u7aef\uff0c\u8fd9\u6837\u540e\u7aef\u80fd\u628a\u63a5\u53e3\u505a\u7684\u5f88\u7075\u6d3b\u591a\u7528<\/p>\n

    \u5e94\u8be5\u662f\u8fd9\u4e2a\u610f\u601d\u5427\uff1f<\/p>\n

    \u53ea\u8981\u4e0d\u662f\u7531\u524d\u7aef\u62fc\u63a5 SQL\uff0c\u8fd9\u6ca1\u5565\u95ee\u9898\u554a <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : shadeofgod <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u5c4a\u540e\u7aef\u8fd8\u662f\u4e0d\u884c <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : jswh <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u7ba1\u7406\u540e\u53f0\u53ef\u4ee5\uff0c\u4ea7\u54c1\u4e2d\u6700\u597d\u4e0d\u8981\u3002\u8fd9\u4e8b\u6211\u4e5f\u5e72\u8fc7\uff0c\u672c\u8d28\u4e0a\u53ef\u6240\u8c13\u7684 restful \u6216\u8005 graphql \u7684\u60f3\u6cd5\u662f\u4e00\u6837\u7684\uff0c\u5c31\u662f\u5b9a\u4e49\u4e00\u5957\u81ea\u5df1\u7684 DSL \u514d\u5f97\u8001\u662f\u505a\u76f8\u540c\u7684\u4e8b\u60c5\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lizhuoli <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u91cd\u65b0\u81ea\u5df1\u5b9e\u73b0\u4e00\u4e2a\u5783\u573e\u7248\u672c GraphQL \uff1f\u610f\u4e49\u4f55\u5728 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : hooopo <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    graphql \u4e86\u89e3\u4e00\u4e0b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : puilu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u5c4a\u540e\u7aef\u4e0d\u884c <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : hq136234303 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @zycojamie \u4f60\u4eec\u67b6\u6784\u5e08\u771f\u7684\u53ef\u7231\u3002\u5982\u679c\u662f\u524d\u7aef\u52a0\u5bc6\u505a\u7684\u8bdd \u7ec8\u6709\u4e00\u5929\u89e3\u5f00 sql \u6ce8\u5165 \u4f1a\u723d\u7684\u98de\u8d77\u7684\u3002\u3002\u3002\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : a1562619919 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6570\u636e\u91cf\u6781\u5c0f\u7684\u6a21\u7cca\u67e5\u8be2\u524d\u7aef\u505a\uff0c\u6bd4\u5982\u624b\u673a\u767b\u5f55\u5e10\u53f7\u3002\u4f46\u6570\u636e\u591a\u5230\u8d85\u8fc7\u51e0\u5341\u4e2a\u4e86\u660e\u663e\u524d\u7aef\u4e0d\u8be5\u5904\u7406\uff0c\u6216\u8005\u6d89\u53ca\u4e1a\u52a1\u7684\u6570\u636e\u5c3d\u91cf\u4e0d\u8ba9\u524d\u7aef\u5904\u7406\uff0c\u524d\u7aef\u53ef\u4ee5\u6a21\u7cca\u67e5\u8be2\u4e00\u4e0b\u4e2a\u4eba\u975e\u4e1a\u52a1\u7684\u7f13\u5b58\u6570\u636e\uff08\u4e2a\u4eba\u59d3\u540d\u624b\u673a\u53f7\u8fd9\u79cd\uff09 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : icy37785 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    GraphQL + 10086 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : bllue <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u67b6\u6784\u5e08\u5e94\u8be5\u62ce\u5f97\u6e05
    \u53ea\u8981\u907f\u514d\u524d\u7aef\u62fc\u63a5\u540e\u7aef\u62ff\u6765\u76f4\u63a5\u7528\u7684\u60c5\u51b5 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Jrue0011 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @zycojamie \u8fd9\u79cd\u8bbe\u8ba1\u611f\u89c9\u548c DSL \u6709\u70b9\u50cf\uff0celastic search \u7684\u67e5\u8be2 api \u5c31\u662f\u7c7b\u4f3c\u7684\u8bbe\u8ba1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : yufeng0681 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u80fd\u60f3\u5230 \u524d\u7aef\u80fd\u62d2\u7edd\u7684\u7406\u7531\uff1a
    \u5982\u679c\u6709\u4e09\u4e2a\u7ec8\u7aef \u9700\u8981\u4f7f\u7528\u8fd9\u4e2a\u529f\u80fd\u3002 \u4e09\u4e2a\u7ec8\u7aef\u7684\u5f00\u53d1\u90fd\u8981\u61c2 SQL\uff0c\u90fd\u8981\u5b8c\u6574\u6d4b\u8bd5\uff0c\u4e0d\u5408\u7406\uff0c\u4e5f\u6d6a\u8d39\u6210\u672c\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : SyncWorld <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u76f4\u63a5\u4f20 SQL \u5c82\u4e0d\u662f\u7f8e\u5305\u5305~ <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : qce7 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4eec\u8fd9\u8fb9\u7528 Yii2 \u7684 DSL<\/p>\n

    \/\/ \u8fc7\u6ee4\u6761\u4ef6
    \/\/ \u8fc7\u6ee4\u6761\u4ef6\u6309\u9700\u4f7f\u7528\uff0c\u6ca1\u6709\u8fc7\u6ee4\u6761\u4ef6\u5c31\u4e0d\u4f20 filter
    “filter”: {
    \/\/ and \u8868\u793a “\u4e14”,\u4e5f\u652f\u6301 or,\u4f46\u662f\u5b9e\u9645\u4e1a\u52a1\u7528\u7684\u6bd4\u8f83\u5c11\u800c\u4e14\u6027\u80fd\u4e0d\u4f73 or \u4e0d\u5efa\u8bae\u4f7f\u7528
    “and”: [
    \/\/ like \u6761\u4ef6
    {“mobile”: {“like”: “1”}},
    \/\/ level = 1
    {“level”: 1},
    \/\/ \u8303\u56f4\u6761\u4ef6 id in [2, 5, 9]
    {“id”: {“in”: [2, 5, 9]}},
    \/\/ createdAt > 0
    {“createdAt”: {“gt”:0}},
    \/\/ createdAt < 10000000000
    {“createdAt”: {“lt”:10000000000}}
    ]
    }
    \/\/ \u6bcf\u9875\u8bb0\u5f55\u6570,\u540e\u7aef\u9ed8\u8ba4 10 \u6761
    “perPage”: 10,
    \/\/ \u8bf7\u6c42\u9875\u6570
    “page”: 1,
    \/\/ \u6392\u5e8f\u503c,\u4f18\u5148\u7ea7\u4ece\u524d\u5230\u540e\u201c-\u201d\u8868\u793a\u5012\u5e8f
    “sort”: “-isDefault,-isCertified,-id”
    } <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : SjwNo1 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    graphql \u5427\uff0csql \u4e0d\u5b89\u5168\u4e0d\u592a\u597d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : michaelcheng <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u590d\u6742\u7684\u67e5\u8be2\u4f20\u53c2\u8fd8\u662f\u53ef\u4ee5\u7684\uff0c\u4e0d\u4e00\u5b9a\u662f\u8981 sql ,\u8bed\u4e49\u5316\u7684\u4f20\u53c2\uff0c\u7ea6\u5b9a\u53c2\u6570\u7c7b\u578b\u3001\u8fd0\u7b97\u7b26\u3001\u503c\u7ea6\u675f\u7b49 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : a852695 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5982\u679c\u662f\u76f4\u63a5\u4f20 sql \u4e0d\u53ef\uff0c\u4f46\u662f\u73a9\u7740\u73a9\u7740\u5c31\u53d8\u6210\u4e86\u76f4\u63a5\u4f20 sql\uff0c\u4e0d\u4fe1\u8bd5\u8bd5\u770b\uff1f\u540e\u7aef\u5c1d\u5230\u4e86\u751c\u5934\u3002
    \u5982\u679c\u662f\u62fc\u7ea6\u5b9a\u5b57\u7b26\u4e32\u53ef\u4ee5\uff0c\u73a9\u7740\u73a9\u7740\uff0c\u81ea\u5df1\u90fd\u4e0d\u77e5\u9053\u7ea6\u5b9a\u4e86\u5565\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : onfuns <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u53ef\u884c\uff0c\u4e0d\u8fc7\u8fd9\u79cd\u65b9\u6848\u90fd\u662f\u7528\u5728\u5185\u7f51\u7684\u7cfb\u7edf\uff0c\u53ef\u4ee5\u51cf\u5c11\u5f88\u591a\u7684\u5de5\u4f5c\u91cf\u3002\u5916\u7f51\u7684\u5e94\u7528\u8fd8\u662f\u5e94\u8be5\u89c4\u89c4\u77e9\u77e9\u7684\uff0c\u73b0\u5728\u7684\u5b89\u5168\u53ef\u662f\u5f88\u654f\u611f\u4e86\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : royzxq <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u4e0d\u5c31\u662f\u4f20\u8bf4\u4e2d apiJSON \u7684\u573a\u666f\u5417\uff0c \u8ba9\u4f60\u4eec\u540e\u7aef\u7528\u554a\uff08 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : pap3r <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @masker \u540e\u7aef\u513f\u5b50\u8fde\u6570\u636e\u7c7b\u578b\u90fd\u8981\u524d\u7aef\u4f20 \u600e\u4e48\u4f18\u8d8a\u4e86\uff1f \u4f60\u5c31\u662f\u540e\u7aef\u513f\u5b50\u5427 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : masker <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @pap3r \u8bf4\u5b9e\u8bdd\u633a\u53ef\u601c\u4f60\u4eec\u8fd9\u79cd\u4f2a\u7269\u7406\u9609\u5272\u7684\u592a\u76d1\u7684\u5440\u3002\u3002\u3002\u81ea\u5df1\u751f\u80b2\u529f\u80fd\u4e0d\u884c\uff0c\u8fd8\u559c\u6b22\u5230\u5904\u53eb\u522b\u4eba\u513f\u5b50\u3002\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    \u540e\u7aef\u8981\u6c42\u524d\u7aef\u4f20\u7684\u67e5\u8be2\u53c2\u6570 \u8cc7\u6df1\u5927\u4f6c…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94148"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94148"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94148\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94148"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}