npmpackage.info

Gathering detailed insights and metrics for @yunser/egg-sequelize-ts-partition

@yunser/egg-sequelize-ts-partition - 0.2.3-6 | npmpackage.info

@yunser/egg-sequelize-ts-partition

Sequelize for Egg.js

0.2.3-6

MIT

JavaScript

19.72 kB

1.7

Installations

npm install @yunser/egg-sequelize-ts-partition

Developer Guide

BETA

Typescript

No

Module System

N/A

Min. Node Version

>=6.0.0

Node Version

14.18.1

NPM Version

6.14.15 Pull Requests

Open

1

Total

1

Closed

0

Issues

Open

1

Total

4

Closed

3

Releases

Unable to fetch releases

Languages

JavaScript

JavaScript (100%)

Developer

stone-lyl

Download Statistics

Total Downloads

Last Day

Last Week

Last Month

Last Year

GitHub Statistics

MIT License

24 Stars

99 Commits

10 Forks

1 Watchers

10 Branches

1 Contributors

Updated on Aug 27, 2024

Maintainers

View All 1 Contributors

Package Meta Information

Latest Version

0.2.3-6

Package Id

@yunser/egg-sequelize-ts-partition@0.2.3-6

Unpacked Size

19.72 kB

Size

7.53 kB

File Count

NPM Version

6.14.15

Node Version

14.18.1

Total Downloads

Cumulative downloads

Total Downloads

NaN

Last Day

NaN

Compared to previous day

Last Week

NaN

Compared to previous week

Last Month

NaN

Compared to previous month

Last Year

NaN

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

mz-modules reflect-metadata sequelize sequelize-typescript typescript

Dev Dependencies

autod egg egg-bin egg-mock eslint eslint-config-egg mysql2

egg-sequelize-ts

"version": "0.2.3-6", "sequelize": "https://github.com/chuang-ren/sequelize.git#v5",

有严重问题 "version": "0.2.3-5", "sequelize": "https://github.com/chuang-ren/sequelize.git",

"version": "0.2.3-4", "sequelize": "https://gitee.com/chuang-ren/sequelize.git",

"version": "0.2.3-2", "sequelize": "https://gitee.com/chuang-ren/sequelize.git#v5",

"version": "0.2.3-1", "sequelize": "git://github.com/chuang-ren/sequelize.git#v4",

更改

插件只是将 egg-sequelize 中的 sequelize 替换为 sequelize-typescript, 同时保证用户在 egg.js 创建的项目中使用 egg-sequelize 的方法尽量一致，在使用时的不同，我将下面一一阐述。其他内容部分请查看 egg-sequelize。此插件已在生产项目中得到实践。

目的

能让使用 typescript 编写的 egg.js 项目中能够使用 sequelize方法，并同时得到egg.js所赋予的功能。

安装

1$ npm i --save egg-sequelize-ts
2$ yarn add egg-sequelize-ts

配置

Enable plugin in config/plugin.js
在 config/plugin.js 文件中引入 egg-sequelize-ts 组件

1exports.sequelize = {
2    enable: true,
3    package: 'egg-sequelize-ts'
4}

Edit your own configurations in conif/config.{env}.js 在 conif/config.{env}.js 中编写 sequelize 配置

1    config.sequelize = {
2        dialect: 'mysql',
3        host: '127.0.0.1',
4        port: 3306,
5        database: 'database'
6    };

例子

分别以 model/user.js 和 service/user.js 举例说明

note 注意我们都是从 sequelize-typescript 中导出类名，方法，属性等。

1// app/model/user.js
2
3/**
4 * @desc 用户表
5 */
6import { AutoIncrement, Column, DataType, Model, PrimaryKey, Table } from 'sequelize-typescript';
7@Table({
8    modelName: 'user'
9})
10export class User extends Model<User> {
11
12    @PrimaryKey
13    @AutoIncrement
14    @Column({
15        type: DataType.INTEGER(11),
16        comment: '用户ID',
17        comment: 'user id'
18    })
19    id: number;
20
21    @Column({
22        comment: '用户姓名',
23    })
24    name: string;
25
26    @Column({
27        comment: '用户邮箱'
28    })
29    email: string;
30
31    @Column({
32        comment: '用户手机号码'
33    })
34    phone: string;
35
36    @Column({
37        field: 'created_at'
38    })
39    createdAt: Date;
40
41    @Column({
42        field: 'updated_at'
43    })
44    updatedAt: Date;
45};
46export default () => User;
47

