"sha1hash": null,

        sha1hash:
          nullable: true
          description: sha1 hash of the file
          type: string

            sha1hash: null

                product.sha1hash = hashString(htSHA1, contents);

    nix::Hash sha1hash, sha256hash;

    nix::Hash sha256hash;

            ("insert into BuildProducts (build, productnr, type, subtype, fileSize, sha1hash, sha256hash, path, name, defaultPath) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)",

            ("insert into BuildProducts (build, productnr, type, subtype, fileSize, sha256hash, path, name, defaultPath) values ($1, $2, $3, $4, $5, $6, $7, $8, $9)",

             product.isRegular ? std::make_optional(product.sha1hash.to_string(Base16, false)) : std::nullopt,

            ("select type, subtype, fileSize, sha1hash, sha256hash, path, name, defaultPath from BuildProducts where build = $1 order by productnr",

            ("select type, subtype, fileSize, sha256hash, path, name, defaultPath from BuildProducts where build = $1 order by productnr",

                product.sha1hash = Hash(row[3].as<std::string>(), htSHA1);

                product.sha256hash = Hash(row[3].as<std::string>(), htSHA256);

                product.sha256hash = Hash(row[4].as<std::string>(), htSHA256);
            if (!row[5].is_null())
                product.path = row[5].as<std::string>();
            product.name = row[6].as<std::string>();
            if (!row[7].is_null())
                product.defaultPath = row[7].as<std::string>();

                product.path = row[4].as<std::string>();
            product.name = row[5].as<std::string>();
            if (!row[6].is_null())
                product.defaultPath = row[6].as<std::string>();

                    sha1hash => $product->sha1hash,

  is_nullable: 1
=head2 sha1hash
  data_type: 'text'

  "sha1hash",
  { data_type => "text", is_nullable => 1 },

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iI0gmKqQxiPBTy5QsM6tpQ

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-27 18:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O4R8b/GukNaUmmAErb3Jlw

        'sha1hash',

              <tr><th>SHA-1 hash:</th><td><tt>[% product.sha1hash %]</tt></td></tr>

    sha1hash      text,

alter table BuildProducts drop column sha1hash;