1# Copyright 2013 The Kyua Authors.
2# All rights reserved.
3#
4# Redistribution and use in source and binary forms, with or without
5# modification, are permitted provided that the following conditions are
6# met:
7#
8# * Redistributions of source code must retain the above copyright
9#   notice, this list of conditions and the following disclaimer.
10# * Redistributions in binary form must reproduce the above copyright
11#   notice, this list of conditions and the following disclaimer in the
12#   documentation and/or other materials provided with the distribution.
13# * Neither the name of Google Inc. nor the names of its contributors
14#   may be used to endorse or promote products derived from this software
15#   without specific prior written permission.
16#
17# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
18# "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
19# LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
20# A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
21# OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
22# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
23# LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
24# DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
25# THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26# (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
27# OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
28
29
30# Location of installed schema files.
31: "${KYUA_STOREDIR:=__KYUA_STOREDIR__}"
32
33
34# Location of installed test data files.
35: "${KYUA_STORETESTDATADIR:=__KYUA_STORETESTDATADIR__}"
36
37
38# Creates an empty old-style action database.
39#
40# \param ... Files that contain SQL commands to be run.
41create_historical_db() {
42    mkdir -p "${HOME}/.kyua"
43    cat "${@}" | sqlite3 "${HOME}/.kyua/store.db"
44}
45
46
47# Creates an empty results file.
48#
49# \param ... Files that contain SQL commands to be run.
50create_results_file() {
51    mkdir -p "${HOME}/.kyua/store"
52    local dbname="results.$(utils_test_suite_id)-20140718-173200-123456.db"
53    cat "${@}" | sqlite3 "${HOME}/.kyua/store/${dbname}"
54}
55
56
57utils_test_case upgrade__from_v1
58upgrade__from_v1_head() {
59    atf_set require.files \
60        "${KYUA_STORETESTDATADIR}/schema_v1.sql" \
61        "${KYUA_STORETESTDATADIR}/testdata_v1.sql" \
62        "${KYUA_STOREDIR}/migrate_v1_v2.sql" \
63        "${KYUA_STOREDIR}/migrate_v2_v3.sql"
64    atf_set require.progs "sqlite3"
65}
66upgrade__from_v1_body() {
67    create_historical_db "${KYUA_STORETESTDATADIR}/schema_v1.sql" \
68        "${KYUA_STORETESTDATADIR}/testdata_v1.sql"
69    atf_check -s exit:0 -o empty -e empty kyua db-migrate
70    for f in \
71        "results.test_suite_root.20130108-111331-000000.db" \
72        "results.usr_tests.20130108-123832-000000.db" \
73        "results.usr_tests.20130108-112635-000000.db"
74    do
75        [ -f "${HOME}/.kyua/store/${f}" ] || atf_fail "Expected file ${f}" \
76            "was not created"
77    done
78    [ ! -f "${HOME}/.kyua/store.db" ] || atf_fail "Historical database not" \
79        "deleted"
80}
81
82
83utils_test_case upgrade__from_v2
84upgrade__from_v2_head() {
85    atf_set require.files \
86        "${KYUA_STORETESTDATADIR}/schema_v2.sql" \
87        "${KYUA_STORETESTDATADIR}/testdata_v2.sql" \
88        "${KYUA_STOREDIR}/migrate_v2_v3.sql"
89    atf_set require.progs "sqlite3"
90}
91upgrade__from_v2_body() {
92    create_historical_db "${KYUA_STORETESTDATADIR}/schema_v2.sql" \
93        "${KYUA_STORETESTDATADIR}/testdata_v2.sql"
94    atf_check -s exit:0 -o empty -e empty kyua db-migrate
95    for f in \
96        "results.test_suite_root.20130108-111331-000000.db" \
97        "results.usr_tests.20130108-123832-000000.db" \
98        "results.usr_tests.20130108-112635-000000.db"
99    do
100        [ -f "${HOME}/.kyua/store/${f}" ] || atf_fail "Expected file ${f}" \
101            "was not created"
102    done
103    [ ! -f "${HOME}/.kyua/store.db" ] || atf_fail "Historical database not" \
104        "deleted"
105}
106
107
108utils_test_case already_up_to_date
109already_up_to_date_head() {
110    atf_set require.files "${KYUA_STOREDIR}/schema_v3.sql"
111    atf_set require.progs "sqlite3"
112}
113already_up_to_date_body() {
114    create_results_file "${KYUA_STOREDIR}/schema_v3.sql"
115    atf_check -s exit:1 -o empty -e match:"already at schema version" \
116        kyua db-migrate
117}
118
119
120utils_test_case need_upgrade
121need_upgrade_head() {
122    atf_set require.files "${KYUA_STORETESTDATADIR}/schema_v1.sql"
123    atf_set require.progs "sqlite3"
124}
125need_upgrade_body() {
126    create_results_file "${KYUA_STORETESTDATADIR}/schema_v1.sql"
127    atf_check -s exit:2 -o empty \
128        -e match:"database has schema version 1.*use db-migrate" kyua report
129}
130
131
132utils_test_case results_file__ok
133results_file__ok_body() {
134    echo "This is not a valid database" >test.db
135    atf_check -s exit:1 -o empty -e match:"Migration failed" \
136        kyua db-migrate --results-file ./test.db
137}
138
139
140utils_test_case results_file__fail
141results_file__fail_body() {
142    atf_check -s exit:1 -o empty -e match:"No previous results.*test.db" \
143        kyua db-migrate --results-file ./test.db
144}
145
146
147utils_test_case too_many_arguments
148too_many_arguments_body() {
149    cat >stderr <<EOF
150Usage error for command db-migrate: Too many arguments.
151Type 'kyua help db-migrate' for usage information.
152EOF
153    atf_check -s exit:3 -o empty -e file:stderr kyua db-migrate abc def
154}
155
156
157atf_init_test_cases() {
158    atf_add_test_case upgrade__from_v1
159    atf_add_test_case upgrade__from_v2
160    atf_add_test_case already_up_to_date
161    atf_add_test_case need_upgrade
162
163    atf_add_test_case results_file__ok
164    atf_add_test_case results_file__fail
165
166    atf_add_test_case too_many_arguments
167}
168