Changeset: 68d6529745f2 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=68d6529745f2
Modified Files:
sql/backends/monet5/sql_upgrades.c
Branch: default
Log Message:
Added boilerplate code for upgrade to next release.
diffs (54 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -1615,6 +1615,35 @@ sql_update_jul2015(Client c)
return err; /* usually MAL_SUCCEED */
}
+#if 0
+static str
+sql_update_dec2015(Client c)
+{
+ size_t bufsize = 10240, pos = 0;
+ char *buf = GDKmalloc(bufsize), *err = NULL;
+ mvc *sql = ((backend*) c->sqlcontext)->mvc;
+ ValRecord *schvar = stack_get_var(sql, "current_schema");
+ char *schema = NULL;
+
+ if (schvar)
+ schema = strdup(schvar->val.sval);
+ pos += snprintf(buf + pos, bufsize - pos, "set schema \"sys\";\n");
+
+/* insert upgrade code here */
+
+ if (schema) {
+ pos += snprintf(buf + pos, bufsize - pos, "set schema
\"%s\";\n", schema);
+ free(schema);
+ }
+ assert(pos < bufsize);
+
+ printf("Running database upgrade commands:\n%s\n", buf);
+ err = SQLstatementIntern(c, &buf, "update", 1, 0, NULL);
+ GDKfree(buf);
+ return err; /* usually MAL_SUCCEED */
+}
+#endif
+
void
SQLupgrades(Client c, mvc *m)
{
@@ -1713,4 +1742,14 @@ SQLupgrades(Client c, mvc *m)
GDKfree(err);
}
}
+
+#if 0
+ /* test for upgrade condition */
+ if (...) {
+ if ((err = sql_update_dec2015(c)) !=NULL) {
+ fprintf(stderr, "!%s\n", err);
+ GDKfree(err);
+ }
+ }
+#endif
}
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
