table.d.cts 4.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  1. import type { BuildColumns, BuildExtraConfigColumns } from "../column-builder.cjs";
  2. import { entityKind } from "../entity.cjs";
  3. import { Table, type TableConfig as TableConfigBase, type UpdateTableConfig } from "../table.cjs";
  4. import type { CheckBuilder } from "./checks.cjs";
  5. import { type PgColumnsBuilders } from "./columns/all.cjs";
  6. import type { PgColumn, PgColumnBuilderBase } from "./columns/common.cjs";
  7. import type { ForeignKeyBuilder } from "./foreign-keys.cjs";
  8. import type { AnyIndexBuilder } from "./indexes.cjs";
  9. import type { PgPolicy } from "./policies.cjs";
  10. import type { PrimaryKeyBuilder } from "./primary-keys.cjs";
  11. import type { UniqueConstraintBuilder } from "./unique-constraint.cjs";
  12. export type PgTableExtraConfigValue = AnyIndexBuilder | CheckBuilder | ForeignKeyBuilder | PrimaryKeyBuilder | UniqueConstraintBuilder | PgPolicy;
  13. export type PgTableExtraConfig = Record<string, PgTableExtraConfigValue>;
  14. export type TableConfig = TableConfigBase<PgColumn>;
  15. export declare class PgTable<T extends TableConfig = TableConfig> extends Table<T> {
  16. static readonly [entityKind]: string;
  17. }
  18. export type AnyPgTable<TPartial extends Partial<TableConfig> = {}> = PgTable<UpdateTableConfig<TableConfig, TPartial>>;
  19. export type PgTableWithColumns<T extends TableConfig> = PgTable<T> & {
  20. [Key in keyof T['columns']]: T['columns'][Key];
  21. } & {
  22. enableRLS: () => Omit<PgTableWithColumns<T>, 'enableRLS'>;
  23. };
  24. export interface PgTableFn<TSchema extends string | undefined = undefined> {
  25. <TTableName extends string, TColumnsMap extends Record<string, PgColumnBuilderBase>>(name: TTableName, columns: TColumnsMap, extraConfig?: (self: BuildExtraConfigColumns<TTableName, TColumnsMap, 'pg'>) => PgTableExtraConfigValue[]): PgTableWithColumns<{
  26. name: TTableName;
  27. schema: TSchema;
  28. columns: BuildColumns<TTableName, TColumnsMap, 'pg'>;
  29. dialect: 'pg';
  30. }>;
  31. <TTableName extends string, TColumnsMap extends Record<string, PgColumnBuilderBase>>(name: TTableName, columns: (columnTypes: PgColumnsBuilders) => TColumnsMap, extraConfig?: (self: BuildExtraConfigColumns<TTableName, TColumnsMap, 'pg'>) => PgTableExtraConfigValue[]): PgTableWithColumns<{
  32. name: TTableName;
  33. schema: TSchema;
  34. columns: BuildColumns<TTableName, TColumnsMap, 'pg'>;
  35. dialect: 'pg';
  36. }>;
  37. /**
  38. * @deprecated The third parameter of pgTable is changing and will only accept an array instead of an object
  39. *
  40. * @example
  41. * Deprecated version:
  42. * ```ts
  43. * export const users = pgTable("users", {
  44. * id: integer(),
  45. * }, (t) => ({
  46. * idx: index('custom_name').on(t.id)
  47. * }));
  48. * ```
  49. *
  50. * New API:
  51. * ```ts
  52. * export const users = pgTable("users", {
  53. * id: integer(),
  54. * }, (t) => [
  55. * index('custom_name').on(t.id)
  56. * ]);
  57. * ```
  58. */
  59. <TTableName extends string, TColumnsMap extends Record<string, PgColumnBuilderBase>>(name: TTableName, columns: TColumnsMap, extraConfig: (self: BuildExtraConfigColumns<TTableName, TColumnsMap, 'pg'>) => PgTableExtraConfig): PgTableWithColumns<{
  60. name: TTableName;
  61. schema: TSchema;
  62. columns: BuildColumns<TTableName, TColumnsMap, 'pg'>;
  63. dialect: 'pg';
  64. }>;
  65. /**
  66. * @deprecated The third parameter of pgTable is changing and will only accept an array instead of an object
  67. *
  68. * @example
  69. * Deprecated version:
  70. * ```ts
  71. * export const users = pgTable("users", {
  72. * id: integer(),
  73. * }, (t) => ({
  74. * idx: index('custom_name').on(t.id)
  75. * }));
  76. * ```
  77. *
  78. * New API:
  79. * ```ts
  80. * export const users = pgTable("users", {
  81. * id: integer(),
  82. * }, (t) => [
  83. * index('custom_name').on(t.id)
  84. * ]);
  85. * ```
  86. */
  87. <TTableName extends string, TColumnsMap extends Record<string, PgColumnBuilderBase>>(name: TTableName, columns: (columnTypes: PgColumnsBuilders) => TColumnsMap, extraConfig: (self: BuildExtraConfigColumns<TTableName, TColumnsMap, 'pg'>) => PgTableExtraConfig): PgTableWithColumns<{
  88. name: TTableName;
  89. schema: TSchema;
  90. columns: BuildColumns<TTableName, TColumnsMap, 'pg'>;
  91. dialect: 'pg';
  92. }>;
  93. }
  94. export declare const pgTable: PgTableFn;
  95. export declare function pgTableCreator(customizeTableName: (name: string) => string): PgTableFn;