-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdataBaseMethods.js
66 lines (61 loc) · 1.44 KB
/
dataBaseMethods.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
54
55
56
57
58
59
60
61
62
63
64
65
66
var mongoose = require("mongoose");
var env = process.argv[2] || 'dev';
switch (env) {
case 'dev':
var mongoDatabase = 'mongodb://localhost/theCountedData';
break;
case 'prod':
var mongoDatabase = 'mongodb://localhost/theCountedData'
break;
}
mongoose.connect( mongoDatabase);
var db = mongoose.connection;
db.on('error', function (err) {
console.log('connection error', err);
});
db.once('open', function () {
console.log('connected.');
});
var Schema = mongoose.Schema;
var personSchema = new Schema({
name: String,
age: String,
sex: String,
race: String,
month: String,
day: String,
year: String,
address: String,
city: String,
state: String,
cause: String,
dept: String,
armed: String,
});
a = [];
// Schema to DB Model
var Person = mongoose.model('Person', personSchema);
module.exports.findAll = function(res){
Person.find().
exec(function(err,data){
if(err){
res.status(500)
};
res.status(200).send(data)
});
}
module.exports.findFilter = function(res, data){
var searchKeys = Object.keys(data);
for(var i=0;i<searchKeys.length;i++){
var regex = new RegExp(["^", data[searchKeys[i]], "$"].join(""), "i");
data[searchKeys[i]] = regex;
}
// Creates a regex of: /^SomeStringToFind$/i
Person.find(data).
exec(function(err,data){
if(err){
res.status(500)
};
res.status(200).send(data)
});
}