Default Serialization Functions

See also

• Configuring Pre-processing and Post-processing
• Serialization Functions
• Default Deserialization Functions

SQLAthanor applies default serialization functions to pre-process your model attributes before serializing them. These default functions primarily exist to convert a SQLAlchemy Data Type into a type appropriate for the format to which you are serializing your model instance.

The table below explains how a given model attribute data type is serialized using the default serialization function for each data type. If no information is provided, that means the value is serialized “as-is”.

Data Types	CSV	JSON	YAML	dict
None	Empty string ''
int Integer INTEGER INT long oracle.LONG mssql.TINYINT mysql.TINYINT mysql.MEDIUMINT SmallInteger SMALLINT BigInteger BIGINT mssql.UNIQUEIDENTIFIER
bool Boolean BOOLEAN
str String Text TEXT mssql.NTEXT mysql.LONGTEXT VARCHAR oracle.VARCHAR2 NVARCHAR oracle.NVARCHAR2 CHAR NCHAR Unicode UnicodeText CLOB oracle.NCLOB
float Float FLOAT decimal.Decimal DECIMAL complex REAL Numeric NUMERIC mysql.DOUBLE oracle.DOUBLE_PRECISION postgresql.DOUBLE_PRECISION
datetime.date Date DATE datetime.datetime DateTime DATETIME TIMESTAMP datetime.time Time TIME mssql.SMALLDATETIME mssql.DATETIME2	ISO-8601 formatted string	ISO-8601 formatted string	ISO-8601 formatted string
mysql.YEAR
bytes	string	string	string
datetime.timedelta Interval INTERVAL	total number of seconds	total number of seconds	total number of seconds
BINARY VARBINARY LargeBinary BLOB mysql.TINYBLOB mysql.MEDIUMBLOB mysql.LONGBLOB PickleType postgresql.BYTEA		string
mssql.MONEY mssql.SMALLMONEY postgresql.MONEY
oracle.BINARY_FLOAT oracle.BINARY_DOUBLE mssql.IMAGE
oracle.BFILE oracle.RAW		string	string
Enum ENUM SET postgresql.UUID mssql.BIT postgresql.BIT postgresql.REGCLASS postgresql.OID postgresql.CIDR postgresql.INET postgresql.MACADDR mssql.XML postgresql.TSVECTOR		string	string	string
dict list JSON postgresql.JSONB postgresql.HSTORE ARRAY	UnsupportedSerializationError
set tuple	UnsupportedSerializationError	list	list
mssql.SQL_VARIANT	UnsupportedSerializationError	UnsupportedSerializationError	UnsupportedSerializationError	UnsupportedSerializationError