diff options
| author | stuconnolly <stuart02@gmail.com> | 2010-03-13 13:29:53 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2010-03-13 13:29:53 +0000 |
| commit | 79b24a37b45ad20b8086e481696c758a76092c4e (patch) | |
| tree | bff4198c520fc90a74b8136b26edc6b6355328ba /Resources/sequel-pro-table-info-print-template.html | |
| parent | 1f296e3f0484211d33ee891f344cc6eb10c2c4ac (diff) | |
| download | sequelpro-79b24a37b45ad20b8086e481696c758a76092c4e.tar.gz sequelpro-79b24a37b45ad20b8086e481696c758a76092c4e.tar.bz2 sequelpro-79b24a37b45ad20b8086e481696c758a76092c4e.zip | |
Lots more printing support enhancements, including:
- The ability to print the extended table information view using a new template.
- The inclusion of NULL values diaplyed as the user's NULL value placeholder when printing a table's sturcture and indexes.
- If enabled in the user's preferences, the inclusion of vertical gridlines in the table views.
- Dynamic calculation of page margins based on the paper size of the selected printer as opposed to using hard coded values.
- Lots of other little style enhancements.
Diffstat (limited to 'Resources/sequel-pro-table-info-print-template.html')
| -rw-r--r-- | Resources/sequel-pro-table-info-print-template.html | 149 |
1 files changed, 149 insertions, 0 deletions
diff --git a/Resources/sequel-pro-table-info-print-template.html b/Resources/sequel-pro-table-info-print-template.html new file mode 100644 index 00000000..30198ec2 --- /dev/null +++ b/Resources/sequel-pro-table-info-print-template.html @@ -0,0 +1,149 @@ +<!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, th, td { + width: 300px; + border: none; + border-style: hidden; + border-collapse: collapse; + border-spacing: 0; + } + + th, td { + padding: 0.2em; + } + + th { + text-align: left; + font-weight: bold; + } + + td { + width: 500px; + } + + pre { + font-family: {{font}}; + } + </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 /> + </p> + + <h2>{{heading}}</h2> + + <table> + <tr> + <th scope="row">Type: </th> + <td>{{i.type}}</td> + </tr> + + <tr> + <th scope="row">Encoding: </th> + <td>{{i.encoding}}</td> + </tr> + + <tr> + <th scope="row">Collation: </th> + <td>{{i.collation}}</td> + </tr> + + <tr> + <th scope="row">Create at: </th> + <td>{{i.createdAt}}</td> + </tr> + + <tr> + <th scope="row">Updated at: </th> + <td>{{i.updatedAt}}</td> + </tr> + + <tr> + <th scope="row">Number of rows: </th> + <td>{{i.rowNumber}}</td> + </tr> + + <tr> + <th scope="row">Row format: </th> + <td>{{i.rowFormat}}</td> + </tr> + + <tr> + <th scope="row">Avg. row length: </th> + <td>{{i.rowAvgLength}}</td> + </tr> + + <tr> + <th scope="row">Auto increment: </th> + <td>{{i.rowAutoIncrement}}</td> + </tr> + + <tr> + <th scope="row">Data size: </th> + <td>{{i.dataSize}}</td> + </tr> + + <tr> + <th scope="row">Max data size: </th> + <td>{{i.maxDataSize}}</td> + </tr> + + <tr> + <th scope="row">Index size: </th> + <td>{{i.indexSize}}</td> + </tr> + + <tr> + <th scope="row">Free data size: </th> + <td>{{i.sizeFree}}</td> + </tr> + </table> + + {% if i.comments.length > 0 %} + <h2>Comments</h2> + + <p><em>{{i.comments}}</em></p> + {% /if %} + + <h2>Create Syntax</h2> + + <pre>{{i.createSyntax}}</pre> +</body> +</html> |