相似软件推荐

[wangsongc]

1、按软件清单集成到github_projects_t
/sync/github/repo/projects
2、根据软件清单集成AI推荐软件到alternative_projects
/sync/alternative
3、通过alternative_projects中新增的推荐软件再github仓库接口集成到github_projects_t
/sync/github/repo/projects
4、根据github表刷新alternative_projects表中的字段

UPDATE alternative_projects t1 INNER JOIN github_projects t2 ON t1.alternative_url= t2.html_url
  SET t1.alternative_id= t2.id, t1.alternative_name = t2.full_name, t1.approved=1
	WHERE t1.alternative_id IS NULL;

UPDATE alternative_projects t1 INNER JOIN github_projects_t t2 ON t1.alternative_url= t2.html_url
  SET t1.alternative_id= t2.id, t1.alternative_name = t2.full_name, t1.approved=0
	WHERE t1.alternative_id IS NULL AND t1.approved IS NULL and t2.data_type = 2;

5、人工排查、筛选出来的AI推荐软件调用全量数据接口
/sync/syncSingleProjectAllMetadata

6、数据刷新到excel

select project_id,
       tt.full_name,
       t.html_url,
       group_concat(tt.alternative_name, '\n') as alternative_name,
       group_concat(tt.alternative_url, '\n')  as alternative_url,
       group_concat(tt.stargazers_count, '\n') as stargazers_count
from github_projects_t t
         left join (select git.stargazers_count,
                           alt.alternative_id,
                           alt.alternative_name,
                           alt.alternative_url,
                           alt.project_id,
                           alt.full_name
                    from alternative_projects alt
                             left join github_projects_t git on alt.alternative_id = git.id
                    where git.stargazers_count > 500
                      and git.archived = 0) tt on t.id = tt.project_id
where alternative_id is not null
group by tt.project_id, tt.full_name, t.html_url;