hourus 0.1.0

tui time tracking tool
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145

use crate::entry::{Entry, Interval};
use crate::error::StorageError;
use anyhow::{Result, anyhow};
use chrono::{DateTime, TimeDelta, Utc};
use rusqlite::{Connection, OptionalExtension, Row, params, types::Value};
use std::path::Path;

use crate::repository::Repository;

pub struct SqliteRepository {
    conn: Connection,
}

impl SqliteRepository {
    pub fn new<P>(path: P) -> Result<Self>
    where
        P: AsRef<Path>,
    {
        let conn = Connection::open(path)?;
        let repo = SqliteRepository { conn };
        repo.migrate()?;
        Ok(repo)
    }

    fn migrate(&self) -> Result<()> {
        if self.conn.table_exists(None, "session")? {
            return Ok(());
        }

        self.conn.execute(
            "CREATE TABLE IF NOT EXISTS session (id integer primary key, desc text not null, start_ts integer not null, end_ts integer)",
            (),
        )?;

        self.conn.execute(
            "CREATE UNIQUE INDEX if not exists idx_session_start_ts on session (start_ts)",
            (),
        )?;

        Ok(())
    }

    fn last_open(&self) -> Result<Option<Entry>> {
        let query = "SELECT desc, start_ts, end_ts FROM session WHERE end_ts IS NULL ORDER BY start_ts DESC LIMIT 1";
        Ok(self
            .conn
            .query_row(query, (), SqliteRepository::map_row_to_entry)
            .optional()?)
    }

    fn map_row_to_entry(row: &Row) -> rusqlite::Result<Entry> {
        let start_ts: i64 = row.get(1)?;
        let end_ts: Option<i64> = row.get(2)?;
        Ok(Entry {
            desc: row.get(0)?,
            interval: Interval {
                start: DateTime::from_timestamp(start_ts, 0).unwrap_or_default(),
                end: end_ts.and_then(|ts| DateTime::from_timestamp(ts, 0)),
            },
        })
    }
}

impl Repository for SqliteRepository {
    fn list(&self, opts: super::QueryOpts) -> Result<Vec<Entry>, StorageError> {
        let mut query = String::from("SELECT desc, start_ts, end_ts FROM session WHERE 1=1");
        let mut params: Vec<Value> = Vec::new();

        if let Some(from) = opts.from {
            query.push_str(" AND start_ts >= ?");
            params.push(Value::Integer(from.timestamp()));
        }

        if let Some(to) = opts.to {
            query.push_str(" AND start_ts <= ?");
            params.push(Value::Integer(to.timestamp()));
        }

        query.push_str(" ORDER BY start_ts ASC");

        let limit = opts.limit.map(|l| l as i64);
        let offset = opts.offset.map(|o| o as i64);

        if let Some(l) = limit {
            query.push_str(" LIMIT ?");
            params.push(Value::Integer(l));
        } else if opts.offset.is_some() {
            query.push_str(" LIMIT -1");
        }

        if let Some(o) = offset {
            query.push_str(" OFFSET ?");
            params.push(Value::Integer(o));
        }

        let mut stmt = self.conn.prepare(&query)?;
        let entries: Vec<Entry> = stmt
            .query_map(
                rusqlite::params_from_iter(params),
                SqliteRepository::map_row_to_entry,
            )?
            .collect::<Result<_, _>>()?;

        Ok(entries)
    }

    fn start_session(&mut self, desc: &str, dt: DateTime<Utc>) -> Result<()> {
        // Auto-close any open session one second before the new start.
        if let Some(Entry {
            interval: Interval { start, end: None },
            ..
        }) = self.last_open()?
        {
            let end_ts = (dt - TimeDelta::seconds(1)).timestamp();
            self.conn.execute(
                "UPDATE session SET end_ts = ? WHERE start_ts = ? AND end_ts IS NULL",
                params![end_ts, start.timestamp()],
            )?;
        }

        self.conn.execute(
            "INSERT INTO session (desc, start_ts) VALUES (?, ?)",
            params![desc, dt.timestamp()],
        )?;

        Ok(())
    }

    fn end_session(&mut self, dt: DateTime<Utc>) -> Result<()> {
        let open = self
            .last_open()?
            .ok_or_else(|| anyhow!("tried to end but nothing was started"))?;

        self.conn.execute(
            "UPDATE session SET end_ts = ? WHERE start_ts = ? AND end_ts IS NULL",
            params![dt.timestamp(), open.interval.start.timestamp()],
        )?;

        Ok(())
    }

    fn rename_current(&mut self, new_desc: &str) -> Result<()> {
        todo!()
    }
}