Advertisement
swaggboi

for_blog_post_08052022

Aug 4th, 2022
987
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. sub get_threads($self) {
  2.     $self->pg->db->query(<<~'END_SQL')->hashes()
  3.         SELECT thread_id                                             AS id,
  4.                TO_CHAR(thread_date, 'Dy Mon DD HH:MI:SS AM TZ YYYY') AS date,
  5.                thread_author                                         AS author,
  6.                thread_title                                          AS title,
  7.                thread_body                                           AS body
  8.           FROM threads
  9.          WHERE NOT hidden_status
  10.          ORDER BY thread_date DESC;
  11.        END_SQL
  12. }
Advertisement
RAW Paste Data Copied
Advertisement