user.js

({
  async read(id) {
    return await db('users').read(id, ['id', 'login']);
  },

  async create({ login, password }) {
    const passwordHash = await common.hash(password);
    return await db('users').create({ login, password: passwordHash });
  },

  async update(id, { login, password }) {
    const passwordHash = await common.hash(password);
    return await db('users').update(id, { login, password: passwordHash });
  },

  async delete(id) {
    return await db('users').delete(id);
  },

  async find(mask) {
    const sql = 'SELECT login from users where login like $1';
    return await db('users').query(sql, [mask]);
  },
});