createQuery()

in salesforce/lib/query-builder.js [56:81]

• 26 lines of code
• 6 McCabe index (conditional complexity)

    createQuery(query) {
        let soql = [
            "SELECT ",
            this.createFieldsClause(query.fields, query.includes),
            " FROM ",
            query.table
        ].join("");
        let cond = this.createConditionClause(query.conditions);
        if (cond) {
            soql += " WHERE " + cond;
        }
        let orderby = this.createOrderByClause(query.sort);
        if (orderby) {
            soql += " ORDER BY " + orderby;
        }
        if (query.limit) {
            soql += " LIMIT " + query.limit;
        }
        if (query.offset) {
            soql += " OFFSET " + query.offset;
        }
        if (query.innerjoin) {
            soql += " WHERE " + query.table + "." + query.innerjoin.parent.field + " IN (SELECT " + query.innerjoin.child.table + "." + query.innerjoin.child.field + " FROM " + query.innerjoin.child.table + " )";
        }
        return soql;
    }