How to execute SQL code into Python Code?

Question

SELECT  RiskID.RiskID,  RiskID.FuncID1,  FUNCID.TCODE FROM   RiskID INNER JOIN  FUNCID ON  RiskID.FuncID1 =  FUNCID.FUNCID

Manish Bohra · Accepted Answer

Hello,
You can try below code maybe it helps you
query = """(SELECT  RiskID.RiskID,  RiskID.FuncID1,  FUNCID.TCODE FROM   RiskID INNER JOIN  FUNCID ON  RiskID.FuncID1 =  FUNCID.FUNCID)"""
cr = self._cr
cr.execute(query)
Thanks

Padhmanaban P · Answer

Use below mentioned code:
sql = """select count(name) from table_name where lower(field_name) = lower('%s') """ % self.field_name
self.env.cr.execute(sql)

Mitul Shingala · Answer

Hello
use self._cr.execute() to execute your sql query.
for eg. self._cr.execute("""SELECT  RiskID.RiskID,  RiskID.FuncID1,  FUNCID.TCODE FROM   RiskID INNER JOIN  FUNCID ON  RiskID.FuncID1 =  FUNCID.FUNCID """)
then you can get your result using below code:
result = *self._cr.dictfetchall()* or   result = *self._cr.fetchall()*

This question has been flagged

Enjoying the discussion? Don't just read, join in!