1// app/service/user.js
2import { Service } from 'egg';
3import { Sequelize } from 'sequelize-typescript';
4
5class UserService extends Service {
6  async index() {
7    const { or } = Sequelize.Op;
8    const users = await this.ctx.model.User.findOne({
9        where: {
10            [or]: [
11                { name, phone },
12                { id }
13            ]
14        }
15    });
16    this.ctx.body = users;
17  }
18}

No vulnerabilities found.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

License

Determines if the project has defined a license.

0

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

0

Maintained

Determines if the project is "actively maintained".

0

SAST

Determines if the project uses static code analysis.

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Security-Policy

Determines if the project has published a security policy.

0

Fuzzing

Determines if the project uses fuzzing.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

Reason

87 existing vulnerabilities detected

Details

Warn: Project is vulnerable to: GHSA-67hx-6x53-jw92
Warn: Project is vulnerable to: GHSA-6chw-6frg-f759
Warn: Project is vulnerable to: GHSA-v88g-cgmw-v5xw
Warn: Project is vulnerable to: GHSA-93q8-gq69-wqmw
Warn: Project is vulnerable to: GHSA-fwr7-v2mv-hh25
Warn: Project is vulnerable to: GHSA-v6h2-p8h4-qcjw
Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
Warn: Project is vulnerable to: GHSA-pxg6-pf52-xh8x
Warn: Project is vulnerable to: GHSA-h452-7996-h45h
Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275
Warn: Project is vulnerable to: GHSA-gxpj-cx7g-858c
Warn: Project is vulnerable to: GHSA-w573-4hg7-7wgq
Warn: Project is vulnerable to: GHSA-9j49-mfvp-vmhm
Warn: Project is vulnerable to: GHSA-wm7h-9275-46v2
Warn: Project is vulnerable to: GHSA-4gxf-g5gf-22h4
Warn: Project is vulnerable to: GHSA-4gmj-3p3h-gm8h
Warn: Project is vulnerable to: GHSA-3gx7-xhv7-5mx3
Warn: Project is vulnerable to: GHSA-gjm5-83cw-p3p2
Warn: Project is vulnerable to: GHSA-q42p-pg8m-cqh6
Warn: Project is vulnerable to: GHSA-w457-6q6x-cgp9
Warn: Project is vulnerable to: GHSA-62gr-4qp9-h98f
Warn: Project is vulnerable to: GHSA-f52g-6jhx-586p
Warn: Project is vulnerable to: GHSA-2cf5-4w76-r9qv
Warn: Project is vulnerable to: GHSA-3cqr-58rm-57f8
Warn: Project is vulnerable to: GHSA-g9r4-xpmj-mj65
Warn: Project is vulnerable to: GHSA-q2c6-c6pm-g3gh
Warn: Project is vulnerable to: GHSA-765h-qjxv-5f44
Warn: Project is vulnerable to: GHSA-f2jv-r9rf-7988
Warn: Project is vulnerable to: GHSA-43f8-2h32-f4cj
Warn: Project is vulnerable to: GHSA-pc5p-h8pf-mvwp
Warn: Project is vulnerable to: GHSA-qqgx-2p2h-9c37
Warn: Project is vulnerable to: GHSA-78xj-cgh5-2h22
Warn: Project is vulnerable to: GHSA-2p57-rm9w-gvfp
Warn: Project is vulnerable to: GHSA-2pr6-76vf-7546
Warn: Project is vulnerable to: GHSA-8j8c-7jfh-h6hx
Warn: Project is vulnerable to: GHSA-9c47-m6qq-7p4h
Warn: Project is vulnerable to: GHSA-6c8f-qphg-qjgp
Warn: Project is vulnerable to: GHSA-593f-38f6-jp5m
Warn: Project is vulnerable to: GHSA-x2rg-q646-7m2v
Warn: Project is vulnerable to: GHSA-jf85-cpcp-j695
Warn: Project is vulnerable to: GHSA-p6mc-m468-83gw
Warn: Project is vulnerable to: GHSA-29mw-wpgm-hmr9
Warn: Project is vulnerable to: GHSA-35jh-r3h4-6jhm
Warn: Project is vulnerable to: GHSA-4xcv-9jjx-gfj3
Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv
Warn: Project is vulnerable to: GHSA-f8q6-p94x-37v3
Warn: Project is vulnerable to: GHSA-vh95-rmgr-6w4m
Warn: Project is vulnerable to: GHSA-xvch-5gv4-984h
Warn: Project is vulnerable to: GHSA-fhjf-83wg-r2j9
Warn: Project is vulnerable to: GHSA-8hfj-j24r-96c4
Warn: Project is vulnerable to: GHSA-wc69-rhjr-hc9g
Warn: Project is vulnerable to: GHSA-56x4-j7p9-fcf9
Warn: Project is vulnerable to: GHSA-v78c-4p63-2j6c
Warn: Project is vulnerable to: GHSA-mqr2-w7wj-jjgr
Warn: Project is vulnerable to: GHSA-49j4-86m8-q2jw
Warn: Project is vulnerable to: GHSA-fpw7-j2hg-69v5
Warn: Project is vulnerable to: GHSA-4rch-2fh8-94vw
Warn: Project is vulnerable to: GHSA-pmh2-wpjm-fj45
Warn: Project is vulnerable to: GHSA-mwcw-c2x4-8c55
Warn: Project is vulnerable to: GHSA-4c7m-wxvm-r7gc
Warn: Project is vulnerable to: GHSA-pch5-whg9-qr2r
Warn: Project is vulnerable to: GHSA-hj48-42vr-x3v9
Warn: Project is vulnerable to: GHSA-9wv6-86v2-598j
Warn: Project is vulnerable to: GHSA-hrpp-h998-j3pp
Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw
Warn: Project is vulnerable to: GHSA-j9xp-92vc-559j
Warn: Project is vulnerable to: GHSA-m9jw-237r-gvfv
Warn: Project is vulnerable to: GHSA-fw4p-36j9-rrj3
Warn: Project is vulnerable to: GHSA-wrh9-cjv3-2hpw
Warn: Project is vulnerable to: GHSA-8c25-f3mj-v6h8
Warn: Project is vulnerable to: GHSA-vqfx-gj96-3w95
Warn: Project is vulnerable to: GHSA-f598-mfpv-gmfx
Warn: Project is vulnerable to: GHSA-7pvx-4585-hqww
Warn: Project is vulnerable to: GHSA-4g88-fppr-53pp
Warn: Project is vulnerable to: GHSA-4jqc-8m5r-9rpr
Warn: Project is vulnerable to: GHSA-29xr-v42j-r956
Warn: Project is vulnerable to: GHSA-3329-pjwv-fjpg
Warn: Project is vulnerable to: GHSA-p6j9-7xhc-rhwp
Warn: Project is vulnerable to: GHSA-89gv-h8wf-cg8r
Warn: Project is vulnerable to: GHSA-gcv8-gh4r-25x6
Warn: Project is vulnerable to: GHSA-gmv4-r438-p67f
Warn: Project is vulnerable to: GHSA-8h2f-7jc4-7m3m
Warn: Project is vulnerable to: GHSA-3vjf-82ff-p4r3
Warn: Project is vulnerable to: GHSA-g694-m8vq-gv9h
Warn: Project is vulnerable to: GHSA-qgmg-gppg-76g5
Warn: Project is vulnerable to: GHSA-c4w7-xm78-47vh
Warn: Project is vulnerable to: GHSA-p9pc-299p-vxgp

Score

1.7

/10

Last Scanned on 2025-07-07

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More