krisrice/ddl.js

## ddl.js
var ddl = (function () {
    function DDL() {
    	this.options = {
    			//columnNamePrefix: "?",
    			"Object Prefix": {value:"a"},
    			Schema: {value:"hr"},
       			"On Delete": {value:'Cascade',check:['Cascade','Restrict','Set Null']},
       			Compression: {value:'No',check:['Yes','No']},
    			"Include Drops": {value:'No',check:['Yes','No']},
    			"Date Data Type":{value:'DATE',check:['DATE','TIMESTAMP','Timestamp with time zone','Timestamp with local time zone']},
    			"Audit Columns": {value:'No',check:['Yes','No']},
    	};
    	this.forest = null;

    	this.find = function( name ) {
    		for( var i = 0; i < this.forest.length; i++ ) {
    			var descendants = this.forest[i].descendants();
    			for( var j = 0; j < descendants.length; j++ ) {
    				var node = descendants[j];
    				if( node.parseName() == name )
    					return node;
    				else if( node.parseName('noprefix=>true') == name )
    					return node;
    			}
    		}
    		return null;
    	};
    	this.translate = function (input, options) {
    		var output = '';

    		this.forest = tree(input);

    		for( var i = 0; i < this.forest.length; i++ ) {
    			output += this.forest[i].toDDL()+'\n';
    		}

    		for( var i = 0; i < this.forest.length; i++ ) {
    			output += this.forest[i].generateData()+'\n';
    		}

    		return output;
    	};
    	this.optionsPopup = function () {
    		if (!window.focus ) return true;

    		var popup = window.open('', 'Options', 'height=500,width=500,scrollbars=yes');

    		var t = window.document.createElement("table");
    		popup.document.body.appendChild(t);


    		for( var key in this.options ) {
    			if( this.options.hasOwnProperty(key) ) {
    				//console.log(key + " -> " + p[key]);
    				var row = t.insertRow(-1);
    				var cell0 = row.insertCell(0);
    				var l = window.document.createElement("label");
    				l.innerHTML = key;
    				cell0.appendChild(l);
    				var cell1 = row.insertCell(1);
    				var i = window.document.createElement("input");
    				i.type = "text";
    				if( this.options[key].check != undefined ) {
    					i = window.document.createElement("select");
    					var values = this.options[key].check;
    					for( var j = 0; j < values.length; j++ ) {
    						var o = window.document.createElement("option");
    						o.text = values[j];
    						i.add(o);
    					}
    				}
    				i.value = this.options[key].value;
    				i.name = key;
    				i.id = key;
    				cell1.appendChild(i);
    			}
    		}


    		var row = t.insertRow(-1);
    		var cell = row.insertCell(0);
    		var s = document.createElement("input");
    		s.type = "submit";
    		s.value = "Submit";
    		s.onclick = function() {
    			var options = ddl.options;
        		for( var key in options ) {
        			if( options.hasOwnProperty(key) ) {
        				options[key].value = popup.document.getElementById(key).value;
        			}
        		}
    			popup.close();
    		};
    		cell.appendChild(s);

    		return true;
    	};

    	this.examplesPopup = function () {
    		if (!window.focus ) return true;

    		var popup = window.open('syntax_and_examples.html');
    	}

       	this.objPrefix = function () {
       		var ret = this.options['Schema'].value;
       		if( '' != ret )
       			ret = ret + '.';
       		ret = ret + this.options["Object Prefix"].value;
       		if( '' != ret )
       			ret = ret + '_';
       		return ret.toUpperCase();
       	}

    	this.tree = function ( input, table ) {
        	var forest = tree(input);
    	    try {
    			table.innerHTML = "";
    			try {
    				for( var i = 0; i < forest.length; i++ )
    				    forest[i].render(table, 0);
    			} catch (err) {
    				var row = table.insertRow(-1);
    				var cell = row.insertCell(0);
    				cell.innerHTML = "<html><font color=red>" + err;
    			}
    		} catch (error) {
    			console.log("Error parsing string statement.->" + error);
    		}
    	}

    }

    return new DDL();
}());
	var ddl = (function () {
	function DDL() {
	this.options = {
	//columnNamePrefix: "?",
	"Object Prefix": {value:"a"},
	Schema: {value:"hr"},
	"On Delete": {value:'Cascade',check:['Cascade','Restrict','Set Null']},
	Compression: {value:'No',check:['Yes','No']},
	"Include Drops": {value:'No',check:['Yes','No']},
	"Date Data Type":{value:'DATE',check:['DATE','TIMESTAMP','Timestamp with time zone','Timestamp with local time zone']},
	"Audit Columns": {value:'No',check:['Yes','No']},
	};
	this.forest = null;

	this.find = function( name ) {
	for( var i = 0; i < this.forest.length; i++ ) {
	var descendants = this.forest[i].descendants();
	for( var j = 0; j < descendants.length; j++ ) {
	var node = descendants[j];
	if( node.parseName() == name )
	return node;
	else if( node.parseName('noprefix=>true') == name )
	return node;
	}
	}
	return null;
	};
	this.translate = function (input, options) {
	var output = '';

	this.forest = tree(input);

	for( var i = 0; i < this.forest.length; i++ ) {
	output += this.forest[i].toDDL()+'\n';
	}

	for( var i = 0; i < this.forest.length; i++ ) {
	output += this.forest[i].generateData()+'\n';
	}

	return output;
	};
	this.optionsPopup = function () {
	if (!window.focus ) return true;

	var popup = window.open('', 'Options', 'height=500,width=500,scrollbars=yes');

	var t = window.document.createElement("table");
	popup.document.body.appendChild(t);


	for( var key in this.options ) {
	if( this.options.hasOwnProperty(key) ) {
	//console.log(key + " -> " + p[key]);
	var row = t.insertRow(-1);
	var cell0 = row.insertCell(0);
	var l = window.document.createElement("label");
	l.innerHTML = key;
	cell0.appendChild(l);
	var cell1 = row.insertCell(1);
	var i = window.document.createElement("input");
	i.type = "text";
	if( this.options[key].check != undefined ) {
	i = window.document.createElement("select");
	var values = this.options[key].check;
	for( var j = 0; j < values.length; j++ ) {
	var o = window.document.createElement("option");
	o.text = values[j];
	i.add(o);
	}
	}
	i.value = this.options[key].value;
	i.name = key;
	i.id = key;
	cell1.appendChild(i);
	}
	}


	var row = t.insertRow(-1);
	var cell = row.insertCell(0);
	var s = document.createElement("input");
	s.type = "submit";
	s.value = "Submit";
	s.onclick = function() {
	var options = ddl.options;
	for( var key in options ) {
	if( options.hasOwnProperty(key) ) {
	options[key].value = popup.document.getElementById(key).value;
	}
	}
	popup.close();
	};
	cell.appendChild(s);

	return true;
	};

	this.examplesPopup = function () {
	if (!window.focus ) return true;

	var popup = window.open('syntax_and_examples.html');
	}

	this.objPrefix = function () {
	var ret = this.options['Schema'].value;
	if( '' != ret )
	ret = ret + '.';
	ret = ret + this.options["Object Prefix"].value;
	if( '' != ret )
	ret = ret + '_';
	return ret.toUpperCase();
	}

	this.tree = function ( input, table ) {
	var forest = tree(input);
	try {
	table.innerHTML = "";
	try {
	for( var i = 0; i < forest.length; i++ )
	forest[i].render(table, 0);
	} catch (err) {
	var row = table.insertRow(-1);
	var cell = row.insertCell(0);
	cell.innerHTML = "<html><font color=red>" + err;
	}
	} catch (error) {
	console.log("Error parsing string statement.->" + error);
	}
	}

	}

	return new DDL();
	}());