teachmehow/sqlTest.js at master · Pointe-Blank/teachmehow · 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
79
80
81
82
83
84
85
86
87
88
89
90
91
const models = require('./server/config/db.connect.js');
// pretend this is a controller
module.exports = () => {
  let tmp = {
      teachId: null,
      catId: null,
      catIdDance: null
    };
  console.log('in test');
  models.User.create({
      name: 'Khoa',
      teachFlag: 0
    })
    .then((result) => {
      return models.User.create({
        name: 'Nate',
        teachFlag: 0
      });
    })
    .then((result) => {
      return models.User.create({
        name: 'Kevin',
        teachFlag: 0
      });
    })
    .then((result) => {
      return models.User.create({
        name: 'Ricky',
        teachFlag: 1
      });
    })
    .then((result) => {
      console.log('----- Result of User add', result.dataValues);
      tmp.teachId = result.dataValues.id;
      return models.Category.create({
          name: 'driving'
        });
    })
    .then((result) => {
      console.log('----- Result of Category add', result.dataValues);
      tmp.catId = result.dataValues.id;
      return models.Lesson.create({
          name: 'How to drift',
          UserId: tmp.teachId,
          CategoryId: tmp.catId
        });
    })
     .then((result) => {
       console.log('----- Result of Category add', result.dataValues);
       return models.Lesson.create({
          name: 'How to do a drive stick',
          UserId: tmp.teachId,
          CategoryId: tmp.catId
        });
     })

      .then((result) => {
        return models.User.create({
        name: 'Daria',
        teachFlag: 1
      });
      })
    .then((result) => {
      console.log('----- Result of User add', result.dataValues);
      tmp.teachId = result.dataValues.id;
      return models.Category.create({
          name: 'dance'
        });
    })
    .then((result) => {
      console.log('----- Result of Category add', result.dataValues);
      tmp.catIdDance = result.dataValues.id;
      return models.Lesson.create({
          name: 'How to drift',
          UserId: tmp.teachId,
          CategoryId: tmp.catId
        });
    })
     .then((result) => {
       console.log('----- Result of Category add', result.dataValues);
       return models.Lesson.create({
          name: 'How to dougie',
          UserId: tmp.teachId,
          CategoryId: tmp.catIdDance
        });
     })

    .catch(err => {
      console.log('there was an error in the test', err);
    });
};