Function updateRemotes

app/src/sqlite/util.ts:232–309

(
	table: 'remoteNote' | 'remoteTemplate',
	isCreate: boolean,
	remoteIdByLocal: Map<
		readonly [NoteId, RemoteTemplateId] | readonly [TemplateId, NookId],
		readonly [RemoteNoteId | RemoteTemplateId, Array<[Base64, RemoteMediaId]>]
	>,
)

	)
}
export async function updateRemotes(
	table: 'remoteNote' | 'remoteTemplate',
	isCreate: boolean,
	remoteIdByLocal: Map<
		readonly [NoteId, RemoteTemplateId] | readonly [TemplateId, NookId],
		readonly [RemoteNoteId | RemoteTemplateId, Array<[Base64, RemoteMediaId]>]
	>,
) {
	const now = C.getDate().getTime()
	await tx(async (db) => {
		for (const [
			[entityId, nOrT],
			[remoteId, hashAndRemoteMediaIds],
		] of remoteIdByLocal) {
			const entityDbId = toLDbId(entityId)
			const r = await db
				.updateTable(table)
				.$if(table === 'remoteTemplate' && nOrT !== nullNook, (eb) =>
					eb
						.set({ remoteId: toLDbId(remoteId), uploadDate: now })
						.where('nook', '=', nOrT as NookId),
				)
				.$if(table === 'remoteTemplate' && nOrT === nullNook, (eb) =>
					eb
						.set({ uploadDate: now }) //
						.where('remoteId', '=', toLDbId(remoteId)),
				)
				.$if(table === 'remoteNote', (eb) =>
					eb
						.set({
							remoteId: isCreate ? toLDbId(remoteId) : undefined,
							uploadDate: now,
						})
						.where((eb) =>
							eb.exists(
								eb
									.selectFrom('remoteNote')
									.select(sql`1`.as('_'))
									.innerJoin('note', 'note.id', 'remoteNote.localId')
									.innerJoin(
										'remoteTemplate',
										'remoteTemplate.localId',
										'note.templateId',
									)
									.where(
										'remoteTemplate.remoteId',
										'=',
										toLDbId(nOrT as RemoteTemplateId),
									)
									.where('remoteNote.localId', '=', entityDbId),
							),
						),
				)
				.where('localId', '=', entityDbId)
				.returningAll()
				.execute()
			for (const [hash, remoteMediaId] of hashAndRemoteMediaIds) {
				await db