diff options
Diffstat (limited to 'src/db')
| -rw-r--r-- | src/db/balancing.rs | 19 |
1 files changed, 9 insertions, 10 deletions
diff --git a/src/db/balancing.rs b/src/db/balancing.rs index 1641b97..8914eef 100644 --- a/src/db/balancing.rs +++ b/src/db/balancing.rs @@ -12,15 +12,6 @@ fn row_to_balancing(row: &Row) -> Result<Balancing, rusqlite::Error> { }) } -fn row_to_table_row(row: &Row) -> Result<TableRow, rusqlite::Error> { - Ok(TableRow { - id: row.get(0)?, - source: row.get(1)?, - destination: row.get(2)?, - amount: row.get(3)?, - }) -} - pub async fn count(conn: &Connection) -> i64 { let query = r#" SELECT COUNT(*) @@ -49,6 +40,7 @@ pub async fn list_for_table(conn: &Connection, page: i64, per_page: i64) -> Vec< let query = r#" SELECT balancing.id, + strftime('%d/%m/%Y', balancing.created_at), users_src.name, users_dest.name, balancing.amount @@ -67,7 +59,14 @@ pub async fn list_for_table(conn: &Connection, page: i64, per_page: i64) -> Vec< stmt.query_map( named_params![":limit": per_page, ":offset": (page - 1) * per_page], - row_to_table_row + |row: &Row| + Ok(TableRow { + id: row.get(0)?, + date: row.get(1)?, + source: row.get(2)?, + destination: row.get(3)?, + amount: row.get(4)?, + }) )? .collect::<Result<Vec<TableRow>, _>>() }) |