Comment 4 for bug 1052545

+Michael who's a DB query wizard.

On 09/19/2012 03:17 AM, Milo Casagrande wrote:
> Hello Andy,
>
> thanks for the input!
>
> On Wed, Sep 19, 2012 at 12:02 AM, Andy Doan <email address hidden> wrote:
>> I think you are on the right track here. However, rather than listing
>> all tests, we could probably make this function take some params. For
>> example, if we know:
>>
>> device-type (panda, vexpress, origen, etc)
>> build-type (android / ubuntu)
>>
>> You could actually filter down the list of tests more appropriately.
>
> Something like that would be awesome for us, but I guess I need a
> little bit of guidance here then.
> Looking at the Test model in 'lava_dashboard/dashboard_app/models.py',
> the model is pretty simple, there is no information about device or
> build.
>
> The only reference about hardware I found is in TestRun model, that
> refers to HardwareDevice, but the latter is not really helpful.
>

Michael - do you think there's a way to query for this semi-efficiently.
ie somehow doing a "SELECT test where device_type=='panda'"