Jokerz Posts - Answer Overflow

Jokerz

Explore posts from servers

TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by Jokerz on 7/21/2024 in #questions

anyone running into failed to connect to daemon? i cant run pnpm dev

21/07/24 10:57:18] ➜  sol-eats git:(main) ✗ pnpm dev

> create-t3-turbo@ dev /Users/daniel/Documents/Repos/sol-eats
> turbo watch dev

• Packages in scope: @acme/api, @acme/auth, @acme/db, @acme/eslint-config, @acme/github, @acme/nextjs, @acme/prettier-config, @acme/tailwind-config, @acme/tsconfig, @acme/ui, @acme/validators
• Running dev in 11 packages
• Remote caching disabled
  × failed to connect to daemon
  ╰─▶ server is unavailable: channel closed

21/07/24 10:57:18] ➜  sol-eats git:(main) ✗ pnpm dev

> create-t3-turbo@ dev /Users/daniel/Documents/Repos/sol-eats
> turbo watch dev

• Packages in scope: @acme/api, @acme/auth, @acme/db, @acme/eslint-config, @acme/github, @acme/nextjs, @acme/prettier-config, @acme/tailwind-config, @acme/tsconfig, @acme/ui, @acme/validators
• Running dev in 11 packages
• Remote caching disabled
  × failed to connect to daemon
  ╰─▶ server is unavailable: channel closed

1 replies

DTDrizzle Team

•Created by Jokerz on 2/15/2024 in #help

can we filter by a prop on a relation during a query?

eg. watch has watch brands + watch families as relations if i wanted to search across watch name, watch brand name + watch family name should that be possible? current query just using watch name

const items = await ctx.db.query.watch.findMany({
            ...withCursorPagination({
              limit: 10,
              cursors: [[schema.watchBrand.name, "desc", cursor]],
            }),
            where: and(
              like(schema.watch.name, `%${input.name}%`),
              notInArray(schema.watch.id, usersWatches),
            ),
            with: {
              watchBrand: true,
              watchFamily: true,
            },
          });

const items = await ctx.db.query.watch.findMany({
            ...withCursorPagination({
              limit: 10,
              cursors: [[schema.watchBrand.name, "desc", cursor]],
            }),
            where: and(
              like(schema.watch.name, `%${input.name}%`),
              notInArray(schema.watch.id, usersWatches),
            ),
            with: {
              watchBrand: true,
              watchFamily: true,
            },
          });

13 replies

DTDrizzle Team

•Created by Jokerz on 10/2/2023 in #help

are timezones saved as utc? for pg

im having an issue where the db is saving -2 instead of -1

2 replies

DTDrizzle Team

•Created by Jokerz on 7/8/2023 in #help

foreign key constraint cannot be implemented

/Users/daniel/Documents/Repos/Thatch/thatch-web/node_modules/.pnpm/[email protected]/node_modules/postgres/cjs/src/connection.js:771
    const error = Errors.postgres(parseError(x))
                         ^
PostgresError: foreign key constraint "users_to_posts_user_id_users_id_fk" cannot be implemented

/Users/daniel/Documents/Repos/Thatch/thatch-web/node_modules/.pnpm/[email protected]/node_modules/postgres/cjs/src/connection.js:771
    const error = Errors.postgres(parseError(x))
                         ^
PostgresError: foreign key constraint "users_to_posts_user_id_users_id_fk" cannot be implemented

import { relations } from "drizzle-orm";
import { pgTable, primaryKey, varchar } from "drizzle-orm/pg-core";

import { posts } from "./posts";
import { users } from "./users";

export const usersToPosts = pgTable(
  "users_to_posts",
  {
    userId: varchar("user_id")
      .notNull()
      .references(() => users.id),
    postId: varchar("post_id")
      .notNull()
      .references(() => posts.id),
  },
  (t) => ({
    pk: primaryKey(t.userId, t.postId),
  })
);

export const usersToPostsRelations = relations(usersToPosts, ({ one }) => ({
  post: one(posts, {
    fields: [usersToPosts.postId],
    references: [posts.id],
  }),
  user: one(users, {
    fields: [usersToPosts.userId],
    references: [users.id],
  }),
}));

