diff options
Diffstat (limited to 'Resources/Templates')
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> |