#!/bin/sh

## Feeding CSV as follows:
##	user,team
#	j2100,Teacher

## This script can be run repeatedly in order to change team allocation.

DB=${1:-users.sq3}
CSV=${2:-newgrp.csv}
sqlite3 ${DB} <<-EOF
	.mode csv
	CREATE TEMPORARY TABLE newgrp(user, team);
	.read inittbl.sql
	.import $CSV newgrp
	DELETE FROM newgrp WHERE user LIKE 'user';
	INSERT INTO teams SELECT distinct team FROM newgrp
			  WHERE team NOT IN (SELECT team FROM teams);
	PRAGMA foreign_keys=off;		-- To avoid score deletion
	UPDATE users SET team=(SELECT team FROM newgrp WHERE user=users.user)
	WHERE user IN (SELECT user FROM newgrp);
EOF