Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

Will the below query execute correctly? await prisma.$queryRawWITH filtered_tracks AS (…

  1. User

    Will the below query execute correctly?

    await prisma.queryRaw‘WITHfilteredtracksAS(SELECT∗FROMtracksWHEREcampaignidrt=ANY(ARRAY[queryRaw`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;`;

  2. 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) where query is 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);
    

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.