[aur-dev] [PATCH 1/4] Add sqlite3 schema for testing databases

Lukas Fleischer lfleischer at archlinux.org
Wed Mar 1 19:19:07 UTC 2017

On Wed, 01 Mar 2017 at 07:46:18, Mark Weiman wrote:
> The existing aur-schema.sql file is specific to MySQL, this patch adds a second
> schema file for use to create sqlite3 testing databases.
> Signed-off-by: Mark Weiman <mark.weiman at markzz.com>
> ---
>  schema/aur-schema-sqlite.sql | 368 +++++++++++++++++++++++++++++++++++++++++++
>  1 file changed, 368 insertions(+)
>  create mode 100644 schema/aur-schema-sqlite.sql
> [...]

This makes it a bit more cumbersome to update the schema since having
two independent schema files means that every database layout amendment
must be done twice. I suggest creating this automatically instead, like
we already do in the test suite; see the patches which I will send to
the list in a minute.

More information about the aur-dev mailing list