-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.coffee
118 lines (111 loc) · 2.55 KB
/
schema.coffee
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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
Sequelize = require('sequelize')
module.exports.sequelize = (app) ->
db = app.set('dbname')
user = app.set('dbuser')
pass = app.set('dbpass')
options = {host:app.set('dbhost'), logging:false}
return new Sequelize(db, user, pass, options)
module.exports.users = (sequelize) ->
users = sequelize.define('User', {
id: {
type:Sequelize.INTEGER,
primaryKey:true,
autoIncrement:true
},
name: {
type:Sequelize.STRING,
validate: {
is:["[a-z]", 'i']
}
},
email: {
type:Sequelize.STRING,
validate: {
isEmail:true
}
},
password: {
type:Sequelize.STRING,
validate: {
isEmpty:false,
}
},
balance: {
type:Sequelize.FLOAT,
defaultValue:0,
allowNull:false
},
sid: Sequelize.STRING,
type: {
type:Sequelize.STRING,
defaultValue:0
}
})
return users
module.exports.coffees = (sequelize) ->
coffees = sequelize.define('Coffee', {
id: {
type:Sequelize.INTEGER,
primaryKey:true,
autoIncrement:true
},
consumedByID: Sequelize.INTEGER,
cost: Sequelize.FLOAT
})
return coffees
module.exports.milk = (sequelize) ->
milk = sequelize.define('Milk', {
id: {
type:Sequelize.INTEGER,
primaryKey:true,
autoIncrement:true
},
consumedByID: Sequelize.INTEGER,
amount: Sequelize.INTEGER,
cost: Sequelize.FLOAT
})
return milk
module.exports.purchases = (sequelize) ->
purchases = sequelize.define('Purchase', {
id: {
type:Sequelize.INTEGER,
primaryKey:true,
autoIncrement:true
},
purchasedByID: Sequelize.INTEGER,
type: Sequelize.STRING,
amount: Sequelize.STRING,
cost: Sequelize.FLOAT,
description: Sequelize.STRING
})
return purchases
module.exports.payments = (sequelize) ->
payments = sequelize.define('Payment', {
id: {
type:Sequelize.INTEGER,
primaryKey:true,
autoIncrement:true
},
amount: Sequelize.FLOAT,
paymentByID: Sequelize.INTEGER,
reference: Sequelize.STRING,
note: Sequelize.TEXT,
confirmed: {
type: Sequelize.BOOLEAN,
defaultValue: false
}
})
return payments
module.exports.checkDBInit = (users) ->
email = '[email protected]'
users.find({ where: {email:email} }).success((user) ->
if not user?
newUser = users.build({
name:'Banker',
email:'[email protected]',
password:'c40b331003356d4e85272ac4286fe12602dd1eb2'
balance:0,
type:1
})
newUser.save()
)