TGTGamer Comments - Answer Overflow

TGTGamer

Explore posts from servers

EEventiva SIASapphire - Imagine a Framework DTDrizzle Team

•Created by TGTGamer on 4/7/2025 in #help

pgTable - extra config (primaryKey) issues

abstraction.ts

import { encircleId } from '@encircle-marketing/crm.utilities.helpers.custom-db-type-encircle-id'
import { idSchema, typeid } from '@encircle-marketing/crm.utilities.helpers.custom-db-type-typeid'
import { BuildExtraConfigColumns, SQL, sql } from 'drizzle-orm'
import {
    customType,
    index,
    PgColumnBuilderBase,
    pgEnum,
    pgTable as drizzlePgTable,
    PgTableExtraConfigValue,
    timestamp,
    uniqueIndex
} from 'drizzle-orm/pg-core'
import { getPgColumnBuilders } from 'drizzle-orm/pg-core/columns/all'
export function pgTable<
    TTableName extends string,
    TColumnsKey extends string,
    TColumnsMap extends Record<TColumnsKey, PgColumnBuilderBase>
> (
    name: TTableName,
    columns: ( columnTypes: AllBuilders ) => TColumnsMap,
    extraConfig?: ( self: BuildExtraConfigColumns<TTableName, TColumnsMap, 'pg'> ) => PgTableExtraConfigValue[]
) {
    const result = drizzlePgTable(
        name,
        ( db ) => columns( {
            ...db,
            encircleId,
            typeid
        } ),
        ( table ) => {
            const extra = extraConfig
                ? extraConfig( table )
                : []

            return [
                ...extra
            ]
        }
    )
    return result
}

import { encircleId } from '@encircle-marketing/crm.utilities.helpers.custom-db-type-encircle-id'
import { idSchema, typeid } from '@encircle-marketing/crm.utilities.helpers.custom-db-type-typeid'
import { BuildExtraConfigColumns, SQL, sql } from 'drizzle-orm'
import {
    customType,
    index,
    PgColumnBuilderBase,
    pgEnum,
    pgTable as drizzlePgTable,
    PgTableExtraConfigValue,
    timestamp,
    uniqueIndex
} from 'drizzle-orm/pg-core'
import { getPgColumnBuilders } from 'drizzle-orm/pg-core/columns/all'
export function pgTable<
    TTableName extends string,
    TColumnsKey extends string,
    TColumnsMap extends Record<TColumnsKey, PgColumnBuilderBase>
> (
    name: TTableName,
    columns: ( columnTypes: AllBuilders ) => TColumnsMap,
    extraConfig?: ( self: BuildExtraConfigColumns<TTableName, TColumnsMap, 'pg'> ) => PgTableExtraConfigValue[]
) {
    const result = drizzlePgTable(
        name,
        ( db ) => columns( {
            ...db,
            encircleId,
            typeid
        } ),
        ( table ) => {
            const extra = extraConfig
                ? extraConfig( table )
                : []

            return [
                ...extra
            ]
        }
    )
    return result
}

table.ts

import { pgTable } from '@encircle-marketing/crm.entities.abstraction'
import { record, recordTableName } from '@encircle-marketing/crm.entities.db.drizzle.schema.record'
import { primaryKey } from 'drizzle-orm/pg-core'

export const recordsToRecords = pgTable(
    recordsToRecordsTableName,
    ( db ) => ( {
        sourceId: db.typeid( 'source_id', { type: recordTableName } )
            .notNull()
            .references( () => record.id ),
        competitorId: db.typeid( 'matched_id', { type: recordTableName } )
            .notNull()
            .references( () => record.id )
    } ),
    ( table ) => [
        primaryKey( { columns: [ table.sourceId, table.competitorId ] } )
    ]
)

import { pgTable } from '@encircle-marketing/crm.entities.abstraction'
import { record, recordTableName } from '@encircle-marketing/crm.entities.db.drizzle.schema.record'
import { primaryKey } from 'drizzle-orm/pg-core'

export const recordsToRecords = pgTable(
    recordsToRecordsTableName,
    ( db ) => ( {
        sourceId: db.typeid( 'source_id', { type: recordTableName } )
            .notNull()
            .references( () => record.id ),
        competitorId: db.typeid( 'matched_id', { type: recordTableName } )
            .notNull()
            .references( () => record.id )
    } ),
    ( table ) => [
        primaryKey( { columns: [ table.sourceId, table.competitorId ] } )
    ]
)

3 replies

DTDrizzle Team

•Created by TGTGamer on 4/7/2025 in #help

pgTable - extra config (primaryKey) issues

TS2769: No overload matches this call. 

