How to generate SQL statements dynamically using Doobie (scala)

Question

I have the query:

val sql = """select
                   id,
                   clientName
             from
                  partnerClients
             where
                  partnerName = ?
          """

I read partnerName from excel file and for each I perform the func:

case class Partner(name: String)
case class Client(id: Int, name: String)

def queryPartnerClients(partnerName: String) = Query[String, Client](sql, None).toQuery0(partnerName)

def getPartnerClients(partner: Partner): IO[Vector[Client]] =  partnerClients(partner.name)                                             
                                                              .to[Vector]
                                                              .transact(xa)

I used this FAQ (How do I turn an arbitrary SQL string into a Query/Query0)

The problem is getting empty results when I take partner name from excel, but it works if I specify the same partner name in the code like this for example:

def partnerClients(partnerName: String) = {
    val temp = "Partner Name"
    Query[String, Client](sql, None).toQuery0(temp)
}

I thought it was the problem with an encoding and I tried to fix it

def partnerClients(partnerName: String) = {
    val temp = new String(partner.getBytes("Windows-1251"), "UTF-8")
    Query[String, Client](sql, None).toQuery0(temp)
}

But the result is the same - the empty set.

Alex Spektr · Accepted Answer · 2020-01-29 11:50:06Z

1

I use this answer to turn on logging and found out that parameters sent by me contain whitespaces. Trim function fixed it

answered Jan 29, 2020 at 11:50

Alex Spektr

637 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to generate SQL statements dynamically using Doobie (scala)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related