Nice way to generate SQL query in Python

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

async def register_experiment(self, pool):
    async with pool.acquire() as conn:
        async with conn.cursor() as cur:
            sql = "INSERT INTO " + str(self.auxname) + "." + 
                str(self.auxtable)
            sql += " VALUES(NULL, '" 
            sql += str(self.dbname) 
            sql += "', '" 
            sql += str(self.encoder) 
            sql += "', 0, '" #goodEncoder
            sql += str(self.lattices) 
            sql += "', 0, '" #goodLattices
            sql += str(self.complex) 
            sql += "', 0, '" #goodComplex 
            sql += str(self.verges_total) 
            sql += "', 0, " #goodVerges
            sql += str(self.verges_total) 
            sql += ", '" 
            sql += str(self.trains) 
            sql += "', 0, '" #goodTrains 
            sql += str(self.tests) 
            sql += "', 0, '" #goodTests 
            sql += str(self.hypotheses) 
            sql += "', 0, '" #goodHypotheses 
            sql += str(self.type)
            sql += "')"
            await cur.execute(sql)
            await conn.commit()