# express-crud-router-sequelize-v6-adapter

> Sequelize v6 adapter to express-crud-router

Latest version **4.1.1** (published 2022-11-09) · MIT license · 0 weekly downloads

## Install

```sh
npm install express-crud-router-sequelize-v6-adapter
pnpm add express-crud-router-sequelize-v6-adapter
yarn add express-crud-router-sequelize-v6-adapter
bun add express-crud-router-sequelize-v6-adapter
```

## Health

**Score 25/100 (F)** — status: abandoned.

Positive: has types; no vulnerabilities; high quality score.

Warnings: low downloads; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 4.1.1 |
| Published | 2022-11-09 |
| First published | 2022-01-28 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | bundled |
| Module format | CommonJS |
| Dependencies | 0 |
| Unpacked size | 16.8 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 1 |
| Maintainers | urakozz |
| Keywords | react-admin, crud, express, express-crud-router-adapter, sequelize |

## Links

- npm: https://www.npmjs.com/package/express-crud-router-sequelize-v6-adapter
- Repository: https://github.com/urakozz/express-crud-router-sequelize-v6-adapter
- Homepage: https://github.com/urakozz/express-crud-router-sequelize-v6-adapter#readme
- npm.io page: https://npm.io/package/express-crud-router-sequelize-v6-adapter

## Alternatives

- [express-promise-router](https://npm.io/package/express-promise-router.md) — 736.1K weekly downloads
- [next-usequerystate](https://npm.io/package/next-usequerystate.md) — 29.8K weekly downloads
- [@bitkyc08/opencodex](https://npm.io/package/@bitkyc08/opencodex.md) — 4.6K weekly downloads
- [lynkr](https://npm.io/package/lynkr.md) — 575 weekly downloads
- [baremetal.js](https://npm.io/package/baremetal.js.md) — 42 weekly downloads

## Recent versions

- 4.1.1 (latest) — 2022-11-09
- 4.1.0 — 2022-11-09
- 4.0.0 — 2022-09-07
- 3.1.1 — 2022-08-19
- 3.1.0 — 2022-08-19
- 3.0.0 — 2022-04-27
- 2.0.2 — 2022-04-01
- 1.0.3 — 2022-02-02
- 1.0.2 — 2022-02-01
- 1.0.1 — 2022-02-01
- 1.0.0 — 2022-01-28

## README

# express-crud-router-sequelize-v6-connector

Sequelize v6 connector to [express-crud-router](https://github.com/lalalilo/express-crud-router).

```ts
import crud from "express-crud-router";
import sequelizeV6Crud from "express-crud-router-sequelize-v6-connector";

app.use(crud("/admin/users", sequelizeV6Crud(User)));
```

## Install

```
npm install express-crud-router-sequelize-v6-router
```

## Search

express-crud-router-sequelize-v6-router exposes a default search helper function `sequelizeSearchFields`.

Here is an example:

```ts
import crud from "express-crud-router";
import sequelizeCrud, {
  sequelizeSearchFields,
} from "express-crud-router-sequelize-v6-connector";

crud("/admin/users", {
  ...sequelizeCrud(User),
  search: sequelizeSearchFields(User, ["address", "zipCode", "city"]),
});
```

When searching `some stuff`, the following records will be returned in this order:

1. records with a searchable field that contains `some stuff`
2. records that have searchable fields that contain both `some` and `stuff`
3. records that have searchable fields that contain one of `some` or `stuff`

The search is case insensitive by default (except for search fields of type `DataTypes.UUID` where exact matches are returned). You can customize the search to make it case sensitive or use a scope:

```ts
import { Op } from "sequelize";

const search = sequelizeSearchFields(
  User,
  ["address", "zipCode", "city"],
  Op.like
);
```

## Contribute

See https://github.com/lalalilo/express-crud-router#contribute

---
_Source: https://npm.io/package/express-crud-router-sequelize-v6-adapter · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._