diff options
| author | stuconnolly <stuart02@gmail.com> | 2010-03-12 01:02:52 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2010-03-12 01:02:52 +0000 |
| commit | 88f89987a4329b394ee30a2a77705d3afbb35195 (patch) | |
| tree | 71d53571320669deb0881485fd53dc5062c7ae3f /Resources | |
| parent | 98af234687c698826817a6c219ce8f731fdfa1e7 (diff) | |
| download | sequelpro-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')
| -rw-r--r-- | Resources/English.lproj/sequel-pro-print-template.html | 57 | ||||
| -rw-r--r-- | Resources/sequel-pro-mysql-help-template.html | 61 |
2 files changed, 81 insertions, 37 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> diff --git a/Resources/sequel-pro-mysql-help-template.html b/Resources/sequel-pro-mysql-help-template.html index 13f14e3d..214c2623 100644 --- a/Resources/sequel-pro-mysql-help-template.html +++ b/Resources/sequel-pro-mysql-help-template.html @@ -1,34 +1,39 @@ <!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html dir="ltr" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> -<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> -<style type="text/css" media="all"> - body { - margin: 2px; - padding: 10px; - font-family:'Helvetica'; - font-size:9pt; - } - h2 { - } - ul { - } - li { - } - .internallink { - color:#6A81DD; - text-decoration:none; - } - .description { - font-family:Monaco; - } - .example { - font-family:Courier; - } - .header { - padding-bottom:5px; - } -</style> + <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> + + <style type="text/css" media="all"> + body { + margin: 2px; + padding: 10px; + font-family:'Helvetica'; + font-size:9pt; + } + + h2 {} + + ul {} + + li {} + + .internallink { + color: #6A81DD; + text-decoration: none; + } + + .description { + font-family: Monaco; + } + + .example { + font-family: Courier; + } + + .header { + padding-bottom: 5px; + } + </style> </head> <body> %@ |