Function updateSkill

packages/core/src/db/skill-queries.ts:98–137

(id: string, updates: Partial<Skill>)

}

export async function updateSkill(id: string, updates: Partial<Skill>): Promise<void> {
  const database = await getDB();
  const sets: string[] = [];
  const values: unknown[] = [];

  if (updates.name !== undefined) {
    sets.push("name = ?");
    values.push(updates.name);
  }
  if (updates.description !== undefined) {
    sets.push("description = ?");
    values.push(updates.description);
  }
  if (updates.enabled !== undefined) {
    sets.push("enabled = ?");
    values.push(updates.enabled ? 1 : 0);
  }
  if (updates.parameters !== undefined) {
    sets.push("parameters = ?");
    values.push(JSON.stringify(updates.parameters));
  }
  if (updates.prompt !== undefined) {
    sets.push("prompt = ?");
    values.push(updates.prompt);
  }
  // Add sync tracking
  const deviceId = await getDeviceId();
  const syncVersion = await nextSyncVersion(database, "skills");
  const updatedAt = await nextUpdatedAt(database, "skills", id);
  sets.push("updated_at = ?");
  values.push(updatedAt);
  sets.push("sync_version = ?");
  values.push(syncVersion);
  sets.push("last_modified_by = ?");
  values.push(deviceId);

  if (sets.length === 0) return;
  values.push(id);
  await database.execute(`UPDATE skills SET ${sets.join(", ")} WHERE id = ?`, values);
}

export async function deleteSkill(id: string): Promise<void> {
  const database = await getDB();