#!/bin/bash

[[ -d /usr/local/mysql ]] && echo "Existing MariaDB detected!!!" && select choice in Yes No; do
    [[ $choice == "Yes" ]] && rm -r /usr/local/mysql
    break
done

apiURL=https://downloads.mariadb.org/rest-api/mariadb

echo "Which major version should be installed?"

select major in $(curl -s $apiURL | jq -r .major_releases[].release_id); do
    echo $major
    break
done

res=$(curl -s $apiURL/$major | jq -r .releases[])
curl -L $(echo $res | jq -r .files[].file_download_url | rg '\-linux\-systemd\-x86_64.tar.gz' | head -n 1) -o $(echo $res | jq -r .files[].file_name | rg '\-linux\-systemd\-x86_64.tar.gz' | head -n 1)

gunzip mariadb-$(echo $res | jq -r .release_id | head -n 1)-linux-systemd-x86_64.tar.gz
tar xvf mariadb-$(echo $res | jq -r .release_id | head -n 1)-linux-systemd-x86_64.tar
rm mariadb-$(echo $res | jq -r .release_id | head -n 1)-linux-systemd-x86_64.tar
mv mariadb-$(echo $res | jq -r .release_id | head -n 1)-linux-systemd-x86_64 /usr/local/mysql

cd /usr/local/mysql

ln -fs $(pwd)/bin/* /bin

ls $(pwd)/bin | tee $(pwd)/bins.txt

cru mysql

bash scripts/mariadb-install-db --user=mysql --datadir=data

mv -f $(pwd)/man/* /usr/share/man
rm -r $(pwd)/man

chown -R mysql .

mv support-files/systemd/mariadb.service /etc/systemd/system

systemctl enable mariadb

systemctl restart mariadb