save.sql 376 B

123456789
  1. INSERT INTO goto (hash, content, qr, preview, created) VALUES (:hash, :content, :qr, json(:preview), CURRENT_TIMESTAMP)
  2. ON CONFLICT DO
  3. UPDATE SET
  4. content = excluded.content,
  5. created = excluded.created,
  6. qr = excluded.qr,
  7. preview = excluded.preview
  8. WHERE excluded.created > goto.created;
  9. SELECT 'dynamic' AS component, sqlpage.run_sql('sqlpage/link.sql') AS properties;