Method main

compat/src/test/nodejs-postgres/runner.js:324–394

(yamlFile)

    }

    async main(yamlFile) {
        const data = yaml.load(fs.readFileSync(yamlFile, 'utf8'));
        const globalVariables = data.variables || {};
        const tests = data.tests || [];

        const port = process.env.PGPORT || 8812;

        // Run all tests twice - once with prepare: false and once with prepare: true
        for (const prepareMode of [true, false]) {
            console.log(`\n=============================`);
            console.log(`Running tests with prepare: ${prepareMode}`);
            console.log(`=============================\n`);
            this.sql = postgres({
                prepare: prepareMode,
                host: 'localhost',
                port: port,
                user: 'admin',
                password: 'quest',
                database: 'qdb',
                // Force UTC timezone
                timezone: 'UTC',
                // Configure custom type parsers
                types: {
                    // Custom parsers for integers to ensure they're returned as numbers
                    int2: {
                        from: [21],
                        parse: value => parseInt(value, 10)
                    },
                    int4: {
                        from: [23],
                        parse: value => parseInt(value, 10)
                    },
                    int8: {
                        from: [20],
                        parse: value => parseInt(value, 10)
                    },
                    // Custom parser for timestamps to match expected microsecond precision
                    timestamp: {
                        from: [1114],
                        parse: value => {
                            // Split on the decimal point if it exists
                            const [dateTimePart, fractionPart = '000000'] = value.split('.');
                            // Pad or truncate to exactly 6 digits
                            const normalizedFraction = (fractionPart + '000000').slice(0, 6);
                            // Replace space with T and add normalized fraction and Z
                            return `${dateTimePart.replace(' ', 'T')}.${normalizedFraction}Z`;
                        }
                    }
                },
                // Error handling
                onnotice: message => console.log(`NOTICE: ${message}`)
            });

            for (const test of tests) {
                const exclusions = test.exclude || [];
                if (exclusions.includes('nodejs-postgres')) {
                    console.log(`Skipping test '${test.name}' because it is excluded for nodejs-postgres.`);
                    continue;