svn commit: r299979 - user/des/fbce/db

[Dag-Erling Smørgrav]

Author: des
Date: Mon May 16 22:16:54 2016
New Revision: 299979
URL: https://svnweb.freebsd.org/changeset/base/299979

Log:
  Update notes for this year's election.

Modified:
  user/des/fbce/db/notes

Modified: user/des/fbce/db/notes
==============================================================================
--- user/des/fbce/db/notes	Mon May 16 22:16:17 2016	(r299978)
+++ user/des/fbce/db/notes	Mon May 16 22:16:54 2016	(r299979)
@@ -35,17 +35,20 @@ psql -f db/fbce.sql fbce fbce
 perl -Ilib -MFBCE -e 'FBCE->model("FBCE::Person")->find({ login => "kenneth36" })->set_password("4ltInn!?")'
 
 #
-# The list of users is generated on freefall using scripts written for
-# that purpose by gjb:
+# The list of users is extracted from fst3k:
 #
-# des at freefall ~% ~gjb/bin/genuserlist.sh                          
-# Output written to: /home/des/tmp.NAQqdhqXM0
-# des at freefall ~% ~gjb/bin/genuserlist.pl /home/des/tmp.NAQqdhqXM0 >users-20140521.txt
-# des at freefall ~% echo dbn >>users-20140521.txt
-# des at freefall ~% getent passwd $(cat users-20140521.txt) >gecos-20140521.txt
+# fst3k=# \t on
+# Showing only tuples.
+# fst3k=# \o users-20160518.txt
+# fst3k=# select login from persons where login != 'cvs2svn';
+# fst3k=# \o
+#
+# Real names are taken from freefall:
 #
-./script/fbce_user.pl import users-20140521.txt
-./script/fbce_user.pl gecos gecos-20140521.txt
+# des at freefall ~% getent passwd >gecos-20160518.txt
+#
+./script/fbce_user.pl import users-20160518.txt
+./script/fbce_user.pl gecos gecos-20160518.txt
 ./script/fbce_user.pl smash
 
 #
@@ -53,16 +56,18 @@ perl -Ilib -MFBCE -e 'FBCE->model("FBCE:
 #
 # fst3k=# \t on
 # Showing only tuples.
-# fst3k=# \o active-20140521.txt
-# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2013-05-21' group by p.login;
+# fst3k=# \o active-20160518.txt
+# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2015-05-18' group by p.login;
+# fst3k=# \o
 #
-./script/fbce_user.pl activate active-20140521.txt
+./script/fbce_user.pl activate active-20160518.txt
 
 #
-# The list of incumbents was manually generated from
-# http://www.freebsd.no/administration.html#t-core
+# The list of incumbents is obtained from freefall:
+#
+# des at freefall ~% getent group core | cut -d: -f4 | tr , '\n' >core-20160518.txt
 #
-./script/fbce_user.pl incumbent core-20140521.txt
+./script/fbce_user.pl incumbent core-20160518.txt
 
 #
 # Finally, generate passwords