Overload 1 of 2, '(config: { name?: string; columns: [AnyPgColumn<{ tableName: string; }>, ...AnyPgColumn<{ tableName: string; }>[]]; }): PrimaryKeyBuilder', gave the following error. Type 'ExtraConfigColumn<ColumnBaseConfig<ColumnDataType, string>>' is not assignable to type 'AnyPgColumn<{ tableName: string; }>' with 'exactOptionalPropertyTypes: true'. Consider adding 'undefined' to the types of the targets properties. The types of 'table._.config.columns' are incompatible between these types.

Type 'Record<string, import(".../drizzle-orm/pg-core/columns/common", { with: { "resoluti
on-mode": "import" } }).PgColumn<import("...' is not assignable to type 'Record<string, import(".../drizzle-orm/pg-core/columns/common").PgColumn<import("...'.
          'string' index signatures are incompatible.
            Type 'import(".../drizzle-orm/pg-core/columns/common", { with: { "resolution-mode": "
import" } }).PgColumn<import("...' is not assignable to type 'import(".../drizzle-orm/pg-core/columns/common").PgColumn<import("...' with 'exactOptionalPropertyTypes: true'. Consider adding 'undefined' to the types of the target's properties.
              Property 'config' is protected but type 'Column<T, TRuntimeConfig, TTypeConfig>' is not a class derived from 'Column<T, TRuntimeConfig, TTypeConfig>'.


Overload 2 of 2, '(...columns: AnyPgColumn<{ tableName: string; }>[]): PrimaryKeyBuilder', gave the following error. Object literal may only specify known properties, and 'columns' does not exist in type 'PgColumn<Required<Update<ColumnBaseConfig<ColumnDataType, string>, { tableName: string; }>>, {}, {}>'.

29 primaryKey( { columns: [ table.sourceId, table.competitorId ] } )

TS2769: No overload matches this call. 

Overload 1 of 2, '(config: { name?: string; columns: [AnyPgColumn<{ tableName: string; }>, ...AnyPgColumn<{ tableName: string; }>[]]; }): PrimaryKeyBuilder', gave the following error. Type 'ExtraConfigColumn<ColumnBaseConfig<ColumnDataType, string>>' is not assignable to type 'AnyPgColumn<{ tableName: string; }>' with 'exactOptionalPropertyTypes: true'. Consider adding 'undefined' to the types of the targets properties. The types of 'table._.config.columns' are incompatible between these types.

Type 'Record<string, import(".../drizzle-orm/pg-core/columns/common", { with: { "resoluti
on-mode": "import" } }).PgColumn<import("...' is not assignable to type 'Record<string, import(".../drizzle-orm/pg-core/columns/common").PgColumn<import("...'.
          'string' index signatures are incompatible.
            Type 'import(".../drizzle-orm/pg-core/columns/common", { with: { "resolution-mode": "
import" } }).PgColumn<import("...' is not assignable to type 'import(".../drizzle-orm/pg-core/columns/common").PgColumn<import("...' with 'exactOptionalPropertyTypes: true'. Consider adding 'undefined' to the types of the target's properties.
              Property 'config' is protected but type 'Column<T, TRuntimeConfig, TTypeConfig>' is not a class derived from 'Column<T, TRuntimeConfig, TTypeConfig>'.


Overload 2 of 2, '(...columns: AnyPgColumn<{ tableName: string; }>[]): PrimaryKeyBuilder', gave the following error. Object literal may only specify known properties, and 'columns' does not exist in type 'PgColumn<Required<Update<ColumnBaseConfig<ColumnDataType, string>, { tableName: string; }>>, {}, {}>'.

29 primaryKey( { columns: [ table.sourceId, table.competitorId ] } )

3 replies

DTDrizzle Team

•Created by TGTGamer on 2/25/2025 in #help

Running db.execute on the read replica?

3 replies

DTDrizzle Team

•Created by TGTGamer on 2/25/2025 in #help

Running db.execute on the read replica?

The code (note using TS Effect but the drizzle side of things should be roughly the same)

3 replies

DTDrizzle Team

•Created by A_Dev on 10/22/2024 in #help

Pgschema

Simply make sure the drizzle definitions have the table included. You can either use the cli to generate these from your database or define the schema using the schema options: https://orm.drizzle.team/docs/schemas

2 replies

DTDrizzle Team

•Created by Kelvin on 9/7/2024 in #help

Creating migrations while using ES Modules fails with error `Cannot find module '<filename>.js`

Not sure if you fixed, but double check your moduleResolution as that was what got me with this issue. Solved by using NodeNext or Node instead of ESNext, ES2021 etc...

3 replies

SIASapphire - Imagine a Framework