diff options
Diffstat (limited to 'database.py')
| -rwxr-xr-x | database.py | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/database.py b/database.py index 272e39e..cf51922 100755 --- a/database.py +++ b/database.py @@ -55,6 +55,11 @@ class Database: cursor.execute("SELECT alt, url FROM images WHERE pfp_img = 1;") return cursor.fetchall() + def get_sidebar_images(self): + with self.__connection.cursor() as cursor: + cursor.execute("SELECT alt, url FROM images WHERE sidebar_image = 1;") + return cursor.fetchall() + def get_header_articles(self): with self.__connection.cursor() as cursor: cursor.execute("SELECT articleName, link FROM headerArticles;") @@ -350,5 +355,7 @@ def request_recent_commits(since = datetime.datetime.now() - datetime.timedelta( if __name__ == "__main__": + import app with Database() as db: - print(db.fetch_diary()) + print(app.get_sidebar_img(db)) + # print(db.get_sidebar_images()) |