def processSurf(img, imageId):

    data = 325
    pdata = cPickle.dumps(data, cPickle.HIGHEST_PROTOCOL)
    pdatabin = sqlite3.Binary(pdata)
    kpDes, numDescriptors = surf.calc_surf_blend(img)
    kpDes_pickle = cPickle.dumps(kpDes, cPickle.HIGHEST_PROTOCOL)
    kpDes_bin = sqlite3.Binary(kpDes_pickle)
    print cPickle.HIGHEST_PROTOCOL
    print pdata
    print pdatabin
    c.execute("""INSERT INTO table1 (data) VALUES (?)""", (kpDes_bin, ))
def processSurf(img,imageId,c,conn):

    kpDes, numDescriptors = surf.calc_surf_blend(img)
    kpDes_pickle = pickle.dumps(kpDes, pickle.HIGHEST_PROTOCOL)
    kpDes_bin = sqlite3.Binary(kpDes_pickle)
    cmd = 'INSERT INTO {tn}(imageId, numDescriptors, descriptors) VALUES((SELECT imageId from images WHERE imageId="{iId}"), {numDes}, ?)'.format(tn=table_name,iId=imageId,numDes=numDescriptors)
    #print cmd   
    try:
        c.execute(cmd,(kpDes_bin,))
        conn.commit()
    except sqlite3.IntegrityError:
        print('ERROR: ID already exists in PRIMARY KEY column {}'.format(imageId))
def processSurf(img,imageId):

    data = 325
    pdata = cPickle.dumps(data, cPickle.HIGHEST_PROTOCOL)
    pdatabin = sqlite3.Binary(pdata)
    kpDes, numDescriptors = surf.calc_surf_blend(img)
    kpDes_pickle = cPickle.dumps(kpDes, cPickle.HIGHEST_PROTOCOL)
    kpDes_bin = sqlite3.Binary(kpDes_pickle)
    print cPickle.HIGHEST_PROTOCOL
    print pdata
    print pdatabin
    c.execute("""INSERT INTO table1 (data) VALUES (?)""",(kpDes_bin,))
def processSurf(img, imageId, c, conn):

    kpDes, numDescriptors = surf.calc_surf_blend(img)
    kpDes_pickle = pickle.dumps(kpDes, pickle.HIGHEST_PROTOCOL)
    kpDes_bin = sqlite3.Binary(kpDes_pickle)
    cmd = 'INSERT INTO {tn}(imageId, numDescriptors, descriptors) VALUES((SELECT imageId from images WHERE imageId="{iId}"), {numDes}, ?)'.format(
        tn=table_name, iId=imageId, numDes=numDescriptors)
    #print cmd
    try:
        c.execute(cmd, (kpDes_bin, ))
        conn.commit()
    except sqlite3.IntegrityError:
        print('ERROR: ID already exists in PRIMARY KEY column {}'.format(
            imageId))