Will the below query execute correctly? await prisma.$queryRawWITH filtered_tracks AS (…
- User
Will the below query execute correctly?
await prisma.{campaignIdRTs}]::VARCHAR[])--ANY(${campaignIdRTs}) ), campaign_domains AS ( SELECT t.campaign_id_rt, d.domain_id, d.domain_name, d.domain_weight FROM filtered_tracks t JOIN campaigns c ON t.campaign_id = c.campaign_id JOIN domains d ON c.id = d.campaign_id ), grouped_domains AS ( SELECT domain_id, domain_name, domain_weight, array_agg(campaign_id_rt) as campaigns FROM campaign_domains GROUP BY domain_id, domain_name, domain_weight ) SELECT domain_id, domain_name as name, domain_weight as weight, 'SEDO' as feedSource, campaigns FROM grouped_domains;`;
- Assistant
The given query will not execute correctly because it contains an incorrect syntax.
The correct syntax for executing a raw query using Prisma is
await prisma.$queryRaw(query)wherequeryis a string containing the SQL query.Here is the corrected query:
const query = ` WITH filtered_tracks AS ( SELECT * FROM tracks WHERE campaign_id_rt = ANY(ARRAY[${campaignIdRTs}]::VARCHAR[])--ANY(${campaignIdRTs}) ), campaign_domains AS ( SELECT t.campaign_id_rt, d.domain_id, d.domain_name, d.domain_weight FROM filtered_tracks t JOIN campaigns c ON t.campaign_id = c.campaign_id JOIN domains d ON c.id = d.campaign_id ), grouped_domains AS ( SELECT domain_id, domain_name, domain_weight, array_agg(campaign_id_rt) as campaigns FROM campaign_domains GROUP BY domain_id, domain_name, domain_weight ) SELECT domain_id, domain_name as name, domain_weight as weight, 'SEDO' as feedSource, campaigns FROM grouped_domains;` await prisma.$queryRaw(query);
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.