use Test::More;
use strict;
use IO::String;
use JSON qw(from_json);
my $res;
my $maintests = 16;
require 't/test-lib.pm';
my $file = tempdb();
SKIP: {
eval {
require DBI;
require DBD::SQLite;
require XML::LibXML;
require XML::LibXSLT;
};
if ($@) {
skip 'DBD::SQLite or XML::Lib* not found', $maintests;
}
my $dbh = DBI->connect("dbi:SQLite:dbname=$file");
$dbh->do(
'CREATE TABLE notifications (uid text,ref text,date datetime,xml text,cond text,done datetime)'
);
$dbh->do(
qq{INSERT INTO notifications VALUES ('dwho','testref','2016-05-30 00:00:00','
Test title
Test subtitle
This is a test text
Accept test
I am sure
',null,null)}
);
$dbh->do(
qq{INSERT INTO notifications VALUES ('dwho','testref2','2016-05-30 00:00:00','
Test2 title
Test2 subtitle
This is a second test text
Accept test
',null,null)}
);
$dbh->do(
qq{INSERT INTO notifications VALUES ('dwho','testref3','2050-05-30 00:00:00','
Test title
Test subtitle
This is a test text
Accept test
',null,null)}
);
$dbh->do(
qq{INSERT INTO notifications VALUES ('rtyler','testref','2016-05-30 00:00:00','
Test title
Test subtitle
This is a test text
Accept test
',null,null)}
);
$dbh->do(
qq{INSERT INTO notifications VALUES ('rtyler','testref2','2050-05-30 00:00:00','
Test title
Test subtitle
This is a test text
Accept test
',null,null)}
);
my $client = LLNG::Manager::Test->new( {
ini => {
logLevel => 'error',
useSafeJail => 1,
notification => 1,
notificationStorage => 'DBI',
notificationStorageOptions => {
dbiChain => "dbi:SQLite:dbname=$file",
},
oldNotifFormat => 1,
notificationsExplorer => 1
}
}
);
# Try to authenticate
# -------------------
ok(
$res = $client->_post(
'/',
IO::String->new(
'user=dwho&password=dwho&url=aHR0cDovL3Rlc3QxLmV4YW1wbGUuY29tLw=='
),
accept => 'text/html',
length => 64,
),
'Auth query'
);
expectOK($res);
my $id = expectCookie($res);
my @refs = ( $res->[2]->[0] =~
//gs );
ok( @refs == 2, 'Two notification references found' )
or print STDERR Dumper( $res->[2]->[0] );
ok( $res->[2]->[0] =~ /1x1x1/, ' Found ref' );
expectForm( $res, undef, '/notifback', 'reference1x1', 'url' );
# Verify that cookie is ciphered (session invalid)
ok(
$res = $client->_get(
'/',
query => 'url=aHR0cDovL3Rlc3QxLmV4YW1wbGUuY29tLw==',
cookie => "lemonldap=$id",
),
'Test cookie received'
);
expectReject($res);
# Try to validate notification without accepting it
my $str = 'reference1x1=testref&url=aHR0cDovL3Rlc3QxLmV4YW1wbGUuY29tLw==';
ok(
$res = $client->_post(
'/notifback',
IO::String->new($str),
cookie => "lemonldap=$id",
accept => 'text/html',
length => length($str),
),
"Don't accept notification"
);
expectOK($res);
# Try to validate notifications
$str =
'reference1x1=testref&check1x1x1=accepted&check1x1x2=accepted&reference1x2=testref2&check1x2x1=accepted&url=aHR0cDovL3Rlc3QxLmV4YW1wbGUuY29tLw==';
ok(
$res = $client->_post(
'/notifback',
IO::String->new($str),
cookie => "lemonldap=$id",
accept => 'text/html',
length => length($str),
),
"Accept notifications"
);
expectRedirection( $res, 'http://test1.example.com/' );
my $cookies = getCookies($res);
ok(
!defined( $cookies->{lemonldappdata} ),
" Make sure no pdata is returned"
);
$id = expectCookie($res);
# Verify that notification was tagged as 'done'
my $sth =
$dbh->prepare('SELECT * FROM notifications WHERE done IS NOT NULL');
$sth->execute;
my $i = 0;
while ( $sth->fetchrow_hashref ) { $i++ }
ok( $i == 2, 'Notification was deleted' );
# GET notifications explorer
ok(
$res = $client->_get(
'/mynotifications', cookie => "lemonldap=$id",
),
'Notifications explorer query'
);
my $json;
ok( $json = eval { from_json( $res->[2]->[0] ) }, 'Response is JSON' )
or print STDERR "$@\n" . Dumper($res);
ok( $json->{result} == 2, ' Result is 2' )
or explain( $json, "result => 2" );
ok( $json->{MSG} == 'myNotifications', ' MSG is myNotifications' )
or explain( $json, "result => 2" );
ok( $json->{NOTIFICATIONS}->[0]->{reference} =~ /testref2?/,
' Notification 1 found' )
or explain( $json, "Notification 1" );
ok( $json->{NOTIFICATIONS}->[0]->{reference} =~ /testref2?/,
' Notification 2 found' )
or explain( $json, "Notification 2" );
ok( $json->{NOTIFICATIONS}->[0]->{epoch} =~ /\d{10}/, ' epoch found' )
or explain( $json, "Epoch found" );
$client->logout($id);
# Try to authenticate
# -------------------
ok(
$res = $client->_post(
'/',
IO::String->new(
'user=rtyler&password=rtyler&url=aHR0cDovL3Rlc3QxLmV4YW1wbGUuY29tLw=='
),
accept => 'text/html',
length => 68,
),
'Auth query'
);
expectRedirection( $res, 'http://test1.example.com/' );
$id = expectCookie($res);
$client->logout($id);
clean_sessions();
eval { unlink $file };
}
count($maintests);
done_testing( count() );