User Tools

Site Tools


scratchpad:automated_sql_reports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
scratchpad:automated_sql_reports [2011/04/29 09:35] – some future ideas bshumscratchpad:automated_sql_reports [2022/02/10 13:34] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== Automated SQL Report Scripting (Draft) ====== ====== Automated SQL Report Scripting (Draft) ======
 +
 +This document is a scratchpad created quickly during the 2011 Evergreen Conference.
 +
 +**NOTE: Updates can be found at the permanent location - [[evergreen-reports:automated_sql_reports|evergreen-reports:automated_sql_reports]]**.
  
 ===== Requirements ===== ===== Requirements =====
Line 27: Line 31:
      * The RECIPIENT variable defines the e-mail address you will be sending to      * The RECIPIENT variable defines the e-mail address you will be sending to
  
-<code>+<code bash>
 #!/bin/sh #!/bin/sh
  
Line 76: Line 80:
 This file is called TEST_daily_circ.postgresql.  It creates an output file used by the control script above.  The path for the output is hardcoded into the first line of the SQL with the \o.  The \f | indicates that | will be used as the delimiter between columns. This file is called TEST_daily_circ.postgresql.  It creates an output file used by the control script above.  The path for the output is hardcoded into the first line of the SQL with the \o.  The \f | indicates that | will be used as the delimiter between columns.
  
-<code>+<code sql>
  
 \o /home/<user>/sql/TEST/TEST_daily_stats2.csv \o /home/<user>/sql/TEST/TEST_daily_stats2.csv
Line 102: Line 106:
 ==== E-mail Text Script ==== ==== E-mail Text Script ====
  
-<code>+<code bash>
  
 #!/bin/bash #!/bin/bash
scratchpad/automated_sql_reports.1304084104.txt.gz · Last modified: 2022/02/10 13:33 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.