Improve sql efficiency

See merge request !1095

Using LIKE instead of Regexp match is way faster.

Thanks-to: Charles Oliveira <charles.oliveira@linaro.org>
Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

submit_time is always lower than now! (not in the future).
Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

Use a local cache + SQL aggregate.

On /results/ this decrease the number of queries from 183 to 106.
Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

SQL efficiency

See merge request !1090

XMLRPC api endpoint for downloading master encryption key.

Closes #388

See merge request !1092

test: interactive: allow for non-exiting commands

See merge request !1086

Docker fixes

See merge request !1091

Fix typo in commit c779080d

See merge request !1094

Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

scheduler: templates: change quick filter widgets to tabs

Closes #395

See merge request !1093

Instead of showing pagers which are more suitable for pagination, tabs
are used. This clarifies content selection.

Fixes: #395
Signed-off-by: Milosz Wasilewski <milosz.wasilewski@linaro.org>

Fixes #388.

State machine: fix an issue when start_time is not set

See merge request !1088

XMLRPC api endpoints for uploading/downloading worker encryption keys.

See merge request !1089

Lower the number of SQL requests in a number of pages.
Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

Use the same page layout.
Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

This page was generating 74 requests.
It's now generating 22 queries.
Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

RESTAPI endpoint for downloading master encryption key.

Closes #388

See merge request !1085

The lava-dispatcher-host mapping will share the device with the
container when it's connected, so for instance if the tests reset the
board for some reason, it will just work.

But if the device is already up when the container starts, it needs to
be passed in the docker command line.

For safety, amend the one existing user to also call tty()

DockerRun.run will perform several utilities before actually running the
command:

- it will pull the image to make sure we always run the latest version
- it will check that the architecture in the image matches the host
  architectures, and issue a warning otherwise.

This is kind of hardcoded to support libguestfs stuff, but any used images
should be self-contained and already include a kernel image with modules.

New global endpoint 'system' is introduced.

device-type: add sun8i-h3-bananapi-m2-plus

See merge request !1087

If the job is really quick to finish (a failure in validate), and lava-master
is slow to response then lava-logs will notice the end of a job (and call
go_state_finished) before lava-master handles the START_OK message (and call
go_state_running).

LAVA : https://lkft.validation.linaro.org/scheduler/job/1331302
Event: https://sentry.io/organizations/linaro/issues/1591706434/Signed-off-by: Rémi Duraffort <remi.duraffort@linaro.org>

This patch adds support for the sun8i-h3-bananapi-m2-plus

When trying to test commands that don't exit in non-posix shells,
interactive test needs a new flag "wait_for_prompt". This flag can be
added to any command. Only success or failure strings need to be matched to
proceed to next command. One use case for this flag is testing
'fastboot' in u-boot shell
Signed-off-by: Milosz Wasilewski <milosz.wasilewski@linaro.org>

device-types: add imx6q-var-dt6customboard

See merge request !1084

RESTAPI endpoints for uploading/downloading worker encryption keys.

Closes #388

See merge request !1079

Add RESTAPI calls for downloading and uploading slave public
keys to the master.

This patch adds support for the imx6q-var-dt6customboard.
Signed-off-by: Corentin LABBE <clabbe@baylibre.com>

device-types: stm32mp157c-dk2: permit to overrides addresses

See merge request !1083

Using the current bootm_ramdisk_addr lead to "TFTP error: trying to overwrite reserved memory..."
According to Remi Duraffort which create this device-type, the addresses was given by ST people,
perhaps it works on some old revision of this board.
So let's permit to override addresses per board.