aboutsummaryrefslogtreecommitdiffstats
path: root/infrastructure/framework-src/modules/sqlbase/sqlcommon.js
blob: 360f5e21a77e7ecd610ad74c77f407c0a1c6d127 (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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
/**
 * 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("jsutils.scalaF1")
import("stringutils.startsWith");

jimport("net.appjet.ajstdlib.SQLBase");
jimport("java.lang.System.out.println");

function _sqlbase() { return appjet.cache.sqlbase };

function init(driver, url, username, password) {
  var dbName = url.split(":")[1];
  println("Using "+dbName+" database type.");

  appjet.cache.sqlbase = new SQLBase(driver, url, username, password);

  // Test the connection
  println("Establishing "+dbName+" connection (this may take a minute)...");
  try {
    withConnection(function() {
      return;
    });
  } catch (ex) {
    println("Error establishing "+dbName+" connection:");
    println(ex.toString().split('\n')[0]);
    if (_sqlbase().isMysql()) {
      println("Perhaps mysql server is not running, or you did not specify "+
	      "proper database credentials with --etherpad.SQL_PASSWORD "+
	      "and --etherpad.SQL_USERNAME?");
    }
    if (_sqlbase().isDerby()) {
      println("Perhaps database directory "+appjet.config.derbyHome+
	      " is not writable?");
    }
    println("Exiting...");
    Packages.java.lang.System.exit(1);
  }
  println(dbName+" connection established.");
}

function onShutdown() {
  _sqlbase().close();
}

function withConnection(f) {
  return _sqlbase().withConnection(scalaF1(f));
}

function inTransaction(f) {
  return _sqlbase().inTransaction(scalaF1(f));
}

function closing(s, f) {
  if (s instanceof java.sql.Connection) {
    throw new java.lang.IllegalArgumentException("Don't want to use 'closing()' on a sql connection!");
  }
  try {
    return f();
  }
  finally {
    s.close();
  }
}

function doesTableExist(table) {
  return withConnection(function(conn) {
    return _sqlbase().doesTableExist(conn, table);
  });
}

function autoIncrementClause() {
  return _sqlbase().autoIncrementClause();
}

function createTableOptions() {
  return _sqlbase().createTableOptions();
}

function btquote(x) { return _sqlbase().quoteIdentifier(x); }

function getSqlBase() { return _sqlbase(); }

function isMysql() { return _sqlbase().isMysql(); }
function isDerby() { return _sqlbase().isDerby(); }