DT
Drizzle Team•2w ago
JordanR

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?
1 Reply
JordanR
JordanROP•2w ago
For some extra context here, if I create a drizzle client and run this exact same query on the drizzle client and using the extended prisma client, it works...

Did you find this page helpful?