Alphacross play stats

crossword-db.sh

if [ $(id -u) -ne 0 ]
  then echo "Please run this script as root."
  exit
fi

/data/data/com.termux/files/usr/bin/sqlite3 /data/data/org.akop.crosswords/databases/crosswords

query.sql

.mode column
.header on
select 
  case sizeRank 
    when 0 then 'xsmall' 
    when 1 then 'small' 
    when 2 then 'medium'
    when 3 then 'large' 
    when 4 then 'xlarge'
  end as grid_size, 
  count(*) as completed, 
  concat(sum(playTimeMillis)/1000/60/60,' hours') as time, 
  concat(round(
    cast(sum(squaresCheated) as real)/sum(squaresTotal)*100,
  2),'%') as cheated
  from Crosswords
  where status = 2
  group by sizeRank;

note that this includes archived and trashed grids. filter on folderId to exclude