summaryrefslogtreecommitdiff
path: root/tko/compose_query.cgi
AgeCommit message (Collapse)AuthorFilesLines
2010-01-26Table name in tko database have been changed. So update table name inmbligh1-1/+1
tko/compose_query.cgi. This patch will fix error "Table 'tko.kernels' doesn't exist:" in 'Results database' page. Signed-off-by: Feng Yang <fyang@redhat.com> git-svn-id: svn://test.kernel.org/autotest/trunk@4172 592f7852-d20e-0410-864c-8624ca9c26a4
2009-06-22Move client/bin/kernel_versions to common_lib; it is used by tko.mbligh1-1/+1
Signed-off-by: Duane Sand <duanes@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@3316 592f7852-d20e-0410-864c-8624ca9c26a4
2009-01-13Change all tabs to space. somehow we lost this change from tko/ ? mbligh1-192/+192
Somewhat scary Signed-off-by: Martin J. Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@2640 592f7852-d20e-0410-864c-8624ca9c26a4
2008-12-03gps pointed out that "== and != work in most cases but its better to use ismbligh1-1/+1
and is not as you'll never run into a case where someone's __eq__ or __ne__ method do the wrong thing." Signed-off-by: Martin J. Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@2533 592f7852-d20e-0410-864c-8624ca9c26a4
2008-11-27Fix the help URL in tkombligh1-1/+1
Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@2517 592f7852-d20e-0410-864c-8624ca9c26a4
2008-06-18Fix bad links when compose_query.cgi is viewed in 'brief' mode sincembligh1-6/+6
the afe now does a http request of the tko page and then injects it directly into a div tag (thus all relative links become relative from /afe/ not /tko/). Risk: Low (should be easy to verify things are working) Visibility: High Signed-off-by: Jeremy Orlow <jorlow@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1722 592f7852-d20e-0410-864c-8624ca9c26a4
2008-06-06Fix various TKO issuesmbligh1-2/+9
- make sure that Set-Cookie statement printed out before opening html tag - make sure query is recorded / replayed in case of proxy connection - fixed hardcoded cookie key in unique_cookie.unique_id - Formatting cleanup Signed-off-by: Vladimir Samarskiy <vsamarsk@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1629 592f7852-d20e-0410-864c-8624ca9c26a4
2008-06-06Whenever URL passed to compose_query.cgi contains argument brief=1 we willmbligh1-19/+28
display only the main grid. Mouse hovering fuctionality stubbed in brief view Signed-off-by: Vladimir Samarskiy <vsamarsk@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1628 592f7852-d20e-0410-864c-8624ca9c26a4
2008-05-15Save query on request.mbligh1-7/+23
a) Add to TKO UI a form containing button [SaveQuery] and edit control for optional comments b) On saveQuery request TKO make sure that user's cookies contain a unique user's id c) ... and then write into table query_history in TKO: time stamp, comment, uid, url of the query d) Make sure user can read saved queries back ( can read only own queries ) compose_query.cgi - added a form that supports user's request to save current qu ery save_query.cgi - saves the query query_history.cgi - shows saved queries by this user unique_cookie.py - common cookie related function: set/get user's unique id 006_add_table_query_history.py - database migration. New table introduced for qu ery history. Signed-off-by: Vladimir Samarskiy <vsamarsk@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1523 592f7852-d20e-0410-864c-8624ca9c26a4
2008-05-02Implemented a hover feature. Hovering over a cell in tko/compose_query.cgijadmanski1-3/+5
will give you the headers and the status. From: Fa Yoeu <fayoeu@google.com> Signed-off-by: John Admanski <jadmanski@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1483 592f7852-d20e-0410-864c-8624ca9c26a4
2008-05-01Convert tko/*.cgi to use absolute imports, to resolve somejadmanski1-12/+8
ambiguity with importing "frontend". Signed-off-by: John Admanski <jadmanski@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1482 592f7852-d20e-0410-864c-8624ca9c26a4
2008-05-01Printing out some performance measurements at the bottom of the page.jadmanski1-2/+10
Specifically, the page load time and sql access time for the tko/compose_query.cgi page. From: Fa Yoeu <fayoeu@google.com> Signed-off-by: John Admanski <jadmanski@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1481 592f7852-d20e-0410-864c-8624ca9c26a4
2008-05-01Provide support for lazily retrieving job logs from an external storage source.mbligh1-11/+14
From: Svitlana Tumanova <stumanova@google.com> Signed-off-by: Steve Howard <showard@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1478 592f7852-d20e-0410-864c-8624ca9c26a4
2008-04-16Roll back change to insert date cutoff field on front of TKOmbligh1-15/+4
Real solution as was discussed by Jeremy/Martin is to reduce the number of machine_group columns. From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1444 592f7852-d20e-0410-864c-8624ca9c26a4
2008-04-16restored parse_fieldmbligh1-2/+4
From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1443 592f7852-d20e-0410-864c-8624ca9c26a4
2008-04-16Exposed the title field in the report.mbligh1-5/+12
From: Fa Yoeu <fayoeu@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1442 592f7852-d20e-0410-864c-8624ca9c26a4
2008-04-16implementing request: reasons of failure should be displayed in non header cellsmbligh1-2/+16
- reasons are retrieved from the database and displayed in cells only when either columns or rows are grouped by status (because of performance reasons) - reasons are displayed in cell below GOOD / TOTAL ratio and only if GOOD is less then TOTAL i.e. when some problems occured From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1441 592f7852-d20e-0410-864c-8624ca9c26a4
2008-04-16TKO doesn't handle time conditions well, time_daily in the condition field ↵mbligh1-20/+3
does not work properly If you click on anything in this query the entire query gets screwed up. Row and column are both set to tag for no good reason, and the time condition is set equal to a particular second of the day. The time condition needs to be changed from time_daily='2008-03-17 00:00:00' to time_daily<'2008-03-18 00:00:00'&time_daily>'2008-03-17 00:00:00' time_daily should map to the SQL "DATE(whatever_the_time_column_is)". Also, the input to time_daily should have the time stripped off. I.e. it's not an acceptable solution for 'time_daily = some date' to map to 'time >= some date 00:00:00 & time <= some date 23:59:59" From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: Martin J. Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1440 592f7852-d20e-0410-864c-8624ca9c26a4
2008-04-16More undocumented changes for compose_query.cgimbligh1-7/+17
From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1439 592f7852-d20e-0410-864c-8624ca9c26a4
2008-04-16Various poorly documented changes to tko frontend. Sorrymbligh1-4/+7
From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1437 592f7852-d20e-0410-864c-8624ca9c26a4
2008-03-25fixed the problem of lost conditions when clicking Flipmbligh1-2/+3
Signed-off-by: Vladimir Samarskiy <vsamarsk@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1364 592f7852-d20e-0410-864c-8624ca9c26a4
2008-03-07Make a number of changes to compose_query:mbligh1-28/+67
- Fixed link to help file for condition control - Included time attribute into drop down menu - Allowed time and ID into condition control - Fixed font width - Improved data mining From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: John Admanski <jadmanski@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1311 592f7852-d20e-0410-864c-8624ca9c26a4
2008-02-28Missing a '/' on the end of job tagsmbligh1-1/+1
Signed-off-by: Scott Zawalski <scottz@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1275 592f7852-d20e-0410-864c-8624ca9c26a4
2008-02-21tko: use the root_url prefix in compose_query.cgiapw1-1/+1
We should be using the user specified prefix in compose_query.cgi, not hardwiring to /results/. Signed-off-by: Andy Whitcroft <apw@shadowen.org> git-svn-id: svn://test.kernel.org/autotest/trunk@1262 592f7852-d20e-0410-864c-8624ca9c26a4
2008-02-21split patched kernels into their own kernel rows V2apw1-11/+67
When we have tests on a kernel such as 2.6.24 and against 2.6.24+patch they are lumped together in the same results row. This is not optimal as commonly you are patching those kernels in order to fix a problem and want to see those separately. Ideally we would have a row for the virgin 2.6.24 results and a separate row for each different patch combination. The current structure simply displays the contents of the kernels table 'printable' field when displaying the matrix. That would necessitate encoding the base name and all applied patches into this field. Additionally if we desire to have tooltips, or links to individual patches the HTML encoding for that would need to be packed into this field. This is not desirable. This patch set modifies the meaning of the kernels table printable field, making it more of a "sortable" field. This field must be unique for all kernels, and also approximatly sortable into "kernel release" order. For kernels without patches, this is simply the base kernel version as normal. For patched kernels it is the base kernel version plus the kernel index number. This combination effectively allows the kernel to be sorted by base release, then by date. Now that the printable field is mearly a sortable identifier, it is no longer suitable for display. Thus this patch also introduces a new map abstraction for data fields. It supplies a mapper for the kernel field which uses the sortable kernel identifier to locate the base kernel and the full list of patches. For display purposes we want to see the kernel version plus the names of all the patches, all without allowing making the kernel column excessively wide. So the supplied mapper displays the base kernel version, plus truncated patch names (but with tooltips for the full names). Which ends up looking something like this: 2.6.24-mm1 p112 +add-new-string-functions- +x86-amd-thermal-interrupt This mapping does introduce a single additional query over the patches table (which is pretty small) before the matrix can be produced, only when the kernel field is displayed. Signed-off-by: Andy Whitcroft <apw@shadowen.org> git-svn-id: svn://test.kernel.org/autotest/trunk@1261 592f7852-d20e-0410-864c-8624ca9c26a4
2008-02-20A few display changes to tkombligh1-5/+2
1. Colors augmentation 2. fix insert_break_into_kernel_name 3. &nbsp;/&nbsp; to prevent line break just before or just after / From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: John Admanski <jadmanski@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1254 592f7852-d20e-0410-864c-8624ca9c26a4
2008-02-19Fixes a number of issues with the results display:mbligh1-4/+55
- clicking on the intersection of a job+test takes you to the results for that specific test - use different colours to indicate the percentage of failures - when looking at multiple results for the same test, display job_id/name on one axis and test_name on the other, instead of job_id on one axis and job_name on the other From: Vladimir Samarskiy <vsamarsk@google.com> Signed-off-by: John Admanski <jadmanski@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1249 592f7852-d20e-0410-864c-8624ca9c26a4
2008-01-16Clean up the reporting backend, and add CLI functionalitymbligh1-75/+31
I've pulled out the generic bits into frontend.py. There are way too many things called "row" and "column" so I've changed the matrix iterators to "x" and "y" to be less confusing Removed all the old, specific query reports, in favour of the new, powerful general one Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1166 592f7852-d20e-0410-864c-8624ca9c26a4
2008-01-11Move where the headers get generated on the results pagembligh1-2/+1
Signed-off-by: Martin J. Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1149 592f7852-d20e-0410-864c-8624ca9c26a4
2008-01-04Do URL encoding properly. This fixes a bug where, if your condition statementmbligh1-7/+6
had an & in it, clicking on a link would strip all but the first condition off. This should fix this and other potential problems. Signed-off-by: Jeremy Orlow <jorlow@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1109 592f7852-d20e-0410-864c-8624ca9c26a4
2008-01-04make compose_query.cgi executablembligh1-0/+0
git-svn-id: svn://test.kernel.org/autotest/trunk@1108 592f7852-d20e-0410-864c-8624ca9c26a4
2008-01-03Drill down support.mbligh1-6/+50
From: Jeremy Orlow <jorlow@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1105 592f7852-d20e-0410-864c-8624ca9c26a4
2008-01-03This patch will make compose_query.cgi considerably faster. It also has thembligh1-98/+103
beginnings of a library for parsing a simple language (for expressing conditionals) into SQL. Right now, the language only understands &'s, |'s, and most operators sql understands. In the future, it'll understand ()'s, !'s, and maybe others...but, given that the original compose_query.cgi only knew &'s and ='s, I didn't want to gate this patch for such support. In addition, high on my todo list is the ability to drill down into results by clicking on rows, columns, and cells. Signed-off-by: Jeremy Orlow <jorlow@google.com> NB. mbligh changed the set calls to use the builtin class. If that doesn't work, it's my fault ;-) git-svn-id: svn://test.kernel.org/autotest/trunk@1100 592f7852-d20e-0410-864c-8624ca9c26a4
2007-12-19reduce size of text boxmbligh1-1/+1
Signed-off-by: Martin J. Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@1088 592f7852-d20e-0410-864c-8624ca9c26a4
2007-11-05The query should allow the user to change the search on the fly.mbligh1-2/+70
From: Jeremy Orlow <jorlow@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@918 592f7852-d20e-0410-864c-8624ca9c26a4
2007-11-05lightly prettier (?) results tables, with minimal actual code changesmbligh1-0/+1
This looks like it changes lots of files, but really all the changes are in disp lay.py. In the other files I just added display.print_main_header() so that all pages have the common header now, which they should have anyway. From: Steve Howard <showard@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@909 592f7852-d20e-0410-864c-8624ca9c26a4
2007-11-051. Fix duplicate entries showing up in the table.mbligh1-72/+44
2. Modify the code to make only one sql query and then process the info than mak e one sql query per xy in a table. 3. Add reporting clii. 4. Also move the common libraries used by the cli and web interface into query_l ib.py. From: Radha Ramachandran <radha@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@908 592f7852-d20e-0410-864c-8624ca9c26a4
2007-11-05Import os module.mbligh1-1/+1
From: Radha Ramachandran <radha@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@886 592f7852-d20e-0410-864c-8624ca9c26a4
2007-11-05Add reporting support for backend.mbligh1-0/+141
From: Radha Ramachandran <radha@google.com> Signed-off-by: Martin Bligh <mbligh@google.com> git-svn-id: svn://test.kernel.org/autotest/trunk@880 592f7852-d20e-0410-864c-8624ca9c26a4
generated by cgit v1.2.3 (git 2.39.1) at 2024-11-21 16:03:47 +0000