Merge ~pappacena/launchpad:db-ocirecipe-args into launchpad:db-devel

[Thiago F. Pappacena]

Database changes to support build ARG parameters when building OCI recipes

This field will be mapped on OCIRecipe.build_args as a JSON field. It should be an uni-dimensional dict with the arguments that ultimately will be used to add `--build-arg VARIABLE=value` to `docker build` command on the builders.

[Colin Watson (cjwatson)]

Other than the comment, OK by me, but I think we're still generally preferring to get second DB reviews from William so I'm adding him as a reviewer as well.

review: Approve (db)

e9eef42... by Thiago F. Pappacena on 2020-08-27

Changing json field datatype to jsonb instead of text

[William Grant (wgrant)]

review: Approve (db)

diff --git a/database/schema/patch-2210-20-1.sql b/database/schema/patch-2210-20-1.sql
new file mode 100644
index 0000000..83d5615
--- /dev/null
+++ b/database/schema/patch-2210-20-1.sql
@@ -0,0 +1,10 @@
+-- Copyright 2020 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+ALTER TABLE OCIRecipe ADD COLUMN build_args jsonb;
+
+COMMENT ON COLUMN OCIRecipe.build_args IS 'ARGs to be used when building the OCI Recipe.';
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 20, 1);