Perl Google Sheets API Install Problems

jamesk has asked for the wisdom of the Perl Monks concerning the following question:

Hi All, I am attempting to install a Perl module:

Net::Google::Spreadsheets::V4

One of the dependencies is failing three tests and so will not install:

Net::Google::DataAPI::Auth::OAuth2

The failed tests give this output:

#   Failed test at t/04_auth/04_oauth2.t line 72.
#     Structures begin differing at:
#          $got->{hd} = ''
#     $expected->{hd} = Does not exist

#   Failed test at t/04_auth/04_oauth2.t line 101.
#     Structures begin differing at:
#          $got->{hd} = ''
#     $expected->{hd} = Does not exist

#   Failed test at t/04_auth/04_oauth2.t line 124.
#     Structures begin differing at:
#          $got->{hd} = ''
#     $expected->{hd} = Does not exist
# Looks like you failed 3 tests of 28.
t/04_auth/04_oauth2.t .................................. Dubious, test
+ returned 3 (wstat 768, 0x300)
Failed 3/28 subtests
t/05_types.t ........................................... Any::Moose is
+ deprecated. Please use Moo instead at t/05_types.t line 6.
t/05_types.t ........................................... ok

Test Summary Report
-------------------
t/04_auth/04_oauth2.t                                (Wstat: 768 Tests
+: 28 Failed: 3)
  Failed tests:  9, 22, 28
  Non-zero exit status: 3
Files=24, Tests=423,  4 wallclock secs ( 0.10 usr  0.03 sys +  4.14 cu
+sr  0.40 csys =  4.67 CPU)
Result: FAIL
Failed 1/24 test programs. 3/423 subtests failed.
Makefile:801: recipe for target 'test_dynamic' failed
make: *** [test_dynamic] Error 255
Terminal does not support GetHistory.
Lockfile removed.
  DANJOU/Net-Google-DataAPI-0.2805.tar.gz
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, t
+ry:
  reports DANJOU/Net-Google-DataAPI-0.2805.tar.gz
Failed during this command:
 DANJOU/Net-Google-DataAPI-0.2805.tar.gz      : make_test NO
[download]

It would appear at least one other person has had the same problem:

https://rt.cpan.org/Public/Bug/Display.html?id=124866

Assuming that this module is essential for what I'm doing, can anybody shed some light on it? Is it me doing something wrong or is it a genuine bug with the module? Alternative options are very welcome. I essentially need to send data that Perl has to an existing Google Sheet.

If it matters I'm using Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-21-generic x86_64) with Perl v5.22.1

Thanks, James

Comment on Perl Google Sheets API Install Problems Download Code

Replies are listed 'Best First'.
Re: Perl Google Sheets API Install Problems by stevieb (Canon) on Aug 07, 2019 at 20:41 UTC
What I found, is that in the `t/04_auth/04_oauth2.t` test file, there's a query that looks like it adds a field that the test file wasn't expecting. The repository appears to be a bit problematic and I don't have time to sort it out currently, but you can add the following line: `hd => '',` [download] ...on lines 78, 108 and 134 of that test file, then run: `perl Makefile.PL make make test make install` [download] You can download the distribution from here. Knowing that these three test failures are not significant and won't cause any harm, you can also install from CPAN with force (which isn't something one should normally do): `cpanm -f Net::Google::DataAPI` [download]	[reply] [d/l] [select]
Re^2: Perl Google Sheets API Install Problems by jamesk (Initiate) on Aug 08, 2019 at 09:21 UTC
That's such a relief that it wasn't just me being a fool! It's worked perfectly. Thank you for trying it and giving me the instructions. I had considered doing something similar to what you suggested, but I wasn't sure at all of what to do exactly. Thanks, James	[reply]
Re^3: Perl Google Sheets API Install Problems by stevieb (Canon) on Aug 08, 2019 at 20:49 UTC
I notice you're new around here jamesk (welcome to the Monastery, by the way!), so if this isn't a one-off question and you're still listening, I'd be willing to fix this issue, as well as other blatant warnings to push back to the CPAN, so long as you'll hang around and test it in a real environment. Are you available for this type of work?	[reply]
Re^4: Perl Google Sheets API Install Problems by jamesk (Initiate) on Aug 09, 2019 at 13:28 UTC
Re^5: Perl Google Sheets API Install Problems by stevieb (Canon) on Aug 09, 2019 at 19:32 UTC
Some notes below your chosen depth have not been shown here


Perl-Sensitive Sunglasses
	PerlMonks