Sha256: 491950e9d5e64c38c0885d5a863ef12bf6c15beb0d1d3e22d05206f223622083

Contents?: true

Size: 1.45 KB

Versions: 38

Compression:

Stored size: 1.45 KB

Contents

<% blazer_title "Schema: #{@data_source.name}" %>

<h1>Schema: <%= @data_source.name %></h1>

<hr />

<div id="header">
  <input id="search" type="text" placeholder="Start typing a table or column" style="width: 300px; display: inline-block;" class="search form-control" />
</div>

<% @schema.each do |table| %>
  <table class="table schema-table">
    <thead>
      <tr>
        <th colspan="2">
          <% if table[:schema] != "public" %><%= table[:schema] %>.<% end %><%= table[:table] %>
        </th>
      </tr>
    </thead>
    <tbody>
      <% table[:columns].each do |column| %>
        <tr>
          <td style="width: 60%;"><%= column[:name] %></td>
          <td class="text-muted"><%= column[:data_type] %></td>
        </tr>
      <% end %>
    </tbody>
  </table>
<% end %>

<script>
  $("#search").on("keyup", function() {
    var value = $(this).val().toLowerCase()
    $(".schema-table").filter(function() {
      // if found in table name, show entire table
      // if just found in rows, show row

      var found = $(this).find("thead").text().toLowerCase().indexOf(value) > -1

      if (found) {
        $(this).find("tbody tr").toggle(true)
      } else {
        $(this).find("tbody tr").filter(function() {
          var found2 = $(this).text().toLowerCase().indexOf(value) > -1
          $(this).toggle(found2)
          if (found2) {
            found = true
          }
        })
      }

      $(this).toggle(found)
    })
  }).focus()
</script>

Version data entries

38 entries across 38 versions & 3 rubygems

Version Path
blazer_xlsx-3.0.7 app/views/blazer/queries/schema.html.erb
blazer_xlsx-3.0.6 app/views/blazer/queries/schema.html.erb
blazer_xlsx-3.0.5 app/views/blazer/queries/schema.html.erb
blazer-3.0.3 app/views/blazer/queries/schema.html.erb
blazer-3.0.2 app/views/blazer/queries/schema.html.erb
finery-3.0.3 app/views/blazer/queries/schema.html.erb
finery-3.0.2 app/views/blazer/queries/schema.html.erb
blazer-3.0.1 app/views/blazer/queries/schema.html.erb
finery-3.0.1 app/views/blazer/queries/schema.html.erb
finery-3.0.0 app/views/blazer/queries/schema.html.erb
blazer-3.0.0 app/views/blazer/queries/schema.html.erb
blazer-2.6.5 app/views/blazer/queries/schema.html.erb
blazer-2.6.4 app/views/blazer/queries/schema.html.erb
blazer-2.6.3 app/views/blazer/queries/schema.html.erb
blazer-2.6.2 app/views/blazer/queries/schema.html.erb
blazer-2.6.1 app/views/blazer/queries/schema.html.erb
blazer-2.6.0 app/views/blazer/queries/schema.html.erb
blazer-2.5.0 app/views/blazer/queries/schema.html.erb
blazer-2.4.8 app/views/blazer/queries/schema.html.erb
blazer-2.4.7 app/views/blazer/queries/schema.html.erb