-
Notifications
You must be signed in to change notification settings - Fork 0
/
backup
79 lines (68 loc) · 2.52 KB
/
backup
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
var orm = require('orm');
// app.use(orm.express("mysql://"+process.env.DB_USER+":"+process.env.DB_PASS+"@"+process.env.DB_HOST+"/"+process.env.DB_NAME, {
// define: function (db, models, next) {
// models.person = db.define("person", { ... });
// next();
// }
// }));
// orm.connect("mysql://"+process.env.DB_USER+":"+process.env.DB_PASS+"@"+process.env.DB_HOST+"/"+process.env.DB_NAME, function(err, db){
// // db is now available to use! ^__^
// // console.log(db);
// db.define('TestDB01',{ Data : String});
// });
var Person = require('./app/model/person');
console.log(Person);
orm.connect("mysql://"+process.env.DB_USER+":"+process.env.DB_PASS+"@"+process.env.DB_HOST+"/"+process.env.DB_NAME, function (err, db) {
if (err) throw err;
var Person = db.define("person", {
name : String,
surname : String,
age : Number, // FLOAT
male : Boolean
// continent : [ "Europe", "America", "Asia", "Africa", "Australia", "Antartica" ], // ENUM type
// photo : Buffer,// BLOB/BINARY
// data : Object // JSON encoded
} , {
methods: {
fullName: function () {
return this.name + ' ' + this.surname;
}
},
validations: {
age: orm.enforce.ranges.number(18, undefined, "under-age")
}
});
Person.find({ surname: "Doe" }, function (err, people) {
// SQL: "SELECT * FROM person WHERE surname = 'Doe'"
if (err) throw err;
console.log("People found: %d", people.length);
console.log("First person: %s, age %d", people[0].fullName(), people[0].age);
people[0].age = 16;
people[0].save(function (err) {
// err.msg = "under-age";
});
});
// add the table to the database
//db.sync(function(err) {
//if (err) throw err;
// add a row to the person table
// Person.create({ id: 1, name: "John", surname: "Doe", age: 27 }, function(err) {
// if (err) throw err;
//
// // query the person table by surname
// Person.find({ surname: "Doe" }, function (err, people) {
// // SQL: "SELECT * FROM person WHERE surname = 'Doe'"
// if (err) throw err;
//
// console.log("People found: %d", people.length);
// console.log("First person: %s, age %d", people[0].fullName(), people[0].age);
//
// people[0].age = 16;
// people[0].save(function (err) {
// // err.msg = "under-age";
// });
// });
//
// });
//});
});