Skip to content

Latest commit

 

History

History

APIJSONDemo-MultiDataSource-Elasticsearch

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
libs
libs
 
 
src/main
src/main
 
 
README.md
README.md
 
 
pom.xml
pom.xml
 
 

README.md

APIJSONDemo

支持多数据源

数据源解析顺序:

  • 对象@datasource

  • 全局 @datasource

  • 应用默认 @datasource

    {
  // "@datasource": "db2" 全局
	"@post": {
		"User:aa": {
			 "@datasource": "db2" // 对象
		},
		"User_address[]": {
			 "@datasource": "db2"
		}
	},
    "User:aa":{
        "username":"test-3",
        "password": "233223",
		"state": 1
    },
    "ES_blog:a": {
        "@datasource": "elasticSearch",
        "title.keyword": "test-2"
    },
    "User_address[]": [
    	{
    	"user_id@": "User:aa/id",
    	"addr": "ddd",
    	"count@": "ES_blog:a/count"
    	},
    	{
    	"user_id@": "User:aa/id",
    	"addr": "ddd1",
    	"count@": "ES_blog:a/count"
    	}
    ],
    "@explain": true
}

    image

集成elasticsearch-sql

换成xpack, 也一样

应用导入: elasticsearch-sql-7.17.5.0.jar

apijson elasticsearch type支持

APIJSONSQLConfig.TABLE_KEY_MAP.put("ES_blog", "es_blog/doc");

apijson支持elasticsearch功能点

新增���修改、删除、查询

elasticsearch-sql不支持RLIKE

image

apijson支持字段 .keyword

{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
    "title.keyword$": "%test-2",
		"content": "u-c-2",
		"url": "u-u-2",
		"postdate": "2008-12-11",
		"count": 1
    },
    "tag": "ES_blog",
    "@explain": true
}

示例

单条插入

http://localhost:8080/post

{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
        "title":"test-1",
        "author": "a-1",
		"content": "c-1",
		"url": "u-1",
		"postdate": "2018-12-11",
		"count": 1
    },
    "tag": "ES_blog",
    "@explain": true
}

elasticsearch查询插入的数据:

GET /es_blog/_doc/5b77b103-0231-42c3-a6cf-a0cb933d3dda

批量插入

http://localhost:8080/post

{
	"@datasource": "elasticSearch",
    "ES_blog:aa[]": [
        {
            "title":"test-1",
	        "author": "a-1",
			"content": "c-1",
			"url": "u-1",
			"postdate": "2018-12-11",
			"count": 1
        },
        {
            "title":"test-2",
	        "author": "a-2",
			"content": "c-2",
			"url": "u-2",
			"postdate": "2018-12-11",
			"count": 2
        },
        {
            "title":"test-3",
	        "author": "a-3",
			"content": "c-3",
			"url": "u-3",
			"postdate": "2018-12-11",
			"count": 3
        }
    ],
    "tag": "ES_blog[]",
    "@explain": true
}

elasticsearch查询插入的数据:

GET /es_blog/_search

id修改

http://localhost:8080/put

{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
    	"id": "5b77b103-0231-42c3-a6cf-a0cb933d3dda",
        "title":"u-test-1",
        "author": "u-a-1",
		"content": "u-c-1",
		"url": "u-u-1",
		"postdate": "2018-12-10",
		"count": 9
    },
    "tag": "ES_blog",
    "@explain": true
}

非id修改

http://localhost:8080/put
{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
    	"title~":"u-test-1",
        "author": "u1-a-2",
		"content": "u1-c-2",
		"url": "u1-u-2",
		"postdate": "2028-12-11",
		"count": 1
    },
    "tag": "ES_blog",
    "@explain": true
}


{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
    	"title~":"test-3",
        "author~": "u3-a-2",
		"content": "u1-c-2",
		"url": "u1-u-2",
		"postdate": "2028-12-11",
		"count": 1,
		"@combine":"title~ | author~"
    },
    "tag": "ES_blog",
    "@explain": true
}

{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
    	"count{}":[1,4],
		"content": "u-c-2",
		"url": "u-u-2",
		"postdate": "2008-12-11",
		"count": 1
    },
    "tag": "ES_blog",
    "@explain": true
}

{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
    	"title$": "%test",
		"content": "u-c-2",
		"url": "u-u-2",
		"postdate": "2008-12-11",
		"count": 1
    },
    "tag": "ES_blog",
    "@explain": true
}


{
	"@datasource": "elasticSearch",
    "ES_blog:aa":{
    	"postdate%":"2007-10-01,2018-10-01",
		"content": "u-c-2",
		"url": "u-u-2",
		"postdate": "2008-12-11",
		"count": 1
    },
    "tag": "ES_blog",
    "@explain": true
}

批量修改

http://localhost:8080/put
{
	"@datasource": "elasticSearch",
    "ES_blog:aa[]": [
        {
	        "title~":"test-1",
	        "author": "u3-a-2",
			"content": "u3-c-2",
			"url": "u3-u-2",
			"postdate": "2038-12-11",
			"count": 1
        },
        {
	    	"title~":"test-2",
	        "author": "u-a-3",
			"content": "u-c-3",
			"url": "u-u-3",
			"postdate": "2008-12-11",
			"count": 4
        }
    ],
    "tag": "ES_blog[]",
    "explain": true
}

id删除

{
	"@datasource": "elasticSearch",
    "ES_blog:del": {
        "id": "043a7511-296b-43b5-9f12-966dd86299d1"
    },
    "tag": "ES_blog",
    "explain": true
}

非id条件删除

http://localhost:8080/delete

{
	"@datasource": "elasticSearch",
    "ES_blog:del": {
        "title": "test-2"
    },
    "tag": "ES_blog",
    "explain": true
}

{
	"@datasource": "elasticSearch",
    "ES_blog:del": {
        "count{}":[2,4]
    },
    "tag": "ES_blog",
    "explain": true
}

批量删除

{
	"@datasource": "elasticSearch",
    "ES_blog:del": {
        "id{}": ["f41e3010-c410-45a0-b41a-33afbc1e4ef8","d765de31-2fc8-40e5-9430-277bf7e5f91b"]
    },
    "tag": "ES_blog",
    "explain": true
}

查询单条记录

{
    "ES_blog:a": {
        "@datasource": "elasticSearch",
        "id": "4862927d-9a38-47c9-9cfc-5b3e9db38d30"
    },
    "@explain": true
}

分页查询

{
  "[]": {
    "ES_blog": {
    	"@datasource": "elasticSearch"
    },
    "page": 0,
    "count": 2,
    "query": 2
  },
  "total@": "/[]/total"
}

分组查询

{
	 "@datasource": "elasticSearch",
	"[]": {
		"count": 5,
		"ES_blog":{
			"@column":"count;sum(count):sum",
			"@group":"count"
		}
	}
}