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
