summaryrefslogtreecommitdiff
path: root/bin/expire_sessions
diff options
context:
space:
mode:
Diffstat (limited to 'bin/expire_sessions')
-rwxr-xr-xbin/expire_sessions11
1 files changed, 11 insertions, 0 deletions
diff --git a/bin/expire_sessions b/bin/expire_sessions
new file mode 100755
index 0000000..3b57a70
--- /dev/null
+++ b/bin/expire_sessions
@@ -0,0 +1,11 @@
+#!/usr/bin/perl
+
+use strict;
+use warnings;
+require PgCommitFest::Request;
+
+my $db = PgCommitFest::Request->db();
+$db->do(<<EOM);
+DELETE FROM session WHERE login_time < now() - '10 days'::interval;
+EOM
+$db->commit;