ArwanceR Comments - Answer Overflow

ArwanceR

Posts Comments

DTDrizzle Team

•Created by jrandeniya on 8/22/2023 in #help

I can't create a simple table..

I had the same issue after upgrading to 0.28.3, try downgrading to 0.28.2

6 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

happy to help

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

if there's no other API you will still have to use some workaround

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

but, that being said, I don't think sql will make you find other solution, since it's raw

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

but, to turn it on for all queries:

export const db = drizzle(pool, {
  logger: true
})

export const db = drizzle(pool, {
  logger: true
})

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

I don't think you can turn on logging per request

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

know where to put it ?

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

what sql it generates

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

you can turn logging on and check the generated query with this 'working' example

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

this is one solution, you might find other

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

well, I there was another solution, I would too use it : )

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

this might need some modifications, such as selecting more fields in select({})

33 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

modifying second example:

export async function getLoansLJ(spaceId: string) { 
  return db
    .select({
      financial_institutions: sql`(SELECT id,name,bic,logoUrl,country from financialInstitutions where financialInstitutions.id = 
loans.financialInstitutionId))`
})
    .from(loans)
    .where(eq(loans.spaceId, spaceId));
}

export async function getLoansLJ(spaceId: string) { 
  return db
    .select({
      financial_institutions: sql`(SELECT id,name,bic,logoUrl,country from financialInstitutions where financialInstitutions.id = 
loans.financialInstitutionId))`
})
    .from(loans)
    .where(eq(loans.spaceId, spaceId));
}