Issue with drizzle-zod?
Schema
```
export const testinArray = pgTable("testing_array", {
id: varchar("id", { length: 14 })...
Optional One-to-One Relation
Currently it's possible to define only a One-to-One relation (https://orm.drizzle.team/docs/rqb#one-to-one) but in the types, the value returned will never be undefined or null.
In my use case I would like to define a One-to-One relation that could be optional.
Is there a solution? Is this even possible?
(I also raised an issue on GitHub (https://github.com/drizzle-team/drizzle-orm/issues/1066) a month ago but I think it got lost there)...
Having Issues Pushing Database Schema
Hi I am getting this issue whenever I am trying to push the database schema. Any help would be greatly appreciated.
```
❯ pnpm drizzle-kit push:mysql --schema=./Database/schema.ts
drizzle-kit: v0.19.13
drizzle-orm: v0.28.6...
migration failed
code:
```js
const migrationClient = postgres("postgresql://jer:admin@localhost:5432/test", { max: 1 })
async function main() {...
TypeError: Cannot read properties of undefined (reading 'compositePrimaryKeys')
I am attempting to run db push, but I am getting this error above^^
does anyone know what might be going on?...
Nesting sqlite drizzle into a deeper location in my ts app, difficulties with src/ vs dist/
Hey! I'm very new to drizzle and trying to set up a very small drizzle instance for a service that reads a whole pile of json files and acts as a simple read-only information store.
I got most of the setup to work. I have it at a location
```
src/...
syntax highlighting not working
I reinstalled the node_modules multiple times and it didnt fix my problem. This isnt suposed to look like this does it?
Prepare raw sql query (Postgres)
Hi, I need to do a recursive query, so I think I need to use the magic sql operator to build it. Is it possible to make a prepared statement this way? I haven't been able to find a way, but something like
db.prepare(sql`...`) would make sense to me.packing migration files with the library
hey there, I'm trying to use
migrate inside from a library consumer (i.e I have a @mycompany/db-lib that has doMigration and from my internal dev-app, I want to do something like:
```ts
import { doMigrate } from '@mycompany/db-lib'
export const onMigrateClick = () => {...Any way to invoke a SQL function?
For ex: lets say I declare a SQL function
CREATE OR REPLACE FUNCTION do_something()
how do i invoke this function using Drizzle's interface?...How to include array literals in raw sql?
I have an input array used for an order by using the array_position function - rather than passing the array as a single param, the call to:
...
.orderBy(sql`array_position(${ingredientNames}, ${entity.name})`);
.orderBy(sql`array_position(${ingredientNames}, ${entity.name})`);
any way to automatically cast numeric types on retrieval?
I have a numeric field in a video table:
```
export const VideoTable = pgTable('videos', {
id: uuid('id').primaryKey().defaultRandom(),
height: integer('height'),...
Query in drizzle doesn't work
Error:
...
DrizzleError: No fields selected for table "usersToGroups" ("users_groups")
DrizzleError: No fields selected for table "usersToGroups" ("users_groups")
Cannot read properties of undefined (reading 'referencedTable')
Seemingly getting this error out of nowhere. I believe it's related to the relations I defined, but can't quite figure out what is causing it specifically.
Relational query builder in mysql?
I cant find anything about how to implement this. Am I blind or is this impossible?
TransactionRollbackError
Need some help understanding TransactionRollbackError...
Is this error saying the
tx.rollback() function itself threw an error and that the rollback was unsuccessful, or just that the tx.rollback() function was called?...PostgresError: null value in column "id" of relation "pairs" violates not-null constraint
Hello, I am fairly new to Drizzle and working with databases, so I am running into a problem that I am unsure how to solve and hope that you can help me with it.
I use Directus CMS to create all of my tables. Then, I wrote schema.ts (using introspect and making a couple of manual changes).
So, one of my tables looks like this:...
OnConflictDoNothing with mysql
Hi everyone,
I want to use the on conflict do nothing method described here: https://orm.drizzle.team/docs/insert#onconflict-and-upsert-insert-or-update.
But it seems to be that only onConflictDoUpdate is available. Is this database specific or Am I doing something wrong here?
this is my query: ...
drizzle-kit introspect reorder tables
Here is the case:
- I have a remote database. I made a backup and restore it locally
- I ran: drizzle-kit introspect:pg --config=./database/drizzle/drizzle.config.ts
- With different connections in the config: first for the remote DB and second for the local DB, I got different orders of tables in the generated schema...