aboutsummaryrefslogtreecommitdiffstats
path: root/Resources/English.lproj/sequel-pro-print-template.html
diff options
context:
space:
mode:
authorstuconnolly <stuart02@gmail.com>2010-03-12 01:02:52 +0000
committerstuconnolly <stuart02@gmail.com>2010-03-12 01:02:52 +0000
commit88f89987a4329b394ee30a2a77705d3afbb35195 (patch)
tree71d53571320669deb0881485fd53dc5062c7ae3f /Resources/English.lproj/sequel-pro-print-template.html
parent98af234687c698826817a6c219ce8f731fdfa1e7 (diff)
downloadsequelpro-88f89987a4329b394ee30a2a77705d3afbb35195.tar.gz
sequelpro-88f89987a4329b394ee30a2a77705d3afbb35195.tar.bz2
sequelpro-88f89987a4329b394ee30a2a77705d3afbb35195.zip
Various printing support enhancements, including:
- Splitting out all printing methods to SPPrintController which is category of TableDocument. - The ability to print table relations. - If present the inclusion of table indexes when printing a table's source. - If the user has use monospaced fonts enables, then the print out's tabular data will be in a monospaced font. - Lots of other style enhancements, including page headings and sections headings.
Diffstat (limited to 'Resources/English.lproj/sequel-pro-print-template.html')
-rw-r--r--Resources/English.lproj/sequel-pro-print-template.html57
1 files changed, 48 insertions, 9 deletions
diff --git a/Resources/English.lproj/sequel-pro-print-template.html b/Resources/English.lproj/sequel-pro-print-template.html
index 9fe2fe29..6265a3f8 100644
--- a/Resources/English.lproj/sequel-pro-print-template.html
+++ b/Resources/English.lproj/sequel-pro-print-template.html
@@ -24,14 +24,22 @@
color: #000000;
}
+ h1 {
+ font-size: 14px;
+ }
+
+ h2 {
+ font-size: 11px;
+ }
+
table, th, td {
border: 0.1em solid #000000;
}
table {
+ width: 100%;
border-collapse: collapse;
border-spacing: 0;
- width: 100%;
}
th, td {
@@ -39,8 +47,13 @@
}
th {
- background-color: #E5E5E5;
+ text-align: left;
font-weight: bold;
+ background-color: #E5E5E5;
+ }
+
+ td {
+ font-family: {{font}};
}
tr > td {
@@ -54,19 +67,26 @@
tr.odd > td {
background-color: #FFFFFF;
}
+
+ code {
+ font-family: Monaco;
+ }
</style>
</head>
<body>
+ <h1>{{c.table}}</h1>
+
<p>
- {% if c.table %}<b>Table:</b> {{c.table}}<br>{% /if %}
- <b>Connection:</b> {{c.username}}{% if c.username %}@{% /if %}{{c.hostname}}{% if c.port %}:{% /if %}{{c.port}}/{{c.database}}<br>
- <b>Generated on:</b> {% now | date_format: "dd MMM yyyy 'at' HH:mm:ss" %} by {{c.version}}<br>
- {% if c.query %}<b>SQL query:</b> {{c.query}}{% /if %}
- <br>
+ <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>
- <table id="table_results" class="data">
+ <h2>{{title}}</h2>
+
+ <table class="data">
<thead>
<tr>
{% for column in columns %}<th>{{ column }}</th>{% /for %}
@@ -80,7 +100,26 @@
</tr>
{% /for %}
</tbody>
-</table>
+ </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>