main: If repo was updated, save new `updated_at` value

If the repo was updated since we last cached it, update the `updated_at`
column to the new value so we know that we fetched the latest.

1 files changed, 15 insertions, 1 deletions

diff --git a/src/database.rs b/src/database.rs
index e735df9..2a53f0b 100644
--- a/src/database.rs
+++ b/src/database.rs
@@ -139,7 +139,21 @@ impl Db {
         is_updated
     }
 
-    pub fn repo_update(repo: &Repo) -> Result<(), Error> {
+    pub async fn repo_update(&mut self, repo: &Repo) -> Result<(), Error> {
+        let mut tx = self.connection.begin().await?;
+
+        sqlx::query(r#"
+            UPDATE repositories
+            SET updated_at = ?
+            WHERE id = ?
+        "#)
+            .bind(&repo.updated_at)
+            .bind(repo.id)
+            .execute(&mut tx)
+            .await?;
+
+        tx.commit().await?;
+
         Ok(())
     }
 }