alighasami
3d5eaf9445
Security: Sync from Public / sync-from-public (push) Has been cancelled
Test: Benchmark Nightly / build (push) Has been cancelled
Test: Benchmark Nightly / Notify Cats on failure (push) Has been cancelled
CI: Python / Checks (push) Has been cancelled
Test: Evals Python / Workflow Comparison Python (push) Has been cancelled
Util: Check Docs URLs / check-docs-urls (push) Has been cancelled
Test: Visual Storybook / Cloudflare Pages (push) Has been cancelled
Test: E2E Performance / build-and-test-performance (push) Has been cancelled
Test: Workflows Nightly / Run Workflow Tests (push) Has been cancelled
Util: Cleanup CI Docker Images / Delete stale CI images (push) Has been cancelled
Test: Benchmark Destroy Env / build (push) Has been cancelled
Util: Update Node Popularity / update-popularity (push) Has been cancelled
Test: E2E Coverage Weekly / Coverage Tests (push) Has been cancelled
62 lines
1.6 KiB
TypeScript
62 lines
1.6 KiB
TypeScript
import { NodeTestHarness } from '@nodes-testing/node-test-harness';
|
|
import nock from 'nock';
|
|
|
|
jest.mock('jsonwebtoken', () => ({
|
|
sign: jest.fn().mockReturnValue('signature'),
|
|
}));
|
|
|
|
describe('Test Google BigQuery V2, executeQuery with named parameters', () => {
|
|
nock('https://oauth2.googleapis.com')
|
|
.persist()
|
|
.post(
|
|
'/token',
|
|
'grant_type=urn%3Aietf%3Aparams%3Aoauth%3Agrant-type%3Ajwt-bearer&assertion=signature',
|
|
)
|
|
.reply(200, { access_token: 'token' });
|
|
|
|
nock('https://bigquery.googleapis.com/bigquery')
|
|
.post('/v2/projects/test-project/jobs', {
|
|
configuration: {
|
|
query: {
|
|
queryParameters: [
|
|
{
|
|
name: 'email',
|
|
parameterType: { type: 'STRING' },
|
|
parameterValue: { value: 'test@n8n.io' },
|
|
},
|
|
{
|
|
name: 'name',
|
|
parameterType: { type: 'STRING' },
|
|
parameterValue: { value: 'Test Testerson' },
|
|
},
|
|
{
|
|
name: 'n8n_variable',
|
|
parameterType: { type: 'STRING' },
|
|
parameterValue: { value: 42 },
|
|
},
|
|
],
|
|
query:
|
|
'SELECT * FROM bigquery_node_dev_test_dataset.test_json WHERE email = @email AND name = @name AND n8n_variable = @n8n_variable;',
|
|
useLegacySql: false,
|
|
parameterMode: 'NAMED',
|
|
},
|
|
},
|
|
})
|
|
.reply(200, {
|
|
jobReference: {
|
|
jobId: 'job_123',
|
|
},
|
|
status: {
|
|
state: 'DONE',
|
|
},
|
|
})
|
|
.get('/v2/projects/test-project/queries/job_123')
|
|
.reply(200)
|
|
.get('/v2/projects/test-project/queries/job_123?maxResults=1000&timeoutMs=10000')
|
|
.reply(200, { rows: [], schema: {} });
|
|
|
|
new NodeTestHarness().setupTests({
|
|
workflowFiles: ['executeQuery.queryParameters.workflow.json'],
|
|
});
|
|
});
|