sql.go

package db

var selectUserByToken = `
SELECT
	u.id AS id,
	username,
	email,
	is_admin,
	is_blocked
FROM
	users u,
	tokens t
WHERE
	u.id = t.user_id AND
	t.token = $1
LIMIT 1
`

var countOfObjectByBucketAndRandomKey = `
SELECT
	COUNT(*) as count
FROM
	objects
WHERE
	bucket = $1 AND
	random_key = $2
`

var insertShortURL = `
INSERT INTO
	objects (bucket_key, bucket, key, random_key, dir, type, dest_url, content_type, associated_user)
VALUES
	($1, 'public', $2, $2, '/', 1, $3, NULL, $4)
`

var insertFile = `
INSERT INTO
	objects (bucket_key, bucket, key, random_key, dir, content_type, content_length, md5_hash, associated_user)
VALUES
	($1, 'public', $2, $3, '/', $4, $5, $6, $7)
`

var selectUserByUsernameOrEmail = `
SELECT
	id
FROM
	users
WHERE
	username_lower = $1 OR
	email = $2
`

var insertUser = `
INSERT INTO
	users (id, username, username_lower, email)
VALUES
	($1, $2, $3, $4)
`

var insertToken = `
INSERT INTO
	tokens (user_id, token)
VALUES
	($1, $2)
`