server/models/application/application.ts

   1 import * as Sequelize from 'sequelize'
   2
   3 import { addMethodsToModel } from '../utils'
   4 import {
   5   ApplicationAttributes,
   6   ApplicationInstance,
   7
   8   ApplicationMethods
   9 } from './application-interface'
  10
  11 let Application: Sequelize.Model<ApplicationInstance, ApplicationAttributes>
  12 let loadMigrationVersion: ApplicationMethods.LoadMigrationVersion
  13 let updateMigrationVersion: ApplicationMethods.UpdateMigrationVersion
  14
  15 export default function defineApplication (sequelize: Sequelize.Sequelize, DataTypes: Sequelize.DataTypes) {
  16   Application = sequelize.define<ApplicationInstance, ApplicationAttributes>('Application',
  17     {
  18       migrationVersion: {
  19         type: DataTypes.INTEGER,
  20         defaultValue: 0,
  21         allowNull: false,
  22         validate: {
  23           isInt: true
  24         }
  25       }
  26     }
  27   )
  28
  29   const classMethods = [ loadMigrationVersion, updateMigrationVersion ]
  30   addMethodsToModel(Application, classMethods)
  31
  32   return Application
  33 }
  34
  35 // ---------------------------------------------------------------------------
  36
  37 loadMigrationVersion = function () {
  38   const query = {
  39     attributes: [ 'migrationVersion' ]
  40   }
  41
  42   return Application.findOne(query).then(data => data ? data.migrationVersion : null)
  43 }
  44
  45 updateMigrationVersion = function (newVersion: number, transaction: Sequelize.Transaction) {
  46   const options: Sequelize.UpdateOptions = {
  47     where: {},
  48     transaction: transaction
  49   }
  50
  51   return Application.update({ migrationVersion: newVersion }, options)
  52 }