3 /* Copyright (c) 1999-2011 by OpenMFG LLC, d/b/a xTuple.
4 See www.xm.ple.com/CPAL for the full text of the software license. */
6 var sql = "select pkghead_version from pkghead where pkghead_name = 'xt';",
14 result = plv8.execute(sql);
16 pkgVersion = result[0].pkghead_version.split();
17 updVersion = updVersion.split();
18 if (pkgVersion.length === updVersion.length) {
19 while (pkgVersion.length) {
20 if (pkgVersion.shift() < updVersion.shift()) {
28 sql = "select viewname from pg_views where schemaname = 'xm';"
29 result = plv8.execute(sql);
30 for (i = 0; i < result.length; i++) {
31 viewname = result[i].viewname;
32 plv8.execute('drop view if exists xm.' + viewname + ' cascade;');
35 sql = "select viewname from pg_views where schemaname = 'sys';"
36 result = plv8.execute(sql);
37 for (i = 0; i < result.length; i++) {
38 viewname = result[i].viewname;
39 plv8.execute('drop view if exists sys.' + viewname + ' cascade;');
42 plv8.execute("select xt.js_init()");
43 plv8.execute("delete from xt.orm where orm_json ~ '\"isSystem\":true';");