sqlstore

README

Running tests towards local database

Get postgres docker image

docker pull postgres

Run postgres image and forward port to localhost

docker run --name postgres -e POSTGRES_PASSWORD=your_password -p 5432:5432 postgres

Connect to postgres database and create events table

docker run -it --rm --link postgres:postgres postgres psql -h postgres -U postgres

Paste contents of schema.sql to create table.

Run tests

env POSTGRES_CONN_STRING="user=postgres password=your_password sslmode=disable" go test -v

Documentation

Index

• func BySequenceID(value string) eventsource.QueryOption
• func ByTimestamp(value int64) eventsource.QueryOption
• func ByType(value string) eventsource.QueryOption
• func New(db *sql.DB, tableName string) eventsource.Store
• func NewPgx(db driver.PgxPool, tableName string) eventsource.Store
• func WithAscending() eventsource.QueryOption
• func WithDescending() eventsource.QueryOption
• func WithLimit(limit int) eventsource.QueryOption
• func WithOffset(offset int) eventsource.QueryOption
• type EventDB

Functions

func BySequenceID

func BySequenceID(value string) eventsource.QueryOption

func ByTimestamp

func ByTimestamp(value int64) eventsource.QueryOption

func ByType

func ByType(value string) eventsource.QueryOption

func New

func New(db *sql.DB, tableName string) eventsource.Store

New creates a new event source store.

func NewPgx

func NewPgx(db driver.PgxPool, tableName string) eventsource.Store

NewPgx creates a new event source store.

func WithAscending

func WithAscending() eventsource.QueryOption

WithAscending will set the sorting order to ascending.

func WithDescending

func WithDescending() eventsource.QueryOption

WithDescending will set the sorting order to descending.

func WithLimit

func WithLimit(limit int) eventsource.QueryOption

WithLimit will limit the result.

func WithOffset

func WithOffset(offset int) eventsource.QueryOption

WithOffset will offset the result.

Types

type EventDB

type EventDB interface {
	Load(ctx context.Context, query string, args []interface{}) ([]eventsource.Record, error)
	NewTransaction(ctx context.Context, query string, records ...eventsource.Record) (eventsource.StoreTransaction, error)
}