Mercurial > hgrepos > hgweb.cgi > s4

changeset 1056:65397dab6c6c draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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

yatex.org