1.9.132 • Published 4 months ago

j2sql2 v1.9.132

Weekly downloads
74
License
MIT
Repository
github
Last release
4 months 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

4 months ago

1.9.131

4 months ago

1.9.130

1 year ago

1.9.129

1 year ago

1.9.127

1 year ago

1.9.128

1 year ago

1.9.125

1 year ago

1.9.126

1 year ago

1.9.123

1 year ago

1.9.124

1 year ago

1.9.121

1 year ago

1.9.122

1 year ago

1.9.118

2 years ago

1.9.119

2 years ago

1.9.116

2 years ago

1.9.117

2 years ago

1.9.114

2 years ago

1.9.115

2 years ago

1.9.112

2 years ago

1.9.113

2 years ago

1.9.110

2 years ago

1.9.111

2 years ago

1.9.107

2 years ago

1.9.108

2 years ago

1.9.105

2 years ago

1.9.106

2 years ago

1.9.103

2 years ago

1.9.104

2 years ago

1.9.101

2 years ago

1.9.102

2 years ago

1.9.109

2 years ago

1.9.100

3 years ago

1.9.99

3 years ago

1.9.98

3 years ago

1.9.97

3 years ago

1.9.96

4 years ago

1.9.95

4 years ago

1.9.94

4 years ago

1.9.93

4 years ago

1.9.92

4 years ago

1.9.91

4 years ago

1.9.90

4 years ago

1.9.89

4 years ago

1.9.88

4 years ago

1.9.87

4 years ago

1.9.86

4 years ago

1.9.85

4 years ago

1.9.84

4 years ago

1.9.83

4 years ago

1.9.82

4 years ago

1.9.81

4 years ago

1.9.80

4 years ago

1.9.79

4 years ago

1.9.78

4 years ago

1.9.77

4 years ago

1.9.76

4 years ago

1.9.75

4 years ago

1.9.74

4 years ago

1.9.73

4 years ago

1.9.72

4 years ago

1.9.71

4 years ago

1.9.70

4 years ago

1.9.69

4 years ago

1.9.68

4 years ago

1.9.67

4 years ago

1.9.66

4 years ago

1.9.65

4 years ago

1.9.64

4 years ago

1.9.63

4 years ago

1.9.62

4 years ago

1.9.61

4 years ago

1.9.60

4 years ago

1.9.59

4 years ago

1.9.58

4 years ago

1.9.57

4 years ago

1.9.56

4 years ago

1.9.55

4 years ago

1.9.54

4 years ago

1.9.53

4 years ago

1.9.52

4 years ago

1.9.49

5 years ago

1.9.51

5 years ago

1.9.50

5 years ago

1.9.48

5 years ago

1.9.47

5 years ago

1.9.46

5 years ago

1.9.45

5 years ago

1.9.44

5 years ago

1.9.43

5 years ago

1.9.42

5 years ago

1.9.41

5 years ago

1.9.40

5 years ago

1.9.39

5 years ago

1.9.38

5 years ago

1.9.37

5 years ago

1.9.36

5 years ago

1.9.35

5 years ago

1.9.34

5 years ago

1.9.33

5 years ago

1.9.32

5 years ago

1.9.31

5 years ago

1.9.30

5 years ago

1.9.29

5 years ago

1.9.28

5 years ago

1.9.27

5 years ago