#!/bin/sh test_description='usermaint tests' . ./setup.sh test_expect_success 'Test removal of login IP addresses.' ' now=$(date -d now +%s) && threedaysago=$(date -d "3 days ago" +%s) && tendaysago=$(date -d "10 days ago" +%s) && cat <<-EOD | sqlite3 aur.db && UPDATE Users SET LastLogin = $threedaysago, LastLoginIPAddress = "1.2.3.4" WHERE ID = 1; UPDATE Users SET LastLogin = $tendaysago, LastLoginIPAddress = "2.3.4.5" WHERE ID = 2; UPDATE Users SET LastLogin = $now, LastLoginIPAddress = "3.4.5.6" WHERE ID = 3; UPDATE Users SET LastLogin = 0, LastLoginIPAddress = "4.5.6.7" WHERE ID = 4; UPDATE Users SET LastLogin = 0, LastLoginIPAddress = "5.6.7.8" WHERE ID = 5; UPDATE Users SET LastLogin = $tendaysago, LastLoginIPAddress = "6.7.8.9" WHERE ID = 6; EOD "$USERMAINT" && cat <<-EOD >expected && 1.2.3.4 3.4.5.6 EOD echo "SELECT LastLoginIPAddress FROM Users WHERE LastLoginIPAddress IS NOT NULL;" | sqlite3 aur.db >actual && test_cmp actual expected ' test_expect_success 'Test removal of SSH login IP addresses.' ' now=$(date -d now +%s) && threedaysago=$(date -d "3 days ago" +%s) && tendaysago=$(date -d "10 days ago" +%s) && cat <<-EOD | sqlite3 aur.db && UPDATE Users SET LastSSHLogin = $now, LastSSHLoginIPAddress = "1.2.3.4" WHERE ID = 1; UPDATE Users SET LastSSHLogin = $threedaysago, LastSSHLoginIPAddress = "2.3.4.5" WHERE ID = 2; UPDATE Users SET LastSSHLogin = $tendaysago, LastSSHLoginIPAddress = "3.4.5.6" WHERE ID = 3; UPDATE Users SET LastSSHLogin = 0, LastSSHLoginIPAddress = "4.5.6.7" WHERE ID = 4; UPDATE Users SET LastSSHLogin = 0, LastSSHLoginIPAddress = "5.6.7.8" WHERE ID = 5; UPDATE Users SET LastSSHLogin = $tendaysago, LastSSHLoginIPAddress = "6.7.8.9" WHERE ID = 6; EOD "$USERMAINT" && cat <<-EOD >expected && 1.2.3.4 2.3.4.5 EOD echo "SELECT LastSSHLoginIPAddress FROM Users WHERE LastSSHLoginIPAddress IS NOT NULL;" | sqlite3 aur.db >actual && test_cmp actual expected ' test_done