js modularized

1 files changed, 425 insertions, 0 deletions

diff --git a/js/row.js b/js/row.js
new file mode 100644
index 0000000..e09afd5
--- /dev/null
+++ b/js/row.js
@@ -0,0 +1,425 @@
+/* --------------------- table row ( = db column) ------------ */
+
+SQL.Row = OZ.Class().extend(SQL.Visual);
+
+SQL.Row.prototype.init = function(owner, title, data) {
+	this.owner = owner;
+	this.relations = [];
+	this.keys = [];
+	this.selected = false;
+	this.expanded = false;
+	
+	SQL.Visual.prototype.init.apply(this);
+	
+	this.data.type = 0;
+	this.data.size = "";
+	this.data.def = null;
+	this.data.nll = true;
+	this.data.ai = false;
+	this.data.comment = "";
+	
+	if (data) { this.update(data); }
+	this.setTitle(title);
+}
+
+SQL.Row.prototype._build = function() {
+	this.dom.container = OZ.DOM.elm("tbody");
+	
+	this.dom.content = OZ.DOM.elm("tr");
+	this.dom.selected = OZ.DOM.elm("div", {className:"selected",innerHTML:"» "});
+	this.dom.title = OZ.DOM.elm("div", {className:"title"});
+	var td1 = OZ.DOM.elm("td");
+	var td2 = OZ.DOM.elm("td", {className:"typehint"});
+	this.dom.typehint = td2;
+
+	OZ.DOM.append(
+		[this.dom.container, this.dom.content],
+		[this.dom.content, td1, td2],
+		[td1, this.dom.selected, this.dom.title]
+	);
+	
+	this.enter = this.bind(this.enter);
+	this.changeComment = this.bind(this.changeComment);
+
+	OZ.Event.add(this.dom.container, "click",this.bind(this.click));
+	OZ.Event.add(this.dom.container, "dblclick",this.bind(this.dblclick));
+}
+
+SQL.Row.prototype.select = function() {
+	if (this.selected) { return; }
+	this.selected = true;
+	this.redraw();
+}
+
+SQL.Row.prototype.deselect = function() {
+	if (!this.selected) { return; }
+	this.selected = false;
+	this.redraw();
+	this.collapse();
+}
+
+SQL.Row.prototype.setTitle = function(t) {
+	var old = this.getTitle();
+	for (var i=0;i<this.relations.length;i++) {
+		var r = this.relations[i];
+		if (r.row1 != this) { continue; }
+		var tt = r.row2.getTitle().replace(new RegExp(old,"g"),t);
+		if (tt != r.row2.getTitle()) { r.row2.setTitle(tt); }
+	}
+	
+	SQL.Visual.prototype.setTitle.apply(this, [t]);
+}
+
+SQL.Row.prototype.click = function(e) { /* clicked on row */
+	this.dispatch("rowclick", this);
+	this.owner.owner.rowManager.select(this);
+}
+
+SQL.Row.prototype.dblclick = function(e) { /* dblclicked on row */
+	OZ.Event.prevent(e);
+	OZ.Event.stop(e);
+	this.expand();
+}
+
+SQL.Row.prototype.update = function(data) { /* update subset of row data */
+	var des = SQL.Designer;
+	if (data.nll && data.def && data.def.match(/^null$/i)) { data.def = null; }
+	
+	for (var p in data) { this.data[p] = data[p]; }
+	if (!this.data.nll && this.data.def === null) { this.data.def = ""; }
+
+	var elm = this.getDataType();
+	for (var i=0;i<this.relations.length;i++) {
+		var r = this.relations[i];
+		if (r.row1 == this) { r.row2.update({type:des.getFKTypeFor(this.data.type),size:this.data.size}); }
+	}
+	this.redraw();
+}
+
+SQL.Row.prototype.up = function() { /* shift up */
+	var r = this.owner.rows;
+	var idx = r.indexOf(this);
+	if (!idx) { return; }
+	r[idx-1].dom.container.parentNode.insertBefore(this.dom.container,r[idx-1].dom.container);
+	r.splice(idx,1);
+	r.splice(idx-1,0,this);
+	this.redraw();
+}
+
+SQL.Row.prototype.down = function() { /* shift down */
+	var r = this.owner.rows;
+	var idx = r.indexOf(this);
+	if (idx+1 == this.owner.rows.length) { return; }
+	r[idx].dom.container.parentNode.insertBefore(this.dom.container,r[idx+1].dom.container.nextSibling);
+	r.splice(idx,1);
+	r.splice(idx+1,0,this);
+	this.redraw();
+}
+
+SQL.Row.prototype.buildEdit = function() {
+	OZ.DOM.clear(this.dom.container);
+	
+	var elms = [];
+	this.dom.name = OZ.DOM.elm("input");
+	this.dom.name.type = "text";
+	elms.push(["name",this.dom.name]);
+	OZ.Event.add(this.dom.name, "keypress", this.enter);
+
+	this.dom.type = this.buildTypeSelect(this.data.type);
+	elms.push(["type",this.dom.type]);
+
+	this.dom.size = OZ.DOM.elm("input");
+	this.dom.size.type = "text";
+	elms.push(["size",this.dom.size]);
+
+	this.dom.def = OZ.DOM.elm("input");
+	this.dom.def.type = "text";
+	elms.push(["def",this.dom.def]);
+
+	this.dom.ai = OZ.DOM.elm("input");
+	this.dom.ai.type = "checkbox";
+	elms.push(["ai",this.dom.ai]);
+
+	this.dom.nll = OZ.DOM.elm("input");
+	this.dom.nll.type = "checkbox";
+	elms.push(["null",this.dom.nll]);
+	
+	this.dom.comment = OZ.DOM.elm("span",{className:"comment"});
+	this.dom.comment.innerHTML = this.data.comment;
+
+	this.dom.commentbtn = OZ.DOM.elm("input");
+	this.dom.commentbtn.type = "button";
+	this.dom.commentbtn.value = _("comment");
+	
+	OZ.Event.add(this.dom.commentbtn, "click", this.changeComment);
+
+	for (var i=0;i<elms.length;i++) {
+		var row = elms[i];
+		var tr = OZ.DOM.elm("tr");
+		var td1 = OZ.DOM.elm("td");
+		var td2 = OZ.DOM.elm("td");
+		var l = OZ.DOM.text(_(row[0])+": ");
+		OZ.DOM.append(
+			[tr, td1, td2],
+			[td1, l],
+			[td2, row[1]]
+		);
+		this.dom.container.appendChild(tr);
+	}
+	
+	var tr = OZ.DOM.elm("tr");
+	var td1 = OZ.DOM.elm("td");
+	var td2 = OZ.DOM.elm("td");
+	OZ.DOM.append(
+		[tr, td1, td2],
+		[td1, this.dom.comment],
+		[td2, this.dom.commentbtn]
+	);
+	this.dom.container.appendChild(tr);
+}
+
+SQL.Row.prototype.changeComment = function(e) {
+	var c = prompt(_("commenttext"),this.data.comment);
+	if (c === null) { return; }
+	this.data.comment = c;
+	this.dom.comment.innerHTML = this.data.comment;
+}
+
+SQL.Row.prototype.expand = function() {
+	if (this.expanded) { return; }
+	this.expanded = true;
+	this.buildEdit();
+	this.load();
+	this.redraw();
+	this.dom.name.focus();
+	this.dom.name.select();
+}
+
+SQL.Row.prototype.collapse = function() {
+	if (!this.expanded) { return; }
+	this.expanded = false;
+
+	var data = {
+		type: this.dom.type.selectedIndex,
+		def: this.dom.def.value,
+		size: this.dom.size.value,
+		nll: this.dom.nll.checked,
+		ai: this.dom.ai.checked
+	}
+	
+	OZ.DOM.clear(this.dom.container);
+	this.dom.container.appendChild(this.dom.content);
+
+	this.update(data);
+	this.setTitle(this.dom.name.value);
+}
+
+SQL.Row.prototype.load = function() { /* put data to expanded form */
+	this.dom.name.value = this.getTitle();
+	var def = this.data.def;
+	if (def === null) { def = "NULL"; }
+	
+	this.dom.def.value = def;
+	this.dom.size.value = this.data.size;
+	this.dom.nll.checked = this.data.nll;
+	this.dom.ai.checked = this.data.ai;
+}
+
+SQL.Row.prototype.redraw = function() {
+	var color = this.getColor();
+	this.dom.container.style.backgroundColor = color;
+	OZ.DOM.removeClass(this.dom.title, "primary");
+	OZ.DOM.removeClass(this.dom.title, "key");
+	if (this.isPrimary()) { OZ.DOM.addClass(this.dom.title, "primary"); }
+	if (this.isKey()) { OZ.DOM.addClass(this.dom.title, "key"); }
+	this.dom.selected.style.display = (this.selected ? "" : "none");
+	this.dom.container.title = this.data.comment;
+	
+	var typehint = [];
+	if (this.owner.owner.getOption("showtype")) {
+		var elm = this.getDataType();
+		typehint.push(elm.getAttribute("sql"));
+	}
+	
+	if (this.owner.owner.getOption("showsize") && this.data.size) {
+		typehint.push("(" + this.data.size + ")");
+	}
+	
+	this.dom.typehint.innerHTML = typehint.join(" ");
+	this.owner.redraw();
+	this.owner.owner.rowManager.redraw();
+}
+
+SQL.Row.prototype.addRelation = function(r) {
+	this.relations.push(r);
+}
+
+SQL.Row.prototype.removeRelation = function(r) {
+	var idx = this.relations.indexOf(r);
+	if (idx == -1) { return; }
+	this.relations.splice(idx,1);
+}
+
+SQL.Row.prototype.addKey = function(k) {
+	this.keys.push(k);
+	this.redraw();
+}
+
+SQL.Row.prototype.removeKey = function(k) {
+	var idx = this.keys.indexOf(k);
+	if (idx == -1) { return; }
+	this.keys.splice(idx,1);
+	this.redraw();
+}
+
+SQL.Row.prototype.getDataType = function() {
+	var type = this.data.type;
+	var elm = DATATYPES.getElementsByTagName("type")[type];
+	return elm;
+}
+
+SQL.Row.prototype.getColor = function() {
+	var elm = this.getDataType();
+	var g = this.getDataType().parentNode;
+	return elm.getAttribute("color") || g.getAttribute("color") || "#fff";
+}
+
+SQL.Row.prototype.buildTypeSelect = function(id) { /* build selectbox with avail datatypes */
+	var s = OZ.DOM.elm("select");
+	var gs = DATATYPES.getElementsByTagName("group");
+	for (var i=0;i<gs.length;i++) {
+		var g = gs[i];
+		var og = OZ.DOM.elm("optgroup");
+		og.style.backgroundColor = g.getAttribute("color") || "#fff";
+		og.label = g.getAttribute("label");
+		s.appendChild(og);
+		var ts = g.getElementsByTagName("type");
+		for (var j=0;j<ts.length;j++) {
+			var t = ts[j];
+			var o = OZ.DOM.elm("option");
+			if (t.getAttribute("color")) { o.style.backgroundColor = t.getAttribute("color"); }
+			if (t.getAttribute("note")) { o.title = t.getAttribute("note"); }
+			o.innerHTML = t.getAttribute("label");
+			og.appendChild(o);
+		}
+	}
+	s.selectedIndex = id;
+	return s;
+}
+
+SQL.Row.prototype.destroy = function() {
+	SQL.Visual.prototype.destroy.apply(this);
+	while (this.relations.length) {
+		this.owner.owner.removeRelation(this.relations[0]);
+	}
+	for (var i=0;i<this.keys.length;i++){ 
+		this.keys[i].removeRow(this);
+	}
+}
+
+SQL.Row.prototype.toXML = function() {
+	var xml = "";
+	
+	var t = this.getTitle().replace(/"/g,"&quot;");
+	var nn = (this.data.nll ? "1" : "0");
+	var ai = (this.data.ai ? "1" : "0");
+	xml += '<row name="'+t+'" null="'+nn+'" autoincrement="'+ai+'">\n';
+
+	var elm = this.getDataType();
+	var t = elm.getAttribute("sql");
+	if (this.data.size.length) { t += "("+this.data.size+")"; }
+	xml += "<datatype>"+t+"</datatype>\n";
+	
+	if (this.data.def || this.data.def === null) {
+		var q = elm.getAttribute("quote");
+		var d = this.data.def;
+		if (d === null) { 
+			d = "NULL"; 
+		} else if (d != "CURRENT_TIMESTAMP") { 
+			d = q+d+q; 
+		}
+		xml += "<default>"+d+"</default>";
+	}
+
+	for (var i=0;i<this.relations.length;i++) {
+		var r = this.relations[i];
+		if (r.row2 != this) { continue; }
+		xml += '<relation table="'+r.row1.owner.getTitle()+'" row="'+r.row1.getTitle()+'" />\n';
+	}
+	
+	if (this.data.comment) { 
+		var escaped = this.data.comment.replace(/&/g, "&amp;").replace(/>/g, "&gt;").replace(/</g, "&lt;");
+		xml += "<comment>"+escaped+"</comment>\n"; 
+	}
+	
+	xml += "</row>\n";
+	return xml;
+}
+
+SQL.Row.prototype.fromXML = function(node) {
+	var name = node.getAttribute("name");
+	
+	var obj = { type:0, size:"" };
+	obj.nll = (node.getAttribute("null") == "1");
+	obj.ai = (node.getAttribute("autoincrement") == "1");
+	
+	var cs = node.getElementsByTagName("comment");
+	if (cs.length && cs[0].firstChild) { obj.comment = cs[0].firstChild.nodeValue; }
+	
+	var d = node.getElementsByTagName("datatype");
+	if (d.length && d[0].firstChild) { 
+		var s = d[0].firstChild.nodeValue;
+		var r = s.match(/^([^\(]+)(\((.*)\))?.*$/);
+		var type = r[1];
+		if (r[3]) { obj.size = r[3]; }
+		var types = window.DATATYPES.getElementsByTagName("type");
+		for (var i=0;i<types.length;i++) {
+			var sql = types[i].getAttribute("sql");
+			var re = types[i].getAttribute("re");
+			if (sql == type || (re && new RegExp(re).exec(type)) ) { obj.type = i; }
+		}
+	}
+	
+	var elm = DATATYPES.getElementsByTagName("type")[obj.type];
+	var d = node.getElementsByTagName("default");
+	if (d.length && d[0].firstChild) { 
+		var def = d[0].firstChild.nodeValue;
+		obj.def = def;
+		var q = elm.getAttribute("quote");
+		if (q) {
+			var re = new RegExp("^"+q+"(.*)"+q+"$");
+			var r = def.match(re);
+			if (r) { obj.def = r[1]; }
+		}
+	}
+
+	this.update(obj);
+	this.setTitle(name);
+}
+
+SQL.Row.prototype.isPrimary = function() {
+	for (var i=0;i<this.keys.length;i++) {
+		var k = this.keys[i];
+		if (k.getType() == "PRIMARY") { return true; }
+	}
+	return false;
+}
+
+SQL.Row.prototype.isUnique = function() {
+	for (var i=0;i<this.keys.length;i++) {
+		var k = this.keys[i];
+		var t = k.getType();
+		if (t == "PRIMARY" || t == "UNIQUE") { return true; }
+	}
+	return false;
+}
+
+SQL.Row.prototype.isKey = function() {
+	return this.keys.length > 0;
+}
+
+SQL.Row.prototype.enter = function(e) {
+	if (e.keyCode == 13) { 
+		this.collapse();
+	}
+}