--:name get-all-fortunes :? :*
-- select all records from the fortune table
SELECT * FROM "fortune"

-- :name update-world! :! :1
-- update an existing world record
UPDATE "world"
SET "randomnumber" = :randomnumber
WHERE id = :id

-- :name get-world :? :1
-- get world by id
SELECT * FROM "world"
WHERE id = :id