projects
/
webmention-receiver
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
WIP
[webmention-receiver]
/
src
/
db
/
postgres
/
sql
/
channel-insert.sql
1
--
2
WITH
new_id
AS
(
3
SELECT
uuid_generate_v1
()
AS id
4
)
5
INSERT INTO
channel
(
account_id
,
channel_id
,
name
,
uid
)
VALUES
(
6
$
(
accountId
),
7
(
SELECT id FROM
new_id
),
8
$
(
name
),
9
COALESCE
(
$
(
uid
), (
SELECT id FROM
new_id
):
:text
)
10
)
11
RETURNING
*