data-access-object-agent.interface.ts

import { Stream } from 'node:stream';
import { AutocompleteFieldsDS } from '../../data-access-layer/shared/data-structures/autocomplete-fields.ds.js';
import { FilteringFieldsDS } from '../../data-access-layer/shared/data-structures/filtering-fields.ds.js';
import { ForeignKeyDS } from '../../data-access-layer/shared/data-structures/foreign-key.ds.js';
import { FoundRowsDS } from '../../data-access-layer/shared/data-structures/found-rows.ds.js';
import { PrimaryKeyDS } from '../../data-access-layer/shared/data-structures/primary-key.ds.js';
import { ReferencedTableNamesAndColumnsDS } from '../../data-access-layer/shared/data-structures/referenced-table-names-columns.ds.js';
import { TableDS } from '../../data-access-layer/shared/data-structures/table.ds.js';
import { TableSettingsDS } from '../../data-access-layer/shared/data-structures/table-settings.ds.js';
import { TableStructureDS } from '../../data-access-layer/shared/data-structures/table-structure.ds.js';
import { TestConnectionResultDS } from '../../data-access-layer/shared/data-structures/test-result-connection.ds.js';
import { ValidateTableSettingsDS } from '../../data-access-layer/shared/data-structures/validate-table-settings.ds.js';

export interface IDataAccessObjectAgent {
	addRowInTable(
		tableName: string,
		row: Record<string, unknown>,
		userEmail: string,
	): Promise<Record<string, unknown> | number>;

	deleteRowInTable(
		tableName: string,
		primaryKey: Record<string, unknown>,
		userEmail: string,
	): Promise<Record<string, unknown>>;

	getIdentityColumns(
		tableName: string,
		referencedFieldName: string,
		identityColumnName: string,
		fieldValues: Array<string | number>,
		userEmail: string,
	): Promise<Array<Record<string, unknown>>>;

	getRowByPrimaryKey(
		tableName: string,
		primaryKey: Record<string, unknown>,
		settings: TableSettingsDS,
		userEmail: string,
	): Promise<Record<string, unknown>>;

	bulkGetRowsFromTableByPrimaryKeys(
		tableName: string,
		primaryKeys: Array<Record<string, unknown>>,
		settings: TableSettingsDS,
		userEmail: string,
	): Promise<Array<Record<string, unknown>>>;

	getRowsFromTable(
		tableName: string,
		settings: TableSettingsDS,
		page: number,
		perPage: number,
		searchedFieldValue: string,
		filteringFields: Array<FilteringFieldsDS>,
		autocompleteFields: AutocompleteFieldsDS,
		tableStructure: TableStructureDS[] | null,
		userEmail: string,
	): Promise<FoundRowsDS>;

	getTableForeignKeys(tableName: string, userEmail: string): Promise<Array<ForeignKeyDS>>;

	getTablePrimaryColumns(tableName: string, userEmail: string): Promise<Array<PrimaryKeyDS>>;

	getTablesFromDB(userEmail?: string): Promise<Array<TableDS>>;

	getTableStructure(tableName: string, userEmail: string): Promise<Array<TableStructureDS>>;

	getTableStructureWithoutCache(tableName: string, userEmail: string): Promise<Array<TableStructureDS>>;

	invalidateMetadataCache(): void;

	testConnect(): Promise<TestConnectionResultDS>;

	updateRowInTable(
		tableName: string,
		row: Record<string, unknown>,
		primaryKey: Record<string, unknown>,
		userEmail: string,
	): Promise<Record<string, unknown>>;

	bulkUpdateRowsInTable(
		tableName: string,
		newValues: Record<string, unknown>,
		primaryKeys: Array<Record<string, unknown>>,
		userEmail: string,
	): Promise<Array<Record<string, unknown>>>;

	bulkDeleteRowsInTable(
		tableName: string,
		primaryKeys: Array<Record<string, unknown>>,
		userEmail: string,
	): Promise<number>;

	validateSettings(settings: ValidateTableSettingsDS, tableName: string, userEmail: string): Promise<Array<string>>;

	getReferencedTableNamesAndColumns(
		tableName: string,
		userEmail: string,
	): Promise<Array<ReferencedTableNamesAndColumnsDS>>;

	isView(tableName: string, userEmail: string): Promise<boolean>;

	getTableRowsStream(
		tableName: string,
		settings: TableSettingsDS,
		page: number,
		perPage: number,
		searchedFieldValue: string,
		filteringFields: Array<FilteringFieldsDS>,
	): Promise<Stream & AsyncIterable<never>>;

	importCSVInTable(file: Express.Multer.File, tableName: string, userEmail: string): Promise<void>;

	executeRawQuery(query: string, tableName: string, userEmail: string): Promise<Array<Record<string, unknown>>>;

	getSchemaHash(userEmail: string): Promise<string>;
}