Function makeNoteUploadable

app/src/sqlite/note.ts:391–443

(
		remoteNote: Override<
			InsertObject<DB, 'remoteNote'>,
			{ localId: RemoteNote['localId'] }
		> & { note: Note },
	)

	},
	getMediaToUpload,
	async makeNoteUploadable(
		remoteNote: Override<
			InsertObject<DB, 'remoteNote'>,
			{ localId: RemoteNote['localId'] }
		> & { note: Note },
	) {
		const { hashByLocal } = await remotifyNote(
			domainToCreateRemote(remoteNote.note, [
				/* this doesn't need any real values */
			]),
		)
		// @ts-expect-error kysley doesn't use note - it's only used by the above
		delete remoteNote.note
		await tx(async (db) => {
			await db
				.insertInto('remoteNote')
				.values(remoteNote)
				.onConflict((db) => db.doNothing())
				.execute()
			const srcs = new Set(hashByLocal.keys())
			const mediaBinaries = await db
				.selectFrom('media')
				.select(['id', 'data'])
				.where('id', 'in', Array.from(srcs))
				.execute()
			if (mediaBinaries.length !== srcs.size)
				C.toastFatal("You're missing a media.") // medTODO better error message
			// await db // F19F2731-BA29-406F-8F35-4E399CB40242
			// 	.deleteFrom('remoteMedia')
			// 	.where('localEntityId', '=', remoteNote.localId)
			// 	.where('localMediaId', 'in', Array.from(srcs))
			// 	.execute()
			if (hashByLocal.size !== 0) {
				await db
					.insertInto('remoteMedia')
					.values(
						Array.from(hashByLocal).map(
							([localMediaId]) =>
								({
									localEntityId: remoteNote.localId,
									localMediaId,
								}) satisfies InsertObject<DB, 'remoteMedia'>,
						),
					)
					.onConflict((db) =>
						db.doUpdateSet({
							localMediaId: (x) => x.ref('excluded.localMediaId'),
						}),
					)
					.execute()
			}
		})
	},
	async makeNoteNotUploadable(noteId: NoteId, nook: NookId) {
		const noteDbId = toLDbId(noteId)
		await tx(async (db) => {