File Coverage

blib/lib/App/WatchLater.pm

Criterion	Covered	Total	%
statement	29	67	43.2
branch	0	20	0.0
condition	0	3	0.0
subroutine	10	20	50.0
pod	1	1	100.0
total	40	111	36.0

package App::WatchLater;

use 5.016;
use strict;
use warnings;

use Carp;
use DBI;
use Getopt::Long qw(:config auto_help gnu_getopt);
use Pod::Usage;
use Try::Tiny;

use App::WatchLater::YouTube;
use App::WatchLater::Browser;

=head1 NAME

App::WatchLater - Manage your YouTube Watch Later videos

=head1 VERSION

Version 0.03

=cut

our $VERSION = '0.03';


=head1 SYNOPSIS

    exit App::WatchLater::main();

=head1 DESCRIPTION

Manages a Watch Later queue of YouTube videos, in case you're one of the kinds
of people whose Watch Later lists get too out of hand. Google has deprecated the
ability to access the B playlist via the YouTube Data API, which means we
have to go to a bit more effort.

An API key is required to access the YouTube Data API. Alternatively, requests
may be authorized by providing an OAuth2 access token.

=head1 SUBROUTINES/METHODS

=cut

sub _ensure_schema {
  my $dbh = shift;
  $dbh->do(<<'SQL') or die $dbh->errstr;
CREATE TABLE IF NOT EXISTS videos(
  video_id      TEXT PRIMARY KEY,
  video_title   TEXT,
  channel_id    TEXT,
  channel_title TEXT,
  watched       INTEGER NOT NULL DEFAULT 0
);
SQL
}

sub _add {
  my ($dbh, $api, $opts, @video_ids) = @_;

  my $on_conflict = $opts->{force} ? 'REPLACE' : 'IGNORE';

  my $sth = $dbh->prepare_cached(<
INSERT OR $on_conflict INTO videos
(video_id, video_title, channel_id, channel_title, watched)
VALUES (?, ?, ?, ?, 0);
SQL

  for my $vid (@video_ids) {
    try {
      my $snippet = $api->get_video($vid);
      $sth->execute($vid, $snippet->{title},
                    $snippet->{channelId}, $snippet->{channelTitle});
    } catch {
      # warn the user and continue
      print STDERR;
    };
  }
}

sub _get_random_video {
  my ($dbh) = @_;
  my $sth = $dbh->prepare_cached(<<'SQL');
SELECT video_id, video_title, channel_id, channel_title FROM videos
WHERE NOT watched
ORDER BY RANDOM()
LIMIT 1;
SQL
  $sth->execute or die $sth->errstr;
  my $row = $sth->fetchrow_hashref or croak 'no videos';
  $row->{video_id};
}

sub _mark_watched {
  my ($dbh, $vid) = @_;
  my $sth = $dbh->prepare(<<'SQL');
UPDATE videos SET watched=1
WHERE video_id = ?;
SQL
  $sth->execute($vid) or die $sth->errstr;
}

sub _watch {
  my ($dbh, $api, $opts, @video_ids) = @_;

  if (!@video_ids) {
    push @video_ids, _get_random_video($dbh);
  }

  for my $vid (@video_ids) {
    try {
      open_url("https://youtu.be/$vid") if $opts->{open};
      _mark_watched($dbh, $vid);
    } catch {
      # warn the user and continue
      print STDERR;
    };
  }
}

=head2 main

    main();

C runs the watch-later command line interface. It reads arguments
directly from C<@ARGV> using L.

=cut

# TODO a better module interface to main()
sub main {
  my %opts = (
    'db-path' => "$ENV{HOME}/.watch-later.db",
    force     => 0,
    open      => 1,
  );

  GetOptions(
    \%opts,
    'db-path|d=s',
    'add|a',
    'watch|w',
    'force|f!',
    'open|o!',
  ) or pod2usage(2);

  croak "Add and Watch modes both specified" if $opts{add} && $opts{watch};

  my @video_ids = map { find_video_id($_) } @ARGV;

  my $dbpath = $opts{'db-path'};
  my $dbh = DBI->connect("dbi:SQLite:dbname=$dbpath");
  _ensure_schema($dbh);

  my $api = App::WatchLater::YouTube->new(
    api_key      => $ENV{YT_API_KEY},
    access_token => $ENV{YT_ACCESS_TOKEN},
  );

  if ($opts{watch}) {
    _watch($dbh, $api, \%opts, @video_ids);
  } else {
    _add($dbh, $api, \%opts, @video_ids);
  }
}

=head1 AUTHOR

Aaron L. Zeng, C<<  >>

=head1 BUGS

Please report any bugs or feature requests to C, or through
the web interface at L.  I will be notified, and then you'll
automatically be notified of progress on your bug as I make changes.




=head1 SUPPORT

You can find documentation for this module with the perldoc command.

    perldoc App::WatchLater


You can also look for information at:

=over 4

=item * RT: CPAN's request tracker (report bugs here)

L

=item * AnnoCPAN: Annotated CPAN documentation

L

=item * CPAN Ratings

L

=item * Search CPAN

L

=back


=head1 ACKNOWLEDGEMENTS


=head1 LICENSE AND COPYRIGHT

Copyright 2017 Aaron L. Zeng.

This program is distributed under the MIT (X11) License:
L

Permission is hereby granted, free of charge, to any person
obtaining a copy of this software and associated documentation
files (the "Software"), to deal in the Software without
restriction, including without limitation the rights to use,
copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the
Software is furnished to do so, subject to the following
conditions:

The above copyright notice and this permission notice shall be
included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
OTHER DEALINGS IN THE SOFTWARE.


=cut

1;                              # End of App::WatchLater