jeff.kershner Comments - Answer Overflow

It is tough to debug this just by looking at your code. If you write console logs at each step and see what values are going in and coming out, that is probably the best way to see what is going on. It is weird that you are not getting any response? Like seriously no response from the API? Are you getting a 200 but no data, or is the API not even returning?

6 replies

TTCTheo's Typesafe Cult

•Created by cadams on 9/25/2023 in #questions

When to use "src/page/api/doStuff.ts" vs "src/server/api/routers/routerThatDoesStuff.ts"

Hello... as you know, you can't call a hook conditionally. But in react-query (and tRPC), you can supply an enabled parameter on when you want to call that useQuery. For example:

const bill = api.sale.bill.useQuery(
     {rows: spreadSheet?.rows ?? [] },
     { refetchInterval: false, refetchOnWindowFocus: false, enabled: hasBilled });

const bill = api.sale.bill.useQuery(
     {rows: spreadSheet?.rows ?? [] },
     { refetchInterval: false, refetchOnWindowFocus: false, enabled: hasBilled });

This useQuery will only be executed if hasBilled is true. This is a typical pattern that is used when submitting a form. When clicking submit, you change a local state variable to true and use that variable in the enabled flag. Does this answer your question?

11 replies

TTCTheo's Typesafe Cult

•Created by Bozic0909 on 9/18/2023 in #questions

env variable is undefined

Isn't this a t3 discord?

6 replies

TTCTheo's Typesafe Cult

•Created by Bhan Singh on 9/23/2023 in #questions

Drizzle and Create-t3

@Bozic0909 You shouldn't have to do that if you are running dotenv in your studio command like this (in your package.json):

"db:studio": "dotenv drizzle-kit studio",

"db:studio": "dotenv drizzle-kit studio",

My entire drizzle.config.ts look like this:

import { type Config } from "drizzle-kit";

import { env } from "~/env.mjs";

export default {
  schema: "./src/server/db/schema.ts",
  driver: "mysql2",
  dbCredentials: {
    connectionString: env.DATABASE_URL,
  },
  tablesFilter: ["rtc_*"],
} satisfies Config;

import { type Config } from "drizzle-kit";

import { env } from "~/env.mjs";

export default {
  schema: "./src/server/db/schema.ts",
  driver: "mysql2",
  dbCredentials: {
    connectionString: env.DATABASE_URL,
  },
  tablesFilter: ["rtc_*"],
} satisfies Config;

21 replies

TTCTheo's Typesafe Cult

•Created by Bhan Singh on 9/23/2023 in #questions

Drizzle and Create-t3

If either of you are still having trouble, send me your github repo (if its public) and I can try it locally. Your repo will not contain your .env file (at least it shouldn't), so it would be safe sharing.

21 replies

TTCTheo's Typesafe Cult

•Created by Bhan Singh on 9/23/2023 in #questions

Drizzle and Create-t3

@Bhan Singh Interesting that you are getting invalid environment variables. What variables do you have? For database, you should only have DATABASE_URL. What auth provider are you using? Whatever auth provider you are using, you will need to make sure they are in your .env and env.mjs (in two places - in the server object and in the runtimeEnv).

21 replies

TTCTheo's Typesafe Cult

•Created by Bhan Singh on 9/23/2023 in #questions

Drizzle and Create-t3

21 replies

TTCTheo's Typesafe Cult

•Created by Bhan Singh on 9/23/2023 in #questions

Drizzle and Create-t3

Your DATABSE_URL is wrong... Planetscale should give you this connection string (you might have to click on prisma in planetscale to see it). It should be something like this (replaced parts of my connection string with xxxx for obvious reasons):

mysql://t2xxxxxxxxxxosmqy:[email protected]/rtc?ssl={"rejectUnauthorized":true}

mysql://t2xxxxxxxxxxosmqy:[email protected]/rtc?ssl={"rejectUnauthorized":true}

If you go to your planetscale dashboard and click on settings -> passwords and click on Connect with Prisma (I know you are not using prisma, but that is the connect string you need). But you have to replace the sslaccept=strict with ssl={"rejectUnauthorized":true}

21 replies

TTCTheo's Typesafe Cult

•Created by Bhan Singh on 9/23/2023 in #questions

Drizzle and Create-t3

It worked for me with a fresh install of a new planetscale database, brand new t3 app (7.20.2). I am using bun and NextAuth with a GoogleProvider. Does your drizzle-kit studio work and show your tables? Add this to your package.json:

"db:studio": "dotenv drizzle-kit studio",

"db:studio": "dotenv drizzle-kit studio",

And make sure you install mysql2 package:

bunx add mysql2

bunx add mysql2

Make sure your planetscale database string in your .env ends with:

?ssl={"rejectUnauthorized":true}

?ssl={"rejectUnauthorized":true}

No other custom changes were made on my side. Did you guys make any changes or do anything different?

21 replies

TTCTheo's Typesafe Cult

•Created by Bozic0909 on 9/18/2023 in #questions

env variable is undefined

Not sure if this is an older version of t3, but in the latest at the time of my post (7.20.2), the drizzle.config.ts looks like this out of the box (and works):

import { type Config } from "drizzle-kit";

import { env } from "~/env.mjs";

export default {
  schema: "./src/server/db/schema.ts",
  driver: "mysql2",
  dbCredentials: {
    connectionString: env.DATABASE_URL,
  },
  tablesFilter: ["rtc_*"],
} satisfies Config;

import { type Config } from "drizzle-kit";

import { env } from "~/env.mjs";

export default {
  schema: "./src/server/db/schema.ts",
  driver: "mysql2",
  dbCredentials: {
    connectionString: env.DATABASE_URL,
  },
  tablesFilter: ["rtc_*"],
} satisfies Config;

6 replies

Gaming

Programming