Method getKey

kontrol/postgres.go:432–464

(preds ...interface{})

}

func (p *Postgres) getKey(preds ...interface{}) (*KeyPair, error) {
	psql := sq.StatementBuilder.PlaceholderFormat(sq.Dollar).
		Select("id", "public", "private", "deleted_at").
		From("kite.key")

	for _, pred := range preds {
		psql = psql.Where(pred)
	}

	sqlQuery, args, err := psql.ToSql()
	if err != nil {
		return nil, err
	}

	var (
		kp KeyPair
		t  pq.NullTime
	)

	err = p.DB.QueryRow(sqlQuery, args...).Scan(&kp.ID, &kp.Public, &kp.Private, &t)
	if err != nil {
		if err == sql.ErrNoRows {
			return nil, ErrNoKeyFound
		}
		return nil, err
	}

	if t.Valid {
		return nil, ErrKeyDeleted
	}

	return &kp, nil
}

func (p *Postgres) GetKeyFromID(id string) (*KeyPair, error) {
	return p.getKey(sq.Eq{"id": id})