aboutsummaryrefslogtreecommitdiffstats
path: root/Resources/Templates
diff options
context:
space:
mode:
authorstuconnolly <stuart02@gmail.com>2010-07-03 23:00:12 +0000
committerstuconnolly <stuart02@gmail.com>2010-07-03 23:00:12 +0000
commit7d14f85443c7a7e7a3bc804fdd7aee4fc5c6c205 (patch)
tree4e517e57e2b758ff84a92062c3263aa3a5b0907f /Resources/Templates
parent89719b64e4f6fa793c4ed7d4d1a63f8b4938812c (diff)
downloadsequelpro-7d14f85443c7a7e7a3bc804fdd7aee4fc5c6c205.tar.gz
sequelpro-7d14f85443c7a7e7a3bc804fdd7aee4fc5c6c205.tar.bz2
sequelpro-7d14f85443c7a7e7a3bc804fdd7aee4fc5c6c205.zip
Tidy up the Resources directory to match that of Xcode's logical directory structure.
Diffstat (limited to 'Resources/Templates')
-rw-r--r--Resources/Templates/sequel-pro-mysql-help-template.html41
-rw-r--r--Resources/Templates/sequel-pro-print-template.html124
-rw-r--r--Resources/Templates/sequel-pro-table-info-print-template.html151
3 files changed, 316 insertions, 0 deletions
diff --git a/Resources/Templates/sequel-pro-mysql-help-template.html b/Resources/Templates/sequel-pro-mysql-help-template.html
new file mode 100644
index 00000000..214c2623
--- /dev/null
+++ b/Resources/Templates/sequel-pro-mysql-help-template.html
@@ -0,0 +1,41 @@
+<!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>
+</head>
+<body>
+%@
+</body>
+</html>
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>
diff --git a/Resources/Templates/sequel-pro-table-info-print-template.html b/Resources/Templates/sequel-pro-table-info-print-template.html
new file mode 100644
index 00000000..acc13ad3
--- /dev/null
+++ b/Resources/Templates/sequel-pro-table-info-print-template.html
@@ -0,0 +1,151 @@
+<!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 %}
+
+ {% if i.createSyntax > 0 %}
+ <h2>Create Syntax</h2>
+
+ {{i.createSyntax}}
+ {% /if %}
+</body>
+</html>