文章目錄
需求
一、環(huán)境
二、功能實(shí)現(xiàn)
1.搭建環(huán)境
2.文件內(nèi)容識別
三.代碼
需求
? ? ? ? 產(chǎn)品希望我們這邊能夠?qū)崿F(xiàn)用戶上傳PDF,WORD,TXT之內(nèi)得文本內(nèi)容,然后用戶可以根據(jù)附件名稱或文件內(nèi)容模糊查詢文件信息,并可以在線查看文件內(nèi)容
一、環(huán)境
? ? ? ? 項目開發(fā)環(huán)境:
????????????????后臺管理系統(tǒng)springboot+mybatis_plus+mysql+es
? ? ? ? ????????搜索引擎:elasticsearch7.9.3 +kibana圖形化界面
二、功能實(shí)現(xiàn)
1.搭建環(huán)境
? ? ? ? es+kibana的搭建這里就不介紹了,網(wǎng)上多的是
? ? ? ? 后臺程序搭建也不介紹,這里有一點(diǎn)很重要,Java使用的連接es的包的版本一定要和es的版本對應(yīng)上,不然你會有各種問題
2.文件內(nèi)容識別
? ? ? ?第一步: 要用es實(shí)現(xiàn)文本附件內(nèi)容的識別,需要先給es安裝一個插件:Ingest Attachment Processor Plugin(這知識一個內(nèi)容識別的插件,還有其它的例如OCR之類的其它插件,有興趣的可以去搜一下了解一下)
??Ingest Attachment Processor Plugin
是一個文本抽取插件,本質(zhì)上是利用了Elasticsearch
的ingest node
功能,提供了關(guān)鍵的預(yù)處理器attachment
。在安裝目錄下運(yùn)行以下命令即可安裝。
到es的安裝文件bin目錄下執(zhí)行
elasticsearch-plugin install ingest-attachment
? ? ? ? 因為我們這里es是使用docker安裝的,所以需要進(jìn)入到es的docker鏡像里面的bin目錄下安裝插件
[root@iZuf63d0pqnjrga4pi18udZ plugins]# docker exec -it es bash
[root@elasticsearch elasticsearch]# ls
LICENSE.txt NOTICE.txt README.asciidoc bin config data jdk lib logs modules plugins
[root@elasticsearch elasticsearch]# cd bin/
[root@elasticsearch bin]# ls
elasticsearch elasticsearch-certutil elasticsearch-croneval elasticsearch-env-from-file elasticsearch-migrate elasticsearch-plugin elasticsearch-setup-passwords elasticsearch-sql-cli elasticsearch-syskeygen x-pack-env x-pack-watcher-env
elasticsearch-certgen elasticsearch-cli elasticsearch-env elasticsearch-keystore elasticsearch-node elasticsearch-saml-metadata elasticsearch-shard elasticsearch-sql-cli-7.9.3.jar elasticsearch-users x-pack-security-env
[root@elasticsearch bin]# elasticsearch-plugin install ingest-attachment
-> Installing ingest-attachment
-> Downloading ingest-attachment from elastic
[=================================================] 100%??
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@ WARNING: plugin requires additional permissions @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
* java.lang.RuntimePermission accessClassInPackage.sun.java2d.cmm.kcms
* java.lang.RuntimePermission accessDeclaredMembers
* java.lang.RuntimePermission getClassLoader
* java.lang.reflect.ReflectPermission suppressAccessChecks
* java.security.SecurityPermission createAccessControlContext
* java.security.SecurityPermission insertProvider
* java.security.SecurityPermission putProviderProperty.BC
See http://docs.oracle.com/javase/8/docs/technotes/guides/security/permissions.html
for descriptions of what these permissions allow and the associated risks.
Continue with installation? [y/N]y
-> Installed ingest-attachment
顯示installed 就表示安裝完成了,然后重啟es,不然第二步要報錯
? ? ? ? ?第二步:創(chuàng)建一個文本抽取的管道
? ? ? ? 主要是用于將上傳的附件轉(zhuǎn)換成文本內(nèi)容,支持(word,PDF,txt,excel沒試,應(yīng)該也支持)
{
"description": "Extract attachment information",
"processors": [
{
"attachment": {
"field": "content",
"ignore_missing": true
}
},
{
"remove": {
"field": "content"
}
}
]
}
? ? ? ? 第三步:定義我們內(nèi)容存儲的索引
{
"mappings": {
"properties": {
"id":{
"type": "keyword"
},
"fileName":{
"type": "text",
"analyzer": "my_ana"
},
"contentType":{
"type": "text",
"analyzer": "my_ana"
},
"fileUrl":{
"type": "text"
},
"attachment": {
"properties": {
"content":{
"type": "text",
"analyzer": "my_ana"
}
}
}
}
},
"settings": {
"analysis": {
"filter": {
"jieba_stop": {
"type": "stop",
"stopwords_path": "stopword/stopwords.txt"
},
"jieba_synonym": {
"type": "synonym",
"synonyms_path": "synonym/synonyms.txt"
}
},
"analyzer": {
"my_ana": {
"tokenizer": "jieba_index",
"filter": [
"lowercase",
"jieba_stop",
"jieba_synonym"
]
}
}
}
}
}
?mapping:定義的是存儲的字段格式
setting:索引的配置信息,這邊定義了一個分詞(使用的是jieba的分詞)
注意:內(nèi)容檢索的是attachment.content字段,一定要使用分詞,不使用分詞的話,檢索會檢索不出來內(nèi)容
? ? ? ? 第四步:測試
{
"id":"1",
"name":"進(jìn)口紅酒",
"filetype":"pdf",
"contenttype":"文章",
"content":"UEsDBBQABgAIAAAAIQAykW9XZgEAAKUFAAATAAgCW0NvbnRlbnRfVHlwZXNdLnhtbCCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC0lMtqwzAQRfeF/oPRtthKuiilxMmij2UbaPoBijRORPVCo7z+vuM4MaUkMTTJxiDP3HvPCDGD0dqabAkRtXcl6xc9loGTXmk3K9nX5C1/ZBkm4ZQw3kHJNoBsNLy9GUw2ATAjtcOSzVMKT5yjnIMVWPgAjiqVj1YkOsYZD0J+ixnw+17vgUvvEriUp9qDDQcvUImFSdnrmn43JBEMsuy5aayzSiZCMFqKRHW+dOpPSr5LKEi57cG5DnhHDYwfTKgrxwN2ug+6mqgVZGMR07uw1MVXPiquvFxYUhanbQ5w+qrSElp97Rail4BId25N0Vas0G7Pf5TDLewUIikvD9Jad0Jg2hjAyxM0vt3xkBIJrgGwc+5EWMH082oUv8w7QSrKnYipgctjtNadEInWADTf/tkcW5tTkdQ5jj4grZX4j7H3e6NW5zRwgJj06VfXJpL12fNBvZIUqAPZfLtkhz8AAAD//wMAUEsDBBQABgAIAAAAIQAekRq37wAAAE4CAAALAAgCX3JlbHMvLnJlbHMgogQCKKAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArJLBasMwDEDvg/2D0b1R2sEYo04vY9DbGNkHCFtJTBPb2GrX/v082NgCXelhR8vS05PQenOcRnXglF3wGpZVDYq9Cdb5XsNb+7x4AJWFvKUxeNZw4gyb5vZm/cojSSnKg4tZFYrPGgaR+IiYzcAT5SpE9uWnC2kiKc/UYySzo55xVdf3mH4zoJkx1dZqSFt7B6o9Rb6GHbrOGX4KZj+xlzMtkI/C3rJdxFTqk7gyjWop9SwabDAvJZyRYqwKGvC80ep6o7+nxYmFLAmhCYkv+3xmXBJa/ueK5hk/Nu8hWbRf4W8bnF1B8wEAAP//AwBQSwMEFAAGAAgAAAAhALJengn1HQAAGVoBABEAAAB3b3JkL2RvY3VtZW50LnhtbOxdW1MbyZJ+34j9DwQR5xGju5BjPCckBGe965nxGWZjH08IaIPOgMSRhD2cJwEWEiAhbHOxQebiwQZfkGDBICSBIvavTFd168l/YTOrWkIIZo58mbFUbodDSNXV1Z1VWZlfVmZlffXnn4aHWu5KgaDX77vRarxmaG2RfH3+fq9v4Ebrf//Q3dbR2hIMeXz9niG/T7rROiYFW//89b//21f3rvf7+0aHJV+oBZrwBa/fG+m70ToYCo1cb28P9g1Kw57gtWFvX8Af9N8JXevzD7f779zx9knt9/yB/naTwWhg30YC/j4pGITndXp8dz3BVq25vp/qa60/4LkHN2ODlva+QU8gJP103obxvRuxtjvaOy43ZPqAhoBCk/FyU+b3bsrWjm91qSHLBzUEb3WpJeuHtXQFcbYPa8l0uSX7h7VkvtxSx4e1dImdhi8zuH9E8sHFO/7AsCcEPwMD7cOewI+jI23Q8Ign5O31DnlDY9CmwVZuxuP1/fgBbwR3VVoYNve/dwv29mF/vzRk7i+34r/ROhrwXdfub6vcj69+nd+v/ancIQ3V91h4nKNd+ik0FAyV7w3U03f8drcmWFivtQekIehHvy846B2pSIfhD20NLg6WG7n7Wx1wd3ioXO/eiLHOqfZros3Nh+G8wXpeXxu74SH+5r/dotFQx2hiE5U76nmFi88sv8kwcPD5gz+oa6o611in8Ck3YLrUgK1PqlNZlNvo0Npo7zuf3diOt85pVW6Hjwq24z3vWGOdMrD2ZaoaCPaH+gffqxVTuV/b8V5PyDPoCVYYHVuU3u+lrJXmxoar+mhk4OMmwl8C/tGR89a8H9fazXOReA/ByXu0pU2o6kke/LiX6Rn0jICkHO67fnPA5w94eofgjWB6tACHt7ARwE9gFPzDvko/sXIc6xaUMa1fA6rq9feP4d8RuGa5PuIJeG4CU5oNXRZrtxvAGJaCTgphqV37B6XXAcH1f3+j1WDocJu6bKZK0e3AFYVu6Y5ndCh0+crtqiL2FrcD+Oeet99/r9PvCwX8Q+1YEBzx9AHNcNeQF3veZrdiE/jj+1Ek3BO6JXlA+rPaf++Da3c9oDyGpDtamX80hLVv3R0qXzPwCwH+yEA3PC4I1zzBPi/wCUnPyqeP8CHYrjPo9VSXDTp9wQuV+oKVX6zVPv+QP1B+ktludluM/MKPUsBXKbfxsuA/yyWWjnJJJ75LVVm79qbtlU7C5i93eROSdO966Gs5H5ZPYvRx5rZ/yBNwu/BiiFfhNF/mUYvF7Ha5TA3Do1dx3e8zEtUdrnHxeX8br+hvXtZgLORg/z4JRcgrdPWQLu3R5aPS8uG7wgqoKFObwQb/W4z262ZbHQxl6LYY3XYnDrzOUB/GUINjI1IA5OyPLYHrCG4CN/uZoB70BkP+wBjcyLnrc/Ldr4muD+W72ANl5T5dOFKXk7VMVumOX2M5m6vbaXQbuxqF5YKD/WVK+4YkT4B1JnYeaNjRkB9/3vEOwdVu9k/rnxrlbLYZsOJ7KOdfGfVBaWik7Q6U/YuBv1APx94Z8HqGrhp69u83hv58oE2MQz6ByGwcIpA3r1KvTU8UwIbS42IpGifHh/Bfjb5SNhZwUi7tydmwnP9Zzj0gc+vKwjqJHCgHebI2Sxf3aCJNco/eFeIktUN2H5OJHTW9qaSXSWxKeZGna0d07b6cncUKsZfKwo6cm1JPM8rmGzl/pOQfkfkYPEIuPCYzRagjZ3NQh8aOaXJePlslkWOyFaVr42r0kBROaHj7l/B46fVj+KJOnsJ3+va4FE3y58JPkp4mkR2SzJSebuCbl1+PphJkZvOX8IRYI6ax4f9tGA2GP4lFGokUSPpELJq+Gev5660W6zVbu/Wavb3jmkEs8mD6ija9gqGBgISDZjQKN1YgRknuhYjz7LuAB2CXWDTV6i6EUnjlIhC2W82ubpers1UHwg09ojh6OhBuVKJK0SiAUA4qycN4NZ5FUMkgLQhQOh2mqWl+VZ2ZUCZOSGRfzr1mYPmUY0+sxpFsbKr0cF3JbUMLpUhCOU2TRLT0JAElgFuV7Yf8El2MlFZSdPwZ2UogngUwux/mTUGzgIIB+cIrkUhCPTw5R7hbUXgiyHFl/ExsqCsWUXT5mbqWABMIjCKyOCVnVyoWi7JzQNIr3JKpsXmgkE6/JPuLMP7K9Ak5G0fjKhkDYwn4kRTCNDcPptp5U+kwSSxi+cIZ3A52HY09UIu7YNFdML3OZskLMbmmhSFvsUgjhUX6aE4+TYHJrB5FQHyIRZ+AQ4bKgE1imgoj+k5m1LMzPl/1sWtwkkBSikXQRVdO05NDwol3hRhJ7YhFltFgsgg2UCdHJPlALJqCY8Feydc3+DevLygFQoINWCpHn2T4Er5YlImPDrNzAC/IPIxeHmxEkpgh83G6+1wsWnukYW9bz5ivTzjEoWPDZhkpjutJ5oRmFt4VpkFUquE4jc3T1BuSfIVm+eIUOjYrNrlocNLYbhTPnUUzSbKXpMtHYLDJp3MwkqVUWLBxu2YWTPNFJkniAGxreHjpVZyk43TxENe5ctvk0TiZWWeLaPo6V9OMJ0Mygk06QcM1eHSQjlcafbAeCmbIfe/uEVH0IQKZwGg2Of+cpHbkbEIupunCCcktAJZUdmZJLinn8/LpIrpyNsZhXLlrEQHpZIRMvdUC7/am9DnZ6K7AsmWgFseV7bwaPdARSpOQxhFKfQE6RofZarU4OlsbJEDHNzrMr3iHLm3pgms3K+E7ZaorN3xkaE+vdMcfkG60Olhsj+dOSAqwH6yaHtPzOfmZR7Tg2iGPgGGBL6hGWHQL/CTZSVKoBF3Xw/Ymd7fL4TLhJpYvJS7N68NHIP8CoSadsRuAsXlc15XsDYhJTZ/BpY9VTS5PyIMb/KvJPS/TyD0vQFqrLnt9wC3lGz81+e+2tz6WuvOB+43BPC9A6qou/67UkeJbxMv5TfXoQM6ukJlNvmGkEipVSoXp/gTIKzJ/vzporxReUYtRLtZEAyZJuhTFfTYHeSW//q4QExBTdnuHpJ6xYEgaFou4d4VpTeHmFsn+BHqDmLwScxR7QoAGhRtAFEhr42Rru/QkIZ/OiaxbXuQE1i18S2JlCnK/Xp3It8PuctksDbM1WTf4Phln4IALgYvlbJhMPSFbK2oG7Tz4xJ8MF9dr3hncjk6rrVGYXDfvvkQ2FnMv0uqUcralTMe0TUkwSbnVwsurtiPxEjm7S1PTuAUp+0rO5nlljIxNZnBeJzMwtRFaPoyr0QOy94DXJMlXcJVXRgvp9NEFH8NpEb7z9klqjzwN0+UjUaMBBWMfbtxORUqTOxgEkf9ZmZ8Cc0JMK+J2wP/TmFh04VzNnJCtJb6NkO/uw8XYqvmJi1eZY7o/UZo8JZGYkk/CmPOhhprK/SMyP0enE2q6WFpOk9jeua+pPOErfIE+xnxEczmOrxCWT0NNb6kZ9C7Kxad0ZgshQhF3r0AddftnuiZYhKKQfuSZGRD89BGYoSmSfFAKjwMfVOkHrAAaQKvwNKpubqKkj01BZagJaqdGSyALpteUuT01+orMoGypgY3AtXJurppN6dPnauaQ+aP3yaSmVTT9k1iENqsztkA53TjmWxfr3PveZTbbOu3mVqFAqOF9975fztDI+OF3ZdVe/tkZvIJx600TZr6ClXlZgwDVP4ZIZo+xUEW+MbcOxjda3Ra7zd4wPuUPYnzddPqcGuI8zKgsl8XSgAJGnfwSHhcNwZezLekD1dAEiZheicNNEUWfkMsaYBHQ3S2wivVVqGYgSi0+xkXJwoaSX6+y8BI8vWdVEpqVC3S3Xw13TW6TqbOjYWLJ6vaombRu+TiPmg6UP63p9jF8Tba2SfqkFL2UsfoqH5nFYHI6Dcheuo9M59/PZeixzENiaRejwdDyg2Aak2/9QRU5lSilwuqLcbK6IWdzJLFIUzkudDAeZeulOrNPnxbVcJzM5dXDXfmkvFibXsOMbuMruCI7HUVHwMI+gCZcUo0v8XVZTA6RfIC+QxafpBbnlfyherhOZyN1bmewWgxuoxXFl66LdVn2OXUx8C+Py6qDbe0mp8vVaUfd1bhsq60n/w5sqwdlNbwGGILHfy/5+qWA1H/bMyC5ApLnR3YX7rVmYcFaNPDKr23XweQVz9bIzMblEA9MSbJwRJJLWhz82/s0N48uvMMT0Ao8eQm31lDHVN84H6fLRyQeIfOvtbS4D+PaqQ+skd9+LtdkdCEj5x8rq1lUQuWYSv7o+rSOxWjr6HY4GjumUp++XzTQ5ptPKpOUf1Fe5krLh3R5AyYC36mN82XjhCbSfFkEUB33p8uFrFJ4Wd4AjmlnEPyl10pPInyRsuIrh1tofJqnqYFpBfOoTne52dzZ1e1smJjNP3gSNfnsuOKEMBzJ6x5f3yAS3uf39UkjoTaj2W41s5iIjz487JN3Q3e3zWnQaH7/+cWVXTxSy+pVh4U1vRCpXRBteoLEzOI+t0OiOTk3VXp2n0tgcvqMFJh9XuZSHlQLwrxabqtnk2Rrm8fSQiNqYh5tfibeKzei3b6apZmFGiGPRnv5cZrZX76FpqbpzGM6/TMCOXYJ34QtGahHM/BEFu6FFcjMKsm94IX1aQ2DudPksDO8oWsNEbQGG7Oy1gh5gj+2GR0Wh8NqYa8olMrQDBZdZegq43MTVXqxRGKrFYZki7M7cm6OzrwFsVy9O/2CVV6uTyKF0uYZHhoC308OmcyPcV1Al0646lHySfp2jh8XA7oDhH9thfG39DDPjlScAL1TCekme1OVB8nZuZqOv0KE4NHRF0WICSSI2eDA8pDfPxTyjtxoRS9vNlxaSKuZGbq0Wzn3xO3sKU3iqgVPzVid80rbvBA5krO72A/RV/R/8/CdFCd5WmNeUjnxpvonr0Dm56BBeIQMJljqPP0q6Gtlbo8UJkg2y/UvN7vU4qq6iRYZWd2AV6JruKCh5J+gfi88JvElGluiu89oYp3kc2oazTdyclR9b001HlD9rhADCw5HZGKHzsXo00kekY9vxfMz87u0ytNAi4Dil/USnX4Jhm3tkXOCCWGw7ZG5GZJDFsHcbSwjxcEeCRfINFydq46e1xYL2IFQcC+y42mePj0juQUMo2f3op1/8Awq1wfUrC6z22Sx4BzUPTNNB9Q+C//38s9P7pmpnF1VD9uandauLjuqFD1KQuffz7V4u7VNTiI0OQ8iWSzg+d2tH26LRREXLQgbFzI0Pq4eRQAzikWiVbDM+nI2St98dKa1xqKpXSxy8EBStqWTbyxGszA5I+LcMlr1uaXPrc8wt8jUEz636oy063Y5LVaLs1W353Q8XB8Rvfzz00e9l4+y/tW1nKtidjoMhm63o2H4VzfsvkjDjvlI5ezcr53pzlfu8CiTJzvqkxU6u47rsjNhmsqwY9erI+/iGOYWTVZC6oQ7G0owaMTlFnriuaece8T5AmxqR8kVMVVwmiVDYRFamEpraZevvtanpG0Og7uzq9vdKEJOV9JfrJIG003OhtXoIQ1fPBj+as61Gjudrk6TpVE4V1fPX6J6rk4xSGIvhduLf6vnW7EIEi6N4C3/QEuP9I9RydcntXw7OtwrBUQbsWllMy0Xn7JsoEs8IoIuH+GKRGSH7IcrWgPR8HiRACBmOw+1I6TzR2pxnRQW1beYDxvTBbL69eIjp8FhNHS36vhIVy71EdHLPz85PqKZ17gOl9vmHC2cWFamX2JGz60EiR3BnK9jclq6uxxdhsbZFKlDwC9yhYbBPrKek3NzYk3K76V+v1gUYRBplZiR8z/T1aKIQ+fy+ob8A8INXimcV88elHVEnMe7aDiPFbLNKjFlLkoexpWdA5Je4eHCJHEgnxZZXuptdVOLfCUzG8rhM4CGv4TH4TvZXabpt8ruRdXT9N3mdot28KwWdByXT9YRzhdWSuENzKRQjpVGy4BhpDoDT51Wi8Fhc7XqGF9HD/UR0cs/PznG1wB+8XUpvA4yTc7XE4Fqs3Q7zU63sVH4V4fBXyIMBkmspnNkawU0bPWWUfQ6RnZwBwvjZxG9jmbBoh1BCmkZVbILfNTUYlTZmeXKFkDU+a6kmY3SwjgOMSCrqoMTSHRDPpmjyxvkdJ88wu0hyANbL8XqJ5NFLHr4bm3yNIpHL3GEzEa/zqXSLme3xdjZMEul+mkWjCH00yzei0hk8wbawPvHEQ2mspw/rmOeWy32ToepyyLWPP9NuKkjy8+pltTMCzoZUTPHJDmhbtceTXDF9m62jbs2r9A/e//eZhkZaAv19+Llyi5vmnpDl6J0P0rDedyfntLymXDPfhn47NLpME1No2KcPAUQRBeOcJP7yv3S5omymhZz+3N6E2gEAukL6PeLbvP2qo4XgMXIw9qk/FewlZHnrNP4qr13dIwx0kCoO+AZBpHxt94hj+9HAfmAZeRpOKj7UTQ1ao6OjyKKiyyR52md2Tadxk6j1d3ZqlsiuiXS3KD8xYR8utg4h/z8cZRfJaCvnu1mk73b7rJ9Scvfuj3yWf2PF7M9wRc5O6slqUpvKvNTDYcqPopcgQ+px3XpeITOviGxVZLP8UIMBmA/K6vclRL18AVJHiu7mO6qDslk7Xa6DVanuVEkU92OZdar7XrqyUsWICqZL8Dio3PbJHZEkheNPsFsiXeFFX5CPVk9w/S38SVl5b5YUu5/pF6xCFIW46WnzzDyi8UAgdKVz4p15gF2ubrMBlvzpZfThfFXVwtj1uXiC+POWzdFF8NldSNnZ/g6OwaQsBlemjytxtpiSbPakW16gniG0DrTwzitZneHy9Wqy2NB5DHaOZfcbqYOu9HM1jLOPW4s7d1/eu56wLD61t8vXft7EL79xQ8ft//jNnxe+7brB/IwfnssNOj38SP/hPSw9bj/SxftQor22pH9skS729lltlib77xrXbR/dbVot+Bzy6I9IN2RArjdvG0geK9trG+wbewOi6kQSzg7b+u4W0zhXDuyX5RwNncbnXZrZ8Ocoqe7y64e13OB3OzMyVwnYk04gX1i/ACa3/BxqsU1OvdcH88mGc/a47Wu1gp2q8nS3W3obG02yG7RqNb3wDYvo7q/6RFr5iG2LgvQGsqusq7QUK5YV0GpL+T1+9ru/fSPtt5/DLXdNQloWzWoVfFRNDUiF39c3HdjKno97vvSbBI+7psfSSeWkhA0OEM7kLKyQ5x5b8jxc/k0Vd8ChcluddhNDX5gsw5FBV2sSD+jsWPldaYawmkbAsMrmN+gnNoCebtcGdibRI51w7hJiCrH+U7IZ7PkxQQoF7Ho+2as56+32roD8ByxCPslXLv7t8kJGhlw9g97fYLhgHrj403ujk6Xucvcqu/T0/fpNS2RMNbwet9Lvn4pIPXf9gxIroDk+ZHdBZNhNUsiB/TFBCm+rWNKGBxu9xeW0lgHvJ9TWMu5KXX7Z82/w7gUbe29KZJNk5mXAIHp6iF5fkpSe6XwtHq4Sx7GG2c7qo5z/9UydB0ix9jdbXe7mjD9qVWjV7e3m90Uq2VUXZw07lgp07FSNFpJkFQ5h1DOhuXsqxqKr/J2YeTR5TBxo9Fht7PETTWZmUAXqZkXSn5Kzs8q+QRmcGeQSi5u0vGMkGHhlY6uld4iLelzIuXsLklmSDxC5l9zDpKzee18yodxmgqTLcFEg3jHd78iyVd47jobtTo3Y5qcDovT3HxnQ+uYo/k5Fk/rW18HzMG/0McZGo/yY0Eqq/sol4qTuEScDauxN3QyQqbegokk3FqxyJGMuQU18/xyar8mJ66rU7BoKZJek8/gyQk5N0fmEUiWZ2hczj/nse2ABEqvH8P0VNPF0nKahrfVyTrzUpvNDqOloxt1gq5rdF3zB/N2MoOHg8VzqG7K37nGIakduj6P8IlxO5mK0NnnuAdn9o3yelZZeEtmVvEUo9MHSj51fnBVPAeV8USjqpnCz7WEksoj5JPZ0vIh/d9NTFqbXlMPd2DK4L2x13Vmc7c7O8w2W/Pt4dNnTfPPGnX7Pt0oYAhGJgkThFsWKPzf3qe5+VIkoZymUTsw971YytAkFjl0IysWQR0tfxEMLNeJolxml9NgcbfqvnrdV9+0RCKbax75VILMbNbB+HZHh9HuMnY1CuPXDYRsGuF6MoMaBwQbtLIDIuSwWszXBkPDQ1ha8T3IuQecQ8iTHTC43xViXRjl4e1r6fQPj4yGpJYeKXDX2ye9K0wDnC89LpaicbyJZRTEZSRmoZLEI/Vo5pfwuMLOIgV4Xnq6gelECydQgU6/JPuLUPmmx4OPuOm7E4CHBEb7QqMBqcUTbPFUPQYPBoy9hmeo6U0lvcxfD1eoLr4qiSTIHJ5kQSd2StGoerh78wdl842cx7NRyXSCptZJdIpsRfGIrzR6+Mlkkrv06d4hvurCW3zDrZfK/SO6t6DsTpPIGxLZ5+ALbA66cSyfFWniGKqBUU4XY2CFaC2UXwSDCJjhzl+W34svkDjAiPDEAZopD+O8H+RCVim8BFIq3Qh00Pi4kt/VMjTGVunSHlmbrW5f3f6ZTB2QrRVlOyFnV6C8lArTfQznJDMvwXgC0phhhJcwBn1/UUhvUe16ULtYfiLhfMPCrd+B/KuWQTD/+PY+MhVRTh/wBbua1QqxOkDgNXS6jOdso4uWSXN93Jpk3BCBpMLy6cHVK+VNT6V4QnR+txRJ6POrSeYX6DwSyQIirSBMzTHFwqHqW1Kx261uk9nc2apbloJYlh343IplaTY4bFdbluUNhN9L/d6gMh0D2885EgS2cLta7sBbsnJuWZJIgaRPwGYC+4kVk0RSTafpRhSsODDAuIFEj4/JfIzsPibM5qk8gIMy1ODrOfSuJuM0lVMmd8H845xKkjM1cXyg62l+Uz06ANOOzK+R+Xl4inw6R/JHanEd6nObjSQf4zr87nS16SWkfcV6vXY66xZWAxN0ecSaniRtmsfH5ZMIP6kCrCuY7zUzHf3Cp4+qFVIpmlTPJsnWNkfyQvVKy0/DQ9dxTV+60ToSkIJS4K7UitCwRazBF27bq5DAULhAMwHFKIbR5O8jVGKJHXgmetzhtrWC4QWZvJo51paQ5+MgMUk0SfYekEcJkluAn6XlwzpPIHUZ3YA4mi96Rof2X10N7S+cKR6y2Sym34b23/h9A3636wpwr10BeE/ScRLZ4QhfK+XovgLYSz+vka2XJDZFspN4vOBBXsmvg6BBbM58SRzyk8IifcTSdnJ3ydYKD5nh1dAvo5mlVY6n9An+TJ8o42fM3ROV86d0/BnZSqBVwVaN5MJjxBq702RmnS8isQERCt1r/V47p4U86OxKJ2TZ+TZezY1iSf2rxrjpieKS4rKxD7OUlyj5R2jgb63QjePKMj7L6DtNZ1+SvSmtQnxJa4GLEtHSrAm6sxv36Jeern0ZYyjkBEZ1zRbauLmOJj2bqzCYfBgra2r1AE6nw+CydeuAUxTAaWKRiZe2SdusDlPbPwfx2vk+ab5jrbChnmk6wP0DhhO5PSFPyw8Bjy847A0GvX5fdcwSs3y+d7u+6WGHcPX89Rb8/e6W8zbAPd4gRlovH57viMttybmH6NxfndKEDZhIu8/hNrU4rmzn8Uv6WelxBMOCoE4MF47JzAbmfszN4ebe00c8NgezioDQyudIehogB1ZLZngwFA8p4qC18uiKU4UNj1DwE0ZKdOh5MYviZWYVS6rXDmjTEwQ4g6bekNReBWfy6U5ie2DvytkZPZynGYiqMyNfZ6fd1WHVXdLCwAh2Yn1l3cpiNl4R7FwJuyWZE3V/k6PP73oQQ3zX+3epL9TSAyrXM1AT9IyhwG/O6NvjUjTJ1g80ZS6fzoHyB6FRUealpxsYJwEPYE2fe6VB7bOVCYfjmqPy70/wXKNJzr5yYNRzBQQw3xcNb8N9rLr1T+fGL1/kCm+j/4sFBGuu8P08WZuF9rnNi0+M7JSePuMLW9rLaK8qILiAIRQcXFQzrIhoonYEm56gq/dKfKgIqXPrms3icJvM9Zx4Z+0yGQ1MZNal1C5Wr1ZqvCtAdN6uDNi/ap+9+EAP7ma6BwLI6DCwTFmD8N3WYe7gTY4MfOPBFkN+kNtGi4VZiQHvwCC8j7GDb2fr9YdC/uHzy6jLzq8OSp5+CZ7bYWXvccfvD+FPh4NRODAaYj+1wYSBx8HUfOwWE9tcfe96v7/vLwEvKtgQyBPQll6fFGSPgi+3vaE+eGmzkfVCe7kb2Ndef/8Y+wItjA5LvtDX/w8AAP//AwBQSwMEFAAGAAgAAAAhAIhTqnwyAgAAjxAAABwACAF3b3JkL19yZWxzL2RvY3VtZW50LnhtbC5yZWxzIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAzFbLcpswFN13pv/gYdFdAPGQoA32oq/JopvUzdYj4Now1oORRBr+vooTx7RJPTVlYpa6jI7OPRwd3cvFHWezW1C6liJzkOs7MxCFLGuxyZwfyy8XiTPThoqSMikgczrQzmL+9s3lNTBq7CZd1Y2eWRShM6cypnnvebqogFPtygaE/bKWilNjl2rjNbTY0g14ge9jT/UxnPlvmLOrMnPUVWnPX3YN/Au2XK/rAj7JouUgzAtHeJVFUqwWWwtK1QbMA6y2uBWwxqWs7lrhFpJ75SPMqgRDa+YhjIOYuJXh+73fZGlpfb4zoARljvcyfxROpQEL56cDGpjKHwhwGAWn8x9Vfw3G2KuhD+z3Fddi/Y1CgCYiYYgSNMDDZCoWTsIIJwMsHJypgUbJsi0sSpqm6J43O5H4VJQP4hAPMM6oumvTMejfvN362L1DeDL3jhAfD9DPn0z2xumA7B0190TLc1A2aw/0n0rHXDAVE6CABKk/QMTXej0ayagqc0teaMmg38tpjOMzKc671ZreSlUbmwsD0vZcvP90Ck5itHsuTkyLUUcdY/fCgftu+VBERzP3tSLLCseluMjbri/lQjc8ixHBLorjOExcFMbEj4iLXBJBQgCT65tq+1W8o7z5sMMoa9N9vBf40f8r3eYnGiedTkzHA+ajaEz6PyH//mxK7hWPmWcqOuIkSofMmaMK+R/80yTyB7w0wajz2loKs6Q564XIU2lvAq9PQ89/AQAA//8DAFBLAwQUAAYACAAAACEAOgXMGeEGAADOIAAAFQAAAHdvcmQvdGhlbWUvdGhlbWUxLnhtbOxZW2sbRxR+L/Q/LPuu6Lari4kcpJUUN7ETEyspeRyvRrtjze6ImZEdEQIheSqFQiEteWig9KUPpTTQQEP70P9Sl4Q0/RGdmZW0O9IsTmIbQrFtrLl858w355w5c7R7+cq9CFuHkDJE4pZdvlSyLRj7ZIjioGXfHvQLDdtiHMRDgEkMW/YMMvvK5qefXAYbPIQRtIR8zDZAyw45n2wUi8wXw4BdIhMYi7kRoRHgokuD4pCCI6E3wsVKqVQrRgDFthWDSKi9ORohH1p/v/zjzQ9P/3r4pfizNxdr9LD4F3MmB3xM9+QKUBNU2OG4LD/YjHmYWocAt2yx3JAcDeA9blsYMC4mWnZJ/djFzcvFpRDmObIZub76mcvNBYbjipKjwf5S0HFcp9Ze6lcAzNdxvXqv1qst9SkA8H2x04SLrrNe8Zw5NgNKmgbd3Xq3WtbwGf3VNXzblb8aXoGSprOG7/e91IYZUNJ01/Bup9np6voVKGnW1vD1Urvr1DW8AoUYxeM1dMmtVb3FbpeQEcFbRnjTdfr1yhyeooqZ6ErkY54XaxE4ILQvAMq5gKPY4rMJHAFf4F7//MXr3/+0tlEQiribgJgwMVqqlPqlqvgvfx3VUg4FGxBkhJMhn60NSToW8yma8JZ9TWi1M5BXL18eP3px/Oi348ePjx/9Ml97XW4LxEFW7u2PX//77KH1z6/fv33yjRnPsnhta0Y412h9+/z1i+evnn715qcnBnibgv0sfIAiyKwb8Mi6RSKxQcMCcJ++n8QgBCgr0Y4DBmIgZQzoHg819I0ZwMCA60DdjneoyBYm4NXpgUZ4L6RTjgzA62GkAXcIwR1CjXu6LtfKWmEaB+bF6TSLuwXAoWltb8XLvelEhD0yqfRCqNHcxcLlIIAx5JacI2MIDWJ3EdLsuoN8ShgZcesusjoAGU0yQPtaNKVCWygSfpmZCAp/a7bZuWN1CDap78JDHSnOBsAmlRBrZrwKphxERsYgwlnkNuChieTejPqawRkXng4gJlZvCBkzydykM43udSDSltHtO3gW6UjK0diE3AaEZJFdMvZCEE2MnFEcZrGfsbEIUWDtEm4kQfQTIvvCDyDOdfcdBDV3n3y2b4s0ZA4QOTOlpiMBiX4eZ3gEoEl5m0Zaim1TZIyOzjTQQnsbQgyOwBBC6/ZnJjyZaDZPSV8LRVbZgibbXAN6rMp+DBm0VG1jcCxiWsjuwYDk8NmZrSSeGYgjQPM03xjrIdPbp+IwmuIV+2MtlSIqD62ZxE0WafvL1bobAi2sZJ+Z43VGNf+9yxkTMgcfIAPfW0Yk9ne2zQBgbYE0YAYAWdumdCtENPenIvI4KbGpUW6kH9rUDcWVmidC8UkF0Erp455f6SMKjFffPTNgz6bcMQNPU+jk5ZLV8iYPt1rUeIQO0cdf03TBNN6F4hoxQC9KmouS5n9f0uSd54tC5qKQuShkzCLnUMiktYt6ALR4zKO0RLnPfEYI4z0+w3CbqaqHibM/7ItB1VFCy0dMk1A058tpuIAC1bYo4Z8jHu6FYCKWKasVAjZXHTBrQpgonNSwUbecwNNohwyT0XJ58VRTCACejovCazEuqjSejNbq6eO7pXrVC9Rj1gUBKfs+JDKL6SSqBhL1xeAJJNTOzoRF08CiIdXnslAfc6+Iy8kC8rm46ySMRLiJkB5KPyXyC++euafzjKlvu2LYXlNyPRtPayQy4aaTyIRhKC6P1eEz9nUzdalGT5pinUa9cR6+lklkJTfgWO9ZR+LMVV2hxgeTlj0S35hEM5oIfUxmKoCDuGX7fG7oD8ksE8p4F7AwgampZP8R4pBaGEUi1rNuwHHKrVypyz1+pOSapY/Pcuoj62Q4GkGf54ykXTGXKDHOnhIsO2QqSO+FwyNrH0/pLSAM5dbL0oBDxPjSmkNEM8GdWnElXc2Pova2JT2iAE9CML9Rssk8gav2kk5mH4rp6q70/nwz+4F00qlv3ZOF5EQmaeZcIPLWNOeP87vkM6zSvK+xSlL3aq5rLnJd3i1x+gshQy1dTKMmGRuopaM6tTMsCDLLLUMz744469tgNWrlBbGoK1Vv7bU22T8Qkd8V1eoUc6aoim8tFHiLF5JJJlCji+xyj1tTilr2/ZLbdryK6xVKDbdXcKpOqdBw29VC23Wr5Z5bLnU7lQfCKDyMym6ydl982cez+ct7Nb72Aj9alNqXfBIViaqDi0pYvcAvV0wv8Ady3raQsMz9WqXfrDY7tUKz2u4XnG6nUWh6tU6hW/Pq3X7XcxvN/gPbOlRgp131nFqvUaiVPa/g1EqSfqNZqDuVStuptxs9p/1gbmux88XnwryK1+Z/AAAA//8DAFBLAwQUAAYACAAAACEAssMlJ7oEAAA7DQAAEQAAAHdvcmQvc2V0dGluZ3MueG1stFfbbts4EH1fYP/B0PM6shTLTYw6RXxrUthtESXbZ0qiLW54EUjKjlPsv++QFC2naQsni7wk1FzODIczh/T7Dw+MdjZYKiL4KIhOekEH81wUhK9Hwd3tvHsWdJRGvEBUcDwKdlgFHy7+/OP9dqiw1mCmOgDB1ZDlo6DUuhqGocpLzJA6ERXmoFwJyZCGT7kOGZL3ddXNBauQJhmhRO/CuNcbBA2MGAW15MMGostILoUSK21chmK1Ijlu/nkPeUxc5zIVec0w1zZiKDGFHARXJamUR2OvRQNl6UE2v9vEhlFvt416R2x3K2Sx9zgmPeNQSZFjpeCAGPUJEt4G7j8D2sc+gdjNFi0UuEc9uzrMPHkZQPwMYJDjh5dhnDUYIXge4pDiZTiDPQ5pCxsNXpfMAYAqdFG+CCX2dQ2NL9KoRGrfRQYRvyypZA+3Y22NFD2ma5xqQTKJpJvJpmVYPrxecyFRRiEdaJ0OnH7HZmf+QhHNP7vED1Zu6hBcAEc8CsE622GFZQ6DAgTzrheERpFBmsA6U/FZ6LSWUtS8uMIIZL9Uz4XQjbrAK1RTfYuyVIsKAmwQbLEfN+CFRFto/I+SFH9jqUmOaFqhHETeNEoGjSlRFUW7KyHJo+Aa0WnrOwNe3HkPD+3sPeyvrGNnnZdIohyybsJPIIQU1FsZFpQwpF9rnuvaclHjZ+nRrBQ44rmQdwtXF0QRz3EKWBSPdxo4qM7c6hspdOlyNFVbYLTBY5TfKwotdWnY2ypreisRsfVwAms9e6iA49OSrPQN1sBIVoWKf2qlF4TjK0zWpb7mt6YHHI7C89kC7UStD1JO3Z0AG+SIYbfDPc8vRQGkDa6SHN/VxqE5ssPa/BhIQPXhELBNMNU7CkXjOiWP+JIXn2AXBBBdhV+fwe8SwNxE/gJjdbur8BwjqCLclW8TzJ7ZnJJqSWA25DUvYLreLBhZrbCEAARpvISxI1JsbZ3dwL5VXOiwb2AMrHYKLZvfj4XWgl3tqhJq/f9O0g5zeDhn8AAqlF/cANPsTXtRlJzPzl2mRnuUJon65/2faZJZHPWafT/VnE3j2cASR7jPhw3Ns+Kr9CvT1B3mPCaIZZKgztI8PEJjkcn7MeFen2Fgd3yoSevMK7tdp1AMUTqH8nqFLQ2zPDfFK7umSyTXLW5jIX8qBWb+tMcynI/lR2Dvymm3ElWuWb1J1O83noQD0zAvV3WWei8O99GBCq6CLxtp69SWZzvUcPh26Beo5XnMu3epOXaMlL5UBI2Cx7I7+dz0HZWp6Rm8RFXlWi9bR6OAGrKLjJuGrwKerPYjW8eNLra62OnsB8rNZsG6WbSy2MsO7E697LSV9b2s38oSL0ta2cDLBkZWAtlISvg9TIFfGvlKUCq2uLhq9c9ErgiqRBWeugsVOk44QXPDqs5miB/g4sYF0fBLoCIFQ/Bqi3qxvUAba2rvgSe2RmeMq6cI5o3TzH34xNl2/Q+5mIs+J9Ch6Y5l7bV54hKnRAFnVHDDaiG97i+rixJ79WrLG3CwN3g1RgoXja4Q+bV5syTO53uSTAa902mvexnNBt3+2WDWPe+/m3ST6Xg87c/n/fFk9m8zmP5Xz8V/AAAA//8DAFBLAwQUAAYACAAAACEAUEqBflMFAACjVgAAEgAAAHdvcmQvbnVtYmVyaW5nLnhtbOycy27jNhSG9wX6Dob2iUTdbUwycBy7SFEMCkyKrmWZjoVIokDJdtLlvEwfoY81r9BD6uK7IMlZKMDZRDYP+fP450X84Mhfvr5F4WBDeRqw+E4ht5oyoLHPFkH8cqf89Ty7cZVBmnnxwgtZTO+Ud5oqX+9//eXLdhSvoznlUHEAGnE62ib+nbLKsmSkqqm/opGX3kaBz1nKltmtzyKVLZeBT9Ut4wtV14gmXyWc+TRNQWfixRsvVQo5/62Z2oJ7W2gsBE3VX3k8o287DdJaxFKHqnsqpHcQgk+ok1Mpo7WUrYqsToTMTkKQ1YmS1U3pzIezuynpp0pONyXjVMntpnQynaLTCc4SGkNwyXjkZfCWv6iRx1/XyQ0IJ14WzIMwyN5BU7NLGS+IXztkBK0qhchYtFZw1IgtaGgsShV2p6x5PCra31TtReqjvH1xqVrQsFm30N1QpW9ZmGZlW97Eu7z5I/PXEY0z6ZrKaQg+sjhdBUm1O0Rd1SC4KkU2dQZsorCst01Iw6V2aWt7zIdhJ9gk/WLsojDPvF6RaA1GU0hULZqkcNhnmUkEM3jXcSdr9swlDTefUkA/EbB92vBmUWq4hYbq71a30AkaLqtSJx8VoRPsjCUN98DjZPYE0kW2WLVS0UtfVdHWy7yVl1YTXSjSdklZldx7tOdR8nLdQviNs3WyUwuuU3vabYlbcTppoVUsqP1Fnl6XzPeVl8BOGfmjp5eYcW8eQkawPAYwwwdyBMRfmCjiIl/SN1kuxnog9hjlHo5V3jzNuOdn39bR4ODdE8xNOJ6B2ohTOJNxUZifwMbLjPIHTr1XUUWoxKnoZ7TxYMMm06FpkdlEUUUkWodZ8Afd0PD5PaFlHVkaitK8VhYlYRl71GxtTIidR8KNCARwKfuSuVSd5bXgcDiLqsL5OgxpVrV/hjtDGfr547+q/He/LA3psqie/MllPmBEcS3rQBfgxihhMG6Oronq6q5iEIvPL3TyKLxZefGLPNcadlm7UOfFZcbiLBWup34AU/P7ezRnoWw6BkMPCoIYhBd06YFxeabpP2VmVTJSV5Wf7dg6cr117AOMI6ZZ55wMd7FuwtY8oHzwjW73/DsuvdZEXahkcG+HA8KGfoipP3/8+wG26qTy6ZytMtzF1r+htmCzdM/Uw7JrLTV6a6nr1loqwv201OyrpWBRnaUy3E9Lrb5aahq1dyIZ7qeldl8ttbTaW5QM99NSp7eWOrW3Jxnup6VuXy21zdrbkwz3xVL1gCtEi1roIEoH6DAd2zatoZVn1B46zAkwmqa51dBUUwCh4wro+PDVgxCCEIIQghCCEIIQghCCENLCUoQQhJDGECJOWa0hxNL1mW5MjTyj9hAycx80XZvK/A+nAEIIQghCSANbEUIQQipLEUIQQhBCEEIQQhBCPiOEiCNBewh5mLjm41TPM2oPIYZmTR7G1rQammoKIIQghCCENLAVIQQhpLIUIQQhBCEEIQQhBCHkM0KIuH+1hhBnOh7rxqz4d6r2EGK5zmRmDfEZEIQQhJButiKEIIRUliKEIIQghCCEIIQghHxGCBGbbXsImT1OHFcb5hm1h5Dxg2baU1J8k7I/BRBCEEIQQhrYihCCEFJZihCCEIIQghCCEIIQ0lMIiSV8xHsPootf0Bot1vL3tUShaxiAFIYt/T6glKqvoqv4jKR8rORY0rCJ4xJCnMuaZfrnNMVJ5URTd4iuucS2LmuaNZryS59jTSI07aGuGZdF5bMvF0QlxB2LWq5BNN3S8wl8VlNO5AuaYrc+o2lrxABwuygpfyeglMyvOVHe/w8AAP//AwBQSwMEFAAGAAgAAAAhAA55YS5UDQAA3oEAAA8AAAB3b3JkL3N0eWxlcy54bWzsncty3LgVhvepyjuwepUs5Fa3bh7XyFOyLEWqSLZmWo7XaBKtxogkGJKty7xAFllmkSynZpFVkjfI22SSylsEAMFutA7B5gFhuSY1G1tN8ny4nPMfALx++dVDEgd3NC8YTw8Hoxfbg4CmIY9YenM4+HB9uvVyEBQlSSMS85QeDh5pMfjq9S9/8eX9q6J8jGkRCEBavErCw8G8LLNXw2ERzmlCihc8o6nYOeN5QkrxM78ZJiS/XWRbIU8yUrIpi1n5OBxvb+8PNCbvQuGzGQvpWx4uEpqWyn6Y01gQeVrMWVbUtPsutHueR1nOQ1oUotFJXPESwtIlZrQLQAkLc17wWflCNEbXSKGE+Whb/ZXEK8AeDjAGgP2QPuAYLzVjKCxNDotwnP0lh0UGx60yBqCIymiOoozrfh1KW1KSOSnmJpHiKrW3xD0mso+S8NX5TcpzMo0FSXg9EI4LFFj+K9ov/1N/0ge1XTZh8FpoIeLhWzoji7gs5M/8Ktc/9S/13ylPyyK4f0WKkLFrUUFRSsJEgWdHacEGYg8lRXlUMGLuPNHb5P65PLDRMixKY/MbFrHBUBZ6S/NU7L4j8eFgXG0qvltuGNVbjmW9qm36qJikN/U2mm59mJj1Oxx8N986fic3TUVRhwOSb02OpOFQN7f63+iEbPmrOupJjwn1Ci1PqpQi9tLZBQ9vaTQpxY7DwbYsSmz8cH6VM56LtHE4+OILvXFCE3bGooimxoHpnEX045ymHwoarbZ/faqkrzeEfJGKv3cO9pUX4yI6eQhpJhOJ2JsS2aHvpEEsj16wVeHK/Pc1TPdjo/2cEplNg9FThKo+CjGWFoXR2mbm4knb1VGognaeq6Dd5ypo77kK2n+ugg6eq6CXz1WQwnzKglgaicStjofFAOomjkWNaI5FbGiORUtojkUqaI5FCWiOJdDRHEscozmWMEVwSh7aotAI9h1LtLdzN48RbtzNQ4Ibd/MI4MbdnPDduJvzuxt3czp3427O3m7czckaz62mWsG5kFla9lbZjPMy5SUNSvrQn0ZSwVJLTD88OejR3EsjPWCqzKYH4t60kKjfmyNEidR9PC/lSi3gs2DGbhY5LXpXnKZ3NOYZDUgUCZ5HYE7LRW7pEZeYzumM5jQNqc/A9geNWUqDdJFMPcRmRm68sWgaee6+muglKSwDmizKuRQJ8xDUCQlz3r9qnHjLDxes6N9XEhK8WcQx9cR65yfEFKv/2kBh+i8NFKb/ykBh+i8MDJ/56iJN89RTmuapwzTNU79V8emr3zTNU79pmqd+07T+/XbNylileHPWMep+7u445vKiQO96TNhNSsQEoP9wo8+ZBlckJzc5yeaBPKvcjDXbjC3nDY8eg2sfY9qS5Gter0LkWLSapYv+HbpG8yWuJc+TvJY8TwJb8vpL7FJMk+UE7czPemaymJaNolWkTqKdkHhRTWj7q42U/SNsJYBTlhfeZNCM9RDB7+R0VrrTR+Zb1bJ/xVas/rJ6mpW8Vk8jPdQy5uGtnzR89pjRXCzLbnuTTnkc83sa+SNOypxXsWZKfqxc0knyJ0k2JwVTa6U1RPehvr6dILgkWe8GXcWEpX78drKVEBYH/mYQZ9eXF8E1z+QyU3aMH+AbXpY88cbUZwJ/9ZFOf+2ngkdiEZw+emrtkafTQwp2zDwMMhWJR55IYprJUuZlDFW839LHKSd55Id2ldPqDp6SeiJOSJJVkw4P2hJ58V7kHw+zIcX7HcmZPC/kS1TXXmDGacNiMf2Whv1T3TseeDkz9H5RqvOPaqqrrP3h+k8T1nD9pwjKm2J4kPHrobFruP6NXcP5auxxTIqCWS+hOvN8Nbfm+W5v/8Wf5vGY57NF7K8Da6C3HqyB3rqQx4skLXy2WPE8NljxfLfXY8gonodTcor3m5xF3pyhYL48oWC+3KBgvnygYF4d0P8OHQPW/zYdA9b/Xp0K5mkKYMB8xZnX4d/TVR4D5ivOFMxXnCmYrzhTMF9xtvM2oLOZmAT7G2IMpK+YM5D+Bpq0pEnGc5I/ekKexPSGeDhBWtGucj6Tj3bwtLqJ2wNSnqOOPU62K5wvJ3+kU29Vkyyf9fJwRpTEMeeezq2tBhxluX7v2iYz9RhG7ypcxSSkcx5HNLe0yW4r1suTjIT6ND243NfptOcFu5mXwWS+PNtvYva3N1rWC/Y1s80FNvX5fv3kSZPZJY3YIqkrCh+m2N/pbqwies14d7PxaiaxZrnX0RKWub/ZcjVLXrM86GgJy3zZ0VLpdM2yTQ9vSX7bGAgHbfGzXONZgu+gLYqWxo3FtgXS0rIpBA/aomhNKsFRGMqrBdA73TRjt+8mHrs9RkV2CkZOdkpnXdkRbQL7ht4xObJjkqYqb3n3BMj7ahLdKXN+veDVefu1C07dH+o6FxOntKBBI2en+4WrtSxj78fO6caO6Jx37IjOCciO6JSJrOaolGSndM5NdkTnJGVHoLMVHBFw2Qra47IVtHfJVpDikq16zALsiM7TATsCLVSIQAu1x0zBjkAJFZg7CRVS0EKFCLRQIQItVDgBwwkV2uOECu1dhAopLkKFFLRQIQItVIhACxUi0EKFCLRQHef2VnMnoUIKWqgQgRYqRKCFquaLPYQK7XFChfYuQoUUF6FCClqoEIEWKkSghQoRaKFCBFqoEIESKjB3EiqkoIUKEWihQgRaqNWjhu5ChfY4oUJ7F6FCiotQIQUtVIhACxUi0EKFCLRQIQItVIhACRWYOwkVUtBChQi0UCECLVR1sbCHUKE9TqjQ3kWokOIiVEhBCxUi0EKFCLRQIQItVIhACxUiUEIF5k5ChRS0UCECLVSIaItPfYnSdpv9CH/W03rHfvdLV7pS35iPcpuone6oulZ2VvdnEd5wfhs0Pni4o9Yb3SBsGjOuTlFbLqubXHVLBOrC5/vj9id8THrPly7pZyHUNVMA3+1qCc6p7LaFvGkJFnm7bZFuWoJZ525b9jUtwTC425Z0lS7rm1LEcASM29KMYTyymLdla8McdnFbjjYMYQ+3ZWbDEHZwWz42DPcCmZyfWu917Kf95f2lgNAWjgbhwE5oC0voqzodQ2F0dZqd0NV7dkJXN9oJKH9aMXjH2lFoD9tRbq6GMsO62l2odgLW1ZDg5GqAcXc1RDm7GqLcXA0TI9bVkIB1tXtythOcXA0w7q6GKGdXQ5Sbq+FQhnU1JGBdDQlYV/cckK0Yd1dDlLOrIcrN1XByh3U1JGBdDQlYV0OCk6sBxt3VEOXsaohyczVYJaNdDQlYV0MC1tWQ4ORqgHF3NUQ5uxqi2lytzqKsuRrlYcMcNwkzDHEDsmGIS86GocNqybB2XC0ZBMfVEvRV7XPcasl0mp3Q1Xt2Qlc32gkof1oxeMfaUWgP21Fursatlppc7S5UOwHratxqyepq3Gqp1dW41VKrq3GrJburcaulJlfjVktNrnZPznaCk6txq6VWV+NWS62uxq2W7K7GrZaaXI1bLTW5GrdaanJ1zwHZinF3NW611Opq3GrJ7mrcaqnJ1bjVUpOrcaulJlfjVktWV+NWS62uxq2WWl2NWy3ZXY1bLTW5GrdaanI1brXU5GrcasnqatxqqdXVuNVSq6txq6VLYcI8vAJqkpC8DPy9L+6MFPOS9H854Yc0pwWP72gU+G3qBaqVw/u1z19Jtvq2nji+FH0m34BuPK4UVW+A1UB14LkgEfUFK1mJQH+1S3+4StVVX6lVf2fV58juWcTv5ePbOY9rEx2i34b1hikv57qKymyoS9xQx2WtRqBWq89hqaKmRPTDe9l/ai/RXSv6r9400pVaRW29R+vSbFtesGjZmO2Xb8cn9d07Da1W24vqCVphNJUvFaOyQPXwVfXzaFFyfYjucTIrab48Sv16ctCTPozprKy28erVTxd36x1ed67lS3GHgx//8cd//fNPsrjVB9hW29RH4cwNYbH8VfVx9e9xof43vwi3oxP06pNwdbo0PwlXbTO+7IYKgbE1BLRnNofA+P85BOoU8JlCQHftKgJWMbGKgGrb5ggI5yIEQv3mO1ui2gYBYXmptcXnundXubU6bi2zVrW11LKUg2NbDWHWWnt1ni0WdTBuqpioxjSuvCz+OE9ltN7rLwpWFYwetAjE/mMax5ekOppn9kNliFV7R9vqrSZP9k+rF3Ra7XM1k7MChuuVqX62B0P1yQ59i5Gtq2F2qN8C2LOXOwZpuChEt6iB92ndRjBQ//39H/77w1/EvPfHv//5P3/7a3P+qud55hi2IX/Zc9ZPe0To2tVja1ePsV2t++0n0NWfLvO29HT12amtrUUWiSlnyRK6tbUj2nn7uNs4TtuObXOHrYs71n6VHHZAlVZriLYK9MnNG+MjlEuq1RHb26enutR6o/xkRDVMIOdMLX4r5jwvI1qEoEtWexq7ZFPUf/5J0aee+7RqbqxDee0TyGqbP81l1TeiTadlalXlUUFd4yiDVfk5bp45brr6KmbAWbH+rPfP3vo8Kl+NTXC41F8xaNM1HJjqz613W8HqrptWZag5BWxA/Vfx+n8AAAD//wMAUEsDBBQABgAIAAAAIQDhFsS7ZQIAACkTAAAUAAAAd29yZC93ZWJTZXR0aW5ncy54bWzsmG1v2jAQx99P2neI8r4kzjOoUIlVnSZN09R1H8Akhlizc5FtCPTT7xIempZ2amAVb/IGX86+n+7+lyOB65u1FNaKKc2hGNtk4NoWK1LIeLEY278f7q4S29KGFhkVULCxvWHavpl8/nRdjSo2+8WMwZPaQkqhRzId27kx5chxdJozSfUASlbg5hyUpAYv1cKRVP1ZllcpyJIaPuOCm43juW5k7zDqPRSYz3nKbiFdSlaYJt5RTCARCp3zUu9p1XtoFaisVJAyrbEeKbY8SXlxwJDgCCR5qkDD3AywmF1GDQrDidtYUjwBwm4A7wgQpWzdjZHsGA5Gtjk868aJDhyetTinJdMC6MxkeSeKt9fVqWOpoTnVeZvIuiUVHnAbWWsk09G3RQGKzgSSsOsWNs5qwPUn1l8vjcnWjb8uwZ7gQGR8pXerVY1qiYnnx54bhrHfHJhBtrltNldU4K7t1F6ch+9sbvZe9+C954v8FfcDlMfOKRgD8oUfE5lmqrbMU0yBc2zjhX6sz9VGSVO2s1MQgONHlwa2CNHKrFvk7FlG3WJVu/IuoU676LofX3IusudNiYOYJEOfxE1PzlCfJL3+J+hP/CgIwygOtkNxRgOGvf6n6B+4gYcNGJJz9e/lf1v+rflCeTdO3KFL8L7tlf9w5bfrfgL+7W13KYxDfC2I3aRv0gW+nXx8MJAgjs5W33ff0v+w03fg1Q7EURDFfhD09/8F1Cde6PtkGJJhL/9l5PeSCH+39S9HHyj/KY/o/+ati4DScMkf2R2oqYJKM9XURoWA6uePr9tsW39wTf4CAAD//wMAUEsDBBQABgAIAAAAIQDdRDGeFwMAAMUNAAASAAAAd29yZC9mb250VGFibGUueG1s5JbPb9MwFMfvSPwPUe5bfvRXWq2b2m6VkBAHVgRXN3Eai9iObGdtz5wQR+DPAHFGQvwzoB0Q/wPPTtt1JNuaDSEmEqVJnu1v3vv4+bkHRwuaWmdYSMJZ3/b2XdvCLOQRYbO+/Wwy3gtsSyrEIpRyhvv2Ekv76PDhg4N5L+ZMSQvGM9mjYd9OlMp6jiPDBFMk93mGGTTGXFCk4FXMHIrEyzzbCznNkCJTkhK1dHzXbdsrGbGLCo9jEuJjHuYUM2XGOwKnoMiZTEgm12rzXdTmXESZ4CGWEmKmaaFHEWEbGa9ZEqIkFFzyWO1DMCuPjBQM91zzRNMLgVY9Ab8k0A7xop5GsNJwYOS2Donq6bQ3OiTa0rmdM1sCMlJRUkvFX3N19FikUIJksq2I6znV2sgtqWZEw96jGeMCTVNQglm3YOIsI6x/IX59M494Yew6BPtwtRSseY8hCiNPl3TKU2PPEOMSe9B0htK+7bbg9FydIh23DfeW27Ed3TFMkJBYaxQd/cIcI0rS5doqOEWsaMiICpO1/QwJop0umiSZQUMupy7orA67sHiwwi9b/FKfxmVLaHSCyxZvqw980ykAlEBMCMXSeoLn1lPjeRURPa1ttwEkmnD58NSsJmK+dHciJ+CzfzIeXxAZgaUTtIYlIt3riJhXr9DZnciI54JgoZlcQaMDBLqGiqbRrEWD8giLKhwxWeBodxbNxt9g8RzKrd5m5BUrpXTUWCkoV/weLZTzD6/PP381HFCqnoBt7fExZrMXZJPjpXTxYPG4kDLe+qyEFLT/CKSBjsMfbuVLIxiNO6Px4HdIXvuGfGnCVTNfvn988+3L2ypIp4Se5v8GIhMFVLELRH4QjNfh10bk1UOU4DTb05YqSiNEp+B2NaaK43ZlmHE1ETmeLDNc5hbhGOWpui6EAbhYvXf67hBmsmlqY3HWqY1yTqS8RzvFEP7fsFnVPP749O7nq/dXZXvDZLt7U7avzHfdTYf6U/5gi1G7e9yBilBi1Li2bMILVM5uTUZF2bQek1lSZPz/VR9XD/LwFwAAAP//AwBQSwMEFAAGAAgAAAAhAOD8G5tnAQAA3wIAABEACAFkb2NQcm9wcy9jb3JlLnhtbCCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJySy07DMBBF90j8Q+R9YieVUImSVILSVSshUQRiZ+xpa5o4lu025O9xniWiK3bzuHM0vuNk8V3k3hm0EaVMURgQ5IFkJRdyn6LX7cqfI89YKjnNSwkpqsGgRXZ7kzAVs1LDsy4VaCvAeI4kTcxUig7Wqhhjww5QUBM4hXTNXakLal2q91hRdqR7wBEhd7gASzm1FDdAX41E1CM5G5HqpPMWwBmGHAqQ1uAwCPFFa0EX5upA2/mlLIStFVyVDs1R/W3EKKyqKqhmrdTtH+L3zfqlfaovZOMVA5QlnMVW2ByyBF9CF5nT5xcw25XHxMVMA7WlzpZP63XbHAqN1Ueoq1Jz48YmmZNxMEwLZd0BO+ik4NQ5NXbjLroTwB/qnv+33kg1nEXzE7KoVYxp0tva7QTcc3bEnXlD5232uNyuUBaRKPLJ3Cf3WxLGs3lMyEez1mT+Aiz6Bf5NHACdM9Mvmf0AAAD//wMAUEsDBBQABgAIAAAAIQC/cOziegEAAM4CAAAQAAgBZG9jUHJvcHMvYXBwLnhtbCCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJxSTU/DMAy9I/Efqt5ZujHBQF4QGkIc+JLWwTlK3DYiTaIkIPbvcSgrQ3AiJ/vZfnl+CVy896Z4wxC1s8tyOqnKAq10Stt2WW7q66NFWcQkrBLGWVyWW4zlBT88gMfgPIakMRZEYeOy7FLy54xF2WEv4oTKliqNC71IlIaWuabREq+cfO3RJjarqhOG7wmtQnXkR8JyYDx/S/8lVU5mffGp3nri41Bj741IyO/zpJkol3pgIwq1S8LUukdeETwm8ChajPwY2BDAswsq8tPZDNgQwqoTQchEDvL5dDYFtgfApfdGS5HIXH6nZXDRNal4+FRcZAJg+y1AW6xRvgadtlnIfgq32mYpc2BDRNqCaIPwXeRnWeCYwVoKgysygDfCRAT2DcDK9V5Y4mNjRHwvceNrd5W9+Br5Ce6t+axTt/ZCkoT5Isv5swRrQlHRBqOGEYAbepVg8gU0a1tUu57fhWzh0/A9+fRkUtH59GyH0eLjv+EfAAAA//8DAFBLAQItABQABgAIAAAAIQAykW9XZgEAAKUFAAATAAAAAAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAB6RGrfvAAAATgIAAAsAAAAAAAAAAAAAAAAAnwMAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhALJengn1HQAAGVoBABEAAAAAAAAAAAAAAAAAvwYAAHdvcmQvZG9jdW1lbnQueG1sUEsBAi0AFAAGAAgAAAAhAIhTqnwyAgAAjxAAABwAAAAAAAAAAAAAAAAA4yQAAHdvcmQvX3JlbHMvZG9jdW1lbnQueG1sLnJlbHNQSwECLQAUAAYACAAAACEAOgXMGeEGAADOIAAAFQAAAAAAAAAAAAAAAABXKAAAd29yZC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAGAAgAAAAhALLDJSe6BAAAOw0AABEAAAAAAAAAAAAAAAAAay8AAHdvcmQvc2V0dGluZ3MueG1sUEsBAi0AFAAGAAgAAAAhAFBKgX5TBQAAo1YAABIAAAAAAAAAAAAAAAAAVDQAAHdvcmQvbnVtYmVyaW5nLnhtbFBLAQItABQABgAIAAAAIQAOeWEuVA0AAN6BAAAPAAAAAAAAAAAAAAAAANc5AAB3b3JkL3N0eWxlcy54bWxQSwECLQAUAAYACAAAACEA4RbEu2UCAAApEwAAFAAAAAAAAAAAAAAAAABYRwAAd29yZC93ZWJTZXR0aW5ncy54bWxQSwECLQAUAAYACAAAACEA3UQxnhcDAADFDQAAEgAAAAAAAAAAAAAAAADvSQAAd29yZC9mb250VGFibGUueG1sUEsBAi0AFAAGAAgAAAAhAOD8G5tnAQAA3wIAABEAAAAAAAAAAAAAAAAANk0AAGRvY1Byb3BzL2NvcmUueG1sUEsBAi0AFAAGAAgAAAAhAL9w7OJ6AQAAzgIAABAAAAAAAAAAAAAAAAAA1E8AAGRvY1Byb3BzL2FwcC54bWxQSwUGAAAAAAwADAABAwAAhFIAAAAA"
}
測試內(nèi)容需要將附件轉(zhuǎn)換成base64格式
在線轉(zhuǎn)換文件的地址:任意文件轉(zhuǎn)base64-直接拖進(jìn)來
? ? ? ? 查詢剛剛上傳的文件:
{
"took": 861,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 5,
"relation": "eq"
},
"max_score": 1.0,
"hits": [
{
"_index": "fileinfo",
"_type": "_doc",
"_id": "lkPEgYIBz3NlBKQzXYX9",
"_score": 1.0,
"_source": {
"fileName": "測試_20220809164145A002.docx",
"updateTime": 1660034506000,
"attachment": {
"date": "2022-08-09T01:38:00Z",
"content_type": "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
"author": "DELL",
"language": "lt",
"content": "什么是PolarDB\n更新時間:2022-06-06 17:36\n我的收藏\nPolarDB是阿里巴巴自研的新一代云原生關(guān)系型數(shù)據(jù)庫,在存儲計算分離架構(gòu)下,利用了軟硬件結(jié)合的優(yōu)勢,為用戶提供具備極致彈性、高性能、海量存儲、安全可靠的數(shù)據(jù)庫服務(wù)。PolarDB?100%兼容MySQL 5.6/5.7/8.0,PostgreSQL 11,高度兼容Oracle。\nPolarDB采用存儲和計算分離的架構(gòu),所有計算節(jié)點(diǎn)共享一份數(shù)據(jù),提供分鐘級的配置升降級、秒級的故障恢復(fù)、全局?jǐn)?shù)據(jù)一致性和免費(fèi)的數(shù)據(jù)備份容災(zāi)服務(wù)。PolarDB既融合了商業(yè)數(shù)據(jù)庫穩(wěn)定可靠、高性能、可擴(kuò)展的特征,又具有開源云數(shù)據(jù)庫簡單開放、自我迭代的優(yōu)勢,例如PolarDB MySQL引擎作為超級MySQL,性能最高可達(dá)開源MySQL的6倍(在1024并發(fā)sysbench_insert場景下,PolarDB MySQL引擎與開啟主備半同步Semi-Sync的開源MySQL的性能對比),而成本只有商用數(shù)據(jù)庫的1/10,每小時最低只需1.3元即可體驗完整的產(chǎn)品功能。PolarDB MySQL引擎100%兼容原生MySQL和RDS MySQL,您可以在不修改應(yīng)用程序任何代碼和配置的情況下,將MySQL數(shù)據(jù)庫遷移至PolarDB MySQL引擎。\n· 計算與存儲分離,共享分布式存儲。\n采用計算與存儲分離的設(shè)計理念,滿足業(yè)務(wù)彈性擴(kuò)展的需求。各計算節(jié)點(diǎn)通過分布式文件系統(tǒng)(PolarFileSystem)共享底層的存儲(PolarStore),極大降低了用戶的存儲成本。\n· 一寫多讀,讀寫分離。\nPolarDB集群版采用多節(jié)點(diǎn)集群的架構(gòu),集群中有一個主節(jié)點(diǎn)(可讀可寫)和至少一個只讀節(jié)點(diǎn)。當(dāng)應(yīng)用程序使用集群地址時,PolarDB通過內(nèi)部的代理層(PolarProxy)對外提供服務(wù),應(yīng)用程序的請求都先經(jīng)過代理,然后才訪問到數(shù)據(jù)庫節(jié)點(diǎn)。代理層不僅可以做安全認(rèn)證和保護(hù),還可以解析SQL,把寫操作發(fā)送到主節(jié)點(diǎn),把讀操作均衡地分發(fā)到多個只讀節(jié)點(diǎn),實(shí)現(xiàn)自動的讀寫分離。對于應(yīng)用程序來說,就像使用一個單點(diǎn)的數(shù)據(jù)庫一樣簡單。\n產(chǎn)品優(yōu)勢\n您可以像使用MySQL、PostgreSQL、Oracle一樣使用PolarDB。此外,PolarDB還有傳統(tǒng)數(shù)據(jù)庫不具備的優(yōu)勢:\n· 大容量\n最高100 TB,您不再需要因為單機(jī)容量的天花板而去購買多個實(shí)例做分片,由此簡化應(yīng)用開發(fā),降低運(yùn)維負(fù)擔(dān)。\n· 低成本\n· 共享存儲:計算與存儲分離,每增加一個只讀節(jié)點(diǎn)只收取計算資源的費(fèi)用,而傳統(tǒng)的只讀節(jié)點(diǎn)同時包含計算和存儲資源,每增加一個只讀節(jié)點(diǎn)需要支付相應(yīng)的存儲費(fèi)用。\n· 彈性存儲:存儲空間無需配置,根據(jù)數(shù)據(jù)量自動伸縮,您只需為實(shí)際使用的數(shù)據(jù)量按小時付費(fèi)。\n· 存儲包:PolarDB推出了預(yù)付費(fèi)形式的存儲包。當(dāng)您的數(shù)據(jù)量較大時,推薦您使用存儲包,相比按小時付費(fèi),預(yù)付費(fèi)購買存儲包有折扣,購買的容量越大,折扣力度越大。\n· 計算包:PolarDB首創(chuàng)計算包,用于抵扣計算節(jié)點(diǎn)的費(fèi)用,計算包兼顧了包年包月付費(fèi)方式的經(jīng)濟(jì)性和按量付費(fèi)方式的靈活性。您還可以將計算包與自動擴(kuò)縮容配合使用,在業(yè)務(wù)峰值前后實(shí)現(xiàn)自動彈性升降配,輕松應(yīng)對業(yè)務(wù)量波動。\n· 高性能\n大幅提升OLTP性能,支持超過50萬次/秒的讀請求以及超過15萬次/秒的寫請求。\n· 分鐘級擴(kuò)縮容\n存儲與計算分離的架構(gòu),配合容器虛擬化技術(shù)和共享存儲,增減節(jié)點(diǎn)只需5分鐘。存儲容量自動在線擴(kuò)容,無需中斷業(yè)務(wù)。\n· 讀一致性\n集群地址利用LSN(Log Sequence Number)確保讀取數(shù)據(jù)時的全局一致性,避免因為主備延遲引起的不一致。\n· 毫秒級延遲(物理復(fù)制)\n利用基于Redo的物理復(fù)制代替基于Binlog的邏輯復(fù)制,提升主備復(fù)制的效率和穩(wěn)定性。即使對大表進(jìn)行加索引、加字段等DDL操作,也不會造成數(shù)據(jù)庫的延遲。\n· 秒級快速備份\n不論多大的數(shù)據(jù)量,全庫備份只需30秒,而且備份過程不會對數(shù)據(jù)庫加鎖,對應(yīng)用程序幾乎無影響,全天24小時均可進(jìn)行備份。\nPolarDB定價\n詳情請參見計費(fèi)項概覽和購買PolarDB集群。\n如何使用PolarDB\n您可以通過以下方式管理PolarDB集群,包括創(chuàng)建集群、創(chuàng)建數(shù)據(jù)庫、創(chuàng)建賬號等。\n· 控制臺:提供圖形化的Web界面,操作方便。\n· CLI:控制臺上所有的操作都可以通過CLI實(shí)現(xiàn)。\n· SDK:控制臺上所有的操作都可以通過SDK實(shí)現(xiàn)。\n· API:控制臺上所有的操作都可以通過API實(shí)現(xiàn)。\n創(chuàng)建PolarDB集群后,您可以通過以下方式連接PolarDB集群:\n· DMS:您可以通過DMS連接PolarDB集群,在Web界面進(jìn)行數(shù)據(jù)庫開發(fā)工作。\n· 客戶端:您可以使用通用的數(shù)據(jù)庫客戶端工具連接PolarDB集群。例如,MySQL-Front、pgAdmin等。\n相關(guān)概念\n了解以下概念,將幫助您更好地選購和使用PolarDB:\n· 集群:PolarDB集群版采用集群架構(gòu),一個集群版集群中可包含一個主節(jié)點(diǎn)和最多15個只讀節(jié)點(diǎn)。\n· 地域:地域是指物理的數(shù)據(jù)中心。一般情況下,PolarDB集群應(yīng)該和ECS實(shí)例位于同一地域,以實(shí)現(xiàn)最高的訪問性能。\n· 可用區(qū):可用區(qū)是指在某個地域內(nèi)擁有獨(dú)立電力和網(wǎng)絡(luò)的物理區(qū)域。同一地域的不同可用區(qū)之間沒有實(shí)質(zhì)性區(qū)別。\n· 規(guī)格:每個節(jié)點(diǎn)的資源配置,例如2核8 GB。\n相關(guān)服務(wù)\n· ECS:ECS是云服務(wù)器,通過內(nèi)網(wǎng)訪問同一地域的PolarDB集群時,可實(shí)現(xiàn)PolarDB集群的最佳性能。ECS搭配PolarDB集群是典型的業(yè)務(wù)訪問架構(gòu)。\n· Redis:Redis提供持久化的內(nèi)存數(shù)據(jù)庫服務(wù)。當(dāng)業(yè)務(wù)訪問量較大時,ECS 、PolarDB和Redis的組合可以支持更多的讀請求,同時減少響應(yīng)時間。\n· MongoDB:提供穩(wěn)定可靠、彈性伸縮、完全兼容MongoDB協(xié)議的數(shù)據(jù)庫服務(wù)。數(shù)據(jù)結(jié)構(gòu)多樣時,可以選擇將結(jié)構(gòu)化數(shù)據(jù)存儲在PolarDB,將非結(jié)構(gòu)化數(shù)據(jù)存儲在MongoDB,滿足業(yè)務(wù)的多樣化存儲需求。\n· DTS:您可以使用數(shù)據(jù)傳輸服務(wù)DTS將本地數(shù)據(jù)庫遷移到云上的PolarDB。\n· OSS:對象存儲服務(wù)OSS是阿里云提供的海量、安全、低成本、高可靠的云存儲服務(wù)。",
"content_length": 2572
},
"createTime": 1660034506000,
"fileUrl": "http://localhost:8092/fileInfo/profile/upload/fileInfo/2022/08/09/測試_20220809164145A002.docx",
"id": 1306333192,
"contentType": "文章",
"fileType": "docx"
}
},
{
"_index": "fileinfo",
"_type": "_doc",
"_id": "mUPHgYIBz3NlBKQzwIVW",
"_score": 1.0,
"_source": {
"fileName": "測試_20220809164527A001.docx",
"updateTime": 1660034728000,
"attachment": {
"date": "2022-08-09T01:38:00Z",
"content_type": "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
"author": "DELL",
"language": "lt",
"content": "什么是PolarDB\n更新時間:2022-06-06 17:36\n我的收藏\nPolarDB是阿里巴巴自研的新一代云原生關(guān)系型數(shù)據(jù)庫,在存儲計算分離架構(gòu)下,利用了軟硬件結(jié)合的優(yōu)勢,為用戶提供具備極致彈性、高性能、海量存儲、安全可靠的數(shù)據(jù)庫服務(wù)。PolarDB?100%兼容MySQL 5.6/5.7/8.0,PostgreSQL 11,高度兼容Oracle。\nPolarDB采用存儲和計算分離的架構(gòu),所有計算節(jié)點(diǎn)共享一份數(shù)據(jù),提供分鐘級的配置升降級、秒級的故障恢復(fù)、全局?jǐn)?shù)據(jù)一致性和免費(fèi)的數(shù)據(jù)備份容災(zāi)服務(wù)。PolarDB既融合了商業(yè)數(shù)據(jù)庫穩(wěn)定可靠、高性能、可擴(kuò)展的特征,又具有開源云數(shù)據(jù)庫簡單開放、自我迭代的優(yōu)勢,例如PolarDB MySQL引擎作為超級MySQL,性能最高可達(dá)開源MySQL的6倍(在1024并發(fā)sysbench_insert場景下,PolarDB MySQL引擎與開啟主備半同步Semi-Sync的開源MySQL的性能對比),而成本只有商用數(shù)據(jù)庫的1/10,每小時最低只需1.3元即可體驗完整的產(chǎn)品功能。PolarDB MySQL引擎100%兼容原生MySQL和RDS MySQL,您可以在不修改應(yīng)用程序任何代碼和配置的情況下,將MySQL數(shù)據(jù)庫遷移至PolarDB MySQL引擎。\n· 計算與存儲分離,共享分布式存儲。\n采用計算與存儲分離的設(shè)計理念,滿足業(yè)務(wù)彈性擴(kuò)展的需求。各計算節(jié)點(diǎn)通過分布式文件系統(tǒng)(PolarFileSystem)共享底層的存儲(PolarStore),極大降低了用戶的存儲成本。\n· 一寫多讀,讀寫分離。\nPolarDB集群版采用多節(jié)點(diǎn)集群的架構(gòu),集群中有一個主節(jié)點(diǎn)(可讀可寫)和至少一個只讀節(jié)點(diǎn)。當(dāng)應(yīng)用程序使用集群地址時,PolarDB通過內(nèi)部的代理層(PolarProxy)對外提供服務(wù),應(yīng)用程序的請求都先經(jīng)過代理,然后才訪問到數(shù)據(jù)庫節(jié)點(diǎn)。代理層不僅可以做安全認(rèn)證和保護(hù),還可以解析SQL,把寫操作發(fā)送到主節(jié)點(diǎn),把讀操作均衡地分發(fā)到多個只讀節(jié)點(diǎn),實(shí)現(xiàn)自動的讀寫分離。對于應(yīng)用程序來說,就像使用一個單點(diǎn)的數(shù)據(jù)庫一樣簡單。\n產(chǎn)品優(yōu)勢\n您可以像使用MySQL、PostgreSQL、Oracle一樣使用PolarDB。此外,PolarDB還有傳統(tǒng)數(shù)據(jù)庫不具備的優(yōu)勢:\n· 大容量\n最高100 TB,您不再需要因為單機(jī)容量的天花板而去購買多個實(shí)例做分片,由此簡化應(yīng)用開發(fā),降低運(yùn)維負(fù)擔(dān)。\n· 低成本\n· 共享存儲:計算與存儲分離,每增加一個只讀節(jié)點(diǎn)只收取計算資源的費(fèi)用,而傳統(tǒng)的只讀節(jié)點(diǎn)同時包含計算和存儲資源,每增加一個只讀節(jié)點(diǎn)需要支付相應(yīng)的存儲費(fèi)用。\n· 彈性存儲:存儲空間無需配置,根據(jù)數(shù)據(jù)量自動伸縮,您只需為實(shí)際使用的數(shù)據(jù)量按小時付費(fèi)。\n· 存儲包:PolarDB推出了預(yù)付費(fèi)形式的存儲包。當(dāng)您的數(shù)據(jù)量較大時,推薦您使用存儲包,相比按小時付費(fèi),預(yù)付費(fèi)購買存儲包有折扣,購買的容量越大,折扣力度越大。\n· 計算包:PolarDB首創(chuàng)計算包,用于抵扣計算節(jié)點(diǎn)的費(fèi)用,計算包兼顧了包年包月付費(fèi)方式的經(jīng)濟(jì)性和按量付費(fèi)方式的靈活性。您還可以將計算包與自動擴(kuò)縮容配合使用,在業(yè)務(wù)峰值前后實(shí)現(xiàn)自動彈性升降配,輕松應(yīng)對業(yè)務(wù)量波動。\n· 高性能\n大幅提升OLTP性能,支持超過50萬次/秒的讀請求以及超過15萬次/秒的寫請求。\n· 分鐘級擴(kuò)縮容\n存儲與計算分離的架構(gòu),配合容器虛擬化技術(shù)和共享存儲,增減節(jié)點(diǎn)只需5分鐘。存儲容量自動在線擴(kuò)容,無需中斷業(yè)務(wù)。\n· 讀一致性\n集群地址利用LSN(Log Sequence Number)確保讀取數(shù)據(jù)時的全局一致性,避免因為主備延遲引起的不一致。\n· 毫秒級延遲(物理復(fù)制)\n利用基于Redo的物理復(fù)制代替基于Binlog的邏輯復(fù)制,提升主備復(fù)制的效率和穩(wěn)定性。即使對大表進(jìn)行加索引、加字段等DDL操作,也不會造成數(shù)據(jù)庫的延遲。\n· 秒級快速備份\n不論多大的數(shù)據(jù)量,全庫備份只需30秒,而且備份過程不會對數(shù)據(jù)庫加鎖,對應(yīng)用程序幾乎無影響,全天24小時均可進(jìn)行備份。\nPolarDB定價\n詳情請參見計費(fèi)項概覽和購買PolarDB集群。\n如何使用PolarDB\n您可以通過以下方式管理PolarDB集群,包括創(chuàng)建集群、創(chuàng)建數(shù)據(jù)庫、創(chuàng)建賬號等。\n· 控制臺:提供圖形化的Web界面,操作方便。\n· CLI:控制臺上所有的操作都可以通過CLI實(shí)現(xiàn)。\n· SDK:控制臺上所有的操作都可以通過SDK實(shí)現(xiàn)。\n· API:控制臺上所有的操作都可以通過API實(shí)現(xiàn)。\n創(chuàng)建PolarDB集群后,您可以通過以下方式連接PolarDB集群:\n· DMS:您可以通過DMS連接PolarDB集群,在Web界面進(jìn)行數(shù)據(jù)庫開發(fā)工作。\n· 客戶端:您可以使用通用的數(shù)據(jù)庫客戶端工具連接PolarDB集群。例如,MySQL-Front、pgAdmin等。\n相關(guān)概念\n了解以下概念,將幫助您更好地選購和使用PolarDB:\n· 集群:PolarDB集群版采用集群架構(gòu),一個集群版集群中可包含一個主節(jié)點(diǎn)和最多15個只讀節(jié)點(diǎn)。\n· 地域:地域是指物理的數(shù)據(jù)中心。一般情況下,PolarDB集群應(yīng)該和ECS實(shí)例位于同一地域,以實(shí)現(xiàn)最高的訪問性能。\n· 可用區(qū):可用區(qū)是指在某個地域內(nèi)擁有獨(dú)立電力和網(wǎng)絡(luò)的物理區(qū)域。同一地域的不同可用區(qū)之間沒有實(shí)質(zhì)性區(qū)別。\n· 規(guī)格:每個節(jié)點(diǎn)的資源配置,例如2核8 GB。\n相關(guān)服務(wù)\n· ECS:ECS是云服務(wù)器,通過內(nèi)網(wǎng)訪問同一地域的PolarDB集群時,可實(shí)現(xiàn)PolarDB集群的最佳性能。ECS搭配PolarDB集群是典型的業(yè)務(wù)訪問架構(gòu)。\n· Redis:Redis提供持久化的內(nèi)存數(shù)據(jù)庫服務(wù)。當(dāng)業(yè)務(wù)訪問量較大時,ECS 、PolarDB和Redis的組合可以支持更多的讀請求,同時減少響應(yīng)時間。\n· MongoDB:提供穩(wěn)定可靠、彈性伸縮、完全兼容MongoDB協(xié)議的數(shù)據(jù)庫服務(wù)。數(shù)據(jù)結(jié)構(gòu)多樣時,可以選擇將結(jié)構(gòu)化數(shù)據(jù)存儲在PolarDB,將非結(jié)構(gòu)化數(shù)據(jù)存儲在MongoDB,滿足業(yè)務(wù)的多樣化存儲需求。\n· DTS:您可以使用數(shù)據(jù)傳輸服務(wù)DTS將本地數(shù)據(jù)庫遷移到云上的PolarDB。\n· OSS:對象存儲服務(wù)OSS是阿里云提供的海量、安全、低成本、高可靠的云存儲服務(wù)。",
"content_length": 2572
},
"createTime": 1660034728000,
"fileUrl": "http://localhost:8092/fileInfo/profile/upload/fileInfo/2022/08/09/測試_20220809164527A001.docx",
"id": 1306333193,
"contentType": "文章",
"fileType": "docx"
}
},
{
"_index": "fileinfo",
"_type": "_doc",
"_id": "JDqshoIBbkTNu1UgkzFK",
"_score": 1.0,
"_source": {
"fileName": "txt測試_20220810153351A001.txt",
"updateTime": 1660116831000,
"attachment": {
"content_type": "text/plain; charset=UTF-8",
"language": "lt",
"content": "產(chǎn)品優(yōu)勢\r\n您可以像使用MySQL、PostgreSQL、Oracle一樣使用PolarDB。此外,PolarDB還有傳統(tǒng)數(shù)據(jù)庫不具備的優(yōu)勢:\r\n?\t大容量\r\n最高100 TB,您不再需要因為單機(jī)容量的天花板而去購買多個實(shí)例做分片,由此簡化應(yīng)用開發(fā),降低運(yùn)維負(fù)擔(dān)。\r\n?\t低成本\r\no\t共享存儲:計算與存儲分離,每增加一個只讀節(jié)點(diǎn)只收取計算資源的費(fèi)用,而傳統(tǒng)的只讀節(jié)點(diǎn)同時包含計算和存儲資源,每增加一個只讀節(jié)點(diǎn)需要支付相應(yīng)的存儲費(fèi)用。\r\no\t彈性存儲:存儲空間無需配置,根據(jù)數(shù)據(jù)量自動伸縮,您只需為實(shí)際使用的數(shù)據(jù)量按小時付費(fèi)。\r\no\t存儲包:PolarDB推出了預(yù)付費(fèi)形式的存儲包。當(dāng)您的數(shù)據(jù)量較大時,推薦您使用存儲包,相比按小時付費(fèi),預(yù)付費(fèi)購買存儲包有折扣,購買的容量越大,折扣力度越大。\r\no\t計算包:PolarDB首創(chuàng)計算包,用于抵扣計算節(jié)點(diǎn)的費(fèi)用,計算包兼顧了包年包月付費(fèi)方式的經(jīng)濟(jì)性和按量付費(fèi)方式的靈活性。您還可以將計算包與自動擴(kuò)縮容配合使用,在業(yè)務(wù)峰值前后實(shí)現(xiàn)自動彈性升降配,輕松應(yīng)對業(yè)務(wù)量波動。\r\n?\t高性能\r\n大幅提升OLTP性能,支持超過50萬次/秒的讀請求以及超過15萬次/秒的寫請求。\r\n?\t分鐘級擴(kuò)縮容\r\n存儲與計算分離的架構(gòu),配合容器虛擬化技術(shù)和共享存儲,增減節(jié)點(diǎn)只需5分鐘。存儲容量自動在線擴(kuò)容,無需中斷業(yè)務(wù)。\r\n?\t讀一致性\r\n集群地址利用LSN(Log Sequence Number)確保讀取數(shù)據(jù)時的全局一致性,避免因為主備延遲引起的不一致。\r\n?\t毫秒級延遲(物理復(fù)制)\r\n利用基于Redo的物理復(fù)制代替基于Binlog的邏輯復(fù)制,提升主備復(fù)制的效率和穩(wěn)定性。即使對大表進(jìn)行加索引、加字段等DDL操作,也不會造成數(shù)據(jù)庫的延遲。\r\n?\t秒級快速備份\r\n不論多大的數(shù)據(jù)量,全庫備份只需30秒,而且備份過程不會對數(shù)據(jù)庫加鎖,對應(yīng)用程序幾乎無影響,全天24小時均可進(jìn)行備份。",
"content_length": 804
},
"createTime": 1660116831000,
"fileUrl": "http://localhost:8092/fileInfo/profile/upload/fileInfo/2022/08/10/txt測試_20220810153351A001.txt",
"id": 1306333194,
"contentType": "告示",
"fileType": "txt"
}
}
]
}
}
?我們調(diào)用上傳的接口,可以看到文本內(nèi)容已經(jīng)抽取到es里面了,后面就可以直接分詞檢索內(nèi)容,高亮顯示了
三.代碼
? ? ? ? 介紹下代碼實(shí)現(xiàn)邏輯:文件上傳,數(shù)據(jù)庫存儲附件信息和附件上傳地址;調(diào)用es實(shí)現(xiàn)文本內(nèi)容抽取,將抽取的內(nèi)容放到對應(yīng)索引下;提供小程序全文檢索的api實(shí)現(xiàn)根據(jù)文件名稱關(guān)鍵詞聯(lián)想,文件名稱內(nèi)容全文檢索模糊匹配,并高亮顯示分詞匹配字段;直接貼代碼
yml配置文件:
# 數(shù)據(jù)源配置
spring:
# 服務(wù)模塊
devtools:
restart:
# 熱部署開關(guān)
enabled: true
# 搜索引擎
elasticsearch:
rest:
url: 127.0.0.1
uris: 127.0.0.1:9200
connection-timeout: 1000
read-timeout: 3000
username: elastic
password: 123456
elsticsearchConfig(連接配置)
package com.yj.rselasticsearch.domain.config;
import org.apache.http.HttpHost;
import org.apache.http.auth.AuthScope;
import org.apache.http.auth.UsernamePasswordCredentials;
import org.apache.http.impl.client.BasicCredentialsProvider;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import java.time.Duration;
@Configuration
public class ElasticsearchConfig {
@Value("${spring.elasticsearch.rest.url}")
private String edUrl;
@Value("${spring.elasticsearch.rest.username}")
private String userName;
@Value("${spring.elasticsearch.rest.password}")
private String password;
@Bean
public RestHighLevelClient restHighLevelClient() {
//設(shè)置連接的用戶名密碼
final BasicCredentialsProvider credentialsProvider = new BasicCredentialsProvider();
credentialsProvider.setCredentials(AuthScope.ANY, new UsernamePasswordCredentials(userName, password));
RestHighLevelClient client = new RestHighLevelClient(RestClient.builder(
new HttpHost(edUrl, 9200,"http"))
.setHttpClientConfigCallback(httpClientBuilder -> {
httpClientBuilder.disableAuthCaching();
//保持連接池處于鏈接狀態(tài),該bug曾導(dǎo)致es一段時間沒使用,第一次連接訪問超時
httpClientBuilder.setKeepAliveStrategy(((response, context) -> Duration.ofMinutes(5).toMillis()));
return httpClientBuilder.setDefaultCredentialsProvider(credentialsProvider);
})
);
return client;
}
}
文件上傳保存文件信息并抽取內(nèi)容到es
實(shí)體對象FileInfo
package com.yj.common.core.domain.entity;
import com.baomidou.mybatisplus.annotation.TableField;
import com.yj.common.core.domain.BaseEntity;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.Setter;
import org.springframework.data.elasticsearch.annotations.Document;
import org.springframework.data.elasticsearch.annotations.Field;
import org.springframework.data.elasticsearch.annotations.FieldType;
import java.util.Date;
@Setter
@Getter
@Document(indexName = "fileinfo",createIndex = false)
public class FileInfo {
/**
* 主鍵
*/
@Field(name = "id", type = FieldType.Integer)
private Integer id;
/**
* 文件名稱
*/
@Field(name = "fileName", type = FieldType.Text,analyzer = "jieba_index",searchAnalyzer = "jieba_index")
private String fileName;
/**
* 文件類型
*/
@Field(name = "fileType", type = FieldType.Keyword)
private String fileType;
/**
* 內(nèi)容類型
*/
@Field(name = "contentType", type = FieldType.Text)
private String contentType;
/**
* 附件內(nèi)容
*/
@Field(name = "attachment.content", type = FieldType.Text,analyzer = "jieba_index",searchAnalyzer = "jieba_index")
@TableField(exist = false)
private String content;
/**
* 文件地址
*/
@Field(name = "fileUrl", type = FieldType.Text)
private String fileUrl;
/**
* 創(chuàng)建時間
*/
private Date createTime;
/**
* 更新時間
*/
private Date updateTime;
}
controller類
package com.yj.rselasticsearch.controller;
import com.yj.common.core.controller.BaseController;
import com.yj.common.core.domain.AjaxResult;
import com.yj.common.core.domain.entity.FileInfo;
import com.yj.rselasticsearch.service.FileInfoService;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import javax.annotation.Resource;
/**
* (file_info)表控制層
*
* @author xxxxx
*/
@RestController
@RequestMapping("/fileInfo")
public class FileInfoController extends BaseController {
/**
* 服務(wù)對象
*/
@Resource
private FileInfoService fileInfoService;
@PutMapping("uploadFile")
public AjaxResult uploadFile(String contentType, MultipartFile file) {
return fileInfoService.uploadFileInfo(contentType,file);
}
}
serviceImpl實(shí)現(xiàn)類
package com.yj.rselasticsearch.service.impl;
import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.yj.common.config.RuoYiConfig;
import com.yj.common.core.domain.AjaxResult;
import com.yj.common.utils.FastUtils;
import com.yj.common.utils.StringUtils;
import com.yj.common.utils.file.FileUploadUtils;
import com.yj.common.utils.file.FileUtils;
import com.yj.framework.config.ServerConfig;
import lombok.extern.slf4j.Slf4j;
import org.elasticsearch.action.index.IndexRequest;
import org.elasticsearch.action.index.IndexResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.common.xcontent.XContentType;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.data.elasticsearch.core.ElasticsearchRestTemplate;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import com.yj.common.core.domain.entity.FileInfo;
import com.yj.rselasticsearch.mapper.FileInfoMapper;
import com.yj.rselasticsearch.service.FileInfoService;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Base64;
@Service
@Slf4j
public class FileInfoServiceImpl implements FileInfoService{
@Resource
private ServerConfig serverConfig;
@Autowired
@Qualifier("restHighLevelClient")
private RestHighLevelClient client;
@Resource
private FileInfoMapper fileInfoMapper;
/**
* 上傳文件并進(jìn)行文件內(nèi)容識別上傳到es
* @param contentType
* @param file
* @return
*/
@Override
public AjaxResult uploadFileInfo(String contentType, MultipartFile file) {
if (FastUtils.checkNullOrEmpty(contentType,file)){
return AjaxResult.error("請求參數(shù)不能為空");
}
try {
// 上傳文件路徑
String filePath = RuoYiConfig.getUploadPath() + "/fileInfo";
FileInfo fileInfo = new FileInfo();
// 上傳并返回新文件名稱
String fileName = FileUploadUtils.upload(filePath, file);
String prefix = fileName.substring(fileName.lastIndexOf(".")+1);
File files = File.createTempFile(fileName, prefix);
file.transferTo(files);
String url = serverConfig.getUrl() + "/fileInfo" + fileName;
fileInfo.setFileName(FileUtils.getName(fileName));
fileInfo.setFileType(prefix);
fileInfo.setFileUrl(url);
fileInfo.setContentType(contentType);
int result = fileInfoMapper.insertSelective(fileInfo);
if (result > 0) {
fileInfo = fileInfoMapper.selectOne(new LambdaQueryWrapper<FileInfo>().eq(FileInfo::getFileUrl,fileInfo.getFileUrl()));
byte[] bytes = getContent(files);
String base64 = Base64.getEncoder().encodeToString(bytes);
fileInfo.setContent(base64);
IndexRequest indexRequest = new IndexRequest("fileinfo");
//上傳同時,使用attachment pipline進(jìn)行提取文件
indexRequest.source(JSON.toJSONString(fileInfo), XContentType.JSON);
indexRequest.setPipeline("attachment");
IndexResponse indexResponse = client.index(indexRequest, RequestOptions.DEFAULT);
log.info("indexResponse:" + indexResponse);
}
AjaxResult ajax = AjaxResult.success(fileInfo);
return ajax;
} catch (Exception e) {
return AjaxResult.error(e.getMessage());
}
}
/**
* 文件轉(zhuǎn)base64
*
* @param file
* @return
* @throws IOException
*/
private byte[] getContent(File file) throws IOException {
long fileSize = file.length();
if (fileSize > Integer.MAX_VALUE) {
log.info("file too big...");
return null;
}
FileInputStream fi = new FileInputStream(file);
byte[] buffer = new byte[(int) fileSize];
int offset = 0;
int numRead = 0;
while (offset < buffer.length
&& (numRead = fi.read(buffer, offset, buffer.length - offset)) >= 0) {
offset += numRead;
}
// 確保所有數(shù)據(jù)均被讀取
if (offset != buffer.length) {
throw new ServiceException("Could not completely read file "
+ file.getName());
}
fi.close();
return buffer;
}
}
高亮分詞檢索
參數(shù)請求WarningInfoDto
package com.yj.rselasticsearch.domain.dto;
import com.yj.common.core.domain.entity.WarningInfo;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.util.List;
/**
* 前端請求數(shù)據(jù)傳輸
* WarningInfo
* @author luoY
*/
@Data
@ApiModel(value ="WarningInfoDto",description = "告警信息")
public class WarningInfoDto{
/**
* 頁數(shù)
*/
@ApiModelProperty("頁數(shù)")
private Integer pageIndex;
/**
* 每頁數(shù)量
*/
@ApiModelProperty("每頁數(shù)量")
private Integer pageSize;
/**
* 查詢關(guān)鍵詞
*/
@ApiModelProperty("查詢關(guān)鍵詞")
private String keyword;
/**
* 內(nèi)容類型
*/
private List<String> contentType;
/**
* 用戶手機(jī)號
*/
private String phone;
}
controller類
package com.yj.rselasticsearch.controller;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.yj.common.core.controller.BaseController;
import com.yj.common.core.domain.AjaxResult;
import com.yj.common.core.domain.entity.FileInfo;
import com.yj.common.core.domain.entity.WarningInfo;
import com.yj.rselasticsearch.service.ElasticsearchService;
import com.yj.rselasticsearch.service.WarningInfoService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.springframework.web.bind.annotation.*;
import com.yj.rselasticsearch.domain.dto.WarningInfoDto;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.List;
/**
* es搜索引擎
*
* @author luoy
*/
@Api("搜索引擎")
@RestController
@RequestMapping("es")
public class ElasticsearchController extends BaseController {
@Resource
private ElasticsearchService elasticsearchService;
/**
* 告警信息關(guān)鍵詞聯(lián)想
*
* @param warningInfoDto
* @return
*/
@ApiOperation("關(guān)鍵詞聯(lián)想")
@ApiImplicitParams({
@ApiImplicitParam(name = "contenttype", value = "文檔類型", required = true, dataType = "String", dataTypeClass = String.class),
@ApiImplicitParam(name = "keyword", value = "關(guān)鍵詞", required = true, dataType = "String", dataTypeClass = String.class)
})
@PostMapping("getAssociationalWordDoc")
public AjaxResult getAssociationalWordDoc(@RequestBody WarningInfoDto warningInfoDto, HttpServletRequest request) {
List<String> words = elasticsearchService.getAssociationalWordOther(warningInfoDto,request);
return AjaxResult.success(words);
}
/**
* 告警信息高亮分詞分頁查詢
*
* @param warningInfoDto
* @return
*/
@ApiOperation("高亮分詞分頁查詢")
@ApiImplicitParams({
@ApiImplicitParam(name = "keyword", value = "關(guān)鍵詞", required = true, dataType = "String", dataTypeClass = String.class),
@ApiImplicitParam(name = "pageIndex", value = "頁碼", required = true, dataType = "Integer", dataTypeClass = Integer.class),
@ApiImplicitParam(name = "pageSize", value = "頁數(shù)", required = true, dataType = "Integer", dataTypeClass = Integer.class),
@ApiImplicitParam(name = "contenttype", value = "文檔類型", required = true, dataType = "String", dataTypeClass = String.class)
})
@PostMapping("queryHighLightWordDoc")
public AjaxResult queryHighLightWordDoc(@RequestBody WarningInfoDto warningInfoDto,HttpServletRequest request) {
IPage<FileInfo> warningInfoListPage = elasticsearchService.queryHighLightWordOther(warningInfoDto,request);
return AjaxResult.success(warningInfoListPage);
}
}
serviceImpl實(shí)現(xiàn)類
package com.yj.rselasticsearch.service.impl;
import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yj.common.constant.DataConstants;
import com.yj.common.constant.HttpStatus;
import com.yj.common.core.domain.entity.FileInfo;
import com.yj.common.core.domain.entity.WarningInfo;
import com.yj.common.core.domain.entity.WhiteList;
import com.yj.common.core.redis.RedisCache;
import com.yj.common.exception.ServiceException;
import com.yj.common.utils.FastUtils;
import com.yj.rselasticsearch.domain.dto.RetrievalRecordDto;
import com.yj.rselasticsearch.domain.dto.WarningInfoDto;
import com.yj.rselasticsearch.domain.vo.MemberVo;
import com.yj.rselasticsearch.service.*;
import lombok.extern.slf4j.Slf4j;
import org.elasticsearch.action.bulk.BulkRequest;
import org.elasticsearch.action.bulk.BulkResponse;
import org.elasticsearch.action.index.IndexRequest;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.common.xcontent.XContentType;
import org.elasticsearch.index.query.BoolQueryBuilder;
import org.elasticsearch.index.query.Operator;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.fetch.subphase.highlight.HighlightBuilder;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.elasticsearch.core.ElasticsearchRestTemplate;
import org.springframework.data.elasticsearch.core.SearchHits;
import org.springframework.data.elasticsearch.core.query.*;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.*;
import java.util.stream.Collectors;
@Service
@Slf4j
public class ElasticsearchServiceImpl implements ElasticsearchService {
@Resource
private WhiteListService whiteListService;
@Autowired
@Qualifier("restHighLevelClient")
private RestHighLevelClient client;
@Autowired
private RedisCache redisCache;
@Resource
private TokenService tokenService;
/**
* 文檔信息關(guān)鍵詞聯(lián)想(根據(jù)輸入框的詞語聯(lián)想文件名稱)
*
* @param warningInfoDto
* @return
*/
@Override
public List<String> getAssociationalWordOther(WarningInfoDto warningInfoDto, HttpServletRequest request) {
//需要查詢的字段
BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery()
.should(QueryBuilders.matchBoolPrefixQuery("fileName", warningInfoDto.getKeyword()));
//contentType標(biāo)簽內(nèi)容過濾
boolQueryBuilder.must(QueryBuilders.termsQuery("contentType", warningInfoDto.getContentType()));
//構(gòu)建高亮查詢
NativeSearchQuery searchQuery = new NativeSearchQueryBuilder()
.withQuery(boolQueryBuilder)
.withHighlightFields(
new HighlightBuilder.Field("fileName")
)
.withHighlightBuilder(new HighlightBuilder().preTags("<span style='color:red'>").postTags("</span>"))
.build();
//查詢
SearchHits<FileInfo> search = null;
try {
search = elasticsearchRestTemplate.search(searchQuery, FileInfo.class);
} catch (Exception ex) {
ex.printStackTrace();
throw new ServiceException(String.format("操作錯誤,請聯(lián)系管理員!%s", ex.getMessage()));
}
//設(shè)置一個最后需要返回的實(shí)體類集合
List<String> resultList = new LinkedList<>();
//遍歷返回的內(nèi)容進(jìn)行處理
for (org.springframework.data.elasticsearch.core.SearchHit<FileInfo> searchHit : search.getSearchHits()) {
//高亮的內(nèi)容
Map<String, List<String>> highlightFields = searchHit.getHighlightFields();
//將高亮的內(nèi)容填充到content中
searchHit.getContent().setFileName(highlightFields.get("fileName") == null ? searchHit.getContent().getFileName() : highlightFields.get("fileName").get(0));
if (highlightFields.get("fileName") != null) {
resultList.add(searchHit.getContent().getFileName());
}
}
//list去重
List<String> newResult = null;
if (!FastUtils.checkNullOrEmpty(resultList)) {
if (resultList.size() > 9) {
newResult = resultList.stream().distinct().collect(Collectors.toList()).subList(0, 9);
} else {
newResult = resultList.stream().distinct().collect(Collectors.toList());
}
}
return newResult;
}
/**
* 高亮分詞搜索其它類型文檔
*
* @param warningInfoDto
* @param request
* @return
*/
@Override
public IPage<FileInfo> queryHighLightWordOther(WarningInfoDto warningInfoDto, HttpServletRequest request) {
//分頁
Pageable pageable = PageRequest.of(warningInfoDto.getPageIndex() - 1, warningInfoDto.getPageSize());
//需要查詢的字段,根據(jù)輸入的內(nèi)容分詞全文檢索fileName和content字段
BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery()
.should(QueryBuilders.matchBoolPrefixQuery("fileName", warningInfoDto.getKeyword()))
.should(QueryBuilders.matchBoolPrefixQuery("attachment.content", warningInfoDto.getKeyword()));
//contentType標(biāo)簽內(nèi)容過濾
boolQueryBuilder.must(QueryBuilders.termsQuery("contentType", warningInfoDto.getContentType()));
//構(gòu)建高亮查詢
NativeSearchQuery searchQuery = new NativeSearchQueryBuilder()
.withQuery(boolQueryBuilder)
.withHighlightFields(
new HighlightBuilder.Field("fileName"), new HighlightBuilder.Field("attachment.content")
)
.withHighlightBuilder(new HighlightBuilder().preTags("<span style='color:red'>").postTags("</span>"))
.build();
//查詢
SearchHits<FileInfo> search = null;
try {
search = elasticsearchRestTemplate.search(searchQuery, FileInfo.class);
} catch (Exception ex) {
ex.printStackTrace();
throw new ServiceException(String.format("操作錯誤,請聯(lián)系管理員!%s", ex.getMessage()));
}
//設(shè)置一個最后需要返回的實(shí)體類集合
List<FileInfo> resultList = new LinkedList<>();
//遍歷返回的內(nèi)容進(jìn)行處理
for (org.springframework.data.elasticsearch.core.SearchHit<FileInfo> searchHit : search.getSearchHits()) {
//高亮的內(nèi)容
Map<String, List<String>> highlightFields = searchHit.getHighlightFields();
//將高亮的內(nèi)容填充到content中
searchHit.getContent().setFileName(highlightFields.get("fileName") == null ? searchHit.getContent().getFileName() : highlightFields.get("fileName").get(0));
searchHit.getContent().setContent(highlightFields.get("content") == null ? searchHit.getContent().getContent() : highlightFields.get("content").get(0));
resultList.add(searchHit.getContent());
}
//手動分頁返回信息
IPage<FileInfo> warningInfoIPage = new Page<>();
warningInfoIPage.setTotal(search.getTotalHits());
warningInfoIPage.setRecords(resultList);
warningInfoIPage.setCurrent(warningInfoDto.getPageIndex());
warningInfoIPage.setSize(warningInfoDto.getPageSize());
warningInfoIPage.setPages(warningInfoIPage.getTotal() % warningInfoDto.getPageSize());
return warningInfoIPage;
}
}
代碼測試:
文章來源:http://www.zghlxwxcb.cn/news/detail-406015.html
--請求jason
{
"keyword":"全庫備份",
"contentType":["告示"],
"pageIndex":1,
"pageSize":10
}
--響應(yīng)
{
"msg": "操作成功",
"code": 200,
"data": {
"records": [
{
"id": 1306333194,
"fileName": "txt測試_20220810153351A001.txt",
"fileType": "txt",
"contentType": "告示",
"content": "?\t秒級快速<span style='color:red'>備份</span>\r\n不論多大的數(shù)據(jù)量,<span style='color:red'>全庫</span><span style='color:red'>備份</span>只需30秒,而且<span style='color:red'>備份過程</span>不會對數(shù)據(jù)庫加鎖,對應(yīng)用程序幾乎無影響,全天24小時均可進(jìn)行<span style='color:red'>備份</span>。",
"fileUrl": "http://localhost:8092/fileInfo/profile/upload/fileInfo/2022/08/10/txt測試_20220810153351A001.txt",
"createTime": "2022-08-10T15:33:51.000+08:00",
"updateTime": "2022-08-10T15:33:51.000+08:00"
}
],
"total": 1,
"size": 10,
"current": 1,
"orders": [],
"optimizeCountSql": true,
"searchCount": true,
"countId": null,
"maxLimit": null,
"pages": 1
}
}
?返回的內(nèi)容將分詞檢索到匹配的內(nèi)容,并將匹配的詞高亮顯示文章來源地址http://www.zghlxwxcb.cn/news/detail-406015.html
到了這里,關(guān)于springboot+Elasticsearch實(shí)現(xiàn)word,pdf,txt內(nèi)容抽取并高亮分詞全文檢索的文章就介紹完了。如果您還想了解更多內(nèi)容,請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章,希望大家以后多多支持TOY模板網(wǎng)!