sql

Documentation

Index

• Constants

Constants

const CreateLink = `
	INSERT INTO links (
		url, created_by, created_at
	)
	VALUES (
		$1, $2, NOW()
	)
	RETURNING id
`

const CreateSchema = `
	CREATE TABLE IF NOT EXISTS schema_migrations (
		version integer
	);
`

const GetLinkByID = `
	SELECT id, url, created_by, created_at
	FROM links
	WHERE id = $1
`

const GetLinkByURL = `
	SELECT id, url, created_by, created_at
	FROM links
	WHERE url = $1
`

const InsertSchema = `
	INSERT INTO schema_migrations (version) VALUES (0);
`

const SelectSchema = `
	SELECT * FROM schema_migrations;
`