Function getNewNotesToUploadDom

app/src/sqlite/note.ts:285–313

(noteId?: NoteId)

		)
	},
	async getNewNotesToUploadDom(noteId?: NoteId) {
		const remoteNotes = await ky
			.selectFrom('remoteNote')
			.selectAll()
			.where('remoteId', 'is', null)
			.execute()
		const localIds = [...new Set(remoteNotes.map((t) => t.localId))]
		return await ky
			.selectFrom('note')
			.selectAll('note')
			.innerJoin('template', 'note.templateId', 'template.id')
			.select(templateSelection)
			.where('note.id', 'in', localIds)
			.$if(noteId != null, (db) => db.where('note.id', '=', toLDbId(noteId!)))
			.execute()
			.then((n) =>
				n.map((entity) => {
					const note = noteEntityToDomain(
						entity,
						remoteNotes.filter((rn) => rn.localId === entity.id),
					)
					if (objKeys(note.remotes).length === 0)
						C.toastImpossible(
							'Zero remotes - is something wrong with the SQL query?',
						)
					return [getTemplate(entity), note] as const
				}),
			)
	},
	async getEditedNotesToUpload(noteId?: NoteId, nook?: NookId) {
		const remoteTemplates = await ky
			.selectFrom('remoteTemplate')