Mid_Internship_Backend/model.js at main · wnsrlf0721/Mid_Internship_Backend · GitHub

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
const mongoose = require('mongoose');
mongoose.connect('mongodb://localhost:27017/IoTDB', { useNewUrlParser: true });
var db = mongoose.connection;
db.on('error', function(){
    console.log('Connection Failed!');
});
db.once('open', function() {
    console.log('Connected!');
});
var Schema = mongoose.Schema;
//IoT data정보
const airSchema = new Schema({
  deviceId: { type: String, required: true },
  label: { type: String, required: true },
  categories: {type: String, required: true},
  created_at: Date,
  updated_at: Date,
  co2_measure: Number,
  co2_concern: String,
  dust_measure: Number,
  dust_concern: String,
  fineDust_measure: Number,
  fineDust_concern: String,
  veryfineDust_measure: Number,
  veryfineDust_concern: String,
  illuminance: Number,
  humidity: Number,
  temperature: Number,
  battery: Number
});
const doorSchema = new Schema({
  deviceId: { type: String, required: true },
  label: { type: String, required: true },
  categories: {type: String, required: true},
  created_at: Date,
  updated_at: Date,
  contact: String,
  acceleration: String,
  battery: Number
});
const hueSchema = new Schema({
  deviceId: { type: String, required: true },
  label: { type: String, required: true },
  categories: {type: String, required: true},
  created_at: Date,
  updated_at: Date,
  sat: Number,
  hue: Number,
  switch: String
});
const motionSchema = new Schema({
  deviceId: { type: String, required: true },
  label: { type: String, required: true },
  categories: {type: String, required: true},
  created_at: Date,
  updated_at: Date,
  motion: String,
  battery: Number
});
const plugSchema = new Schema({
  deviceId: { type: String, required: true },
  label: { type: String, required: true },
  categories: {type: String, required: true},
  created_at: Date,
  updated_at: Date,
  energy: Number,
  switch: String
});

var Air = mongoose.model('Air',airSchema, 'Air_data');
var Door = mongoose.model('Door',doorSchema, 'Door_data');
var Hue = mongoose.model('Hue',hueSchema, 'Hue_data');
var Motion = mongoose.model('Motion',motionSchema, 'Motion_data');
var Plug = mongoose.model('Plug',plugSchema, 'Plug_data');

module.exports = {
  Air, Door, Hue, Motion, Plug
}