- def get_history(self, limit=None, offset=None, builder=None, user=None):
- query = "SELECT * FROM builders_history"
- args = []
-
- conditions = []
-
- if builder:
- conditions.append("builder_id = %s")
- args.append(builder.id)
-
- if user:
- conditions.append("user_id = %s")
- args.append(user.id)
-
- if conditions:
- query += " WHERE %s" % " AND ".join(conditions)
-
- query += " ORDER BY time DESC"
-
- if limit:
- if offset:
- query += " LIMIT %s,%s"
- args += [offset, limit,]
- else:
- query += " LIMIT %s"
- args += [limit,]
-
- entries = []
- for entry in self.db.query(query, *args):
- entry = logs.BuilderLogEntry(self.pakfire, entry)
- entries.append(entry)
-
- return entries
-