introspect not finding tables for pg database

Hi all.

Contributing to an OSS project https://github.com/codu-code/codu and we are migrating from prisma to drizzle.

We have built the drizzle schema manually but its not 100% correct as we are having issues migrating some of our DB queries.

Ideally we would like to have drizzle kit create the schema definition for us using

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

However when we run this, it ignores the tables and only pulls the enums from our PG DB and not the tables. This creates the following schema

import { pgTable } from "drizzle-orm/pg-core"
  import { sql } from "drizzle-orm"

export const role = pgEnum("Role", ['MODERATOR', 'ADMIN', 'USER'])

import { pgTable } from "drizzle-orm/pg-core"
  import { sql } from "drizzle-orm"

export const role = pgEnum("Role", ['MODERATOR', 'ADMIN', 'USER'])

import { pgTable } from "drizzle-orm/pg-core"
  import { sql } from "drizzle-orm"

export const role = pgEnum("Role", ['MODERATOR', 'ADMIN', 'USER'])

import { pgTable } from "drizzle-orm/pg-core"
  import { sql } from "drizzle-orm"

export const role = pgEnum("Role", ['MODERATOR', 'ADMIN', 'USER'])

We have 17 tables in our DB and would like these and there relations to be pulled into the schema file.

Repro Steps

mkdir codu
cd codu
git clone https://github.com/codu-code/codu.git
Run
npm i
```
npm i
```
npm i
```
npm i
```
Look at the README to learn our to populate the .env file. The sample.env will give you the DB creds you need. Just rename it from sample.env -> .env

Run

docker compose up

docker compose up

docker compose up

docker compose up

Run

npx prisma db push

npx prisma db push

npx prisma db push

npx prisma db push

Add

out: "./drizzle"

out: "./drizzle"

out: "./drizzle"

out: "./drizzle"

to drizzle.config,ts file

Run

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

Any help greatly appreciated

GitHub

GitHub - codu-code/codu: Codú's open-source codebase. A space for c...

Codú's open-source codebase. A space for coders. Visit our community! - GitHub - codu-code/codu: Codú's open-source codebase. A space for coders. Visit our community!

GitHub

GitHub - codu-code/codu: Codú's open-source codebase. A space for c...

Codú's open-source codebase. A space for coders. Visit our community! - GitHub - codu-code/codu: Codú's open-source codebase. A space for coders. Visit our community!

introspect not finding tables for pg database

Similar Threads

Similar Threads

Similar Threads