diff --git a/jtserv/adduser.sh b/jtserv/adduser.sh index e895938..f0908da 100755 --- a/jtserv/adduser.sh +++ b/jtserv/adduser.sh @@ -1,14 +1,20 @@ #!/bin/sh +## Feeding CSV as follows: +## user,gecos,email,team +# j2100,"HIROSE Yuuji",yuuji@es.gentei.org,Teacher + +## This script can be run repeatedly in order to change team allocation. + DB=${1:-users.sq3} -CSV=${2:-users.csv} +CSV=${2:-trrusers.csv} sqlite3 ${DB} <<-EOF .mode csv - PRAGMA foreign_keys=on; CREATE TEMPORARY TABLE newuser(user, gecos, email, team); .import $CSV newuser + DELETE FROM newuser WHERE user LIKE 'user'; 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); + PRAGMA foreign_keys=off; -- To avoid score deletion + REPLACE INTO users SELECT user, gecos, email, team FROM newuser; EOF