History log of /external/autotest/tko/frontend.py
Revision Date Author Comments (<<< Hide modified files) (Show modified files >>>)
c1a98d1e146080bd3e4f034cb13d740dfb1535f4 15-Jan-2010 showard <showard@592f7852-d20e-0410-864c-8624ca9c26a4> Support for job keyvals
* can be passed as an argument to create_job, stored in AFE DB
* scheduler reads them from the AFE DB and writes them to the job-level keyval file before the job starts
* parser reads them from the keyval file and writes them to the TKO DB in a new table

Since the field name "key" happens to be a MySQL keyword, I went ahead and made db.py support proper quoting of field names. Evetually it'd be really nice to deprecate db.py and use Django models exclusively, but that is a far-off dream.

Still lacking support in the AFE and TKO web clients and CLIs, at least the TKO part will be coming soon

Signed-off-by: Steve Howard <showard@google.com>


git-svn-id: http://test.kernel.org/svn/autotest/trunk@4123 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
12b45582c04b2417036a6f11afc843ac5fddea50 11-Jan-2010 lmr <lmr@592f7852-d20e-0410-864c-8624ca9c26a4> Massive permission fix

Fix permissions for all the development tree

Signed-off-by: Lucas Meneghel Rodrigues <lmr@redhat.com>


git-svn-id: http://test.kernel.org/svn/autotest/trunk@4094 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
eab66ce582bfe05076ff096c3a044d8f0497bbca 23-Dec-2009 showard <showard@592f7852-d20e-0410-864c-8624ca9c26a4> Rename the tables in the databases, by prefixing the app name. This is
in preparation for merging the two databases and the two Django
projects into one.

Note that this renames *all* standard Autotest DB tables in both the
autotest_web and tko databases. If you have scripts written directly
against these databases, *they will break*. If your scripts access
the RPC interfaces, they should continue to work.

Another patch will be along within the next few weeks to actually move
the TKO tables into the autotest_web database.

From: James Ren <jamesren@google.com>
Signed-off-by: Steve Howard <showard@google.com>

Rename the tables in the databases, by prefixing the app name. This is
in preparation for merging the two databases and the two Django projects
into one.

Note that this renames *all* standard Autotest DB tables in both the autotest_web and tko databases. If you have scripts written directly against these databases, *they will break*. If your scripts access the RPC interfaces, they should continue to work.

From: James Ren <jamesren@google.com>
Signed-off-by: Steve Howard <showard@google.com>


git-svn-id: http://test.kernel.org/svn/autotest/trunk@4040 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
3abbceee9421805bed8f5c2c6c6abb9299b32cbf 11-Jul-2009 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> For files that won't be directly executed, the #! is unneccessary and can
confuse some tools that attempt to detect what the file is. Best to just
not have them there.

Signed-off-by: Jesse Keating <jkeating@redhat.com>


git-svn-id: http://test.kernel.org/svn/autotest/trunk@3407 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
753362d363fb183f32b4403d13ccc051438641e1 22-Jun-2009 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Move client/bin/kernel_versions to common_lib; it is used by tko.

Signed-off-by: Duane Sand <duanes@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@3316 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
8d88a6dd94bbb72171f1406acd07fa8a2b1ddcc7 05-Feb-2009 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Add start_time support.

Signed-off-by: Justin TerAvest <teravest@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@2751 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
b33e53e4544b179f4d27df16b4ab0a3d3851e075 17-Jun-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Fix errors found by lint.

Signed-off-by: Jeremy Orlow <jorlow@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1712 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
0afbb6369aa5aa9a75ea67dd9e95ec4b21c0c181 06-Jun-2008 jadmanski <jadmanski@592f7852-d20e-0410-864c-8624ca9c26a4> Convert all python code to use four-space indents instead of eight-space tabs.

Signed-off-by: John Admanski <jadmanski@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1658 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
146c796e19db7db37364006d84bf82762369c728 04-Jun-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> smart_sort is not sorting kernels correctly

Not much point in doing a custom kernel sort if we do another
unconditional sort at the end of the function. Return early.

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1599 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
204d356e8075fe2a7c1a0fcda2f3803287ca9a0d 27-May-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Make sure that grouping by time_daily works as expected.
Problem occurred because missing time stamp bewilded
sorting algorithm. Replace all NULLs with 1970-01-01 00:00:00 before sorting.
Change is visible to users.

Signed-off-by: Vladimir Samarskiy <vsamarsk@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1552 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
27eab24e72ae3c54482f3f4ca4090871becef849 21-May-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Query that user complains about actually returns ~27000 records
Bump up limit from 20000 to 50000 so that tko will not fail in typical workflows

Signed-off-by: Vladimir Samarskiy <vsamarsk@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1538 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
31260691c605f0d1f05619f3b418788ea902023f 17-Apr-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> implementing request: reasons of failure should be displayed in non header cells

- 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: http://test.kernel.org/svn/autotest/trunk@1441 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
5bb5586f9b39029794a7cb7fcb1f876793b2d24a 17-Apr-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> TKO doesn't handle time conditions well, time_daily in the condition field 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: http://test.kernel.org/svn/autotest/trunk@1440 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
aea0960b17ba471be6ff7e1361ec56d44357f91c 17-Apr-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Various poorly documented changes to tko frontend. Sorry

From: Vladimir Samarskiy <vsamarsk@google.com>
Signed-off-by: Martin Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1437 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
4a370cfff1670c1b09af271db885de41a988b53c 01-Apr-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> include time attribute into drop down menus

