@fastcampus/fastdao NPM

fastdao

fast and simple dao using knex

Getting Started

// const = { connect, CrudOperations } = require('@fastcampus/fastdao');
import { connect, CrudOperations } from '@fastcampus/fastdao';

const knex = connect({ ...  });
// to use a separated connection for select
const knexReplica = connect({ ...  });
const postCrud = CrudOperations.create({ knex, knexReplica, table: 'post' });
await postCrud.select({ ... });
await postCrud.selectFirst({ ... });
await postCrud.selectById(1);
await postCrud.count({ ... });
await postCrud.exist({ ... });
await postCrud.insert({ ... });
await postCrud.update({ ... });
await postCrud.updateById(id, { ... });
await postCrud.delete({ ... });
await postCrud.deleteById(id);
await knex.transaction(async (tx) => {
  await postCrud.transacting(tx).insert(...);
  await postCrud.transacting(tx).updateById(...);
  await postCrud.transacting(tx).deleteById(...);
});