def get_parent_node_id(cid):
if not msc.MSC.row_with_cid_exists(cid, 1):
return None
colnames = ["id", "parent_id"]
results = msc.MSC.get_collection(colnames, cid)
if msc.has_one_row(results):
return results[0][1] # get parent_id
def create_and_link_parent_node(self):
colnames = ["id", "parent_id"]
results = msc.MSC.get_collection(colnames, self.cid)
# create TreeNode object for the parent and link it to the current node
if msc.has_one_row(results):
cid, parent_id = results[0]
parent_node = TreeNode(int(parent_id))
parent_node.add_child(self)
def get_node_info_with_cid(cid, level=0):
""" result is determined by TreeNode._node_format """
if TreeNode._node_format == 1:
return "{}{}".format(" " * level, cid)
elif TreeNode._node_format == 2:
# query to get node's data
results = msc.MSC.get_collection(TreeNode.get_node_headers(), cid)
if msc.has_one_row(results):
for row in results:
cl_id, parent_id, is_category, name = row
##return "{}{} {} {} {}".format(" " * level, cl_id, parent_id, is_category, name.encode('utf-8'))
##return TreeNode.get_node_format_data( [cl_id, parent_id, is_category, name.encode('utf-8')] )
return TreeNode.get_node_format_data([cl_id, parent_id, is_category, name])
