Drizzle Team•8mo ago

0 tables

I don't understand why there is there is 0 tables even tho there are 3 exports for 3 different postgres tables ./project/lib/database/schema.ts

import { pgTable, text, json, integer, date, varchar } from "drizzle-orm/pg-core";

export const roles = pgTable('roles', {
    id: varchar('id').primaryKey(),
    roles: json('roles').default([]),
})

export const levels = pgTable('levels', {
    id: varchar('id').primaryKey(),
    level: integer('level'),
    currentXp: integer('current_xp'),
    totalXp: integer('total_xp'),
})

export const bans = pgTable('bans', {
    id: varchar('id').primaryKey(),
    banned: integer('banned'),
    reason: text('reason'),
    expire_date: date('expire_date'),
    expire_time: integer('expire_time'),
})

import { pgTable, text, json, integer, date, varchar } from "drizzle-orm/pg-core";

export const roles = pgTable('roles', {
    id: varchar('id').primaryKey(),
    roles: json('roles').default([]),
})

export const levels = pgTable('levels', {
    id: varchar('id').primaryKey(),
    level: integer('level'),
    currentXp: integer('current_xp'),
    totalXp: integer('total_xp'),
})

export const bans = pgTable('bans', {
    id: varchar('id').primaryKey(),
    banned: integer('banned'),
    reason: text('reason'),
    expire_date: date('expire_date'),
    expire_time: integer('expire_time'),
})

./drizzle.config.ts

import { type Config } from 'drizzle-kit'

export default {
     schema: './project/lib/database/schema.ts',
     out: './drizzle',
     driver: 'pg',
     verbose: true,
     dbCredentials: {
        host: Bun.env.DATABASE_HOST as string,
        port: parseInt(Bun.env.DATABASE_PORT as string),
        user: Bun.env.DATABASE_USER,
        password: Bun.env.DATABASE_PASSWORD,
        database: Bun.env.DATABASE_NAME as string,
        ssl: true,
     },
} satisfies Config

import { type Config } from 'drizzle-kit'

export default {
     schema: './project/lib/database/schema.ts',
     out: './drizzle',
     driver: 'pg',
     verbose: true,
     dbCredentials: {
        host: Bun.env.DATABASE_HOST as string,
        port: parseInt(Bun.env.DATABASE_PORT as string),
        user: Bun.env.DATABASE_USER,
        password: Bun.env.DATABASE_PASSWORD,
        database: Bun.env.DATABASE_NAME as string,
        ssl: true,
     },
} satisfies Config

11 Replies

AlexBrodbelt•4mo ago

I have a similar issue too...

Mario564•4mo ago

Is this your the first migration you're generating with Drizzle Kit or have you done it succcessfully before with the described settings and project structure?