diff options
| -rw-r--r-- | internal/repository/media.go | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/internal/repository/media.go b/internal/repository/media.go index f57c839..a7a9553 100644 --- a/internal/repository/media.go +++ b/internal/repository/media.go @@ -254,10 +254,12 @@ func (s *SQLite) ListMedia(ctx context.Context, filter MediaFilter) ([]model.Med } if filter.Limit > 0 { - query += fmt.Sprintf(" LIMIT %d", filter.Limit) + query += " LIMIT ?" + args = append(args, filter.Limit) } if filter.Offset > 0 { - query += fmt.Sprintf(" OFFSET %d", filter.Offset) + query += " OFFSET ?" + args = append(args, filter.Offset) } rows, err := s.db.QueryContext(ctx, query, args...) |