Method getSkillsByTask

packages/memos-core/src/storage/sqlite.ts:1985–1996

(taskId: string)

  }

  getSkillsByTask(taskId: string): Array<{ skill: Skill; relation: TaskSkillRelation; versionAt: number }> {
    const rows = this.db.prepare(`
      SELECT s.*, ts.relation, ts.version_at
      FROM task_skills ts JOIN skills s ON s.id = ts.skill_id
      WHERE ts.task_id = ?
    `).all(taskId) as Array<SkillRow & { relation: string; version_at: number }>;
    return rows.map(r => ({
      skill: rowToSkill(r),
      relation: r.relation as TaskSkillRelation,
      versionAt: r.version_at,
    }));
  }

  getTasksBySkill(skillId: string): Array<{ task: Task; relation: TaskSkillRelation }> {
    const rows = this.db.prepare(`