Skip to content

A local-first personal finance app

13.0 KB
Raw Blame
import request from 'supertest';
import { v4 as uuidv4 } from 'uuid';

import { getAccountDb } from './account-db';
import { handlers as app } from './app-admin';

const ADMIN_ROLE = 'ADMIN';
const BASIC_ROLE = 'BASIC';

// Create user helper function
const createUser = (userId, userName, role, owner = 0, enabled = 1) => {
  getAccountDb().mutate(
    'INSERT INTO users (id, user_name, display_name, enabled, owner, role) VALUES (?, ?, ?, ?, ?, ?)',
    [userId, userName, `${userName} display`, enabled, owner, role],
  );
};

const deleteUser = userId => {
  getAccountDb().mutate('DELETE FROM user_access WHERE user_id = ?', [userId]);
  getAccountDb().mutate('DELETE FROM users WHERE id = ?', [userId]);
};

const createSession = (userId, sessionToken) => {
  getAccountDb().mutate(
    'INSERT INTO sessions (token, user_id, expires_at) VALUES (?, ?, ?)',
    [sessionToken, userId, Date.now() + 1000 * 60 * 60], // Expire in 1 hour
  );
};

const generateSessionToken = () => `token-${uuidv4()}`;

describe('disabled-user session revocation', () => {
  let adminUserId, adminSessionToken;
  let targetUserId, targetSessionToken;

  beforeEach(() => {
    adminUserId = uuidv4();
    targetUserId = uuidv4();
    adminSessionToken = generateSessionToken();
    targetSessionToken = generateSessionToken();

    createUser(adminUserId, 'adminForRevocation', ADMIN_ROLE);
    createSession(adminUserId, adminSessionToken);
    createUser(targetUserId, 'targetForRevocation', BASIC_ROLE);
    createSession(targetUserId, targetSessionToken);
  });

  afterEach(() => {
    deleteUser(adminUserId);
    deleteUser(targetUserId);
  });

  it('should return 401 when the token belongs to a disabled user', async () => {
    getAccountDb().mutate('UPDATE users SET enabled = 0 WHERE id = ?', [
      targetUserId,
    ]);

    const res = await request(app)
      .get('/users')
      .set('x-actual-token', targetSessionToken);

    expect(res.statusCode).toEqual(401);
    expect(res.body).toHaveProperty('status', 'error');
    expect(res.body).toHaveProperty('reason', 'unauthorized');
  });

  it('should remove existing sessions when an admin disables the user', async () => {
    const res = await request(app)
      .patch('/users')
      .send({
        id: targetUserId,
        userName: 'targetForRevocation',
        displayName: 'Target',
        enabled: false,
        role: BASIC_ROLE,
      })
      .set('x-actual-token', adminSessionToken);

    expect(res.statusCode).toEqual(200);

    const session = getAccountDb().first(
      'SELECT token FROM sessions WHERE token = ?',
      [targetSessionToken],
    );
    expect(session).toBeNull();
  });

  it('should remove existing sessions when an admin deletes the user', async () => {
    const res = await request(app)
      .delete('/users')
      .send({ ids: [targetUserId] })
      .set('x-actual-token', adminSessionToken);

    expect(res.statusCode).toEqual(200);

    const session = getAccountDb().first(
      'SELECT token FROM sessions WHERE token = ?',
      [targetSessionToken],
    );
    expect(session).toBeNull();
  });
});

