1

npm install ali-rds

1
2
3
4
5
6
7
8

const rds = require('ali-rds');
const db = rds({
    host: '10.26.62.5',
    port: '10656',
    user: 'root',
    password: 'simple',
    database: 'database', 
})

1
2
3
4
5
6
7
8
9

let res = await db.select('work', {
    where : {
        status : 1
    },
    limit : 3,
    columns: ['author', 'title'],
    orders: [['id', 'desc']]
})
let list = JSON.parse(JSON.stringify(res))

1
2
3
4
5
6
7
8

const row = {
  name: 'fengmk2',
  otherField: 'other field value',
  createdAt: db.literals.now, // `now()` on db server
  // ...
};
const result = await db.insert('table-name', row);
console.log(result);

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

let res = await db.update("simple_table", {
    config : JSON.stringify(config),
    status : 5,
    source : '',
    description : '',
    name : templateName,
}, {
    where : {
        id : styleID
    }
})
let list = JSON.parse(JSON.stringify(res))

1

let res = await db.query("UPDATE work SET `status` = 2 WHERE id = 21875631 AND project_id = 'auto3d-lheHqcLzSWv-w4BY4r9lT9';")