initial commit

[urlittler] / src / db / postgres / sql / link-upsert.sql

INSERT INTO link (id, url, auth_token)
        VALUES
                ($(id), $(url), $(authToken))
        ON CONFLICT (id) DO UPDATE
        SET
                url = $(url)
RETURNING *,
        extract(epoch from created) AS created,
        extract(epoch from last_access) AS last_access,
        extract(epoch from expires) AS expires