Method getById

packages/db/src/services/event.service.ts:1030–1077

({
    projectId,
    id,
    createdAt,
  }: {
    projectId: string;
    id: string;
    createdAt?: Date;
  })

  }

  async getById({
    projectId,
    id,
    createdAt,
  }: {
    projectId: string;
    id: string;
    createdAt?: Date;
  }) {
    const [event, metas] = await Promise.all([
      clix(this.client)
        .select<IClickhouseEvent>(['*'])
        .from('events')
        .where('project_id', '=', projectId)
        .when(!!createdAt, (q) => {
          if (createdAt) {
            q.where('created_at', 'BETWEEN', [
              new Date(createdAt.getTime() - 1000),
              new Date(createdAt.getTime() + 1000),
            ]);
          }
        })
        .where('id', '=', id)
        .limit(1)
        .execute()
        .then((res) => {
          if (!res[0]) {
            return null;
          }

          return transformEvent(res[0]);
        }),
      getEventMetasCached(projectId),
    ]);

    if (event?.profileId) {
      const profile = await getProfileById(event?.profileId, projectId);
      if (profile) {
        event.profile = profile;
      }
    }

    if (event) {
      event.meta = metas.find((meta) => meta.name === event.name);
    }

    return event;
  }

  async getList({
    projectId,