sequencesTypes.ts

import type {
  DropOptions,
  IfNotExistsOption,
  Name,
  Type,
} from './generalTypes';

export interface SequenceOptions {
  type?: Type;

  increment?: number;

  minvalue?: number | null | false;

  maxvalue?: number | null | false;

  start?: number;

  cache?: number;

  cycle?: boolean;

  owner?: string | null | false;
}

export interface SequenceOptionsCreate
  extends SequenceOptions,
    IfNotExistsOption {
  temporary?: boolean;
}

export interface SequenceOptionsAlter extends SequenceOptions {
  restart?: number | true;
}

type CreateSequenceFn = (
  sequenceName: Name,
  sequenceOptions?: SequenceOptionsCreate & DropOptions
) => string | string[];

export type CreateSequence = CreateSequenceFn & { reverse: CreateSequenceFn };

export type DropSequence = (
  sequenceName: Name,
  dropOptions?: DropOptions
) => string | string[];

export type AlterSequence = (
  sequenceName: Name,
  sequenceOptions: SequenceOptionsAlter
) => string | string[];

type RenameSequenceFn = (
  oldSequenceName: Name,
  newSequenceName: Name
) => string | string[];

export type RenameSequence = RenameSequenceFn & { reverse: RenameSequenceFn };