From: Victor Huesca <victor.huesca@bootlin.com>
To: buildroot@busybox.net
Subject: [Buildroot] [PATCH buildroot-test 0/4] allow results to be filtered by symbols
Date: Fri, 21 Jun 2019 14:37:08 +0200 [thread overview]
Message-ID: <20190621123712.8060-1-victor.huesca@bootlin.com> (raw)
The following patch provides a better support for interaction with the autobuild
database.
The patch is composed of 4 commits that add the following changes:
- Update internal sql query (func.inc.php) to allow requests on symbols.
- Update the index.php page to parse read symbols from GET with the syntax
`symbols[BR2_INIT_SYSTEMD]=y`
- Update the database schema by adding indexes on the two columns of
`symbol_per_result` to improve queries that involve specific symbols.
Also mark these columns as foreign keys to ensure integrity of the database.
- Add a new page which consist a basic form to ease searching in the database.
This patch is a v1 and there are probably many issue to fix, so any suggestion
concerning functionnalities/coding style are welcome -- especially as it is an
ugly php script and an even more ugly javascript.
Victor Huesca (4):
web/{funcs,db}.inc.php: add support for symbols in sql query
web/index.php: add support for symbols to be passed via GET
web/schema.sql: add indexes on the database schema
web/request.{js,php} and web/stylesheet.css: new page to ease seaching
for specific results
web/db.inc.php | 28 ++++++++++++++--
web/funcs.inc.php | 48 ++++++++++++++++++++++------
web/index.php | 25 ++++++++++++---
web/request.js | 47 +++++++++++++++++++++++++++
web/request.php | 67 +++++++++++++++++++++++++++++++++++++++
web/schema.sql | 7 +++-
web/stylesheet.css | 79 ++++++++++++++++++++++++++++++++++++++++++++++
7 files changed, 284 insertions(+), 17 deletions(-)
create mode 100644 web/request.js
create mode 100644 web/request.php
--
2.21.0
next reply other threads:[~2019-06-21 12:37 UTC|newest]
Thread overview: 13+ messages / expand[flat|nested] mbox.gz Atom feed top
2019-06-21 12:37 Victor Huesca [this message]
2019-06-21 12:37 ` [Buildroot] [PATCH buildroot-test 1/4] web/{funcs, db}.inc.php: add support for symbols in sql query Victor Huesca
2019-06-21 12:37 ` [Buildroot] [PATCH buildroot-test 2/4] web/index.php: add support for symbols to be passed via GET Victor Huesca
2019-06-21 12:37 ` [Buildroot] [PATCH buildroot-test 3/4] web/schema.sql: add indexes on the database schema Victor Huesca
2019-06-21 12:37 ` [Buildroot] [PATCH buildroot-test 4/4] web/request.{js, php} and web/stylesheet.css: new page to ease seaching for specific results Victor Huesca
2019-07-08 8:17 ` [Buildroot] [PATCH buildroot-test v2 0/4] allow results to be filtered by symbols Victor Huesca
2019-07-08 8:17 ` [Buildroot] [PATCH buildroot-test v2 1/4] web/{funcs, db}.inc.php: add support for symbols in sql query Victor Huesca
2019-07-12 13:29 ` Thomas Petazzoni
2019-07-08 8:17 ` [Buildroot] [PATCH buildroot-test v2 2/4] web/index.php: add support for symbols to be passed via GET Victor Huesca
2019-07-12 13:37 ` Thomas Petazzoni
2019-07-08 8:17 ` [Buildroot] [PATCH buildroot-test v2 3/4] web/schema.sql: add indexes on the database schema Victor Huesca
2019-07-12 13:46 ` Thomas Petazzoni
2019-07-08 8:17 ` [Buildroot] [PATCH buildroot-test v2 4/4] web/request.{js, php} and web/stylesheet.css: new page to ease seaching for specific results Victor Huesca
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20190621123712.8060-1-victor.huesca@bootlin.com \
--to=victor.huesca@bootlin.com \
--cc=buildroot@busybox.net \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox