photochamber-webserver/model/mediaItemTag.js

const DatabaseModel = require("./DatabaseModel.js").DatabaseModel;

function MediaFileTagModel(md5sum, tag) {
    DatabaseModel.call(this);
    this.md5sum = md5sum || "";
    this.tag = tag || "";
}

MediaFileTagModel.prototype = Object.create(DatabaseModel.prototype);

MediaFileTagModel.prototype.getTableName = function() {
    return "mediaTag";
}

MediaFileTagModel.prototype.createOrUpdateBase = async function(dbHelper) {
    await dbHelper.runSql(`CREATE TABLE IF NOT EXISTS 'mediaTag' (
        md5sum STRING NOT NULL,
        tag varchar(32) NOT NULL,
        PRIMARY KEY (md5sum, tag))`);
}

MediaFileTagModel.prototype.describe = function() {
    return {
        "md5sum": this.md5sum,
        "tag": this.tag
    };
}

MediaFileTagModel.prototype.versionColumn = function() { return ""; }

MediaFileTagModel.prototype.fromDb = function(dbObj) {
    this.md5sum = dbObj["md5sum"];
    this.tag = dbObj["tag"];
}

module.exports.MediaFileTagModel = MediaFileTagModel;