db

Documentation

Index

• Constants
• func Connect() (*pgx.Conn, error)
• func InitDatabase(conn *pgx.Conn) error

Constants

const (
	CreateFileTable = `
		CREATE TABLE Files (
			FileID SERIAL PRIMARY KEY,
			FileName TEXT,
			FileURL TEXT,
			PreviewURL TEXT
		);
	`

	CreateTagTable = `
		CREATE TABLE Tags (
			TagID SERIAL PRIMARY KEY,
			Name TEXT,
			Description TEXT
		);
	`

	CreateLibraryTable = `` /* 243-byte string literal not displayed */

	QueryLibraryExists = `
		SELECT EXISTS (
			SELECT 1
			FROM information_schema.tables 
			WHERE table_name = 'library'
		);
	`
)

Functions

func Connect

func Connect() (*pgx.Conn, error)

func InitDatabase

func InitDatabase(conn *pgx.Conn) error