aboutsummaryrefslogtreecommitdiffstats
path: root/etherpad/src/etherpad/db_migrations/m0010_pad_sqlmeta.js
blob: 36150b1a142924f9f0fd6f6f7520f7f511344ba0 (plain) (blame)
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
/**
 * Copyright 2009 Google Inc.
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *      http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS-IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import("sqlbase.sqlbase");
import("sqlbase.sqlobj");
import("sqlbase.sqlcommon");
import("etherpad.utils.startConsoleProgressBar");


function run() {

  sqlobj.dropAndCreateTable('PAD_SQLMETA', {
    id: 'VARCHAR(128) PRIMARY KEY NOT NULL',
    version: 'INT NOT NULL',
    creationTime: sqlobj.getDateColspec('NOT NULL'),
    lastWriteTime: sqlobj.getDateColspec('NOT NULL'),
    headRev: 'INT NOT NULL'
  });

  sqlobj.createIndex('PAD_SQLMETA', ['version']);

  var allPadIds = sqlbase.getAllJSONKeys("PAD_META");

  // If this is a new database, there are no pads; else
  // it is an old database with version 1 pads.
  if (allPadIds.length == 0) {
    return;
  }

  var numPadsTotal = allPadIds.length;
  var numPadsSoFar = 0;
  var progressBar = startConsoleProgressBar();

  allPadIds.forEach(function(padId) {
    var meta = sqlbase.getJSON("PAD_META", padId);

    sqlobj.insert("PAD_SQLMETA", {
      id: padId,
      version: 1,
      creationTime: new Date(meta.creationTime || 0),
      lastWriteTime: new Date(),
      headRev: meta.head
    });

    delete meta.creationTime; // now stored in SQLMETA
    delete meta.version; // just in case (was used during development)
    delete meta.dirty; // no longer stored in DB
    delete meta.lastAccess; // no longer stored in DB

    sqlbase.putJSON("PAD_META", padId, meta);

    numPadsSoFar++;
    progressBar.update(numPadsSoFar/numPadsTotal, numPadsSoFar+"/"+numPadsTotal+" pads");
  });

  progressBar.finish();
}