SQL to Java Code Generator Code

function resultMapId(table) {
    var result = "";

    result += "rm";
    result += convertor.convertToClass(table.name);

    return result;
}

function pkWhereClauseId(table) {
    var result = "";
    
    result += "pkw";
    result += convertor.convertToClass(table.name);
    
    return result;
}

/**
 * Check if we need to print the resultmap line
 *
 * The line should only be printed non-additional columns or additional columns
 * who's parent is a table of the type 'TABLE'.
 *
 * If this column has a reference, the reference may only have one primary key
 */
function shouldPrintRmLine(column) {
    var result = false;
    
    result = ((column.table.type.equalsIgnoreCase("TABLE")) || 
              (! column.additional));
    
    if (column.hasReference())
        result = result && column.reference.table.primaryKeys.size() <= 1;
    
    return result;
}

function selectFields(table) {
    var result = "";
    var iter = table.columns.values().iterator();
    
    counter = 0;

    while (iter.hasNext()) {
        column = iter.next();
        name = "";

        if (column.isAdditional())
            log.info("Adding Additional column : " + column);
        
        if (counter++ > 0)
            result += ",\n               ";
        
        name += column.table.name;
        name += ".";
        name += column.name;
        
        result += convertor.convertToSql(name);
    }
    
    return result;
}

function nextValueSql(entity) {
    var result = "";
    
    naming = util.createParameterizedString(database.sequenceStrategy.sql);
    
    if (entity instanceof net.sf.sql2java.common.beans.Schema) {
        naming.addParameter("schema", entity.name);
    } else if (entity instanceof net.sf.sql2java.common.beans.Table) {
        naming.addParameter("schema", entity.schema.name);
        naming.addParameter("table", entity.name);
    } else if (entity instanceof net.sf.sql2java.common.beans.Column) {
        naming.addParameter("schema", entity.table.schema.name);
        naming.addParameter("table", entity.table.name);
        naming.addParameter("column", entity.name);
    }
    
    return naming.parse();
}

function insertFields(table) {
    var result = "";
    var counter = 0;
    
    var iter = table.columns.values().iterator();
    
    while (iter.hasNext()) {
        column = iter.next();

        if (! column.isAdditional()) {
            if (counter++ > 0)
                result += ",\n            ";

            result += convertor.convertToSql(column.name);
        }
    }
    
    return result;
}

function insertValues(table) {
    var result = "";
    var counter = 0;
    
    var iter = table.columns.values().iterator();
    
    while (iter.hasNext()) {
        column = iter.next();

        if (! column.isAdditional()) {
            if (counter++ > 0)
                result += ",\n            ";

            result += ("#" + convertor.convertToVariable(column.name) + "#");
        }
    }
    
    return result;
}

function updateItems(table) {
    var result = "";
    var counter = 0;
    
    var iter = table.columns.values().iterator();
    
    while (iter.hasNext()) {
        column = iter.next();

        if (! column.isAdditional()) {
            if (counter++ > 0)
                result += ",\n               ";

            result += convertor.convertToSql(column.name);
            result += " = "
            result += ("#" + convertor.convertToVariable(column.name) + "#");
        }
    }
    
    return result;
}

function deEscapeSql(input) {
    if (input.startsWith("\""))
        input = input.substring(1);
    
    if (input.endsWith("\""))
        input = input.substring(0, input.size() - 1);
    
    return input;
}
    




























/*




function beanPackage(table) {
    var result = "";
    
    template = templates.getTemplate("tmpBean");
    
    result += templates.basePackage;
    result += ".";
    result += template.generationPackage;
    
    return result;
}

function fullPathUrlToMap(table) {
    var result = "";
        
    template = templates.getTemplate("tmpSqlMap");
    
    r = new net.sf.sql2java.generator.ResourceNaming();
    r.append(application.getTemplateManager().getBasePackage());
    r.append(template.getTargetPackage());
    r.append(template.getTargetFilename());
    
    naming = new net.sf.sql2java.generator.Naming(r.getAsFilePath());
    
    naming.addParameter("table", table.getName());
    naming.addParameter("schema", table.getSchema().getName());
    
    result = naming.parse();

    result += (template.getTargetExtension());

    return result;
}



// -- Result Maps -------------------------------------------------------------



// -- Selects -----------------------------------------------------------------

function pkSelectFields(pkColumn) {
    var result = "";
    
    result += pkColumn.fullName;
    
    return result;
}



// -- Insert ------------------------------------------------------------------

function insertFields(table) {
    var result = "";
    var counter = 0;
    
    var iter = table.columns.values().iterator();
    
    while (iter.hasNext()) {
        column = iter.next();

        if (! column.isAdditional()) {
            if (counter++ > 0)
                result += ",\n            ";

            result += column.name;
        }
    }
    
    return result;
}

function insertValues(table) {
    var result = "";
    var counter = 0;
    
    var iter = table.columns.values().iterator();
    
    while (iter.hasNext()) {
        column = iter.next();

        if (! column.isAdditional()) {
            if (counter++ > 0)
                result += ",\n            ";

            result += ("#" + util.variable(column.name) + "#");
        }
    }
    
    return result;
}

// -- Update ------------------------------------------------------------------

function updateItems(table) {
    var result = "";
    var counter = 0;
    
    var iter = table.columns.values().iterator();
    
    while (iter.hasNext()) {
        column = iter.next();

        if (! column.isAdditional()) {
            if (counter++ > 0)
                result += ",\n               ";

            result += column.name;
            result += " = "
            result += ("#" + util.variable(column.name) + "#");
        }
    }
    
    return result;
}
 */