Method insertSkillVersion

packages/memos-core/src/storage/sqlite.ts:1950–1955

(sv: SkillVersion)

  // ─── Skill Versions ───

  insertSkillVersion(sv: SkillVersion): void {
    this.db.prepare(`
      INSERT OR REPLACE INTO skill_versions (id, skill_id, version, content, changelog, change_summary, upgrade_type, source_task_id, metrics, quality_score, created_at)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    `).run(sv.id, sv.skillId, sv.version, sv.content, sv.changelog, sv.changeSummary, sv.upgradeType, sv.sourceTaskId, sv.metrics, sv.qualityScore, sv.createdAt);
  }

  getLatestSkillVersion(skillId: string): SkillVersion | null {
    const row = this.db.prepare("SELECT * FROM skill_versions WHERE skill_id = ? ORDER BY version DESC LIMIT 1").get(skillId) as SkillVersionRow | undefined;