1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
# Test the incus admin sql command.
test_sql() {
# Invalid arguments
! incus admin sql foo "SELECT * FROM CONFIG" || false
! incus admin sql global "" || false
# Local database query
incus admin sql local "SELECT * FROM config" | grep -qF "core.https_address"
# Global database query
incus config set user.foo=bar
incus admin sql global "SELECT * FROM config" | grep -qF "user.foo"
# Global database insert
incus admin sql global "INSERT INTO config(key,value) VALUES('core.https_allowed_credentials','true')" | grep -qxF "Rows affected: 1"
incus admin sql global "DELETE FROM config WHERE key='core.https_allowed_credentials'" | grep -qxF "Rows affected: 1"
# Standard input
echo "SELECT * FROM config" | incus admin sql global - | grep -qF "user.foo"
# Multiple queries
incus admin sql global "SELECT * FROM config; SELECT * FROM instances" | grep -qxF "=> Query 0:"
# Local database dump
SQLITE_DUMP="${TEST_DIR}/dump.db"
incus admin sql local .dump | sqlite3 "${SQLITE_DUMP}"
sqlite3 "${SQLITE_DUMP}" "SELECT * FROM patches" | grep -qF "|dnsmasq_entries_include_device_name|"
rm -f "${SQLITE_DUMP}"
# Local database schema dump
SQLITE_DUMP="${TEST_DIR}/dump.db"
incus admin sql local .schema | sqlite3 "${SQLITE_DUMP}"
[ "$(sqlite3 "${SQLITE_DUMP}" 'SELECT * FROM schema' | wc -l)" = "0" ]
[ "$(sqlite3 "${SQLITE_DUMP}" 'SELECT * FROM patches' | wc -l)" = "0" ]
rm -f "${SQLITE_DUMP}"
# Global database dump
SQLITE_DUMP="${TEST_DIR}/dump.db"
GLOBAL_DUMP="$(incus admin sql global .dump)"
echo "$GLOBAL_DUMP" | grep -F "CREATE TRIGGER" # ensure triggers are captured.
echo "$GLOBAL_DUMP" | grep -F "CREATE INDEX" # ensure indices are captured.
echo "$GLOBAL_DUMP" | grep -F "CREATE VIEW" # ensure views are captured.
echo "$GLOBAL_DUMP" | sqlite3 "${SQLITE_DUMP}"
sqlite3 "${SQLITE_DUMP}" "SELECT * FROM profiles" | grep -qF "|Default Incus profile|"
rm -f "${SQLITE_DUMP}"
# Global database schema dump
SQLITE_DUMP="${TEST_DIR}/dump.db"
incus admin sql global .schema | sqlite3 "${SQLITE_DUMP}"
[ "$(sqlite3 "${SQLITE_DUMP}" 'SELECT * FROM schema' | wc -l)" = "0" ]
[ "$(sqlite3 "${SQLITE_DUMP}" 'SELECT * FROM profiles' | wc -l)" = "0" ]
rm -f "${SQLITE_DUMP}"
# Sync the global database to disk
SQLITE_SYNC="${INCUS_DIR}/database/global/db.bin"
echo "SYNC ${SQLITE_SYNC}"
incus admin sql global .sync
sqlite3 "${SQLITE_SYNC}" "SELECT * FROM schema" | grep -q "^1|"
sqlite3 "${SQLITE_SYNC}" "SELECT * FROM profiles" | grep -qF "|Default Incus profile|"
}
|
