Source

htsql-charset-option / test / output / sqlite.yaml

Full commit
#
# This file contains expected test output data for regression tests.
# It was generated automatically by the `regress` routine.
#

id: sqlite
tests:
- id: queries-sqlite
  tests:
  - uri: /
    status: 200 OK
    headers:
    - [Content-Type, text/plain; charset=UTF-8]
    body: |
      (no data)

       ----
       /
  - uri: /{2+2}
    status: 200 OK
    headers:
    - [Content-Type, text/plain]
    body: |
      /{2+2}
  - uri: /test
    status: 200 OK
    headers:
    - [Content-Type, text/plain; charset=UTF-8]
    body: |2
       | test       |
      -+------------+-
       | id | data  |
      -+----+-------+-
       |  1 | one   |
       |  2 | two   |
       |  3 | three |
             (3 rows)

       ----
       /test
  - uri: /test{id}
    status: 200 OK
    headers:
    - [Content-Type, text/plain; charset=UTF-8]
    body: |2
       | test   |
      -+--------+-
       | id     |
      -+--------+-
       |      1 |
       |      2 |
       |      3 |
         (3 rows)

       ----
       /test{id}
  - uri: /test
    status: 200 OK
    headers:
    - [Content-Type, application/json]
    body: |
      [
        [1, "one"],
        [2, "two"],
        [3, "three"]
      ]
  - uri: /test
    status: 200 OK
    headers:
    - [Content-Type, text/csv; charset=UTF-8]
    body: "id,data\r\n1,one\r\n2,two\r\n3,three\r\n"
  - uri: /test
    status: 200 OK
    headers:
    - [Content-Type, text/plain; charset=UTF-8]
    body: |2
       | test       |
      -+------------+-
       | id | data  |
      -+----+-------+-
       |  1 | one   |
       |  2 | two   |
       |  3 | three |
             (3 rows)

       ----
       /test
  - uri: /test
    status: 200 OK
    headers:
    - [Content-Type, text/html; charset=UTF-8]
    body: |
      <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
      <html>
      <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>/test</title>
      <style type="text/css">
      body { font-family: sans-serif; font-size: 90%; color: #515151; background: #ffffff }
      a:link, a:visited { color: #1f4884; text-decoration: none }
      a:hover { text-decoration: underline }
      table { border-collapse: collapse; margin: 0.5em auto; width: 100% }
      table, tr { border-style: solid; border-width: 0 }
      td, th { padding: 0.2em 0.5em; vertical-align: top; text-align: left }
      div.tab { position: relative; left: -1px; margin-right: 60%; padding: 0.2em 0.5em; background: #ffffff; border-style: solid; border-width: 5px 1px 0; border-top-left-radius: 10px; border-top-right-radius: 10px; -moz-border-radius-topleft: 10px; -moz-border-radius-topright: 10px; -webkit-border-top-left-radius: 10px; -webkit-border-top-right-radius: 10px }
      table.page { border: 0; padding: 1em; width: auto }
      tr.content { padding: 1em 1em 0.5em }
      tr.footer { padding: 0 1em 1em; text-align: left; font-style: italic }
      table.chart .number { text-align: right }
      tr.caption { font-size: 105%; background: transparent }
      tr.caption th { padding: 0 }
      div.tab { border-color: #6f9ad3 #c3c3c3 }
      tr.header { background: #dae3ea; border-color: #c3c3c3; border-width: 1px 1px 0 }
      tr.odd { background: #ffffff; border-color: #c3c3c3; border-width: 0 1px }
      tr.even { background: #f2f2f2; border-color: #c3c3c3; border-width: 0 1px }
      tr.odd:hover, tr.even:hover { background: #ffe3bd }
      tr.total { background: transparent;border-color: #c3c3c3; border-width: 1px 0 0 }
      tr.total td { text-align: right; font-size: 75%; font-style: italic; padding: 0.3em 0.5em 0 }
      table.void { text-align: center; border-color: #c3c3c3; border-width: 1px 0 }
      </style>
      </head>
      <body>
      <table class="page" summary="/test">
      <tr>
      <td class="content">
      <table class="chart" summary="test">
      <tr class="caption"><th colspan="2"><div class="tab">test</div></th></tr>
      <tr class="header"><th class="number">id</th><th>data</th></tr>
      <tr class="odd"><td class="number">1</td><td>one</td></tr>
      <tr class="even"><td class="number">2</td><td>two</td></tr>
      <tr class="odd"><td class="number">3</td><td>three</td></tr>
      <tr class="total"><td colspan="2">(3 rows)</td></tr></table></td>
      </tr>
      <tr><td class="footer">/test</td></tr>
      </table>
      </body>
      </html>
  - uri: /test{data}?id=1
    status: 200 OK
    headers:
    - [Content-Type, text/plain]
    body: |
      /test{data}?id=1