MQTTvue/mqtt-vue-dashboard/server/dist/models/firmware.js

"use strict";
Object.defineProperty(exports, "__esModule", { value: true });
exports.FirmwareFileModel = void 0;
const database_1 = require("../config/database");
class FirmwareFileModel {
    static async create(firmwareData) {
        const query = `
      INSERT INTO firmware_files (version, filename, filepath, filesize, md5sum, description, status, created_by)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?)
    `;
        const values = [
            firmwareData.version,
            firmwareData.filename,
            firmwareData.filepath,
            firmwareData.filesize,
            firmwareData.md5sum,
            firmwareData.description || null,
            firmwareData.status || 'active',
            firmwareData.created_by || null
        ];
        const result = await (0, database_1.executeQuery)(query, values);
        const insertId = result.insertId;
        return this.getById(insertId);
    }
    static async getById(id) {
        const query = 'SELECT * FROM firmware_files WHERE id = ?';
        const firmwareFiles = await (0, database_1.executeQuery)(query, [id]);
        return firmwareFiles.length > 0 ? firmwareFiles[0] : null;
    }
    static async getAll() {
        const query = 'SELECT * FROM firmware_files ORDER BY version DESC';
        return await (0, database_1.executeQuery)(query);
    }
    static async getByStatus(status) {
        const query = 'SELECT * FROM firmware_files WHERE status = ? ORDER BY version DESC';
        return await (0, database_1.executeQuery)(query, [status]);
    }
    static async updateStatus(id, status) {
        const query = 'UPDATE firmware_files SET status = ? WHERE id = ?';
        const result = await (0, database_1.executeQuery)(query, [status, id]);
        return result.affectedRows > 0;
    }
    static async delete(id) {
        const query = 'DELETE FROM firmware_files WHERE id = ?';
        const result = await (0, database_1.executeQuery)(query, [id]);
        return result.affectedRows > 0;
    }
    static async createTable() {
        const query = `
      CREATE TABLE IF NOT EXISTS firmware_files (
        id INT AUTO_INCREMENT PRIMARY KEY,
        version VARCHAR(50) NOT NULL UNIQUE,
        filename VARCHAR(255) NOT NULL,
        filepath VARCHAR(255) NOT NULL,
        filesize BIGINT NOT NULL,
        md5sum VARCHAR(32) NOT NULL,
        description TEXT,
        status ENUM('active', 'inactive') DEFAULT 'active',
        created_by VARCHAR(50),
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        INDEX idx_version (version),
        INDEX idx_status (status)
      )
    `;
        await (0, database_1.executeQuery)(query);
    }
}
exports.FirmwareFileModel = FirmwareFileModel;
//# sourceMappingURL=firmware.js.map