mirror of
https://github.com/rjNemo/go-wiki
synced 2026-06-06 02:36:40 +00:00
55 lines
1.3 KiB
Go
55 lines
1.3 KiB
Go
package data
|
|
|
|
const (
|
|
// CreateTablePages is the SQL command used to create the pages table if it
|
|
// not exists.
|
|
CreateTablePages = `
|
|
CREATE TABLE IF NOT EXISTS pages (
|
|
id SERIAL PRIMARY KEY,
|
|
title TEXT UNIQUE NOT NULL,
|
|
body TEXT)
|
|
`
|
|
|
|
// GetPage is the SQL command used to retrieve a user from the table
|
|
GetPage = `
|
|
SELECT * FROM pages WHERE title = $1;
|
|
`
|
|
|
|
// GetAllPages is the SQL command used to retrieve all pages from the database.
|
|
GetAllPages = `
|
|
SELECT * FROM pages ORDER BY title;
|
|
`
|
|
|
|
// FindPages is the SQL command used to retrieve all pages from the table
|
|
// which satisfy the specified condition
|
|
FindPages = `
|
|
SELECT * FROM pages WHERE $1 = $2;
|
|
`
|
|
|
|
// InsertPage is the SQL command used to insert a user in the table.
|
|
// Returning the new ID.
|
|
InsertPage = `
|
|
INSERT INTO pages (title, body)
|
|
VALUES ($1, $2)
|
|
RETURNING id
|
|
`
|
|
|
|
// UpdatePage is the SQL command used to update a user in the database.
|
|
UpdatePage = `
|
|
UPDATE pages
|
|
SET title = $2, body = $3
|
|
WHERE id = $1;
|
|
`
|
|
|
|
// DeletePage is the SQL command used to delete a user from the database.
|
|
DeletePage = `
|
|
DELETE FROM pages
|
|
WHERE id = $1
|
|
RETURNING *;
|
|
`
|
|
|
|
// ExistsPage is the SQL command used to check whether a page from the database.
|
|
ExistsPage = `
|
|
SELECT EXISTS(SELECT * FROM pages WHERE title = $1)
|
|
`
|
|
)
|