-
Notifications
You must be signed in to change notification settings - Fork 1
/
my.js
53 lines (38 loc) · 1.08 KB
/
my.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
//rdsuenfaezuaq7n.mysql.rds.aliyuncs.com:3306
//cycok cycmysql
//rj8329y7c6l3mrwl
'use strict'
var Sequelize = require('sequelize');
var sequelize = new Sequelize('rj8329y7c6l3mrwl', 'cycok', 'cycmysql', {
host: 'rdsuenfaezuaq7n.mysql.rds.aliyuncs.com',
dialect: 'mysql',
logging: false
});
var Mans = sequelize.define('mans', {
myid: {type: Sequelize.INTEGER, primaryKey:true, field :'id'},
name: Sequelize.STRING,
age: Sequelize.INTEGER,
interest: Sequelize.INTEGER,
},{
freezeTableName: true,
tableName: 'mans',
timestamps: false,
});
//var Mans = sequelize.define('mans', {
// id: {type:Sequelize.INTEGER, field: 'id', primaryKey:true},
// name: Sequelize.STRING,
// age: Sequelize.INTEGER,
// interest: Sequelize.INTEGER
//});
Mans.all({ logging: console.log}).then(forx);
//Mans.destroy({where: {id:4}, logging: console.log}).then(si);
function si(data){
console.log(data);
}
function forx(data){
for(var key in data){
console.log(data[key].dataValues);
}
}
//si(Mans.getTableName())
module.exports = sequelize;