Reorganize model files

3 files changed, 84 insertions, 0 deletions

diff --git a/server/models/application/application-interface.ts b/server/models/application/application-interface.ts
new file mode 100644
index 000000000..c03513db1
--- /dev/null
+++ b/server/models/application/application-interface.ts
@@ -0,0 +1,26 @@
+import * as Sequelize from 'sequelize'
+
+export namespace ApplicationMethods {
+  export type LoadMigrationVersionCallback = (err: Error, version: number) => void
+  export type LoadMigrationVersion = (callback: LoadMigrationVersionCallback) => void
+
+  export type UpdateMigrationVersionCallback = (err: Error, applicationInstance: ApplicationAttributes) => void
+  export type UpdateMigrationVersion = (newVersion: number, transaction: Sequelize.Transaction, callback: UpdateMigrationVersionCallback) => void
+}
+
+export interface ApplicationClass {
+  loadMigrationVersion: ApplicationMethods.LoadMigrationVersion
+  updateMigrationVersion: ApplicationMethods.UpdateMigrationVersion
+}
+
+export interface ApplicationAttributes {
+  migrationVersion: number
+}
+
+export interface ApplicationInstance extends ApplicationClass, ApplicationAttributes, Sequelize.Instance<ApplicationAttributes> {
+  id: number
+  createdAt: Date
+  updatedAt: Date
+}
+
+export interface ApplicationModel extends ApplicationClass, Sequelize.Model<ApplicationInstance, ApplicationAttributes> {}
diff --git a/server/models/application/application.ts b/server/models/application/application.ts
new file mode 100644
index 000000000..0e9a1ebb3
--- /dev/null
+++ b/server/models/application/application.ts
@@ -0,0 +1,57 @@
+import * as Sequelize from 'sequelize'
+
+import { addMethodsToModel } from '../utils'
+import {
+  ApplicationClass,
+  ApplicationAttributes,
+  ApplicationInstance,
+
+  ApplicationMethods
+} from './application-interface'
+
+let Application: Sequelize.Model<ApplicationInstance, ApplicationAttributes>
+let loadMigrationVersion: ApplicationMethods.LoadMigrationVersion
+let updateMigrationVersion: ApplicationMethods.UpdateMigrationVersion
+
+export default function defineApplication (sequelize: Sequelize.Sequelize, DataTypes: Sequelize.DataTypes) {
+  Application = sequelize.define<ApplicationInstance, ApplicationAttributes>('Application',
+    {
+      migrationVersion: {
+        type: DataTypes.INTEGER,
+        defaultValue: 0,
+        allowNull: false,
+        validate: {
+          isInt: true
+        }
+      }
+    }
+  )
+
+  const classMethods = [ loadMigrationVersion, updateMigrationVersion ]
+  addMethodsToModel(Application, classMethods)
+
+  return Application
+}
+
+// ---------------------------------------------------------------------------
+
+loadMigrationVersion = function (callback: ApplicationMethods.LoadMigrationVersionCallback) {
+  const query = {
+    attributes: [ 'migrationVersion' ]
+  }
+
+  return Application.findOne(query).asCallback(function (err, data) {
+    const version = data ? data.migrationVersion : null
+
+    return callback(err, version)
+  })
+}
+
+updateMigrationVersion = function (newVersion: number, transaction: Sequelize.Transaction, callback: ApplicationMethods.UpdateMigrationVersionCallback) {
+  const options: Sequelize.UpdateOptions = {
+    where: {},
+    transaction: transaction
+  }
+
+  return Application.update({ migrationVersion: newVersion }, options).asCallback(callback)
+}
diff --git a/server/models/application/index.ts b/server/models/application/index.ts
new file mode 100644
index 000000000..706f85cb9
--- /dev/null
+++ b/server/models/application/index.ts
@@ -0,0 +1 @@
+export * from './application-interface'