Files
n8n/packages/cli/test/integration/shared/db/data-tables.ts
alighasami 3d5eaf9445
Some checks failed
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
first commit
2026-03-17 16:22:57 +03:30

44 lines
1.4 KiB
TypeScript

import type { CreateDataTableColumnDto } from '@n8n/api-types';
import { randomName } from '@n8n/backend-test-utils';
import type { Project } from '@n8n/db';
import { Container } from '@n8n/di';
import type { DataTableRows } from 'n8n-workflow';
import { DataTableColumnRepository } from '@/modules/data-table/data-table-column.repository';
import { DataTableRowsRepository } from '@/modules/data-table/data-table-rows.repository';
import { DataTableRepository } from '@/modules/data-table/data-table.repository';
export const createDataTable = async (
project: Project,
options: {
name?: string;
columns?: CreateDataTableColumnDto[];
data?: DataTableRows;
updatedAt?: Date;
} = {},
) => {
const dataTableRepository = Container.get(DataTableRepository);
const dataTable = await dataTableRepository.createDataTable(
project.id,
options.name ?? randomName(),
options.columns ?? [],
);
if (options.updatedAt) {
await dataTableRepository.update(dataTable.id, {
updatedAt: options.updatedAt,
});
dataTable.updatedAt = options.updatedAt;
}
if (options.data) {
const dataTableColumnRepository = Container.get(DataTableColumnRepository);
const columns = await dataTableColumnRepository.getColumns(dataTable.id);
const dataTableRowsRepository = Container.get(DataTableRowsRepository);
await dataTableRowsRepository.insertRows(dataTable.id, options.data, columns, 'count');
}
return dataTable;
};