Skip to content

Database

Doug Hagan edited this page Jan 22, 2017 · 11 revisions

Connect

  1. Login to jumpbox.
  2. Run aurora/connect.sh. Enter password when prompted (from gdrive).
  3. After login, a mysql client is presented.

Queries

Discovery

> show databases;   
> use *<database>*; 
> show tables;
> show columns from *<table>*;

Statistics

  • All conversations created

    select count(*) from h2conversation where creation > UNIX_TIMESTAMP('20160801') * 1000;

  • Unique conversation creators

    select count(distinct author) from h2conversation where creation > UNIX_TIMESTAMP('20160801') * 1000;

  • Unique conversation contributors

    select count(distinct author) from h2attendance where timestamp_c > UNIX_TIMESTAMP('20160801') * 1000;

Clone this wiki locally