{% extends "base.html" %}

{% block title %}
    {{ metadata.title or "Datasette" }}: {% for database in databases %}{{ database.name }}{% if not loop.last %}, {% endif %}{% endfor %}
{% endblock %}

{% block extra_head %}
<script type="application/ld+json">
{{ metadata.structured_metadata | tojson(indent=2) }}
</script>
{% endblock %}


{% block body_class %}index{% endblock %}

{% block content %}
<h1>{{ metadata.title or "Datasette" }}{% if private %} 🔒{% endif %}</h1>
{{ render_markdown("""
Welcome to the ToMCAT dataset!
The dataset currently is served via a [single SQLite database](/tomcat),
but we may add additional ones in the future.

Currently, there are tables for the participant information, group session,
raw fNIRS data, the testbed messages, and the baseline tasks. More
tables (EEG, EKG, GSR, eye tracking, vocalic features, demographic data,
questionnaires) will be added in the near future.

For users who are not familiar with SQL, we will provide some sample SQL
queries to demonstrate how to use this database and the associated Datasette
interface.

For more advanced users, feel free to try different queries, use the
programmatic APIs provided by Datasette, or simply [download the whole SQLite
database](https://tomcat.ivilab.org/tomcat.db).

The database schema diagram is available here: [Database
diagram](/assets/db_diagram.png).

Sign up for our [mailing list](/mailing-list) to get updates on the dataset!
""") }}
            {% for database in databases %}
                <h2 style="padding-left: 10px; border-left: 10px solid #{{ database.color }}">
                    <a href="{{ urls.database(database.name) }}">{{ database.name }}</a>
                    {% if database.private %} 🔒{% endif %}
                </h2>
                <p>
                    {% if database.show_table_row_counts %}{{ "{:,}".format(database.table_rows_sum) }} rows in {% endif %}{{ database.tables_count }} table{% if database.tables_count != 1 %}s{% endif %}{% if database.tables_count and database.hidden_tables_count %}, {% endif -%}
                    {% if database.hidden_tables_count -%}
                        {% if database.show_table_row_counts %}{{ "{:,}".format(database.hidden_table_rows_sum) }} rows in {% endif %}{{ database.hidden_tables_count }} hidden table{% if database.hidden_tables_count != 1 %}s{% endif -%}
                    {% endif -%}
                    {% if database.views_count -%}
                        {% if database.tables_count or database.hidden_tables_count %}, {% endif -%}
                        {{ "{:,}".format(database.views_count) }} view{% if database.views_count != 1 %}s{% endif %}
                    {% endif %}
                </p>
                <p>{% for table in database.tables_and_views_truncated %}<a href="{{ urls.table(database.name, table.name) }}"{% if table.count %} title="{{ table.count }} rows"{% endif %}>{{ table.name }}</a>{% if table.private %} 🔒{% endif %}{% if not loop.last %}, {% endif %}{% endfor %}{% if database.tables_and_views_more %}, <a href="{{ urls.database(database.name) }}">...</a>{% endif %}</p>
            {% endfor %}

{{ render_markdown("""
## Funding Acknowledgment

The creation of this dataset was funded by the Army Research Office and was
accomplished under Grant Number W911NF-20-1-0002. The grant was awarded through
the Defense Advanced Research Projects Agency (DARPA). We would also like to
acknowledge intramural seed funding from the University of Arizona's SensorLab.
""") }}
{% endblock %}