Method List

app/store/database/publickey_subkey.go:71–102

List return all sub keys from a public key.

(ctx context.Context, publicKeyID int64)

// List return all sub keys from a public key.
func (s PublicKeySubKeyStore) List(ctx context.Context, publicKeyID int64) ([]string, error) {
	const sqlQuery = `
		SELECT public_key_sub_key_id
		FROM public_key_sub_keys
		WHERE public_key_sub_key_public_key_id = $1`

	db := dbtx.GetAccessor(ctx, s.db)

	rows, err := db.QueryContext(ctx, sqlQuery, publicKeyID)
	if err != nil {
		return nil, database.ProcessSQLErrorf(ctx, err, "Failed to query for public key subkeys")
	}
	defer rows.Close()

	var result []string

	for rows.Next() {
		var subKeyID string
		if err := rows.Scan(&subKeyID); err != nil {
			return nil, database.ProcessSQLErrorf(ctx, err, "Failed to scan subkey ID")
		}

		result = append(result, subKeyID)
	}

	err = rows.Err()
	if err != nil {
		return nil, database.ProcessSQLErrorf(ctx, err, "failed to list subkeys")
	}

	return result, nil
}