Signed-off-by: Vladimir Samarskiy <vsamarsk@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1387 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
2ba3e73931b5b6ee2d36c9dd1c00fe0dd9d5ee72 16-Jan-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Clean up the reporting backend, and add CLI functionality

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: http://test.kernel.org/svn/autotest/trunk@1166 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
5dd503b6b568292a01d5b99d1623caf9bfe44972 03-Jan-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Drill down support.

From: Jeremy Orlow <jorlow@google.com>
Signed-off-by: Martin Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1105 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
12eebfa225a6a7d487134eff47d519904a476eed 03-Jan-2008 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> This patch will make compose_query.cgi considerably faster. It also has the
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: http://test.kernel.org/svn/autotest/trunk@1100 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
f736b33c76389da0e9c40dff0480250f3c8c06f7 18-Dec-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Fix up the owners field mess in tko parsing - it can be None

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1080 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
e6413dbeaf1d7f98b983f1fea4a1b397a1ed6dc3 13-Dec-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Allow the user to search for a job.

From: Jeremy Orlow <jorlow@google.com>
Signed-off-by: Martin Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1065 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
83f63a091c60ae3ce672317800121a8dd197643b 12-Dec-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Fix up the main display page to only use one SQL query per rendering.
We use the new data view, and use SQL counting to get results

Signed-off-by: Martin Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1059 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
f18988255bd3ff34c8273df38e54b40a41ce97e1 07-Dec-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Quick hack fix for Null owners until we do something better



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1047 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
85952b4eed56048d9a9a6e523dffcb4e8a3a447e 07-Dec-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Add in condition for db class, for example select * from tests where kernel_idx
in (x, y, z)

From: Ying Han <yinghan@google.com>
Signed-off-by: Martin Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1045 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
05067a337a533290f1129004a84b80a14aa5641e 03-Dec-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> 'user' is officially an SQL reserved word, which means that it cannot be
used as a field name. Postgres enforces this so rename it to username.

Signed-off-by: Andy Whitcroft <apw@shadowen.org>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1017 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
8174ce35fd5e30a73f8a60f41174aab15e11faf6 30-Nov-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> A couple more updates for displaying machine owners correctly

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@1011 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
2b6725312dfe82ac36181942f2bbb18c4108f511 05-Nov-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> 1. Fix duplicate entries showing up in the table.
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: http://test.kernel.org/svn/autotest/trunk@908 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
2e4e5dfc8a82bbcee7a7e85e19d2427a6a21a1f6 05-Nov-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Add reporting support for backend.

From: Radha Ramachandran <radha@google.com>
Signed-off-by: Martin Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@880 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
c959f4f16a2aa9ed075c375db4cdf4664720b4ed 25-Oct-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Change frontend.py's results reference to a relative path



git-svn-id: http://test.kernel.org/svn/autotest/trunk@838 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
cff2d216eca9781dc672f6efefd7acc97ea2caa3 07-Oct-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Add a group class to frontend.py

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@764 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
414c69e4aa8bc29934025414dac164bfd42d85ad 05-Oct-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Extensions to SQL abstractions

Signed-off-by: Martin J. Bligh <mbligh@google.com>

Add more generalized select statement, allow where to be a
string as instead of a dictionary, add an update function.



git-svn-id: http://test.kernel.org/svn/autotest/trunk@755 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
2aaeb67f9f76232cc8ea78e7b1794193642efb0b 01-Oct-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Add a proper machine table rather than just using the hostname
Should have done this in the first place ;-(

Added a new machine class to frontend, etc as well.

THIS WILL NECESSITATE REBUILDING THE DATABASE

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@730 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
676510c409e142356c670a79d228cb86b3ce688e 28-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Fix silly bug in url setting when there's no subdir

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@710 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
50a2525b9cea63569791d55de030af76ea913e7b 27-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Sometimes we don't need the kernel and iterations for the test ...
especially on the front page. Doing so makes many more SQL queries.
Fix by just caching them as per Paul's suggestion

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@699 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
31d29c4c98201879444341b735a76869962f2219 27-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> add frontend matrix for performance benchmarks

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@694 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
de7335d7f64013da67786a5f728ddb5cbe7818fd 26-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Update tko to parse latest status file format

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@691 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
16ae9267874570539308a2df63ae27b172f68bbd 21-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Add dynamic graphing capability to TKO.

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@680 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
cfd2d01b083f9da7d642bdd78f8f4d4d52a02705 19-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> Refactor front-end display code

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@675 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
250300e6e1e29f274c7eaedc26f0579983bd47b1 18-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> update tko frontend code to link from 2nd level and sort tests.




git-svn-id: http://test.kernel.org/svn/autotest/trunk@670 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
52f974490b2c2bc728c2bc9f462755c817be0459 14-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> tko fixups



git-svn-id: http://test.kernel.org/svn/autotest/trunk@669 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
bfec522d59933f274699e2d9fcf03b8617ca4b33 14-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> tko updates




git-svn-id: http://test.kernel.org/svn/autotest/trunk@667 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
d72c91303fdd7204e2e74c3d59a453f25fb6a1db 14-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> insert second level of drilldown

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@665 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
8e1ab17905c69dc451bafe045ce1c5d5b1e646d0 13-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> update tko

Signed-off-by: Martin J. Bligh <mbligh@google.com>



git-svn-id: http://test.kernel.org/svn/autotest/trunk@663 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py
9bb92fe6698252617910021ec5c46c5edfee7233 12-Sep-2007 mbligh <mbligh@592f7852-d20e-0410-864c-8624ca9c26a4> tko updates



git-svn-id: http://test.kernel.org/svn/autotest/trunk@661 592f7852-d20e-0410-864c-8624ca9c26a4
/external/autotest/tko/frontend.py