bcgov/common-object-management-service

const { Model } = require('objection');

class Metadata extends Model {
  static get tableName() {
    return 'metadata';
  }

  static get relationMappings() {
    const Version = require('./version');
    const VersionMetadata = require('./versionMetadata');

    return {
      version: {
        relation: Model.ManyToManyRelation,
        modelClass: Version,
        join: {
          from: 'metadata.id',
          through: {
            from: 'version_metadata.metadataId',
            to: 'version_metadata.versionId'
          },
          to: 'version.id'
        }
      },
      versionMetadata: {
        relation: Model.HasManyRelation,
        modelClass: VersionMetadata,
        join: {
          from: 'metadata.id',
          to: 'version_metadata.metadataId'
        }
      },
    };
  }

  static get modifiers() {
    return {
      filterKey(query, value) {
        const subqueries = [];
        if (value.metadata && Object.keys(value.metadata).length) {
          Object.entries(value.metadata).forEach(metadata => {
            const q = Metadata.query().select('metadata.id').where('key', 'ilike', `%${metadata[0]}%`);
            subqueries.push(q);
          });
        }
        if (subqueries.length) {
          query
            .whereIn('metadata.id', builder => {
              builder.intersect(subqueries);
            });
        }
      },

      filterKeyValue(query, value) {
        const subqueries = [];
        if (value.metadata && Object.keys(value.metadata).length) {
          Object.entries(value.metadata).forEach(([key, val]) => {
            const q = Metadata.query().select('metadata.id').where('key', 'ilike', `%${key}%`);
            if (val.length) q.where('value', 'ilike', `%${val}%`);
            subqueries.push(q);
          });
        }
        if (subqueries.length) {
          query
            .whereIn('metadata.id', builder => {
              builder.intersect(subqueries);
            });
        }
      },
    };
  }

  static get jsonSchema() {
    return {
      type: 'object',
      required: ['key', 'value'],
      properties: {
        id: { type: 'integer' },
        key: { type: 'string', minLength: 1 },
        value: { type: 'string', minLength: 1 }
      },
      additionalProperties: false
    };
  }
}

module.exports = Metadata;