Lines Matching full:as
1 # Lint as: python2, python3
11 CREATE VIEW tko_test_view AS
20 tko_tests.started_time AS test_started_time,
21 tko_tests.finished_time AS test_finished_time,
22 tko_jobs.tag AS job_tag,
23 tko_jobs.label AS job_label,
24 tko_jobs.username AS job_username,
25 tko_jobs.queued_time AS job_queued_time,
26 tko_jobs.started_time AS job_started_time,
27 tko_jobs.finished_time AS job_finished_time,
28 tko_machines.hostname AS machine_hostname,
30 tko_machines.owner AS machine_owner,
32 tko_kernels.base AS kernel_base,
33 tko_kernels.printable AS kernel_printable,
34 tko_status.word AS status_word
42 CREATE VIEW tko_perf_view AS
51 tko_tests.started_time AS test_started_time,
52 tko_tests.finished_time AS test_finished_time,
53 tko_jobs.tag AS job_tag,
54 tko_jobs.label AS job_label,
55 tko_jobs.username AS job_username,
56 tko_jobs.queued_time AS job_queued_time,
57 tko_jobs.started_time AS job_started_time,
58 tko_jobs.finished_time AS job_finished_time,
59 tko_machines.hostname AS machine_hostname,
61 tko_machines.owner AS machine_owner,
63 tko_kernels.base AS kernel_base,
64 tko_kernels.printable AS kernel_printable,
65 tko_status.word AS status_word,
67 tko_iteration_result.attribute AS iteration_key,
68 tko_iteration_result.value AS iteration_value
78 CREATE VIEW tko_test_view_2 AS
81 tko_tests.test AS test_name,
84 tko_tests.status AS status_idx,
87 tko_tests.started_time AS test_started_time,
88 tko_tests.finished_time AS test_finished_time,
89 tko_jobs.tag AS job_tag,
90 tko_jobs.label AS job_name,
91 tko_jobs.username AS job_owner,
92 tko_jobs.queued_time AS job_queued_time,
93 tko_jobs.started_time AS job_started_time,
94 tko_jobs.finished_time AS job_finished_time,
95 tko_jobs.afe_job_id AS afe_job_id,
96 tko_machines.hostname AS hostname,
97 tko_machines.machine_group AS platform,
98 tko_machines.owner AS machine_owner,
100 tko_kernels.base AS kernel_base,
101 tko_kernels.printable AS kernel,
102 tko_status.word AS status
110 CREATE VIEW tko_test_view_outer_joins AS
113 tko_tests.test AS test_name,
116 tko_tests.status AS status_idx,
119 tko_tests.started_time AS test_started_time,
120 tko_tests.finished_time AS test_finished_time,
121 tko_jobs.tag AS job_tag,
122 tko_jobs.label AS job_name,
123 tko_jobs.username AS job_owner,
124 tko_jobs.queued_time AS job_queued_time,
125 tko_jobs.started_time AS job_started_time,
126 tko_jobs.finished_time AS job_finished_time,
127 tko_machines.hostname AS hostname,
128 tko_machines.machine_group AS platform,
129 tko_machines.owner AS machine_owner,
131 tko_kernels.base AS kernel_base,
132 tko_kernels.printable AS kernel,
133 tko_status.word AS status
141 CREATE VIEW tko_perf_view_2 AS
144 tko_tests.test AS test_name,
147 tko_tests.status AS status_idx,
150 tko_tests.started_time AS test_started_time,
151 tko_tests.finished_time AS test_finished_time,
152 tko_jobs.tag AS job_tag,
153 tko_jobs.label AS job_name,
154 tko_jobs.username AS job_owner,
155 tko_jobs.queued_time AS job_queued_time,
156 tko_jobs.started_time AS job_started_time,
157 tko_jobs.finished_time AS job_finished_time,
158 tko_machines.hostname AS hostname,
159 tko_machines.machine_group AS platform,
160 tko_machines.owner AS machine_owner,
162 tko_kernels.base AS kernel_base,
163 tko_kernels.printable AS kernel,
164 tko_status.word AS status,
166 tko_iteration_result.attribute AS iteration_key,
167 tko_iteration_result.value AS iteration_value
179 CREATE VIEW test_view AS
188 tests.started_time AS test_started_time,
189 tests.finished_time AS test_finished_time,
190 jobs.tag AS job_tag,
191 jobs.label AS job_label,
192 jobs.username AS job_username,
193 jobs.queued_time AS job_queued_time,
194 jobs.started_time AS job_started_time,
195 jobs.finished_time AS job_finished_time,
196 machines.hostname AS machine_hostname,
198 machines.owner AS machine_owner,
200 kernels.base AS kernel_base,
201 kernels.printable AS kernel_printable,
202 status.word AS status_word
210 CREATE VIEW perf_view AS
219 tests.started_time AS test_started_time,
220 tests.finished_time AS test_finished_time,
221 jobs.tag AS job_tag,
222 jobs.label AS job_label,
223 jobs.username AS job_username,
224 jobs.queued_time AS job_queued_time,
225 jobs.started_time AS job_started_time,
226 jobs.finished_time AS job_finished_time,
227 machines.hostname AS machine_hostname,
229 machines.owner AS machine_owner,
231 kernels.base AS kernel_base,
232 kernels.printable AS kernel_printable,
233 status.word AS status_word,
235 iteration_result.attribute AS iteration_key,
236 iteration_result.value AS iteration_value
245 CREATE VIEW test_view_outer_joins AS
248 tests.test AS test_name,
251 tests.status AS status_idx,
254 tests.started_time AS test_started_time,
255 tests.finished_time AS test_finished_time,
256 jobs.tag AS job_tag,
257 jobs.label AS job_name,
258 jobs.username AS job_owner,
259 jobs.queued_time AS job_queued_time,
260 jobs.started_time AS job_started_time,
261 jobs.finished_time AS job_finished_time,
262 machines.hostname AS hostname,
263 machines.machine_group AS platform,
264 machines.owner AS machine_owner,
266 kernels.base AS kernel_base,
267 kernels.printable AS kernel,
268 status.word AS status
276 CREATE VIEW test_view_2 AS
279 tests.test AS test_name,
282 tests.status AS status_idx,
285 tests.started_time AS test_started_time,
286 tests.finished_time AS test_finished_time,
287 jobs.tag AS job_tag,
288 jobs.label AS job_name,
289 jobs.username AS job_owner,
290 jobs.queued_time AS job_queued_time,
291 jobs.started_time AS job_started_time,
292 jobs.finished_time AS job_finished_time,
293 jobs.afe_job_id AS afe_job_id,
294 machines.hostname AS hostname,
295 machines.machine_group AS platform,
296 machines.owner AS machine_owner,
298 kernels.base AS kernel_base,
299 kernels.printable AS kernel,
300 status.word AS status
308 CREATE VIEW perf_view_2 AS
311 tests.test AS test_name,
314 tests.status AS status_idx,
317 tests.started_time AS test_started_time,
318 tests.finished_time AS test_finished_time,
319 jobs.tag AS job_tag,
320 jobs.label AS job_name,
321 jobs.username AS job_owner,
322 jobs.queued_time AS job_queued_time,
323 jobs.started_time AS job_started_time,
324 jobs.finished_time AS job_finished_time,
325 machines.hostname AS hostname,
326 machines.machine_group AS platform,
327 machines.owner AS machine_owner,
329 kernels.base AS kernel_base,
330 kernels.printable AS kernel,
331 status.word AS status,
333 iteration_result.attribute AS iteration_key,
334 iteration_result.value AS iteration_value