Mercurial > hgrepos > hgweb.cgi > s4
changeset 1056:65397dab6c6c draft
FIX: s4-add-group-csv.sh violates existing group
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 15 Jun 2024 15:42:46 +0900 |
parents | d7796b60566c |
children | 957a3fd80b88 |
files | scripts/add-group-csv.sh |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/scripts/add-group-csv.sh Sat Jun 08 09:24:27 2024 +0900 +++ b/scripts/add-group-csv.sh Sat Jun 15 15:42:46 2024 +0900 @@ -28,7 +28,8 @@ .mode csv CREATE TEMPORARY TABLE _gusers(gname, user, admin); .import $target _gusers - REPLACE INTO grp SELECT distinct gname FROM _gusers; + INSERT INTO grp SELECT distinct gname FROM _gusers + WHERE _gusers.gname NOT IN (SELECT gname FROM grp); CREATE TEMPORARY TABLE _default_grp_attr(key, val); INSERT INTO _default_grp_attr