procedure to load events in TideSQL table

load_events.sql

DELIMITER // 

CREATE PROCEDURE load_events(IN loops INT) 
BEGIN 
    DECLARE i INT DEFAULT 0; 
    
    WHILE i < loops DO 
        INSERT INTO events(ts, device_id, metric, value, payload) 
        VALUES ( 
            NOW(6) - INTERVAL FLOOR(RAND() * 86400) SECOND,
            FLOOR(1 + RAND() * 1000), 
            ELT(FLOOR(1 + RAND() * 4), 'temperature', 'humidity', 'pressure', 'voltage'), 
            RAND() * 100, 
            JSON_OBJECT('source', 'generator', 'seq', i) 
        ); 
        
        SET i = i + 1; 
    END WHILE; 
END// 

DELIMITER ;