upsert-session.sql 537 B

1234567891011121314
  1. INSERT INTO sessions
  2. (session_key, version, created_at, cwd, parent_session, seed_length, origin,
  3. delegation_depth, agent_preset, incarnation, revision)
  4. VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0)
  5. ON CONFLICT(session_key) DO UPDATE SET
  6. version = excluded.version,
  7. created_at = excluded.created_at,
  8. cwd = excluded.cwd,
  9. parent_session = excluded.parent_session,
  10. seed_length = excluded.seed_length,
  11. origin = excluded.origin,
  12. delegation_depth = excluded.delegation_depth,
  13. agent_preset = excluded.agent_preset
  14. RETURNING id;