def nchar(size, nullable=False): if size <= 0 or size > 55: raise e.InvalidDataTypeException( "Invalid size, has to be between 1 and 55") else: if nullable: return "NCHAR({0})".format(str(size)) else: return "NCHAR({0}) NOT NULL".format(str(size))
def character(size, nullable=False): if size <= 0 or size > 20: raise e.InvalidDataTypeException( "Invalid size, has to be between 1 and 20") else: if nullable: return "CHARACTER({0})".format(str(size)) else: return "CHARACTER({0}) NOT NULL".format(str(size))
def varying_character(size, nullable=False): if size <= 0 or size > 255: raise e.InvalidDataTypeException( "Invalid size, has to be between 1 and 255") else: if nullable: return "VARYING CHAR({0})".format(str(size)) else: "VARYING CHAR({0}) NOT NULL".format(str(size))
def int(byte_size=0, nullable=False): res = "" if byte_size == 0: res = "INT" elif byte_size == 8: res = "INT" + str(byte_size) elif byte_size == 2: res = "INT" + str(byte_size) else: raise e.InvalidDataTypeException("Invalid data type") if nullable: return res else: return res + " NOT NULL"