WorkIt/models.js at master · BrianCarroll112/WorkIt · 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
const Sequelize = require('sequelize');

let sequelize;
if (process.env.DATABASE_URL) {
  console.log('called');
  sequelize = new Sequelize(process.env.DATABASE_URL, {
    dialect:  'postgres',
    logging:  true,
    operatorsAliases: false,
    define: {
      underscored: true
    }
  });
} else {
  sequelize = new Sequelize({
    database: 'workit_db',
    dialect: 'postgresql',
    operatorsAliases: false,
    define: {
      underscored: true
    }
  });
}

const User = sequelize.define('user', {
  email: { type: Sequelize.STRING, unique: true },
  password_digest: Sequelize.STRING,
  first_name: Sequelize.STRING,
  last_name: Sequelize.STRING,
  profile_pic: Sequelize.TEXT,
  cv: Sequelize.TEXT,
  bio: Sequelize.TEXT,
  job_title: Sequelize.STRING,
});
const Company = sequelize.define('company', {
  name: Sequelize.STRING,
  location: Sequelize.STRING,
  about: Sequelize.TEXT,
  link: Sequelize.STRING,
});
const Job = sequelize.define('job', {
  job_title: Sequelize.STRING,
  description: Sequelize.TEXT,
  employee_status: Sequelize.STRING,
  salary: Sequelize.INTEGER,
  experience_level: Sequelize.STRING,
  location: Sequelize.STRING,
});


Job.belongsTo(Company);
Company.hasMany(Job);

User.belongsTo(Company);
Company.hasMany(User);

module.exports = {
  User,
  Company,
  Job,
  sequelize,
};