Lines Matching full:and

4 -- Redistribution and use in source and binary forms, with or without
9 --   notice, this list of conditions and the following disclaimer.
11 --   notice, this list of conditions and the following disclaimer in the
12 --   documentation and/or other materials provided with the distribution.
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
24 -- DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
33 -- and its changes were:
41 --   programs and test cases in an abstract manner regardless of their
44 -- * Added the metadata_id field to the test_programs and test_cases
48 --   rather than in microseconds.  There is no data loss, and the code that
51 -- * Removed the atf_* and plain_* tables.
55 -- * Added missing column affinities to the absolute_path and relative_path
80 -- Add the new tables, columns and indexes.
93 -- Upgrade the test_programs table by adding missing column affinities and
139 -- every test program and test case.  Entries corresponding to a test program
140 -- will have the test_program_id field set to not NULL and entries corresponding
161 -- Populate default metadata values for all test programs and test cases.
163 -- We do this first to ensure that all test programs and test cases have
199     WHERE test_program_id IS NOT NULL AND property_name = 'timeout'
200         AND interface = 'plain';
207     WHERE test_case_id IS NOT NULL AND property_name = 'timeout'
208         AND interface = 'plain';
223     WHERE test_case_id IS NOT NULL AND property_name = 'description'
224         AND interface = 'atf';
229     WHERE test_case_id IS NOT NULL AND property_name = 'has_cleanup'
230         AND interface = 'atf';
235     WHERE test_case_id IS NOT NULL AND property_name = 'timeout'
236         AND interface = 'atf';
241     WHERE test_case_id IS NOT NULL AND property_name = 'required_memory'
242         AND interface = 'atf';
247     WHERE test_case_id IS NOT NULL AND property_name = 'required_user'
248         AND interface = 'atf';
253             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
255     WHERE test_case_id IS NOT NULL AND property_name = 'allowed_architectures'
256         AND interface = 'atf'
257         AND EXISTS(SELECT 1 FROM atf_test_cases_multivalues AS aux
259                    AND property_name = 'require.arch');
264             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
266     WHERE test_case_id IS NOT NULL AND property_name = 'allowed_platforms'
267         AND interface = 'atf'
268         AND EXISTS(SELECT 1 FROM atf_test_cases_multivalues AS aux
270                    AND property_name = 'require.machine');
275             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
277     WHERE test_case_id IS NOT NULL AND property_name = 'required_configs'
278         AND interface = 'atf'
279         AND EXISTS(SELECT 1 FROM atf_test_cases_multivalues AS aux
281                    AND property_name = 'require.config');
286             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
288     WHERE test_case_id IS NOT NULL AND property_name = 'required_files'
289         AND interface = 'atf'
290         AND EXISTS(SELECT 1 FROM atf_test_cases_multivalues AS aux
292                    AND property_name = 'require.files');
297             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
299     WHERE test_case_id IS NOT NULL AND property_name = 'required_programs'
300         AND interface = 'atf'
301         AND EXISTS(SELECT 1 FROM atf_test_cases_multivalues AS aux
303                    AND property_name = 'require.progs');
306 -- Fill metadata_id pointers in the test_programs and test_cases tables.