Open-source and local-first Slack and Notion alternative that puts you in control of your data
TypeScript chatchat-applicationcrdteditorelectronknowledge-baselocal-firstnotionnotion-alternativerealtime-collaborationself-hostedslacksqliteteam-collaborationwikiyjs
import {
SynchronizerOutputMessage,
SyncCollaborationsInput,
SyncCollaborationData,
} from '@colanode/core';
import { database } from '@colanode/server/data/database';
import { SelectCollaboration } from '@colanode/server/data/schema';
import { createLogger } from '@colanode/server/lib/logger';
import { BaseSynchronizer } from '@colanode/server/synchronizers/base';
import { Event } from '@colanode/server/types/events';
const logger = createLogger('collaboration-synchronizer');
export class CollaborationSynchronizer extends BaseSynchronizer<SyncCollaborationsInput> {
public async fetchData(): Promise<SynchronizerOutputMessage<SyncCollaborationsInput> | null> {
const collaborations = await this.fetchCollaborations();
if (collaborations.length === 0) {
return null;
}
return this.buildMessage(collaborations);
}
public async fetchDataFromEvent(
event: Event
): Promise<SynchronizerOutputMessage<SyncCollaborationsInput> | null> {
if (!this.shouldFetch(event)) {
return null;
}
const collaborations = await this.fetchCollaborations();
if (collaborations.length === 0) {
return null;
}
return this.buildMessage(collaborations);
}
private async fetchCollaborations() {
if (this.status === 'fetching') {
return [];
}
this.status = 'fetching';
try {
const collaborations = await database
.selectFrom('collaborations')
.selectAll()
.where('collaborator_id', '=', this.user.userId)
.where('revision', '>', this.cursor)
.orderBy('revision', 'asc')
.limit(100)
.execute();
return collaborations;
} catch (error) {
logger.error(error, 'Error fetching collaborations for sync');
} finally {
this.status = 'pending';
}
return [];
}
private buildMessage(
unsyncedCollaborations: SelectCollaboration[]
): SynchronizerOutputMessage<SyncCollaborationsInput> {
const items: SyncCollaborationData[] = unsyncedCollaborations.map(
(collaboration) => ({
nodeId: collaboration.node_id,
workspaceId: collaboration.workspace_id,
collaboratorId: collaboration.collaborator_id,
role: collaboration.role,
createdBy: collaboration.created_by,
updatedBy: collaboration.updated_by,
createdAt: collaboration.created_at.toISOString(),
updatedAt: collaboration.updated_at?.toISOString() ?? null,
deletedAt: collaboration.deleted_at?.toISOString() ?? null,
deletedBy: collaboration.deleted_by ?? null,
revision: collaboration.revision.toString(),
})
);
return {
type: 'synchronizer.output',
userId: this.user.userId,
id: this.id,
items: items.map((item) => ({
cursor: item.revision,
data: item,
})),
};
}
private shouldFetch(event: Event) {
if (
event.type === 'collaboration.created' &&
event.workspaceId === this.user.workspaceId &&
event.collaboratorId === this.user.userId
) {
return true;
}
if (
event.type === 'collaboration.updated' &&
event.workspaceId === this.user.workspaceId &&
event.collaboratorId === this.user.userId
) {
return true;
}
return false;
}
}