import type { INodeProperties } from 'n8n-workflow';

import * as deleteRows from './delete.operation';
import * as rowExists from './rowExists.operation';
import * as rowNotExists from './rowNotExists.operation';
import * as get from './get.operation';
import * as insert from './insert.operation';
import * as update from './update.operation';
import * as upsert from './upsert.operation';
import { DATA_TABLE_RESOURCE_LOCATOR_BASE } from '../../common/fields';

export { insert, get, rowExists, rowNotExists, deleteRows, update, upsert };

export const description: INodeProperties[] = [
	{
		displayName: 'Operation',
		name: 'operation',
		type: 'options',
		noDataExpression: true,
		displayOptions: {
			show: {
				resource: ['row'],
			},
		},
		options: [
			{
				name: 'Delete',
				value: deleteRows.FIELD,
				description: 'Delete row(s)',
				action: 'Delete row(s)',
			},
			{
				name: 'Get',
				value: get.FIELD,
				description: 'Get row(s)',
				action: 'Get row(s)',
				builderHint: {
					propertyHint:
						"There is no `getAll` operation. To fetch many rows, use `operation: 'get'` with `returnAll: true`.",
				},
			},
			{
				name: 'If Row Exists',
				value: rowExists.FIELD,
				description: 'Match input items that are in the data table',
				action: 'If row exists',
			},
			{
				name: 'If Row Does Not Exist',
				value: rowNotExists.FIELD,
				description: 'Match input items that are not in the data table',
				action: 'If row does not exist',
			},
			{
				name: 'Insert',
				value: insert.FIELD,
				description: 'Insert a new row',
				action: 'Insert row',
				builderHint: {
					propertyHint:
						'Row IDs are auto-generated. Do NOT define a custom `id` column or seed `id` on insert. The built-in row `id` is valid for filtering update/delete but is not part of the user-defined table schema.',
				},
			},
			{
				name: 'Update',
				value: update.FIELD,
				description: 'Update row(s) matching certain fields',
				action: 'Update row(s)',
			},
			{
				name: 'Upsert',
				value: upsert.FIELD,
				description: 'Update row(s), or insert if there is no match',
				action: 'Upsert row(s)',
			},
		],
		default: 'insert',
	},
	{
		...DATA_TABLE_RESOURCE_LOCATOR_BASE,
		modes: [
			{
				...DATA_TABLE_RESOURCE_LOCATOR_BASE.modes[0],
				typeOptions: {
					...DATA_TABLE_RESOURCE_LOCATOR_BASE.modes[0].typeOptions,
					allowNewResource: {
						label: 'resourceLocator.dataTable.createNew',
						url: '/projects/{{$projectId}}/datatables/new',
					},
				},
			},
			...DATA_TABLE_RESOURCE_LOCATOR_BASE.modes.slice(1),
		],
		displayOptions: { show: { resource: ['row'] } },
	},
	...deleteRows.description,
	...insert.description,
	...get.description,
	...rowExists.description,
	...rowNotExists.description,
	...update.description,
	...upsert.description,
];