| | |
|---|
| | | unit_id TEXT NOT NULL, |
|---|
| | | description TEXT NOT NULL, |
|---|
| | | start_time DATETIME NOT NULL, |
|---|
| | | end_time DATETIME NOT NULL, |
|---|
| | | end_time DATETIME, |
|---|
| | | FOREIGN KEY (device_id) REFERENCES devices(device_id), |
|---|
| | | FOREIGN KEY (unit_id) REFERENCES units(unit_id) |
|---|
| | | ) |
|---|
| | |
|---|
| | | |
|---|
| | | // 插入单元数据 |
|---|
| | | for (int i = 1; i <= 3; ++i) { |
|---|
| | | for (int j = 1; j <= 3; ++j) { |
|---|
| | | for (int j = 0; j <= 3; ++j) { |
|---|
| | | int unitId = j; |
|---|
| | | std::string deviceId = std::to_string(i); |
|---|
| | | std::string unitName = "Unit" + std::to_string(j); |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | /* |
|---|
| | | // 初始化随机数生成器 |
|---|
| | | std::random_device rd; |
|---|
| | | std::mt19937 gen(rd()); |
|---|
| | |
|---|
| | | std::cerr << "Failed to insert alarm data." << std::endl; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | */ |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 添加报警信息 |
|---|
