postgres

Documentation

Index

• Variables
• func Connect(url *url.URL) (*sqlx.DB, error)
• func Downgrade(url *url.URL) error
• func Upgrade(url *url.URL) error
• type UserStore
  • func (db *UserStore) Create(firstName string, lastName string, email string) (*models.User, error)
  • func (db *UserStore) Find(id string) (*models.User, error)

Variables

var Migrations = []db.Migration{
	{
		ID: "create_users_table",
		Up: func(tx *sqlx.Tx) error {
			_, err := tx.Exec(`
				CREATE TABLE IF NOT EXISTS users (
					id TEXT PRIMARY KEY,
					first_name TEXT NOT NULL,
					last_name TEXT NOT NULL,
					email TEXT NOT NULL UNIQUE,
					locked BOOLEAN NOT NULL DEFAULT FALSE,
					created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
					deleted_at TIMESTAMPTZ
				)
			`)
			return err
		},
		Down: func(tx *sqlx.Tx) error {
			_, err := tx.Exec("DROP TABLE users")
			return err
		},
	},
}

Functions

func Connect

func Connect(url *url.URL) (*sqlx.DB, error)

func Downgrade

func Downgrade(url *url.URL) error

func Upgrade

func Upgrade(url *url.URL) error

Types

type UserStore

type UserStore struct {
	sqlx.Ext
}

func (*UserStore) Create

func (db *UserStore) Create(firstName string, lastName string, email string) (*models.User, error)

func (*UserStore) Find

func (db *UserStore) Find(id string) (*models.User, error)