Example #1
0
    def genTableName(self, node):
	if self.table_name != "":
	    table = util.searchTable(self.table_name)
	    if table is None and self.table_name in node.table_alias_dic.keys():
		table = util.searchTable(node.table_alias_dic[self.table_name])
	    if table is None:
		# TODO error
		return
	    print table.table_name, self.column_name
	    self.column_type = table.getColumnByName(self.column_name).column_type
	    return
	
	if self.column_name == "*":
	    return
	col_list = util.searchColumn(self.column_name)
	for col in col_list:
	    if col.table_schema.table_name in node.table_list:
		self.table_name = col.table_schema.table_name
		self.column_type = col.table_schema.getColumnByName(self.column_name).column_type
		return
	    for key in node.table_alias_dic.keys():
		if col.table_schema.table_name == self.table_alias_dic[key]:
		    self.table_name = key
		    self.column_type = col.table_schema.getColumnByName(self.column_name).column_type
		    return
Example #2
0
    def genIndex(self, node):
	new_exp = None
	if self.column_name == "*":
	    new_exp = copy.deepcopy(self)
	    return new_exp
	if self.table_name != "":
	    if self.table_name not in node.table_alias_dic.keys():
		if self.table_name not in node.table_list:
		    # TODO error
		    pass
		tmp_table = util.searchTable(self.table_name)
		if tmp_table is None:
		    return None
		index = tmp_table.getColumnIndexByName(self.column_name)
		new_exp = Column(self.table_name, index)
		new_exp.column_name = int(new_exp.column_name)
		new_exp.column_type = self.column_type
	else:
	    tmp_column = util.searchColumn(self.column_name)
	    tmp_table = None
	    for tmp in tmp_column:
		if tmp.table_schema.table_name in node.table_list or tmp.table_schema.table_name in node.table_alias_dic.values():
		    tmp_table = searchTable(tmp.table_schema.table)
		    break
	    if tmp_table is None:
		return None
	    index = tmp_table.getColumnIndexByName(self.column_name)
	    new_exp = Column(tmp.table_schema.table_name, index)
	    new_exp.column_name = int(new_exp.column_name)
	    new_exp.column_name = self.column_type
	return new_exp
Example #3
0
 def __calTrouserAbias(self,I,J,L,M,N):
     print "Int(J)"+str(int(J))
     rows = searchTable(self.table3,2,int(J))
     print "len(rows):"+str(len(rows))
     if len(rows)==1:
         locatedRow = rows[0]
     else:
         row1 = searchTable(self.table3,2,int(J)+1)[0]
         row2 = searchTable(self.table3,2,int(J)-1)[0]
         locatedRow = row1 if abs(row1[1]-I)<abs(row2[1]-I) else row2
     P_,I_,J_,L_ ,M_,N_= locatedRow[:6]
     P1 = I-I_
     P2 = J-J_
     P4 = L-L_
     P = P_
     P5 = M-M_
     P6 = N -N_
     return (P1,P2,P4,P,P5,P6)