SQL Store

go get github.com/thuongh2/go-security/go-security-sql

// lockout.Dialect — 4 methods
type Dialect interface {
    Get(ctx context.Context, db *sql.DB, keyHash string) (lockout.Entry, error)
    Incr(ctx context.Context, db *sql.DB, keyHash string, window time.Duration) (lockout.Entry, error)
    Lock(ctx context.Context, db *sql.DB, keyHash string, until time.Time) error
    Reset(ctx context.Context, db *sql.DB, keyHash string) error
}

// session.Dialect — 5 methods
type Dialect interface {
    Insert(ctx context.Context, db *sql.DB, id string, attrs []byte, now, expiresAt time.Time) error
    Get(ctx context.Context, db *sql.DB, id string, now time.Time, idleTimeout, absoluteTTL time.Duration) (attrs []byte, created, lastAccessed time.Time, found bool, err error)
    Save(ctx context.Context, db *sql.DB, id string, attrs []byte) error
    Delete(ctx context.Context, db *sql.DB, id string) error
    GC(ctx context.Context, db *sql.DB, now time.Time) (int64, error)
}

lockoutStore, err := sqllockout.NewStore(db, myDialect{})
sessionStore, err := sqlsession.NewStore(db, myDialect{}, sqlsession.Options{
    EncryptionKey: myKey,
})

func TestMyDialect(t *testing.T) {
    lockout.StoreConformance(t, func() lockout.Store {
        return must(sqllockout.NewStore(db, myDialect{}))
    })
}