describe('/admin', () => {
  describe('/owner-created', () => {
    it('should return 200 and true if an owner user is created', async () => {
      const sessionToken = generateSessionToken();
      const adminId = uuidv4();
      createUser(adminId, 'admin', ADMIN_ROLE, 1);
      createSession(adminId, sessionToken);

      const res = await request(app)
        .get('/owner-created')
        .set('x-actual-token', sessionToken);

      expect(res.statusCode).toEqual(200);
      expect(res.body).toBe(true);
    });
  });

  describe('/users', () => {
    describe('GET /users', () => {
      let sessionUserId, testUserId, sessionToken;

      beforeEach(() => {
        sessionUserId = uuidv4();
        testUserId = uuidv4();
        sessionToken = generateSessionToken();

        createUser(sessionUserId, 'sessionUser', ADMIN_ROLE);
        createSession(sessionUserId, sessionToken);
        createUser(testUserId, 'testUser', ADMIN_ROLE);
      });

      afterEach(() => {
        deleteUser(sessionUserId);
        deleteUser(testUserId);
      });

      it('should return 200 and a list of users', async () => {
        const res = await request(app)
          .get('/users')
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(200);
        expect(res.body.length).toBeGreaterThan(0);
      });
    });

    describe('POST /users', () => {
      let sessionUserId, sessionToken;
      let createdUserId;
      let duplicateUserId;

      beforeEach(() => {
        sessionUserId = uuidv4();
        sessionToken = generateSessionToken();
        createUser(sessionUserId, 'sessionUser', ADMIN_ROLE);
        createSession(sessionUserId, sessionToken);
      });

      afterEach(() => {
        deleteUser(sessionUserId);
        if (createdUserId) {
          deleteUser(createdUserId);
          createdUserId = null;
        }

        if (duplicateUserId) {
          deleteUser(duplicateUserId);
          duplicateUserId = null;
        }
      });

      it('should return 200 and create a new user', async () => {
        const newUser = {
          userName: 'user1',
          displayName: 'User One',
          enabled: 1,
          owner: 0,
          role: BASIC_ROLE,
        };

        const res = await request(app)
          .post('/users')
          .send(newUser)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(200);
        expect(res.body.status).toBe('ok');
        expect(res.body.data).toHaveProperty('id');

        createdUserId = res.body.data.id;
      });

      it('should return 400 if the user already exists', async () => {
        const newUser = {
          userName: 'user1',
          displayName: 'User One',
          enabled: 1,
          owner: 0,
          role: BASIC_ROLE,
        };

        let res = await request(app)
          .post('/users')
          .send(newUser)
          .set('x-actual-token', sessionToken);

        duplicateUserId = res.body.data.id;

        res = await request(app)
          .post('/users')
          .send(newUser)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(400);
        expect(res.body.status).toBe('error');
        expect(res.body.reason).toBe('user-already-exists');
      });
    });

    describe('PATCH /users', () => {
      let sessionUserId, testUserId, sessionToken;

      beforeEach(() => {
        sessionUserId = uuidv4();
        testUserId = uuidv4();
        sessionToken = generateSessionToken();

        createUser(sessionUserId, 'sessionUser', ADMIN_ROLE);
        createSession(sessionUserId, sessionToken);
        createUser(testUserId, 'testUser', ADMIN_ROLE);
      });

      afterEach(() => {
        deleteUser(sessionUserId);
        deleteUser(testUserId);
      });

      it('should return 200 and update an existing user', async () => {
        const userToUpdate = {
          id: testUserId,
          userName: 'updatedUser',
          displayName: 'Updated User',
          enabled: true,
          role: BASIC_ROLE,
        };

        const res = await request(app)
          .patch('/users')
          .send(userToUpdate)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(200);
        expect(res.body.status).toBe('ok');
        expect(res.body.data.id).toBe(testUserId);
      });

      it('should return 400 if the user does not exist', async () => {
        const userToUpdate = {
          id: 'non-existing-id',
          userName: 'nonexistinguser',
          displayName: 'Non-existing User',
          enabled: true,
          role: BASIC_ROLE,
        };

        const res = await request(app)
          .patch('/users')
          .send(userToUpdate)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(400);
        expect(res.body.status).toBe('error');
        expect(res.body.reason).toBe('cannot-find-user-to-update');
      });
    });

    describe('POST /users/delete-all', () => {
      let sessionUserId, testUserId, sessionToken;

      beforeEach(() => {
        sessionUserId = uuidv4();
        testUserId = uuidv4();
        sessionToken = generateSessionToken();

        createUser(sessionUserId, 'sessionUser', ADMIN_ROLE);
        createSession(sessionUserId, sessionToken);
        createUser(testUserId, 'testUser', ADMIN_ROLE);
      });

      afterEach(() => {
        deleteUser(sessionUserId);
        deleteUser(testUserId);
      });

      it('should return 200 and delete all specified users', async () => {
        const userToDelete = {
          ids: [testUserId],
        };

        const res = await request(app)
          .delete('/users')
          .send(userToDelete)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(200);
        expect(res.body.status).toBe('ok');
        expect(res.body.data.someDeletionsFailed).toBe(false);
      });

      it('should return 400 if not all users are deleted', async () => {
        const userToDelete = {
          ids: ['non-existing-id'],
        };

        const res = await request(app)
          .delete('/users')
          .send(userToDelete)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(400);
        expect(res.body.status).toBe('error');
        expect(res.body.reason).toBe('not-all-deleted');
      });
    });
  });

  describe('/access', () => {
    describe('POST /access', () => {
      let sessionUserId, testUserId, fileId, sessionToken;

      beforeEach(() => {
        sessionUserId = uuidv4();
        testUserId = uuidv4();
        fileId = uuidv4();
        sessionToken = generateSessionToken();

        createUser(sessionUserId, 'sessionUser', ADMIN_ROLE);
        createSession(sessionUserId, sessionToken);
        createUser(testUserId, 'testUser', ADMIN_ROLE);
        getAccountDb().mutate('INSERT INTO files (id, owner) VALUES (?, ?)', [
          fileId,
          sessionUserId,
        ]);
      });

      afterEach(() => {
        deleteUser(sessionUserId);
        deleteUser(testUserId);
        getAccountDb().mutate('DELETE FROM files WHERE id = ?', [fileId]);
      });

      it('should return 200 and grant access to a user', async () => {
        const newUserAccess = {
          fileId,
          userId: testUserId,
        };

        const res = await request(app)
          .post('/access')
          .send(newUserAccess)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(200);
        expect(res.body.status).toBe('ok');
      });

      it('should return 400 if the user already has access', async () => {
        const newUserAccess = {
          fileId,
          userId: testUserId,
        };

        await request(app)
          .post('/access')
          .send(newUserAccess)
          .set('x-actual-token', sessionToken);

        const res = await request(app)
          .post('/access')
          .send(newUserAccess)
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(400);
        expect(res.body.status).toBe('error');
        expect(res.body.reason).toBe('user-already-have-access');
      });
    });

    describe('DELETE /access', () => {
      let sessionUserId, testUserId, fileId, sessionToken;

      beforeEach(() => {
        sessionUserId = uuidv4();
        testUserId = uuidv4();
        fileId = uuidv4();
        sessionToken = generateSessionToken();

        createUser(sessionUserId, 'sessionUser', ADMIN_ROLE);
        createSession(sessionUserId, sessionToken);
        createUser(testUserId, 'testUser', ADMIN_ROLE);
        getAccountDb().mutate('INSERT INTO files (id, owner) VALUES (?, ?)', [
          fileId,
          sessionUserId,
        ]);
        getAccountDb().mutate(
          'INSERT INTO user_access (user_id, file_id) VALUES (?, ?)',
          [testUserId, fileId],
        );
      });

      afterEach(() => {
        deleteUser(sessionUserId);
        deleteUser(testUserId);
        getAccountDb().mutate('DELETE FROM files WHERE id = ?', [fileId]);
      });

      it('should return 200 and delete access for the specified user', async () => {
        const deleteAccess = {
          ids: [testUserId],
        };

        const res = await request(app)
          .delete('/access')
          .send(deleteAccess)
          .query({ fileId })
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(200);
        expect(res.body.status).toBe('ok');
        expect(res.body.data.someDeletionsFailed).toBe(false);
      });

      it('should return 400 if not all access deletions are successful', async () => {
        const deleteAccess = {
          ids: ['non-existing-id'],
        };

        const res = await request(app)
          .delete('/access')
          .send(deleteAccess)
          .query({ fileId })
          .set('x-actual-token', sessionToken);

        expect(res.statusCode).toEqual(400);
        expect(res.body.status).toBe('error');
        expect(res.body.reason).toBe('not-all-deleted');
      });
    });
  });
});