nixos/profiles/workstation/scripts/rsqlite


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

#!/usr/bin/env bash
if [[ "$#" != 2 && "$#" != "3" ]]; then
    echo "usage: $0 <host> <path_in_var_lib> [sql]"
    exit 1
fi

printf -v path %q "$2"

if [[ "$#" == "3" ]]; then
    printf -v sql %q "$3"
else
    sql=""
fi

ssh "$1" -t "sudo su -c 'sqlite3 /var/lib/$path $sql'"