diff options
Diffstat (limited to 'Resources/Templates/sequel-pro-print-template.html')
-rw-r--r-- | Resources/Templates/sequel-pro-print-template.html | 124 |
1 files changed, 124 insertions, 0 deletions
diff --git a/Resources/Templates/sequel-pro-print-template.html b/Resources/Templates/sequel-pro-print-template.html new file mode 100644 index 00000000..ba8b31fa --- /dev/null +++ b/Resources/Templates/sequel-pro-print-template.html @@ -0,0 +1,124 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> +<head> + <title>Sequel Pro</title> + + <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> + + <style type="text/css" media="all"> + html { + font-size: 12px; + } + + .nowrap { + white-space: nowrap; + } + + div.nowrap { + margin: 0; + padding: 0; + } + + body, table, th, td { + background-color: #FFFFFF; + color: #000000; + } + + h1 { + font-size: 16px; + } + + h2 { + font-size: 14px; + } + + table { + width: 100%; + border: 1px solid #CCCCCC; + border-collapse: collapse; + border-spacing: 0; + } + + th, td { + padding: 0.2em; + } + + th { + text-align: left; + font-weight: bold; + background-color: #E5E5E5; + border: 1px solid #CCCCCC; + } + + td { + font-family: {{font}}; + border: {{gridlines}}; + } + + tr > td { + text-align: left; + } + + tr.even > td { + background-color: #EDF3FE; + } + + tr.odd > td { + background-color: #FFFFFF; + } + + code { + font-family: Courier; + } + </style> +</head> + +<body> + <h1>{{c.table}}</h1> + + <p> + <strong>Connection:</strong> {{c.username}}{% if c.username %}@{% /if %}{{c.hostname}}{% if c.port %}:{% /if %}{{c.port}}/{{c.database}}<br /> + <strong>Generated on:</strong> {% now | date_format: "dd MMM yyyy 'at' HH:mm:ss" %} by {{c.version}}<br /> + {% if c.query %}<br /><strong>SQL query:</strong> <code>{{c.query}}</code>{% /if %} + <br /> + </p> + + <h2>{{heading}}</h2> + + <table class="data"> + <thead> + <tr> + {% for column in columns %}<th>{{ column }}</th>{% /for %} + </tr> + </thead> + + <tbody> + {% for row in rows %} + <tr {% cycle 'class="odd" ' 'class="even" ' %}> + {% for cell in row %}<td>{{ cell }}</td>{% /for %} + </tr> + {% /for %} + </tbody> + </table><br /> + + {% if indexes %} + <h2>Table Indexes</h2><br /> + + <table class="data"> + <thead> + <tr> + {% for indexColumn in indexColumns %}<th>{{ indexColumn }}</th>{% /for %} + </tr> + </thead> + + <tbody> + {% for index in indexes %} + <tr {% cycle 'class="odd" ' 'class="even" ' %}> + {% for cell in index %}<td>{{ cell }}</td>{% /for %} + </tr> + {% /for %} + </tbody> + </table> + {% /if %} +</body> +</html> |