1.0.3 • Published 5 years ago

buildwhere v1.0.3

Weekly downloads
4
License
ISC
Repository
github
Last release
5 years ago

buildWhere

buildWhere 根据参数创建sql

  npm install buildwhere --save-dev
  yarn add buildwhere --dev
  const params = { id: '123', user_name: 'admin' };
  const whereArr = [
    {
      param: 'id',
      isLike: false,
    },
    {
      param: 'user_name',
      isLike: true,
      likeRule: 'all',
    },
  ];
  title = buildWhere('user', params, whereArr);
  // title = 'user."id"=123' AND user."user_name" LIKE '%admin%'