<SYSTEM_TASK:>
Solve the following problem using Python, implementing the functions described below, one line at a time
<END_TASK>
<USER_TASK:>
Description:
 def getTripInfo(triple):
 """Return a dictionary of information about a particular triple"""


    col_names=['mjdate', 'filter', 'elongation', 'discovery','checkup', 'recovery', 'iq','block' ]
    sql="SELECT mjdate md,"
    sql=sql+" filter, avg(elongation), d.id, checkup.checkup, recovery.recovery , avg(obs_iq_refccd), b.qname "
    sql=sql+"FROM triple_members t JOIN bucket.exposure e ON t.expnum=e.expnum "
    sql=sql+"JOIN bucket.blocks b ON b.expnum=e.expnum "
    sql=sql+"JOIN bucket.circumstance c on e.expnum=c.expnum "
    sql=sql+"LEFT JOIN discovery d ON t.triple=d.triple "
    sql=sql+"LEFT JOIN checkup  ON t.triple=checkup.triple "
    sql=sql+"LEFT JOIN recovery ON t.triple=recovery.triple "
    sql=sql+"WHERE t.triple=%s "
    sql=sql+"GROUP BY t.triple ORDER BY t.triple "
    cfeps.execute(sql,(triple, ) )
    rows=cfeps.fetchall()
    result={}
    #import datetime
    for idx in range(len(rows[0])):
        result[col_names[idx]]=rows[0][idx]

    return result