Away:Module-get: Difference between revisions
From The Commonwealth of Acropolis
More actions
No edit summary |
No edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
#!/usr/bin/env bash | #!/usr/bin/env bash | ||
case $1 in | case $1 in | ||
name) # user_name -> user_real_name | name) # user_name -> user_real_name | ||
mariadb - | mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT user_real_name FROM user WHERE user_name = '$2';" | ||
;; | ;; | ||
dob) # user_name -> date_of_birth | dob) # user_name -> date_of_birth | ||
mariadb - | 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';" | |||
;; | |||
id) # user_name -> user_id | |||
mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT user_id FROM user WHERE user_name = '$2';" | |||
;; | ;; | ||
esac | esac | ||
Latest revision as of 13:43, 30 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';"
;;
id) # user_name -> user_id
mariadb --password="${wgDBpassword}" "${wgDBname}" <<<"SELECT user_id FROM user WHERE user_name = '$2';"
;;
esac