query

Documentation

Index

• Constants

Constants

const CountCreate = `
INSERT INTO count (count_id, date, link_id) VALUES ($1, now(), $2)
`

const CountGet = `
SELECT count(*) FROM count where link_id=$1`

const CreatePostgresql = `` /* 1302-byte string literal not displayed */

const LinkAllByUser = `` /* 337-byte string literal not displayed */

const LinkByAPIPoint = `` /* 133-byte string literal not displayed */

const LinkById = `
SELECT link_id, title, url, api_point, created_at, links.user_id
    FROM links
    WHERE link_id=$1 AND deleted_at is null
`

const LinkCreate = `
INSERT INTO links (link_id, title, url, api_point, created_at, user_id) VALUES ($1, $2, $3, $4, now(), $5)
`

const LinkDelete = `
UPDATE links
    SET deleted_at=now()
    WHERE link_id=$1 AND user_id=$2 AND deleted_at is NULL
`

const LinkIsApiPointExist = `
SELECT count(*)
    FROM links WHERE api_point=$1
`

const UserById = `
SELECT user_id, name FROM user WHERE user_id=$1 AND deleted_at IS NULL
`

const UserConnection = `
SELECT user_id, count(*) from users where name=lower($1) and password=$2 and deleted_at is null group by user_id
`

const UserCreate = `
INSERT INTO users (user_id, name, password, created_at) VALUES ($1, lower($2), $3, now())
`

const UserExist = `
SELECT count(*) FROM users WHERE user_id=$1 and name=lower($2) AND deleted_at is null
`