take-20123121

.py

def hack_convert(records):                                                                                                                                                               
    template = "select * from analytics where tag in ({CODE})"                                                                                                                           
    root = "(VALUES "                                                                                                                                                                    
    for rec in records:                                                                                                                                                                  
        root = root + "('"+rec+"'::uuid),"                                                                                                                                               
    # this removes the last comma                                                                                                                                                                                     
    root = root[:-1]                                                                                                                                                                     
                                                                                                                                                                                         
    root = root + ")"                                                                                                                                                                    
    return root                                                                                                                                                                          
                                                                                                                                                                                         
TEMPLATE = """UPDATE analytics SET updated = now() WHERE tag_uuid IN {UUIDS}"""                                                                                                          
def update_records(tag_id, uuids):                                                                                                                                                       
    "running against", len(uuids)                                                                                                                                                                                                                                                                                             
    structured_uuids = hack_convert(uuids)                                                                                                                                               
    print structured_uuids                                                                                                                                                               
    query = TEMPLATE.format(UUIDS=structured_uuids, IPS=structured_uuids)                                                                                                                
    print 'executing function - psql call execute'                                                                                                                                       
    #print tag_cursor.mogrify(query)                                                                                                                                                     
                                                                                                                                                                    
    tag_cursor.execute(query)                                                                                                                                                            
    print 'finish running exec'                                                                                                                                                          
    #s("analyticsd.update.record")                                                                                                                                                       
    return