def test_ordering_with_real_data(): """ read a patch on the server and order it""" import psycopg2 import numpy as np conn, cur = connect_to_base() gid = 906855 tot_level = 7 stop_level = 7 #print("connectin string : ", conn.dsn) connection_string = "dbname=test_pointcloud user=postgres password=postgres host=172.16.3.50 port=5432" q = """ SELECT pc_uncompress(patch) FROM acquisition_tmob_012013.riegl_pcpatch_space_proxy ORDER BY gid ASC OFFSET 100 LIMIT 1 """ arg_list = [gid] execute_querry(q, arg_list, conn, cur) patch = cur.fetchall() import rc_patch_LOD as rcp wkb_ordered_patch, pt_per_class = rcp.reordering_patch_following_midoc( patch[0][0], tot_level, stop_level, connection_string) #print("point per class : ", np.sum( pt_per_class)) conn.close() #test_ordering_with_real_data()
def test_ordering_with_real_data(): """ read a patch on the server and order it""" import psycopg2 import numpy as np conn, cur =connect_to_base() gid = 906855 tot_level = 7 stop_level = 7 #print("connectin string : ", conn.dsn) connection_string = "dbname=test_pointcloud user=postgres password=postgres host=172.16.3.50 port=5432" q = """ SELECT pc_uncompress(patch) FROM acquisition_tmob_012013.riegl_pcpatch_space_proxy ORDER BY gid ASC OFFSET 100 LIMIT 1 """ ; arg_list = [gid] ; execute_querry(q,arg_list,conn,cur) ; patch = cur.fetchall() import rc_patch_LOD as rcp wkb_ordered_patch, pt_per_class = rcp.reordering_patch_following_midoc(patch[0][0], tot_level, stop_level,connection_string) #print("point per class : ", np.sum( pt_per_class)) conn.close() #test_ordering_with_real_data()
def process_one_gid(one_gid, conn, cur, connection_string): """given one gid, process """ import rc_patch_LOD as rcp import numpy as np #get data tot_level = 8 stop_level = 6 data_dim = 3 q = """ SELECT pc_uncompress(patch) AS patch FROM acquisition_tmob_012013.riegl_pcpatch_space WHERE gid = %s """ arg_list = [one_gid.tolist()] execute_querry(q, arg_list, conn, cur) result = cur.fetchall()[0] u_patch = result[0] #process opatch, ppl = rcp.reordering_patch_following_midoc(u_patch, tot_level, stop_level, connection_string) ppl = ppl.astype('int32').tolist() opatch = u_patch q = """ UPDATE lod.dim_descr_comparison SET ( points_per_level_py) = ( %s) WHERE gid = %s; """ #arg_list = [opatch,ppl ,gid] arg_list = [ppl, one_gid] execute_querry(q, arg_list, conn, cur) return True