From ba7dabc6811dbc1548cbcb6a94b7a619d75753bd Mon Sep 17 00:00:00 2001 From: jwanek Date: Mon, 25 May 2020 21:50:43 +0100 Subject: added lambda timestamping --- database.py | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'database.py') diff --git a/database.py b/database.py index 26b8e43..3a0a15c 100755 --- a/database.py +++ b/database.py @@ -92,4 +92,10 @@ class Database: links = self.get_lambda(user)[1] return permalink in links or permalink.replace("https://www.reddit.com", "") in links - + def get_all_lambdas(self): + self.cursor.execute("SELECT lambdas.lambdaID, lambdas.permalink, users.user_name, lambdas.created FROM lambdas INNER JOIN users ON lambdas.userID = users.userID;") + return self.cursor.fetchall() + + def add_date_to_permalink(self, permalink, date): + self.cursor.execute("UPDATE lambdas SET created = ? WHERE permalink = ?;", (date, permalink)) + self.connection.commit() \ No newline at end of file -- cgit v1.2.3