10 examples of 'sequelize sync' in JavaScript

27
function sync(...args) {
28
  return sequelize.sync(...args);
29
}

51
function sync (...args) {
52
  return sequelize.sync(...args)
53
}

143
executed () {
144
  const self = this;
145
146
  return this._model()
147
    .sync()
148
    .then((Model) => Model.findAll({ order: [ [ self.columnName, 'ASC' ] ] }))
149
    .then((migrations) => migrations.map((migration) => migration[self.columnName]));
150
}

52
private async createTable() {
53
    await this.sequelize.sync();
54
}

99
async _getTable() {
100
    if (!this.table) {
101
        this.table = this.sequelize.define(this.tableName, tableOption[0], tableOption[1]);
102
        await this.table.sync();
103
    }
104
    return this.table;
105
}

64
function dbSync (force) {
65
  return db.sequelize.sync({ force: force, logging: false })
66
    .then(() => true)
67
    .catch(err => {
68
      if (err.name === 'SequelizeConnectionError') {
69
        console.log('Can not connect to the database.')
70
        let answer = readLine.keyInSelect(['Try again.', 'Close the installer'], 'What do you want to do?')
71
        if (answer === 0) {
72
          dbSync(force)
73
        } else {
74
          return false
75
        }
76
      } else {
77
        console.error(err)
78
      }
79
    })
80
}

36
function syncDatabase() {
37
  return Book.sync({ force: true });
38
}

12
function SequelizeAdapter(schema) {
13
    this.schema = schema;
14
    this._models = {};
15
    this._modelDefinitions = {};
16
    this._modelSettings = {};
17
    this.client = new Sequelize(
18
        schema.settings.database,
19
        schema.settings.username,
20
        schema.settings.password, {
21
            host: schema.settings.host,
22
            port: schema.settings.port,
23
            logging: schema.settings.port,
24
            maxConcurrentQueries: schema.settings.maxConcurrentQueries
25
        }
26
    );
27
}

34
sync() {
35
  return this.db.none(syncSql());
36
}

1
export async function up(sequelize) {
2
    // language=PostgreSQL
3
    await sequelize.query(`
4
        CREATE TABLE "keywords" (
5
            "id" SERIAL UNIQUE PRIMARY KEY NOT NULL,
6
            "keyword" VARCHAR(30) UNIQUE NOT NULL,
7
            "createdAt" TIMESTAMP NOT NULL,
8
            "updatedAt" TIMESTAMP NOT NULL,
9
            "deletedAt" TIMESTAMP
10
        );
11
        CREATE TABLE "keywords_entries" (
12
            "keywordId" INTEGER NOT NULL
13
                CONSTRAINT "keywords_entries_keywordId_fkey"
14
                REFERENCES keywords
15
                ON UPDATE CASCADE ON DELETE CASCADE,
16
            "entryId" INTEGER NOT NULL
17
                CONSTRAINT "keywords_entries_entryId_fkey"
18
                REFERENCES entries
19
                ON UPDATE CASCADE ON DELETE CASCADE,
20
            "createdAt" TIMESTAMP NOT NULL,
21
            UNIQUE("keywordId", "entryId")
22
        );
23
  `);
24
25
    console.log('*Table keywords created!*');
26
}