Method load_todos

crates/devsql/src/engine.rs:408–454

(&mut self)

    }

    fn load_todos(&mut self) -> Result<()> {
        self.conn.execute(
            "CREATE TABLE IF NOT EXISTS todos (
                rowid INTEGER PRIMARY KEY,
                content TEXT,
                status TEXT
            )",
            [],
        )?;

        let todos_dir = self.claude_data_dir.join("todos");
        if !todos_dir.is_dir() {
            return Ok(());
        }

        let entries = match std::fs::read_dir(&todos_dir) {
            Ok(e) => e,
            Err(_) => return Ok(()),
        };

        for entry in entries.filter_map(|e| e.ok()) {
            let path = entry.path();
            if path.extension().and_then(|e| e.to_str()) != Some("json") {
                continue;
            }

            let content = match std::fs::read_to_string(&path) {
                Ok(c) => c,
                Err(_) => continue,
            };

            // Try parsing as a JSON array of todo items
            if let Ok(items) = serde_json::from_str::<Vec<Value>>(&content) {
                for item in &items {
                    let todo_content = item.get("content").and_then(|v| v.as_str()).unwrap_or("");
                    let status = item.get("status").and_then(|v| v.as_str()).unwrap_or("");

                    self.conn.execute(
                        "INSERT INTO todos (content, status) VALUES (?1, ?2)",
                        params![todo_content, status],
                    )?;
                }
            }
        }

        Ok(())
    }

    fn load_commits(&mut self) -> Result<()> {
        self.conn.execute(