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