summaryrefslogtreecommitdiff
path: root/lib/db/models.js
blob: 588ce58c4a81646a21700aa73768a2592cf65196 (plain)
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
let fs = require('fs')
let model = require('./model')

let connection = require("./bookshelf")
let bookshelf = connection.bookshelf
let knex = connection.knex

let Folder = bookshelf.Model.extend({
  tableName: 'folders',
  hasTimestamps: true,
})
let File = bookshelf.Model.extend({
  tableName: 'files',
  hasTimestamps: true,
})
let Job = bookshelf.Model.extend({
  tableName: 'jobs',
  hasTimestamps: true,
})
let Task = bookshelf.Model.extend({
  tableName: 'tasks',
  hasTimestamps: true,
})

module.exports = {
  folder: model('folder', Folder, {
    afterCreate: (folder) => {
      fs.mkdir('data/' + folder.get('id') + '/', function(){
        console.log('created folder', folder.get('id'), folder.get('name'))
      })
    }
  }),
  file: model('file', File),
  job: model('job', Job),
  task: model('task', Task, {
    hasOne: {
      content_file: File,
      style_file: File,
      output_file: File,
    }
  }),
}