Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE]: drizzle-seed should support ignoring specified columns during refinement #3964

Open
1 task done
michaelschufi opened this issue Jan 17, 2025 · 0 comments
Open
1 task done
Labels
enhancement New feature or request

Comments

@michaelschufi
Copy link

michaelschufi commented Jan 17, 2025

Feature hasn't been suggested before.

  • I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

Given an already set up drizzle-orm schema, I would like to hand it over to drizzle-seed and then refine which columns should be seeded and which should be ignored.

Currently, there is no way to ignore a custom field column.

Suggestion

// schema.ts
export const users = pgTable("users", {
  id: integer().primaryKey(),
  name: text().notNull(),
  age: int(),
  photo: somethingSpecial() // some special field, e.g. a xata file
});

// seed.ts
import * as schema from './schema.ts'

await seed(db, schema).refine((f) => ({
  usersTbl: {
    count: 5,
    columns: {
      name: f.fullName(),
      photo: false, // photo will not be seeded, i.e. it's completely skipped in the statement, so the database can use its own default value.
      // id and age still get seeded implicitly
    }
  },
}))
@michaelschufi michaelschufi added the enhancement New feature or request label Jan 17, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant