#!/bin/sh

DB=${1:-users.sq3}
CSV=${2:-users.csv}
sqlite3 ${DB} <<-EOF
	.mode csv
	PRAGMA foreign_keys=on;
	CREATE TEMPORARY TABLE newuser(user, gecos, email, team);
	.import $CSV newuser
	INSERT INTO teams SELECT distinct team FROM newuser
			  WHERE team NOT IN (SELECT team FROM teams);
	INSERT INTO users SELECT user, gecos, email, team
		FROM newuser WHERE user NOT IN (SELECT user FROM users);
EOF