MQTTvue/mqtt-vue-dashboard/server/dist/models/sensorData.d.ts

export interface SensorData {
    id?: number;
    device_id: string;
    topic: string;
    data_type: string;
    value: string;
    timestamp: Date;
    created_at?: Date;
}
export declare class SensorDataModel {
    static getAll(limit?: number, offset?: number): Promise<SensorData[]>;
    static getByDeviceId(deviceId: string, limit?: number): Promise<SensorData[]>;
    static getByDeviceIdAndType(deviceId: string, dataType: string, limit?: number): Promise<SensorData[]>;
    static getByType(dataType: string, limit?: number): Promise<SensorData[]>;
    static getByTimeRange(deviceId: string, dataType: string, hours?: number): Promise<SensorData[]>;
    static getLatestByDevice(deviceId: string): Promise<SensorData[]>;
    static getCount(): Promise<number>;
    static getCountByDeviceId(deviceId: string): Promise<number>;
    static getCountByType(dataType: string): Promise<number>;
    static insert(data: Omit<SensorData, 'id' | 'created_at'>): Promise<SensorData>;
    static updateLatestByDeviceAndType(deviceId: string, dataType: string, value: string): Promise<boolean>;
    static upsertByDeviceAndType(deviceId: string, dataType: string, value: string, topic?: string): Promise<void>;
}
//# sourceMappingURL=sensorData.d.ts.map