Away:Module-get: Difference between revisions
From The Commonwealth of Acropolis
More actions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
;; | ;; | ||
dob) # user_name -> date_of_birth | dob) # user_name -> date_of_birth | ||
mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT date_of_birth FROM user WHERE user_name = '$2';" | mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT date_of_birth FROM user WHERE user_name = '$2';" | tail -n1 | ||
;; | ;; | ||
gender) # user_name -> gender_marker | gender) # user_name -> gender_marker | ||
mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT gender_marker FROM user WHERE user_name = '$2';" | mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT gender_marker FROM user WHERE user_name = '$2';" | ||
esac | esac | ||
Revision as of 21:48, 16 September 2026
#!/usr/bin/env bash
case $1 in
name) # user_name -> user_real_name
mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT user_real_name FROM user WHERE user_name = '$2';"
;;
dob) # user_name -> date_of_birth
mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT date_of_birth FROM user WHERE user_name = '$2';" | tail -n1
;;
gender) # user_name -> gender_marker
mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT gender_marker FROM user WHERE user_name = '$2';"
esac