private _handleQuery()

in src/SqlProviderBase.ts [1144:1167]

• 20 lines of code
• 8 McCabe index (conditional complexity)

    private _handleQuery(sql: string, args?: any[], reverseOrSortOrder?: boolean | QuerySortOrder, limit?: number,
        offset?: number): Promise<ItemType[]> {
        // Check if we must do some sort of ordering
        if (reverseOrSortOrder !== QuerySortOrder.None) {
            const reverse = reverseOrSortOrder === true || reverseOrSortOrder === QuerySortOrder.Reverse;
            sql += ' ORDER BY ' + this._queryColumn + (reverse ? ' DESC' : ' ASC');
        }

        if (limit) {
            if (limit > LimitMax) {
                if (this._verbose) {
                    console.warn('Limit exceeded in _handleQuery (' + limit + ')');
                }

                limit = LimitMax;
            }
            sql += ' LIMIT ' + limit.toString();
        }
        if (offset) {
            sql += ' OFFSET ' + offset.toString();
        }

        return this._trans.internal_getResultsFromQuery(sql, args);
    }