Function uploadableNoteMedia

app/src/sqlite/util.ts:311–355

(
	torn: boolean,
	noteId: TId = undefined as TId,
	count: TCount = undefined as TCount,
)

}

export async function uploadableNoteMedia<
	TId extends NoteId | undefined = undefined,
	TCount extends true | undefined = undefined,
>(
	torn: boolean,
	noteId: TId = undefined as TId,
	count: TCount = undefined as TCount,
) {
	const r = await ky
		.selectFrom('remoteMedia')
		.innerJoin('media', 'remoteMedia.localMediaId', 'media.id')
		.innerJoin('noteBase', 'remoteMedia.localEntityId', 'noteBase.id')
		.leftJoin('remoteNote', 'remoteNote.localId', 'noteBase.id')
		.$if(count === true, (qb) =>
			qb.select(
				ky.fn.count<SqliteCount>('remoteMedia.localEntityId').as('count'),
			),
		)
		.$if(count === undefined, (qb) =>
			qb.select([
				'remoteMedia.localMediaId',
				'media.data',
				'remoteMedia.localEntityId',
				'remoteMedia.remoteMediaId',
				'remoteNote.remoteId',
			]),
		)
		.$if(noteId != null, (qb) => qb.where('noteBase.id', '=', toLDbId(noteId!)))
		.$if(torn, (qb) => qb.where('remoteMedia.remoteMediaId', 'is not', null))
		.where((eb) =>
			eb.or([
				eb('remoteMedia.uploadDate', 'is', null),
				eb('media.edited', '>', eb.ref('remoteMedia.uploadDate')),
			]),
		)
		.execute()
	type SqlRow = (typeof r)[0]
	type R = TCount extends true
		? number
		: Array<Rasterize<Required<Omit<SqlRow, 'count'>>>>
	if (count) {
		return r[0]!.count as R
	}
	return r as R
}

export async function uploadableTemplateMedia<
	TId extends TemplateId | undefined = undefined,