'tonyyprints' Posts - Answer Overflow

const profilePhoto = await ctx.db.query.profile.findFirst({
          where: eq(schema.profile.id, profile.profileId),
          columns: {
            profilePhotoId: true,
          },
        })

const profilePhoto = await ctx.db.query.profile.findFirst({
          where: eq(schema.profile.id, profile.profileId),
          columns: {
            profilePhotoId: true,
          },
        })

but get the following overload error:

Argument of type bigint is not assignable to parameter of type number | SQLWrapper.

Argument of type bigint is not assignable to parameter of type number | SQLWrapper.

My schema for the related fields are also posted below.

export const profile = mySqlTable("Profile", {
  id: serial("id").primaryKey(),
  userName: varchar("userName", { length: 255 }).unique().notNull(),
  bio: text("bio"),
  profilePhotoId: bigint("profilePhoto", {mode: "bigint", unsigned: true}).references(() => profilePhoto.id),
  createdAt: timestamp("createdAt")
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp("updatedAt").onUpdateNow(),
});

export const profileRelations = relations(profile, ({ one, many }) => ({
  profilePhoto: one(profilePhoto, {
    fields: [profile.profilePhotoId],
    references: [profilePhoto.id],
  }),
  posts: many(post),
}));

export const profilePhoto = mySqlTable("ProfilePhoto", {
  id: serial("id").primaryKey().notNull(),
  url: varchar("url", { length: 255 }).notNull(),
  // key: varchar("varchar", { length: 255 }).notNull(),
  createdAt: timestamp("createdAt")
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp("updatedAt").onUpdateNow(),
});

export const profilePhotoRelations = relations(profilePhoto, ({ one }) => ({
  profile: one(profile, {
    fields: [profilePhoto.id],
    references: [profile.id],
  }),
}));

export const profile = mySqlTable("Profile", {
  id: serial("id").primaryKey(),
  userName: varchar("userName", { length: 255 }).unique().notNull(),
  bio: text("bio"),
  profilePhotoId: bigint("profilePhoto", {mode: "bigint", unsigned: true}).references(() => profilePhoto.id),
  createdAt: timestamp("createdAt")
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp("updatedAt").onUpdateNow(),
});

export const profileRelations = relations(profile, ({ one, many }) => ({
  profilePhoto: one(profilePhoto, {
    fields: [profile.profilePhotoId],
    references: [profilePhoto.id],
  }),
  posts: many(post),
}));

export const profilePhoto = mySqlTable("ProfilePhoto", {
  id: serial("id").primaryKey().notNull(),
  url: varchar("url", { length: 255 }).notNull(),
  // key: varchar("varchar", { length: 255 }).notNull(),
  createdAt: timestamp("createdAt")
    .default(sql`CURRENT_TIMESTAMP`)
    .notNull(),
  updatedAt: timestamp("updatedAt").onUpdateNow(),
});

export const profilePhotoRelations = relations(profilePhoto, ({ one }) => ({
  profile: one(profile, {
    fields: [profilePhoto.id],
    references: [profile.id],
  }),
}));

7 replies

TTCTheo's Typesafe Cult

•Created by 'tonyyprints' on 2/1/2024 in #questions

Running script from root

3 replies

TTCTheo's Typesafe Cult

•Created by 'tonyyprints' on 11/6/2023 in #questions

tRPC not returning string

I have a procedure that generates a presigned url and sends it to the frontend. When I print the url in the trpc procedure it prints, but when I try to print it on the frontend, it doesn't. Clientside

const Camera = () => {

  const [image, setImage] = useState(null);
  const mutation = api.media.postImage.useMutation();

  ...
  const pickImage = async () => {
    ...
    const url = mutation.mutate({bucket: "myawsbucket-0xc3", key: "testKey123", caption: "test caption", tags: ["otherUserKey"]});
    console.log("url on frontend: ", url);
  };

  return (
    <View style={{ flex: 1, alignItems: 'center', justifyContent: 'center' }}>
      <Button title="Pick an image from camera roll" onPress={pickImage} />
      {image && <Image source={{ uri: image }} style={{ width: 200, height: 200 }} />}
    </View>
  );
}
export default Camera;

const Camera = () => {

  const [image, setImage] = useState(null);
  const mutation = api.media.postImage.useMutation();

  ...
  const pickImage = async () => {
    ...
    const url = mutation.mutate({bucket: "myawsbucket-0xc3", key: "testKey123", caption: "test caption", tags: ["otherUserKey"]});
    console.log("url on frontend: ", url);
  };

  return (
    <View style={{ flex: 1, alignItems: 'center', justifyContent: 'center' }}>
      <Button title="Pick an image from camera roll" onPress={pickImage} />
      {image && <Image source={{ uri: image }} style={{ width: 200, height: 200 }} />}
    </View>
  );
}
export default Camera;

tRPC

  postImage: protectedProcedure
    .input(
      z.object({
        bucket: z.string(),
        key: z.string(),
        caption: z.string().optional(),
        tags: z.array(z.string()),
      }),
    )
    .output(z.string())
    .mutation(async ({ ctx, input }) => {
      const metadata = {
        AuthorId: ctx.session.uid,
      };
      if (input.caption) {
        metadata["Caption" as keyof typeof metadata] = input.caption;
      }

      if (input.tags.length > 0) {
        input.tags.forEach((tag, index) => {
          metadata[`Tag${index}` as keyof typeof metadata] = tag;
        });
      }

      const putObjectParams = {
        Bucket: input.bucket,
        Key: input.key,
        Metadata: metadata,
      };

      const url = await getSignedUrl(ctx.s3, new PutObjectCommand(putObjectParams), {
        expiresIn: 3600,
      });
      console.log("url", url);
      return url;
    }),

  postImage: protectedProcedure
    .input(
      z.object({
        bucket: z.string(),
        key: z.string(),
        caption: z.string().optional(),
        tags: z.array(z.string()),
      }),
    )
    .output(z.string())
    .mutation(async ({ ctx, input }) => {
      const metadata = {
        AuthorId: ctx.session.uid,
      };
      if (input.caption) {
        metadata["Caption" as keyof typeof metadata] = input.caption;
      }

      if (input.tags.length > 0) {
        input.tags.forEach((tag, index) => {
          metadata[`Tag${index}` as keyof typeof metadata] = tag;
        });
      }

      const putObjectParams = {
        Bucket: input.bucket,
        Key: input.key,
        Metadata: metadata,
      };

      const url = await getSignedUrl(ctx.s3, new PutObjectCommand(putObjectParams), {
        expiresIn: 3600,
      });
      console.log("url", url);
      return url;
    }),

2 replies

TTCTheo's Typesafe Cult

•Created by 'tonyyprints' on 9/15/2023 in #questions

NextAuth Discord Provider Callback Error

2 replies

TTCTheo's Typesafe Cult

•Created by 'tonyyprints' on 9/5/2023 in #questions

discord callback url

24 replies

TTCTheo's Typesafe Cult

•Created by 'tonyyprints' on 8/31/2023 in #questions

Discord not signing in

9 replies

TTCTheo's Typesafe Cult

•Created by 'tonyyprints' on 3/19/2023 in #questions

Google Provider when deploying

I'm trying to deploy my project on vercel with a custom domain, but I'm getting an error that says something like: Google OAuth 2 authorization - Error: redirect_uri_mismatch. does anyone know how to fix this?

4 replies

TTCTheo's Typesafe Cult

•Created by 'tonyyprints' on 2/18/2023 in #questions

mutation is returning void