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 { Kysely } from 'kysely';
import ms from 'ms';
import {
EmojiDatabaseSchema,
IconDatabaseSchema,
} from '@colanode/client/databases';
import { eventBus, mapAvatar } from '@colanode/client/lib';
import { AppService } from '@colanode/client/services/app-service';
import { Avatar } from '@colanode/client/types/avatars';
export class AssetService {
private readonly app: AppService;
public readonly emojis: Kysely<EmojiDatabaseSchema>;
public readonly icons: Kysely<IconDatabaseSchema>;
constructor(app: AppService) {
this.app = app;
this.emojis = this.app.kysely.build<EmojiDatabaseSchema>({
path: this.app.path.emojisDatabase,
readonly: true,
});
this.icons = this.app.kysely.build<IconDatabaseSchema>({
path: this.app.path.iconsDatabase,
readonly: true,
});
}
public async getAvatar(
accountId: string,
avatar: string,
autoDownload?: boolean
): Promise<Avatar | null> {
const updatedAvatar = await this.app.database
.updateTable('avatars')
.returningAll()
.set({
opened_at: new Date().toISOString(),
})
.where('id', '=', avatar)
.executeTakeFirst();
if (updatedAvatar) {
const url = await this.app.fs.url(updatedAvatar.path);
if (!url) {
await this.app.fs.delete(updatedAvatar.path);
await this.app.database
.deleteFrom('avatars')
.where('id', '=', avatar)
.execute();
return null;
}
return mapAvatar(updatedAvatar, url);
}
if (autoDownload) {
await this.app.jobs.addJob(
{
type: 'avatar.download',
accountId,
avatar,
},
{
deduplication: {
key: `avatar.download.${avatar}`,
},
retries: 5,
}
);
}
return null;
}
public async downloadAvatar(
accountId: string,
avatar: string
): Promise<boolean | null> {
const account = this.app.getAccount(accountId);
if (!account) {
return null;
}
if (!account.server.isAvailable) {
return null;
}
const response = await account.client.get<ArrayBuffer>(
`v1/avatars/${avatar}`
);
if (response.status !== 200) {
return false;
}
const avatarPath = this.app.path.avatar(avatar);
const avatarBytes = new Uint8Array(await response.arrayBuffer());
await this.app.fs.writeFile(avatarPath, avatarBytes);
const createdAvatar = await this.app.database
.insertInto('avatars')
.returningAll()
.values({
id: avatar,
path: avatarPath,
size: avatarBytes.length,
created_at: new Date().toISOString(),
opened_at: new Date().toISOString(),
})
.onConflict((oc) =>
oc.columns(['id']).doUpdateSet({
opened_at: new Date().toISOString(),
})
)
.executeTakeFirst();
if (!createdAvatar) {
return false;
}
const url = await this.app.fs.url(avatarPath);
if (!url) {
await this.app.fs.delete(avatarPath);
await this.app.database
.deleteFrom('avatars')
.where('id', '=', avatar)
.execute();
return false;
}
eventBus.publish({
type: 'avatar.created',
avatar: mapAvatar(createdAvatar, url),
});
return true;
}
public async cleanupAvatars(): Promise<void> {
const sevenDaysAgo = new Date(Date.now() - ms('7 days')).toISOString();
const unopenedAvatars = await this.app.database
.deleteFrom('avatars')
.where('opened_at', '<', sevenDaysAgo)
.returningAll()
.execute();
for (const avatar of unopenedAvatars) {
await this.app.fs.delete(avatar.path);
eventBus.publish({
type: 'avatar.deleted',
avatar: mapAvatar(avatar, ''),
});
}
}
}