SELECT 
 col1,
 col2,
 ...
WHERE NOT EXISTS (
 SELECT 1 FROM "table" WHERE "table"."id" = sqlc.arg('tableId')
);

N/A

CREATE TABLE IF NOT EXISTS "rels" (
 "id" text PRIMARY KEY NOT NULL,
 "type" integer NOT NULL,
 "left" text NOT NULL,
 "right" text NOT NULL,
 "metadata" blob,
 "created" integer NOT NULL
) STRICT;

-- name: InsertPostReact :exec
INSERT INTO "rels" (
 id,
 type,
 left,
 right,
 metadata,
 created
)
SELECT
 sqlc.arg('id'),
 sqlc.arg('type'),
 sqlc.arg('left'),
 sqlc.arg('right'),
 sqlc.arg('metadata'),
 sqlc.arg('created')
WHERE NOT EXISTS (
 SELECT
 1
 FROM
 "rels"
 WHERE
 "rels"."left" = sqlc.arg('left') AND
 "rels"."right" = sqlc.arg('right') AND
 "rels"."type" = sqlc.arg('prohibitedType') 
)
LIMIT 1;

version: "2"
sql:
 - engine: "sqlite"
 queries: "db/query.sql"
 schema: "db/schema.sql"
 gen:
 go:
 package: "dbv2"
 out: "dbv2"