Skip to content

FEAT:搜索功能迭代 #18

Closed
master1lan opened this issue Feb 23, 2023 · 5 comments
Closed

FEAT:搜索功能迭代 #18

master1lan opened this issue Feb 23, 2023 · 5 comments
Assignees
Labels
enhancement New feature or request good first issue Good for newcomers

Comments

@master1lan
Copy link
Member

目前获取视频接口的q字段支持name和tag的查询。但是只能返回全字匹配的内容。
请求更改为模糊匹配,为了方便用户查询建议q字段额外添加视频标题的查询,可以以title作为查询字段。

@kazami139 kazami139 added the enhancement New feature or request label Feb 23, 2023
@kazami139 kazami139 added this to To do in EOEFANS 1.0~2.0 via automation Feb 23, 2023
@kazami139 kazami139 changed the title FEAT:获取视频添加模糊搜索以及支持搜索视频标题 FEAT:获取视频添加模糊搜索以及支持搜索视频标题 Feb 23, 2023
@kazami139 kazami139 pinned this issue Feb 23, 2023
@kazami139 kazami139 unpinned this issue Feb 23, 2023
@kazami139 kazami139 added the good first issue Good for newcomers label Feb 27, 2023
@kazami139 kazami139 pinned this issue Feb 27, 2023
@kazami139
Copy link
Member

尽快提上日程。

@kazami139 kazami139 changed the title FEAT:获取视频添加模糊搜索以及支持搜索视频标题 FEAT:搜索功能迭代 Mar 5, 2023
@kazami139
Copy link
Member

kazami139 commented Mar 5, 2023

@runs 在现有搜索tag的基础上,增加:

  • 搜索视频标题
  • 搜索up主名字

@kazami139
Copy link
Member

cp的tag请看这个issue
EOEFANS/eoefans-web#42

@kazami139
Copy link
Member

kazami139 commented Mar 5, 2023

关于CP搜索,目前的想法是:
@runs @master1lan

转移至 #30

runs added a commit that referenced this issue Mar 7, 2023
@runs
Copy link
Member

runs commented Mar 7, 2023

  • 新增了 title 作为关键词
  • 所有使用AND连接的查询 会进行 LIKE 查询
  • 出于性能的考量 OR 连接的查询 则依然使用 IN 查询

得益于迁移到postgreSQL,目前tag支持 数组操作符 进行查询
目前我使用下述这个方案进行查询,如果满足需要额外的支持,我可以配合添加

if strings.ToLower(item.Key) == "tag" {
	switch item.Type {
	case query_parser.TypeAND:
		tx = tx.Where("tag_list @> ?", pq.StringArray(item.Values))
	case query_parser.TypeOR:
		tx = tx.Where("tag_list && ?", pq.StringArray(item.Values))
	}
	continue
}

@kazami139 kazami139 moved this from To do to In progress in EOEFANS 1.0~2.0 Mar 7, 2023
@kazami139 kazami139 removed this from In progress in EOEFANS 1.0~2.0 Mar 8, 2023
@runs runs closed this as completed Mar 14, 2023
@kazami139 kazami139 unpinned this issue Mar 14, 2023
Sign in to join this conversation on GitHub.
Labels
enhancement New feature or request good first issue Good for newcomers
Projects
Status: Done
Development

No branches or pull requests

4 participants