1.9.132 • Published 1 year ago

j2sql2 v1.9.132

Weekly downloads
74
License
MIT
Repository
github
Last release
1 year ago

j2sql2

enhance j2sql use ioredis mysql-promise mssql

npm i j2sql2

导入 sample.sql

node sample.js

关键字和表的冲突

不要使用以下关键字作为数据库表名

pool _mysql format cmd run genData

check 增强

在使用对象提交 sql 的情况下,增强如下功能

  • 对 where 条件是否有包含此列
  • 对 column 是否有包含此列
  • 对 order by 是否有包含此列
  • 对 string 和 number 类型进行预检测
  • 同时封装 mysql 和 redis 详见 sample.js

如果数据库配置文件中打开如下配置，将返回和接受，camel 形式的列名，例如 cTime => c_time ..

extendOption: {
  columnCamelize: true
}

如果有 mysql.crudExtend 就扩展 db'tableName'.ex 属性，并检查数据库表是否有如下字段,都基于 d_flag 字段

mysql: {
  crudExtend: {
    isDevMode: 1 // 默认开发模式打印sql语句
    /* delflagField: 'd_flag', // 默认逻辑删除标记
      createTimeField: 'c_time',
      modifyTimeField: 'm_time' */
  }
}
redis: {
  keyLimit: ['x1', 'c*'] // '*' 全部允许
}
// 也可以通过redis实例 redis.keysLimit.add('*') or redis.keysLimit.status = 0 全部允许(关闭过滤)
// 详见 sample.js
    // reJson 支持    
    let r = (await rd.jset('sky', '.', { 'x': 1 })) 
    console.log('reJson Test', r)
    r = (await rd.jget('sky', '.')) 
    console.log('reJson Test', r)
    
// 详见 sample.js
  • 详见 crud.js
  • page, 分页
  • list,
  • insert,
  • update,
  • remove,
  • clear,
  • getById,
  • removeById,
  • deleteById,
  • updateById,
  • addById 列增加
amqp-connection-manageramqplibbluebirdioredismeekomssqlpromise-mysql
@everything-registry/sub-chunk-1945skyjtskybase-template@zalastax/nolb-j2
1.9.132

1 year ago

1.9.131

1 year ago

1.9.130

2 years ago

1.9.129

2 years ago

1.9.127

2 years ago

1.9.128

2 years ago

1.9.125

2 years ago

1.9.126

2 years ago

1.9.123

2 years ago

1.9.124

2 years ago

1.9.121

2 years ago

1.9.122

2 years ago

1.9.118

3 years ago

1.9.119

3 years ago

1.9.116

3 years ago

1.9.117

3 years ago

1.9.114

3 years ago

1.9.115

3 years ago

1.9.112

3 years ago

1.9.113

3 years ago

1.9.110

3 years ago

1.9.111

3 years ago

1.9.107

3 years ago

1.9.108

3 years ago

1.9.105

3 years ago

1.9.106

3 years ago

1.9.103

3 years ago

1.9.104

3 years ago

1.9.101

3 years ago

1.9.102

3 years ago

1.9.109

3 years ago

1.9.100

4 years ago

1.9.99

4 years ago

1.9.98

4 years ago

1.9.97

4 years ago

1.9.96

5 years ago

1.9.95

5 years ago

1.9.94

5 years ago

1.9.93

5 years ago

1.9.92

5 years ago

1.9.91

5 years ago

1.9.90

5 years ago

1.9.89

5 years ago

1.9.88

5 years ago

1.9.87

5 years ago

1.9.86

5 years ago

1.9.85

5 years ago

1.9.84

5 years ago

1.9.83

5 years ago

1.9.82

5 years ago

1.9.81

5 years ago

1.9.80

5 years ago

1.9.79

5 years ago

1.9.78

5 years ago

1.9.77

5 years ago

1.9.76

5 years ago

1.9.75

5 years ago

1.9.74

5 years ago

1.9.73

5 years ago

1.9.72

5 years ago

1.9.71

5 years ago

1.9.70

5 years ago

1.9.69

5 years ago

1.9.68

5 years ago

1.9.67

5 years ago

1.9.66

5 years ago

1.9.65

5 years ago

1.9.64

5 years ago

1.9.63

5 years ago

1.9.62

5 years ago

1.9.61

5 years ago

1.9.60

5 years ago

1.9.59

5 years ago

1.9.58

5 years ago

1.9.57

5 years ago

1.9.56

5 years ago

1.9.55

5 years ago

1.9.54

5 years ago

1.9.53

6 years ago

1.9.52

6 years ago

1.9.49

6 years ago

1.9.51

6 years ago

1.9.50

6 years ago

1.9.48

6 years ago

1.9.47

6 years ago

1.9.46

6 years ago

1.9.45

6 years ago

1.9.44

6 years ago

1.9.43

6 years ago

1.9.42

6 years ago

1.9.41

6 years ago

1.9.40

6 years ago

1.9.39

6 years ago

1.9.38

6 years ago

1.9.37

6 years ago

1.9.36

6 years ago

1.9.35

6 years ago

1.9.34

6 years ago

1.9.33

6 years ago

1.9.32

6 years ago

1.9.31

6 years ago

1.9.30

6 years ago

1.9.29

6 years ago

1.9.28

6 years ago

1.9.27

6 years ago