(sourceId: number)
| 380 | "DELETE FROM shift_rules WHERE source_id = ?" |
| 381 | ); |
| 382 | stmt.run(sourceId); |
| 383 | ruleCache.delete(sourceId); |
| 384 | return true; |
| 385 | } |
| 386 | return false; |
| 387 | } catch (error) { |
| 388 | console.error(`[SHIFT] Error deleting rule:`, error); |
| 389 | return false; |
| 390 | } |
| 391 | } |
| 392 | |
| 393 | // Get all rules |
| 394 | function getAllShiftRules(): Array<{ sourceId: number; rule: ShiftRule }> { |
| 395 | try { |
| 396 | if (useLowdb && lowdb) { |
| 397 | // 从 lowdb 读取 |
| 398 | return Object.entries(lowdb.data.rules).map(([sourceId, rule]) => ({ |
| 399 | sourceId: Number(sourceId), |
| 400 | rule: rule as ShiftRule, |
| 401 | })); |
| 402 | } else if (sqliteDb) { |
| 403 | // 从 SQLite 读取 |
| 404 | const stmt = sqliteDb.prepare("SELECT * FROM shift_rules"); |
| 405 | const rows = stmt.all() as any[]; |
| 406 | |
| 407 | return rows.map((row) => ({ |
no test coverage detected