diff options
Diffstat (limited to 'database.py')
-rwxr-xr-x | database.py | 8 |
1 files changed, 7 insertions, 1 deletions
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 |