'tonyyprints'
'tonyyprints'
Explore posts from servers
TtRPCPPrismaTTCTheo's Typesafe CultDTDrizzle TeamBABetter Auth
PostsComments
BABetter Auth
Created by luksch42 on 1/2/2025 in #help
getCookie() does not exist on authClient - Expo plugin errors
just ended up rolling my own auth rip
31 replies
BABetter Auth
Created by EgeOnder on 3/4/2025 in #help
[1.2.2] Type error with Expo client plugin
Any progress from your guys ends?
37 replies
BABetter Auth
Created by 'tonyyprints' on 3/9/2025 in #help
ExpoClient type mismatch
I'm also turborepo btw
3 replies
BABetter Auth
Created by luksch42 on 1/2/2025 in #help
getCookie() does not exist on authClient - Expo plugin errors
this thread seems to be deleted. Did yall figure out what the issue was?
31 replies
DTDrizzle Team
Created by 'tonyyprints' on 6/12/2024 in #help
Migrations taking the first snapshot
This is the error I'm getting. 
Error: Table 'Blocked' already exists
    at PromiseConnection.query (C:\Users\ghait\WebstormProjects\oppfy\node_modules\mysql2\promise.js:94:22)
    at MySql2PreparedQuery.execute (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql2\session.ts:85:18)
    at MySql2Session.execute (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\session.ts:81:5)
    at MySql2Transaction.execute (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\db.ts:456:23)
    at <anonymous> (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\dialect.ts:62:16)
    at MySql2Session.transaction (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql2\session.ts:247:25)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at MySqlDialect.migrate (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\dialect.ts:55:3)
    at migrate (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql2\migrator.ts:10:2)
    at <anonymous> (c:\Users\ghait\WebstormProjects\oppfy\packages\db\migrate.ts:8:1) {
  code: 'ER_TABLE_EXISTS_ERROR',
  errno: 1050,
  sql: 'CREATE TABLE `Blocked` (\n' +
    '\t`id` serial AUTO_INCREMENT NOT NULL,\n' +
    '\t`userId` varchar(255) NOT NULL,\n' +
    '\t`blockedUserId` varchar(255) NOT NULL,\n' +
    '\t`createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n' +
    '\tCONSTRAINT `Blocked_id` PRIMARY KEY(`id`)\n' +
    ');\n',
  sqlState: '42S01',
  sqlMessage: "Table 'Blocked' already exists"
}
Error: Table 'Blocked' already exists
    at PromiseConnection.query (C:\Users\ghait\WebstormProjects\oppfy\node_modules\mysql2\promise.js:94:22)
    at MySql2PreparedQuery.execute (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql2\session.ts:85:18)
    at MySql2Session.execute (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\session.ts:81:5)
    at MySql2Transaction.execute (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\db.ts:456:23)
    at <anonymous> (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\dialect.ts:62:16)
    at MySql2Session.transaction (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql2\session.ts:247:25)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at MySqlDialect.migrate (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql-core\dialect.ts:55:3)
    at migrate (C:\Users\ghait\WebstormProjects\oppfy\node_modules\src\mysql2\migrator.ts:10:2)
    at <anonymous> (c:\Users\ghait\WebstormProjects\oppfy\packages\db\migrate.ts:8:1) {
  code: 'ER_TABLE_EXISTS_ERROR',
  errno: 1050,
  sql: 'CREATE TABLE `Blocked` (\n' +
    '\t`id` serial AUTO_INCREMENT NOT NULL,\n' +
    '\t`userId` varchar(255) NOT NULL,\n' +
    '\t`blockedUserId` varchar(255) NOT NULL,\n' +
    '\t`createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n' +
    '\tCONSTRAINT `Blocked_id` PRIMARY KEY(`id`)\n' +
    ');\n',
  sqlState: '42S01',
  sqlMessage: "Table 'Blocked' already exists"
}
2 replies
DTDrizzle Team
Created by michaelhedgpeth on 4/25/2024 in #help
Not clear what happens during migrate
any chance you found an answer elsewhere?
4 replies
DTDrizzle Team
Created by 'tonyyprints' on 3/24/2024 in #help
bigint is not a number
ohhhhh that makes so much sense. Thank you. Just replaced all instances to number and it works 🙏
7 replies
DTDrizzle Team
Created by 'tonyyprints' on 3/24/2024 in #help
bigint is not a number
happy to: 
export const user = mySqlTable("User", {
  id: varchar("id", {length: 255}).primaryKey(),
  // email: varchar("email", { length: 255 }).unique().notNull(),
  name: varchar("name", { length: 255 }),
  dateOfBirth: date("dateOfBirth"),
  profileId: bigint("profileId", {mode: "bigint", unsigned: true}).references(() => profile.id),
  notificationSetting: bigint("notificationSetting", {mode: "bigint", unsigned: true}).references(
    () => notificationSetting.id,
  ),
  createdAt: timestamp("createdAt")
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp("updatedAt").onUpdateNow(),
});

export const userRelations = relations(user, ({ one }) => ({
  profile: one(profile, {
    fields: [user.profileId],
    references: [profile.id],
  }),
  notificationSetting: one(notificationSetting, {
    fields: [user.notificationSetting],
    references: [notificationSetting.id],
  }),
}));
export const user = mySqlTable("User", {
  id: varchar("id", {length: 255}).primaryKey(),
  // email: varchar("email", { length: 255 }).unique().notNull(),
  name: varchar("name", { length: 255 }),
  dateOfBirth: date("dateOfBirth"),
  profileId: bigint("profileId", {mode: "bigint", unsigned: true}).references(() => profile.id),
  notificationSetting: bigint("notificationSetting", {mode: "bigint", unsigned: true}).references(
    () => notificationSetting.id,
  ),
  createdAt: timestamp("createdAt")
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp("updatedAt").onUpdateNow(),
});

export const userRelations = relations(user, ({ one }) => ({
  profile: one(profile, {
    fields: [user.profileId],
    references: [profile.id],
  }),
  notificationSetting: one(notificationSetting, {
    fields: [user.notificationSetting],
    references: [notificationSetting.id],
  }),
}));
7 replies
DTDrizzle Team
Created by 'tonyyprints' on 3/24/2024 in #help
bigint is not a number
This is where profile comes from. profileId should be the serial index of the row 
const profile = await ctx.db.query.user.findFirst({

          where: eq(schema.user.id, input.metadata.id),
          columns: {
            profileId: true,
          },
        });
        if (!profile?.profileId) {
        // For now, assume a profile is always created in the auth flow
          throw new TRPCError({message: "User profile not found", code: "NOT_FOUND"});
        }
const profile = await ctx.db.query.user.findFirst({

          where: eq(schema.user.id, input.metadata.id),
          columns: {
            profileId: true,
          },
        });
        if (!profile?.profileId) {
        // For now, assume a profile is always created in the auth flow
          throw new TRPCError({message: "User profile not found", code: "NOT_FOUND"});
        }
7 replies
TTCTheo's Typesafe Cult
Created by 'tonyyprints' on 2/1/2024 in #questions
Running script from root
similar to how I can run db:push
3 replies
TTCTheo's Typesafe Cult
Created by 'tonyyprints' on 11/6/2023 in #questions
tRPC not returning string
had to return url as an object
2 replies