import type { Pipeline } from '@naturalcycles/nodejs-lib/stream';
import type { CommonDBCreateOptions } from '../db.model.js';
import type { CommonKeyValueDBSaveBatchOptions, CommonKeyValueDBSupport, IncrementTuple, KeyValueDBTuple } from './commonKeyValueDB.js';
/**
 * Common interface for Synchronous Key-Value database implementations.
 * Same as CommonKeyValueDB, but with a sync implementation,
 * modeled after e.g SQLite in Node.js, which is designed to be sync.
 *
 * Methods use `Sync` postfix to allow one implementation to support
 * both async and sync CommonKeyValueDB interfaces.
 *
 * @experimental
 */
export interface CommonSyncKeyValueDB {
    /**
     * Manifest of supported features.
     */
    support: CommonKeyValueDBSupport;
    /**
     * Check that DB connection is working properly.
     */
    pingSync: () => void;
    /**
     * Will do like `create table ...` for mysql.
     * Caution! dropIfExists defaults to false. If set to true - will actually DROP the table!
     */
    createTableSync: (table: string, opt?: CommonDBCreateOptions) => void;
    /**
     * Returns an array of tuples [key, value]. Not found values are not returned (no error is thrown).
     *
     * Currently it is NOT required to maintain the same order as input `ids`.
     */
    getByIdsSync: (table: string, ids: string[]) => KeyValueDBTuple[];
    deleteByIdsSync: (table: string, ids: string[]) => void;
    saveBatchSync: (table: string, entries: KeyValueDBTuple[], opt?: CommonKeyValueDBSaveBatchOptions) => void;
    streamIds: (table: string, limit?: number) => Pipeline<string>;
    streamValues: (table: string, limit?: number) => Pipeline<Buffer>;
    streamEntries: (table: string, limit?: number) => Pipeline<KeyValueDBTuple>;
    countSync: (table: string) => number;
    /**
     * Perform a batch of Increment operations.
     * Given entries array, increment each key of it (1st index of the tuple) by the given amount (2nd index of the tuple).
     *
     * Example:
     * [
     *   ['key1', 2],
     *   ['key2', 3],
     * ]
     * would increment `key1` by 2, and `key2` by 3.
     *
     * Returns the entries array with tuples of the same structure, with updated numbers.
     *
     * @experimental
     */
    incrementBatchSync: (table: string, entries: IncrementTuple[]) => IncrementTuple[];
}