Function insertSkill

packages/core/src/db/skill-queries.ts:39–60

(skill: Skill)

}

export async function insertSkill(skill: Skill): Promise<void> {
  const database = await getDB();
  const deviceId = await getDeviceId();
  const syncVersion = await nextSyncVersion(database, "skills");
  await database.execute(
    "INSERT INTO skills (id, name, description, icon, enabled, parameters, prompt, built_in, created_at, updated_at, sync_version, last_modified_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
    [
      skill.id,
      skill.name,
      skill.description,
      skill.icon || null,
      skill.enabled ? 1 : 0,
      JSON.stringify(skill.parameters),
      skill.prompt,
      skill.builtIn ? 1 : 0,
      skill.createdAt,
      skill.updatedAt,
      syncVersion,
      deviceId,
    ],
  );
}

export async function upsertSkill(skill: Skill): Promise<void> {
  const database = await getDB();