[feature] Clean up/uncache remote media (#407)

* Add whereNotEmptyAndNotNull

* Add GetRemoteOlderThanDays

* Add GetRemoteOlderThanDays

* Add PruneRemote to Manager interface

* Start implementing PruneRemote

* add new attachment + status to tests

* fix up and test GetRemoteOlderThan

* fix bad import

* PruneRemote: return number pruned

* add Cached column to mediaattachment

* update + test pruneRemote

* update mediaTest

* use Cached column

* upstep bun to latest version

* embed structs in mediaAttachment

* migrate mediaAttachment to new format

* don't default cached to true

* select only remote media

* update db dependencies

* step bun back to last working version

* update pruneRemote to use Cached field

* fix storage path of test attachments

* add recache logic to manager

* fix trimmed aspect ratio

* test prune and recache

* return errwithcode

* tidy up different paths for emoji vs attachment

* fix incorrect thumbnail type being stored

* expose TransportController to media processor

* implement tee-ing recached content

* add thoughts of dog to test fedi attachments

* test get remote files

* add comment on PruneRemote

* add postData cleanup to recache

* test thumbnail fetching

* add incredible diagram

* go mod tidy

* buffer pipes for recache streaming

* test for client stops reading after 1kb

* add media-remote-cache-days to config

* add cron package

* wrap logrus so it's available to cron

* start and stop cron jobs gracefully

1 files changed, 8 insertions, 50 deletions

diff --git a/vendor/modernc.org/libc/stdio/stdio_darwin_arm64.go b/vendor/modernc.org/libc/stdio/stdio_darwin_arm64.go
index d361e7a8e..76157f5fc 100644
--- a/vendor/modernc.org/libc/stdio/stdio_darwin_arm64.go
+++ b/vendor/modernc.org/libc/stdio/stdio_darwin_arm64.go
@@ -18,7 +18,6 @@ const (
 	BUFSIZ                                 = 1024
 	EOF                                    = -1
 	FILENAME_MAX                           = 1024
-	FIXINC_WRAP_STDIO_H_STDIO_STDARG_H     = 1
 	FOPEN_MAX                              = 20
 	L_ctermid                              = 1024
 	L_tmpnam                               = 1024
@@ -127,46 +126,7 @@ type X__uint128_t = struct {
 type X__builtin_va_list = uintptr /* <builtin>:46:14 */
 type X__float128 = float64        /* <builtin>:47:21 */
 
-//  DO NOT EDIT THIS FILE.
-//
-//     It has been auto-edited by fixincludes from:
-//
-// 	"/Library/Developer/CommandLineTools/SDKs/MacOSX12.sdk/usr/include/stdio.h"
-//
-//     This had to be done to correct non-standard usages in the
-//     original, manufacturer supplied header file.
-
-// Copyright (C) 1989-2021 Free Software Foundation, Inc.
-//
-// This file is part of GCC.
-//
-// GCC is free software; you can redistribute it and/or modify
-// it under the terms of the GNU General Public License as published by
-// the Free Software Foundation; either version 3, or (at your option)
-// any later version.
-//
-// GCC is distributed in the hope that it will be useful,
-// but WITHOUT ANY WARRANTY; without even the implied warranty of
-// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-// GNU General Public License for more details.
-//
-// Under Section 7 of GPL version 3, you are granted additional
-// permissions described in the GCC Runtime Library Exception, version
-// 3.1, as published by the Free Software Foundation.
-//
-// You should have received a copy of the GNU General Public License and
-// a copy of the GCC Runtime Library Exception along with this program;
-// see the files COPYING3 and COPYING.RUNTIME respectively.  If not, see
-// <http://www.gnu.org/licenses/>.
-
-// ISO C Standard:  7.15  Variable arguments  <stdarg.h>
-
-// Define __gnuc_va_list.
-
-type X__gnuc_va_list = X__builtin_va_list /* stdarg.h:40:27 */
-
-// Define the standard macros for the user,
-//    if this invocation was from the user program.
+var X__darwin_check_fd_set_overflow uintptr /* <builtin>:146:5: */
 
 // Copyright (c) 2000, 2005, 2007, 2009, 2010 Apple Inc. All rights reserved.
 //
@@ -358,6 +318,13 @@ type X__gnuc_va_list = X__builtin_va_list /* stdarg.h:40:27 */
 // in between its arguments.  __CONCAT can also concatenate double-quoted
 // strings produced by the __STRING macro, but this only works with ANSI C.
 
+// In non-ANSI C environments, new programs will want ANSI-only C keywords
+// deleted from the program and old programs will want them left alone.
+// When using a compiler other than gcc, programs using the ANSI C keywords
+// const, inline etc. as normal identifiers should define -DNO_ANSI_KEYWORDS.
+// When using "gcc -traditional", we assume that this is the intent; if
+// __GNUC__ is defined but __STDC__ is not, we leave the new keywords alone.
+
 // __pure2 can be used for functions that are only a function of their scalar
 // arguments (meaning they can't dereference pointers).
 //
@@ -797,15 +764,6 @@ type X__gnuc_va_list = X__builtin_va_list /* stdarg.h:40:27 */
 
 // Set up standard Mac OS X versions
 
-//  DO NOT EDIT THIS FILE.
-//
-//     It has been auto-edited by fixincludes from:
-//
-// 	"/Library/Developer/CommandLineTools/SDKs/MacOSX12.sdk/usr/include/AvailabilityInternal.h"
-//
-//     This had to be done to correct non-standard usages in the
-//     original, manufacturer supplied header file.
-
 // Copyright (c) 2007-2016 by Apple Inc.. All rights reserved.
 //
 // @APPLE_LICENSE_HEADER_START@