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"