15132641868

Committed 20 May 2025 08:26AM UTC coverage: 53.287% (+0.4%) from 52.927%

Build # 15132641868

Build Type

push

github

Committed by

alvarobernal2412

Commit Message

test(scopes): added model

Run Details

363 of 758 branches covered (47.89%)

Branch coverage included in aggregate %.

950 of 1706 relevant lines covered (55.69%)

8.59 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/src/controllers/query.controller.js

import { models } from '../models/models.js';
import { getSQLFromSequelize, parseSQLQuery } from '../utils/sqlQueryBuilder.js';
import { handleControllerError } from '../utils/errorHandler.js';

/**
 * Verifies if the specified model is supported
 * @param {string} modelName - Name of the model to verify
 * @returns {boolean} - true if the model is supported, false otherwise
 */
function isModelSupported(modelName) {
  return models && modelName && Object.hasOwn(models, modelName);
}

export async function createQuery(req, res) {
  const { model, operation, options } = req.body;
  
  try {
    if (!isModelSupported(model)) {
      return res.status(400).json({
        success: false,
        message: `Model not supported: ${model}`,
        supportedModels: Object.keys(models)
      });
    }
    
    const response = await getSQLFromSequelize(
      models[model],
      operation,
      options
    );
    return res.status(200).json({
      message: 'SQL query created successfully',
      query: response,
    });
  } catch (error) {
    return handleControllerError(res, error, 'Failed to create SQL query');
  }
}

export async function parseQuery(req, res) {
  try {
    const response = parseSQLQuery(req.body.rawSql);
    return res.status(200).json({
      message: 'SQL query parsed successfully',
      sql: response,
    });
  } catch (error) {
    return handleControllerError(res, error, 'Failed to parse SQL query');
  }
}

1	import { models } from '../models/models.js';
2	import { getSQLFromSequelize, parseSQLQuery } from '../utils/sqlQueryBuilder.js';
3	import { handleControllerError } from '../utils/errorHandler.js';
4
5	/**
6	* Verifies if the specified model is supported
7	* @param {string} modelName - Name of the model to verify
8	* @returns {boolean} - true if the model is supported, false otherwise
9	*/
10	function isModelSupported(modelName) {
11	return models && modelName && Object.hasOwn(models, modelName);	×
12	}
13
14	export async function createQuery(req, res) {
15	const { model, operation, options } = req.body;	×
16
17	try {	×
18	if (!isModelSupported(model)) {	×
19	return res.status(400).json({	×
20	success: false,
21	message: `Model not supported: ${model}`,
22	supportedModels: Object.keys(models)
23	});
24	}
25
26	const response = await getSQLFromSequelize(	×
27	models[model],
28	operation,
29	options
30	);
31	return res.status(200).json({	×
32	message: 'SQL query created successfully',
33	query: response,
34	});
35	} catch (error) {
36	return handleControllerError(res, error, 'Failed to create SQL query');	×
37	}
38	}
39
40	export async function parseQuery(req, res) {
41	try {	×
42	const response = parseSQLQuery(req.body.rawSql);	×
43	return res.status(200).json({	×
44	message: 'SQL query parsed successfully',
45	sql: response,
46	});
47	} catch (error) {
48	return handleControllerError(res, error, 'Failed to parse SQL query');	×
49	}
50	}

statuscompliance / status-backend / 15132641868

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous