def run():
#EXTRACT ALL OUR FEATURES AND STORE THEM IN THE SQL DATABASE
imagesHandler.main()
colourHandler.main("RGB")
colourHandler.main("LAB")
hogHandler.main()
surf_start = timeit.default_timer()
surf_codebook.run_codebook(n_clusters,hessian_threshold, resize_ratio, resize_method, crop_amount)
surfRunTime = timeit.default_timer() - surf_start
sift_start = timeit.default_timer()
sift_codebook.run_codebook(n_clusters, resize_ratio, resize_method, crop_amount)
siftRunTime = timeit.default_timer() - sift_start
orb_start = timeit.default_timer()
orb_codebook.run_codebook(n_clusters, resize_ratio, resize_method, crop_amount)
orbRunTime = timeit.default_timer() - orb_start
print "SurfRunttime:",surfRunTime,"siftRuntime:",siftRunTime,"orbRt",orbRunTime
# PERFORM TSNE
tsneHandler.drop_database_table()
tsneHandler.create_database_table()
RGB_col_tsne,R_c_ids = tsne.TSNE_General(colourHandler.RGB_table_name)
LAB_col_tsne,L_c_ids = tsne.TSNE_General(colourHandler.LAB_table_name)
hog_tsne, h_ids = tsne.TSNE_General(hogHandler.table_name)
gist_tsne,g_ids = tsne.TSNE_Gist("gist_tsne", "gistvals")
surf_tsne, su_ids = tsne.TSNE_Surf("surf_ht"+str(hessian_threshold)+"_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters))
orb_tsne, o_ids = tsne.TSNE_orb("orb_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters))
sift_tsne, si_ids = tsne.TSNE_sift("sift_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters))
# get from sql
#col_tsne, c_ids = tsneHandler.getTSNEwithIds(colourHandler.table_name)
#hog_tsne, h_ids = tsneHandler.getTSNEwithIds(hogHandler.table_name)
#surf_tsne, s_ids = tsneHandler.getTSNEwithIds("surf_n"+str(n_clusters))
#Plot
plot_visualisation.plot_raw_TSNE(RGB_col_tsne,R_c_ids,colourHandler.RGB_table_name)
plot_visualisation.plot_raw_TSNE(LAB_col_tsne, L_c_ids, colourHandler.LAB_table_name)
plot_visualisation.plot_raw_TSNE(hog_tsne,h_ids,hogHandler.table_name)
plot_visualisation.plot_raw_TSNE(gist_tsne, g_ids, "gist")
plot_visualisation.plot_raw_TSNE(surf_tsne,su_ids,"surf_ht"+str(hessian_threshold)+"_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters) + '_tsne')
plot_visualisation.plot_raw_TSNE(orb_tsne,o_ids,"orb_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters) + '_tsne')
plot_visualisation.plot_raw_TSNE(sift_tsne,si_ids,"sift_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters) + '_tsne')
#Export tsne results to csv to be processed by gephi ect
tsneHandler.exportTsneWithFile(colourHandler.RGB_table_name)
tsneHandler.exportTsneWithFile(colourHandler.LAB_table_name)
tsneHandler.exportTsneWithFile(hogHandler.table_name)
tsneHandler.exportTsneWithFile("gist_tsne")
tsneHandler.exportTsneWithFile("surf_ht"+str(hessian_threshold)+"_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters))
tsneHandler.exportTsneWithFile("orb_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters))
tsneHandler.exportTsneWithFile("sift_rz"+str(resize_ratio)+"_cr"+str(crop_amount) +"_n"+str(n_clusters))
def export_urls_of_images_as_txt():
imagesHandler.main()
local_sqlite = dirm.sqlite_file
conn = sqlite3.connect(local_sqlite)
c = conn.cursor()
c.execute('SELECT fullURL FROM images')
results = c.fetchall()
print len(results)
file = open(dirm.outputDirectory + "localurl.txt", "w")
for row in results:
out = str(row[0])
file.write("%s\n" % out)
file.close()
conn.close()
def export_urls_of_images_as_txt():
imagesHandler.main()
local_sqlite = dirm.sqlite_file
conn = sqlite3.connect(local_sqlite)
c = conn.cursor()
c.execute('SELECT fullURL FROM images')
results = c.fetchall()
print len(results)
file = open(dirm.outputDirectory+"localurl.txt", "w")
for row in results:
out = str(row[0])
file.write("%s\n" % out)
file.close()
conn.close()
