TJBlackman
TJBlackman
Explore posts from servers
DDenoDTDrizzle Team
PostsComments
DDeno
Created by TJBlackman on 9/1/2024 in #help
Deno memory usage in Docker Container is crazy high...?
When I run Deno in Docker, Docker Desktop stats say it's using 144mb of memory, and NodeJS uses 11mb... Is this right?!?!? docker run -it --rm --name deno-process denoland/deno:alpine deno docker run -it --rm --name node-process node:22-alpine node
9 replies
DTDrizzle Team
Created by TJBlackman on 6/10/2024 in #help
Can't infer relationship one-to-one
I'm trying to follow the relationship docs to set a relationship between a user and a role, but I'm getting the error Error: There is not enough information to infer relation "users.role" although I'm sure I'm following the example on this page: https://orm.drizzle.team/docs/rqb#one-to-one Can anyone help me find the issue? Code: 
export const users = pgTable(
  "users",
  {
    id: serial("id").primaryKey(),
    email: varchar("email", { length: 150 }).unique().notNull(),
  },
  (table) => {
    return {
      tokenIdx: index("email_idx").on(table.email),
    };
  }
);

export const usersRelations = relations(users, ({ one }) => ({
  role: one(roles),
}));

export const roles = pgTable("roles", {
  id: serial("id").primaryKey(),
  userId: integer("user_id")
    .references(() => users.id, {
      onDelete: "cascade",
    })
    .notNull(),
  staffRole: rolesEnum("role").notNull(),
});

export const db = drizzle(queryClient, {
  schema: {
    users,
    usersRelations,
    roles,
  },
});
export const users = pgTable(
  "users",
  {
    id: serial("id").primaryKey(),
    email: varchar("email", { length: 150 }).unique().notNull(),
  },
  (table) => {
    return {
      tokenIdx: index("email_idx").on(table.email),
    };
  }
);

export const usersRelations = relations(users, ({ one }) => ({
  role: one(roles),
}));

export const roles = pgTable("roles", {
  id: serial("id").primaryKey(),
  userId: integer("user_id")
    .references(() => users.id, {
      onDelete: "cascade",
    })
    .notNull(),
  staffRole: rolesEnum("role").notNull(),
});

export const db = drizzle(queryClient, {
  schema: {
    users,
    usersRelations,
    roles,
  },
});
1 replies
DTDrizzle Team
Created by TJBlackman on 5/14/2024 in #help
Make varchar field one of string union
I know that CHECK constraint hasn't been implemented yet, but I want to implement a Role field that is a varchar that can only be set to "user", "paid-user", or "admin" and I want the schema definition in TS to reflect this. I know this wont set the constraint at the DB level, but I want to TS definition to reflect that only the above union of strings are valid. How can I tell drizzle that this field should be this specific TS type? 
 role: varchar("role", { length: 50 }).notNull(), // user|paid-user|admin
 role: varchar("role", { length: 50 }).notNull(), // user|paid-user|admin
6 replies
DDeno
Created by TJBlackman on 1/23/2023 in #help
How can I get `npm` in the path for Deno.run()?
6 replies