import { relations } from "drizzle-orm";
import { pgTable, primaryKey, varchar } from "drizzle-orm/pg-core";

import { posts } from "./posts";
import { users } from "./users";

export const usersToPosts = pgTable(
  "users_to_posts",
  {
    userId: varchar("user_id")
      .notNull()
      .references(() => users.id),
    postId: varchar("post_id")
      .notNull()
      .references(() => posts.id),
  },
  (t) => ({
    pk: primaryKey(t.userId, t.postId),
  })
);

export const usersToPostsRelations = relations(usersToPosts, ({ one }) => ({
  post: one(posts, {
    fields: [usersToPosts.postId],
    references: [posts.id],
  }),
  user: one(users, {
    fields: [usersToPosts.userId],
    references: [users.id],
  }),
}));

2 replies

DTDrizzle Team

•Created by Jokerz on 6/6/2023 in #help

When trying to push:mysql its warning that schema has changed and data will be lost when it hasnt.

· You're about to change projected_points column type from alter_table_alter_column_set_type to decimal with 689 items
THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

· You're about to change projected_points column type from alter_table_alter_column_set_type to decimal with 689 items
THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

No changes have been made ...

11 replies

TTCTheo's Typesafe Cult

•Created by Jokerz on 1/13/2023 in #questions

Vercel - Module not found: Can't resolve

On a new deployment I am getting a new error where I haven't changed anything at all in these files.

Failed to compile.
./src/pages/api/trpc/[trpc].ts
Module not found: Can't resolve '../../../server/api/root.js' in '/vercel/path0/src/pages/api/trpc'
./src/pages/api/trpc/[trpc].ts
Module not found: Can't resolve '../../../server/api/trpc.js' in '/vercel/path0/src/pages/api/trpc'

Failed to compile.
./src/pages/api/trpc/[trpc].ts
Module not found: Can't resolve '../../../server/api/root.js' in '/vercel/path0/src/pages/api/trpc'
./src/pages/api/trpc/[trpc].ts
Module not found: Can't resolve '../../../server/api/trpc.js' in '/vercel/path0/src/pages/api/trpc'

Here is the contents of my [trpc].ts

import { createNextApiHandler } from "@trpc/server/adapters/next";

import { env } from "../../../env/server.mjs";
import { appRouter } from "../../../server/api/root.js";
import { createTRPCContext } from "../../../server/api/trpc.js";

// export API handler
export default createNextApiHandler({
  router: appRouter,
  createContext: createTRPCContext,
  onError:
    env.NODE_ENV === "development"
      ? ({ path, error }) => {
          console.error(
            `❌ tRPC failed on ${path ?? "<no-path>"}: ${error.message}`
          );
        }
      : undefined,
});

import { createNextApiHandler } from "@trpc/server/adapters/next";

import { env } from "../../../env/server.mjs";
import { appRouter } from "../../../server/api/root.js";
import { createTRPCContext } from "../../../server/api/trpc.js";

// export API handler
export default createNextApiHandler({
  router: appRouter,
  createContext: createTRPCContext,
  onError:
    env.NODE_ENV === "development"
      ? ({ path, error }) => {
          console.error(
            `❌ tRPC failed on ${path ?? "<no-path>"}: ${error.message}`
          );
        }
      : undefined,
});

2 replies

TtRPC

•Created by Jokerz on 11/8/2022 in #❓-help

How do we add settings in each query like before?

Since the new update, bee super confused. I used to do this, and can't recreate it now.

  const {
    data: traitz,
    isLoading,
    refetch: refetchTraitz,
  } = trpc.useQuery(["trait.get-traits"], {
    refetchOnWindowFocus: false,
    enabled: !publicKey,
  });

  const {
    data: traitz,
    isLoading,
    refetch: refetchTraitz,
  } = trpc.useQuery(["trait.get-traits"], {
    refetchOnWindowFocus: false,
    enabled: !publicKey,
  });

  const {
    data: traitz,
    isLoading,
    refetch: refetchTraitz,
  } = trpc.trait.getTraits.useQuery();

  const {
    data: traitz,
    isLoading,
    refetch: refetchTraitz,
  } = trpc.trait.getTraits.useQuery();

3 replies

Gaming

Programming