Aklapper has uploaded a new change for review.
https://gerrit.wikimedia.org/r/255430
Change subject: List workboard column changes in weekly Phabricator changes
email
......................................................................
List workboard column changes in weekly Phabricator changes email
Bug: T119623
Change-Id: If340c5eec5156e37f332d98985238eaf554624a6
---
M modules/phabricator/templates/project_changes.sh.erb
1 file changed, 19 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/30/255430/1
diff --git a/modules/phabricator/templates/project_changes.sh.erb
b/modules/phabricator/templates/project_changes.sh.erb
index 8df8010..8d43a91 100644
--- a/modules/phabricator/templates/project_changes.sh.erb
+++ b/modules/phabricator/templates/project_changes.sh.erb
@@ -55,6 +55,23 @@
END
)
+#echo "result_column_changes"
+result_column_changes=$(MYSQL_PWD=${sql_pass} /usr/bin/mysql -h $sql_host
-u$sql_user $sql_name << END
+
+SELECT SELECT cltr.oldValue, cltr.newValue, prj.name, usr.userName
+ FROM phabricator_project.project_columntransaction cltr
+ JOIN phabricator_project.project prj
+ JOIN phabricator_project.project_column pcl
+ JOIN phabricator_user.user usr
+ WHERE (cltr.transactionType = "project:col:name"
+ OR cltr.transactionType = "project:col:status")
+ AND cltr.objectPHID = pcl.phid
+ AND pcl.projectPHID = prj.phid
+ AND cltr.authorPHID = usr.phid
+ AND cltr.dateModified > UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 WEEK));
+
+END
+)
# the actual email
cat <<EOF | /usr/bin/mail -r "${sndr_address}" -s "Phabricator weekly project
changes" ${rcpt_address}
@@ -76,6 +93,8 @@
${result_policy_locking_archiving_changes}
+PROJECT WORKBOARD COLUMN CHANGES:
+${result_column_changes}
Yours sincerely,
Fab Rick Aytor
--
To view, visit https://gerrit.wikimedia.org/r/255430
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: If340c5eec5156e37f332d98985238eaf554624a6
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Aklapper <aklap...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
