def validatecolumnvaluepair(parsetree):
metadata = Metadata(parsetree.database, parsetree.table)
for pair in parsetree.columnvaluepair:
column = pair.key
if not metadata.hascolumn(column):
raise Exception("Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
logger.get_event_logger().warning(
"Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
def validatecolumns(parsetree):
if len(parsetree.columns) == 1 and parsetree.columns[0] == "*":
parsetree.columns = None
return
metadata = Metadata(parsetree.database, parsetree.table)
for column in parsetree.columns:
if not metadata.hascolumn(column):
raise Exception("Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
logger.get_event_logger().warning(
"Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
def validatedata(parsetree):
metadata = Metadata(parsetree.database, parsetree.table)
for column in parsetree.columnvaluepair.keys():
if not metadata.hascolumn(column):
raise Exception("Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
logger.get_event_logger().warning(
"Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
validator.checkdatatype(metadata, column,
parsetree.columnvaluepair[column])
validator.transformvalue(metadata, parsetree.columnvaluepair, column)
validator.validatelength(metadata, column,
parsetree.columnvaluepair[column])
def validatedata(parsetree):
metadata = Metadata(parsetree.database,parsetree.table)
actualcolumns = metadata.columns.keys()
providedcolumns = parsetree.columnvaluepair.keys()
if len(actualcolumns)!= len(providedcolumns):
raise Exception("Column count does not match with actual columns")
logger.get_event_logger().warning("Column count does not match with actual columns")
for column in parsetree.columnvaluepair.keys():
if not metadata.hascolumn(column):
raise Exception("Column '{}' does not exist in table '{}'".format(column,parsetree.table))
logger.get_event_logger().warning("Column '{}' does not exist in table '{}'".format(column,parsetree.table))
validator.checkdatatype(metadata,column,parsetree.columnvaluepair[column])
validator.transformvalue(metadata,parsetree.columnvaluepair,column)
validator.validatelength(metadata,column,parsetree.columnvaluepair[column])
def validatecondition(parsetree):
if parsetree.condition is None:
return
metadata = Metadata(parsetree.database, parsetree.table)
column = list(parsetree.condition.keys())[0]
value = parsetree.condition[column]
if not metadata.hascolumn(column):
raise Exception("Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
logger.get_event_logger().warning(
"Column '{}' does not exist in table '{}'".format(
column, parsetree.table))
checkdatatype(metadata, column, value)
transformvalue(metadata, parsetree.condition, column)
transformcomparator(parsetree)