running.bats

#!/usr/bin/env bats

load ../common

# Assumes process is running

@test "MariaDB service is listening on port 3306" {
  docker exec -i $imagename netstat -tulpn | grep :3306
}

@test "MySQL user running process" {
  docker exec -i $imagename ps -u mysql
}

@test "Creates root account and database" {
  docker exec -i $imagename mysql -u root --password="123321" -h 127.0.0.1 -e 'show tables' registry
}

@test "Creates user account with password" {
  docker exec -i $imagename mysql -u registry_user --password="WJzesbe3poNZ91qIbmR7" -h 127.0.0.1 -e 'show tables' registry
}

@test "UTF8 character set" {
  docker exec -i $imagename mysql -u root -h 127.0.0.1 --password=123321 -e 'show variables' | grep char | grep utf8
}

@test "UTF8 collations" {
  docker exec -i $imagename mysql -u root -h 127.0.0.1 --password=123321 -e 'show variables' | grep collation | grep utf8_bin
}

@test "UTF8 databases" {
  docker exec -i $imagename mysql -u root -h 127.0.0.1 --password=123321 -e 'show create database registry' | grep "DEFAULT CHARACTER SET utf8 COLLATE utf8_bin"
}