import * as sql from 'mssql'; /** * Initialize the SQL adapter with configuration * @param config Configuration for different service types */ export declare const initializeSQLAdapter: (config: TMSSQLAdapterConfig) => void; /** * Get or create a connection pool for a specific service type * @param serviceType The type of service/database to connect to * @returns A connected SQL connection pool */ export declare const getConnection: (serviceType: string) => Promise; /** * Close all database connections */ export declare const disconnectAll: () => Promise; /** * Execute a raw SQL query * @param props Query properties including service type, SQL query, and parameters * @returns Query results */ export declare const query: (props: TMSSQLQueryProps) => Promise; /** * Get a single row from a table * @param props Properties including service type, table, columns, and where conditions * @returns The first matching row or null if not found */ export declare const getRow: (props: TMSSQLGetRowProps) => Promise; /** * Get multiple rows from a table * @param props Properties including service type, table, columns, where conditions, ordering, and pagination * @returns Array of matching rows */ export declare const getRows: (props: TMSSQLGetRowsProps) => Promise; /** * Get rows from multiple tables * @param props Properties including service type, base table, fields, where conditions, ordering, includes, type, primaryKey, foreignKey and pagination * @returns Object of matching rows and count */ export declare const fetchQueryResult: (props: TMSSQLfetchQueryResultProps) => Promise; /** * Insert a row into a table * @param props Properties including service type, table, data, and whether to return the inserted row * @returns The ID of the inserted row or the full inserted row if returnInserted is true */ export declare const insertRow: (props: TMSSQLInsertRowProps) => Promise; /** * Update rows in a table * @param props Properties including service type, table, data, where conditions, and whether to return updated rows * @returns Boolean success indicator or the updated rows if returnUpdated is true */ export declare const updateRow: (props: TMSSQLUpdateRowProps) => Promise; /** * Delete rows from a table * @param props Properties including service type, table, where conditions, and whether to return deleted rows * @returns Boolean success indicator or the deleted rows if returnDeleted is true */ export declare const deleteRow: (props: TMSSQLDeleteRowProps) => Promise; /** * Execute multiple queries in a transaction * @param serviceType The service type to connect to * @param callback Function that receives a transaction object and executes queries * @returns Result of the callback function */ export declare const withTransaction: (serviceType: string, callback: (transaction: sql.Transaction) => Promise) => Promise; /** * Execute a batch of queries in a single request * @param props Properties including service type and an array of queries * @returns Array of results for each query */ export declare const executeBatch: (props: TMSSQLBatchProps) => Promise; /** * Get the count of rows in a table matching the given conditions * @param props Properties including service type, table, and where conditions * @returns The count of matching rows */ export declare const getRowCount: (props: TMSSQLGetRowProps) => Promise; declare const _default: { initializeSQLAdapter: (config: TMSSQLAdapterConfig) => void; getConnection: (serviceType: string) => Promise; disconnectAll: () => Promise; query: (props: TMSSQLQueryProps) => Promise; getRow: (props: TMSSQLGetRowProps) => Promise; getRows: (props: TMSSQLGetRowsProps) => Promise; fetchQueryResult: (props: TMSSQLfetchQueryResultProps) => Promise; getRowCount: (props: TMSSQLGetRowProps) => Promise; insertRow: (props: TMSSQLInsertRowProps) => Promise; updateRow: (props: TMSSQLUpdateRowProps) => Promise; deleteRow: (props: TMSSQLDeleteRowProps) => Promise; withTransaction: (serviceType: string, callback: (transaction: sql.Transaction) => Promise) => Promise; executeBatch: (props: TMSSQLBatchProps) => Promise; }; export default _default; //# sourceMappingURL=index.d.ts.map