Method resolveParameters

compat/src/test/nodejs-postgres/runner.js:81–164

(typedParameters, variables)

    }

    resolveParameters(typedParameters, variables) {
        const resolvedParameters = [];
        for (const param of typedParameters) {
            const type = param.type.toLowerCase();
            let value = param.value;

            if (typeof value === 'string') {
                value = this.substituteVariables(value, variables);
            }

            switch (type) {
                case 'int4':
                case 'int8':
                    resolvedParameters.push(parseInt(value));
                    break;
                case 'float4':
                case 'float8':
                    resolvedParameters.push(parseFloat(value));
                    break;
                case 'boolean':
                    value = String(value).toLowerCase().trim();
                    if (value === 'true') {
                        resolvedParameters.push(true);
                    } else if (value === 'false') {
                        resolvedParameters.push(false);
                    } else {
                        throw new Error(`Invalid boolean value: ${value}`);
                    }
                    break;
                case 'varchar':
                case 'char':
                    resolvedParameters.push(String(value));
                    break;
                case 'timestamp':
                case 'date':
                    resolvedParameters.push(value);
                    break;
                case 'array_float8':
                    // Handle floating point arrays like {-1, 2, 3, 4, 5.42}
                    if (typeof value === 'string') {
                        // Handle empty array case "{}"
                        if (value.trim() === '{}') {
                            resolvedParameters.push([]);
                            break;
                        }

                        // Strip curly braces and split by comma
                        const strippedValue = value.replace(/^\{|\}$/g, '');
                        // Convert each element to float, handling null values
                        const floatArray = strippedValue.split(',').map(item => {
                            const trimmedItem = item.trim();
                            if (!trimmedItem) return undefined;
                            if (trimmedItem.toLowerCase() === 'null') return null;
                            return parseFloat(trimmedItem);
                        }).filter(item => item !== undefined); // Filter out undefined values
                        resolvedParameters.push(floatArray);
                    }
                    // If already an array, ensure all elements are floats or null