Simple file list templateHEADmaster

TODO: it should provide a link to file, instead of printing the path.

1 files changed, 5 insertions, 0 deletions

diff --git a/database.py b/database.py
index 5f14801..29b687a 100644
--- a/database.py
+++ b/database.py
@@ -21,6 +21,11 @@ class DatabaseConnection(object):
 		with closing(self.conn.cursor(MySQLdb.cursors.DictCursor)) as c:
 			c.execute("select * from `groups`")
 			return c.fetchall()
+	
+	def get_files(self):
+		with closing(self.conn.cursor(MySQLdb.cursors.DictCursor)) as c:
+			c.execute("select `files`.* from `files` inner join `groups` on `files`.`group_id` = `groups`.`id` order by `groups`.`date` desc")
+			return c.fetchall()
 
 def get_connection(user, passwd, db):
 	conn = MySQLdb.connect(user=user, passwd=passwd, db=db)