57 lines
1.6 KiB
YAML
57 lines
1.6 KiB
YAML
id: "mariadb"
|
|
aliases:
|
|
- "maria"
|
|
name: "MariaDB"
|
|
|
|
install:
|
|
apt:
|
|
- libaio1
|
|
- libtinfo5
|
|
- mysql-client
|
|
riju:
|
|
- sqls
|
|
# MariaDB has Debian package downloads, but only for LTS versions of
|
|
# Ubuntu, so we have to download the release tarball instead.
|
|
manual: |
|
|
install -d "${pkg}/opt/mariadb"
|
|
|
|
ver="$(curl -sSL https://downloads.mariadb.org/ | grep 'href="/mariadb/[0-9]' | grep -Eo '[0-9][^/]+' | sort -rV | head -n1)"
|
|
wget "https://downloads.mariadb.org/f/mariadb-${ver}/bintar-linux-systemd-x86_64/mariadb-${ver}-linux-systemd-x86_64.tar.gz/from/http%3A//sfo1.mirrors.digitalocean.com/mariadb/?serve" -O mariadb.tar.gz
|
|
tar -xf mariadb.tar.gz -C "${pkg}/opt/mariadb" --strip-components=1
|
|
chmod a=rx,u=rwx "${pkg}/opt/mariadb/lib/plugin/auth_pam_tool_dir"
|
|
chmod a=rx,u=rwxs "${pkg}/opt/mariadb/lib/plugin/auth_pam_tool_dir/auth_pam_tool"
|
|
|
|
repl: |
|
|
rm -rf data
|
|
/opt/mariadb/scripts/mariadb-install-db --no-defaults --user="$(id -un)"
|
|
(/opt/mariadb/bin/mysqld --no-defaults --datadir="$PWD/data" --socket="$PWD/socket" --skip-networking &)
|
|
until [[ -e socket ]]; do
|
|
sleep 0.01
|
|
done
|
|
mysql --socket=socket
|
|
input: |
|
|
SELECT 123 * 234;
|
|
|
|
main: "main.sql"
|
|
template: |
|
|
SELECT 'Hello, world!';
|
|
|
|
run: |
|
|
set -e
|
|
rm -rf data
|
|
/opt/mariadb/scripts/mariadb-install-db --no-defaults --user="$(id -un)"
|
|
(/opt/mariadb/bin/mysqld --no-defaults --datadir="$PWD/data" --socket="$PWD/socket" --skip-networking &)
|
|
until [[ -e socket ]]; do
|
|
sleep 0.01
|
|
done
|
|
(mysql --socket=socket < main.sql; mysql --socket=socket)
|
|
|
|
lsp:
|
|
start: |
|
|
sqls
|
|
code: "TODO"
|
|
item: "TODO"
|
|
|
|
skip:
|
|
- lsp
|