DT
Drizzle Team•16mo ago
Seifeddine LARGAT

Define shared columns

hello , please i'm trying to create some shared columns definition in able to be used in multiple tables . my file structure : -> database/tables/<table_name>.ts : containing table definition + relations + schemas + types -> database/tables/utils.ts: containing the shared functions + columns definitions -> database/tables/index.ts : export all the tables + utils here is where i define the shared columns : ( database/tables/utils.ts) 
const tokenCols = {
    id: serial('id').primaryKey(),
    userId: text('user_id')
        .notNull()
        .references(() => usersTable.id, { onDelete: 'cascade' }),
    email: text('email').notNull(),
    token: text('token').notNull(),
    expiresAt: timestamp('expires_at', { withTimezone: true, mode: 'date' }).notNull()
};

const timestampsCols = {
    createdAt: timestamp('created_at', { mode: 'date' }).notNull().defaultNow(),
    updatedAt: timestamp('updated_at', { mode: 'date' }).$onUpdate(() => new Date())
};

const coordinatesCols = {
    latitude: text('latitude'),
    longitude: text('longitude')
};

function lower(email: AnyPgColumn): SQL {
    return sql`lower(${email})`;
}

export {lower, coordinatesCols, timestampsCols, tokenCols };
const tokenCols = {
    id: serial('id').primaryKey(),
    userId: text('user_id')
        .notNull()
        .references(() => usersTable.id, { onDelete: 'cascade' }),
    email: text('email').notNull(),
    token: text('token').notNull(),
    expiresAt: timestamp('expires_at', { withTimezone: true, mode: 'date' }).notNull()
};

const timestampsCols = {
    createdAt: timestamp('created_at', { mode: 'date' }).notNull().defaultNow(),
    updatedAt: timestamp('updated_at', { mode: 'date' }).$onUpdate(() => new Date())
};

const coordinatesCols = {
    latitude: text('latitude'),
    longitude: text('longitude')
};

function lower(email: AnyPgColumn): SQL {
    return sql`lower(${email})`;
}

export {lower, coordinatesCols, timestampsCols, tokenCols };
error: 
Cannot access 'timestampsCols' before initialization
Cannot access 'timestampsCols' before initialization
3 Replies
rphlmr ⚡
rphlmr ⚡•16mo ago
Hello, when does this error occur? Here a demo of shared columns https://drizzle.run/hoec133o0ktmw3hndjm0qkx0
Drizzle Run
Shared columns - Drizzle Run
rphlmr ⚡
rphlmr ⚡•16mo ago
If you have a circular dependencies, is it possible that you import utils.ts from index.ts in your tables? You can't do that since utils.ts is also imported in index.ts
Seifeddine LARGAT
Seifeddine LARGATOP•16mo ago
thanks Raphaël for the quick response , I've just rescanned my tables and i've found a nasty '.' thanks for mentioning that🙏🏻

Did you find this page helpful?