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
Last revisionBoth sides next revision
scratchpad:automated_sql_reports [2011/04/29 09:35] – some future ideas bshumscratchpad:automated_sql_reports [2011/07/13 15:01] aatre
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.txt · Last modified: 2022/02/10 13:34 by 127.0.0.1

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.