| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198 |
- import { ColumnBuilder } from "../../column-builder.js";
- import { Column } from "../../column.js";
- import { entityKind, is } from "../../entity.js";
- import { ForeignKeyBuilder } from "../foreign-keys.js";
- import { iife } from "../../tracing-utils.js";
- import { uniqueKeyName } from "../unique-constraint.js";
- import { makePgArray, parsePgArray } from "../utils/array.js";
- class PgColumnBuilder extends ColumnBuilder {
- foreignKeyConfigs = [];
- static [entityKind] = "PgColumnBuilder";
- array(size) {
- return new PgArrayBuilder(this.config.name, this, size);
- }
- references(ref, actions = {}) {
- this.foreignKeyConfigs.push({ ref, actions });
- return this;
- }
- unique(name, config) {
- this.config.isUnique = true;
- this.config.uniqueName = name;
- this.config.uniqueType = config?.nulls;
- return this;
- }
- generatedAlwaysAs(as) {
- this.config.generated = {
- as,
- type: "always",
- mode: "stored"
- };
- return this;
- }
- /** @internal */
- buildForeignKeys(column, table) {
- return this.foreignKeyConfigs.map(({ ref, actions }) => {
- return iife(
- (ref2, actions2) => {
- const builder = new ForeignKeyBuilder(() => {
- const foreignColumn = ref2();
- return { columns: [column], foreignColumns: [foreignColumn] };
- });
- if (actions2.onUpdate) {
- builder.onUpdate(actions2.onUpdate);
- }
- if (actions2.onDelete) {
- builder.onDelete(actions2.onDelete);
- }
- return builder.build(table);
- },
- ref,
- actions
- );
- });
- }
- /** @internal */
- buildExtraConfigColumn(table) {
- return new ExtraConfigColumn(table, this.config);
- }
- }
- class PgColumn extends Column {
- constructor(table, config) {
- if (!config.uniqueName) {
- config.uniqueName = uniqueKeyName(table, [config.name]);
- }
- super(table, config);
- this.table = table;
- }
- static [entityKind] = "PgColumn";
- }
- class ExtraConfigColumn extends PgColumn {
- static [entityKind] = "ExtraConfigColumn";
- getSQLType() {
- return this.getSQLType();
- }
- indexConfig = {
- order: this.config.order ?? "asc",
- nulls: this.config.nulls ?? "last",
- opClass: this.config.opClass
- };
- defaultConfig = {
- order: "asc",
- nulls: "last",
- opClass: void 0
- };
- asc() {
- this.indexConfig.order = "asc";
- return this;
- }
- desc() {
- this.indexConfig.order = "desc";
- return this;
- }
- nullsFirst() {
- this.indexConfig.nulls = "first";
- return this;
- }
- nullsLast() {
- this.indexConfig.nulls = "last";
- return this;
- }
- /**
- * ### PostgreSQL documentation quote
- *
- * > An operator class with optional parameters can be specified for each column of an index.
- * The operator class identifies the operators to be used by the index for that column.
- * For example, a B-tree index on four-byte integers would use the int4_ops class;
- * this operator class includes comparison functions for four-byte integers.
- * In practice the default operator class for the column's data type is usually sufficient.
- * The main point of having operator classes is that for some data types, there could be more than one meaningful ordering.
- * For example, we might want to sort a complex-number data type either by absolute value or by real part.
- * We could do this by defining two operator classes for the data type and then selecting the proper class when creating an index.
- * More information about operator classes check:
- *
- * ### Useful links
- * https://www.postgresql.org/docs/current/sql-createindex.html
- *
- * https://www.postgresql.org/docs/current/indexes-opclass.html
- *
- * https://www.postgresql.org/docs/current/xindex.html
- *
- * ### Additional types
- * If you have the `pg_vector` extension installed in your database, you can use the
- * `vector_l2_ops`, `vector_ip_ops`, `vector_cosine_ops`, `vector_l1_ops`, `bit_hamming_ops`, `bit_jaccard_ops`, `halfvec_l2_ops`, `sparsevec_l2_ops` options, which are predefined types.
- *
- * **You can always specify any string you want in the operator class, in case Drizzle doesn't have it natively in its types**
- *
- * @param opClass
- * @returns
- */
- op(opClass) {
- this.indexConfig.opClass = opClass;
- return this;
- }
- }
- class IndexedColumn {
- static [entityKind] = "IndexedColumn";
- constructor(name, keyAsName, type, indexConfig) {
- this.name = name;
- this.keyAsName = keyAsName;
- this.type = type;
- this.indexConfig = indexConfig;
- }
- name;
- keyAsName;
- type;
- indexConfig;
- }
- class PgArrayBuilder extends PgColumnBuilder {
- static [entityKind] = "PgArrayBuilder";
- constructor(name, baseBuilder, size) {
- super(name, "array", "PgArray");
- this.config.baseBuilder = baseBuilder;
- this.config.size = size;
- }
- /** @internal */
- build(table) {
- const baseColumn = this.config.baseBuilder.build(table);
- return new PgArray(
- table,
- this.config,
- baseColumn
- );
- }
- }
- class PgArray extends PgColumn {
- constructor(table, config, baseColumn, range) {
- super(table, config);
- this.baseColumn = baseColumn;
- this.range = range;
- this.size = config.size;
- }
- size;
- static [entityKind] = "PgArray";
- getSQLType() {
- return `${this.baseColumn.getSQLType()}[${typeof this.size === "number" ? this.size : ""}]`;
- }
- mapFromDriverValue(value) {
- if (typeof value === "string") {
- value = parsePgArray(value);
- }
- return value.map((v) => this.baseColumn.mapFromDriverValue(v));
- }
- mapToDriverValue(value, isNestedArray = false) {
- const a = value.map(
- (v) => v === null ? null : is(this.baseColumn, PgArray) ? this.baseColumn.mapToDriverValue(v, true) : this.baseColumn.mapToDriverValue(v)
- );
- if (isNestedArray) return a;
- return makePgArray(a);
- }
- }
- export {
- ExtraConfigColumn,
- IndexedColumn,
- PgArray,
- PgArrayBuilder,
- PgColumn,
- PgColumnBuilder
- };
- //# sourceMappingURL=common.js.map
|