JordanR Posts - Answer Overflow

JordanR

Explore posts from servers

•Created by JordanR on 3/22/2025 in #help

Using prisma to select columns not returning what I'm passing

I'm not sure what is happening. I'm in the process of switching to Drizzle from Prisma and am having an issue with my query that is causing the select object I'm passing to not be respected and just returning the columns for one of my tables. I have this query trying to select some specific columns from each of my tables

db.$drizzle
              .select({
                post_id: Post.id,
                content: Post.content,
                post_date: Post.postDate,
                profile_id: Post.profileId,
                post_created_at: Post.createdAt,
                post_updated_at: Post.updatedAt,
                profile_name: Profile.name,
                username: Profile.username,
                latitude: Profile.latitude,
                longitude: Profile.longitude,
                profile_created_at: Profile.createdAt,
                bio: Profile.bio,
                type: Profile.type,
                address_1: Profile.address1,
                address_2: Profile.address2,
                city: Profile.city,
                state: Profile.state,
                postal_code: Profile.postalCode,
                user_id: Profile.userId,
                profile_photo: Profile.profilePhoto,
              })
              .from(Post)
              .innerJoin(Profile, eq(Post.profileId, Profile.id))
              .where(
                sql`ST_DistanceSphere(profiles.location, ST_MakePoint(${longitude}, ${latitude})) <= ${nearRadius}`
              )
              .orderBy(desc(Post.postDate))

db.$drizzle
              .select({
                post_id: Post.id,
                content: Post.content,
                post_date: Post.postDate,
                profile_id: Post.profileId,
                post_created_at: Post.createdAt,
                post_updated_at: Post.updatedAt,
                profile_name: Profile.name,
                username: Profile.username,
                latitude: Profile.latitude,
                longitude: Profile.longitude,
                profile_created_at: Profile.createdAt,
                bio: Profile.bio,
                type: Profile.type,
                address_1: Profile.address1,
                address_2: Profile.address2,
                city: Profile.city,
                state: Profile.state,
                postal_code: Profile.postalCode,
                user_id: Profile.userId,
                profile_photo: Profile.profilePhoto,
              })
              .from(Post)
              .innerJoin(Profile, eq(Post.profileId, Profile.id))
              .where(
                sql`ST_DistanceSphere(profiles.location, ST_MakePoint(${longitude}, ${latitude})) <= ${nearRadius}`
              )
              .orderBy(desc(Post.postDate))

But the ouput from the returned records are only the columns from Post and they are not even named like what I'm selecting here. Can anyone help me troubleshoot this?

2 replies

TTCTheo's Typesafe Cult

•Created by JordanR on 6/23/2024 in #questions

Uploadthing UploadDropzone component button stuck on loading state

I'm trying to get this thing setup in my Next.js app and while I can click on the drop zone and all seems to be actually functioning, the button and dropzone stays in a "Loading..." state no matter what I've tried.

3 replies

Gaming

Programming